Hi Magdi,
I use a script to extract three hourly averages from our "legacy"
(Informix database) historian reduction groups.
I write the values to shared memory variables on an AW51 so they can be
displayed on a regular Foxview screen.
The only tricky part is getting the appropriate times for isql to use. I
use a small c program to convert a date to unix time, and then I add in the
additional seconds for the time since midnight. The program really isn't
necessary because it is relatively simple to calculate the time, but I had
written the date2unix program for another project so I re-used it.
There are probably better & easier ways to extract the values and
calculate the times, but my method works & it was fun to develop.
I can send you a copy of the script if you would like to see it, but you
would have to determine the field names, table names and pt_id_key of your
historian points and edit the script for it to work.
Stephen Murray
Asarco
----- Original Message -----
From: "Magdi Abdel halim" <[EMAIL PROTECTED]>
To: "Foxboro DCS Mail List" <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 12:07 PM
Subject: History points
> Hi foxboro list,
> How can I read the history information like Hourly average for a
certain
> Compound:Block.parameter directly on the display, via a direct command or
> even a script.
>
> Any help or suggestions will be greatly appreciated!
>
> Magdi Abdel halim
> Advansys Co.
> Egypt
-----------------------------------------------------------------------
This list is neither sponsored nor endorsed by the Foxboro Company. All
postings from this list are the work of list subscribers and no warranty
is made or implied as to the accuracy of any information disseminated
through this medium. By subscribing to this list you agree to hold the
list sponsor(s) blameless for any and all mishaps which might occur due to
your application of information received from this mailing list.
To be removed from this list, send mail to
[EMAIL PROTECTED]
with "unsubscribe foxboro" in the Subject. Or, send any mail to
[EMAIL PROTECTED]
