Export Service User Guide

Overview

Export Service is a dedicated service that allows OCP users to gain access to their raw application data. The Exports UI is accessible to all OCP users, however only users with privileged rights may create a new export or download data. 

Contact the Customer Support team for additional access rights.

To access Export Service, go to Insights → Export Service in the side panel.

As such, the Export provides information about the following:

• Archive

• Subscriptions

• Exports Request board

• Create an export

Data Compliance

Omilia OCP® Data Warehouse and Export Service comply with General Data Protection Regulation (GDPR) requirements. For any data type exported from OCP, through Export Service, the OCP users are responsible to ensure that their exported data are handled accordingly and meet necessary regulations.

Archive 

The Export Service Archive provides information about the total number of export requests per OCP Group to which the user has access. Users can select the desired group from a dropdown list of available groups they have access to.

Subscriptions

Subscription functionality within the Export Service of Omilia OCP® empowers users to subscribe to message channels, facilitating the receipt of near real-time data streams. This feature is instrumental for users seeking dynamic insights, enabling them to stay abreast of updates in call detail records, dialog events, and user activity trails. The structured Subscription process, complemented by robust data compliance measures, ensures users have a seamless and compliant experience in managing and leveraging their raw application data within the OCP ecosystem. The message channels are organized by data type. 

Currently, the following data types are supported:

• CDRs:

  • dialog_start

  • dialog_end

  • dialog_step

• Audit Data (OCP User activity trails, like create app, delete app):

  • Audit_events

Currently Audit_events may be available on particular environment. Reach out to your Account Manager for more details.

For information about Streaming functionality availability, please coordinate with your Account Manager since it may retrieve additional costs.

To subscribe, proceed as follows:
1. Select the targeted entity you want to subscribe to, and click the corresponding button.

2. Fill in the Subscription form and click Save when finished:

• Subscription name - give a name to your Subscription according to validation rules.

• OCP Group - The group the export request belongs to (preconfigured).

• Connections - Connection fields for Clients API in order to enable Subscription to their API.

  • API Path - The callback path where the data is going to be sent to.

  • Type - The type of protocol (for example, http or https).

  • Token Path - The clients URI to use in order to get the token.

• Authentication

  • Auth_Type - The open autorization type (oauth2 - preconfigured).

  • Auth_ID - The client ID used to retrieve oauth2 jwt token from client.

  • Auth_Secret - The client secret used to retrieve token from client.

Read more about the fields and how to create a request in the Export API document.

3. Once created, you see a success message and your subscription will be Active. You can cancel your subscription by simply clicking the Unsubscribe button.

Export Requests board

​⁠All the submitted batch exports are located as a list on the Exports board with most recents ones always displayed first. 

The listed exports contain the following information: 

• Name: The dedicated Name for this export request.

• Job ID: The unique ID for the export request.

• Status: The status of the export request, can be split into three categories.

  • Submitted - The export request was submitted successfully.

  • Processing - The export request is being processed (collecting info to make the request). 

  • Running - The export request is running after being processed.

  • Completed - The export request was completed and data are available for export.

  • Failed - The export request wasn’t completed successfully. 

  • Expired  - The data are not longer available for export.

• Group: The OCP Group the export request was made for.

• Submitted Date: the date the export request was made. 

Data is available for download only for 24 hours after the export request was completed successfully. 

Additional Exports Metadata 

By selecting the (i) tooltip, the user may also view additional information about the exports requested. This includes the data types for each export request, and the date range the data were requested for. 

Create an Export

OCP users with privileged access rights can create a new Export request by clicking the Create an export button at the top right of their screen. 

When the Create an Export button is clicked, the following parameters should be filled in the pop-up window:

• Date Range: The selected date time the user wants to export data from.

• Group: The name of the OCP group the user wants to make an export request. Can be selected from the dropdown list of the available ones.

• Name: The selected name for the export request.

• Data Type: The data the user wants to export from OCP. Can be selected from the dropdown list of the available ones. Navigate to the Supported Data section to learn more.

Click the Create button to finish. The success message will appear on the top right of your screen.

After that, you will see the new export on top of the exports requests list as submitted. 

You can not have two different export requests for the same OCP group being processed at the same time. If you want to make multiple export requests for the same data and OCP groups, the first request needs to be completed, and only after that you proceed with the next request. 

The new export request may have a minimum timespan of the 1 hour data and maximum of 48 hours. Data is NOT available real time for batch export requests but has a latency of at least 2 hours. If the data is not available for export, you will receive the “Data is not available for exports” message.

Downloading Data 

After a successful export request (depends on the size of the export request), and some period of processing, the data will be available to be downloaded. The available data for download have the Ready status along with a Save icon you need to click to start the downloading process.

Depending on the size of the exports, this process can take a couple of minutes with resulting in one or more ZIP files. 

In the event of large exports, where multiple files are generated, it is common for the export process to pause momentarily due to rate limiting, before proceeding with the remaining files. This is automatically managed by the Export Service as part of its rate limiting configuration.

Export ZIP file

The downloaded Export ZIP file has the respective Export ID on it with the order number in case of multiple files from the same export request.

The Export Request ZIP example of single file can be found below:

export_e3c9908c-595f-4d2a-9333-147f3ae00045_(1_of_1).zip

Where the (1_of_1) refers to file 1 out of 1 total files for this export ID. 

The downloaded ZIP files have the following file paths: 

Exports -> message type (ex message_type=dialog_end) -> date= data time of exported data (example date=2023-09-04-22) -> group = OCP Group name (example group=ocp_test ) -> DownloadedJSONs.json

The example of valid export file path is provided below:

~/exports/message_type=dialog_end/date=2023-09-04-22/group=ocp-qa/diamant-events+0+0334990378.json

The file splits are based on default optimal configurations to make the exports optimal and avoid delays during processing. 

OCP Data has UTC timestamps. 

Supported Data 

Export Service supports the following OCP Data: 

• Call Detail Records

  • Dialog Start 

  • Dialog End 

  • Dialog Step

By selecting Dialog Data, the user is requesting all three Start, End and Step files within the same request. 

More information about OCP Data can be found within CRD Models Schema guide.

Export API 

If you want to build a more automated process for creating Exports, visit the Export API document for more information.

The Export API document is available for the OCP users who have access to Export Service to create export requests.