OMrun Help Online Manual for OMrun Version 4

Plug-in XML Converter


OMrun Program Object Icon

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

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

Database Single Conversion

"@param1" (Input file) [mandatory]

  • Description: Source location incl. file name + extension
  • Syntax: <full path>\<file name>.xml
  • Example: "c:\Input\Data\Test.xml", "c:\OMrun\Results\Result.tor"

"@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.

"@param3" = <Empty>

"@param4" = <Empty>

Flatfile Single Conversion

"@param1" (Input file) [mandatory]

  • Description: Source location incl. file name + extension
  • Syntax: <full path>\<file name>.xml
  • Example: "c:\Input\Data\Test.xml", "c:\OMrun\Results\Result.tor"

"@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

"@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)

"@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

"@param1" (Input file) [mandatory]

  • Description: Source location without file name
  • Syntax: <full path>
  • Example: "c:\Input\Data", "c:\OMrun\Results"

"@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

"@param3" = <Empty>

"@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\OMIS\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