Live File Processor Agent Example – Landtec

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > File Agents > File Processor > Examples >

Live File Processor Agent Example – Landtec

Add the following settings to the ST_CONFIG table (CONFIG_SECTION = 'Live.FileProcessor', CONFIG_KEY = 'Agent').

 

OBJECT_TYPE

OBJECT_VALUE

STRING_VALUE

Description

Landtec

dateTimeColumnHeaderRegex

(?i)date

DT_LOGGER_DATUM.DATUM_UTC_DT; column header text contains (case-insensitive) date.

Landtec

folderWatcherPath

C:EarthSoft\Live\Landtec


Landtec

headerLinesRegex

(?i)id.*date\n.*

The header has two (case-insensitive) lines that look like this:

1.contains id + anything (.*) + date

2.anything (.*)

Landtec

loggerCodeFileNameRegexGroups

^(?'a'[^_.]*)

DT_LOGGER.LOGGER_CODE = file name text before first underscore (_) or dot (.).

 

See YSI-6 example.

Landtec

seriesNameColumnHeaderRegexGroups

^(?'a'.*)\n

DT_LOGGER_SERIES.SERIES_NAME and SERIES_UNIT, e.g., CH4, %.

Landtec

seriesUnitColumnHeaderRegexGroups

\n(?'a'.*)$

 

 

Example File 1

 

 

Device ID,Date/Time,CH4,CO2,O2,Balance,%LEL,Init. Static Press.,Adj. Static Press.,Init. Diff. Press.,Adj. Diff. Press.,Init. Gas Temp.,Adj. Gas Temp.,Init. Flow,Adj. Flow,Init. Power,Adj. Power,Baro. Press.,Sys. Press.,Gas Pod Type,Gas Pod Value,CO,H2S,SO2,NO2,CL2,H2,HCN,Inst-Tech,Latitude,Longitude,Altitude,UTC,SatsUsed,Herror,Verror,HDOP,Status,FLD-Tech,DL-Tech,Serial Number,Ambient-Temp,Precipitation,Wind-Speed,Wind-Direction,Anemometer Vel.,PeakCH4,PeakCO2,Anemometer Flow,MinO2,Temp. GA Mode,Rel. Press.,Site Chosen,Comments,Answers,Site Answers

"GEM™2NAV; Version 3_13L,02/07/13; LSGAM:6_0_20150403; {85929818947}",,%,%,%,%,%,inches H2O,inches H2O,inches H2O,inches H2O,DegF,DegF,SCFM,SCFM,e3BTU/h,e3BTU/h,inches Hg,inches H2O,type,ppm,,,,,,,,,,,ft,,,m,m,,,,,,,,,,m/s,%,%,m3/hr,%,DegF,inches H2O,,,,

ELPP011B,12/1/2017 9:05,0,5.6,16.2,78.2,0,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,28.6,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,    ,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,TKINNEVEY,gas (prm),GM11803,0,0,0,,N/A,N/A,N/A,N/A,N/A,N/A,0,",,,,,,,",",,,,,,,",",,",",,,,"

ELPP016B,12/1/2017 9:10,0,3.1,17.8,79.1,0,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,28.6,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,    ,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,TKINNEVEY,gas (prm),GM11803,0,0,0,,N/A,N/A,N/A,N/A,N/A,N/A,0,",,,,,,,",",,,,,,,",",,",",,,,"

ELPP017A,12/1/2017 11:30,0,1.3,17.6,81.1,0,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,28.51,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,    ,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A,TKINNEVEY,gas (prm),GM11803,0,0,0,,N/A,N/A,N/A,N/A,N/A,N/A,0,",,,,,,,",",,,,,,,",",,",",,,,"

 

 

 

Example File 2

 

 

Model,GA5000,Serial No,G501297,,,,,,,,,,,,,,,,,

Date downloaded,24/11/2017 09:39,Software Version,1.9.11,,,,,,,,,,,,,,,,,

Computer & User Info,LAP269493,JJG,,,,,,,,,,,,,,,,,,

Date of last user calibration,21/11/2017,,,,,,,,,,,,,,,,,,,

Date of last factory calibration,13/09/2017,,,,,,,,,,,,,,,,,,,

Next service due,13/03/2018,,,,,,,,,,,,,,,,,,,

Date of last Gas Check,N/A,,,,,,,,,,,,,,,,,,,

De-selected channels,H2, LAT, LONG, ALTITUDE, UTC, SATSUSED, HERROR,,,,,,,,,,,,,

VERROR, HDOP, STATUS, CHOSEN 1, CHOSEN 2, CHOSEN 3, CHOSEN 4,,,,,,,,,,,,,,

CHOSEN 5, CHOSEN 6, CHOSEN 7, CHOSEN 8, ANSWER 1, ANSWER 2, ANSWER 3,,,,,,,,,,,,,,

SITECHOSEN 1, SITECHOSEN 2, SITECHOSEN 3, SITECHOSEN 4, SITECHOSEN 5, SITECHOSEN 6, SITECHOSEN 7,,,,,,,,,,,,,,

SITECHOSEN 8, SITEANSWER 1, SITEANSWER 2, SITEANSWER 3, SITEANSWER 4, SITEANSWER 5, ADJ-SP,,,,,,,,,,,,,,

ADJ-DP, ADJ-TEMP, ADJ-FLOW, ADJ-POWER, INI-SP, INI-DP, INI-TEMP,,,,,,,,,,,,,,

INI-FLOW, INI-POWER,,,,,,,,,,,,,,,,,,,

Security code,[16723CD5],,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

ID,DATE,CH4,CO2,O2,BALANCE,PEAKCH4,PEAKCO2,MIN O2,CH4 %LEL,BARO,TEMPERATURE,REL.PRESSURE,REL.PRESSURE2,DIPMETER,ANEMOMETER.VEL,ANEMOMETER.FLOW,TECH.ID,INTERNAL FLOW,CO,H2S

,,%,%,%,%,%,%,%,%,mb,DegC,mb,mb,,m/s,m3/h,,l/h,ppm,ppm

BH08,21/11/2017 12:22,0,1.3,19.9,78.8,0,1.3,19.9,0,1010,,-0.66,,,,,JJG_,0,0,0

BH07,21/11/2017 12:40,0,0.6,20.7,78.7,0,0.6,20.7,0,1010,,0.16,,,,,JJG_,0,0,0

BH10,21/11/2017 12:56,0,0.2,21.2,78.6,0,0.2,21.2,0,1010,,0.02,,,,,JJG_,0,0,0