Overview

Imports time series data from files in CSV format with the first line containing the column headers.

To use this import in FEWS configuration: <importType>TvaDailyWaterViewCsv</importType>

Example

Here is an example:

Tva Daily Water View Csv example file

This file is also available for download in the attachments: 20131222.APH

Details of the import format

The field separator is a comma (,).
The decimal separator is a period (.).
The escape character is double quotes ("), used for date and time.
The location id is taken from the first three letters after the dot in the filename.

Columns:

1th: date
2nd: time
3rd till last: values for the parameters specified in the header
Except for columns "recordDate", "recordTime", these are skipped.

Java source code

TvaDailyWaterViewCsvTimeSeriesParser.java

  • No labels