...
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.
...
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
Code Block | ||||
---|---|---|---|---|
| ||||
Wiki Markup | ||||
{code: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>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> {code} |