Posted on 20 June 2009

POP3 to MySQL Import Tool (Visual Basic or similar)

Anywhere
This job is no longer available. But don't worry - we have lots of new freelance jobs for you!
Budget: Don't Know

I require a tool that can be setup as a windows service on a windows 2003 server to check a POP3 inbox at regular intervals and import any emails into a MySQL database

The POP3 server and account details, check interval, database connection/username/password, table name and column names should all be configurable - this can be done via an ini file or preferably an XML config file

The program should pull out the individual parts of the email into separate database fields

i.e to, from, cc, subject, html body, text body etc

Successfully imported emails should be deleted from the server, any that fail should be notified to me somehow - possible forward the email to another email account specified in the config file

Deliverables would be the source code, compiled program and documentation for setup

I'm not too bothered about what programming language is used, although Visual Basic would be preferred as I have experience with it myself