Re: [foxboro] Writing point values to an external database
- From: "Murray, Steve" <SMurray@xxxxxxxxxx>
- To: "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
- Date: Thu, 10 May 2007 07:37:47 -0700
Hi Jeff,
This is an example of using omgetimp. I am actually reading 25 points,
but paired the script down for the email. Separate each C:B.P with one
space.
I ftp the resulting data file over to a computer hosting a web server, and
use a perl script to create a web page from the data file. The timestamp is
included so the web user knows when the data was last updated.
This is getting live data from blocks, not from the historian. To get
data from my historian (legacy Informix) I use the report writer to create
the data file and then ftp it to the web server.
Steve Murray
Asarco
********** content of script file scheduled in cron
*******************************
#!/bin/sh
# Shell script to load values for Plant Overview web page
# Thirty points per omgetimp permitted
# awk command will read in the third field from the omgetimp and write them
to the
# file dataX.tmp
TIMESTAMP=`date '+ %m/%d/%y %H:%M:%S'`
echo $TIMESTAMP >/var/steve/webdata/smdata3.tmp
# Twenty-five this omget
/opt/fox/bin/tools/omgetimp FIC69:FIC69.MEAS G16:ST.RO0001|awk '{print $3}'
>>/var/steve/webdata/smdata3.tmp
************************************
-----Original Message-----
From: Jeff Hurt [mailto:hurtman@xxxxxxxxxxxx]
Sent: Wednesday, May 09, 2007 6:44 PM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Writing point values to an external database
Kevin,
Thanks for the advice of using omgetimp. I'm not
familiar with this command. From googling it, it
looks like it runs from the command line? Any places
you can point me to for more information.
Thanks,
Jeff H.
Indeck-Energy
*
This e-mail and any files transmitted with it are the property of ASARCO LLC
and/or its affiliates, are confidential, and are intended solely for the use of
the individual or entity to whom this e-mail is addressed. If you are not a
named recipient or otherwise have reason to believe that you have received this
message in error,
please notify the sender and delete this message immediately from your
computer. Any other use, retention, dissemination forwarding, printing or
copying of this e-mail is
strictly prohibited. Although this email and any attachments are believed to
be free of any virus or other defect that might affect any computer system into
which it is
received, and opened, it is the responsibility of the recipient to ensure that
it is virus free and no responsibility is accepted by ASARCO LLC and/or its
affiliates for any loss or damage arising in any way from its use
This e-mail has been scanned and cleared by MailMarshal
www.marshal.com
*
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Other related posts:
