Constructing the Input CSV Files

To quickly construct an input CSV file, you can use Bulk Administration Manager to export the applicable type of user or contact, and use the resulting output CSV file as a template.

The following example shows a CSV file for creating voice mail users. To construct the file, voice mail users were exported to a CSV file. Then, unwanted columns and data were removed from the file. Finally, the TemplateAlias column and the applicable data were added. (Note that the data for DisplayName-an optional field-is missing for several users.)

Example CVS Input File for Creating Voice Mail Users
Alias,DisplayName,FirstName,LastName,TemplateAlias,Extension,ListInDirectory
iwinkler,"Winkler, Ian",Ian,Winkler,VoiceMailUserTemplate,5321,1
jsmith,,John,Smith,VoiceMailUserTemplate,5126,1
cjones,"Jones, Cris",Cris,Jones,VoiceMailUserTemplate,5249,1
dalbert,,Dan,Albert,VoiceMailUserTemplate,5299,1
jlee,"Lee, Jane",Jane,Lee,VoiceMailUserTemplate,5324,1
jthompson,"Thompson, Jim",Jim,Thompson,VoiceMailUserTemplate,5029,1
swong,"Wong, Sara",Sara,Wong,VoiceMailUserTemplate,5260,1
rhunter,"Hunter, Russ",Russ,Hunter,VoiceMailUserTemplate,5229,1
cashmore,,Carol,Ashmore,VoiceMailUserTemplate,5403,1
lcarson,"Carson, Lauren",Lauren,Carson,VoiceMailUserTemplate,5999,1

 

Whether you modify an output CSV file or create a CSV file from scratch, use the following guidelines, along with the tables in the "Required and Optional CSV Fields for Use with Bulk Administration Manager" section to construct a valid input CSV file for use with the Bulk Administration Manager:

We highly recommend that your data not include double-quotes because it can cause problems with interactions with external servers. If the data does include double-quotes, place an additional double-quote next to each double-quote. For example, if the data is My "Spare Phone", the entry must be My ""Spare Phone"".

Required and Optional CSV Fields for Use with Bulk Administration Manager

The tables in this section list the required and optional fields to include in input CSV files for creating, updating, and deleting users with and without voice mail, and system contacts. The fields are listed in alphabetical order, except for the required fields, which are listed first.

Use the applicable table, depending on the type of object: