Skip to Content
Modifié par Robert Jan Daams le 2025/02/04 11:52
Depuis la version 20.1
modifié par Richard Dyer
sur 2022/04/14 15:55
Commentaire de modification : Il n'y a aucun commentaire pour cette version
À la version 25.3
modifié par Martijn Spaan
sur 2024/08/27 12:57
Commentaire de modification : Il n'y a aucun commentaire pour cette version

Résumé

Détails

Propriétés de la Page
Auteur du document
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.Martijn
Contenu
... ... @@ -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 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 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  |
... ... @@ -129,11 +129,11 @@
129 129  
130 130  english:
131 131  
132 -Total sample weight (kg)
173 +Weight coarse fraction (kg)
133 133  
134 134  dutch:
135 135  
136 -Totaal gewicht monster (kg)
177 +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)
211 +Total sample weight (kg)
171 171  
172 172  dutch:
173 173  
174 -Gewicht grove fractie (kg)
215 +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**"}}