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

Page 3

Chapter 4 Working with Users

Adding Users

For instructions on creating the CSV file, see

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

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

Creating a CSV File for Users Using BAT.xlt

Follow this procedure to create the CSV file for bulk-adding users. BAT uses the information that you provide here to add the users to the Cisco CallManager database.

Procedure

Step 1 The BAT.xlt file resides on the publisher database server. However, you normally would not have Microsoft Excel installed on the publisher database server. In that case, you must copy the file from the publisher database server and move it to the local machine, which must have 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 Users tab at the bottom of the spreadsheet to add users.

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. If you have multiple devices, several fields will appear multiple times, once for each device.

In the First Name field, enter the first name of the user to whom this phone will be issued, up to 50 characters.

 

 

Bulk Administration Tool User Guide

 

 

 

 

 

 

OL-5385-01

 

 

4-3

 

 

 

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