Jump to content

QDI Mapping file structure: Difference between revisions

From QESTonline
No edit summary
No edit summary
Line 3: Line 3:
Anything preceded by a '#' is a comment, the first few options are as follows:
Anything preceded by a '#' is a comment, the first few options are as follows:


<nowiki><pre># Map Settings
<pre>
TABLENAME:DocumentConcreteDockets
TABLENAME:DocumentConcreteDockets
SYSTEM:QESTLAB
SYSTEM:QESTLAB
DATAFILE:TK*.in
DATAFILE:TK*.in
TRIMLEADINGZEROS:TRUE</pre></nowiki>
TRIMLEADINGZEROS:TRUE</pre>


In order these suggest:
In order these suggest:

Revision as of 00:30, 18 January 2006

QDI Mapping file for QESTLab concrete dockets:

Anything preceded by a '#' is a comment, the first few options are as follows:

TABLENAME:DocumentConcreteDockets
SYSTEM:QESTLAB
DATAFILE:TK*.in
TRIMLEADINGZEROS:TRUE

In order these suggest:

  • This applies to the DocumentConcreteDockets table
  • This mapping file applies to the QESTLab system
  • It will read in any files which have a filename of the structure TK*.in where the '*' is a wildcard standing for any string of characters.
  • Leading zeros will be trimmed from values.

The rest of the file is structured as follows:

fieldName, value1 , value2, value3 , value4, value5

Field Meaning
fieldName This is the field in the givne table that the values will be mapped to.
value1 This is the character offset at which the value will be found in the data file.
value2  
value3  
value4  
value5