User guide

configured ports 5 and 6 in the CSV file when they are not configured in the template, you will receive an
insertion error in BAT.
After you are finished editing the fields for the gateway ports in the BAT spreadsheet, export the file. The
system saves the file to C:\XLSDataFiles or to your choice of another existing folder on your local
workstation using the following default filename:
VG200Gateways#timestamp.txt
where “timestamp” represents the precise date and time that the file was created.
If you enter a comma in one of the fields, BAT.xlt encloses that field entry in double quotes when you
export to BAT format. If you enter a blank row in the spreadsheet, the system treats the empty row as the
end of the file. Data that is entered after a blank line does not get converted to the BAT format.
Attention
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 VG200 T1-Pri T1-Cas E1-Pri FXSFXO tab.
Step 4
For T1 CAS endpoints only, scroll to the right until you see the Number of Port Identifiers field. Enter the
number of port identifiers that you want to add for each Cisco VG200 gateway. If you want only one port
identifier, skip this step.
Step 5
In each row, provide the information for the following fields.
Table 36: VG200 gateway T1 CAS, T1-PRI, E1-PRI, FXS and FXO ports field settings
DescriptionField
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.
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 vg200-1 and the IP domain name is not configured, enter the host
name in this field (in this case, vg200-1). If the host name is configured on the
gateway as vg200-1 and the IP domain name is configured on the gateway as
cisco.com, enter vg200-1.cisco.com in this field.
MGCP Domain Name
Enter a description, up to 100 characters for the gateway. Use a specific
description that helps you locate the gateway.
MGCP 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.
Port Description
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
406 OL-28580-01
CSV data file creation for Cisco VG200 gateways
REVIEW DRAFT - CISCO CONFIDENTIAL