User guide

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 fields, click the Add Lines tab at the bottom of the spreadsheet.
Step 4
Select the Phones radio button to add lines to a phone.
You can choose to add lines to a User Device Profile by selecting the User Device Profile radio
button.
Note
Step 5
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 9: Field descriptions for adding lines using the BAT
spreadsheet, on page 159 for field descriptions.
Step 6
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 to C:\XLSDataFiles\ with the default filename <tabname>-<timestamp>.txt,
or you can use Browse to save the file to another existing folder on your local workstation.
What to Do Next
Upload the file to the Cisco Unified Communications Manager server.
Related Topics
BAT spreadsheet data collection for CSV data file creation, on page 10
Upload and download files, on page 17
Upload file to server, on page 19
Phone line field descriptions for line additions using BAT spreadsheet
The following table provides the field descriptions when you add lines using the BAT spreadsheet.
Table 9: Field descriptions for adding lines using the BAT spreadsheet
DescriptionField
Enter the MAC address for phones, VGC virtual phones, and VGC phones.
Enter a unique identifier for CTI ports and H.323 clients.
MAC Address
Enter a number between 1 and 34 for the line index of a phone.Line Index
Enter a directory number, up to 24 numerals and special characters, for
this line.
Directory Number
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 159
Phone line field descriptions for line additions using BAT spreadsheet
REVIEW DRAFT - CISCO CONFIDENTIAL