User guide

file. When you move phones, use the option, Export Phones with the All Phone Details. This option generates
an export file that contains records with all the information, including the device attributes, line attributes,
and services, that is associated with that phone. You can also export phone records with specific details when
phones have similar line configurations and you want to use a template.
Related Topics
Exported phone record fields, on page 144
CSV data file and custom file formats
CSV data files comprise a string of device attributes and information in a comma separated value (CSV)
format. To insert data records into the Cisco Unified Communications Manager database, ensure that each
data file is in the CSV format. In earlier releases of BAT, the CSV file had a fixed format with two options:
• Default format—CSV files that have a fixed and limited number of attributes and settings for each
device.
• All details format—CSV files that are created by using the export utility and include all attributes and
settings for each device.
The first row of every CSV data file shows the file format by displaying the name of each field that the CSV
file includes. The file format information makes it easier to locate the entry for a specific field in the CSV
data file. For instance, in the following sample CSV file, USER ID represents the fourth field in the header,
and the fifth field in the CSV file for the phone shows “johns.”
To blank out a field, type "NULL" (without quotations) in the field. Do not leave the field blank.Note
Sample CSV data file with the default file format:
MAC ADDRESS,DESCRIPTION,LOCATION,USER ID,DIRECTORY NUMBER 1,DISPLAY 1,LINE TEXT LABEL
1,FORWARD BUSY EXTERNAL 1,FORWARD NO ANSWER EXTERNAL 1,FORWARD NO COVERAGE EXTERNAL 1,FORWARD
BUSY INTERNAL 1,FORWARD NO ANSWER INTERNAL 1,FORWARD NO COVERAGE INTERNAL 1,CALL PICKUP
GROUP 1,SPEED DIAL NUMBER 1,SPEED DIAL LABEL 1,
1231123245AB,SEP1231123245AB,Dallas,Johns,9728437154,9728437154,Mike,9728437172,9728437196,
9728437127,9728437154,9728437178,9728437189,9728437121/TollByPass,1230000000,Helpdesk,
9728437127,9728437154,9728437178,9728437189,Marketing,1230000000,Helpdesk
Now, you can customize the file format for the CSV data file by using the Create Phone File Format
Configuration window. You can add attributes to your file format that are also in the BAT template. This
allows you to override the template entry with a specific attribute for a device. For instance, you can choose
the route partition attribute for your file format and enter different partitions for each phone in the CSV data
file.
From this window, you can choose specific attributes from Device fields and Line fields
The following device attributes always remain in each file format:
• MAC Address
• Description
The File Format Configuration dialog box makes it easy to choose the device attribute in the Device Field
box and click an arrow to move the attribute into the Selected Device Field box. You can select multiple
attributes at the same time by holding down the Ctrl key.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 9
Perform BAT configuration multistep process
REVIEW DRAFT - CISCO CONFIDENTIAL