XML Export from Table

Kalipso - Form - Actions - Actions Description - Group Communications - XML Export from Table

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

Action available for the following operating systems:

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.

• 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.

In Unicode UTF-16 LE, the BOM (Byte Order Mark) 0xFEFF will be added to the beginning of the file.

In Unicode UTF-8, no BOM (Byte Order Mark) will be added.

The actions File Open and File Close don't need to be used.