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

4-5
Bulk Administration Tool User Guide
OL-5385-01
Chapter 4 Working with Users
Adding Users
Note Do not specify new phones, CTI ports, or phones that were added
using BAT with the “BAT” prefix (meaning, they have not been
updated in the Cisco CallManager database with the MAC address
yet) in this field.
• In the Directory Number field, enter the directory number for the primary
extension (usually Line 1) for the phone, up to 50 numerals.
• In the Controlled Device MAC Address2 field, enter the MAC address for any
additional phone that you want to associate with this user, 12 characters.
Step 6 Click the Add More Devices button to enter additional MAC addresses that will
be associated to a new user.
Step 7 Click Export to BAT Format button to transfer the data from the BAT Excel
spreadsheet into a CSV file.
The system saves the file to C:\XLSDataFiles\ (or to your choice of another
existing folder) as
users#timestamp.txt (or to your choice of filename)
where “timestamp” represents the precise date and time that the file was created.
Step 8 To be accessed by BAT, the CSV file must reside on the publisher database server.
However, you normally would not have Microsoft Excel running on the publisher
database server. This step assumes that you have saved the CSV file to the local
machine (not the publisher database server). In that case, you must copy the file
to publisher database server.
Using a floppy disk or a mapped network drive, copy the CSV file from
C:\XLSDataFiles\ to the C:\BATFiles\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 Users
If you do not use the BAT.xlt file for data input when adding users, you must
create the comma separated values (CSV) file by using lines of ASCII text with
values separated by commas.