QDI Mapping file structure - Revision history

Svetlana.lazareva at 12:43, 27 March 2009

2009-03-27T12:43:26Z

←Older revision		Revision as of 12:43, 27 March 2009
Line 39:		Line 39:
	\|}		\|}

			'''NOTE:''' The 'T' data type is depreciated. 'D' should be used instead.
	== See Also ==		== 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.		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}}]]		[[Category:QDI\|{{PAGENAME}}]]

2007-07-20T01:20:07Z

Categorised

←Older revision		Revision as of 01:20, 20 July 2007
Line 41:		Line 41:
	== See Also ==		== 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.		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}}]]

2006-08-30T01:25:02Z

added link to mapping file spec.

←Older revision		Revision as of 01:25, 30 August 2006
Line 38:		Line 38:
	\|-		\|-
	\|}		\|}

			== 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.

2006-01-18T04:04:32Z

←Older revision		Revision as of 04:04, 18 January 2006
Line 17:		Line 17:
	The rest of the file is structured as follows:		The rest of the file is structured as follows:

	fieldName, offset, length, type, key, default		<pre>
			fieldName,offset,length,type,key,default
			</pre>

	{\|border = "1"		{\|border = "1"

2006-01-18T02:03:54Z

←Older revision		Revision as of 02:03, 18 January 2006
Line 21:		Line 21:
	{\|border = "1"		{\|border = "1"
	\|+Table 1		\|+Table 1
	\|'''Field'''\|\|'''Meaning'''		\|'''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.
	\|-		\|-
	\|offset\|\|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.
	\|-		\|-
	\|length\|\|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.
	\|-		\|-
	\|type\|\|The field type.		\|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.		\|key\|\|Denotes whether or not this is the primary key of the table.\|\|"T" - True, "F" - False
	\|-		\|-
	\|default\|\| Default field value.		\|default\|\| Default field value.\|\|Depends on the field type.
	\|-		\|-
	\|}		\|}

2006-01-18T00:47:41Z

←Older revision		Revision as of 00:47, 18 January 2006
Line 17:		Line 17:
	The rest of the file is structured as follows:		The rest of the file is structured as follows:

	fieldName, ~~value1~~ , ~~value2~~, ~~value3~~ , ~~value4~~, ~~value5~~		fieldName, offset, length, type, key, default

	{\|border = "1"		{\|border = "1"
Line 25:		Line 25:
	\|fieldName\|\| This is the field in the givne table that the values will be mapped to.		\|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.
	\|-		\|-
	\|}		\|}

2006-01-18T00:46:59Z

←Older revision		Revision as of 00:46, 18 January 2006
Line 19:		Line 19:
	fieldName, value1 , value2, value3 , value4, value5		fieldName, value1 , value2, value3 , value4, value5

	{\|+Table 1		{\|border = "1"
			\|+Table 1
	\|'''Field'''\|\|'''Meaning'''		\|'''Field'''\|\|'''Meaning'''
	\|-		\|-

2006-01-18T00:46:38Z

←Older revision		Revision as of 00:46, 18 January 2006
Line 24:		Line 24:
	\|fieldName\|\| This is the field in the givne table that the values will be mapped to.		\|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.		\|value1\|\|The character offset at which the value will be found in the data file.
	\|-		\|-
	\|value2\|\|~~ ~~		\|value2\|\|The acceptable length of the field in the data file.
	\|-		\|-
	\|value3\|\|~~ ~~		\|value3\|\|The field type.
	\|-		\|-
	\|value4\|\|~~ ~~		\|value4\|\|Denotes whether or not this is the primary key of the table.
	\|-		\|-
	\|value5\|\|~~ ~~		\|value5\|\| Default field value.
	\|-		\|-
	\|}		\|}

2006-01-18T00:30:32Z

←Older revision		Revision as of 00:30, 18 January 2006
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:

	~~<nowiki>~~<pre>~~# Map Settings~~		<pre>
	TABLENAME:DocumentConcreteDockets		TABLENAME:DocumentConcreteDockets
	SYSTEM:QESTLAB		SYSTEM:QESTLAB
	DATAFILE:TK*.in		DATAFILE:TK*.in
	TRIMLEADINGZEROS:TRUE</pre~~></nowiki~~>		TRIMLEADINGZEROS:TRUE</pre>

	In order these suggest:		In order these suggest:

2006-01-18T00:30:16Z

←Older revision		Revision as of 00:30, 18 January 2006
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: