OSI PI Module

[Duc M Do]

​List,

Short of getting this directly from Ricardo, I think this list is the next best thing.

I've never installed the OSI PI module for Foxray before, and I'm attempting to do it now. But I have no idea what kind of data the module is supposed to report from the PI server(s).  I can see the simple query that's to be run on the PI server, but I have no idea what it returns.

A couple of questions: (1) Does anyone here use this module? (2) Would you mind answering newbie questions?

Thanks!

Duc

[Joseph M. Riccardi]

It’s been years since I installed and used it but I think the OSI PI module returns data like the Historian; lists all points and their configuration parameters.  Hopefully I am close and this gives you something to consider until a real expert answers…  J

 

 

Joseph M. Riccardi

386-451-7607 Cell

 

J...@eRiccardi.com

 

"To give real service you must add something that cannot be bought or measured with money; and that is sincerity and integrity." - Donald A. Adams

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.
Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

[Ron Schafer]

HI Duc,

Lucky for you we have the interface, have not done much with it before but it basically returns all the Pi points and all the Pi point settings like name interface location 1,2,3,4,5 scan rate, etc. Foxray uses it to map the pi point to the dcs points. Ricardo did our in a very short time.

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Duc M Do
Sent: Thursday, May 26, 2016 3:12 PM
To: limewar...@googlegroups.com
Subject: {foxray} OSI PI Module

 

​List,

--

[Currano, Joe]

As far as I know it just dumps the pi tag list into Foxray so Foxray can tell which DCS blocks go to pi, and which pi tags are bad (integrity checks tells you if pi tags are looking for a block that doesn't exist). I've used it for those two things, it's nice to see and helped me clean up our pi database, some tags needed fixing (instrument tag spelling, unit number, etc) and others we deleted.

  However, if you the DCS engineer have no access on the pi server, it is hard to maintain the Foxray script on it, if you ever need to update the Foxray server IP address it sends to, or just restart the service if it stops for some reason. Also keep in mind the normal setup is pi server sending data to Foxray server, so there's a potential security hole there if pi is on an insecure (compared to your DCS) network. (You might be able to do it the other way around, though, with Foxray grabbing from pi.)

  If security is not a problem it's nice to have.

-Joe

[Joseph M. Riccardi]

I am not sure limewar...@googlegroups.com is the appropriate list any more, it was my understanding the fox...@freelists.org would absorb Foxray questions… but then again you’re the Boss…

 

Sorry Duc, not quite.  This is the OSI PI Table content from the Tables Manual…  YUK!  I’ll send you the Tables Manual off line…  Do you have the Installation Manual for OSI PI?

 

 

III.49 histdb_pi_main

Table name: histdb_pi_main

Description: PI Tag References to Fox I/A

Field Name

Field Description

Data Type

 

PI_TAGNAME

PI Tagname

Varchar

 

PI_DESCRP

PI Description

Varchar

 

PI_ENGUNITS

PI engineering Units

Varchar

 

POINTSOURCE

Point Soure of the OSI-PI tag

Varchar

 

POINTYPE

n/a

Varchar

 

IO

Input / Output (Read or Written from PI)

Varchar

 

CP

CP Name

Varchar

 

COMPOUND

Compound Name

Varchar

 

BLOCK

Block Name

Varchar

 

PARAMETER

Parameter Name

Varchar

 

DESCRIPTION

Description in Fox I/A

Varchar

 

REF_EXIST

If Reference to Fox I/A exist or not

(0=Does Not Exist / 1=Exist)

Varchar

 

PIINDEX

PI Index

Integer

 

PISERVER

Name of pi Server

Varchar

 

PIZERO

PI Zero Scale

Varchar

 

PISPAN

PI Span Scale

Varchar

 

LOCATION1

Location 1 Field – PI Interface

Varchar

 

LOCATION2

Location 2 Field – List Number

Varchar

 

LOCATION3

Location 3 Field – I/A Point Type

Varchar

 

LOCATIION4

Location 4 Field – List Scan Rate

Varchar

 

YUK!  I’ll send you the manual off line…

 

 

Joseph M. Riccardi

386-451-7607 Cell

 

J...@eRiccardi.com

 

"To give real service you must add something that cannot be bought or measured with money; and that is sincerity and integrity." - Donald A. Adams

 

[Duc M Do]

Thanks Ron. Also, thank you to Joe R. for your reply.

From the Foxray interface, I see no selection for PI itself, so I assume that, as you said, the PI tag data are mapped to the proper C:B.P object​s. Can you share a typical screen shot showing PI tag information? (I'm not sure if this googlegroups list allows attachments; cc: me in case the attachments don't get distributed to the list. Thanks!)

Duc

[Duc M Do]

​Joe,

Firewall access *is* one of my problems. The Foxray server is on the secure side of the firewall, and they (the IT folks) don't open port 21 for ftp from outside through the firewall. I'm pleading my case as we speak, but probably to no avail. Luckily, my PI guy is very knowledgeable and he thinks we can pull data from the Foxray server using PI OLE DB. We'll see.

Duc

[John / SRP]

Hi Duc,,

  We use the OSI_PI addin, but manually update the file to Foxray rather than having an open communication path between the PCs.

See attachment for layout, ver 2.5...

John

[Joseph M. Riccardi]

Duc,

 

Not exactly sure I understand the situation or the goal yet but…

 

If you install the OSI PI Module on Foxray (I am guessing that is the path you are on?) why can’t you or your PI guy just RDP or install the Foxray client on any Windows box and run an Advance Query directly on the OSI PI Table?  I always have to just ask Ricardo for the query but I’m sure you know how to do it…

 

 

Joseph M. Riccardi

386-451-7607 Cell

 

J...@eRiccardi.com

 

"To give real service you must add something that cannot be bought or measured with money; and that is sincerity and integrity." - Donald A. Adams

 

--

[Ricardo Abech]

Hi Duc,

 

The OSI PI Module collects data from the pipoint table in OSI PI. It uses ipisql tool (command line PI tool to run queries) to gather it. As your PI admin mention, this can be run from other machines instead of only the PI server if direct connection (FTP or shared folders) is an issue.

 

Another option when connection is not possible is to run the script and then manually push the data (air gap) from the PI server to the System Auditor (forxay) server.

 

The PI Module gives you the following capabilities:

 

-        Find connections between PI and Foxboro DCS (and map names between those 2 systems)

-        Allow detection of missing connections in PI and DCS

-        Add the PI connections in the Loop drawings in System Auditor

-        Compare Ranges, Descriptions and Eng Units between systems and create alerts of mismatches

-        Create automated reports to be sent to PI Admin when new blocks are added and match specific rules (defined by user), so the PI admin can create the points.

-        Document all PO points and its properties (Point source, LOCATION1, 2, 3, etc)

 

Thanks

 

Ricardo

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Duc M Do
Sent: Thursday, May 26, 2016 3:53 PM
To: limewar...@googlegroups.com
Subject: Re: {foxray} OSI PI Module

 

​Joe,

--

[Currano, Joe]

Can you tell us how to install and run it on an office computer to manually load into Foxray once in awhile?

Thanks,

-Joe

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Ricardo Abech
Sent: Friday, May 27, 2016 12:46 AM
To: limewar...@googlegroups.com
Subject: RE: {foxray} OSI PI Module

 

Hi Duc,