User guide

c) Click a line field name in the Line Field box and click the arrow to move the field to the Selected Line
Fields box.
To change the order of the items in the Selected Line and Device boxes, choose an item and use
the up and down arrows to move the field up or down in the list.
Tip
d) A message asks whether you want to overwrite the existing CSV format. Click Create to modify the CSV
data file format.
e) Click OK.
New columns for the selected fields display in the BAT spreadsheet in the order that you specified.
Step 6
Scroll to the right to locate the Number of Phone Lines box and enter the number of lines for the phone.
The number of lines you enter must not exceed the number of lines that are configured in the BAT template.
Step 7
For phones, you must enter the number of speed-dial buttons in the Maximum Number of Speed Dials box.
The number of speed dials you enter must not exceed the number of speed dials that are configured in the
BAT template.
After you enter the number, columns display for each speed-dial number.
Step 8
Enter the number of Busy Lamp Field (BLF) speed-dial buttons in the Maximum Number of BLF Speed
Dials box.
After you enter the number, columns display for each BLF speed-dial number.
Step 9
Enter data for an individual phone on each line in the spreadsheet.
Complete all mandatory fields and any relevant, optional fields. Each column heading specifies the length of
the field and whether it is required or optional. See Table 4: Phone field descriptions for the BAT spreadsheet,
on page 81 for phone field descriptions.
Step 10
If you did not enter the MAC address for each phone, check the Create Dummy MAC Address check box.
Do not use the dummy MAC address option for H.323 clients, VGC phones, or VGC virtual
phones.
Attention
Step 11
To transfer the data from the BAT Excel spreadsheet into a CSV formatted data file, click Export to BAT
Format.
For information on how to read the exported CSV data file, click the link to View Sample File in the
Insert phones window in BAT.
Tip
The system saves the file with the default filename: <tabname>-<timestamp>.txt to your choice of a folder
on your local workstation.
What to Do Next
You must upload the CSV data file to the Cisco Unified Communications Manager first node database server
so BAT can access the CSV data file.
Related Topics
BAT spreadsheet data collection for CSV data file creation, on page 10
TAPS overview, on page 545
Upload and download files, on page 17
Phone field descriptions in BAT spreadsheet
The following table provides descriptions of the phone fields that are available for adding device and line
details in a CSV data file.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
80 OL-28580-01
BAT phone templates
REVIEW DRAFT - CISCO CONFIDENTIAL