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)
The import type isĀ LocationIdsHeaderCsv. There is no particular file extension required.
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
<?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> |