Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 25.1
edited by Robin Huisman
on 2022/07/27 21:13
Change comment: There is no comment for this version
To version 17.1
edited by Richard Dyer
on 2022/04/14 15:02
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 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" %)**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 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" %)**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,43 +93,17 @@
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 -**27 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 -**14 maart 2022:**
128 -
129 129  |(% 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**
130 -|
131 -|
132 -|
99 +|
100 +|
101 +|
133 133  |Smoketube test|CodeID: 157|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|Lookupvalue|tblObservations|METINGCODE 157
134 134  |Discontinuity cause| |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|Lookupvalue|tblLayers|LaDiscontinuityCauseCode
135 135  |BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
... ... @@ -140,9 +140,9 @@
140 140  |Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
141 141  |Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
142 142  |Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
143 -|Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
112 +|Precense of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
144 144  |Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
145 -|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
146 146  |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
147 147  |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
148 148  |Koolstofdioxine/CO2 ppm|(((
... ... @@ -155,17 +155,7 @@
155 155  
156 156  CO2 (ppm) einde monstername
157 157  )))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
158 -|Weight debris (kg)|(((
159 -new label
160 -
161 -english:
162 -
163 -Weight coarse fraction (kg)
164 -
165 -dutch:
166 -
167 -Gewicht grove fractie (kg)
168 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
127 +|Weight debris (kg)| |Change label to conform norm|Change|Float|tblJars|JrWeightDebris
169 169  |Pieces of Asbestos|(((
170 170  new label
171 171  
... ... @@ -198,14 +198,14 @@
198 198  
199 199  english:
200 200  
201 -Total sample weight (kg)
160 +Weight coarse fraction (kg)
202 202  
203 203  dutch:
204 204  
205 -Totaal gewicht monster (kg)
164 +Gewicht grove fractie (kg)
206 206  )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
207 207  
208 -== ==
167 +== Changes and updates: ==
209 209  
210 210  **27-01-2022:**
211 211  
... ... @@ -940,8 +940,6 @@
940 940  )))
941 941  
942 942  
943 -
944 -
945 945  (% class="col-xs-12 col-sm-4" %)
946 946  (((
947 947  {{box title="**Contents**"}}