Re: [foxboro] Documenting AIM Historian Database
- From: <Jack.Easley@xxxxxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Thu, 26 Mar 2009 07:58:55 -0500
Has anyone succeeded in pulling long term historical message data from
the AIM Historian using ODBC. We were told in AIM class we could, but
when we tried it all we get is the last hour or so of alarm message
data. What we are looking for is older alarm message data stored in the
mxxx.fdb files.
Thanks,
Jack Easley
Sr. I&C Technician
Luminant Power, Martin Lake Plant
Phone 903.836.6241
jack.easley@xxxxxxxxxxxx
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx]
On Behalf Of lccj4
Sent: Wednesday, March 25, 2009 9:57 PM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Documenting AIM Historian Database
I'm not at my computer now. but I have done this using both excel and
access. Use ODBC to pull the table in. Iwill get my computer and give
more specific indtructions tomorrow.
Connie
----------
This AOL Mail was sent from AT&T's Wireless network using Mobile Email
------Original Message------
From: Jim Kahlden <jim.kahlden@xxxxxxxxx>
To: <foxboro@xxxxxxxxxxxxx>
Date: Wed, Mar 25, 2009 09:15 PM
Subject: [foxboro] Documenting AIM Historian Database
Has anyone found a good way to dump a AIM Historian database and convert
it into an Excel spreadsheet so we can document the historian points by
name, type, description, hscale, lscale, engunits and delta? I would
like
to find out what points are in an existing historian and need a way to
easily sort this information out.
Thanks,
Jim Kahlden
_______________________________________________________________________
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
Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.
_______________________________________________________________________
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:
