If you have a dataset or are transferring data from another system, you can import your data into Engyn to create new objects and organize your information. By preparing your data in a supported format, you can ensure a smooth import process and minimize the need for manual adjustments. This guide will walk you through the steps to properly format your data, upload it to Engyn, and review or update data types to ensure accuracy.
1. Prepare the File
Before importing, ensure your data is properly formatted in either CSV or Excel file formats. Engyn will automatically recognise the data types of each column if they follow the required format. For columns with unrecognized data types, Engyn will default them to text, but you can update these data types later after the initial data import.
Recognized Format
Example | Data Type | Sub Data Type |
|---|---|---|
TRUE, False (case insensitive, empty value will be ignored) | Boolean |
|
1 or -1 | Number | Integer |
1.0 or 1.1 or -1.1 | Number | Decimal |
2024-07-12T04:26:50 | DateTime | DateTime |
2024-07-12T04:26:50+00:00 | DateTime | DateTimeUTC |
2024-07-12 | DateTime | Date |
05:56:59 | DateTime | TimeOfDay |
09:31:38+00:00 | DateTime | TimeOfDayUTC |
f3f462aa-e710-4e8b-ad98-1c84a8814efe | Unique Identifier |
|
2. Import File to Engyn
To upload your file:
Navigate to the Dataset section of Engyn.
Under My Collection or Shared Data, hover over the target Space and click on the three-dot menu.
From the dropdown, select Import.
Enter a name for your dataset and upload your prepared file.
3. Review and Update the Data Type
After importing, it's important to review and update the data types for accuracy:
In the same section, hover over the dataset you just imported and click on the three-dot menu.
Select View Schema from the dropdown. This will display the fields in your dataset and their automatically detected data types.
Engyn will detect and assign the most relevant data type for each column based on the recognized data format. If any format is unrecognized, it defaults to text, but you can easily update it:
Click the icon in the top-right corner to enter Edit Mode.
Select any property in the list and adjust its Data Type in the properties panel.
Once all changes are made, click Publish to make the changes live.