User guide

Remember that you must create two separate CSV files, one for CMC and one for
FAC.
Tip
Step 3
To create a CMC CSV file, enter the corresponding information, where x, y represent the following fields:
x—The client matter code (mandatory entry for all additions, updates, and deletions)
y—The description (optional if you update the entry)
For example, you may enter 5555,Acme Toys, where 5555 equals the mandatory client matter code, and Acme
Toys equals the description.
Step 4
To create a FAC CSV file, enter the corresponding information, where x,y,z represent the following fields:
x—The forced authorization code (mandatory entry for all additions, updates, and deletions)
y—The authorization code name (optional if you update the entry)
z—The authorization level (optional if you update the entry)
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.
If you add new codes at the same time that you update them, make sure that you enter all required
information. 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 the value, for example, to Acme Toys, Inc., or John
L. Smith from the preceding examples, overwrites the existing value in the database.
Caution
Step 5
Upload the CSV file to the first node of Cisco Unified Communications Manager.
While saving your CSV file, choose to save it as UTF-8 encoded. In Notepad, you can select encoding as
UTF-8 from the Encoding dropdown.
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
Step 6
Perform one of the following tasks:
If you made additions or updates, insert the file in the CUCM database using BAT.
You can delete code settings.
You cannot perform insert and update operations simultaneously with the same CSV file. You have
to create separate CSV files for insert and update.
Note
Related Topics
Code setting deletion examples, on page 433
Related Topics, on page 618
Update CMC or FAC in CUCM database using BAT, on page 430
Upload file to server, on page 19
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 605
Text-based CSV files
Create custom text-based CSV files for Client Matter Codes and Forced Authorized Codes
REVIEW DRAFT - CISCO CONFIDENTIAL