Export schedule and status maintenance

Provisioning data can be exported to an ASCII file in either XML or CVS format using the application user interface. The SDS Maintenance Export pages allow you to view the status, progress, and data count information for scheduled provisioning exports. You may use exported records to do data manipulation of subscriber data.

Note:

Export is a time consuming operation recommended to be scheduled during off-peak hours. SDS operators can schedule one-time or recurring exports.
Exported data may also be offloaded to a remote server. The exported text file is also available to be downloaded from the file transfer area. Export is a periodic task. Any changes done to the export table take effect on next export period. The following is the functionality of Export:
  • You can configure and schedule data export on daily, weekly, or monthly.
  • The exported files are sFTPed or transferred via SSH to a server configured on SDS.
  • Data can be exported to a file in XML, CSV, or HLRR formats to be used as import files for an HLRR.
  • You can export subscriber data (in XML or CSV format) as shown in Table 4-10:

    Table 4-10 Interfaces for Subscriber Data Types

    Subscriber Data Type GUI (add, change, delete and query) SOAP and/or XML (add, change, delete and query) XML Export and Import CSV Export and Import SQL Query (from Query Server) HLRR
    Subscriber yes yes no no yes yes
    MSISDN yes GUI (add, change, delete and query) SOAP and/or XML (add, change, delete and query) XML Export and Import CSV Export and Import SQL Query (from Query Server)
    IMSI yes yes yes yes yes yes
    MSISDN Prefix yes yes no no no yes
    IMSI Prefix yes yes no no yes yes
    MSISDN Blacklist yes yes no no yes yes
    IMSI Blacklist yes yes no no yes yes
    Domain Identifiers yes yes yes yes yes yes
    Local Identifiers yes yes yes yes yes yes
    NAI Hosts yes yes yes yes yes yes
    NAI Users yes yes yes yes yes yes
    Destination yes yes no no yes yes
    Destination Map yes yes no no yes yes