overview
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
overview [2020/11/26 16:38] – dmitry | overview [2021/01/14 18:59] – [Data import] dmitry | ||
---|---|---|---|
Line 9: | Line 9: | ||
* Text files with fixed width columns | * Text files with fixed width columns | ||
* Excel spreadsheets (.xlsx, .xlsm, .xls) | * Excel spreadsheets (.xlsx, .xlsm, .xls) | ||
- | * XML files | + | * XML and JSON files |
* Google Sheets | * Google Sheets | ||
* SharePoint lists | * SharePoint lists | ||
Line 22: | Line 22: | ||
Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once. | Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once. | ||
+ | |||
+ | [[https:// | ||
+ | [[https:// | ||
+ | |||
==== Actions ==== | ==== Actions ==== | ||
Line 34: | Line 38: | ||
{{:: | {{:: | ||
- | Actions are executed consequently, | + | Actions are executed consequently, |
- | The final state (or result) of a table is the result of all actions of this table applied consequently, | + | The final state (result) of a table is the result of all actions of this table applied consequently, |
Some actions (e.g. [[transformations: | Some actions (e.g. [[transformations: | ||
==== Expressions ==== | ==== Expressions ==== | ||
- | Some actions can use [[syntax: | + | Some actions can use [[syntax: |
+ | |||
+ | As of version 4.5 EasyMorph more than 130 functions can be used in expressions: | ||
+ | |||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
==== Derived tables ==== | ==== Derived tables ==== | ||
Line 66: | Line 80: | ||
* EasyMorph datasets (.dset) | * EasyMorph datasets (.dset) | ||
- | ==== Automation | + | ==== Workflow automation |
- | EasyMorph workflows can have following automation: | + | EasyMorph workflows can perform external actions, for instance: |
* File and folder operations (copy/ | * File and folder operations (copy/ | ||
* Running external applications, | * Running external applications, | ||
Line 73: | Line 87: | ||
* Embedded PowerShell scripting | * Embedded PowerShell scripting | ||
+ | A workflow can be composed using advanced patterns: | ||
+ | * FOR..EACH type of loops (iterations) | ||
+ | * DO..WHILE/ | ||
+ | * IF..THEN..ELSE type of conditional branching | ||
+ | * Subroutines | ||
+ | * Error recovery | ||
+ | |||
+ | Workflows can have complex hierarchical structure when a project can consist of multiple modules, and each module can consist of multiple table groups. Such a structure allows designing and navigating workflows with hundreds of transformation steps (actions). | ||
==== Integration with external systems ==== | ==== Integration with external systems ==== | ||
EasyMorph workflows can also integrate and interact with external systems and applications. | EasyMorph workflows can also integrate and interact with external systems and applications. | ||
Line 96: | Line 118: | ||
==== Command-line execution ==== | ==== Command-line execution ==== | ||
- | EasyMorph projects can be executed from command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. | + | EasyMorph projects can be executed from the command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. |
+ | |||
+ | A more robust integration option is the " | ||
==== EasyMorph Server ==== | ==== EasyMorph Server ==== | ||
[[https:// | [[https:// | ||
+ | |||
+ | ==== EasyMorph Community ==== | ||
+ | |||
+ | The [[https:// | ||
+ | |||
**See also:** | **See also:** | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// | ||
- | * [[https:// | + | * [[https:// |
+ | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry