QDI Mapping file structure: Difference between revisions
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: | ||
# Map Settings | <nowiki><pre># Map Settings | ||
TABLENAME:DocumentConcreteDockets | TABLENAME:DocumentConcreteDockets | ||
SYSTEM:QESTLAB | SYSTEM:QESTLAB | ||
DATAFILE:TK*.in | DATAFILE:TK*.in | ||
TRIMLEADINGZEROS:TRUE | TRIMLEADINGZEROS:TRUE</pre></nowiki> | ||
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:
<pre># Map Settings TABLENAME:DocumentConcreteDockets SYSTEM:QESTLAB DATAFILE:TK*.in TRIMLEADINGZEROS:TRUE</pre>
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 |