Live File Processor Agent Example

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.

Live File Processor Agent Example – Horiba

Live File Processor Agent Example – Horiba