...
Here is an example import module configuration file:<?xml version="1.0" encoding="UTF-8"?>
<timeSeriesImportRun xmlns="http://www.wldelft.nl/fews"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/timeSeriesImportRun.xsd">
<!- - This is an example import configuration file for importing WQ CSV data from an import directory -->
<import>
<general>
<!- - Class name of WQ CSV parser is same as UmAquo CSV parser -->
<parserClassName>nl.deltares.umaquo.timeseriesparsers.UmAquoCsvTimeSeriesParser</parserClassName>
<!-- Path to directory containing UmAquo libraries and schemas. If omitted then the content of the umaquo-bin
can be placed in the FEWS-bin dir -->
<binDir>%REGION_HOME%/Modules/umaquo-bin</binDir>
<!- - Directory from which CSV files are to be imported -->
<folder>$IMPORT_FOLDER$/WQ/CSV</folder>
<failedFolder>$IMPORT_FAILED_FOLDER$/WQ/CSV</failedFolder>
<backupFolder>$IMPORT_BACKUP_FOLDER$/WQ/CSV</backupFolder>
<idMapId>IdImportWqCsv</idMapId>
<importTimeZone>
<timeZoneOffset>+00:00</timeZoneOffset>
</importTimeZone>
</general>
<properties>
<!-- Optional: decimal character. Default = . - ->
<string key="DECIMAL_SEPARATOR" value=","/>
<!-- Optional: Regular expression for date value. Default = yyyy-MM-dd - ->
<string key="CSV_DATEPATTERN" value="dd-MM-yyyy"/>
<!- - Optional: select UmAquo schema version 2009 or 2011. Default = 2009 -->
<int key="SCHEMA_VERSION" value="2011"/>
<!- - Optional: allow lenient validation. Default = false -->
<bool key="LENIENT" value="true"/>
<!- - Required for WQCsv: Provide a header line describing the columns - ->
<string key="HEADER_LINE" value=";MeetPunt.identificatie;;;;Begindatum;Begintijd;Typering.code;;Limietsymbool;Numeriekewaarde;Hoedanigheid.code;Eenheid.code;Compartiment.code;"/>
...
The header names that can be provided to describe the content of the WQ-CSV must be selected from the list below.
MeetPunt.codeidentificatie: mapped to location id (required)
Grootheid.code: if Parameter.code not present then this column is mapped to parameter id (optional)
Parameter.code: mapped to parameter.id. If not present then Grootheid.code is used.
Eenheid.code: mapped to timeseries unit and to qualifier 0 (required)
Hoedanigheid.code: mapped to qualifier 1 (required)
Compartiment.code: mapped to qualifier 2 (required)
Begindatum: mapped to timestamp together with BeginTijd (required)
Begintijd: mapped to timestamp. If not present only Begindatum is used. (optional)
Limietsymbool: mapped to OutOfDetectionRangeFlag value (optional)
Numeriekewaarde: contains numeric value. If empty then Alfanumeriekewaarde field is parsed to numeric value.
Alfanumeriekewaarde: only used if Numeriekewaarde field is empty
Kwaliteitsoordeel.code: mapped to flag value
...