[thelist] converting emails to database

Maisha Walker maisha at e-vent.org
Fri Jan 16 18:01:30 CST 2004


thanks anthony,

yes getting it into a csv file is exactly what i'd like to do.

i was hoping someone had already invented this wheel.  i don't have the
programming skills to write a perl or vb script to do this.  maybe there's a
handy tool that a perl guru has put together just for this purpose?

i tried yahoo and google searches using "email conversion" and "email
mining" but didn't get anything relevant.

the emails are actually on my local machine, but i'm sure i could figure out
some way to get them or their outlook files onto the server.

maisha

----- Original Message -----
From: "Anthony Baratta" <anthony at baratta.com>
To: <thelist at lists.evolt.org>
Sent: Friday, January 16, 2004 6:07 PM
Subject: Re: [thelist] converting emails to database


At 03:23 PM 1/16/2004, Maisha Walker wrote:

>Does anyone have any suggestions for where to go to get a script or tool
>that would automate this conversion process?  I really don't want (me or
>anyone else) to have to manually copy and paste the data from each email!

Either install ActiveState Perl in your local box and use that to parse
each email into a comma separated file. Or use VBS to parse (much less
elegant regex). Once you have a CSV file you can shove into your db much
faster.

Depending upon your DB, you could use Perl/PHP/VBS/.Net to parse and shove
into the DB in one pass.

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !




More information about the thelist mailing list