News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

PI Processbook and Visio

Started by Wardaug, March 27, 2017, 11:31:10 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Wardaug

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

wapperdude

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
Visio 2019 Pro

Yacine

#2
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.
Yacine

metuemre

#3
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

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

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

If you need more help, feel free to ask.


Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 209 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1122KB.
Tokens: post-login.
Cache hits: 13: 0.00164s for 26,734 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]