Table of Contents
IMPORT XML FILE
Category: Import / File
Description
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.
Action settings
| Setting | Description |
|---|---|
| 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.
DTD parsing modes
There are three modes that instruct EasyMorph how to parse DTD definitions:
| Mode | Behavior |
|---|---|
| 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. |
Restrictions
- Re-definition of namespaces is not supported. Elements with re-defined namespaces are ignored.
- Multiple default namespaces per element not supported.
- XML validation according to DTD or XDS is not performed.
Remarks
Empty elements (e.g. <tag></tag> or <tag/>) are converted into empty text strings, while missing elements result in empty values (i.e. nulls).
Community examples
- Finding all projects with particular action (Project; Module: Main; Group: Tab 1; Table: Documents; Action position: 3)
- Breaking change in v4.4: Aggregate with Concatenate and grouping (Project; Module: ScanWithModule; Group: Tab 1; Table: Version; Action position: 1)
- Embedded connection - search for type email server (Project; Module: Get connectors; Group: Tab 1; Table: Imported table 1;
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 XML file into the application window. Supported file extensions: .xml
- Drag a folder with XML files into the application window.