You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Overview

Imports time series data from the TNO DINO files.

There are two types of DINO ASCII files:

  • GWS_PutXXXXXXX files
  • Put_XXXXXXX files

Where XXXXXX is the location ID.

Status

Both file types can be imported.

The  

Configuration (Example)

The configuration files below define import of 4 time series from the tmx .mdb file:

Data Format

Parameter (tmx)

Location (tmx)

Parameter (fews)

Location (fews)

analog

Ai1

Loc063

P1.m

tmx_location1

analog

Ao1

Loc063

P2.m

tmx_location2

digital

1

46

P3.m

tmx_location3

digital

1

51

P3.m

tmx_location4

Note

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

ModuleConfigFiles/

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

Defines what time series can be imported from the TMX .mdb file and which tables contain their values.


ImportTmx.xml
<?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/

Defines mappings between TMX and FEWS parameters and locations.

MapIdTmx.xml
<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>
  • No labels

Disclaimer