Page History

...

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

Info

title	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.

A complete import module configuration consists of an ID Mapping file and a Import Module Instance file.

ModuleConfigFiles/

The following example of an Import Module Instance will import the time series as non-equidistant series.

...

Code Block

	xml
	xml
title	ImportTmxImportDINO.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 http://fews.wldelft.nl/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>
	    <general>
      <importType>DINO</importType>
      <folder>$IMPORT_FOLDER_DINO$</folder>
      <failedFolder>$IMPORT_FAILED_FOLDER_DINO$</failedFolder>
      <idMapId>IdImportDINO</idMapId>
      <unitConversionsId>ImportUnitConversions</unitConversionsId>
      <importTimeZone>
        <timeZoneOffset>+01:00</timeZoneOffset>
      </importTimeZone>
      <dataFeedId>DINO</dataFeedId>
    </general>
    <timeSeriesSet>
      <moduleInstanceId>ImportDINO</moduleInstanceId>
      <valueType>scalar</valueType>
      <parameterId>G.meting</parameterId>
      <locationSetId>DINO_G.meting_nonequidistant</locationSetId>
      <timeSeriesType>external historical</timeSeriesType>
      <timeStep unit="nonequidistant"/>
      <readWriteMode>add originals</readWriteMode>
      <synchLevel>1</synchLevel>
    </timeSeriesSet>
  </import>
</timeSeriesImportRun>

...

Info
Defines mappings between TMX DINO and FEWS parameters and locations.

Code Block

	xml
	xml
title	MapIdTmx.xml


<?xml version="1.0" encoding="UTF-8"?>
<idMap xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.\..\..\..\..\..\..\..\..\..\..\xml-schemas\nl/schemas/version1.0/idMap.xsd" version="1.1">
    	<!--DINO analog locaties-->
    <map internalParameter="P1.m"	<map internalLocation="tmx_location1" externalParameter="Ai1" externalLocation="Loc063" />
    <mapB45F0142" internalParameter="P2G.mmeting" internalLocationexternalLocation="tmx_location1B45F0142" externalParameter="Ao1STAND (MV)" externalLocationexternalParameterQualifier="Loc0631" />

    <!-- digital -->
    <map internalParameter="P3.m"	<map internalLocation="tmx_location2" externalParameter="1" externalLocation="46" externalParameterQualifier="ReportAo" />
    <mapB51F0423" internalParameter="P3G.mmeting" internalLocationexternalLocation="tmx_location3B51F0423" externalParameter="1" externalLocation="51STAND (MV)" externalParameterQualifier="ReportAo1" />
</idMap>

Important in this configuration is the externalParameterQualifier, this is used to indicate the Filternumber.

Example File/

Titel: null;;;;;;;;;;;
Gebruikersnaam: hydrologie@aaenmaas.nl;;;;;;;;;;;
Periode aangevraagd: 01/01/1800-12/09/2007;;;;;;;;;;;
Datum: 12/09/2007;;;;;;;;;;;
Referentie: Maaiveld (MV);;;;;;;;;;;

LOCATIE;FILTERNUMMER;EXTERNE AANDUIDING;X-COORDINAAT;Y-COORDINAAT;MAAIVELD NAP;GESCHAT;MEETPUNT NAP;BOVENKANT FILTER;ONDERKANT FILTER;START DATUM;EIND DATUM
B45H0224;1;45HL0037;179790;408310;1691;;1696;1496;1446;28-2-1974;6-12-1989
B45H0224;1;45HL0037;179790;408310;1691;;1684;1534;1484;6-12-1989;29-11-1999

LOCATIE;FILTERNUMMER;PEIL DATUM TIJD;STAND (MV);BIJZONDERHEID;;;;;;;
B45H0224;1;28-2-1974 12:02;103;;;;;;;;
B45H0224;1;14-3-1974 12:03;95;;;;;;;;
B45H0224;1;28-3-1974 12:03;97;;;;;;;;
B45H0224;1;16-4-1974 12:04;110;;;;;;;;
B45H0224;1;29-4-1974 12:04;106;;;;;;;;
B45H0224;1;14-5-1974 12:05;106
B45H0224;1;28-5-1974 12:05;115
B45H0224;1;14-6-1974 12:06;113
B45H0224;1;28-6-1974 12:06;100

Page tree

Versions Compared

Old Version 2

New Version 3

Key

Configuration (Example)

ModuleConfigFiles/

ModuleConfigFiles/

Example File/