How do I build history report from DeltaV (PI as historican database)?

Hello, I'm useing emerson DeltaV 7.3 with PI as "Continuous History" collector. If any one know a way that I can get the historian values of deltaV
tag, and copy it or show it in MS-Excel.
We need to build a weekly/monthly/yearly reports. All data are in one area and be send to the continuous history on the proplus, we can see all needed grafs. But didn't fine any way to copy or show it as text.
We have excel add-in, and we will not by any more PI tools (like pidatalink)
Thank you in advance for Your help Shai
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
You must use the report generator that is sold with deltaV, since it is a screwed up version of PI, or buy PI-to-PI, setup a real PI server and use excel datalink to extract the values.
I know that the PI server solution will set you back about $100k You might get datalink to work with DeltaV historian, but I doubt it. It is $950 per copy.
On 30 Mar 2005 14:45:15 -0800, snipped-for-privacy@gmail.com (Shai) wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I try to use excel-addin from deltaV. I wrote in excel : =DVread(@MOD@/AI1/PV.CV) and get the real time value of the poit. After that I build small VBA or macro for excel, the folowing sub is a macro in excel.
sub histOnExcel() Dim ROW,COL as integer ROW = Range("K1").Value ROW = ROW + 1 COL = 1 ' COL can be an index if we got more then one point. Cells(ROW,COL).Value = Cells(5,COL) Cells(1,11).Value = ROW ' Cell "K1" keep the value of the row end sub The problem is that I don't know how I make it run evry minute so I collect data.
If you there have any suggestion pleas send a reaply
Thanx Shai
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Try this:
Sub AutoRun() Static pttimeSet As Double
pttimeSet = Now + TimeValue("00:01:00") Application.OnTime pttimeSet, "Sheet1.mainCodeSub"
End Sub
Sub mainCodeSub() ... put your code here... AutoRun ' Runs the scheduler again End Sub
The autorun sub starts when the worksheet is opened. It schedules the main code to run in one minute. The main code macro runs on schedule and then calls the autorun command to reschedule itself after one minute.
Hope this helps.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I'll have to look at my plugin when I get to work on Monday. I tend to use @now and PI archived value from the PI menu In a column vertically below the @now, I subtract time to get historical times at set intervals, or use PI to select timed or # of responses.
This format will update everytime any cell in the spreadsheet is changed. Any other method, a macro equivalent of ctrl+alt+F9 would be needed.
On 31 Mar 2005 21:08:08 -0800, snipped-for-privacy@gmail.com (Shai) wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
A couple of questions. Is this a new installation of 7.3 or was it upgraded from a prior version?
With the older versions, one license for PI DataLink was included with the system. I believe that 7.3 also includes one license for PI Datalink as well. This is the best way to pull data out of the PI system for reports, etc.
While the PI Datalink is not included on the CDs, it may be downloaded from the Foundation Support Site.
DeltaV 7.4 has the new DeltaV Advanced Historian. A excel addin is provided to pull the data from the historian as well.
If you have trouble, your local rep office should be able to help.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hello Shai,

I would think the easiest way would be to use OSI's Excel add-in, but you can take a look at our iManageData software. It enables you to extract a series of PI tags over a specified date/time start/stop (or number of rows), then visually inspect the data (trends, scatters, histograms, etc.), filter it and export it to a delimited text file so you can import it into Excel. Info here: http://www.biocompsystems.com/products/imanagedata/index.htm We presently offer a free 30 day license for evaluation Note that the client machine must have PI API licensed from OSI and installed.

May I ask why?
Private replies are welcome at cmcook@ the domain below.
Carl Cook BioComp Systems, Inc. http://www.biocompsystems.com
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Polytechforum.com is a website by engineers for engineers. It is not affiliated with any of manufacturers or vendors discussed here. All logos and trade names are the property of their respective owners.