User guide

where <timestamp> represents the precise date and time that the file was created.
The system saves the file with a default filename to C:\XlsDataFiles\, or you can save the file to another
existing folder on your local workstation. You can rename the CSV formatted data file after you save the
exported file to your local workstation. If you enter a comma in one of the fields, BAT.xlt encloses that field
entry in double quotes when you export to BAT format.
You cannot upload a CSV filename that contains a comma (for example, abcd,e.txt) to the Unified CM
server.
If you enter a blank row in the spreadsheet, the system treats the empty row as the end of the file. Data
that you enter after a blank line is not converted to the BAT format.
Note
Draft comment: Betz 9.1.1: Added cdet CSCuc30279 info. in time for Betz.
The Bulk Administration Tool (BAT) cannot be used to disassociate devices that are already associated to an
end user. If you manually delete a controlled device from an exported end-user record and then insert the
modified user record back in to the Cisco Unified Communications Manager database as a custom CSV data
file, the insertion appears successful when you check the job results using Bulk Administration > Job
Scheduler. However, the controlled device is still listed on the End User Configuration window in Cisco
Unified Communications Manager Administration.
Procedure
Step 1
Download and open the BAT.xlt file.
Step 2
When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
To add user information, click the Update Users tab at the bottom of the spreadsheet.
Step 4
Complete all mandatory fields and any relevant, optional fields.
Each column heading specifies the length of the field and whether it is required or optional. For field
descriptions, see Table 13: Field description in BAT spreadsheet for updating users, on page 204.
Step 5
In the Value for fields to be ignored field, enter the symbol that you will use to tell BAT that you want to
keep the value that was previously stored in the DC directory. Enter the same value in the value of the field
you want to retain.
Step 6
To transfer the data from the BAT Excel spreadsheet into a CSV file, click Export to BAT.
The system saves the file to C:\XlsDataFiles\ with the default filename Update_Users-timestamp.txt
or you can use Browse to save the file to another existing folder on your local workstation.
For information about how to read the CSV data file, click the View Sample File link in the Update Users
window in BAT.
What to Do Next
You must upload the CSV data file to the first node of the Unified CM server, so BAT can access the CSV
data file.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 203
Update user information using CSV data file
REVIEW DRAFT - CISCO CONFIDENTIAL