Work with the Data Store
What is the Data Store?
The Data Store feature is an internal data storage system located on MongoDB that allows users to design a schema and import data from .csv files directly into Hero Platform_ to use in business automations.
This feature allows for data to be added directly to Hero Platform_ that can be used in business processes.
- Name - The name of the Data Store file.
- Version - The specific version of the Data Store file.
- Creator - The user who created the Data Store file.
- Last modified - The last time the Data Store file was saved.
- Size - The size of the Data Store file.
- Actions - Configuration settings for the Data Store file.
Create a New Schema
- Enter a name for the schema.
- Click Add field.
- Enter a field name and assign the field a data type.
- Click Add field to enter additional fields and data types as needed.
- After all the fields have been added, click OK to save the schema.
- The created schema now appears in the Data Store list on the overview page.
Import Schema
The Data Store import feature supports importing fields with a native data type but does not support importing fields with the List data type.
- Enter a name for the schema.
- Click Choose file and select a CSV file that contains the schema.
- Click Next.
- Select the schema delimiter.
- comma: ","
- simi colon: ";"
- /t (TAB)
- vertical bar: "|"
- Mark if headers are present in the schema.
- If headers are present, mark if the header case should be upper, lower, or the the original as imported.
- Select the character set.
- Select the field detection strategy.
- Detect field data types.
- Convert all field data types to strings.
- Click Next.
- Review or edit the mapped fields.
- Click Next to save the schema.
Edit a Schema
To edit a schema:
- Click the settings icon and select Edit.
- When finished editing the schema, click OK to save.
Hero Platform_ protects schemas used in Data Store Inputs, Data Store Outputs, and Robin skills so that they cannot be accidentally modified or deleted.
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:
- Double-click the schema name or click the settings icon and select Show Data.
- Click Import data.
- Browse for a .csv file with data for the schema.
Click Next. - Configure the csv settings.
Click Next. - 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:
- Double-click the schema name or click the settings icon and select Show Data.
- The data in the schema is displayed.
- 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. - When complete, click the Close.
Hero Platform_ protects schemas used in Data Store Inputs, Data Store Outputs, and Robin skills so that they cannot be accidentally modified or deleted.
When filtering column names in a schema, note that the sorting filter is case sensitive and upper case letters come before lowercase letters.
Example: "Z" is sorted before "a"
Export Schema Data
The Data Store export feature supports exporting all fields with any data type. This can cause a problem because importing schema data does not support importing fields with the List data type.
To export the schema data to a .csv file:
- Double-click the schema name or click the settings icon and select Show Data.
- Click Export data.
- The .csv file is exported to the computer's default download folder.
Clone a Schema
To clone/copy a schema:
- Click the settings icon and select Clone.
- Click Yes, Clone to continue.
- 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)" - 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:
- Click the settings icon and select Delete Data.
- Click Yes, Delete to delete all data records within the schema.
or
- Double-click the schema name or click the settings icon and select Show Data.
- Click Delete all.
- Click Yes, Delete to delete all data records within the schema.
Delete Individual Schema Records
To delete individual schema records:
- Double-click the schema name or click the settings icon and select Show Data.
- Navigate to the record for deletion and click the X icon under the actions column.
- 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:
- Click the settings icon and select Delete Schema.
- Click Yes, Delete to delete the schema.
Hero Platform_ protects schemas used in Data Store Inputs, Data Store Outputs, and Robin skills so that they cannot be accidentally modified or deleted.
Knowledge Graph
A Knowledge Graph is a schema with one or more fields that contain data of possible OCRed results. Using OCR features in combination with a Knowledge Graph increases the results accuracy.
You can designate buckets stored in the Data Store to be used as a Knowledge Graph to add additional support for the OCR engine building models or in a Flow with a Knowledge Graph.
Enable
Enable a Data Store bucket as a Knowledge Graph:
Click the settings icon and select Enable Knowledge Graph.
Enabling a Knowledge Graphs with over 150,000 entries may take some time to complete. If no results have been displayed after one or two minutes, please refresh to view the results.
Disable
Disable a Data Store bucket as a Knowledge Graph:
Click the settings icon and select Disable Knowledge Graph.
Refresh
If the data in a Data Store bucket being used as a Knowledge Graph has been updated, it is necessary to refresh that bucket in the Data Store.
Click the settings icon and select Refresh Knowledge Graph.
Maintaining a Knowledge Graph
If a schema designated as a Knowledge Graph is used in a Flow, and that Flow is exported, that Data Store artifact is not automatically set to be exported. This may cause Flows that are imported without the corresponding Knowledge Graph artifact to fail. It is recommended to check that all exports that include a document extractor using a Knowledge Graph specifically include the related Knowledge Graph artifacts in the Data Store.
Values in Knowledge Graph buckets can be added, updated, and/or removed by users at any time. These changes immediately take effect the next time the function runs.