Cisco Systems OL-5385-01 manual Creating the CSV File for Users, Related Topics

Page 2

Chapter 4 Working with Users

Adding Users

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.

 

Bulk Administration Tool User Guide

4-2

OL-5385-01

Image 2
Contents Working with Users Adding UsersCreating the CSV File for Users Related TopicsCreating a CSV File for Users Using BAT.xlt ProcedureWorking with Users Adding Users Creating a Text-Based CSV File for Users Procedure Tips for Creating a Text-Based CSV File ExampleAdding Users to Cisco CallManager Before You BeginChoose Configure Users Working with Users Adding Users Click Insert Updating Users Creating the CSV File for Updating UsersCreating a CSV File for Updating Users Using BAT.xlt Userid,#,department,,,123456789012 Creating a Text-Based CSV File for Updating Users Tips for Creating a Text-Based CSV File Retaining Stored Values Updating Users to Cisco CallManager Working with Users Updating Users Deleting Users Deleting Users from Cisco CallManager Related Topics