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:
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:
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.
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:
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.