email to database

In Progress Posted Jul 18, 2011 Paid on delivery
In Progress 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

MySQL PHP Software Architecture

Project ID: #1133919

About the project

5 proposals Remote project Active Jul 19, 2011

Awarded to:

gangabass

I can do this for you. See PM for details.

$50 USD in 1 day
(139 Reviews)
6.0

5 freelancers are bidding on average $100 for this job

auriclesoft09

Dear Sir We are ERP/POS/CRM solution provider from India. So we are really interested to deliver this project. Regards AuricleSoft

$100 USD in 20 days
(25 Reviews)
6.2
dhinoja

hi, plz check pm

$150 USD in 3 days
(0 Reviews)
0.0
GauravMalik8666

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

$101 USD in 4 days
(0 Reviews)
0.0
joshwells8438665

i have done many o these sites and have code prewritten look at my profile see the sites i have done

$99 USD in 1 day
(0 Reviews)
0.0