User guide

CSV data file adds new devices
When you are adding new devices to the system, you can use the Microsoft Excel spreadsheet that was designed
to use with BAT. The BAT spreadsheet assists you with the following features:
• Data file templates with macros for the different devices
• Customized file format definition
• Support for multiple phone lines
• Record error checking
• File conversion to CSV format
When you are creating new records, use the BAT spreadsheet, which is named BAT.xlt, because the data gets
validated automatically when you export to the CSV format.
BAT.xlt validates data only for valid characters, data types, and field length for particular fields.Note
For experienced BAT users who are comfortable with working in a CSV formatted file, you can use a text
editor to create a CSV data file by following the sample text file that is provided on the device insert task
window.
Related Topics
BAT spreadsheet data collection for CSV data file creation, on page 10
Validate CSV data file phone records, on page 111
Text-based CSV files, on page 585
CSV data file updates existing devices
To modify or update existing phones and devices, you need to locate the records for these devices. BAT
provides two methods for locating phones, gateways, and device profiles. You can search by using a customized
query or by using a custom file.
You can also extract a group of phone records from the Cisco Unified Communications Manager database
for inclusion in a CSV data file using the export utility.
Customized query searches
BAT provides a window for defining your query criteria. You can choose the specific device model and/or
choose criteria from a list of device details and a list of line details. To locate all devices of a specific device
model, such as Cisco IP Phone 7912, you choose the model but add no other criteria for the search. You get
the records for all the Cisco Unified IP Phones 7912 that are configured in the database.
Custom file searches
When no common attribute to use for a query exists, BAT provides the custom file option. A custom file
includes device names or directory numbers. You can build a custom text file by putting each record on a
separate line. The search gives you all the records that match the criteria.
Export phone records to CSV data file
When you need to move a group of phones, you can use the export utility. You use the export utility to extract
existing records from the Cisco Unified Communications Manager database to move them into a CSV data
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
8 OL-28580-01
Perform BAT configuration multistep process
REVIEW DRAFT - CISCO CONFIDENTIAL