# XML Export from Table

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

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*

* **Target type** - Defines the type of the target. It can be one of:
  * 1\. Yes
  * 2\. No
* **Encoding** - Indicates the file encoding to use. It can be one of:
  * 1\. Unicode UTF-16 LE (each character uses 2 bytes)
  * 2\. ANSI/BINARY (each character uses 1 byte)
  * 3\. Unicode UTF-8 (each character uses 1 byte to 4 bytes)
* **Target** - The name of the target. User must define a control or a variable to be a target. Also is possible to save in a file, by defining the complete path and name to the file.
* **Database Profile** - The name of the Database Profile defined.
* **SQL** - The SQL code to define the Database Table.

{% hint style="info" %}
For sub-queries, you can use function **COL\_EXPORT**(tableIndex, colIndex) for accessing parent Tables columns to use as filter in your SQL query.
{% endhint %}

* **XML Prefix** <*string*> - The XML Prefix to each XML Element.
* **XML Suffix** <*string*> - The XML Suffix to each XML Element.
* **Decimal Separator** - Defines the separator to use when exporting numeric values.

*Group Element*

* **XML Group Element** <*string*> - The name of the XML Element that user wants to export to the file.
* **Attribute Name** <*string*> - The name of the element's attribute.
* **Attribute Value** - The value to save in the file.

*Column List*

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

{% hint style="info" %}
In Unicode UTF-16 LE, the BOM (Byte Order Mark) 0xFEFF will be added to the beginning of the file.
{% endhint %}

{% hint style="info" %}
In Unicode UTF-8, no BOM (Byte Order Mark) will be added.
{% endhint %}

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