Import External ACD Data

Updated 

This page provides detailed steps for creating a Custom Entity, configuring its fields, and setting up Data Connectors for data ingestion. These are required to create Forecast Scenarios using the Copy Historical Data type.

Create Custom Entity

  1. Navigate to Entity Studio to open the Entity Manager Record Manager.

  2. Click the Create Custom Entity button at the top right of the Entity Manager Record Manager.

  3. Fill in the required fields on the Create Custom Entity page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Entity Name: Enter the name of the Custom Entity. (Required)

    2. Plural Name: Re-enter the name of the Custom Entity. (Required)

    3. API Reference ID: Enter the Custom Entity name without spaces. (Required)

    4. Description: Enter a brief description of the Custom Entity.

    5. Store Data Externally: This toggle is disabled by default.

  4. Click the Create button at the bottom right of the page.

This will create the Custom Entity using the details you entered. However, it will be disabled by default, and you’ll need to enable it manually. Follow these steps to enable the Custom Entity:

  1. Navigate to Entity Studio to open the Entity Manager Record Manager.

  2. Select Custom at the top right to show all Custom Entities.

  3. Enable the toggle under the Status column corresponding to the Custom Entity.

Configure Custom Entity

After creating the Custom Entity, you need to set up the fields required for data ingestion. Follow these steps to configure the Custom Entity:

  1. Navigate to Entity Studio to open the Entity Manager Record Manager.

  2. Select Custom at the top right to show all Custom Entities.

  3. Hover over the required Custom Entity in the Name column, then click the View button.

This will open the page to configure the Custom Entity. Under the Fields and Relationship tab, you will have to create the following fields.

  • AHT Value

  • Volume Value

  • Workload Name

  • Timestamp

  • Concatenated Workload and Timestamp

  • Work Queue.

On the Fields and Relationship Record Manager, click the Create Field button at the top right to create and configure the fields. The steps below explain how to configure each field.

Note: It is recommended to keep all other settings at their default values, except for the fields listed below.

AHT Value

Field

Value

Field Type

Number

Name

"AHT Value"

API Reference ID

"AHT_Value"

Mandatory Field

Disabled

Volume Value

Field

Value

Field Type

Number

Name

"Volume Value"

API Reference ID

"Volume_Value"

Mandatory Field

Disabled

Workload Name

Field

Value

Field Type

Text

Name

"Workload Name"

API Reference ID

"Workload_Name"

Mandatory Field

Enabled

Timestamp

Field

Value

Field Type

Datetime

Name

"Timestamp"

API Reference ID

"Timestamp"

Placeholder

"dd/MM/yyyy HH:mm"

Date Format

European

Time Format

24 Hour

Mandatory Field

Disabled

Concatenated Workload and Timestamp

Field

Value

Field Type

Text

Name

"Concatenated Workload and Timestamp"

API Reference ID

"Concatenated_Workload_Timestamp"

Placeholder

"Enter Concatenated Workload and Timestamp"

Mandatory Field

Disabled

Work Queue

Field

Value

Field Type

Text

Name

"Work Queue"

API Reference ID

"Work_Queue"

Placeholder

"Enter Work Queue"

Default Value

"67a095be52a9c26959e67f16"

Mandatory Field

Disabled


Create Data Connector

Once you have created the Custom Entity and configured the required fields, you will need to create a Data Connector to populate data in those fields. This is done from the the Unified Data Connector (UDC) module.

Follow these steps to create a Data Connector to import external ACD data:

  1. Navigate to Unified Data Connector on the Launchpad. This will open the Data Connectors record manager.

  2. Click the Install Connector button at the top right of the page. Ensure that Import is selected on the Left Pane.

  3. Select the created Custom Entity in the Entity field on the Entity Selection page.

  4. Click Next to open the Entity Specific Settings page.

  5. Choose Upsert in the Integration Type field on the Entity Specific Settings page.

  6. Click Next to open the Source Selection page.

  7. Fill in the required fields on the Source Selection page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Entity Source: Select File Upload. (Required)

    2. Connector Name: Enter the name of the Connector. (Required)

    3. Description: Enter a brief description of the Connector.

  8. Click Next to open the Source Specific Settings page.

  9. Fill in the required fields on the Source Specific Settings page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Upload Sample File: Upload your historical ACD data file. (Required)

      Advanced Settings

    2. Is Data Encrypted: Enable this toggle if data in the uploaded file in encrypted.

    3. Encryption Algorithm: Choose the algorithm used for file encryption. Supported options are RSA and PGP. (Required)

    4. Original File Extension: Choose the extension of the uploaded file. Supported options are XLSX, CSV, and XLS. (Required)

  10. Click Next to open the Mapping Configuration page. This page allows you to map the source data headers to destination fields in Sprinklr.

  11. For each header mapping, the following options are available:

    1. Header: This column shows the headers available in the file uploaded.

    2. Destination Field: Map the headers to the corresponding fields configured in the Custom Entity.

    3. Sample Value: This field is disabled and not relevant for this configuration.

    4. Validation Rule: Choose the validation type, if any, if the value of the source Header is expected to be in a specific format, such as email IDs, mobile numbers, or custom patterns using Regex.

    5. Mandatory: Enable this toggle to enforce mandatory Header mapping during ingestion.

  12. Click Next after mapping the fields from your file to the custom entity fields.

  13. Fill in the required fields on the Additional Settings page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. User / User Groups: Specify the Sprinklr Users/User Groups who can view the data. The Notifications section below will be accessible only when Users/User Groups are selected.

      Notifications

    2. Notification Type: Choose how the notification should be sent the the Users/User Groups.

    3. Users to Notify: Choose the Users/User Groups who will receive the notifications.

  14. Click the Save button to save and create the Connector configuration.

Manually Run Data Connector

This will create the Data Connector. Once created, you’ll need to run it to start ingesting data. Follow these steps to manually trigger a run of the Data Connector:

  1. Navigate to the Data Connectors Record Manager.

  2. Click the vertical ellipsis (⋮) icon corresponding to the relevant Data Connector. This will show a list of options.

  3. Select Run to open the Runtime Connector Details page.

  4. Upload the file that contains the actual data to be ingested into the Sprinklr system.

  5. Click Run at the bottom right of the page.

This will trigger the manual run upon which you will receive a notification confirming the same.