...
Note |
---|
This import is available in DELFT-FEWS versions after 2008.03 |
Info |
---|
There is also an UMAQUO version of this import: link |
Imports time series data in csv format, specially added for some of the Dutch Waterboards. This import format has some special features compared to other time series import formats. Water quality is mostly analysed from a sample, there fore the sample id is a required field in this file. The data is seperated by a ";" and contains 15 columns with data. Because the data files do not contain any information on the content of the different columns, the layout and number of columns is fixed.
...
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>WQCSV</importType> <folder>$IMPORT_FOLDER_WQCSV$</folder> <failedFolder>$IMPORT_FAILED_FOLDER_WQCSV$</failedFolder> <backupFolder>$IMPORT_BACKUP_FOLDER_WQCSV$</backupFolder> <idMapId>IdImportWQCSV</idMapId> <unitConversionsId>ImportUnitConversions</unitConversionsId> <importTimeZone> <timeZoneOffset>+01:00</timeZoneOffset> </importTimeZone> <dataFeedId>WQCSV</dataFeedId> </general> <timeSeriesSet> <moduleInstanceId>ImportWQCSV</moduleInstanceId> <valueType>sample</valueType> <parameterId>ZS</parameterId> <locationSetId>WQLocaties</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="nonequidistant"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportWQCSV</moduleInstanceId> <valueType>sample</valueType> <parameterId>BZV4</parameterId> <locationSetId>WQLocaties</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="nonequidistant"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>ImportWQCSV</moduleInstanceId> <valueType>sample</valueType> <parameterId>BZV1</parameterId> <locationSetId>WQLocaties</locationSetId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="nonequidistant"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> </timeSeriesSet> </import> </timeSeriesImportRun> |
...
The file format is just plain ASCII with the columns seperated by se a semicolon ";"
Example:
No Format |
---|
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Afvoer geschat l/s;;;15;NVT;l/s;OW;afGeschat 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Afvoer l/s;;;n.b.;NVT;l/s;OW;afL/s 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Ammonium-N;NH4;;0,2;N;mg/l;OW;NH4 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;BZV met Atu/5 dagen;BZV5;<;1;O2;mg/l;OW;BZV1 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Cadmium (Cd);Cd;;0,088;NVT;ug/l;OW;Cd2W 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Calcium (Ca);Ca;;36;NVT;mg/l;OW;Ca2W 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Chloride;Cl;;14;NVT;mg/l;OW;Cl 2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Chroom (Cr);Cr;;1,2;NVT;ug/l;OW;Cr2W |
Note:
- Make sure the date and time formats are correct (dd-mm-yyyy and hh-mm-ss).
- Make sure each line has only 15 columns with 14 ";" characters separating the columns.
- Only columns 1, 2, 6, 7, 10, 11, 13 and 15 are required, all other columns can be left empty.