In Progress

email to database

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

Skills: MySQL, PHP, Software Architecture

See more: pop3 google apps, mysql database models, mysql customer database, google apps email, gmail architecture, email sender software, apps script google, abc 11, imap google apps, google apps imap, find google apps, database models, pop3 email, php mysql imap, names email, nad, imap, google script gmail, find email address, email hosting, email customer, email file sender, checking email, report mysql php database, php email receive

About the Employer:
( 1 review ) Milano, Italy

Project ID: #1133919

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