Updating users, Creating the csv file for updating users – Cisco OL-5385-01 User Manual
Page 12
 
Chapter 4 Working with Users
Updating Users
4-12
Bulk Administration Tool User Guide
OL-5385-01
Updating Users
You can use BAT to update user information to the Cisco CallManager 
database/Lightweight Directory Access Protocol (LDAP) Directory in batches, 
rather than individually.
To update users to the Cisco CallManager database/LDAP Directory in bulk, you 
must perform these steps:
1.
Create a comma separated values (CSV) file to define individual values for 
each user that you want to update. Cisco recommends that you create the CSV 
file by using the Excel file, BAT.xlt.
2.
Use BAT to insert the CSV file to update users to the Cisco CallManager 
database.
Related Topics
•
Creating the CSV File for Updating Users, page 4-12
•
Updating Users to Cisco CallManager, page 4-18
•
Adding Users to Cisco CallManager, page 4-8
•
Deleting Users from Cisco CallManager, page 4-21
Creating the CSV File for Updating Users
To update users to Cisco CallManager, you must create a comma separated values 
(CSV) file. You can create a CSV file two ways. You can use the Microsoft Excel 
template called BAT.xlt or create the CSV by using a program like Notepad or 
Microsoft Word, by using the sample text file and the following instructions as 
reference. Each CSV file type, such as phones, phones and users combined, and 
so on, provides a sample text file. However, Cisco recommends that you use the 
BAT.xlt template because the data is validated automatically when you export to 
CSV format.
The BAT.xlt file provides data file templates with macros, support for multiple 
phone lines, error checking, and exports the values into CSV files for phones, 
users, CTI ports, phone/user combinations, CTI port/user combinations, Cisco 
VG200 gateways, and FXS ports on Cisco Catalyst 6000 analog interface 
modules.