Live File Processor Agent Example – Horiba

<< Click to Display Table of Contents >>

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

Live File Processor Agent Example – Horiba

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

 

OBJECT_TYPE

OBJECT_VALUE

STRING_VALUE

Description

Horiba

dateTimeColumnHeaderRegex

^Date

DT_LOGGER_DATUM.DATUM_UTC_DT date; column header text starts with Date.

Horiba

folderWatcherPath

C:\EarthSoft\Live\Horiba


Horiba

headerLinesRegex

Date.*Time

The header line contains Date + anything (.*) + Time.

Horiba

ignoreColumnHeadersRegex

^No.|[Ee]rror|code|^[0-9]+$

Do not add series or datum for columns whose header text:

1.Starts with No.

2.Contains E or e + rror

3.Contains code

4.Contains only numbers (0-9)

 

Note: Non-float datum values
(e.g., Latitudes and Longitudes = -- -- -- -) are also not added, but this is done on a case-by-case basis.

Horiba

loggerCodeColumnHeaderRegex

^SITE

DT_LOGGER.LOGGER_CODE

Horiba

timeColumnHeaderRegex

^Time

DT_LOGGER_DATUM.DATUM_UTC_DT time; column header text starts with Time.

 

 

 

U-50PC DataFile,Version,1,989,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

No.,SITE,Date,Time,Latitude,Longitude,Probe error,Temperature,10,Error,pH,1,Error,pHmV,24,Error,ORP,2,Error,Conductivity,6,Error,Turbidity,3,Error,Dissolved Oxygen,4,Error,DO%,22,Error,TDS,8,Error,Salinity,7,Error,Specific gravity,9,Error,Depth,11,Error,---,0,Error,Battery voltage,Device code,Date code,Time code,Unit code,Format code,Status code,Sensor error code

3,B-30              ,2/27/2013,8:46:35,-- -- -- -,--- -- -- -,,18.36,°C,,6.6,pH,,-,-,-,168,mV,,0.695,mS/cm,,310,NTU,,3.79,mg/L,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,    V,P30,D130227,T084635,U0000000000000,F2200302131100,S1101111000000,A0000000000000

4,B-30              ,2/27/2013,8:47:05,-- -- -- -,--- -- -- -,,18.36,°C,,6.6,pH,,-,-,-,168,mV,,0.694,mS/cm,,334,NTU,,3.75,mg/L,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,    V,P30,D130227,T084705,U0000000000000,F2200302131100,S1101111000000,A0000000000000

5,B-30              ,2/27/2013,8:47:35,-- -- -- -,--- -- -- -,,18.31,°C,,6.6,pH,,-,-,-,167,mV,,0.692,mS/cm,,354,NTU,,3.75,mg/L,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,    V,P30,D130227,T084735,U0000000000000,F2200302131100,S1101111000000,A0000000000000

 

 

 

Note: The series units (e.g., °C, pH, mV, mS/cm, NTU, etc.) in the data lines (in the columns with number-only header text, which we ignore) are not added to DT_LOGGER_SERIES.SERIES_UNIT; seriesUnitColumnHeaderRegexGroups requires the units to be in the headerLinesRegex lines, and to be in the same column as their series names.
 
A SERIES_UNIT and/or SERIES_DESC may be added later, manually, but the SERIES_NAME cannot be changed; it uniquely identifies the series.