-----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
