Cisco Systems OL-5385-01 manual Creating the CSV File for Updating Users

Page 12

Chapter 4 Working with Users

Updating Users

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.

 

Bulk Administration Tool User Guide

4-12

OL-5385-01

Image 12
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