Pegasus Mail & Mercury

Welcome to the Community for Pegasus Mail and
The Mercury Mail Transport System, the Internet's longest-serving PC e-mail system!
Welcome to Pegasus Mail & Mercury Sign in | Join | Help
in
Home Blogs Forums Downloads Pegasus Mail Overview Mercury Overview Wiki

Take incoming email, and put it into a MySQL database

Last post 09-13-2018, 12:38 by Tym. 4 replies.
Sort Posts: Previous Next
  •  01-29-2012, 4:15

    • gears is not online. Last active: 01-29-2012, 4:16 gears
    • Not Ranked
    • Joined on 09-27-2010
    • Member
    • Points 215

    Take incoming email, and put it into a MySQL database

    If someone could make this, it would be amazing,

     

    It grabs the from, to and content from the email, then inserts them into a table called "from_phone" into columns to,from,content.

     

    It sounds simple enough but I would guess this is hard.

    Filed under:
  •  01-30-2012, 12:33

    • PaulW is not online. Last active: 14 Sep 2018, 9:56 PaulW
    • Top 10 Contributor
    • Joined on 05-08-2007
    • UK
    • SuperStar
    • Points 18,150

    Re: Take incoming email, and put it into a MySQL database

    I would think it could be written as a program called from a policy.  You just need a programmer with DB skills.
  •  05-27-2012, 0:40

    AW: Take incoming email, and put it into a MySQL database

    Why you want to put the Mails into a DB? But the DB programing could be a little bit tricky!
  •  10-22-2012, 14:49

    • mcorrow is not online. Last active: 11-14-2012, 17:16 mcorrow
    • Top 500 Contributor
    • Joined on 03-10-2008
    • Member
    • Points 290

    Re: Take incoming email, and put it into a MySQL database

    This is actually very easy.  We do this currently...  You set up an incoming rule to copy all emails to a special user (in our server it's a user named "emailsout"), then all you need is a program to log in to that user mailbox, and process each email there...  Note:  Because of the way that Mercury splits the email, all you get is the "to:" address.  the CC's and BCC's won't be in the email that you are processing.

     

    We process the emails using visual basic 6 with a POP3 component from Mailbee.

     

    Does that help?

  •  09-13-2018, 12:38

    • Tym is not online. Last active: 17 Sep 2018, 17:24 Tym
    • Not Ranked
    • Joined on 09-13-2018
    • Preston, UK
    • Member
    • Points 50

    Re: Take incoming email, and put it into a MySQL database

    1000 apologies for opening an old thread, but this would be quite easy to do. I write a lot of Database programs commercially and this would be quite straight forward to achieve. The *downside* is that as it would need to run as a policy, it may slow down the processing of mail as each one needs storing before the policy task completes. Have to say I don't know if Mercury processes these in parallel or series. 

    That aside, we can have Mercury pass the email text to an application that then inserts them into the required database.

    Drop me a line if you still (after all these years!) think it's worth looking at. 


    Tym
View as RSS news feed in XML

Contact | Advertise | Host provider: PraktIT | Terms of Use | Privacy Statement
Copyright © 2007-2011 David Harris / Peter Strömblad. | Pegasus Mail Home Page