Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.RichardDyer
	1	+XWiki.Martijn

Content

...	...	@@ -10,9 +10,9 @@
10	10
11	11	**[[Field database description>>attach:20150224 Field Database Description (3).docx]]**
12	12
13		-[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
	13	+[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
14	14
15		-[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
	15	+[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16	16	)))
17	17	)))
18	18
...	...	@@ -29,6 +29,11 @@
29	29
30	30	Small XML example, full example can be found as an attachment:
31	31
	32	+(% class="box infomessage" %)
	33	+(((
	34	+'dsFieldProject' root tag, is also named: 'VeldData'. This is the same export formatting inside.
	35	+)))
	36	+
32	32	{{code language="XML" layout="LINENUMBERS" width="100%"}}
33	33
34	34	<dsFieldProject
...	...	@@ -88,13 +88,49 @@
88	88
89	89	(% class="box infomessage" %)
90	90	(((
91		-When you need help with detailed mappings, please request help at: service@terraindex.com
	96	+(% class="box infomessage" %)
	97	+(((
	98	+When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]]
92	92	)))
93	93
	101	+- DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam).
	102	+
	103	+- ID’s in the XML should be valid internally, as Primary- and Foreign-Keys. Once getting pushed into the database, the database will provice new ID’s.
	104	+
	105	+
	106	+)))
	107	+
	108	+== ==
	109	+
94	94	== Changes and updates: ==
95	95
	112	+**27 augustus 2024:**
96	96
	114	+|(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
	115	+|
	116	+|
	117	+|
	118	+|BroId| |A test done to determine wether no air is escaping the suction system of the filtration unit. This is important because if this is the case, dangerous gases might escape and affect the health of people nearby|Add|Varchar(50)|tblProjects|BroId
	119	+|ReportDate| |This describes the cause of a discontinuity among rock layers for a rock classification. This is not a description of the discontinuity, merely how it came to exist|Add|datetime|tblProjects|ReportDate
	120	+|BroAccountableParty| |Field for the BroID at filltertube level|Add|Varchar(200)|tblProjects|BroAccountableParty
97	97
	122	+**27 juli 2022:**
	123	+
	124	+Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
	125	+
	126	+
	127	+|dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
	128	+|dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
	129	+|dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
	130	+|dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
	131	+|dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
	132	+|dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
	133	+|dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
	134	+|dsFieldProject.tblWaterSamples.AnStreamlineGUID
	135	+|dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
	136	+
	137	+**14 maart 2022:**
	138	+
98	98	|(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
99	99	|
100	100	|
...	...	@@ -174,7 +174,7 @@
174	174	Totaal gewicht monster (kg)
175	175	)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
176	176
177		-== Changes and updates: ==
	218	+== ==
178	178
179	179	**27-01-2022:**
180	180
...	...	@@ -909,6 +909,8 @@
909	909	)))
910	910
911	911
	953	+
	954	+
912	912	(% class="col-xs-12 col-sm-4" %)
913	913	(((
914	914	{{box title="**Contents**"}}