Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Here is an example import module configuration file:

Code Block


<?xml version="1.0" encoding="UTF-8"?>
<timeSeriesImportRun xmlns="http://www.wldelft.nl/fews"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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&nbsp; -->
&nbsp;&nbsp; &nbsp;<import>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<general>
    <import>
        <general>
        <!-- Class name of WQ CSV parser is same as UmAquo CSV parser -->
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <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 \-->
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <binDir>%REGION_HOME%/Modules/umaquo-bin</binDir>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;


            <!-- Directory from which CSV files are to be imported -->
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;            <folder>$IMPORT_FOLDER$/WQ/CSV</folder>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <failedFolder>$IMPORT_FAILED_FOLDER$/WQ/CSV</failedFolder>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <backupFolder>$IMPORT_BACKUP_FOLDER$/WQ/CSV</backupFolder>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<idMapId>IdImportWqCsv</idMapId>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<importTimeZone>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <idMapId>IdImportWqCsv</idMapId>
            <importTimeZone>
                <timeZoneOffset>+00:00</timeZoneOffset>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</importTimeZone>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</general>
<properties>
            </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;"/>*

         </properties>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<timeSeriesSet>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<moduleInstanceId>ImportUmAquo</moduleInstanceId>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<valueType>scalar</valueType>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<parameterId>MyPar</parameterId>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<locationSetId>MyLocSet</locationSetId>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<timeSeriesType>external historical</timeSeriesType>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;        <timeSeriesSet>
            <moduleInstanceId>ImportUmAquo</moduleInstanceId>
            <valueType>scalar</valueType>
            <parameterId>MyPar</parameterId>
            <locationSetId>MyLocSet</locationSetId>
            <timeSeriesType>external historical</timeSeriesType>
            <timeStep unit="nonequidistant"/>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;            <readWriteMode>add originals</readWriteMode>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<synchLevel>1</synchLevel>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</timeSeriesSet>
&nbsp;&nbsp; &nbsp;            <synchLevel>1</synchLevel>
        </timeSeriesSet>
    </import>
</timeSeriesImportRun>

Expected CSV header names

...