QDI Mapping file structure: Difference between revisions

Revision as of 00:47, 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, 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.

@@ Line 17: / Line 17: @@
 The rest of the file is structured as follows:
-fieldName, value1 , value2,  value3 , value4, value5
+fieldName, offset, length,  type, key, default
 {|border = "1"
@@ Line 25: / Line 25: @@
 |fieldName|| This is the field in the givne table that the values will be mapped to.
 |-
-|value1||The character offset at which the value will be found in the data file.
+|offset||The character offset at which the value will be found in the data file.
 |-
-|value2||The acceptable length of the field in the data file.
+|length||The acceptable length of the field in the data file.
 |-
-|value3||The field type.
+|type||The field type.
 |-
-|value4||Denotes whether or not this is the primary key of the table.
+|key||Denotes whether or not this is the primary key of the table.
 |-
-|value5|| Default field value.
+|default|| Default field value.
 |-
 |}