This chapter provides information to use Cisco Unified Communications Manager Bulk Administration (BAT) to configure Cisco gateway file formats in the Cisco Unified Communications Manager database in batches.
Choose Bulk Administration > Gateways > Gateway File Format > Create File Format. The Gateway File Format Find and List window displays.
Do one of the following:
To find all records in the database, ensure the dialog box is empty; go to Step 3.
To filter or search records:
From the first drop-down list box, select a search parameter.
From the second drop-down list box, choose a search pattern.
Specify the appropriate search text, if applicable.
To add additional search criteria click the + button. When you add criteria, the system searches for a record that matches all criteria that you specify. To remove criteria, click the – button to remove the last added criteria or click the Clear Filter button to remove all added search criteria.
All or matching records display. You can change the number of items that display on each page by choosing a different value from the Rows per Page drop-down list box.
You can delete multiple records from the database by checking the check boxes next to the appropriate record and clicking Delete Selected. You can delete all configurable records for this selection by clicking Select All and then clicking Delete Selected.
From the list of records that display, click the link for the record you want to view.
To reverse the sort order, click the up or down arrow, if available, in the list header.
The window displays the item that you choose.
Gateway file format configuration
You can use BAT to create, copy, modify, or delete a gateway file format.
Click Add New. The Create Gateway File Format window displays.
In the Format Name field, enter a name for this custom format.
Under Device Fields, choose the device field names that you want to define for each gateway. In the Device Field box, click a device field name and click the arrow to move the field to the Selected Device Fields box.
Gateway Name and Description are always selected.
You can select several random field names in the list by holding down the Ctrl key, and then clicking the arrow to select them together. You can select a range of items by using the Shift key.
Click line field names in the Line Field box and click the arrow to move the fields to the Selected Line Fields box.
Make sure that you select Directory Number if you select Line for the file format.
You can change the order of the items in the Selected Line Fields and Selected Device Fields Order boxes. Select an item and then use the up arrow to move the field closer to the beginning of the list or the down arrow to move it to the end of the list.
In the IP Phone Lines Maximums area, enter the maximum values for the Maximum Number of Lines field.
To save your custom file format, click Save. The name of the file format displays in the File Format Names list in the Gateway File Format Find and List window.
Copy existing gateway file format
You can copy an existing gateway file format.
Find the gateway file format you want to copy.
In the Search Results area, choose a file format that you want to copy. The Gateway File Format Configuration window displays.
To make a copy of the chosen file format, click Copy.
To copy the file format, you can also click the corresponding Copy icon in the Gateway File Format Find and List window.
In the Format Name field, enter a new name for the copied format.
After making your changes, click Save to save the copied file format with changes in the list.
You can add the file format with the text-based CSV data file.
When you used a text editor to create the CSV data file, you created a file format for entering values in the text-based file. You entered values in the text file in the order that the file format specified
After the CSV data file is completed, you need to associate the file format with the text-based CSV data file. After associating the file format with the CSV file, the names for each field display as the first record in the CSV data file. You can use this information to verify that you entered the values for each field in the correct order.
Choose Bulk Administration > Gateways > Gateway File Format > Add File Format. Add Gateway File Format window displays.
In the File Name field, choose the text-based CSV file that you created for this transaction.
In the Format File Name field, choose the file format that you created for this type of bulk transaction.
To create a job for associating the matching file format with the CSV data file, click Submit. Use the Job Scheduler option in the Bulk Administration main menu to schedule and/or activate this job.