Cisco Unified CallManager Bulk Administration Guide, Release 5.0(2) - Phone File Format [Cisco Unified Communications Manager (CallManager)]

Table Of Contents

Phone File Format

Using a Text Editor to Create the CSV Data File for Phones

Finding a Phone File Format

Configuring a Phone File Format

Creating a File Format

Copying a File Format

Modifying a File Format

Deleting a File Format

Associating the File Format with the CSV Data File

Related Topics

Phone File Format

The following topics provide information about configuring file formats for CSV data files that are created by using a text editor.

•Using a Text Editor to Create the CSV Data File for Phones

•Finding a Phone File Format

•Configuring a Phone File Format

•Associating the File Format with the CSV Data File

•Creating a Text-Based CSV File for Phones

Using a Text Editor to Create the CSV Data File for Phones

You can create the CSV data file by using lines of ASCII text with values separated by commas. The comma separated values (CSV) file provides textual information in tabular form. For more information about text-based CSV files for phones, see the "Creating a Text-Based CSV File for Phones" section.

Use one of these file format options to identify the device and line fields within the CSV data file:

•Default Phone—Contains a predetermined set of phone device and line fields.

•Simple Phone—Contains basic device and line fields for phones.

•Custom—Contains device and line fields that you choose and order yourself.

You cannot modify or delete the Simple Phone or Default Phone file formats.

Note When you use the Cisco Unified CallManager Bulk Administration (BAT) spreadsheet to create the CSV data file, you can create the file format within the spreadsheet. When you use a text editor to create the CSV data file, you need to create a file format or use the simple or default file format. You enter the values in the text-based file in the same order as specified in the file format.

Additional Information

See the "Related Topics" section

Finding a Phone File Format

Use the following procedure to find a phone file format.:

Procedure

Step 1 Choose Bulk Administration > Phones > Phone File Format > Create File Format.

The Find and List Phone File Formats window displays.

Step 2 From the Find Phone File Format where Format Name drop-down list box, choose one of the following criteria:

•begins with

•contains

•is exactly

•ends with

•is empty

•is not empty

Step 3 Specify the appropriate search text, if applicable, and click Find.

Tip To find all Phone formats, click Find without entering any search text.

Step 4 To further define your query and to add multiple filters, check the Search Within Results check box and choose AND or OR from the drop-down box, and repeat steps 2 and 3.

Step 5 From the list of records, click the file format name that matches your search criteria.

The Phone File Format Configuration window displays.

Additional Information

See the "Related Topics" section

Configuring a Phone File Format

Use the following topics to create, copy, modify, or delete a phone file format:

•Creating a File Format

•Copying a File Format

•Modifying a File Format

•Deleting a File Format

Creating a File Format

To create your file format for the text-based CSV data file, use the following procedure.

Procedure

Step 1 Choose Bulk Administration > Phones > Phone File Format > Create File Format.

Step 2 Click Add New. The Phone File Format Configuration window displays.

Step 3 In the Format Name field, enter a name for this custom format.

Step 4 Under Device Fields, choose the device field names that you want to define for each phone. In the Device Field box, click a device field name and click the arrow to move the field to the Selected Device Fields box.

A CSV data file must include MAC Address/Device Name and Description; therefore, these fields are always selected.

Tip 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.

Step 5 Click line field names in the Line Field box and click the arrow to move the fields to the Selected Line Fields box.

Tip You can change the order of the items in the Selected Line Fields and Selected Device Fields 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.

Step 6 In the IP Phone Services Maximums area, enter the maximum values for the following fields:

•Maximum Number of Speed Dials

•Maximum Number of IP Phone Services

•Maximum Number of IP Phone Service Parameters

Step 7 To save your custom file format, click Save. The name of the file format displays in the File Format Names list in the Find and List Phone File Formats window.

Additional Topics

See the "Related Topics" section.

Copying a File Format

To copy an existing format for the CSV data file, use the following procedure.

Procedure

Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section.

