- Preface
-
- Manage User Device Profiles
- User Device Profile Templates
- User Device Profile File Format
- User Device Profile File Format Addition
- User Device Profile Validation
- UDP Generation
- User Device Profile Updates
- User Device Profile Deletions
- User Device Profile Exports
- Line Attribute Updates for Devices and User Device Profiles
- UDP Line Additions
- UDP Report Generation
- Intercom DN Additions and Updates for UDPs
- Text-Based CSV Files
- BAT Performance
- Index
Contents
- Phone Line Addition and Updates
- Update Phone Lines Using Query
- Phone Line Update Field Descriptions
- Add Phone Lines to Existing Phones and UDPs
- Add Phone Lines to Existing Phones Using BAT Spreadsheet
- Phone Line Field Descriptions for Line Additions Using BAT Spreadsheet
Phone Line Addition and Updates
This chapter provides information to update line attributes for a specific group of devices or user device profiles using the Update Lines option. Lines for a phone and a user device profile get updated at the same time when both are part of the query result.
You can add lines to a group of existing phones or user device profiles in the Cisco Unified Communications Manager database. When you use the template to add new lines, you cannot change phone services or speed dials. Cisco Unified Communications Manager Bulk Administration (BAT) ignores those fields on the template when you add lines to existing devices.
- Update Phone Lines Using Query
- Phone Line Update Field Descriptions
- Add Phone Lines to Existing Phones and UDPs
- Add Phone Lines to Existing Phones Using BAT Spreadsheet
- Phone Line Field Descriptions for Line Additions Using BAT Spreadsheet
Update Phone Lines Using Query
| Step 1 | .
The Update Lines Query window displays.
| ||
| Step 2 | From the first
Find Line where drop-down list box, choose one
of the following criteria:
From the second Find Line where drop-down list box, choose one of the following criteria: | ||
| Step 3 | In the search field list box, choose or enter the value that you
want to locate.
Example:You can choose the Route Partition from the list or enter a range of directory numbers.
| ||
| Step 4 | To further define your query and to add multiple filters, check the Search Within Results check box, choose AND or OR from the drop-down box, and repeat Step 2 and Step 3. | ||
| Step 5 | To display the records that are going to be affected, click
Find.
A list of discovered lines displays by | ||
| Step 6 | Click
Next.
The
Update Lines window shows the type of query that
you chose at the top.
| ||
| Step 7 | Specify the setting that you want to update for all the records that you have defined in your query. You can choose multiple parameters to update. See Phone Line Update Field Descriptions for field descriptions. | ||
| Step 8 | In the Value field for the checked parameter, enter the new value or choose a value from the list box. | ||
| Step 9 | In the Job Information area, enter the Job description. | ||
| Step 10 | Choose an insert method. Do one of the following: | ||
| Step 11 | To create a job for inserting the phone records, click Submit. To schedule this job, activate this job, or both, use the Job Configuration window. |
Phone Line Update Field Descriptions
The following table provides the field descriptions for updating line details.
Values that display in some fields display from Cisco Unified Communications Manager. You must configure these values by using Cisco Unified Communications Manager Administration.
Add Phone Lines to Existing Phones and UDPs
| Step 1 | Choose Bulk Administration > Phones > Add/Update Lines > Add Lines. The Phone Add Lines window displays. |
| Step 2 | In the File Name field, choose the CSV data file that you created for this bulk transaction. |
| Step 3 | In the Phone Template Name field, choose the BAT phone template to use for this bulk transaction. |
| Step 4 | If you are changing the phone settings for existing phones in the template, check the Update the existing phone button template check box. The user phone information also gets updated when this check box is checked. |
| Step 5 | In the Job Information area, enter the Job description. |
| Step 6 | Choose an insert method. Do one of the following: |
| Step 7 | To create a job for adding lines to existing phones and UDPs, click Submit. To schedule, this job, activate this job, or both, use the Job Configuration window. |
Add Phone Lines to Existing Phones Using BAT Spreadsheet
You can create a CSV data file using the BAT spreadsheet to add phone lines to existing phones.
After you have finished adding lines in the BAT spreadsheet, you can export the content to a CSV formatted data file. A default filename is assigned to the exported CSV formatted data file:
<tabname>-<timestamp>.txt
where <tabname> represents the type of input file that you created, such as phones, and <timestamp> represents the precise date and time that the file was created.
The system saves the file to C:\XLSDataFiles\, or you can save the file to another existing folder on your local workstation. You can rename the CSV formatted data file after you save the exported file to your local workstation. 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.
 Note | You cannot upload a CSV filename that contains a comma (for example, abcd,e.txt) to the Cisco Unified Communications Manager server. 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. |
