I am new to PI system and new to VB code. But love to explore new concept. When I came across the system in the plant ..thought of creating model.. Few questions one buy one...

1) I have a tag which gives real time cum reading ..but like to have last 15mins..30mins flow ..How to start?

2) Wish to create a table and link it to a auto refresh web site...Is it possible?

Can any body help me..Thanks

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.

We are using PI-SDK version 1.3.3.
Presently nothing has been build up yet. Only we have an excel sheet which has partically all the tags which is being refreshed every hour to get the total consumption . I want the same stuff to be linked to the Process Book so that the data can be refreshed by itself .And would give comsumption at different time interval ..which would easy for us to monitor .Also shall give the difference from the predicted value.

I HOPE i am able to give some idea.
Lastly thanks RJK for the forum..

Hey uttamb, apologies for the delay.

What are you creating datasets in? I am assuming ProcessBook...?
Can you explain what tools you are using so I can help you out more accurately.

PI does not hold future data (yet - I believe this is on its way in a future release - no pun intended) so calculations will fail for future data.

To "blank" your calculations you could MultiState your symbols so any undesired result ("Color for Bad Data") is set to No Color. This way bad calculations are not shown on your display, once they calculate a good value they will magically reappear.

Hope this helps.

In my PI Process Book , I want show trends of data imported from a website. Data can be exported to an excel spreadsheet .
My Question: If it is possible! Do I need to give tag name in the spreadsheet or when stored in the PI server archive.

Thanks

Once again thanks...I tried to linked data from excel file through ODBC and it worked. Thanks ....

Earlier ..I was trying for future data value.. where RJK had mentioned to apply the Multi State to 'color off ' the bad data's.

When i used next time , the calc fail ..didnot appear ...instead 'count' came in the column ..3600 ..I couldnot understand how calc fail appeared last time.. Can it be explained ..please..

Thanks again

uttamb

Hi Uttamb,

Well one way I have done this in the past is to use Windows API.
Simple PlaySound function:
Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long

Then use a ProcessBook event (or some kind of timer) to check the state of the values you want a sound to play for. So imagine a few digital PI tags being displayed as a Value ProcessBook symbol on a display, loop round each symbol and check the current state - if it is in "alarm" play a sound. Then you make it a bit more clever and only play a sound on a change in alarm state, e.g. when a value goes into alarm.

Rhys.

By the way, glad your management liked your dashboard! Good we could help in some way...remember to spread the word on what a useful PI forum this is ;-)