Structured Import Example

This example is designed to provide a simple introduction to the ability to ingest structured data using Structured Import configurations.

In this scenario, an Excel spreadsheet contains two tabs: Employee and Call Centre Data.  

In the first use case, you want to capture the Employees and Departments, with a link identifying which Employee works in each Department.

In the second use case, you want to examine the Call Centre log to link Customer Sentiment to Employees, the Reason for the call and the Channel used to seek help.

This information will help reveal any problem areas with Customer Service support.

You can:

• Download a zip file which contains:

  • a sample Excel data file, and

  • three example Structured Import configurations.

• Import the configuration files into a new or existing project.

• Ingest the Sample File into a Collection using one of the imported configurations to view the results of each configuration.

• you can modify the configurations to test the features of Structured Import.

For more information about Structured Import, see Add (Ingest) Documents and Load Structured Data.

This example is designed to work in Sintelix 8.  

Click on the link below to download the example project:

Download

The download includes one Sample File and three Configuration Files.

The sample Excel file contains two tabs:

• Employee Management Data

• Call Centre Data

See Structured Import Example: Sample File for more information about the sample file.

There are three configuration files:

• Demo-Simple

• Demo-Filtered

• Demo-Linking

See Structured Import Example: Config Files for more information about the configuration files.

You can import the configurations into a new project or existing project.

To import the configuration:

1. Select Configurations > Structured Import

2. Select the Import tab at the bottom of the configurations pane and choose the file you want to import.

   See Import for more information on importing a configuration.

You can now view and apply the configurations to the sample file. You can copy a configuration and change settings to see the impact of the changes.

Once you have imported the configuration, you can apply the configurations to the sample file provided.

To ingest the sample file you need to:

1. Select Collections

2. Create a collection

3. Select Add Documents > Local Files (via upload)

   See Add (Ingest) Documents.

4. Select the Structured ingestion option (See Structured Ingestion).

5. Select one of the Structured Import configurations you imported, for example, Demo-Simple.

   Result: Messages are displayed showing the status of the configuration.

   See Structured Ingestion Messages.

6. If you selected the Demo-Filter configuration, enter a value for the filter, for example enter "Customer" to only ingest Employees in the Customer Service Department. (See Prompt for Filter Parameter.)

7. Upload the sample file.

   See Add from Local Files.

   Result: The document is ingested. Each row becomes a Document in the Collection, and the defined nodes and links are generated in the Network.

You can make changes to any of the configurations to explore the effect of different settings have on the results.

The structured import configuration defines the content of the documents and the structure of the Network. Therefore, you need to rebuild the documents and Network to see the effect of any changes made to a configuration.

If you don't, you may not see the effect of the changes made to the configuration.

Therefore, if you make changes to a configuration after the sample file has been ingested and a Network has been generated, then before ingesting the sample file again, you need to:

• delete all the documents in the collection (See Delete Documents)

• delete the Network (See Delete a Network).

Alternatively, you can:

• create a new collection, and

• ingest the sample file using the updated configuration into the new collection.

This allows you to compare the before and after results.

The following videos demonstrate the different tabs in the Structured Import configuration. It is best to watch them in sequence. These demonstrations are based on using the example structure import configurations and sample file provided with this example.