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 appropriate radio button from the following options:

• Phones

• UDP

Step 5

Enter data for an individual device profile 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 25: Field descriptions for adding lines to UDPs

using the BAT spreadsheet, on page 338 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 using the default name <tabname>-<timestamp>.txt to C:\XLSDataFiles\ or

you can use Browse to save your file in another existing folder on your local workstation.

What to Do Next

Upload the CSV file to Cisco Unified Communications Manager Server first node.