...
Info | ||
---|---|---|
| ||
Tmx database (mdb) may contain data for both digital and analog types of data. |
ModuleConfigFiles/
Time series which are listed in this file can be imported into fews.
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<idMap xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews ..\..\..\..\..\..\..\..\..\..\..\xml-schemas\idMap.xsd" version="1.1"> <!-- analog --> <map internalParameter="P1.m" internalLocation="tmx_location1" externalParameter="Ai1" externalLocation="Loc063" /> <map internalParameter="P2.m" internalLocation="tmx_location1" externalParameter="Ao1" externalLocation="Loc063" /> <!-- digital --> <map internalParameter="P3.m" internalLocation="tmx_location2" externalParameter="1" externalLocation="46" externalParameterQualifier="ReportAo" /> <map internalParameter="P3.m" internalLocation="tmx_location3" externalParameter="1" externalLocation="51" externalParameterQualifier="ReportAo" /> </idMap> |
Import of TMX in
...
CSV file format
The importtype is called TmxCsv
...
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.
...
5. File naming convention
TMX CVS CSV files to be imported by FEWS should be in the following format:
...
File Name | Valid |
---|---|
location1 01-01-2007.csv |
|
location1.csv |
|
location1 .csv |
|
location1_01012007.csv |
|
location101012007.csv |
|
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