Category: Import / File
Import data from an XML file. Data elements are specified by an XML path. Optionally, data elements can be further narrowed down by selecting only particular XML elements and/or their attributes. Values and attributes of parent elements are repeated for child elements in order to preserve the relationship between them.
|Load file*||Fully-qualified file name of the dataset (includes relative or absolute path).|
|Decimal separator||Sets whether decimal places are represented by points or commas. Options: Points or Commas.|
|Thousand separator||Sets the character that represents thousands places. Options: Default, Comma, Point or Space.|
|DTD Processing||Sets the parsing mode EasyMoprh will use for DTD definition parsing. See below.|
|Value types||Sets whether EasyMorph will interpret between text and numeric values, or read all data in as text values.
Options: Auto, All text.
|Root XML path*||Options: Table, Table/Columns/Column, Table/Columns/Column/Cells, Table/Columns/Column/Cells/Cell.|
* Setting can be specified using a parameter.
There are three modes that instruct EasyMorph how to parse DTD definitions:
|Prohibit (default)||DTD is not allowed. When DTD is encountered in the loaded XML file the project fails.|
|Ignore||DTD is allowed but ignored. When DTD is present in the loaded XML file it is completely ignored and no error is generated.|
|Parse||DTD is parsed.|
Empty elements (e.g. <tag></tag> or <tag/>) are converted into empty text strings, while missing elements result in empty values (i.e. nulls).
Fast ways to create the action: