AnsweredAssumed Answered

How do I extract sampled Data (exp: every 30m) from PI Data Archive via "piconfig"?

Question asked by Muthulingam-EnQuest on Mar 6, 2019
Latest reply on Mar 6, 2019 by Muthulingam-EnQuest

Hi guys,

 

How do I extract sampled Data (example: every 30m) from PI Data Archive via "piconfig"?

 

Current Scenario:

I can do this via PI Datalink, but I find it hard to automate the Data extraction via PI Datalink everyday as I am unable to automate the connection authentication via VBA Code yet and I also noticed PI Datalink requires the user to click on the specific Output Cell and Click OK (at least twice) for it to refresh the Data every morning.

So in the mean time, I've decided to extract the data via "piconfig" commands. I noticed that I can extract all the Raw Data via the following "piconfig" command:

 

@tabl piarc

@istr tag, starttime, endtime, count

@ostr tag, value, time

@ostr ...

@output SEF-WH-DataT.txt

MY.SEA.54PT-PBC-F3.PV, 'y+6h', 't+6h', 10000000

MY.SEA.54PT-PBC-F3.PV, 'y+6h', 't+6h', 10000000

MY.SEA.54PT-PBC-F3.PV, 'y+6h', 't+6h', 10000000

 

What I want to achieve:

I want to extract a sampled data (saved in .csv) for every 30 minutes instead of all the raw data. Is there a way I can do this via "piconfig"?

 

Best regards,

 

Muthulingam Ramiah

Ganesh Supromaniam

Outcomes