BAT supports only UTF-8 and UTF-16 character set encoding for
the text in the CSV file.
To quickly construct an input CSV file, you can use BAT to
export the applicable type of user, contact, system distribution list, system
distribution list members, unified messaging accounts, or video service
accounts, and use the resulting output CSV file as a template.
The following example shows a CSV file for creating voicemail
users. To construct the file as shown in the example, you need to first export
the voicemail users to a CSV file, remove the unwanted columns and data from
the file, and then add the TemplateAlias column and the applicable data.
Note
|
The DisplayName is an optional field and the data for this field
is missing for several users.
|
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
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
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.