Script to access IMAP and save all new attachments to DB

IN PROGRESS
Bids
8
Avg Bid (USD)
$124
Project Budget (USD)
$30 - $250

Project Description:
I'm trying to fill a MySQL database with the daily email reports I get from my ad networks. I want to put a script on my web server, set cron up to run it every day at a certain time, and have it add the newest report data from that email inbox to a MySQL database so I can use that information in a combined ad revenue report I'll make on my own.

I have set up a gmail account specifically for these ad reports. It only gets two emails a day, one from Six Apart Media and another from Technorati Media.

Each message has a specific sender and subject name that never changes. The email body content is useless "here is your report" stuff. One network sends a .txt file, the other sends a .html file. They are delivered every 24 hours.

So my thought is that I need a script that will log in to the Gmail account with IMAP, download all emails newer than the stored timestamp of the most recently downloaded email it read last time, and then write two rows to a database containing the contents of the .html or .xls attachment in those emails.

I imagine the database should have three columns: "filename", "network", and "attachmentcontents". Filename should be the name of the .txt or .html attachment (it includes the report date, so it's useful), network would be either "Six Apart" or "Technorati" (depending on the subject\sender) and the attachmentcontents should be the plaintext contents of the .txt or .html file attached in each respective message.

I have basic-intermediate PHP experience but none using the libraries to access IMAP, and I'd rather not learn it just so I can accomplish a super simple task that I am sure an expert could do pretty quickly :)

Skills required:
MySQL, PHP, Software Architecture
Hire SuitCase
Project posted by:
SuitCase United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 125
in 3 days
$ 225
in 5 days
Hire zeke
$ 100
in 1 days
$ 120
in 2 days
Hire james5400
$ 175
in 2 days
Hire GoldenBow
$ 60
in 1 days
Hire elgad
$ 100
in 1 days
Hire db1976
$ 90
in 3 days