Step 2 In the Search Results area, choose a file format that you want to copy. The Phone File Format Configuration window displays.

Step 3 To make a copy of the chosen file format, click Copy.

Note To copy the file format, you can also click the corresponding Copy icon in the Find and List Phone File Formats window.

Step 4 In the Format Name field, enter a new name for the copied format.

Step 5 Modify the copied format by using one of these methods:

•Add new fields by choosing them from the Device Fields or Line Fields box, and then clicking the arrow to move the chosen fields into the Selected Device Field or Selected Line Fields box.

•Remove selected fields by choosing them from the Selected Device Fields or Selected Line Fields box, and then clicking the arrow to move the chosen fields into the Device Field or Line Fields box.

•Change the order of the fields by choosing a field name in the Selected Device Field or Selected Line Fields box and using the up or down arrow to change its location.

Step 6 After making your changes, click Save to save the copied file format with changes in the list.

Additional Topics

See the "Related Topics" section.

Modifying a File Format

To modify an existing file format for the CSV data file, use the following procedure. You can modify custom formats only.

Procedure

Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section.

Step 2 In the Search Results area, choose a file format that you want to modify. The Phone File Format Configuration window displays.

Step 3 Modify the copied format by using one of these methods:

•Add new fields by choosing them from the Device Fields or Line Fields box, then clicking the arrow to move the chosen fields into the Selected Device Field or Selected Line Fields box.

•Remove fields by choosing them from the Selected Device Fields or Selected Line Fields box, then clicking the arrow to move the selected fields into the Device Field or Line Fields box. You cannot remove the required fields: Number of lines, MAC address, and description.

•Change the order of the fields by choosing a field name in the Selected Device Field or Selected Line Fields box and using the up or down arrow to change its location.

Step 4 After making your changes, click Save to save the changes to the file format.

Additional Topics

See the "Related Topics" section.

Deleting a File Format

To delete an existing file format for the CSV data file, use the following procedure.You can delete only custom formats.

Procedure

Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section.

Step 2 In the Search Results area, verify that this is the file(s) that you want to delete.

Step 3 To remove the file format(s) from the list, click Delete selected. A message asks you to confirm that you want to delete the file format(s). Click OK to continue. The system removes the file format(s) name from the list.

Note Make sure to browse the entire list of displayed results before clicking Delete Selected.

Additional Topics

See the "Related Topics" section.

Associating the File Format with the 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.

To add the file format with the text-based CSV data file, use the following procedure.

Procedure

Step 1 Choose Bulk Administration > Phones > Phone File Format > Add File Format. Add File Format window displays.

Step 2 In the File Name field, choose the text-based CSV file that you created for this transaction.

Step 3 In the File Format Name field, choose the file format that you created for this type of bulk transaction.

Step 4 Click Submit to create a job for associating the matching file format with the CSV data file.

Step 5 Use the Job Scheduler option in the Bulk Administration main menu to schedule and/or activate this job.

For more information on jobs, see the Chapter 51 "Scheduling Jobs."

Additional Topics

See the "Related Topics" section.

Related Topics

•Using a Text Editor to Create the CSV Data File for Phones

•Finding a Phone File Format

•Configuring a Phone File Format

•Associating the File Format with the CSV Data File

•Creating a Text-Based CSV File for Phones

	Cisco Unified CallManager Bulk Administration Guide, Release 5.0(2)
	Phone File Format
