Thanks for such a variety of solutions! I'll be looking into each one of them. Please keep 'em coming if anyone has any other ideas... On Wed, May 8, 2013 at 12:03 PM, Kyle Banerjee <[log in to unmask]>wrote: > 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 > > >