transformations:exportdataset
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:exportdataset [2018/08/15 08:26] – created dmitry | transformations:exportdataset [2023/11/24 20:01] (current) – [Remarks] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Export dataset | + | {{ transformations: |
+ | ====== | ||
+ | Category: Export / File\\ | ||
- | This action exports a dataset (tabular data) into 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 exports a dataset (tabular data) into a file in the native EasyMorph format (.dset) | ||
- | One .dset file contains one dataset. | + | One .dset file contains one dataset.\\ |
- | ==See also== | + | \\ |
+ | =====Use cases===== | ||
+ | When working with large datasets that require significant load times, converting the source tables to .dset files and loading those into the workflow can increase overall process performance.\\ | ||
+ | |||
+ | Exporting a dataset into a .dset file that is stored on EasyMorph Server or is encrypted can be more secure than saving it into a CSV file or a spreadsheet. | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |Export to| Select whether the .dset file will be written to a local file (on your system) or to an EasyMorph Server.\\ Options: | ||
+ | \\ | ||
+ | ====Local file settings==== | ||
+ | ^Setting ^ Description ^ | ||
+ | |File< | ||
+ | |File already exists|If a file with the same name already exists, choose whether to overwrite the existing file, rename the existing file,\\ or halt the action' | ||
+ | |Encrypt columns|When checked, one or more columns in the dataset will be encrypted and require a password to access.\\ | ||
+ | < | ||
+ | \\ | ||
+ | ====EasyMorph Server file settings==== | ||
+ | ^Setting ^Description ^ | ||
+ | |Link to Server|Select to use the pre-configured link to an EasyMorph Server. | ||
+ | |Connector< | ||
+ | |Path< | ||
+ | |File already exists|If a file with the same name already exists, choose whether to overwrite the existing file, rename the existing file,\\ or halt the action' | ||
+ | |Encrypt columns|When checked, one or more columns in the dataset will be encrypted and require a password to access.\\ | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Encrypt columns options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Password| Provide the password that will be required to access the encrypted data.| | ||
+ | |Encrypt columns|Select whether to encrypt all columns in the .dset file, or just selected columns (and choose which columns to encrypt).| | ||
+ | |||
+ | \\ | ||
+ | ====Mode options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Create or overwrite|This option will create a new dataset file (if one doesn' | ||
+ | |Append or create|This open will create a new dataset file (if one doesn' | ||
+ | |||
+ | \\ | ||
+ | ====Create or overwrite options==== | ||
+ | //If a file with such name already exists// | ||
+ | ^Option ^Description ^ | ||
+ | |Overwrite|The new file replaces the original file.| | ||
+ | |Rename|The original file will be renamed with " | ||
+ | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
+ | |||
+ | \\ | ||
+ | ====Append or create options==== | ||
+ | //If appended data contains new columns// | ||
+ | ^Option ^Description ^ | ||
+ | |Add new columns|This option will add columns from the exported file that are not found in the existing dataset file.| | ||
+ | |Ignore new columns and warn|This option will ignore (not append) columns in the exported file that are not found in the existing dataset file, display a warning, and the workflow will continue running.| | ||
+ | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
+ | |||
+ | \\ \\ | ||
+ | =====Remarks===== | ||
+ | When importing a dataset (.dset) file with encrypted columns, the [[transformations: | ||
+ | |||
+ | If you do not have access to a dataset' | ||
+ | |||
+ | :!: The encryption password can't be recovered. If it's lost, all the data encrypted with the password will become inaccessible. | ||
+ | |||
+ | \\ | ||
+ | When appending rows to a target file on EasyMorph Server, this action will fail if another workflow modifies the file before appending finishes. | ||
+ | \\ | ||
+ | =====Community examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
+ |
transformations/exportdataset.1534335966.txt.gz · Last modified: 2018/08/15 08:26 by dmitry