Do they, or another company, have a similer solution that works with MySQL?
Just though Id ask... Thanks Joe Giles > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 29-Jul-2002/08:46 -0400, Adam Ellis <[EMAIL PROTECTED]> wrote: > >I am trying to come up with a system that will allow me to take incoming > >e-mail messages and enter key fields into a database. So, for example, all > >e-mails to [EMAIL PROTECTED] will be pulled apart and fields like > >Problem Description, Date, Priority, etc. will be pulled out of the message > >body and inserted into a mySQL database. First off, does anybody know if > >there is any software out there that does this already (I did not see any on > >Sourceforge or Freshmeat)? > > You are reinventing the wheel. There are web-based helpdesk solutions > available as GPL that will probably do 75% or more of what you need. I've > been using Teacup <http://www.altara.org/teacup.html> for a few months and > it works pretty well for what I need. It uses PostgreSQL, which ships with > Red Hat. > > If you really want to build this yourself, I suggest you get input from a > web form using PHP or CGI instead of trying to parse a human-generated > email message. If the message is already generated by a form, then you're > off to a good start. You will need to build the Perl or PHP scripts to > take the user's input, report errors and omissions, and provide for status > tracking. > > If you do not have access to scripts on a web server and have to take > input via email, then I recommend piping the message to a Perl script > using a filter like this: > > :0 > * ^X-MyCustomHeader: Form name here > | /usr/local/bin/perlscript > > Try having the form generate a custom mail header that you use to filter. > That will reduce the chance of a human being unintentionally creating a > message that seems to come from your web form. > > You have a lot of work to do if you're going to build this from scratch. > > Good Luck, > > Tony > - -- > Anthony E. Greene <mailto:[EMAIL PROTECTED]> > OpenPGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D > AOL/Yahoo Chat: TonyG05 HomePage: <http://www.pobox.com/~agreene/> > Linux: the choice of a GNU Generation. <http://www.linux.org/> > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: Anthony E. Greene 0x6C94239D <[EMAIL PROTECTED]> > > iD8DBQE9RYZcpCpg3WyUI50RAj+4AKCMM6dngX7Msfhrk6Vbt9C5R44plACgvb+V > wiHIiR8BKzoT1GerRb7bHGI= > =nK1h > -----END PGP SIGNATURE----- > > > > _______________________________________________ > Redhat-list mailing list > [EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list > Joe Giles [EMAIL PROTECTED] AOL ID: mcigiles _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
