CSV Data File Creation for Cisco VG200 Gateways
You can create a CSV data file to insert Cisco VG200 gateways and ports in the Cisco Unified Communications Manager database. Use either the BAT spreadsheet or a text editor to create the CSV data file.
Create CSV Data Files for Cisco VG200 Gateways and T1 CAS, T1 PRI, E1 PRI, FXS or FXO Ports Using BAT Spreadsheet
Use the BAT spreadsheet to create the CSV data file that contains the details, such as domain name, MGCP description, and port identifier, for individual T1 CAS, T1 PRI, E1 PRI, FXS or FXO ports.
For T1 CAS only, the ports that you specify in the BAT spreadsheet must be the same ports that you specified in the VG200 template. In the CSV data file, you can specify none, some, or all ports that were configured in the template. Do not configure any ports in the CSV data file that were not also configured in the template, or an error will result when you attempt to insert the BAT VG200 template and the CSV file.
For example, if you configured ports 1,2,3, and 4 in the template, you could configure none of the ports, or ports 1, 2, 3, and 4, or only ports 1 and 2 in the CSV file, and the insertion would be accepted. But if you 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:
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.
To open the BAT spreadsheet, locate and double-click BAT.xlt file
When prompted, click Enable Macros to use the spreadsheet capabilities.
Click the VG200 T1-Pri T1-Cas E1-Pri FXSFXO tab.
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.
Provide the information for the following fields.
To transfer the data from the BAT Excel spreadsheet into a CSV file, click Export to BAT Format.
The system saves the file using the default filename
What to do next
You must upload the CSV data file to the first node of the Cisco Unified Communications Manager server, so BAT can access the data input file.