Yokogawa

<< Click to Display Table of Contents >>

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

Yokogawa

Add the Yokogawa settings below to the ST_CONFIG table using the Live File Processor widget:

 

Settings

 

OBJECT_TYPE

OBJECT_VALUE

STRING_VALUE

Description

Yokogawa

dateTimeColumnHeaderRegex

(?i)Date

DT_LOGGER_DATUM.DATUM_UTC_DT; column header text starts with Date

Yokogawa

timeColumnHeaderRegex

(?i)Time$

Time (only) column header text pattern.

Yokogawa

headerLinesRegex

.*\\n.*\\n.*\\n(?i).*Date.*Time

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

Yokogawa

ignoreColumnHeadersRegex

Tag Comment

Do not add series or datum for columns whose header text contains Tag or Comment

Yokogawa

folderWatcherPath

C:\EarthSoft\Live\Yokogawa

The Folder that will be watched for new data.

Yokogawa

loggerCodeFileNameRegexGroups

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

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

Yokogawa

seriesNameColumnHeaderRegexGroups

^(?'a'.*)\\n

DT_LOGGER_SERIES.SERIES_NAME, SERIES_UNIT

 

(e.g., GAS FLOW, SCFM).

Yokogawa

seriesUnitColumnHeaderRegexGroups

\\n(?'a'.*)\\n.*$

 

Example File

 

SMARTDAC+ STANDARD,,R3.07.03,,,,,

Universal Viewer,,R3.07.03,,,,,

County,,,,,,,

,,,,,,,

Device Type,,DX1000,,,,,

Serial No.,,S6MB08172,,,,,

File Message,,,,,,,

Time Correction,,None,,,,,

Starting Condition,,Auto,,,,,

Dividing Condition,,Auto,,,,,

Meas Ch.,,3,,,,,

Math Ch.,,1,,,,,

Ext Ch.,,0,,,,,

Data Count,,863460,,,,,

Sampling Interval,,20.000,sec,,,,

Start Time,,2021/12/31,08:00:00,,,,

Stop Time,,2022/07/20,08:00:00,,,,

Trigger Time,,2022/07/20,08:00:00,,,,

Trigger No.,,123456,,,,,

Damage Check,,Not Damaged,,,,,

Started by,,,,,,,

Stopped by,,,,,,,

,,,,,,,

Calibration Corrected Ch.,,None,,,,,

,,,,,,,

Num. Of Converted Data,,12000,,,,,

Num. Of Converted Ch.,,4,,,,,

Converted Group,,1,-,,,,

Converted Format,,Group,,,,,

,,,,,,,

,,Ch.,C001,C002,C003,,C101

,,Tag Comment,GAS FLOW,OXYGEN,STACK TEMP,,TOTAL FLOW

,,Tag No.,,,,,

,,Unit,SCFM,%,Deg F,,SCF

Date,Time,sec,MIN,MIN,MIN,,MIN

2022/07/15,10:28:00,0.000,280,0.0,1581,,99219359

2022/07/17,17:14:00,0.000,420,0.0,1588,,485233

2022/07/20,07:10:00,0.000,387,0.0,1602,,1945137

 

 

1.File name: contains the DT_LOGGER.LOGGER_CODE field.

2.Header rows:

a.The line that begins with "Date,Time" is the header line, and contains the DT_LOGGER_DATUM.DATUM_UTC_DT column.

b.The "Tag Comment" column header is ignored.

c.The other column headers contain the DT_LOGGER_SERIES.SERIES_NAME value (e.g., GAS FLOW) and DT_LOGGER_SERIES.SERIES_UNIT value (e.g., SCFM)

3.Data rows:  the remaining rows contain the DT_LOGGER_DATUM.DATUM_VALUEs.