Live Campbell Scientific LoggerNet Agent Example File Format

The Campbell Scientific LoggerNet 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.

"TOA5","ABC-03","CR1000","12345","CR1000.Std.27","CPU:FM6_101012.CR1","22222","Min_60"

"TIMESTAMP","RECORD","Veloc_ms_Avg","Direction_Deg_Avg","Temp_C_Avg","Solar_Rad_Tot","Evaporation_mm_Smp"

"TS","RN","m/s","Deg","C","MJ/m2","mm"

"","","Avg","Avg","Avg","Tot","Smp"

"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).