ACOEM CSV File Downloader

The CSV File Downloader is a file based station driver that offers advanced CSV file reading and import possibilities.

This driver takes a number of parameters, some of which are mutually exclusive.

The Link type should be set to Custom and the Parameters list populated.

Note that this driver can not be used for manual imports

ColumnSelection

Optional - A comma separated list of indices used to select the required columns. The first index in the list is considered to be the Timestamp index if the TimestampIndex isn’t used.

Multiple columns can be specified by using a hyphen e.g. 5-10.

An example: 3,5-10,12,14,18-12

DateTimeFormat

Format of the expected Timestamp string, defaults to dd/MM/yyyy HH:mm. See the Custom Date and Time formats and note that they differ slightly from the manual.

e.g. dd/MM/yyyy HH:mm would be something like 05/12/2023 13:34

Delimiter

The delimiter of the fields, defaults to a comma

EpochBaseDate

Used for epoch based timestamps and taking the form 01/01/1970 00:00:00, leave empty if not used.

EpochIncrement

Used for epoch based timestamps and defined in seconds, leave empty if not used.

FileFilter

The filter applied to the files in the given directory, only files matching this filter pattern will be ingested e.g *.csv for any csv files

FilePath

The fully specified path where files for ingest can be found. Double forward slashed should be used e.g. C://MyData//MyFolder

IndexFirstData

The 0 based row index where the first data row can be found, defaults to 1.

IndexHeaderRow

The 0 based row index where the column header data can be found, defaults to 0.

IndexUnitsRow

Optional - The 0 based row index where the column units can be found

TimestampIndex

The 0 based column index where the timestamp can be found, defaults to 0.

Where the Date and Time are in different columns these can be specified using d and t prefixes

e.g. d3 t4 for Date in the 3rd column and Time in the fourth, note the space between them.