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

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