You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Overview

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

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