Re: [foxboro] Writing point values to an external database
- From: "Jeff Hurt" <hurtman@xxxxxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Wed, 9 May 2007 17:07:03 -0400
Thanks Howard. I have been down that road. I've tried using the AIM*AT 2
different ways and I couldn't fine tune it. It just seemed too glitchy.
The first way I tried was to set up a reduction group and pull the
historical data from midnight. I had a scheduler that would run a few
minutes after midnight.
The other way I tried was to have excel spreadsheet open up one minute
before midnight and it would populate cells with formulas to pull in live
data. At midnight it would copy and paste the values into the cells.
Both ways would work but there were too many external factors since the
computer that has AIM is also used for other things. It would just be nice
to write the 30 values I need to an external database using a foxboro block.
We tried the Report Writer package but in my opinion that product should
still be in the beta test stage.
Thanks,
Jeff H.
Indeck
----- Original Message -----
From: "Cossitt, Howard" <howard.cossitt@xxxxxxxxxxxxxxxx>
To: <foxboro@xxxxxxxxxxxxx>
Sent: Wednesday, May 09, 2007 1:47 PM
Subject: Re: [foxboro] Writing point values to an external database
> If you are using the AIM*AT Suite (or at least the historian) you can
> setup the ODBC AIM*Historian driver and access data with the SQL
> "select" statement thru Microsoft Access. Please note that this requires
> ODBC driver licensing.
>
> If you would like to know which manual covers this subject, it is found
> in:
> B0193YJ AIM*AT Suite AIM*DataLink
> Chapter 10 covers the ODBC functionality including SQL statements and
> examples.
>
> Shameless marketing for May 9th 2007:
> This and many other great topics is covered in our 2004, AIM*AT course
> ;)
>
> Hope the info helps.
>
> Howard C. Cossitt
> National Training Coordinator, Lifetime Learning Center
> Invensys Systems Canada
> Phone: +1-514-421-8095
> Fax: +1-514-421-8059
> -----Original Message-----
> From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx]
> On Behalf Of Jeff Hurt
> Sent: Wednesday, May 09, 2007 12:35 PM
> To: foxboro@xxxxxxxxxxxxx
> Subject: [foxboro] Writing point values to an external database
>
> Is it possible to write point values to a database. What I would like
> to do is at the end of the day, write certain point values to an
> MSAccess database. I thought there might be some way to do this using a
> sequence block. Any help or ideas?
> Thanks,
> Jeff H.
> Indeck
> =
>
> =
>
> _______________________________________________________________________
> 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=3Djoin
> to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
> =
>
>
>
>
> Confidentiality Notice:
> The information contained in this electronic message and any attachment(s)
> =
> to this message are intended for the exclusive use of the recipient(s) and
> =
> may contain confidential, privileged or proprietary information. If you
> are=
> not the intended recipient, please notify the sender immediately, delete
> a=
> ll copies of this message and any attachment(s). Any other use of the
> E-Mai=
> l by you is prohibited.
>
>
>
>
> _______________________________________________________________________
> 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
>
_______________________________________________________________________
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:
