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

Chapter 4 Working with Users
Updating Users
4-14
Bulk Administration Tool User Guide
OL-5385-01
• In the Department field, enter the department number for the user whose
profile you are updating. This optional field can contain as many as 50
characters.
• In the User Device Profile field, enter the user device profile for this user and
device. This optional field can contain as many as 50 characters. The User
Device Profile must exist in Cisco CallManager Administration for the
Cisco CallManager database to accept this record.
• In the User Locale field, enter the language and country that you want to
associate with this user. Your choice determines which cultural-dependent
attributes exist for this user and which language displays in the
Cisco CallManager user windows and phones.
• In the MAC Address field, enter the MAC Address for this user.
• In the Directory Number field, enter the directory number for the primary
extension (usually Line 1) for the user’s phone. This optional field can
contain as many as 50 integer characters.
• In the “Value for fields to be ignored” box, enter the symbol that you will use
to tell BAT that you want to keep the value that was previously stored in the
DC directory. If you enter “#” for the value for fields to be ignored, a CSV
file like the following example tells BAT to keep the Manager field the same
as the one that was previously entered in the DC directory but to overwrite
User Device Profile and User Locale for this user in the DC directory and set
them to blank.
userid,#,department,,,123456789012,
Step 6 Click the 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
Update_Users#timestamp.txt (or to your choice of filename)
Step 7 For BAT to access the CSV file that you created, you must save it to the publisher
database server. However, because 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.