On Tue, 20 Nov 2001, Ashley M. Kirchner wrote: A perl script will do this easily. Depending on what mail system you're running (i.e qmail), put a .qmail which pipes the email through the script. Get the script to parse the email line by line, and use the DBI, DBD:Mysql modules to dump it into a database.
Very easy to do :) cheers, Anth > > I'm trying to find a solution where I can take an incoming email and > have something, an external program, parse the data as it arrives and > pipe the necessary information through to a database, say MySQL... > Basically we receive orders over the net and every order placed > generates an email. That email I would like to parse, extract the > necessary information and shove it into a database, automatically, with > no user interaction. (such script I will write of course) > > Anyone have any suggestions? > > -- > W | I haven't lost my mind; it's backed up on tape somewhere. > +-------------------------------------------------------------------- > Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 > IT Director / SysAdmin / WebSmith . 800.441.3873 x130 > Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6 > http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A. > > > > > _______________________________________________ > Redhat-list mailing list > [EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list > > Scanned by PeNiCillin http://PeNiCillin.pnc.com.au/ > -- -------------------------------------------------------- Anth Courtney - Systems Administrator / Programmer [EMAIL PROTECTED] - PLANET NETCOM - www.pnc.com.au -------------------------------------------------------- Scanned by PeNiCillin http://PeNiCillin.pnc.com.au/ _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
