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

Page 15

Chapter 4 Working with Users

Updating Users

Using a floppy disk or a mapped network drive, copy the CSV file from C:\XLSDataFiles\ to the C:\BATFiles\Users\Update 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 Updating Users

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

If you created the CSV file by using the BAT.xlt file, you can skip the following procedure in this section.

Tips Use BAT.xlt to input data because data validation is performed on that file.

The CSV file provides a common textual way of providing tabular information. You can create a data file by using any file format, such as Microsoft Notepad, Microsoft Word, and so on. Save the CSV file to C:\BATFiles\Users\Update Users\on the server that is running the publisher database for Cisco CallManager.

Use this procedure to create a CSV text file for users.

Procedure

Step 1 Open a text editor (such as Microsoft Notepad) or any application that allows you to export or create a CSV file.

Step 2 Using a separate line for each update to the user, enter the values for each user attribute that you want to add to Cisco CallManager. See Tips for Creating a Text-Based CSV File, page 4-7, for detailed information about the formatting that you must use in the text-based CSV file.

Note Do not leave blank rows in the spreadsheet. You will receive an error message.

 

 

Bulk Administration Tool User Guide

 

 

 

 

 

 

OL-5385-01

 

 

4-15

 

 

 

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