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" %)**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 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 ... ... @@ -93,13 +93,40 @@ 93 93 94 94 (% class="box infomessage" %) 95 95 ((( 96 -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]] 97 97 ))) 98 98 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 + 99 99 == Changes and updates: == 100 100 112 +**juli 2022:** 101 101 114 +Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden. 115 + 102 102 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 + 103 103 |(% 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** 104 104 | 105 105 | ... ... @@ -179,7 +179,7 @@ 179 179 Totaal gewicht monster (kg) 180 180 )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample 181 181 182 -== Changesandupdates:==209 +== == 183 183 184 184 **27-01-2022:** 185 185 ... ... @@ -914,6 +914,8 @@ 914 914 ))) 915 915 916 916 944 + 945 + 917 917 (% class="col-xs-12 col-sm-4" %) 918 918 ((( 919 919 {{box title="**Contents**"}}