/mcpThe DisplayName is an optional field and the data for this field is missing for several users. Note Example CSV Input File for Creating Voicemail 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 edit 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 in BAT, on page 301 section to construct a valid input CSV file for use with the BAT: • The first row in the CSV file must contain column headings that identify the type of data in each column and the information in the subsequent rows must contain the data that you want to import. • Ensure that commas separate the data in each row in the CSV file, including the column headings in the first row. Do not use a tab, spaces, or a semicolon to separate values in the file. • Although the data must be arranged in the same order as the column heading, the order in which you arrange the columns is not important. • If the CSV file includes a column that you want BAT to ignore, use the column heading “Junk.” • If any data includes a space, quotes, or commas, specify it within quotes. The data in the CSV file should 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””. • Column headings are not case sensitive, but they must be spelled as indicated in the tables in the Required and Optional CSV Fields in BAT, on page 301 section. Columns that are designated not applicable (N/A) for an operation are ignored. • (Applicable only to Unity Connection configurations) For creating user accounts, most optional fields that are listed in the CSV field tables correspond to settings defined in a user template. For example, for voicemail users, the default template includes class of service (COS), call transfer, and message notification settings. When data for a particular user setting is not included in the CSV file, BAT uses settings in the user template that you specify in the required field TemplateAlias. For this reason, you should review the settings in the user template that you use to create the accounts before adding any of the optional column headers to your CSV file. If a value for an optional field is not included in the CSV file and if the template does not specify a default value, then the value for the field is not set. If you specify an administrator template for TemplateAlias, the users do not have mailboxes • To explicitly set the value of a field to empty (or to null, if allowed), use the expression %null% for the value in the CSV file. • You should not include more than 5,000 records in an input CSV file. System Administration Guide 266 Tools Constructing Input CSV Files