
October 11th, 2004, 01:24 PM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 25
|
|
|
PAID JOB - Email Retrieval Inbox to MYSQL
Needed is a one page Perl or PHP script that must:
a. Take email coming in off of the .procmailrc file and process it to a MYSQL database. Generally you would use in Perl <STDIN> to gather the contents of the mail and I believe you can use “php://stdin” on a PHP script.
b. If you have a method that would work better than sending the email directly to a script, that is fine to. However the main feature is mail must be stored into MYSQL, and the below steps C and D, must work.
c. Data that should be sent to the MYSQL database should be: Subject Line, From Email, To Email, Reply-to Email, The Message Content, AND ANY AND ALL HEADERS ON THE EMAIL, and should add each attachment names into the database as a one field array.
d. The attachments need to then be translated from the raw data format when it hits the server, back into the actual file, and then uploaded to a server directory, with the file name being logged in MYSQL as mentioned above.
e. ALL WORK MUST BE WELL COMMENTED.
Side Note
We are not looking for a complete email system, just the functionality mentioned above. We will build the functionality for viewing the data from the database.
Please send your complete cost quote to: sknorr@vortexnetworks.com
Must have a grasp of PHP or Perl, and understand the parsing of incoming email.
A project doc can be found at:
http://www.vortexnetworks.com/email_sow.doc
|