# XML Import to Table

Imports from text or a XML file to a Database Table.

Action available for the following operating systems:

![](https://3821468174-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTlA1suFa5N48x_83N%2F-MAlPVpH3WRwBy16c7JY%2F-MAlQBZuuTnc6hyzKSVQ%2Fimage.png?alt=media\&token=5c9534b7-ca05-4ac4-b408-2207cd5a5295)

### Parameters

*General*

* **Source type** - Defines the type of the source. It can be one of:
  * 1\. Yes
  * 2\. No
* **Source** - The name of source.

{% hint style="info" %}
Source XML or Source File depending on parameter Source Type. If it is a Source File user must define the complete path to the file, otherwise user must defines the control or variable that stores the XML File.
{% endhint %}

* **Abort on Error** - This parameter defines if the user wants to abort in case of error or not. It can be one of:
  * 1\. Yes
  * 2\. No
* **Target Table** - The name of the Database Table where that action takes effect.
* **Replace Duplicates** - This parameter defines if the user wants to replace the duplicate values or not. It can be one of:
  * 1\. Yes
  * 2\. No
* **Trim Strings** - This parameter defines if the user wants to trim the strings or not. It can be one of:
  * 1\. Yes
  * 2\. No

{% hint style="info" %}
For more information of this trim action please see the functions chapter.
{% endhint %}

* **Decimal Separator** <*string*> - Defines the separator to use on the importation of numeric values.
* **Ignore Prefix** - Defines if the user wants to ignore the prefix or not. It can be one of:
  * 1\. Yes
  * 2\. No
* **Parent Element** <*string*> - The name of the parent Element of the XML file.

*Group Element*

* **XML Group Element** <*string*> - The name of the XML Element that user wants to import in the Database Table.
* **Attribute** <*string*> - The name of the element's attribute.
* **Target Column** - The Column of Database Table that saves the attribute's element.
* **Type** - The type of element to save in Database Table. Could be string or numeric.

*Column List*

* **Element** <*string*> - The XML element to save in Database Table.
* **Type** - The type of the XML Element to save in Database Table.
* **Value** - The value to save in Database Table.

*Default Values*

* **Column** - Name of the column that user wants to save a default value.
* **Type** - Type of the default value saved.
* **Source Type** - Type of the source to save, by default, in Database Table.
* **Source** - Value to save, by default, in Database Table.

{% hint style="info" %}
The actions File Open and File Close don't need to be used.
{% endhint %}