User guide

You can rearrange the order of the device attribute fields and line attribute fields in the file format by using
the Up and Down arrows. You can select an attribute and then click the Up arrow to move the item closer to
the first record or click the down arrow to move the item further away from the first record. You cannot move
line attributes before device attributes or change the order of speed dials.
You can customize a CSV file format, so it matches the arrangement of your employee phone information
that is stored in another database. This method simplifies exporting data between a company database and
the Cisco Unified Communications Manager database.
Tip
Sample CSV data file with the customized file format:
Device fields—MAC Address, Description, Device Pool, Calling Search Space
Line fields—Directory number, Partition, Line Text Label (moved to position after directory number in file)
The File Format does not include speed-dial codes. Choose speed-dials by selecting the Include Speed Dials
in the CSV Format check box.
MAC ADDRESS,DESCRIPTION,DEVICE POOL,CSS,DIRECTORY NUMBER,LINE TEXT LABEL,
PARTITION,2234900AEF01,SEP2234900AEF01,DP_1,CSS_Restricted,
9725098827,Lobby Phone,Part1
Associate custom file format with CSV data file
When you are using a text editor to create a CSV data file, you can create a customized file format and then
enter values in the same order as specified by that file format. Before inserting the text-based CSV data file
that uses the customized file format, you must associate the file format name with the CSV data file. You can
associate only one file format with a CSV data file.
Procedure
Step 1
In the Add File Format window, choose the name of the CSV data file <CSVfilename>.txt from the File
Name drop-down list.
Step 2
Choose a file format from the File Format Name drop-down list.
The data in the CSV data file must match the custom file format that is chosen.
BAT spreadsheet data collection for CSV data file creation
The BAT spreadsheet simplifies the creation of CSV data files. You can add multiple devices and view the
records for each device in a spreadsheet format. It allows you to customize the file format within the spreadsheet
and provides validation and error checking automatically to help reduce configuration errors. The BAT
spreadsheet includes tabs along the bottom of the spreadsheet for access to the required data input fields for
the various devices and user combinations in BAT.
BAT.xlt validates data only for valid characters, data types, and field length for particular fields.Note
The CSV data file works in combination with the BAT template. For example, when you choose the Phone
tab in the BAT spreadsheet, you can leave Location, Forward Busy Destination, or Call Pickup Group blank.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
10 OL-28580-01
Perform BAT configuration multistep process
REVIEW DRAFT - CISCO CONFIDENTIAL