User guide

The number of lines and speed dials that you define for phones in the BAT spreadsheet must not exceed
the numbers that are defined in the BAT phone template, otherwise, an error occurs when you attempt to
insert the CSV data file and BAT template.
Attention
After you have finished editing all the fields in the BAT spreadsheet, you can export the content to a CSV
formatted data file. A default filename is assigned to the exported CSV formatted data file:
<tabname>-<timestamp>.txt
where <tabname> represents the type of input file that you created, such as phones, and <timestamp> represents
the precise date and time that the file was created.
You can rename the CSV formatted data file after you save the exported file to your local workstation.
You cannot upload a CSV filename that contains a comma (for example, abcd,e.txt) to the Cisco Unified
Communications Manager server.
Note
Procedure
Step 1
To open the BAT spreadsheet, locate and double-click the BAT.xlt file
Step 2
When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
To display the phones options, click the Phones tab at the bottom of the spreadsheet.
Step 4
Choose the radio button for one of the following device types:
The device type that you select determines the validation criteria for data in the BAT spreadsheet.
• Phones
• CTI Port
• H.323 Client
• VGC Phones
• VGC Virtual Phones
• Cisco IP Communicator Phone
The spreadsheet displays options that are available for the chosen device. For example, when you choose
phones, fields for the number of phone lines and the number of speed dials display.
Step 5
Choose the device and line fields to appear in the BAT spreadsheet for each phone. Do the following:
a) Click Create File Format.
The Field Selection popup window displays.
b) To choose the device fields, click a device field name in the Device Field box and then click the arrow to
move the field to the Selected Device Fields box.
A CSV data file must include MAC Address/Device Name and Description; therefore, these fields always
remain selected.
To select a range of items in the list, hold down the Shift key. To select random field names, hold
down the Ctrl key and click field names.
Tip
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 79
BAT phone templates
REVIEW DRAFT - CISCO CONFIDENTIAL