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.

Last updated