Re: [foxboro] Documenting AIM Historian Database

Sascha,

One of the simplest ways of 'documenting' a AIM historian point configuration 
is with a utility named 'HARP' ("historian activity report program"). This is 
one of the programs located in the 'unsp_utilities' folder of the AIM 
installation CD. I have found this program to be most useful for many years. It 
provides a simple one line per point text file that can be brought into Excel 
or any Database program for sorting. HARP does not produce a file that can be 
edited and batched backed in, it is just for documentation purposes.

To use the program, find your AIM installation CD, open the 'unsp_utilities' 
folder and print or read the 'unsp_util.doc' and follow the instructions. The 
procedure involves copying the HARP program to /opt/aim/bin and then in a shell 
(UNIX or Windows) and execute the program. This can be done on a running 
historian. For example, 'harp hist01 -F' will produce a list of all configured 
points in hist01. Another example, 'harp hist01 -C -d' would produce a list of 
all points with their configured deltas. These examples and others are provided 
in the document.

There are also available some third party programs for converting '.inp' files 
to/from Excel. Not sure where I saw these, maybe someone on the list knows ...


Patrick W. Rogers

10900 Equity Drive
Houston, TX 77041
Office (713) 329-1719
Cell    (281) 217-2680

-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sascha Wildner
Sent: Thursday, March 26, 2009 3:36 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Documenting AIM Historian Database

Jim Kahlden schrieb:
> 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.

/opt/aim/bin/histcsave and a few lines of awk did the trick for me.

Regards,

-- 
Sascha Wildner
erpicon Software Development GmbH
Neusser Str. 724-726
50737 Köln
Germany

Phone:  +49 221 9746089
Fax:    +49 221 9746099
Mobile: +49 174 9887655
eMail:  swildner@xxxxxxxxxx
 
 
_______________________________________________________________________
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
 


** Confidentiality Notice:
This e-mail, including any associated or attached files, is intended solely for 
the individual or entity to which it is addressed. This e-mail is confidential 
and may well also be legally privileged. If you have received it in error, you 
are on notice of its status. Please notify the sender immediately by reply 
e-mail and then delete this message from your system. Please do not copy it or 
use it for any purposes, or disclose its contents to any other person.

This email is from the Invensys Process Systems business unit of the Invensys 
Group, a group of companies owned by Invensys plc, which is a company 
registered in England and Wales with its registered office at Portland House, 
Bressenden Place, London, SW1E 5BF (Registered number 166023).  For a list of 
European legal entities within the Invensys Group, please go to 
http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77.  

You may contact Invensys plc on +44 (0)20 7821 3848 or e-mail 
inet.hqhelpdesk@xxxxxxxxxxxxx This e-mail and any attachments thereto may be 
subject to the terms of any agreements between Invensys (and/or its 
subsidiaries and affiliates) and the recipient (and/or its subsidiaries and 
affiliates).


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