User guide

You can change the order of the items in the Selected Line and Device boxes. Choose an item and

use the up arrow to move the field closer to the beginning of the list or chose the down arrow to move

the item to the end of the list.

Tip

Step 7

To modify the CSV data file format, click Create. A message asks whether you want to overwrite the existing

CSV format. Click OK.

New columns for the selected fields display in the BAT spreadsheet in the order that you specified.

Step 8

To locate the Number of Phone Lines box, scroll to the right.

The number of lines that you specify here must not exceed the number of lines that are configured in the BAT

template or an error will result when you insert the CSV data file and UDP template.

Step 9

You must enter the number of speed-dial buttons in the Number of Speed Dials box. After you enter the

number, columns display for each speed-dial number.

Do not exceed the number of speed dials that are configured in the User Device Profile template, or

an error will result when you insert the CSV data file and UDP template.

Note

Step 10

Enter data for an individual user 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 20:

Field descriptions for user device profile in the BAT spreadsheet, on page 283 for field descriptions.

Step 11

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

Format.

The system saves the file using the default filename <tabname>-<timestamp>.txt to C:\XLSDataFiles\

or to your choice of 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 Insert User Device Profiles window in BAT.

Note

What to Do Next

Upload the CSV file to Cisco Unified Communications Manager server.