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>