Overview

Import type EnviromonCsv imports accumulated precipitation data from files in CSV file format.
The file has three header lines containing a description of the time series, followed by data lines.
The file may contain empty and comment lines that begin with '=' character. Comment and empty lines are skipped.

The header lines:

• The first line contains the keywords PERIOD START and PERIOD END, and the location names for which the time series are given. This line is only used to determine the number of locations in the file.
• The second line starts with two empty fields, followed by location Id's. These Id's are the external Id's and can be mapped to the Fews internal Id's in the Fews Id map file.
• The third line starts with two empty fields, followed by the unit in which the data are given.

Data lines:
Each line contains start and end of the accumulation period, and the values for each location in the next fields.
The date/time format is yyyy-mm-dd HH:MM:SS. Character '-' is regarded as missing value. The only allowed decimal separator is a dot.
The values are stored at the end of the accumulation period.

Import type

The import type is EnviromonCsv. There is no particular file extension required. The files can also be supplied in a ZIP file.

Example

Here is a simple example:

=========================================================
====   REPORTS FOR   Sensors  -

PERIOD START,  PERIOD END,   Gympie,  MTT,  Wongaw, LSV
,,  28038.,40335,  40341 ,  40376.
,,  mm,mm,mm, mm

25/03/2010 23:45:00,26/03/2010 00:00:00,- ,0, 1.1,0
25/03/2010 23:30:00,25/03/2010 23:45:00,- ,0,- ,0
25/03/2010 23:15:00,25/03/2010 23:30:00,- ,0,- ,0
25/03/2010 23:00:00,25/03/2010 23:15:00,- ,0,- ,0
25/03/2010 22:45:00,25/03/2010 23:00:00,- ,0,- ,0
25/03/2010 22:30:00,25/03/2010 22:45:00,- ,0,- ,0
25/03/2010 22:15:00,25/03/2010 22:30:00,- ,0,- ,0
25/03/2010 22:00:00,25/03/2010 22:15:00,- ,2.2,- ,0
25/03/2010 21:45:00,25/03/2010 22:00:00,- ,3.3,- ,0