Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Info

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

Code Block
xmlxml
titleImportTmx.xml
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>

...

Info

Defines mappings between TMX and FEWS parameters and locations.

xml
Code Block
xml
titleMapIdTmx.xml
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>

...

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