XML Converter

Abstract

Plug-in to import XML files "xml" into the built-in test database or/and convert it into "csv" flat files within OMrun.

The system works with the following data formats:

• *.xml (Standard xml file structure)

• *.tor (OMrun test result xml files)

The XML plug-in supports 4 different types of conversation:

• Database Multi Deletion Deletes all data tables in the built-in test database of OMrun.

• Database Single Conversion Loads an xml file into the built-in test database of OMrun. Deletes tables with the same system prefixes in advance.

• Flatfile Single Conversion Converts an xml file into a csv output file.

• Flatfile Multi Conversion Converts all xml / tor files within a defined directory to csv output files.

Creates a header file for every unique named loaded xml file. The header file allows to get fix attribute names, even the load does import different struktures for the same schema. It is possible to write a consisent query that does not change. It is possible to delete attributes from the header list which are of no interest. They are not loaded anymore.

Every xml file load creates a query to read the loaded content and the schema of the loaded xml structure. (Single Conversion only)

---

Input

Execution parameters to invoke a conversion:

Database Multi Deletion

Field @param1 = <Empty> Field @param2 = <Empty> Field @param3 = <Empty> Field @param4 = <Empty>

Database Single Conversion

Field @param1 (Input file) [mandatory]

• Description: Source location incl. file name + extension

• Syntax: <full path>\<file name>.xml

• Examples:

"C:\Input\Data\Test.xml"
"C:\OMrun\Results\Result.tor"

Field @param2 (System prefix) [optional]

• Description: System prefix name used as prefix for table names

  • <Empty> uses standard prefix "SourceA".

  • <System prefix> uses defined system prefix, max. char lenght 20

• Example: Nest_Person, OMrun_Person etc.

Field @param3 = <Empty> Field @param4 = <Empty>

Flatfile Single Conversion

Field @param1 (Input file) [mandatory]

• Description: Source location incl. file name + extension

• Syntax: <full path>\<file name>.xml

• Examples:

"C:\Input\Data\Test.xml"
"C:\OMrun\Results\Result.tor"

Field @param2 (Output path) [mandatory]

• Description: Target location of converted files

• Syntax: <full path> (without ending backslash)

• Example: @TestCases\OMrun\Mapping_Business_Rules\Convert_Result_Before_Verify

Field @param3 (Output file) [optional]

• Description: Target file name + extension

• Syntax: <file name>.<extension> (without backslash at beginning)

• Example: Result_Ready2Verify_Amber.csv

• Possible values:

  • <file name>.csv

  • csv (taking input file name and converting into csv)

  • * [or] <empty> (default = File name from @param1 and converted into csv)

Field @param4 (Header definition file) [optional]

• Description: File (csv) with all headers generated from XML file

• Syntax: <file name.csv>

• Example: Filename_HeaderDefinition.csv

• Possible values:

  • <header definition file name.csv> (= File will be converted with this header definition file)

  • * [or] <empty> (=No value converts each file with its own header file generated)

Flatfile Multi Conversion

Field @param1 (Input file) [mandatory]

• Description: Source location without file name

• Syntax: <full path>

• Examples:

"C:\Input\Data"
"C:\OMrun\Results"

Field @param2 (Output path) [mandatory]

• Description: Target location of converted files

• Syntax: <full path> (without ending backslash)

• Example: @TestCases\OMrun\Mapping_Business_Rules\Convert_Result_Before_Verify

Field @param3 = <Empty> Field @param4 = <Empty>

---

Output

The converted file contains 2 additional attributes in front of all other attributes:

• FileName_0 (original file name of XML input file without extension)

• Id_1 (record id of XML input file)

Output format of the CSV file will be ANSI by default. Different formats could be set in config file (admin rights needed): C:\Program Files\dbi\OMrun\BuiltInTests\OMrunPlugIn_XmlConverter.exe.config

Encoding CSV Output Format - It is possible to define the encoding for the csv file:

• UTF8 [with BOM]

• UTF8 without BOM (Default)

• ANSI

• UTF7

• UTF32

• ASCII

• BigEndianUnicode

• Unicode