Live File Processor Agent File – Datum

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > File Agents > File Processor > Settings > File >

Live File Processor Agent File – Datum

Datum_Value

 

Setting

Type

Description

datumValueColumnHeaderRegex

Regex

Add DT_LOGGER_DATUM table rows for column(s) whose header text matches this pattern.

 

Default Value: All columns.

 

Also see ignoreColumnHeadersRegex; it may be easier to exclude a column using this setting rather than include it using datumValueColumnHeaderRegex.

 

And updateExistingValues to update the DT_LOGGER_DATUM.DATUM_VALUE and DATUM_QUALIFIER, if a datum row (LOGGER_SERIES_ID and DATUM_UTC_DT) already exists in the database.

 

Note: The datum values (in the files) are currently parsed using a dot decimal separator (e.g., 1.23), regardless of the user's local settings.

 

 

Datum_Qualifier

 

Setting

Type

Description

datumQualifierColumnHeaderRegex

Regex

The DT_LOGGER_DATUM.DATUM_QUALIFIER column header text pattern (see LoggerDatum example).

 

Also see defaultDatumQualifier* to set (DT_LOGGER_SERIES.DEFAULT_DATUM_QUALIFIER and) DT_LOGGER_DATUM.DATUM_QUALIFIER when adding a new datum row (if a datum qualifier – datumQualifierColumnHeaderRegex – is not provided).

 

 

Nulls

 

Setting

Type

Description

addNullIfDatumValueIs

String

Add a DT_LOGGER_DATUM table 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.

 

Default Value: NaN|NULL

 

 

Data End

 

Setting

Type

Description

dataEndLineRegex

Regex

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

 

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

 

 

Logging

 

Setting

Type

Description

logDatumValueParseErrors

Logging Level

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

 

Default Value: Off

logDuplicateDatumRowErrors

Logging Level

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

 

Default Value: Error