User guide

• When you add new pickup groups, you must complete all required fields like the pickup group name
and pickup group number. If the procedure specifies an entry as mandatory, you must provide the
information in the file.
• Deleting information from a file and leaving the information blank does not remove the information
from the Cisco Unified Communications Manager database; in other words, a blank value does not
overwrite an existing value in the database. Updating the values overwrites the existing value in the
database.
• Upload the appropriate CSV files to the first node of the Cisco Unified Communications Manager cluster.
• Any time that you create or change a CSV file, you must insert the CSV file in BAT to update the Cisco
Unified Communications Manager database.
Create call pickup group CSV data file using BAT.xlt
You can create the CSV file for call pickup groups using the BAT spreadsheet BAT.xlt.
The BAT.xlt file exists on the first node of the Cisco Unified Communications Manager server; however,
you normally do not have Microsoft Excel installed on the server. In that case, copy the file from the first
node and move it to a local machine that has Microsoft Excel installed.
Note
Before You Begin
Review important considerations in Call pickup group setup using BAT, on page 439 before you use BAT to
configure call pickup.
Procedure
Step 1
Choose Bulk Administration > Upload/Download Files.
The Find and List Files window opens.
Step 2
Click Find and download the BAT.xlt file.
Step 3
Copy BAT.xlt to a local machine where Microsoft Excel is installed.
Step 4
To open the BAT Spreadsheet, locate and double-click the BAT.xlt file.
Step 5
When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 6
Click the Call Pickup Group tab.
Step 7
Enter call pickup group settings in the columns.
See Table 39: Configuration settings for call pickup groups, on page 442 for descriptions of configuration
settings.
Repeat Step 7, on page 440 until you enter all pickup
groups.
Note
Step 8
To transfer the Excel spreadsheet format to a CSV file, click Export to BAT Format.
The system automatically saves CSV files to C:\XlsDatafiles on the local machine.
Click Browse to choose a different
location.
Tip
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
440 OL-28580-01
Create call pickup group CSV data file using BAT.xlt
REVIEW DRAFT - CISCO CONFIDENTIAL