Page History

...

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

java source code

WQCSVTimeSeriesParser.java

Page tree

Versions Compared

Old Version 5

New Version Current

Key

java source code