Author Topic: PI Processbook and Visio  (Read 3966 times)

0 Members and 1 Guest are viewing this topic.

Wardaug

  • Newbie
  • *
  • Posts: 1
PI Processbook and Visio
« on: March 27, 2017, 06:31:10 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4878
  • Ideas Visio-lized into solutions
Re: PI Processbook and Visio
« Reply #1 on: March 27, 2017, 08:02:35 PM »
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

  • Hero Member
  • *****
  • Posts: 3234
Re: PI Processbook and Visio
« Reply #2 on: March 28, 2017, 01:00:05 AM »
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.
« Last Edit: March 28, 2017, 01:37:22 AM by Yacine »
Yacine

metuemre

  • Full Member
  • ***
  • Posts: 178
Re: PI Processbook and Visio
« Reply #3 on: March 28, 2017, 02:49:47 AM »
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.

« Last Edit: March 30, 2017, 05:55:40 AM by metuemre »