...
Imports time series data from files in CSV format with the first line containing the without column headers.
To use this import in FEWS configuration: <importType>TvaHourlyWaterViewCsv</importType>
Example
Here is an example:Tva Hourly Water View Csv example file
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
1277.05,840.80,3075,,,,0,,,,,78.5,,,0.00,,,,,,,,,,,,,,,,,,,,285.8,,,,,,,,41630.0000115741,,,0.00
|
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 in the filename.
The date and time are taken from the the filename after the dot in the filename.
Columns:
location id in the format "yyyyMMddHH"
For example the file APH2013122210.dat contains values for location id "APH" on December 22nd 2013 at 10:00.
Columns:
The columns contain values for different parameters:
1: "HeadElev"
2: "TailElev"
3: "TurbDisch"
7: "Spill"
8: "PumpCFS"
9: "PumpMWH"
12: "GenMWH"
15: "StationServ"
35: "GrossGenMWH"
38: "GrossPumpMWH"
43: "WVStrtTime"
44: "RiverDO"
45: "RiverTemp"
46: "Wv4"1th: date
2nd: time
3rd till last: values for the parameters specified in the header
Except for columns "recordDate", "recordTime", these are skipped.