User guide

Complete all mandatory fields and any relevant, optional fields. Each column heading specifies the length of
the field.
• MAC Address—Enter the 12-character MAC address for the gateway.
• Port Number—Enter the numeric port number (1 through 24) that you want to add to the gateway.
• Directory Number—Enter a directory number, up to 24 numerals and special characters, for this port.
You must enter a directory number if you have specified a partition.(Optional)
• Partition—Enter the route partition, up to 50 characters, to which you want this port to belong. Do not
specify a partition unless you also have specified a directory number. (Optional)
The system treats blank rows in the spreadsheet as End of File and discards subsequent records.Caution
Step 5
To transfer the data from the BAT Excel spreadsheet into a CSV file, click Export to BAT Format.
The system saves the file to C:\XLSDataFiles\ or to your choice of another existing folder.
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. For more information, see Upload and download files, on page 17.
Related Topics
BAT spreadsheet data collection for CSV data file creation, on page 10
Create text-based CSV file for Cisco Catalyst 6000 FXS ports, on page 602
Upload and download files, on page 17
CSV data files creation for Cisco VG224 gateways and ports
You can create a CSV data file to insert VG224 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.
Related Topics
Create CSV data files for Cisco VG224 FXS gateways and ports using BAT spreadsheet, on page 408
Create text-based CSV file for Cisco VG224 gateways, on page 600
Create CSV data files for Cisco VG224 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:
VG224Gateways#timestamp.txt
where “timestamp” represents the precise date and time that the file was created.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
408 OL-28580-01
CSV data files creation for Cisco VG224 gateways and ports
REVIEW DRAFT - CISCO CONFIDENTIAL