Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 27.3
edited by Robert Jan Daams
on 2025/02/04 11:52
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
Title
... ... @@ -1,1 +1,1 @@
1 -TerraIndex Export format - dsFieldProject.xsd
1 +Documentation TerraIndex Export format - dsFieldProject.xsd
Parent
... ... @@ -1,1 +1,1 @@
1 -Implementation documentation.For customers.WebHome
1 +Implementation documentation.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RjDaams
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 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 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,49 +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 -**27 augustus 2024:**
113 113  
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
121 121  
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 -
139 139  |(% 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**
140 140  |
141 141  |
... ... @@ -152,7 +152,7 @@
152 152  |Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
153 153  |Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
154 154  |Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
155 -|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
156 156  |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
157 157  |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
158 158  |Koolstofdioxine/CO2 ppm|(((
... ... @@ -170,11 +170,11 @@
170 170  
171 171  english:
172 172  
173 -Weight coarse fraction (kg)
132 +Total sample weight (kg)
174 174  
175 175  dutch:
176 176  
177 -Gewicht grove fractie (kg)
136 +Totaal gewicht monster (kg)
178 178  )))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
179 179  |Pieces of Asbestos|(((
180 180  new label
... ... @@ -208,14 +208,14 @@
208 208  
209 209  english:
210 210  
211 -Total sample weight (kg)
170 +Weight coarse fraction (kg)
212 212  
213 213  dutch:
214 214  
215 -Totaal gewicht monster (kg)
174 +Gewicht grove fractie (kg)
216 216  )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
217 217  
218 -== ==
177 +== Changes and updates: ==
219 219  
220 220  **27-01-2022:**
221 221  
... ... @@ -950,8 +950,6 @@
950 950  )))
951 951  
952 952  
953 -
954 -
955 955  (% class="col-xs-12 col-sm-4" %)
956 956  (((
957 957  {{box title="**Contents**"}}