QDI Mapping file structure

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, offset, length, type, key, default

Table 1

Field	Meaning
fieldName	This is the field in the givne table that the values will be mapped to.
offset	The character offset at which the value will be found in the data file.
length	The acceptable length of the field in the data file.
type	The field type.
key	Denotes whether or not this is the primary key of the table.
default	Default field value.