Maybe I'm missing something, but why couldn't procmail be used to pipe the input into a program that would structure the info however you needed it and insert it? kyle On Wed, May 8, 2013 at 8:19 AM, Cary Gordon <[log in to unmask]> wrote: > Thought: I have done something similar to this using Drupal and some > contributed modules. It shouldn't be difficult. > > Advice: Try doing it in Drupal. > > Threat: NULL > > > On Wed, May 8, 2013 at 7:57 AM, scott bacon <[log in to unmask]> > wrote: > > > Just curious if anyone has any thoughts about this possibility (I already > > know it's not practical): Can I automatically forward to a database all > > emails sent to a specific email address? I've seen proprietary things > like > > Email2DB, but is there a simple open source alternative? > > > > > > Background: At MPOW there is an admin site where employees periodically > > login and check for unanswered patron emails. Patrons submit a PHP email > > form, the form data is saved in a SQL database, and the admin site > queries > > that database, which populates the tables in the admin site. Yes, this is > > convoluted, but just imagine that I'm not able to change this system to > > something more streamlined. > > > > > > This system was made by a previous employee I think in order to alleviate > > all emails going to an email alias, which creates issues with one email > > being answered twice by two different employees. > > > > > > So I would create a simple email address (say, [log in to unmask]) to give to > > patrons (vs. pushing them to a site to fill out a PHP form), but I want > to > > avoid using an email alias that will push all new emails into all alias > > members' email boxes. The admin site method then would allows loggers-in > to > > claim new emails and others then to see them as 'read'. > > > > > > Any thoughts, advice, threats? > > > > > > -Scott > > > > > > -- > Cary Gordon > The Cherry Hill Company > http://chillco.com >