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