Overview
Imports time series data from the Microsoft Access database file.
...
There is no flag column when data type is digital?
Status
Both analog and digital data format can be used.
...
Jira Issues | ||
---|---|---|
|
Configuration (Example)
The configuration files below define import of 4 time series from the tmx .mdb file:
...
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 | ||||||
---|---|---|---|---|---|---|
| ||||||
<?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/schemas/version1.0/timeSeriesImportRun.xsd"> <import> <general> <importType>Tmx</importType> <folder>../junit_test_output/nl/wldelft/fews/system/plugin/dataImport/TimeSeriesImportTestData/import/tmx</folder> <idMapId>tmxMapId</idMapId> <importTimeZone> <timeZoneOffset>+01:00</timeZoneOffset> </importTimeZone> </general> <!-- Analog, table = Loc063Ai1 --> <timeSeriesSet> <moduleInstanceId>ImportTmx</moduleInstanceId> <valueType>scalar</valueType> <parameterId>P1.m</parameterId> <!-- parameter = Ai1 --> <locationId>tmx_location1</locationId> <!-- location = Loc063 --> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minute" multiplier="15"/> <relativeViewPeriod unit="day" start="0" end="11"/> <readWriteMode>add originals</readWriteMode> </timeSeriesSet> <!-- Analog, table = Loc063Ao1 --> <timeSeriesSet> <moduleInstanceId>ImportTmx</moduleInstanceId> <valueType>scalar</valueType> <parameterId>P2.m</parameterId> <!-- parameter = Ao1 --> <locationId>tmx_location1</locationId> <!-- location = Loc063 --> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="day" multiplier="1"/> <relativeViewPeriod unit="day" start="0" end="11"/> <readWriteMode>add originals</readWriteMode> </timeSeriesSet> <!-- Digital, table = ReportAo, defined in the mapping --> <timeSeriesSet> <moduleInstanceId>ImportTmx2</moduleInstanceId> <valueType>scalar</valueType> <parameterId>P3.m</parameterId> <!-- Channel = 1 --> <locationId>tmx_location2</locationId> <!-- LocCode = 46 --> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="day" multiplier="1"/> <relativeViewPeriod unit="day" start="400" end="470"/> <readWriteMode>add originals</readWriteMode> </timeSeriesSet> <!-- Digital, table = ReportAo, defined in the mapping --> <timeSeriesSet> <moduleInstanceId>ImportTmx</moduleInstanceId> <valueType>scalar</valueType> <parameterId>P3.m</parameterId> <!-- Channel = 1 --> <locationId>tmx_location3</locationId> <!-- LocCode = 51 --> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="day" multiplier="1"/> <relativeViewPeriod unit="day" start="400" end="470"/> <readWriteMode>add originals</readWriteMode> </timeSeriesSet> </import> </timeSeriesImportRun> |
IdMapFiles/
Info |
---|
Defines mappings between TMX and FEWS parameters and locations. |
...