email to database
$30-250 USD
Paid on delivery
Hi,
I need a php software that polulate a mySql database with .csv file loaded from POP3/IMAP email address, and processing the sobjects emails.
that will satisfy all the following statements:
1-It should work in php [url removed, login to view] hosting
2-The email address where the .csv file and the to be processed subjects should be on [url removed, login to view], or google apps. POP3 or IMAP4 could be enabled on this account.
3-the script should work on cronjob and send an elaboration report at every usage
The script should work as following:
It should be ran once per day.
Into email address emal2mysql @ [url removed, login to view] (for example), i can receive 2 type of email:
TYPE A:
email from a specify ( for example sender @ [url removed, login to view]) with a csv attached file. The file should be imported to mysql.
The parser should be able to recognize if the record is already included in database, checking 2 field. If the record is already in the db, it should be loaded.
For example the csv file could have this content:
Serial Number,Customer,Models,Description,Date
1234,abc xdf,ZZZZ N123,Device,18-07-11
If Serial Number and Date are equal nad already in the database, the record should not be added.
TYPE B:
email from various and not designed email addresses, with subject like this:
1234,abc xdf,ZZZZ N123,Device,18-07-11,LOADED,19-07-11
The script sould find the already created record in mysql database and ad to the following filed the vales:
LOADED
and
19-09-07
the name of those 2 additional field could be "status" and "date2".
The values and the names of field will be different in final version.
Thanks
Project ID: #1133919
About the project
Awarded to:
5 freelancers are bidding on average $100 for this job
Dear Sir We are ERP/POS/CRM solution provider from India. So we are really interested to deliver this project. Regards AuricleSoft
Work 4 years as a Software Developer. Familiar with Enterprise technologies (Documentum, different Application Servers) and many programming languages. Technical Skills: Documentum ( 2 years ) DC, WebTop, More
i have done many o these sites and have code prewritten look at my profile see the sites i have done