Cisco Systems OL-5385-01 manual Creating a Text-Based CSV File for Users

Page 5

Chapter 4 Working with Users

Adding Users

Note Do not specify new phones, CTI ports, or phones that were added using BAT with the “BAT” prefix (meaning, they have not been updated in the Cisco CallManager database with the MAC address yet) in this field.

In the Directory Number field, enter the directory number for the primary extension (usually Line 1) for the phone, up to 50 numerals.

In the Controlled Device MAC Address2 field, enter the MAC address for any additional phone that you want to associate with this user, 12 characters.

Step 6 Click the Add More Devices button to enter additional MAC addresses that will be associated to a new user.

Step 7 Click Export to BAT Format button to transfer the data from the BAT Excel spreadsheet into a CSV file.

The system saves the file to C:\XLSDataFiles\ (or to your choice of another existing folder) as

users#timestamp.txt (or to your choice of filename)

where “timestamp” represents the precise date and time that the file was created.

Step 8 To be accessed by BAT, the CSV file must reside on the publisher database server. However, you normally would not have Microsoft Excel running on the publisher database server. This step assumes that you have saved the CSV file to the local machine (not the publisher database server). In that case, you must copy the file to publisher database server.

Using a floppy disk or a mapped network drive, copy the CSV file from C:\XLSDataFiles\ to the C:\BATFiles\Users folder on the server that is running the publisher database for Cisco CallManager.

For information on how to read the exported CSV file, click the link to View

Sample File in the Insert Users window in BAT (Configure > Users).

Creating a Text-Based CSV File for Users

If you do not use the BAT.xlt file for data input when adding users, you must create the comma separated values (CSV) file by using lines of ASCII text with values separated by commas.

 

 

Bulk Administration Tool User Guide

 

 

 

 

 

 

OL-5385-01

 

 

4-5

 

 

 

Image 5
Contents Adding Users Working with UsersRelated Topics Creating the CSV File for UsersProcedure Creating a CSV File for Users Using BAT.xltWorking with Users Adding Users Creating a Text-Based CSV File for Users Procedure Example Tips for Creating a Text-Based CSV FileBefore You Begin Adding Users to Cisco CallManagerChoose Configure Users Working with Users Adding Users Click Insert Creating the CSV File for Updating Users 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