Changes for page 2. TerraIndex Export format - dsFieldProject.xsd
Last modified by Robert Jan Daams on 2025/02/04 11:52
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- 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 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 wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]] 16 16 ))) 17 17 ))) 18 18 ... ... @@ -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]] 96 +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 | ... ... @@ -206,7 +206,7 @@ 206 206 Totaal gewicht monster (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 -== == 182 +== 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**"}}