| Step 1 | To open the BAT Spreadsheet, locate and double-click the BAT.xlt file. | ||
| Step 2 | When prompted, click Enable Macros to use the spreadsheet capabilities. | ||
| Step 3 | To display the fields, click the Add Lines tab at the bottom of the spreadsheet. | ||
| Step 4 | Select the
Phones radio button to add lines to a phone.
| ||
| Step 5 | Enter data for an individual phone on each line in the spreadsheet. Complete all mandatory fields and any relevant optional fields. Each column heading specifies the length of the field and whether it is required or optional. See Table 1 for field descriptions. | ||
| Step 6 | To transfer the data from the BAT Excel spreadsheet into a CSV
formatted data file, click
Export to BAT Format.
|
What to Do Next
Upload the file to the Cisco Unified Communications Manager server.
Phone Line Field Descriptions for Line Additions Using BAT Spreadsheet
The following table provides the field descriptions when you add lines using the BAT spreadsheet.
|
Field |
Description |
||||
|---|---|---|---|---|---|
|
MAC Address |
Enter the MAC address for phones, VGC virtual phones, and VGC phones. Enter a unique identifier for CTI ports and H.323 clients. |
||||
|
Line Index |
Enter a number between 1 and 34 for the line index of a phone. |
||||
|
Directory Number |
Enter a directory number, up to 24 numerals and special characters, for this line. |
||||
|
Display |
Enter the text that you want to display on the called party’s phone display, such as the user name (John Smith) or phone location (Conference Room 1).
|
||||
|
Line Text Label |
Enter text that identifies this directory number for a line/phone combination.
|
||||
|
Forward Busy External |
Enter the directory number or directory URI to which a call that is coming from an external number is forwarded when the line is in use.
|
||||
|
Forward No Answer External |
Enter the directory number or directory URI to which a call that is coming from an external number is forwarded when the phone is not answered.
|
||||
|
Forward No Coverage External |
Enter the directory number or directory URI to which a call that is coming from an external number is forwarded when the phone does not have coverage.
|
||||
|
Forward Busy Internal |
Enter the directory number or directory URI to which a call that is coming from an internal number is forwarded when the line is in use.
|
||||
|
Forward No Answer Internal |
Enter the directory number or directory URI to which a call that is coming from an internal number is forwarded when the phone is not answered.
|
||||
|
Forward No Coverage Internal |
Enter the directory number or directory URI to which a call that is coming from an internal number is forwarded when the phone does not have coverage.
|
||||
|
Call Pickup Group |
Enter a Pickup Group Name to specify the call pickup group, which can answer incoming calls to this line by dialing the appropriate pickup group number. |
||||
|
Park Monitoring Forward No Retrieve Destination External |
When the parkee is an external party, then the call will be forwarded to the specified destination in the parker’s Park Monitoring Forward No Retrieve Destination External parameter. If the Forward No Retrieve Destination External field value is empty, the parkee will be redirected to the parker’s line. |
||||
|
Park Monitoring Forward No Retrieve Destination Internal |
When the parkee is an internal party, then the call will be forwarded to the specified destination in the parker’s Park Monitoring Forward No Retrieve Destination Internal parameter. If the Forward No Retrieve Destination Internal is empty, the parkee will be redirected to the parker’s line. |
||||
|
Park Monitoring Reversion Timer |
This parameter determines the number of seconds that Cisco Unified Communications Manager waits before prompting the user to retrieve a call that the user parked. This timer starts when the user presses the Park softkey on the phone, and a reminder is issued when the timer expires. Default: 60 seconds If you configure a non-zero value, this value overrides the value of this parameter set in the Service Parameters window. However, if you configure a value of 0 here, then the value in the Service Parameters window will be used. |
||||
|
Park Monitoring Forward No Retrieve Internal Voice Mail |
This setting uses the settings in the Voice Mail Profile Configuration window. When this check box is checked, Cisco Unified Communications Manager ignores the settings in the Destination box and Calling Search Space. |
||||
|
Park Monitoring Forward No Retrieve External Voice Mail |
This setting uses the settings in the Voice Mail Profile Configuration window. When this check box is checked, Cisco Unified Communications Manager ignores the settings in the Destination box and Calling Search Space. |
||||
|
Park Monitoring Forward No Retrieve External CSS |
Choose the calling search space to apply to the directory number. |
||||
|
Park Monitoring Forward No Retrieve Internal CSS |
Choose the calling search space to apply to the directory number. |
||||
|
Log Missed Calls |
This field allows you to turn this feature on or off. Enter ‘T’ to enable Cisco Unified Communications Manager to log missed calls in the call history for that directory number on the phone. Enter ‘F’ to disable this feature. |
||||
|
Party Entrance Tone |
Enter one of the following Party Entrance Tone options:
|
||||
URI on Directory Number |
Enter a directory URI that you want to associate with the directory number for this phone. Follow the username@host format. Enter a username of up to 47 alphanumeric characters. For the host address, enter an IPv4 address or fully qualified domain name.
|
||||
URI Route Partition on Directory Number |
Enter the partition on which the directory URI belongs. If you do not want to restrict access to the directory URI, leave the field blank. |
||||
URI Is Primary on Directory Number |
Enter a ‘t’ (True) to indicate that this directory URI is the primary directory URI for this extension. Otherwise, enter an ‘f’ (False) to indicate that this is not the primary directory URI for this extension.
|
||||
Enterprise Add to Local Route Partition |
Enter a 't' to add this enterprise alternate number to a local route partition. Enter 'f' to leave the E.164 number off of local routing. |
||||
Enterprise Advertise via globally |
Enter a 't' to enable ILS to advertise this alternate number to rest of the ILS network. Enter an 'f' if you don't want ILS to advertise this number. |
||||
Enterprise Is Urgent |
Enter a 't' to classify routing for this alternate number as urgent. By default, if the dial plan contains overlapping route patterns Cisco Unified Communications Manager does not route the call until the interdigit timer expires (even if a possible route exists for the dialed digits). This setting guards against learned numbers that overlap with statically configured directory numbers and number patterns by allowing Cisco Unified Communications Manager to choose the best match of all available routes for the dial string. When you mark the number as urgent priority, Cisco Unified Communications Manager routes the call as soon as it finds a match between the dialed digits and an available route, without waiting for the interdigit timer to expire (for example, the T302 Timer service parameter). |
||||
Enterprise Number Mask |
Enter the number mask to apply to the directory number. Cisco Unified Communications Manager applies the mask to create an enterprise alternate number that is an alias of this directory number. |
||||
Enterprise Route Partition |
Enter the local route partition to which you want to assign this enterprise alternate number. |
||||
+E.164 Add to Local Route Partition |
Enter a 't' to add this E.164 alternate number to a local route partition. Enter 'f' to leave the E.164 number off of local routing. |
||||
+E.164 Advertise via globally |
Enter a 't' to enable ILS to advertise this alternate number to rest of the ILS network. Enter an 'f' if you don't want ILS to advertise this number. |
||||
+E.164 Is Urgent |
Enter a 't' to classify routing for this alternate number as urgent. By default, if the dial plan contains overlapping route patterns Cisco Unified Communications Manager does not route the call until the interdigit timer expires (even if a possible route exists for the dialed digits). This setting guards against learned numbers that overlap with statically configured directory numbers and number patterns by allowing Cisco Unified Communications Manager to choose the best match of all available routes for the dial string. When you mark the number as urgent priority, Cisco Unified Communications Manager routes the call as soon as it finds a match between the dialed digits and an available route, without waiting for the interdigit timer to expire (for example, the T302 Timer service parameter). |
||||
+E.164 Number Mask |
Enter the number mask to apply to the directory number. Cisco Unified Communications Manager applies the mask to create an +E.164 alternate number that is an alias of this directory number. |
||||
+E.164 Route Partition |
Enter the local route partition to which you want to assign this +E.164 alternate number. |