Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

MSW import (MFPS)

Overview

Imports time series data from MSW CSV files that are delivered from MFPS. The files contain both observed levels and flows in the main Dutch rivers. The files have an extension of "*.csv".

Configuration (Example)

A complete import module configuration consists of an ID Mapping file and a Import Module Instance file. See the attached example configuration files.

ModuleConfigFiles/

The following example of an Import Module Instance will import the time series as equidistant daily series for timezone GMT+1 hour. Notice that FEWS should store the time at the end of the day. Therefore the import timezone should be -23:00 instead of +01:00.

Code Block
xml
xml
titleImportMSW.xml

  <import>
    <general>
      <importType>MSW</importType>
      <folder>$IMPORT_FOLDER_MSW$</folder>
      <failedFolder>$IMPORT_FAILED_FOLDER_MSW$</failedFolder>
      <backupFolder>$IMPORT_BACKUP_FOLDER_MSW$</backupFolder>
      <idMapId>IdImportMSW</idMapId>
      <unitConversionsId>ImportMSWUnits</unitConversionsId>
      <flagConversionsId>ImportMSWFlagConversions</flagConversionsId>
      <importTimeZone>
        <timeZoneOffset>+01:00</timeZoneOffset>
      </importTimeZone>
      <dataFeedId>MSW</dataFeedId>
      <reportChangedValues>true</reportChangedValues>
    </general>
    <timeSeriesSet>
      <moduleInstanceId>ImportMSW</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>H.meting</parameterId>
      <locationSetId>MSW_H</locationSetId>
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="hour"/>
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
    </timeSeriesSet>
    ....
    <externUnit parameterId="H.meting" unit="cm"/>
  </import>

UnitConversion

Important in this configuration is that a unitconversion should be forced to convert the waterlevels from cm to m NAP.

Example File/

Code Block
xml
xml
titleBorghWaterhoogte.CSV

Databank=MSW
Locatie=BORD
Parameter=H10
Waarnemingsgroepcode=-
X_coordinaat=17638000
Y_coordinaat=32040000
2007/12/12;03:00;MET;cm NAP;30;4323
2007/12/12;03:10;MET;cm NAP;30;4324
2007/12/12;03:20;MET;cm NAP;30;4325
2007/12/12;03:30;MET;cm NAP;30;4326
2007/12/12;03:40;MET;cm NAP;30;4326
2007/12/12;03:50;MET;cm NAP;30;4327
2007/12/12;04:00;MET;cm NAP;30;4326
2007/12/12;04:10;MET;cm NAP;30;4326
2007/12/12;04:20;MET;cm NAP;30;4326
2007/12/12;04:30;MET;cm NAP;30;4327
2007/12/12;04:40;MET;cm NAP;30;4327
2007/12/12;04:50;MET;cm NAP;30;4327
2007/12/12;05:00;MET;cm NAP;30;4326
2007/12/12;05:10;MET;cm NAP;30;4326
2007/12/12;05:20;MET;cm NAP;30;4325
........

Java source code

MswTimeSeriesParser.java