Live Campbell Scientific LoggerNet Agent – DT_LOGGER Table

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > File Agents > Campbell Scientific LoggerNet >

Live Campbell Scientific LoggerNet Agent – DT_LOGGER Table

The DT_LOGGER table contains the following fields that are used by EQuIS Live LoggerNet Agent:

 

Field

Description

LOGGER_ID

A system-assigned unique identifier for the logger.

LOGGER_CODE

A user/vendor assigned code that identifies the logger program/configuration.

LOGGER_DESC

A description of the logger program/configuration.

START_DATE

The effective start date of this logger program/configuration.

END_DATE

The effective end date of this logger program/configuration.

UTC_OFFSET_HRS

The number of hours offset from UTC, disregarding Daylight Savings. This value is added to the date/time value in each TOA5 record to compute UTC time.

LIVE_DATA_SOURCE

The computer name and path to the LoggerNet output (*.dat) file for this logger,

 

e.g., 'csi://COMPUTER_NAME/C:/Campbellsci/LoggerNet/10162-LoggerNet-example.dat'

REMARK

A remark about this logger.

FACILITY_ID

The facility with which this logger is associated.

SYS_LOC_CODE

The location with which this logger is associated.

DEVICE_CODE

A code (e.g., serial number) that identifies the logger hardware.

DEVICE_DESC

A description of the logger hardware.

LOG_PERIOD_S

The number of seconds between each logging event on the data logger (aka, how often data is logged on the logger).

TRANSMIT_PERIOD_S

The number of seconds between each LoggerNet Data Collection (aka, how often data is transmitted from the logger to LoggerNet).

SYMBOL_ID

Reserved for future use.

STATUS_FLAG

A status flag to indicate whether or not this logger is active (aka, STATUS_FLAG = 'A').

CUSTOM_FIELD_1

"TOA5" (the type of file being written by LoggerNet).

CUSTOM_FIELD_2

A hash of the file header lines that is used to detect if a logger program has changed (additional parameters, different units, etc.).

CUSTOM_FIELD_3

Used as a bookmark that indicates the last record that was processed. It is in the form of "<byte offset from the beginning of the *.dat file to the last line>|<date/time of the last line>".

CUSTOM_FIELD_4

e.g., CUSTOM_FIELD_4 = '8192|C:\temp\archive' ('<max file size in bytes>|<destination folder>') will archive (move) file 'C:\Campbellsci\LoggerNet\10162-LoggerNet-example.dat' to 'C:\temp\archive\10162-LoggerNet-example.yyyyMMddHHmmssfff.dat' whenever it exceeds 8192 bytes in length.

 

e.g., CUSTOM_FIELD_4 = '1048576' ('<max file size in bytes>') will archive (move) file 'C:\Campbellsci\LoggerNet\10162-LoggerNet-example.dat' to 'C:\Campbellsci\LoggerNet\10162-LoggerNet-example.yyyyMMddHHmmssfff.dat' whenever it exceeds 1048576 bytes in length.

 

yyyyMMddHHmmssfff is the date and time when the file is archived, e.g., 20190502083234890.

CUSTOM_FIELD_5

Reserved for future use.

 

Note: Any changes made to DT_LOGGER and/or DT_LOGGER_SERIES tables while the agent service is running will require a restart of the agent service.