{{ transformations:ImportDatasetAction.png}}
====== 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<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]]