Cisco OL-5385-01 - Manual (Page 2)

Chapter 4 Working with Users
Adding Users
4-2
Bulk Administration Tool User Guide
OL-5385-01
BAT can also associate CTI ports to existing users. This ability proves useful if
you are adding users who will have applications that require a CTI port, such as
Cisco IP SoftPhone. See
Adding Phones and Other IP Telephony Devices,
page 3-2 , for more information.
To add 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 or CTI port/user combination that you want to add. Cisco
recommends that you create the CSV file by using the Excel file, BAT.xlt.
2. Use BAT to insert the CSV file to add the users to the Cisco CallManager
database.
Related Topics
• Creating a CSV File for Users Using BAT.xlt, page 4-3
• Updating Users to Cisco CallManager, page 4-18
• Deleting Users from Cisco CallManager, page 4-21
Creating the CSV File for Users
To add users to Cisco CallManager, you must create a comma separated values
(CSV) file. Three ways exist to create a CSV file. You can use the export utility
to extract existing records from the directory into a CSV file. You can use the
Microsoft Excel template called BAT.xlt or create the CSV by using the sample
text file. Each CSV file type, such as phones, phones and users combined, and so
on, provides a sample text file. However, If you are creating new records, 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 to support multiple
phone lines and error checking. It exports the values into a 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.