CSV Files

The following CSV file fields must be specified to import a CSV file that is used to build XML route tables:

• operation—Add or delete operations for routes in a route set
• public identifier (pub-id)—A public identifier in the form of a telephone number or prefix (for example, NPA-NXX) used in LRT lookup. It is referred to in the LRT XML as object “user” of type “E164”. The Pub Id (or the Pub Id formula and the associated fields required to generate Pub Id): identified in the LRT XML as the object “next” of type “regex”. The Pub Id can be a string value if the route set’s Pub Id type is set to string. Pub Id can be directly imported or edited or it could be the result of the record’s formula. The regex in the LRT file is the URI scheme used by the network attribute to route the call.
• Session establishment data (SED or the SED formula and the associated fields required to generate SED)—Identified in the LRT XML as the object “next” of type regex. SED can be directly imported or edited or it could be the result of the record’s formula. The regex in the LRT file is the URI scheme used by the network attribute to route the call.

  Note:

  Any other combination of fields can be empty, unless they are included in the formula field of the record for which an error should be reported in the import log. A formula specified in Oracle Communications Route Manager during import is applied globally and stored with each record during the import operation. A value supplied in the formula field of a record has precedence over the formula specified in Oracle Communications Route Manager during the import process. The order and preference determines the order of the numbers in the XML file. The lowest number appears first.