User guide

b) To delete a manager or an assistant from a manager-assistant association, click Delete.
Step 7
To transfer the data from the BAT spreadsheet into a CSV data file, click Export to BAT Format.
For information on how to read the exported CSV data file, click the link to View Sample File in
theInsert Managers/Assistants window in BAT.
Tip
The system saves the file using the default filename <type of operation>ManagerAssistants-timestamp.txt
to C:\XLSDataFiles or to your choice of another existing folder on your local workstation.
What to Do Next
You must upload the CSV data file to the Cisco Unified Communications Manager first node database server
so BAT can access the CSV data file.
Related Topics
Download file off server, on page 18
Topics related to CVS data files for manager-assistant, on page 260
Upload file to server, on page 19
Create custom manager-assistant CSV data files
When you have existing phones that you want to set up with manager-assistant associations, you can use the
Custom Managers-Assistants tab in the BAT spreadsheet. Use the BAT spreadsheet to create a custom CSV
data file for inserting or updating manager-assistant associations for proxy lines on the assistant phones.
After you have finished editing all the fields in the BAT spreadsheet, you can export the content to a CSV
formatted data file. The system saves the file using the default filename Custom
Manager-Assistants-timestamp.txt to C:\XLSDataFiles or to your choice of another existing folder
on your local workstation.
Procedure
Step 1
Download the BAT.xlt file from Cisco Unified Communications Manager server.
Step 2
Open the BAT.xlt file. When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
To display the manager-assistant association options, click the Custom Managers-Assistants tab at the
bottom of the spreadsheet.
Step 4
Scroll to the right side of the template until you see Number of Proxy Lines box. In that box, enter the number
of proxy lines that you are assigning to an assistant. The spreadsheet adds Proxy Line DN and Manager Line
DN Columns based on the number that you enter.
Complete all mandatory fields and any relevant, optional fields.
• Manager ID—Enter the user ID of the manager.
• Device Name—Enter the device name that are assigned to the manager phone.
• Intercom DN—Enter the directory number for the manager intercom line. (Optional)
• Assistant ID—Enter the user IDs for the assistants to whom the manager will be associated.
• Device Name—Enter the device name that are assigned to the assistant's phone.
• Intercom DN—Enter the directory number for the assistant intercom line. (Optional)
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 259
CSV Data File for manager-assistant associations
REVIEW DRAFT - CISCO CONFIDENTIAL