Table of Contents
IMPORT DATASET (.dset)
Category: Import / File
Description
This action imports a dataset (tabular data) from a file in the native EasyMorph format (.dset). This format allows very fast loading data into EasyMorph as there is no data conversion.
One .dset file contains one dataset.
Action settings
| Setting | Description |
|---|---|
| Import from | Select whether the .dset file is a Local file (on your system) or stored on an EasyMorph Server. |
Local file settings
| Setting | Description |
|---|---|
| Load file* | Fully-qualified file name of the dataset (includes relative or absolute path). |
| Password | Provide the password to open the dataset, if required. |
| Import | Choose whether to import Data, Data and metadata, or just Metadata. |
| Load all columns | Select if all columns are to be loaded. |
| Load only selected columns | Select if only select columns are to be loaded. A drop-list will appear to select the columns you wish to import. |
| Import metadata | Choose whether to import file metadata and/or custom properties. Options: Import file metadata and Import custom properties. |
* Setting can be specified using a parameter.
EasyMorph Server file settings
| Setting | Description |
|---|---|
| Link to Server | Select to use the pre-configured link to an EasyMorph Server. (Use the Start screen to configure the Server Link if you haven't already done so. |
| Connector* | Select the pre-configured connector to the EasyMorph Server. |
| Path* | Fully-qualified filename of the dataset. |
| Password | Provide the password to open the dataset, if required. |
| Import | Choose whether to import Data, Data and metadata, or just Metadata. |
| Import metadata | Choose whether to import file metadata and/or custom properties. Options: Import file metadata and Import custom properties. |
* Setting can be specified using a parameter.
Remarks
This action can import multiple files. See Importing Multiple Files for more information.
Community examples
- How to do recursive loops in EasyMorph (Project; Module: Main; Group: Tab 1; Table: Loop; Action position: 4)
- Product of Rows in a Column (Project; Module: Multiply line; Group: Tab 1; Table: Imported table 1; Action position: 1)
- Transform parsed JSON to right format (Project; Module: Main; Group: Group 1; Table: Imported table 1.dset; Action position: 1)
Shortcuts
Fast ways to create the action:
- Press the "Add data" menu button. Pick "Import file" or "Import multiple files".
- Drag an EasyMorph dataset file into the application window. Supported file extensions: .dset
- Drag a folder with EasyMorph dataset files into the application window.