Cisco OL-5385-01 - Manual (Page 3)

4-3
Bulk Administration Tool User Guide
OL-5385-01
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.