В работе

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

Квалификация: MySQL, PHP, Архитектура ПО

Показать больше 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 parser

О работодателе:
( 1 отзыв ) Milano, Italy

ID проекта: #1133919

Поручен:

gangabass

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

$50 USD за 1 день
(139 отзывов(-а))
6.0

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $100

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 за 20 дней(-я)
(25 отзывов(-а))
6.2
dhinoja

hi, plz check pm

$150 USD за 3 дней(-я)
(0 отзывов(-а))
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, Больше

$101 USD за 4 дней(-я)
(0 отзывов(-а))
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 за 1 день
(0 отзывов(-а))
0.0