Closed

Email subjects and attached XLS to MySQL database

Hi,

I need a php or perl 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, Perl, PHP, Software Architecture

See more: pop3 google apps, mysql database software, mysql database models, mysql customer database, google apps email, email sender software, apps script google, abc 11, attached xls php, imap google apps, google xls, google apps imap, find google apps, database models, pop3 email, php mysql imap, names email, nad, mysql report, mysql 4, imap, google script gmail, find email address, email hosting, email customer

About the Employer:
( 1 review ) Milano, Italy

Project ID: #1149307

7 freelancers are bidding on average $246 for this job

srinichal

I can deliver the script in perl or php as you decide

$225 USD in 4 days
(104 Reviews)
7.1
Mindon

Kindly check the PMB please, thanks.

$250 USD in 2 days
(94 Reviews)
6.5
CreditGroup

please check pm

$250 USD in 3 days
(35 Reviews)
6.1
sayno2bugs

Hi, Please check my pm to you. Cheers, Nitin

$250 USD in 4 days
(19 Reviews)
6.1
allroundexperts

Please check PMB

$150 USD in 4 days
(57 Reviews)
5.0
CheapGoodWork

Hi lets start! thanks

$100 USD in 4 days
(2 Reviews)
2.7
WebsiteToolbox

We have multi year Php & Perl experience and we specialize in PERL coding, we can resolve this issue.Kindly check PMB,Thanks

$500 USD in 5 days
(1 Review)
0.0