User guide

APPENDIX A
Text-based CSV files
Cisco Unified Communications Manager Bulk Administration (BAT) uses data that is entered in a
comma-separated values (CSV) file format to provide information for insert transactions to the Cisco Unified
Communications Manager database on the first node server. By using the CSV data format, you can build
a textual file that contains data records in a tabular format.
You can create a CSV data file by using a text editor, such as Microsoft Notepad. You must use a separate
line to enter data for each record. Separate each data field with a comma and include comma separators for
blank fields. Enter data on every line in the data file because an error occurs during the insert transaction if
you enter a blank line in a CSV file.
When you insert the data records to the Cisco Unified Communications Manager database, BAT accesses a
set of designated folders that reside on the server that is running the first node database. For BAT to access
the appropriate CSV data file for the transaction, you must upload the CSV data file to the first node database
server of Cisco Unified Communications Manager.
Cisco recommends uploading Text-Based CSV files saved in the UTF-8 format only, as characters other
than ASCII characters can be stored in this format. Text-Based CSV files saved in formats other than
UTF-8 may render garbled when downloaded from Cisco Unified Communications Manager.
Note
• Create text-based CSV file for Phones, page 586
• Create text-based CSV user file, page 590
• User file format, page 591
• Create text-based CSV file for user device profile, page 593
• Create text-based CSV file for Cisco Unified CM assistant manager-assistant associations, page 596
• Create text-based CSV file for Cisco VG200 gateways, page 598
• Create text-based CSV file for Cisco VG224 gateways, page 600
• Create text-based CSV file for Cisco Catalyst 6000 FXS ports, page 602
• Cisco Catalyst 6000 (FXS) torts file format, page 602
• Create text-based CSV file for Cisco VG202 and VG204 gateways, page 603
• Create custom text-based CSV files for Client Matter Codes and Forced Authorized Codes, page 604
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 585