QDI Mapping file structure: Difference between revisions

Latest revision as of 12:43, 27 March 2009

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.

NOTE: The 'T' data type is depreciated. 'D' should be used instead.

@@ Line 17: / Line 17: @@
 The rest of the file is structured as follows:
-fieldName, value1 , value2,  value3 , value4, value5
+<pre>
+fieldName,offset,length,type,key,default
+</pre>
-{|+Table 1
+{|border = "1"
-|'''Field'''||'''Meaning'''
+|+Table 1
+|'''Field'''||'''Meaning'''||'''Values'''
 |-
-|fieldName|| This is the field in the givne table that the values will be mapped to.
+|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.
 |-
-|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.||Will be a number.
 |-
-|value2||The acceptable length of the field in the data file.
+|length||The acceptable length of the field in the data file.||Will be a number.
 |-
-|value3||The field type.
+|type||The field type.||"N" - numeric, "D"/"T" - Date/Time, "S" - String
 |-
-|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.||"T" - True, "F" - False
 |-
-|value5|| Default field value.
+|default|| Default field value.||Depends on the field type.
 |-
 |}
+'''NOTE:''' The 'T' data type is depreciated. 'D' should be used instead.
+== See Also ==
+For Spectra QEST staff, the file: <br> '''\\adls0003\Documents\Spectra QEST\Software\Procedures\IQ0023 QDI Mapping File Specification.htm''' <br> contains a partially complete list of the available options/settings for QDI Mapping Files.
+[[Category:QDI|{{PAGENAME}}]]