Cisco Unified CallManager Bulk Administration Guide, Release 5.0(2) Index Preface Overview Uploading and Downloading Files Phone Template Phone File Format Validating Phone Records Inserting Phones Updating Phones Deleting Phones Exporting Phones Adding and Updating Lines for Phones Resetting or Restarting Phones Generating Phone Reports Migrating Phones Adding Users User Template Inserting Users Updating Users Delete Users Exporting Users Resetting Passwords and PINs Generating User Reports Phones with Users Phones and Users File Format Validating Phones and Users Inserting Phones and Users Working with Cisco Unified CallManager Assitant Inserting Managers/Assistants Deleting Managers/Assistants Deleting Managers Deleting Assistants Generating Reports for Managers/Assistants User Device Profiles User Device Profile Template User Device Profile File Format Adding User Device Profile File Format Validating User Device Profiles Generating UDPs Deleting User Device Profiles Using User Device Profile Export Updating Lines for User Device Profiles Adding Lines in UDP Generating Reports for UDPs Gateway Template Inserting Gateways Deleting Cisco Gateways Generating Reports for Cisco Gateways Working with Client Matter Codes and Forced Authorization Codes Deleting Forced Authorization Codes and Client Matter Codes Working With Call Pickup Groups Deleting Call Pickup Groups Scheduling Jobs Working with Cisco Unified CallManager Auto-Register Phone Tool Troubleshooting BAT and Unified CM Auto-Register Phone Tool Text-Based CSV Files	Download this chapter Phone File Format Download the complete book PDF Version of Entire Book (PDF - 4 MB) Feedback Table Of Contents Phone File Format Using a Text Editor to Create the CSV Data File for Phones Finding a Phone File Format Configuring a Phone File Format Creating a File Format Copying a File Format Modifying a File Format Deleting a File Format Associating the File Format with the CSV Data File Related Topics Phone File Format The following topics provide information about configuring file formats for CSV data files that are created by using a text editor. •Using a Text Editor to Create the CSV Data File for Phones •Finding a Phone File Format •Configuring a Phone File Format •Associating the File Format with the CSV Data File •Creating a Text-Based CSV File for Phones Using a Text Editor to Create the CSV Data File for Phones You can create the CSV data file by using lines of ASCII text with values separated by commas. The comma separated values (CSV) file provides textual information in tabular form. For more information about text-based CSV files for phones, see the "Creating a Text-Based CSV File for Phones" section. Use one of these file format options to identify the device and line fields within the CSV data file: •Default Phone—Contains a predetermined set of phone device and line fields. •Simple Phone—Contains basic device and line fields for phones. •Custom—Contains device and line fields that you choose and order yourself. You cannot modify or delete the Simple Phone or Default Phone file formats. Note When you use the Cisco Unified CallManager Bulk Administration (BAT) spreadsheet to create the CSV data file, you can create the file format within the spreadsheet. When you use a text editor to create the CSV data file, you need to create a file format or use the simple or default file format. You enter the values in the text-based file in the same order as specified in the file format. Additional Information See the "Related Topics" section Finding a Phone File Format Use the following procedure to find a phone file format.: Procedure Step 1 Choose Bulk Administration > Phones > Phone File Format > Create File Format. The Find and List Phone File Formats window displays. Step 2 From the Find Phone File Format where Format Name drop-down list box, choose one of the following criteria: •begins with •contains •is exactly •ends with •is empty •is not empty Step 3 Specify the appropriate search text, if applicable, and click Find. Tip To find all Phone formats, click Find without entering any search text. Step 4 To further define your query and to add multiple filters, check the Search Within Results check box and choose AND or OR from the drop-down box, and repeat steps 2 and 3. Step 5 From the list of records, click the file format name that matches your search criteria. The Phone File Format Configuration window displays. Additional Information See the "Related Topics" section Configuring a Phone File Format Use the following topics to create, copy, modify, or delete a phone file format: •Creating a File Format •Copying a File Format •Modifying a File Format •Deleting a File Format Creating a File Format To create your file format for the text-based CSV data file, use the following procedure. Procedure Step 1 Choose Bulk Administration > Phones > Phone File Format > Create File Format. Step 2 Click Add New. The Phone File Format Configuration window displays. Step 3 In the Format Name field, enter a name for this custom format. Step 4 Under Device Fields, choose the device field names that you want to define for each phone. In the Device Field box, click a device field name and click the arrow to move the field to the Selected Device Fields box. A CSV data file must include MAC Address/Device Name and Description; therefore, these fields are always selected. Tip 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. Step 5 Click line field names in the Line Field box and click the arrow to move the fields to the Selected Line Fields box. Tip You can change the order of the items in the Selected Line Fields and Selected Device Fields 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. Step 6 In the IP Phone Services Maximums area, enter the maximum values for the following fields: •Maximum Number of Speed Dials •Maximum Number of IP Phone Services •Maximum Number of IP Phone Service Parameters Step 7 To save your custom file format, click Save. The name of the file format displays in the File Format Names list in the Find and List Phone File Formats window. Additional Topics See the "Related Topics" section. Copying a File Format To copy an existing format for the CSV data file, use the following procedure. Procedure Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section. Step 2 In the Search Results area, choose a file format that you want to copy. The Phone File Format Configuration window displays. Step 3 To make a copy of the chosen file format, click Copy. Note To copy the file format, you can also click the corresponding Copy icon in the Find and List Phone File Formats window. Step 4 In the Format Name field, enter a new name for the copied format. Step 5 Modify the copied format by using one of these methods: •Add new fields by choosing them from the Device Fields or Line Fields box, and then clicking the arrow to move the chosen fields into the Selected Device Field or Selected Line Fields box. •Remove selected fields by choosing them from the Selected Device Fields or Selected Line Fields box, and then clicking the arrow to move the chosen fields into the Device Field or Line Fields box. •Change the order of the fields by choosing a field name in the Selected Device Field or Selected Line Fields box and using the up or down arrow to change its location. Step 6 After making your changes, click Save to save the copied file format with changes in the list. Additional Topics See the "Related Topics" section. Modifying a File Format To modify an existing file format for the CSV data file, use the following procedure. You can modify custom formats only. Procedure Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section. Step 2 In the Search Results area, choose a file format that you want to modify. The Phone File Format Configuration window displays. Step 3 Modify the copied format by using one of these methods: •Add new fields by choosing them from the Device Fields or Line Fields box, then clicking the arrow to move the chosen fields into the Selected Device Field or Selected Line Fields box. •Remove fields by choosing them from the Selected Device Fields or Selected Line Fields box, then clicking the arrow to move the selected fields into the Device Field or Line Fields box. You cannot remove the required fields: Number of lines, MAC address, and description. •Change the order of the fields by choosing a field name in the Selected Device Field or Selected Line Fields box and using the up or down arrow to change its location. Step 4 After making your changes, click Save to save the changes to the file format. Additional Topics See the "Related Topics" section. Deleting a File Format To delete an existing file format for the CSV data file, use the following procedure.You can delete only custom formats. Procedure Step 1 Find the phone file format you want to copy using "Finding a Phone File Format" section. Step 2 In the Search Results area, verify that this is the file(s) that you want to delete. Step 3 To remove the file format(s) from the list, click Delete selected. A message asks you to confirm that you want to delete the file format(s). Click OK to continue. The system removes the file format(s) name from the list. Note Make sure to browse the entire list of displayed results before clicking Delete Selected. Additional Topics See the "Related Topics" section. Associating the File Format with the 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. To add the file format with the text-based CSV data file, use the following procedure. Procedure Step 1 Choose Bulk Administration > Phones > Phone File Format > Add File Format. Add File Format window displays. Step 2 In the File Name field, choose the text-based CSV file that you created for this transaction. Step 3 In the File Format Name field, choose the file format that you created for this type of bulk transaction. Step 4 Click Submit to create a job for associating the matching file format with the CSV data file. Step 5 Use the Job Scheduler option in the Bulk Administration main menu to schedule and/or activate this job. For more information on jobs, see the Chapter 51 "Scheduling Jobs." Additional Topics See the "Related Topics" section. Related Topics •Using a Text Editor to Create the CSV Data File for Phones •Finding a Phone File Format •Configuring a Phone File Format •Associating the File Format with the CSV Data File •Creating a Text-Based CSV File for Phones
	Terms & Conditions \| Privacy Statement \| Cookie Policy \| Trademarks