User guide

Next, you must upload the converted CSV data file (CSV format version) back to the Cisco Unified

Communications Manager database server by using Upload/Download Files option in the Bulk Administration

of Cisco Unified Communications Manager Administration.

Related Topics

Upload and download files, on page 17

Validate CSV data file phone records, on page 111

Validate BAT data input file

The system runs a validation routine to check for errors in the CSV data file and the BAT template against

the first node database. These checks include the following items:

• Fields, such as description, display text, and speed-dial label that do not have a dependency on a database

table, use valid characters.

• BAT Validate transaction only validates data type, length and relational dependency.

Consider the following example:

MAC ADDRESS,DESCRIPTION,PARTITION

AABBCC112233,Lab Phone,Dallas

If the Partition does not exist, Validate displays an error saying “Dallas is not an existing PARTITION.”

• Number of lines that are configured on a device matches the device template. (Only for Specific Details)

Validation does not check for the existence of a user or for mandatory/optional fields that are BAT defined,

such as the dummy MAC address.

Procedure

Step 1

Select the Validate File option and choose the name of the CSV data input file, the BAT template for the

device, and the model, if applicable.

The CSV data file should contain all details.

Step 2

Select the validation method.

a) Choose Specific Details for validating records that follow the Default or Custom file format.

b) Choose All Details for validating records from a file that was generated from the export utility using the

All Details option.

After the transaction completes, click the Log File Name link in the Job configuration window to see a log

file that displays the devices that could not be validated successfully and the error code.