I have just completed a project where I had to parse
out an email message and dump it into a MySQL db. I find it hard to go wrong
with Perl -> MySQL

v/r
Mike

On Thu, Jun 13, 2002 at 08:37:35AM -0700, James Shaker wrote:
 
 Hello All,
 
 I would like to use "you all" as a sounding board for a project I am
 working on, if that is ok?
 
 We have developed a machine that will be deployed in a few thousand
 locations around the US, Puerto Rico, and Bahamas.  This product will be
 connected to a phone line and will call a linux server that we set up as
 a PPP dial in server.  Once connected, the product will send a small
 email detailing production amounts and status information.  The machine
 will also receive an email, if any, for parameter changes, etc.  This
 all works well.
 
 Once the server receives the email I want to parse that information and
 put it into MySql.  The status of these machines can be viewed via the
 web using apache and PHP4.  
 
 What I would like some advice on, what is the better method of parsing
 the email and putting it into MySql?
 
 Its not that I don't have many options... I have too many.
 
 Procmail -> awk/sed -> PHP4 script -> MySql
 
 Perl -> MySql
 
 And many other combination of tools.  I am leaning towards a Perl ->
 MySql solution for the simplicity; however, I want to know if anyone
 else has something that might be better. Perhaps Python?  
 
 Thank "you all" for your time,
 
 James
 james@vartek-corp.com
 
 ________________________________________________
 See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
 
 PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss