Adding, Changing or Deleting Users in Bulk

If you are managing a very large installation of Movable Type, chances are that you are also managing a very large number of users as well. In order to create, delete and modify many users all at once, Movable Type supports bulk management of users through a CSV file import.

The CSV file contains specific commands (e.g. create, delete, update), followed by a number of different required and optional fields. Each input row in a file represents a single user record. Each optional or required field value (empty or not) in an input row is separated by a comma. Procedures for creating files formatted to accomplish bulk user management tasks are outlined below.

Formatting a file for bulk user creation

  1. Create and save a new file on your hard drive in CSV (comma separated values) format using either Excel or a plain text editor.

  2. Starting with the command word register, type a single line for each new user you wish to create, followed by these required and optional fields, each separated by commas.

Field Example
Username jdoe
Display Name John Doe
Email Address jdoe@example.com
Language en-us
Password* abc123
Password Hint simple phrase
Weblog Name* John Doe's Blog
Weblog Description* John's personal blog
Site URL* http://www.example.com/blog/jdoe/
Site Root* /var/www/html/blog/jdoe
Time Zone* -0800

Note: Fields listed above and marked with an asterisk (*) are optional and may be left blank. However, commas should still demarcate that empty field in the string.

In CSV Format

The following is an example row in CSV format of data described in the table above:

"jdoe","John Doe","jdoe@example.com","en-us","abc123","simple phrase","John Doe's Blog","John's Personal Blog","http://www.example.com/blog/jdoe/","/var/www/html/blog/jdoe","-0800"

Formatting a file for bulk user deletion

  1. Create and save a new file on your hard drive in CSV (comma separated values) format using either Excel or a plain text editor.

  2. Type a single row for each existing user account you wish to remove from the system, starting with the command word delete, followed by a comma and the desired username. Written altogether, each input row representing a single record to be deleted would look like this: delete,jdoe

Formatting a file for bulk user editing

  1. Create and save a new file on your hard drive in CSV (comma separated values) format using either Excel or a plain text editor.

  2. Starting with the command word update, type a single row for each existing user account you wish to update, followed by these required and optional fields, each separated by commas.

Field Example
Username jdoe
New Username*  
Display Name Jonathan Doe
Email Address jdoe@example.com
Language en-us

Note: Fields listed above and marked with an asterisk (*) are optional and may be left blank. However, commas should still demarcate that empty field in the string.

Note: If you wish to handle multiple user management tasks using a single file, format each individual input row as described above. Each input row may represent a different type of task, indicated by the command word that precedes it.

In CSV Format

The following is an example row in CSV format of data described in the table above:

"jdoe","","jdoe@example.com","en-us"

Processing bulk user changes

  1. Switch to the System Overview area of Movable Type by clicking on the blog selection menu and choosing "System Overview."

  2. Click Manage > Users from the System Overview's main menu. This will open a listing of all users that exist in your system.

  3. Click the Bulk Author Import link located in the "Useful Links" section on the right of the screen.

  4. Click the Browse button to the right of the Upload CSV File field. This displays a file upload dialogue box.

  5. Locate and double-click the desired formatted CSV file to upload it.

  6. Select either a specific encoding method or Auto-detect by clicking the down arrow in the Encoding field. Auto-detect is selected by default and should determine the appropriate encoding method for you.

  7. Click the Upload button to process the file and complete the bulk user editing process. Once all users have been processed a confirmation page appears.

This page was last updated on 2007-09-14, 09:51.  

Leave a note

Have a question, please use the MT Forums. Notes sumbitted here should pertain to tips & hints regarding documentation.