User guide

If you enter a comma in one of the fields, BAT.xlt encloses that field entry in double quotes when you

export to BAT format.

If you enter a blank row in the spreadsheet, the system treats the empty row as the end of the file. The

system does not convert data that is entered after a blank line to the BAT format.

Note

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

Click the Phone Migration tab.

Step 4

In each row, provide the information for the following fields:

• Old Device Name—Enter the name of the phone that you are migrating, from 1 to 50 characters that

identifies the old device. This field is mandatory.

• New Device MAC Address—Enter the MAC address of the new Device, 12 characters. This is a

mandatory field.

• Description—Enter a description, up to 50 characters. This is an optional field. The description can

include up to 50 characters in any language, but it cannot include double-quotes ("), percentage sign

(%), ampersand (&), back-slash (\), or angle brackets (<>).

Step 5

To transfer the data from the BAT Excel spreadsheet into a CSV file, click Export to BAT Format.

The system saves the file using the default filename PhoneMigration#timestamp.txt to C:\XLSDataFiles

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

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

the Phone Migration Configuration window in BAT.

Note

What to Do Next

Upload the CSV data file to the first node of the Cisco Unified Communications Manager server so BAT can

access the data input file.