Stephen, I had set a table with the AR System. At the time I was receiving the ARS List in digest format. I would save the digest email as a text file, parse through it with a perl script to break out the individual messages, and load into the table. It became tedious and I've not kept up with it.
I've been considering changing the process and have the individual email sent to the email interface and let the email engine create the record. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, January 11, 2007 9:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS List Email is a Goldmine - How to Index Rick, I want to keep it local. By keeping it local and writing something myself I can tailor the search engine to what will help me the most, and internet connectivity is not required. Nothing against the arslist.org search - I am glad it's there, but I have never cared for it. It takes a lot of search attempts to find what I am looking for. At times even when I am certain that a post exists I can not locate it. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, January 11, 2007 8:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS List Email is a Goldmine - How to Index Why re-invent the wheel? www.arslist.org has them already stored, and you can search on them there. Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, January 11, 2007 5:13 AM To: arslist@ARSLIST.ORG Subject: OT: ARS List Email is a Goldmine - How to Index List, I search my local ARS List emails regularly. However, it's somewhat slow searching the email body within Outlook. For Jan 2005 to Jan 2007 the .pst file is 700MB. I am getting close to simply writing something that extracts the Outlook emails and imports them into a database (either Remedy, SQL Server, or Access) just so I can more efficiently search the ARS List postings. When the data is in a regular database I can index everything. Before I head down this road has anyone else done this? Stephen ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"