File Processor Agent Example – Landtec

<< Click to Display Table of Contents >>

File Processor Agent Example – Landtec

 

Setting

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 x, where x =

1.underscore (_), else

2.dot (.), else if no underscore or dot,

3.everything.

Landtec.loggerDescPrefix

Landtec


Landtec.seriesNameColumnHeaderRegexGroups

^(?'a'.*)\n

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

Landtec.seriesUnitColumnHeaderRegexGroups

\n(?'a'.*)$

 

And default (non-Landtec) settings:

 

Setting

Value

Description

dateTimeFormats

local

Use the date and time format in the user's local settings.

delimiters

,

The fields are separated by commas.

utcOffsetHrs

0

DT_LOGGER.UTC_OFFSET_HRS

 

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