Example File Format

<< Click to Display Table of Contents >>

EQuIS 7  >>  Live > Agents > Campbell Scientific LoggerNet >

Example File Format

This agent will read files formatted as follows, and add their data to the LOGGER database tables: DT_LOGGER, DT_LOGGER_SERIES, and DT_LOGGER_DATUM.







"2017-06-22 16:00:00",3812,1.918,358.5,26.4,1.847365,0.258

"2017-06-22 17:00:00",3813,2.179,21.56,26.17,1.29014,0.257

"2017-06-22 18:00:00",3814,2.844,42.54,24.73,0.5120003,0.311



The fields in the files must be separated (delimited) by commas and/or tabs, and may be enclosed in double quotes.


Line 1 contains the DT_LOGGER (and DT_EQUIPMENT) info, such as:

LOGGER_CODE = ABC-03:MIN_60:22222

LOGGER_DESC = ABC-03:Min_60,

LIVE_DATA_SOURCE = csi://COMPUTER_NAME/C:/Campbellsci/LoggerNet/10162-LoggerNet-example.dat

DEVICE_CODE = CR1000:12345

DEVICE_DESC = CR1000.Std.27:CPU:FM6_101012.CR1

UTC_OFFSET_HRS = The computer's UTC offset (e.g., -5 hours for Eastern Standard Time, NOT adjusted for daylight savings time). Or, if the dateTimeOffsetSkip setting is set to true, 0.


Note that "TOA5" at the beginning of line 1 indicates the type of file being written by LoggerNet.


Lines 2, 3, and 4 contain the DT_LOGGER_SERIES.SERIES_NAMEs, SERIES_UNITs, and SERIES_FUNCTIONs, respectively.


The DT_LOGGER_DATUM begins on line 5. The DT_LOGGER_DATUM.DATUM_UTC_DT is set to the TIMESTAMP (which must be the FIRST field in the line) minus the DT_LOGGER row's UTC_OFFSET_HRS (e.g., 2017-06-22 16:00:00 - -05:00:00 = 2017-06-22 21:00:00).