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	Values
fieldName	This is the field in the given table that the values will be mapped to.	Will be a string relating to a column name.
offset	The character offset at which the value will be found in the data file.	Will be a number.
length	The acceptable length of the field in the data file.	Will be a number.
type	The field type.	"N" - numeric, "D"/"T" - Date/Time, "S" - String
key	Denotes whether or not this is the primary key of the table.	"T" - True, "F" - False
default	Default field value.	Depends on the field type.