XML Import to Table

Kalipso - Form - Actions - Actions Description - Group Communications - XML Import to Table

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

Action available for the following operating systems:

Parameters

General

  • Source type - Defines the type of the source. It can be one of:

    • 1. Yes

    • 2. No

  • Source - The name of source.

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.

  • 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

For more information of this trim action please see the functions chapter.

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

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

Last updated