CSV Column Assignments

The CSV Column Assignments page guides you through mapping the CSV columns to the Oracle® Session Delivery Management Cloud (Oracle SDM Cloud) properties.

If an existing template was not selected on the File Selection page, the Route drop-down fields are empty and you must assign column names.

Note:

If you map the Session Establishment Data (SED) property to CSV file column, the two formula properties are disabled and the SED is used for the route and the formula.

1. Complete the following fields:

   Operation drop-down list	Select from the following values: Add - Select to add the route. Delete - Select to delete the route.
   Pub-Id drop-down list	Select the numerical entry for the alphanumeric string that contains an expression used to define string concatenation and text replacement to generate the Pub Id for a route record.
   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.
   Next Hop Type drop-down list	Select the type of next hop to be used in the formula to generate the SED.
   Session Establishment Data (SED) drop-down list	Select the applicable SED.
   Order drop-down list	Select the value used to order, by preference, route records or output of routes in the Local Route Table (LRT) that have the same pub-id to display from lowest to highest.
   Preference drop-down list	Select the value used to order, by preference, route records or output of routes in Oracle Communications Route Manager that have the same pub-id to display from lowest to highest.
   Destination Group ($DESTGROUP) drop-down list	Select the public identifier group that stores operational route set information.
   Description ($DESCRIPTION) field	Add a description for the route. All routes created with the same pub-id reflect the last (newest) non-empty change made to the Description field.
   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.
   Save As Template field	If the user does not select a Template to Use on the File Selection page, and has made a change to the CSV Column Assignments, they can save the mapping as a new Template File.

2. Click Next.

   Note:

   The following fields are mandatory when importing a CSV file:

   • Operation
   • Pub-Id
   • Next-hop-type
   • SED
   • Range Start (when Pub-Id type is set to Range)
   • Range End (when Pub-Id type is set to Range)

   The Confirmation page appears.