SSC database needs
to provision subscriber profiles, so that IPCF can process the policy
rules using these profiles from SSC and enable the subscriber specific policy
control. SSC provides a mechanism to bulk load this profile data,
provided that such data is available in specified CSV format as
shown below.
<MSISDN,IMSI,TIER_NAME,ENABLE_EMAIL,SUB_EMAIL,ENABLE_SMS,SUB_STATUS,PLAN_NAME,SUB_OPT_OUT,BILL_START_DT,SUB_TYPE,SUB_ORDER,SUB_START_DT,FLAG_LIST
>
The bulk load script
Bulk_load_sub is
located in localhome/ssc/tools folder.
You need to execute this script with administrative user privileges,
ensuring that Oracle is up and running during the provisioning process.
Depending upon composition
of the subscriber profile, CSV file may contain fields similar to
following fields:
-
Mobile Subscriber ISDN
Number (MSISDN): A character data type that indicates subscriber’s
MSISDN.
-
International Mobile
Subscriber Identity (IMSI): A character data type that indicates
subscribers IMSI.
-
Tire Name: A character
data type that indicates the subscription tire associated with this
subscriber.
-
Enable E-mail: A
numeric data type that indicates e-mail is being used to send the
notifications to this subscriber.
-
Sub E-mail: A Character
data type that indicates e-mail address of the subscriber.
-
Enable SMS: A numeric
data type that indicates SMS is being used to send notifications
to this subscriber.
-
Sub status: A numeric
data type that indicates current status of the subscriber. Value
1 indicates active status value 0 indicates in-active status. Depending
upon your business model, you can use additional values to indicate
current status of the subscriber.
-
Service or Data Plan
Name: A character data type that identifies name of service
or data plan associated with the subscriber.
-
Sub Opt Out: This
is a numeric data type.
-
Billing Start Date:
A date data type that indicates the date on which billing is started
for this subscriber.
Following is a sample
of bulk load in CSV format for above mentioned configuration:
77777777777777,777777777777777,GOLD,0,Bye,0,10,VOD,1,21-Apr-2012,10,1,22-Apr-2012,URL=Rediff;URL=Facebook;URL=Google
Where
URL is attribute name and Rediff,Facebook,Google are attribute values.