XML Converter
Last updated
Last updated
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)
Execution parameters to invoke a conversion:
Field @param1 = <Empty>
Field @param2 = <Empty>
Field @param3 = <Empty>
Field @param4 = <Empty>
Field @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"
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>
Field @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"
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)
Field @param1 (Input file) [mandatory]
Description: Source location without file name
Syntax: <full path>
Example: "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>
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
