Re: [foxboro] Alarm priority in logmate

Hi Tim:

I'd like to have a copy of your VB code...

Thank you in advance

Pedro Hernandez
REPSOL YPF Quimica
Puertollano (C.Real)
SPAIN

-----Mensaje original-----
De: Lowell, Tim: [mailto:tlowell@xxxxxxxx]
Enviado el: jueves 14 de febrero de 2002 16:36
Para: 'foxboro@xxxxxxxxxxxxx'
Asunto: Re: [foxboro] Alarm priority in logmate



You can write VisualBasic for Excel code to extract alarm data from
AIM*Historian also.  I have a sample of code I can supply you.  You have to
have all the other things required to access AIM*Historian from your PC,
like the ODBC driver and a second Ethernet port if it's on an AW, etc., but
if you already have all that, you can grab any of the columns in the
AIM*Historian alarm table using VB for Excel.  Let me know if you want the
code.

Tim Lowell
Control Systems Engineer
Phillips Petroleum Company, Trainer Refinery
Phone:  610-364-8362
Fax:    610-364-8211
tlowell@xxxxxxxx


        -----Original Message-----
        From:   Johnson, Alex (Foxboro) [SMTP:ajohnson@xxxxxxxxxxx]
        Sent:   Thursday, February 14, 2002 10:31 AM
        To:     foxboro@xxxxxxxxxxxxx
        Subject:        Re: [foxboro] Alarm priority in logmate


        FoxAMI and AIM*Historian record alarm priorities. AIM*Inform
(available soon
        if not out already) makes alarm reports quite simple.

        Regards,


        Alex Johnson
        System Products - Invensys Systems, Inc.
        10707 Haddington
        Houston, TX 77043
        713.722.2859 (office)
        713.722.2700 (switchboard)
        713.932.0222 (fax)
        ajohnson@xxxxxxxxxxx <mailto:ajohnson@xxxxxxxxxxx> 



                -----Original Message-----
                From:   sumankumar hampapur [SMTP:suman_h_kumar@xxxxxxxxx]
                Sent:   Wednesday, February 13, 2002 11:45 PM
                To:     foxboro@xxxxxxxxxxxxx
                Subject:        [foxboro] Alarm priority in logmate


                Hi List,

                We are using Logmate for alarm management but it does not
print
        priorities, but then again - neither does an OKI data printer - I
tried to
        investigate the possibility of getting it into the message queue - 
                I did some checking on  foxbia.flt (in Logmate) and found
that the
        SQL program does not contain listing of PRIORITY.I tried to edit the
program
        in SQL but for a particular tag (AIN) we have HLPR and HHAPR for AIN
and
        MEASPR,DEVPRI,HHAPRI and OUTPRI for PIDA and BAP for CIN. To add
these
        parameters we need seperate filter strings to be defined in SQL;
which
        requires seperate fileds. Not sure if this the solution.
                Is there any other way to get priorities in logmate?

                Thanks and regards

                suman






                -- 

                _______________________________________________
                Win a ski trip!
                http://www.nowcode.com/register.asp?affiliate=1net2phone3a


                 
                 
                
        
_______________________________________________________________________
                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
         
 
 
_______________________________________________________________________
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: