• Replies 7 replies
  • Subscribers 26 subscribers
  • Views 106 views
  • Users 0 members are here
Options
Related

Getting data out of PI to a CSV

jirvine

What is the best way to get data out of PI and into a CSV?

 

I have a new piece of software that wants a CSV updated every minute with PI data. There are about 1800 PI tags that will need to be pulled., and they are on different scan times. Some will update every 3 minutes up to every second. In the past  I have just used Excel to pull in PI tags with Datalink, and save that out to a CSV but we only do that once per day using Windows Task Scheduler. Not on a minute by minute basis. With 1800 tags and the way Excel 365 works with Datalink now this will take longer than 1 minute to extract the data and write the file. Is there a better way to set this up?

 

The application is Braincube. They have an interface they can setup to the plant system, but  with the way our security is setup it'll never get done. Infosec and the admins will never allow it.

 

Anyone else have experience with this?

Parents

  • Actually really simple, if you have a c# programmer. Would write a simple window service, accessing PI through AFSDK Data Pipes. Data Pipes can access either snapshot or archive data. Would have one thread retrieving data as soon as it comes in (snapshot) or as soon it is archived. Then place data on a thread safe queue. Have another thread continuously reading data from queue and writing to CSV file. Should not take more than a day to write and have up and running. Once running will work for as long as needed.

    Just make sure your window service is running under a windows service account and has access to read from PI Archive PIPOINTS.

Reply

  • Actually really simple, if you have a c# programmer. Would write a simple window service, accessing PI through AFSDK Data Pipes. Data Pipes can access either snapshot or archive data. Would have one thread retrieving data as soon as it comes in (snapshot) or as soon it is archived. Then place data on a thread safe queue. Have another thread continuously reading data from queue and writing to CSV file. Should not take more than a day to write and have up and running. Once running will work for as long as needed.

    Just make sure your window service is running under a windows service account and has access to read from PI Archive PIPOINTS.

Children
No Data