Overview

Imports time series data from files in CSV format with a single header line containing the location ids

Since 2018.02 the last column is ignored when it is empty (line ends with column separator)

Import type

The import type is LocationIdsHeaderCsv. There is no particular file extension required.

Example

Here is a simple example:

ignored,EA_H-2001,EA_H-2032
2003-03-01 01:00:00,-999,-999
2003-03-01 01:15:00,1.000,1.000
2003-03-01 01:30:00,2.000,2.000
2003-03-01 01:45:00,3.000,3.000
2003-03-01 02:00:00,4.000,4.000
2003-03-01 02:15:00,-999,5.000
2003-03-01 02:30:00,6.000,6.000
2003-03-01 02:45:00,7.000,7.000
2003-03-01 03:00:00,8.000,8.000
2003-03-01 03:15:00,9.000,9.000
2003-03-01 03:30:00,10.000,10.000
2003-03-01 03:45:00,11.000,11.000
2003-03-01 04:00:00,12.000,12.000
2003-03-01 04:15:00,13.000,13.000
2003-03-01 04:30:00,14.000,14.986

Config example

<?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>LocationsIdsHeaderCsv</importType>
			<folder>$IMPORT__FORECASTS_FOLDER$</folder>
			<failedFolder>$IMPORT_FAILED_FOLDER$</failedFolder>
			<idMapId>IdIWave</idMapId>
			<unitConversionsId>ImportUnitConversions</unitConversionsId>
			<importTimeZone>
				<timeZoneOffset>+00:00</timeZoneOffset>
			</importTimeZone>
			<dataFeedId>WaveForecast</dataFeedId>
			<columnSeparator>,</columnSeparator>
			<decimalSeparator>.</decimalSeparator>
			<dateTimePattern>dd/MM/yyyy HH:mm:ss</dateTimePattern>
		</general>
		<timeSeriesSet>
			<moduleInstanceId>ImportWave</moduleInstanceId>
  • No labels

Disclaimer