File Processor Agent File – Datum

<< Click to Display Table of Contents >>

 >Live > Agents > File Agents > File Processor > Settings > File >

File Processor Agent File – Datum

 

Setting

Type

Description

addNullIfDatumValueIs

String

Add a DT_LOGGER_DATUM row with DATUM_VALUE = NULL if a value in the file is one of these case-insensitive strings.

 

e.g., |NaN|NULL adds NULL if a value is empty, NaN, or NULL

 

e.g., 999 adds NULL if a value is 999

 

Star (*) adds NULLs for all non-float values.

 

Empty does not add any NULLs.

 

Note: If a value is not a float, it cannot be added to DT_LOGGER_DATUM.DATUM_VALUE, except as NULL.

dataEndLineRegex

Regex

Stop loading data at this line (see Diver example).

 

Start looking for a new header, if multiHeaderFiles = true
(see AreaRAE example).

logDatumValueParseErrors

Boolean

Log an error message if a datum value is not a float, and not in addNullIfDatumValueIs?

logDuplicateDatumRowErrors

Boolean

Log an error message if a there is a duplicate datum row (series and date and time) in a file?

updateExistingValues

Boolean

Update DT_LOGGER_DATUM.DATUM_VALUE and DATUM_QUALIFIER, if a datum row (LOGGER_SERIES_ID and DATUM_UTC_DT) already exists in the database?

 

The following settings are only used if seriesNameColumnHeaderRegex is not empty (see LoggerDatum example).

 

Setting

Type

Description

datumQualifierColumnHeaderRegex

Regex

The DT_LOGGER_DATUM.DATUM_QUALIFIER column header text pattern.

datumValueColumnHeaderRegex

Regex

The DT_LOGGER_DATUM.DATUM_VALUE column header text pattern.