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 (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. Martijn1 +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 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 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,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]] 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 -**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 -|BroId| |A test done to determine wether no air is escaping the suction system of the filtration unit. This is important because if this is the case, dangerous gases might escape and affect the health of people nearby|Add|Varchar(50)|tblProjects|BroId 119 -|ReportDate| |This describes the cause of a discontinuity among rock layers for a rock classification. This is not a description of the discontinuity, merely how it came to exist|Add|datetime|tblProjects|ReportDate 120 -|BroAccountableParty| |Field for the BroID at filltertube level|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 | ... ... @@ -215,7 +215,7 @@ 215 215 Totaal gewicht monster (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 -== == 182 +== 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**"}}