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	+|BRO-ID| |The BRO-ID of the project. Used for specific deliveries to the BRO-loket after the project has been officially registered within the BRO.|Add|Varchar(50)|tblProjects|BroId
	119	+|Report date| |The reporting date of this project towards the 'Bronhouder'. Used for specific deliveries to the BRO-loket, keep in mind this is the date the BRO will check 'Bronhouders' for their legal tasks.|Add|datetime|tblProjects|ReportDate
	120	+|BRO Bronhouder objectId| |The objectId for the 'Bronhouder' to find this project in the BRO Portal.|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**"}}