User guide

Procedure
Step 1
To open the BAT spreadsheet, locate and double-click BAT.xlt file
Step 2
When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
Click the VG202-VG204 tab.
Step 4
For MGCP, click the MGCP radio button and for SCCP, click the SCCP radio button.
Step 5
Do one of the following:
a) If you choose MGCP, proceed to Step 6, on page 411.
b) If you choose SCCP, a Create File Format button appears in the spreadsheet.
1
Click Create File Format; the Field Selection window displays.
2
From the Device Fields box, select the required device fields and click on the >> button to move them
to the Selected Device Fields box.
3
From the Line Fields box, select the line fields and click the >> button to move them to the Selected
Line Fields box.
4
To rearrange the selected fields, click the Up and Down buttons.
5
You can click the << button to remove any of the selected fields from the selected fields list.
6
When you are done selecting the required fields, click Create to add the selected fields to the VG224
sheet.
Step 6
In each row, provide the information for the following fields:
• Domain Name/MAC Address—Enter a name, from 1 to 64 characters, that identifies the gateway. Use
the Domain Name System (DNS) host name if it is configured to resolve correctly; otherwise, use the
host name as defined on the Cisco MGCP gateway. For SCCP gateways, use the MAC address.
The host name must match exactly the host name that is configured on the Cisco IOS gateway. For
example, if the host name is configured on the gateway to resolve to vg204-1 and the IP domain name
is not configured, enter the host name in this field (in this case, vg204-1). If the host name is configured
on the gateway as vg204-1 and the IP domain name is configured on the gateway as cisco.com, enter
vg204-1.cisco.com in this field.
• Description—Enter a description, up to 100 characters for the gateway. Use a specific description that
helps you locate the gateway.
• Slot—Enter the slot number that you are trying to configure. For VG202 and VG204, the slot always
equals 0.
• Subunit—Enter an integer for the subunit value. For VG202 and VG204, the subunit always equals 0.
• Port Directory Number—Enter the directory number, up to 24 numerals and special characters, for this
port. This applies to the directory number field for port 2 through port 4.
Be aware that Port 1 Directory Number and Partition fields are required for FXS ports
only.
Note
• Port Number—Enter an integer for the Port Number.
• Port Description—Enter a description for port 1, up to 50 characters. Use a description to help identify
the port in a list of ports. This applies to the description field for port 2 through port 4.
Step 7
To transfer the data from the BAT Excel spreadsheet into a CSV file, click Export to BAT Format.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 411
CSV data file creation for Cisco VG202 and VG204 gateways
REVIEW DRAFT - CISCO CONFIDENTIAL