AnsweredAssumed Answered

PI UFL - Skip data after given timestamp

Question asked by Hoedr on Feb 17, 2020
Latest reply on Feb 24, 2020 by mhruzik

Hi,

 

we are using PI UFL to write data to PI from a legacy application. The input file(s) provides data in format:

 

BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:00:49;31.6
BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:01:49;31.6
BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:02:49;31.5
BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:03:49;31.6
BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:04:49;31.6
BD1_MR07:COMP301104:Ruimte:Vocht:Opnemer:GemW;31-Mar-18 02:05:49;31.6

 

The input file(s) provide data in timerange 1-Jan-2018 - 31-Dec-2019. 
However, we want to stop the writing of data after 5-May-2019 and thus skip all data coming after this timestamp.

 

Below you find the current PI UFL configuration file, any advice how this can be managed?

 

[INTERFACE]
PLUG-IN=AsciiFiles.dll

[PLUG-IN]
IFM=C:\SAIA\*.txt
IFS=N
REN=_OK
ERR=BAD
PURGETIME=1d
PFN=False
PFI=False
NEWLINE=13,10

[SETTING]
DEB=0
MAXLOG=10
MAXLOGSIZE=20
MSGINERROR=C:\Program Files\PIPC\Interfaces\PI_UFL\Logs\err.log
OUTPUT=C:\Program Files\PIPC\Interfaces\PI_UFL\Logs\out.log
LOCALE=en-us

[FIELD]
FIELD(1).NAME="TagName"
FIELD(1).TYPE="String"
FIELD(2).NAME="TimeStamp"
FIELD(2).TYPE="DateTime"
FIELD(2).FORMAT="dd-MMM-yy hh:mm:ss", "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"
FIELD(3).NAME="Value"
FIELD(3).TYPE="Number"

[MSG]
MSG(1).NAME="Data"

[Data]
Data.FILTER=C1=="*"
TagName=["(*);*;*"]
TimeStamp=["*;(*);*"]
Value=["*;*;(*)"]
StoreInPI(TagName, ,TimeStamp,Value, , )

Outcomes