User guide

Step 7
Enter CMC or FAC settings in the columns.
See Table 37: Configuration settings for CMC and FAC, on page 429 for descriptions of configuration settings.
Repeat Step 7, on page 428 until you enter all
codes.
Note
Step 8
To transfer the Excel spreadsheet format to a CSV file, click Export to BAT Format.
The system automatically saves CSV files to C:\XlsDatafiles on the local machine.
Click Browse to choose a different
location.
Tip
What to Do Next
Upload the CSV files to the first node of the Cisco Unified Communications Manager server.
You must add the CSV file to BAT and insert the file to update the Cisco Unified Communications Manager
database.
Related Topics
Download file off server, on page 18
Topics related to CMC and FAC configuration, on page 431
Update CMC or FAC in CUCM database using BAT, on page 430
Upload file to server, on page 19
CSV data file creation for Client Matter Codes and Forced Authorization Codes
using text editor
You can use a text editor to create the text-based CSV data file for client matter codes and forced authorization
codes. The comma separated values (CSV) file provides textual information in tabular form and contains lines
of ASCII text with values separated by commas.
Related Topics
Create custom text-based CSV files for Client Matter Codes and Forced Authorized Codes, on page 604
Topics related to CMC and FAC configuration, on page 431
Edit existing CMC or FAC CSV data file
You update existing codes by manually updating an existing CSV file or creating a new CSV file using a text
editor.
If you are updating a CMC CSV file, for example, you may enter 5555,Acme Toys, where 5555 equals the
mandatory client matter code, and Acme Toys equals the description.
If you are updating a FAC CSV file, for example, you may enter 1234,John Smith,20, where 1234 equals the
forced authorization code, John Smith equals the authorization code name, and 20 equals the authorization
level.
You can change any part of an existing record, but you must include the code; for example, the forced
authorization code or client matter code. Deleting information and leaving it blank does not remove the
information from the database; a blank value does not overwrite an existing value in the database, but, updating
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
428 OL-28580-01
CSV data file creation for Client Matter Codes and Forced Authorization Codes using text editor
REVIEW DRAFT - CISCO CONFIDENTIAL