Convert email to database

Discussion in 'Databases' started by soldbychris, Aug 19, 2009.

  1. #1
    I have a real estate website and would like to track all homes sold by placing the data in a mysql database via email. The mls system will automatically send them to me daily, how can i scrape the data from the email and import automatically to my database.
     
    soldbychris, Aug 19, 2009 IP
  2. DesignWeb

    DesignWeb Active Member

    Messages:
    251
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    #2
    I didn't made it myself but saw this option at cPanel hosting control panel.
    If your e-mail is under domain name which is hosted with cPanel control panel, there is feature/option called "Pipe" when adding email forwarders. I think this is what you are looking for.
    Here, it is explained more clearly: activecampaign.com/support/tt/index.php?action=kb&article=331
    But you can search google yourself too with therms: "cpanel email pipe"
     
    DesignWeb, Aug 19, 2009 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    You can pipe it to a script, or you can have a script check the email account and parse the email messages.

    Ether way, you will need a script to scrape the email and then insert it into the database. You wouldn't be able to do this with a database alone.
     
    jestep, Aug 20, 2009 IP