Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 24.1
edited by Robin Huisman
on 2022/07/27 21:12
Change comment: There is no comment for this version
To version 19.1
edited by Richard Dyer
on 2022/04/14 15:53
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RobinHuisman
1 +XWiki.RichardDyer
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 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" %)**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 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" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16 16  )))
17 17  )))
18 18  
... ... @@ -29,11 +29,6 @@
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 -
37 37  {{code language="XML" layout="LINENUMBERS" width="100%"}}
38 38  
39 39  <dsFieldProject
... ... @@ -93,40 +93,13 @@
93 93  
94 94  (% class="box infomessage" %)
95 95  (((
96 -(% class="box infomessage" %)
97 -(((
98 -When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]]
91 +When you need help with detailed mappings, please request help at: service@terraindex.com
99 99  )))
100 100  
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 -
110 110  == Changes and updates: ==
111 111  
112 -**juli 2022:**
113 113  
114 -Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
115 -
116 116  
117 -|dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
118 -|dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
119 -|dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
120 -|dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
121 -|dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
122 -|dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
123 -|dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
124 -|dsFieldProject.tblWaterSamples.AnStreamlineGUID
125 -|dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
126 -
127 -
128 -**maart 2022:**
129 -
130 130  |(% 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**
131 131  |
132 132  |
... ... @@ -143,7 +143,7 @@
143 143  |Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
144 144  |Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
145 145  |Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
146 -|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
114 +|Benzeen PID |CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
147 147  |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
148 148  |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
149 149  |Koolstofdioxine/CO2 ppm|(((
... ... @@ -161,11 +161,11 @@
161 161  
162 162  english:
163 163  
164 -Weight coarse fraction (kg)
132 +Total sample weight (kg)
165 165  
166 166  dutch:
167 167  
168 -Gewicht grove fractie (kg)
136 +Totaal gewicht monster (kg)
169 169  )))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
170 170  |Pieces of Asbestos|(((
171 171  new label
... ... @@ -199,14 +199,14 @@
199 199  
200 200  english:
201 201  
202 -Total sample weight (kg)
170 +Weight coarse fraction (kg)
203 203  
204 204  dutch:
205 205  
206 -Totaal gewicht monster (kg)
174 +Gewicht grove fractie (kg)
207 207  )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
208 208  
209 -== ==
177 +== Changes and updates: ==
210 210  
211 211  **27-01-2022:**
212 212  
... ... @@ -941,8 +941,6 @@
941 941  )))
942 942  
943 943  
944 -
945 -
946 946  (% class="col-xs-12 col-sm-4" %)
947 947  (((
948 948  {{box title="**Contents**"}}