Differences

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

--- transformations:importdataset [2018/08/15 08:26] – dmitry
+++ transformations:importdataset [2021/07/13 13:37] (current) – [Community examples] 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**//||
+|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.|
+|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.|
+|//**EasyMorph Server file settings**//||
+|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.|
+<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]]