File Processor Agent Example – In-Situ-5

<< Click to Display Table of Contents >>

Live > Agents > File Agents > File Processor > Examples >

File Processor Agent Example – In-Situ-5

 

Setting

Value

Description

In-Situ-5.dateTimeColumnHeaderRegex

^\s*(Created|Date and Time)

DT_LOGGER_DATUM.DATUM_UTC_DT; column header text starts with zero or more whitespace characters, followed by Created, or Date and Time.

In-Situ-5.folderWatcherPath

C:\EarthSoft\Live\In-Situ-5


In-Situ-5.headerLinesRegex

^\s*(Created|Date and Time.*[Ss]econds)

The header line starts with zero or more whitespace characters, followed by Created, or Date and Time + S or s + econds.

In-Situ-5.loggerCodeHeaderLinesRegexGroups

^Site[:,]*(?'a'[^,]*)

DT_LOGGER.LOGGER_CODE

In-Situ-5.loggerDescPrefix

In-Situ


In-Situ-5.seriesNameColumnHeaderRegexGroups

((?'a'.*)\(|(?'b'.*))

DT_LOGGER_SERIES.SERIES_NAME

In-Situ-5.seriesUnitColumnHeaderRegexGroups

\((?'a'[^)]*)\)[^(]*$

DT_LOGGER_SERIES.SERIES_UNIT

 

And default (non-In-Situ-5) settings:

 

Setting

Value

Description

dateTimeFormats


Empty; determined automatically.

delimiters

,

The fields are separated by commas.

utcOffsetHrs

0

DT_LOGGER.UTC_OFFSET_HRS

 

Example File 1

 

 

Report Date:,9/22/2016 4:25:26 PM,,,

Report User Name:,daenerys,,,

Report Computer Name:,R76,,,

,,,,

,,,,

Log File Properties,,,,

File Name,Troll300.csv,,,

Create Date,9/20/2016 10:48:30 AM,,,

,,,,

Device Properties,,,,

Device,Level TROLL 300,,,

Site,Mereen,,,

Device Name, ,,,

Serial Number,654321,,,

Firmware Version,2.04,,,

Hardware Version,3,,,

,,,,

Log Configuration,,,,

,Log Name,X12,,

,Created By,Targaryen,,

,Computer Name,Pocket PC,,

,Application,WinSituMobile.exe,,

,Application Version,5.5.10.3,,

,Create Date,12/23/2015 7:56:35 AM,,

,Notes Size(bytes),4096,,

,Type,Linear,,

,Overwrite when full,Enabled,,

,Scheduled Start Time,12/23/2015 8:00:00 AM,,

,Scheduled Stop Time,No Stop Time,,

,Interval,Days: 0 hrs: 04 mins: 00 secs: 00,,

,,,,

,,,,

,,,,

Level Reference Settings At Log Creation,,,,

,        Level Measurement Mode,Level Depth To Water,,

,              Specific Gravity,0.999,,

,          Level Reference Mode:,Set new reference,,

,         Level Reference Value:,31.84 (ft),,

, Level Reference Head Pressure,30.257 (PSI),,

,                 Head Pressure,29.3932 (PSI),,

,                   Temperature,13.7213 (C),,

,                Depth of Probe,67.8679 (ft),,

,,,,

,,,,

Log Notes:,,,,

Date and Time,Note,,,

12/23/2015 7:56:39 AM ,Sensor:654321 Factory calibration has expired.: 2/23/2010 4:06:16 PM,,,

,,,,

,,,,

Log Data:,,,,

Record Count,1633,,,

,,,,

Sensors,1,,,

,,,,

,1,654321,Pressure/Temp 100 PSIA (60.1m/197.3ft),

,,,,

Time Zone: Pacific Standard Time/Pacific Daylight Time,,,,

,,,,

,,Sensor: Pres(A) 197.3ft  ,Sensor: Pres(A) 197.3ft  ,Sensor: Pres(A) 197.3ft  

,Elapsed Time,SN#: 654321     ,SN#: 654321         ,SN#: 654321    

Date and Time,Milliseconds,Pressure (PSI)           ,Temperature (C)          ,Level Depth To Water (ft)

12/23/2015 8:00:00 AM ,0,29.418718,13.658508,31.764286

12/23/2015 12:00:00 PM,14400.001,29.415125,13.651779,31.772583

12/23/2015 4:00:00 PM ,28800.001,29.420811,13.649857,31.759455

 

 

Example File 2

 

 

Log:,Default Site- 1 of 2,,,,,,,,,,,,,,

Report Created:, 2015-06-14 14:20:31,,,,,,,,,,,,,,

Site:,SpringField,,,,,,,,,,,,,,

Log Created:, 1970-01-02 05:58:40,,,,,,,,,,,,,,

Number Readings:,8,,,,,,,,,,,,,,

Battery Type:, SmarTROLL™ Battery Pack,,,,,,,,,,,,,,

Battery SN:,363879,,,,,,,,,,,,,,

Device Type:, SmarTROLL™ MP,,,,,,,,,,,,,,

Device SN:,ABC1234,,,,,,,,,,,,,,

Created, Baro (mbar), Temp (C), RDO (mg/L), RDO Sat (%), pH (pH), ORP (mV), Act Cond (µS/cm), Sp Cond (µS/cm), Salinity (psu), Resist (Ohm-cm), Density (g/cm^3), TDS (ppt), Depth (ft), Pressure (psi), Air Temp (C)

1/2/1970 5:58,986.2,20.05,7.81,92.2,7.64,92.9,10997,12143.4,7,91,1.004,8,0.02,0.011,20.9

1/2/1970 6:03,986.3,20.37,4.38,52,7.14,12.6,11164.3,12246.6,7.1,90,1.004,8,0.01,0.005,20.8

1/2/1970 6:08,986.2,21.31,1.65,20,6.79,-12.8,11599.7,12480.2,7.2,86,1.003,8,0.03,0.012,20.8