Differences

This shows you the differences between two versions of the page.

--- transformations:importdataset [2018/08/15 08:26] – dmitry
+++ transformations:importdataset [2024/08/14 00:34] (current) – update with metadata options craigt
@@ Line 1: / Line 1: @@
-===== Import dataset =====
+{{ transformations:ImportDatasetAction.png}}
+====== IMPORT DATASET (.dset) ======
+Category: Import / File\\
-This action imports a dataset (tabular data) from a file in the native EasyMorph format (.dset). The native format allows very fast loading data into EasyMorph as there is no data conversion.
+\\
+=====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.
+One .dset file contains one dataset.\\
-==See also==
+\\
+=====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<sup>*</sup>| 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//.|
+<sup>*</sup> Setting can be specified using a [[:parameters|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<sup>*</sup>|Select the pre-configured connector to the EasyMorph Server.|
+|Path<sup>*</sup>|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//.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].
+\\
+=====Remarks=====
+This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\
+\\
+=====Community examples=====
+  * [[https://community.easymorph.com/t//1769/1|How to do recursive loops in EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/qM6kmqrDRWiEDJFljIa2u6QWre1.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Loop//; Action position: //4//)
+  * [[https://community.easymorph.com/t//1854/2|Product of Rows in a Column
+]] ([[https://community.easymorph.com/uploads/short-url/8o7F1FHzlEr0hUV2BgCLFNEMKqk.morph|Project]]; Module: //Multiply line//; Group: //Tab 1//; Table: //Imported table 1//; Action position: //1//)
+  * [[https://community.easymorph.com/t//2185/4|Transform parsed JSON to right format
+]] ([[https://community.easymorph.com/uploads/short-url/z1JsbbyueYletNwNg1VlSef2C4C.morph|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.
+\\
+=====See also=====
   * [[transformations:exportdataset|Export dataset]]