...
Where XXXXXX is the location ID.
Status
- Import is coded and tested.
- Both file types can be imported.
- File can be ',' or ';' seperated
Not yet supported:
- The column "BIJZONDERHEID" is not yet imported or interpreted.
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 |
|
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 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 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 <map internalLocation="B45F0142" internalParameter="P1G.mmeting" internalLocationexternalLocation="tmx_location1B45F0142" externalParameter="Ai1STAND (MV)" externalLocationexternalParameterQualifier="Loc0631" /> <map <map internalLocation="B51F0423" internalParameter="P2G.mmeting" internalLocationexternalLocation="tmx_location1B51F0423" externalParameter="Ao1STAND (MV)" externalLocationexternalParameterQualifier="Loc0631" /> </idMap> |
Important in this configuration is the externalParameterQualifier, this is used to indicate the Filternumber.
Example File/
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
Titel: null;;;;;;;;;;; Gebruikersnaam: AAAAAAAAA;;;;;;;;;;; Periode <!-- 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> 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 |