Cisco Systems OL-5385-01 manual Creating a CSV File for Updating Users Using BAT.xlt, Procedure

Page 13

Chapter 4 Working with Users

Updating Users

For instructions on creating the CSV file, see

Creating a CSV File for Updating Users Using BAT.xlt, page 4-13(recommended method)

Creating a Text-Based CSV File for Updating Users, page 4-15

Creating a CSV File for Updating Users Using BAT.xlt

Use this procedure to create the CSV file for bulk-updating users. BAT uses the information that you provide here to update users to the Cisco CallManager database.

Procedure

Step 1 The BAT.xlt file resides on the publisher database server. If you do not have Microsoft Excel installed on the publisher database server, you must copy the file from the publisher database server and move it to a local machine with Microsoft Excel installed.

Using a floppy disk or a mapped network drive, open the path C:\CiscoWebs\BAT\ExcelTemplate on the publisher database server and copy the file BAT.xlt to a local machine where Microsoft Excel is installed.

Step 2 Double-click BAT.xlt.

Step 3 When prompted, click the Enable Macros button.

Step 4 Click the Update Users tab.

Step 5 Complete all mandatory fields and any relevant optional fields. Each column heading specifies the length of the field and whether it is required or optional.

Caution The system treats blank rows in the spreadsheet as “End of File” and discards subsequent records.

In each row, provide the following information:

In the UserID field, enter the user ID of the user whose profile you are updating. This mandatory entry can contain as many as 30 characters.

In the Manager field, enter the user ID of the manager of whose profile you are updating. This optional field can contain as many as 30 characters.

 

 

Bulk Administration Tool User Guide

 

 

 

 

 

 

OL-5385-01

 

 

4-13

 

 

 

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