<< Click to Display Table of Contents >> Navigation: Live > Agents > File Agents > File Processor > Examples > Live File Processor Agent Example – Horiba |
Add the Horiba settings below to the ST_CONFIG table using the Live File Processor widget:
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 |
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. |
Copyright © 2024 EarthSoft, Inc. • Modified: 27 Feb 2023