Manage Import Templates

Add an Import Template for a Route Set

Expand the Route Manager slider, and click Import Templates.
In the Import Templates tab, click Add.

In the Choose Route Set dialog box complete the following fields:

Table 4-5 Fields in the Choose Route Set dialog box

Field

Description

Rouet Set Type

SBC is the default route set type. The DSC option is deprecated.

Pub-id Type

Choose any one of the following values:

Range.

Note:
Range is support from SDM Release 9.0.2.
E164
String

Note:

Based on the Pub-id type you select, the next screen containing the CSV column mappings fields are loaded dynamically.

Pub id Type

Attribute Name

Pub-id Type: Range

Range Start

Pub-id Type: Range

Range End

Pub-id Type: E164/String

E164/String

In the Add Import Templates dialog box, complete the following fields:

Name

The new import template name.

Operation drop-down list

Select a row number to map it to the corresponding Operation row in the CSV file from the drop-down list.

Range Start

A Numerical value in the format of E164 that specifies the start value for a contiguous range of DID telephone numbers. Range start can be directly imported or edited.

Range End

A Numerical value in the format of E164 that specifies the end value for a contiguous range of DID telephone numbers. Range End can be directly imported or edited.

pub id drop-down list

Select a row number to map it to the corresponding Pub ID row in the CSV file from the drop-down list.

Additional PubId Properties menu

Click the arrow icon to expand the following Pub Id property entries that can be mapped to their corresponding CSV file column number:

NPA ($NPA), NXX ($NXX), PUser1 and PUser2 fields—Select the route entry that has the alphanumeric value that has a user-specific definable meaning that can be used in the formula to generate the Pub-Id for a route record. It can also be used for aggregating route records into groups. Once defined, use of this field must be consistent within the route set.
Pub-id Formula—The alphanumeric string that contains an expression used to define string concatenation and text replacement to generate the Pub Id for a route record.
If you enter a Pub-id Formula, the pub id field is disabled.

Session Establishment Data (SED) drop-down list

Select the numerical entry for the next hop formula that generates the Session Establishment Data (SED).

Order drop-down list

Select the numerical entry that is used as a mechanism for sorting the display of route records in the application or order the output of routes in the LRT that have the same pub-id. The order of display or output is lowest numerical value to highest.

Preference drop-down list

Select the numerical entry that is used as a mechanism for sorting the display of route records in the application or order the output of routes that have the same pub-id and order. The order of display or output is lowest numerical value to highest.

Destination Group($DESTGROUP) drop-down list

Select the numerical entry that is used as the group of public identifiers that have an object in common. That object stores information that can be used to select a subset of the route set for an operation, for example for global replacement.

Description

Enter a description for this route. All routes created with the same pub-id reflect the last (newest) non-empty change made to the Description field.

Format

Select the Format field while adding an import template in SDM. The import template is used while importing CSV files through the UI and/or the REST interface.

Format attribute implies that all next-hop entries under this route entry must have both Priority and Weight fields defined. A Pub-id/Range can either have all entries as weighted or non-weighted. It cannot have both weighted and non-weighted route entries. Check the Format checkbox to select the format as Weighted. If you have selected the Format checkbox, then ensure that both Priority and Weight attributes are selected too.

Priority

Specify only numerical values in the range 0 to 65535. Alphaneumeric and empty values are considered as invalid.
The maximum number of next-hop entries allowed under one route set with the same priority value is 10.

Weight

Specify values that are numerical and multiples of 10 within the range of 0 to 65535. Alphaneumeric and empty values are considered as invalid.

Additional SED Properties menu

Click the arrow icon to expand the following SED property entries that can be mapped to their corresponding CSV file column number:

Imported SED formula—Select the numerical entry for the alphanumeric string that contains an expression used to define string concatenation and text replacement to generate the SED for a route record.
Next Hop ($NEXTHOP)—Select the numerical entry for the IP address, FQDN, session agent name, or session agent group name that can be used in the formula to generate the SED for a route record.
Trunk Group ($TRUNKGROUP)—Select the numerical entry for the alphanumeric string that can be used in the formula to generate the SED for a route record.
Trunk Context ($TRUNKCONTEXT)—Select the numerical entry for the alphanumeric string that can be used in the formula to generate the SED for a route record.
Routing Number ($RN)—Select the numerical entry for the telephone number or prefix that can be used in the formula to generate the SED for a route record.
Carrier Identification Code ($CIC)—Select the numerical entry for the numeric value used in the formula to generate the SED for a route record.
User 1 through User 5 —Select the numerical entry for the alphanumeric value with a user-specific definable meaning that can be used in the formula to generate the SED for a route record. It can also be used for aggregating route records into groups. Once defined, use of this field must be consistent within the route set.
SED Formula—The numerical entry for the alphanumeric string that contains an expression used to define string concatenation and text replacement to generate the SED for a route record.

Click OK.

Edit Import Templates

Expand the Route Manager slider, and click Import Templates.
In the Import Templates tab, select an import template and click Edit.
In the Edit Import Template dialog box, make any edits that you need to the import template parameters.
Click OK.

Copy an Import Template to Create a New Import Template

Expand the Route Manager slider, and click Import Templates.
In the Import Templates tab, select the row of the import template that you want to copy from the table and click Copy.
In the Copy Import Template dialog box, enter a name for the template that you are creating and edit or add parameter entries that appear in this dialog box. See the Import Route Sets section for more information about these parameters.
Click OK when you are finished creating the new import template.