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

...

Info
titleNote

Tmx database (mdb) may contain data for both digital and analog types of data.
When data are in analog format they usually stored in tables which names are defined using location and parameter name, e.g.: Loc063Ao1, Loc063Ai1. In case of digital format everything is stored in one table, e.g.: ReportAo or ReportDi. When in digital tables other columns than the regular ActualValue column must be imported the externalParameterQualifier can be used to indicate the correct table; ReportDi_Open to import the MinutesOpen column of the ReportDi table.

ModuleConfigFiles/

Time series which are listed in this file can be imported into fews.

...

It is assumed that date and time comes always in the "DD-MM-YYYY hh:mm" format. Since december 2008 also the time format of "DD-MM-YYYY hh:mm:ss" (with seconds) supported.

TimeZone can be used in the configuration file to set an offset.

...

File Name

Valid

location1 01-01-2007.csv

(tick)

location1.csv

(tick)

location1 .csv

(tick)

location1_01012007.csv

(minus)

location101012007.csv

(minus)

6. Two new warnings have been added to this import:

The systems gives a warning when data in the database is overwritten by new data:

  • 29.02.2008 08:52:04 WARN - Timeseries.Changed: ModuleInstance=ImportTMX, locationId=0002_boven, parameterId=H.meting, timestep=10minutes, period=2006-01-01 00:40:00 - 2006-01-31 23:10:00, number of timesteps changed 744

The system gives a warning when multiple series are imported for one location-parameter combination:

  • 29.02.2008 09:07:45 WARN - Multiple time series sets found for parameter-internal/external=H.meting/Ai2 location-internal/external=WAM0400_afwat_kan/WAM0400 ensemble member main$0

Java source code

TmxTimeSeriesParser.java