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
- 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)
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>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> |
IdMapFiles/
Info |
---|
Defines mappings between 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.nl/schemas/version1.0/idMap.xsd" version="1.1"> <!--DINO locaties--> <map internalLocation="B45F0142" internalParameter="G.meting" externalLocation="B45F0142" externalParameter="STAND (MV)" externalParameterQualifier="1"/> <map internalLocation="B51F0423" internalParameter="G.meting" externalLocation="B51F0423" externalParameter="STAND (MV)" externalParameterQualifier="1"/> </idMap> |
Important in this configuration is the externalParameterQualifier, this is used to indicate the Filternumber.
Example File/
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
Titel: null;;;;;;;;;;; Gebruikersnaam: AAAAAAAAA;;;;;;;;;;; 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 |