Hi,
New to this forum, I've searched around trying to find a solution to this problem. I use Visio to create training slides at work, I make one line drawings of process flow (oil production). So piping, valves and process controls. I am trying to imbed PI process book (live process values) into Visio. Is there any experience in doing this?
Thanks,
Wardaug
What do you mean by PI process book? Is this some sort of document, Excel file? Are you trying to just insert the PI book, or are you trying to extract values from it? Are the values merely displayed or are they assigned to specific shapes? Is the information in some sort of organized structure that would aid retrieval?
A small example is always beneficial. VSD format will get the greatest attention. Pictures help too.
Wapperdude
http://www.osisoft.com/pi-system/pi-capabilities/pi-system-tools/pi-processbook/ (http://www.osisoft.com/pi-system/pi-capabilities/pi-system-tools/pi-processbook/)
Guess the system can export excel files. These files can then be linked to your visio drawing to visualize your processes.
The best way is to code a custom OPC Client for Visio. Then you can read live data from OPC Server of PI and use Visio like an HMI diagram.
You can use macros written for Excel as starting point. One example is below;
http://www.engineers-excel.com/Apps/OPC/Description.htm (http://www.engineers-excel.com/Apps/OPC/Description.htm)
You need a wrapper .dll file from an OPC Vendor like Kepware, Matrikon, etc. or you can use a free wrapper like the one below;
http://gray-box.net/daawrapper.php (http://gray-box.net/daawrapper.php)
I strongly suggest you read the OPC DA Automation Interface Standard of OPC foundation before doing anything to understand the mechanism behind OPC protocol. PDF file download link is below;
https://www.dropbox.com/s/rfbg9orzagln1gu/OPC%20DA%20Auto%202.02%20Specification.pdf?dl=0 (https://www.dropbox.com/s/rfbg9orzagln1gu/OPC%20DA%20Auto%202.02%20Specification.pdf?dl=0)
If you need more help, feel free to ask.