User guide

• Port Number—Enter an integer for the Port Number.

Step 7

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 VG224Gateways#timestamp.txt to C:\XLSDataFiles

or to your choice of another existing folder on your local workstation.

For information on how to read the exported CSV data file, click the link to View Sample File in

the Insert Gateways window in BAT.

Note

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.

Related Topics

Create CSV data files for Cisco VG202 and VG204 FXS gateways and ports using BAT spreadsheet, on

page 410

Create text-based CSV file for Cisco VG202 and VG204 gateways, on page 603

Create CSV data files for Cisco VG202 and VG204 FXS gateways and 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 FXS ports.

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:

VG202Gateways#timestamp.txt or VG204Gateways#timestamp.txt

where “timestamp” represents the precise date and time at which 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.

Tip

Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)

410 OL-28580-01

CSV data file creation for Cisco VG202 and VG204 gateways

REVIEW DRAFT - CISCO CONFIDENTIAL