User guide

Procedure

Step 1

To open the BAT spreadsheet, locate and double-click BAT.xlt file.

Step 2

When prompted, click Enable Macros to use the spreadsheet capabilities.

Step 3

To add users, click the Users tab at the bottom of the spreadsheet.

Step 4

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.

In each row, provide the information as described in Table 11: Field description in BAT Spreadsheet for

adding users, on page 187.

• If a user has multiple devices, the device name field should be repeated, once for each device.

• To enter additional device names that will be associated to a new user, enter a value in the Number of

Controlled Devices text box.

You can associate all devices, including CTI ports, ATA ports, and H.323 clients, with a

user.

Note

Step 5

To enter additional device names that will be associated to a new user, enter a value in the Number of

Controlled Devices text box.

Step 6

Click Export to BAT Format to transfer the data from the BAT Excel spreadsheet into a CSV formatted

data file.

The system saves the file to C:\XLSDataFiles with the default file name <tabname>-<timestamp>.txt , or use

Browse to save the file to another existing folder.

For information on how to read the exported CSV data file, click the link to View Sample File in the

Insert Users window in BAT.

Tip

What to Do Next

You must upload the CSV data file to the first node of Cisco Unified Communications Manager database

server so that BAT can access the data file.