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

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.RobinHuisman
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" %)**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" %)**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" %)**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" %)**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,40 @@
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 +**juli 2022:**
96 96  
114 +Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
115 +
97 97  
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 +
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  |
... ... @@ -129,11 +129,11 @@
129 129  
130 130  english:
131 131  
132 -Total sample weight (kg)
164 +Weight coarse fraction (kg)
133 133  
134 134  dutch:
135 135  
136 -Totaal gewicht monster (kg)
168 +Gewicht grove fractie (kg)
137 137  )))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
138 138  |Pieces of Asbestos|(((
139 139  new label
... ... @@ -167,14 +167,14 @@
167 167  
168 168  english:
169 169  
170 -Weight coarse fraction (kg)
202 +Total sample weight (kg)
171 171  
172 172  dutch:
173 173  
174 -Gewicht grove fractie (kg)
206 +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: ==
209 +== ==
178 178  
179 179  **27-01-2022:**
180 180  
... ... @@ -909,6 +909,8 @@
909 909  )))
910 910  
911 911  
944 +
945 +
912 912  (% class="col-xs-12 col-sm-4" %)
913 913  (((
914 914  {{box title="**Contents**"}}

Navigation

TerraIndex
asd