20 likes | 157 Views
Dataflow for WFD reporting. 2014. 2016. 1. User information and Reporting tools. 3. Pre-validation of XML file. 2. Conversion to XML. FME Geoprossesing module. FME Desktop validation. Ressource page. Access db. Draft XML file. Validated XML file. MS premisses.
E N D
Dataflowfor WFD reporting 2014 2016 1. User information and Reportingtools 3. Pre-validation of XML file 2. Conversion to XML FME Geoprossesingmodule FME Desktop validation Ressource page Access db Draft XML file Validated XML file MS premisses C# conversiontool C# validationtool MS fill in the Access dbaccording to schema.xsd Conversion of Access dbcanbe done by. The currentconversioncanbereplaced by a FME geoprocessing service thatpicks up the schema from DD http://dd.eionet.europa.eu/schemasets/browse/ MS go to Ressource page targeted the WFD 2016 wherethey find all information relevant for reporting (i.e. reporting obligation, guidance, xsd, xlst, html, accessdb, The pre-validation is optional. The current desktop toolpicks up the QA rules from ReportNet. Thiscanalsobereplaced by FME http://converterstest.eionet.europa.eu/do/stylesheetList. 4. Upload to ReportNet and execution of QA procedures 5. Upload to master database Receipt ReportNet Schemavalidation FME Uploadtool EEA premisses WFD master db QA Conditionalvalidation Accepted XML file C# uploadtool GML validation MS uploadtheir XML files to ReportNetmanually. When the folder is released the data willbesubmittedthree QC at ReportNet: A.) validationagainst the schema, B.) crossschema check written in Xquery and C.) validation of GML againstlayer at Discomap. When data arevalidated and accepted the data willbeuploaded to the master db. This is today done by a C# uploadtool, but canalsobe done by FME The data is stored in a MS SQL 2008 dbhosted in the EEA
Valuesoutside of enumeration list Exceedingtextfieldlength Numberlargerthanfieldrestriction Schema limitationse.g. % greaterthan 100 Agreewith COM, ignoreerror Ignoreerror Ignoreerror Agreewith COM, ignoreerror Information not available for numberfields Information not available for mandatoryfields Schema incorrecte.g. mandatorywhereconditional Incorrect type, e.g. comment in numberfield Useexception types -7777 (Not applicable) -8888 (Yet to bemeasured) -9999 (Unknown) Use -9999 for numbers and 'Not available' for text Use -7777 for numbers and NA for text FIX – comments in numberfieldswillgetvalue 0