Re: [foxboro] Data collection software for Sun I/A

Ed,

A caution about network loading.

Lotus can get either historian reduction data or OM realtime data.

So you can do "get"s (@OMGET's) and get realtime data but, if you do decide
to use this with nothing else done, you will be doing a broadcast for each
get.  Getting several points at a 1-second rate (and thus doing multiple
broadcasts) would not be good for the network.

If you decide to go this way, prior to running the spreadsheet, in the same
or a separate script, do a 
   cd /opt/fox/bin/tools
   omgetimp {COMPOUND_NAME}.ON
for each compound you expect to access in Lotus.
This will put the compound's network address into the Import List
which will make Lotus's OMGET go straight to the correct station, rather
than do a broadcast.
You need not go to the block level since the compound name is the unique
object.
The Import List is cleared on a reboot so the omgetimp must be done each
time there is a reboot.

For that matter, why not just do a set of the "omget"s you need (but, of
course, use omgetimp) and format the results into a usable table using
something like awk?  This file could be imported into whatever you want for
further computation.

Or you could just build a list and let FoxAPI do it (see utility tasks
sxopen, setclose in B0193UD, FOxAPI Users Guide).  An om list is best for
the network.  Reading the list every second using an existing utility will
be a bit more of a challenge in a script, but take a look at foxdis.     

I hoe this helps.

Regards
Stan


  Stan Abbot  --  Customer Satisfaction Center
  --  Invensys Manufacturing and Process Solutions (IMAPS)
       Mail Stop B52-AA, 33 Commercial St., Foxborough, MA USA
  --  1-866-746-6477  [or outside USA:  (0101) 508-549-2424 ]



-----Original Message-----
From: Ken Heywood [mailto:kheywood@xxxxxxxxx]
Sent: Monday, 25 August, 2003 09:59
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Data collection software for Sun I/A


Last time I used it (several years ago), links were real time. You could =
do 'gets' and 'sets' right from the spreadsheet.

-----Original Message-----
From: Ed Zychowski [mailto:Ed.Zychowski@xxxxxxxxxx]
Sent: Monday, August 25, 2003 9:55 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Data collection software for Sun I/A



Ken,
Where would the spreadsheet get the data? Would it be from the =
historian?
If so, we would have to remove any exception handling when we are doing =
a
collect. We are using the legacy historian so that might be too =
practical,
since we need to stop the historian to edit the historian tags.
If the data doesn't come from the historian, this might be a slick =
solution
providing that we can specify the times in the future and a a one second
data rate.



                                                                         =
                                                             =20
                      "Ken Heywood"                                      =
                                                             =20
                      <kheywood@xxxxxxx        To:       =
foxboro@xxxxxxxxxxxxx                                                    =
    =20
                      om>                      cc:       (bcc: Ed =
Zychowski/Coated & SC Papers/IPAPER)                                =20
                      Sent by:                 Subject:  Re: [foxboro] =
Data collection software for Sun I/A                           =20
                      foxboro-bounce@fr                                  =
                                                             =20
                      eelists.org                                        =
                                                             =20
                                                                         =
                                                             =20
                                                                         =
                                                             =20
                      08/25/2003 07:23                                   =
                                                             =20
                      AM                                                 =
                                                             =20
                      Please respond to                                  =
                                                             =20
                      foxboro                                            =
                                                             =20
                                                                         =
                                                             =20
                                                                         =
                                                             =20




I believe that Lotus on Sun boxes has Foxboro extensions that can =3D
snapshot process block data. You could set up a spreadsheet template for =
=3D
one row, duplicate the rows, and then edit/replace the block names in =
=3D
each row. You could export that spreadsheet using TCP/IP to whatever =3D
machine/tuning package you desire.

If you are looking for some sort of heuristic tuning as found in some of =
=3D
these third party packages, I'm curious as to why you don't use the =3D
exact block? Is it that bad?

-----Original Message-----
From: Ed Zychowski [mailto:Ed.Zychowski@xxxxxxxxxx]
Sent: Monday, August 25, 2003 8:07 AM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] Data collection software for Sun I/A


Hey list,
We are looking for a new method to get data from our unix based I/A =3D
systems
(AW51E) for loop tuning. I am currently looking into OPC servers which =
=3D
seem
to work well but require block configuration at both the OPC server and =
=3D
OPC
client side. It is also very expensive. What I would like is a simple
application where I can type in the tags I'm interested in (typically
PID.MEAS, PID.SPT PID.OUT) and the sample rate. The application would =
=3D
then
put the data in a file in ASCII format. I thought before I wrote =3D
something
I'd see what your using.

Thanks in advance for your help.



=3D20
=3D20
_______________________________________________________________________
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
=3D20
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         =3D
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin
to unsubscribe:      =3D
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave
=3D20


_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe:      =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave








=20
=20
_______________________________________________________________________
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
=20
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe:      =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=20
 
 
_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 
 
 
_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: