I need a program that can do the following:
1. Check a hmailserver mysql database for new emails, the table hm_messages
2. If new emails are found convert the eml file data to a mysql table:
Fields needed:
--------------------------------------------
From
To
CC
Subject
date
Message (needs to be converted to HTML, so it will display ok in a browser)
Attachments (Just write the names of the files, if any – no need for the actually attachments)
3. Once converted, set a status in the hmailserver mysql database to 1
4. Delete the eml file
The program needs to keep checking for new emails every 5 min..
The hmailserver mysql database will not be the same one as the mysql table where the emails will be converted to.
Once a programmer is selected I will send you
- Mysql dumb file with 8500 emails
- Zipped folder including all 8500 eml files
Looking forward hearing from you