Work with the Tuple Store

What is the Tuple Store?

The Tuple Store feature is an internal data storage system that allows users to design a schema and import data from .csv files directly into Hero_Flow to use in business automations

This feature allows for data to be added directly to Hero_Flow that can be used in business processes.

Create a New Schema

  1. Enter a name for the schema.
  2. Click Add field.
  3. Enter a field name and assign the field a data type.
    1. Click Add field to enter additional fields and data types as needed.
  4. After all the fields have been added, click OK to save the schema.
  5. The created schema now appears in the Tuple Store list on the overview page.

Import Schema

  1. Enter a name for the schema.
  2. Click Choose file and select a CSV file that contains the schema.
  3. Click Next.
  4. Select the schema delimiter.
    1. comma: ","
    2. simi colon: ";"
    3. <blank space>
    4. vertical bar: "|"
  5. Mark if headers are present in the schema. 
    1. If headers are present, mark if the header case should be upper, lower, or the the original as imported.
  6. Select the character set.
  7. Select the field detection strategy.
    1. Detect field data types.
    2. Convert all field data types to strings.
  8. Click Next.
  9. Review or edit the mapped fields.
  10. Click Next to save the schema.

Edit a Schema

To edit a schema:

  1. Click the settings icon and select Edit.
  2. When finished editing the schema, click OK to save.

Add Data to a Schema

After creating a schema, the schema has field names (column names) and is empty with no data.

Add data to the schema by importing a .csv file and pairing the .csv file column names with the schema field names.

To add data to a schema:

  1. Double-click the schema name or click the settings icon and select Show Data.
  2. Click Import data.
  3. Browse for a .csv file with data for the schema.
    Click Next.
  4. Configure the csv settings. 
    Click Next.
  5. Map the fields in the .csv file to the fields created in the schema. 
    Click Save to finish adding data to the schema.

View or Edit Data in a Schema

To view data that has been added to a schema:

  1. Double-click the schema name or click the settings icon and select Show Data.
  2. The data in the schema is displayed.
  3. To edit a data in the schema, double-click within the row to edit.
    Data can be edited from each field in the row.
    Save an edit by click the disk icon under the actions column.
  4. When complete, click the Close.

Export Schema Data

To export the schema data to a .csv file:

  1. Double-click the schema name or click the settings icon and select Show Data.
  2. Click Export data.
  3. The .csv file is exported to the computer's default download folder.

Clone a Schema

To clone/copy a schema:

  1. Click the settings icon and select Clone.
  2. Click Yes, Clone to continue.
  3. A copy of the schema and data is created given an iterative name.
    Example: A schema with the name "User_Data" is cloned to the default name "User_Data_(1)"
  4. Cloned schema names can be changed using the Edit action.

Delete Schema Data

Delete All Schema Data

To delete all the data within a schema:

  1. Click the settings icon and select Delete Data.
  2. Click Yes, Delete to delete all data records within the schema. 

or

  1. Double-click the schema name or click the settings icon and select Show Data.
  2. Click Delete all.
  3. Click Yes, Delete to delete all data records within the schema. 

Delete Individual Schema Records

To delete individual schema records:

  1. Double-click the schema name or click the settings icon and select Show Data.
  2. Navigate to the record for deletion and click the X icon under the actions column.
  3. Click Yes, Delete to delete the record from the schema.

Delete a Schema

A schema cannot be delete if the schema contains data. To delete a schema that contains data, the data from the schema must first be deleted.

To delete a schema:

  1. Click the settings icon and select Delete Schema.
  2. Click Yes, Delete to delete the schema.