Hi,
Check out the Foxboro product called "Data for Windows".
This allows you to extract data from the Foxboro I/A system in a variety
of ways including live data form the Object Manager and historical data from
the historian.
This product does require a personal computer running Microsoft Windows
connected to your I/A system.
If you have to do your data extraction on the Foxboro machines you can use
omget in scripts to get live data or use isql in scripts to get historical
data from the Informix (legacy) historian.
omget example to dump just the value of some CBPs:
/opt/fox/bin/tools/omget ANALOG_IN:CALC_FULL.RO01 FDGRIN:RIN13.FDRIN2
FDGRIN:RIN11.FDRIN2 FLOT10:G2_BOOL2.IN_2 FLOT10:G2_BOOL2.IN_3
FLOT10:G2_BOOL2.IN_5 PRODUCTION:S.IO01 PRODUCTION:RECOVERY.RO01
PRODUCTION:SAVEDMTONS.RI01 PRODUCTION:SAVEDMTONS.RI02
PRODUCTION:SAVEDMTONS.RI03 PRODUCTION:SAVEDMTONS.RI04
PRODUCTION:EIMCO_CALC.II02 PRODUCTION:HDS1_4.RO02
PRODUCTION:SECT7_CU.RO03|awk '{print $3}' >/opt/steve/data1.tmp
You can get up to thirty values at a time from omget, but Alex Johnson
warns that this can be a problem on large systems because omget uses
broadcasts to read the values. At one time I was omgetting around 75 values
with three different omgets in a script that runs every two minutes. I
sleep for two seconds between omgets, and I never saw any problems, but I
have a small single node system. I have pared this list down to three calls
of 10 to 14 values apiece & it does not seem to cause any problems for me.
Start small and see if this gets you the live data you need, but 100
values every one minute may get you into trouble!
isql sample to get information from the Informix (legacy) historian. This
fragment is from a script I wrote to put data back into a 24 hour reduction
group after the historian has been turned off (24 hour reduction groups come
up empty if you have the historian off for any reason during the day!).
# (You will have to provide the times and the proper historian & table
names)
isql histox -<<!
SELECT seq, MAX(time_tag) - 1620 AS time_tag, pt_id_key, status_tag,
MAX(halfhr_max) AS daily_max
FROM halfhr_max WHERE time_tag BETWEEN $TIME3 AND $TIME4
AND pt_id_key IN
(SELECT DISTINCT pt_id_key FROM power)
GROUP BY seq, pt_id_key, status_tag
ORDER BY pt_id_key DESC;
!
Or if you do programming the possiblities are endless! :-)
Stephen Murray
Asarco
> -----Original Message-----
> From: Eudilson N��ez Cossio [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 1:47 PM
> To: 'Foxboro DCS Mail List'
> Subject: Capturing Data
>
>
> Hi list,
> I looking for a way to capture data from historian or direct
> from object
> manager in order to analize this information out of line.
> The requirementes are:
> Time sampling: 1 minute or less.
> Data type: plain text
> Variables: aprox. 100
> Period of data: aprox.
>
> We are using the normal tools that comes with Foxboro I/A DCS:
> Config
> Historian
> Data Display
> (choose current data, sample, fileter point name variables)
> Reports
> ASCII File
> But this procedure only save four variables and we need so
> many variables to
> save completed simultaneusly. This procedure fails when we
> specify more
> than four variables and take so many time doing in this way.
>
> In the past we tested a method using the crontab and prelude
> s.s. on a PW-OE
> (PC Venix) but this procedure writes on hard disk frequently
> (every minute)
> and the computer come slow and is dangerous because reduce
> life of hard disk
> . On the other hand today we do not use PW-OE any more.
>
> I would like to know other procedure to reach this purpose.
> Thanks in advance.
-----------------------------------------------------------------------
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]
