1. Provisioning Interface
  2. Interface Description
  3. Data Import
  4. Provisioning Data Import (CSV)

Provisioning Data Import (CSV)

A CSV import file consists of an ASCII text file that contains a series of database manipulation requests in CSV format. Each request must be on a separate line.

An import file can contain as many requests as the storage media used to hold the import file allows. The CSV import process ignores all blank lines and lines that begin with a # character, which are treated as comments.

Table 3-6 shows the supported CSV import formats, examples of each update and delete command, and the import file names.

If the import line has fewer values separated by commas than the number of fields listed in the Format column, the missing fields are treated as unspecified and contain no value. The file names must have the format shown in the table, where X is at least one alpha-numeric character.

Note:

You can only add a subscriber to a subscriber table, if the Account ID, MSISDN, or IMSI is not already in the table. If the table already contains any of these values, the add function fails and an error condition report is generate that contains the reason for the failure.

Table 3-6 CSV Import Formats

Import Type Format/Example File Name
Destination <U|D>, <NAME>, <TYPE>, <FQDN>, <REALM> import_X_destination.csv

U,imsgroup1,imshss,operator.com,imswest

D,aaagroup2

IMSI <U|D>, <IMSI>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_imsi.csv

I,7857857802,,dest2,,,,,,,dest9

U,7857857802,,dest2,,,,,,,dest9

D,7857857803

MSISDN <U|D>, <MSISDN>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_msisdn.csv

I,17857853013,imsgroup13,dest2,,,,,,,dest9

U,17857853013,imsgroup13,dest2,,,,,,,dest9

D,17857853014

NAI User <U|D>, <USER>, <HOST>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_naiuser.csv

U,dptestUser03,dptestHost0,,,dest3

D,dptestUser07,dptestHost0

Wildcard NAI User <U|D>, <WCUSER>, <HOST>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_wcnaiuser.csv

U,dptestUser2,dptestHost0,,,,,,dest20,dest28

D,dptestUser3,dptestHost0

NAI Host <U|D>, <HOST> import_X_naihost.csv

U,dptestHost0

D,dptestHost1

Domain Identifier

<U|D|I>, < DOMAINID>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName>

import_X_domainIdentifier.csv

I,tekelec.com,dest1,,,,,,,,dest9

U,tekelec.com,dest1,,,,,,,,dest9

D,tekelec.com

External Identifier <U|D|I>, <EXTID>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_externalIdentifier.csv

I,test1@tekelec.com,dest1,,,,,,,,dest9

U,test1@tekelec.com,dest1,,,,,,,,dest9

D,test1@tekelec.com

IMSI Prefix <U|D>, <IMSIprefix>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_imsiprefix.csv

U,78578520,imsgroup22

D,78578540

MSISDN Prefix <U|D>, <MSISDNprefix>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_msisdnprefix.csv

U,17857852012,imsgroup24

D,178578540

IMSI Blacklist <U|D>, <IMSI> import_X_imsiblacklist.csv

U,7857851011

D,7857852012

MSISDN Blacklist <U|D>, <MSISDN> import_X_msisdnblacklist.csv

U,17857851011

D,17857852012

Subscriber <U|D|I>, <AccountId>, <IMSI1>, <IMSI2>, <IMSI3>, <IMSI4>, <IMSI5>, <IMSI6>, <MSISDN1>, <MSISDN2>, <MSISDN3>, <MSISDN4>, <MSISDN5>, <MSISDN6>, <ExtId1>, <ExtId2>, <ExtId3>, <ExtId4>, <ExtId5>, <ExtId6>, <ExtId7>, <ExtId8>, <ExtId9>, <ExtId10>, <IMSHSSname>, <LTEHSSname>, <PCRFname>, <OCSname>, <OFCSname>, <AAAname>, <UserDef1Name>, <UserDef2Name>, <MTCHSSName> import_X_subscriber.csv

I,77777777777777777777711111,7774605500,

7774605501,,,,,777771111122222,

777771111133333,,,,,user1@oracle.com,user2@oracle.com,,,,,,,,,imsgroup1,ltehss2,dest3,dest4,,,dest7,dest8,dest9

U,77777777777777777777711111,7774605500,

7774605501,,,,,777771111122222,

777771111133333,,,,,user1@oracle.com,usre2@oracle.com,,,,,,,,,imsgroup1,ltehss2,dest3,dest4,,,dest7,dest8,dest9

D,77777777777777777777722222,,,,,,,,,,,,

Table 3-7 defines the Import Type fields.

Table 3-7 CSV Import Fields

Field Description
<I|U|D> Update or delete record. (I=Insert, U=Update, D=Delete)
<NAME> A unique string of 1-32 characters to identify the Destination
<IMSI> A unique string of 10-15 decimal digits
<IMSIprefix> A unique string of 1-15 decimal digits
<TYPE> Destination type. Values: imshss, ltehss, pcrf, ocs, ofcs, aaa, userdef1, userdef2, or mtchss)
<FQDN> A 1-255 character string for the Diameter FQDN for the destination
<REALM> A 1-255 character string for the Diameter Realm for the destination. Optional
<MSISDN> A unique string of 8-15 decimal digits
<MSISDNprefix> A unique string of 1-15 decimal digits
<IMSHSSname> Name of an IMS HSS destination
<LTEHSSname> Name of an LTE HSS destination
<PCRFname> Name of a PCRF destination
<OCSname> Name of an OCS destination
<OFCSname> Name of an OFCS destination
<AAAname> Name of an AAA destination
<UserDef1Name> Name of a UserDef1 destination
<UserDef2Name> Name of a UserDef2 destination
<MTCHSSName> Name of a MTC HSS destination
<USER> A string of 1-64 characters for the NAI User Name
<WCUSER> A string of 1-64 characters for the wild carded NAI User Name
<HOST> A unique string of 1-64 characters for the NAI Host Name
<ExtId> A string of 3-257 characters for the External Identifier
<DomainId> A unique string of 1-128 characters for the Domain Identifier
<AccountId> A unique string of 1-26 decimal digits, if present
An import can be specified to run in one of the following modes:
  • Blocking – An import runs while updates are blocked on all other PDBI connections. This allows for a logically complete import file created in the fastest time possible at the cost of delaying any new provisioning updates until the import is completed and the transaction is closed.
  • Non-Blocking (Real-time) – An import runs while updates are continued to be received and committed to the database.

Import file names on the remote server must have a suffix of .csv to be automatically downloaded and imported into the provisioning database.