MYSQL pipe email csv into MYSQL
Posted on 2011-05-10
I have a email with sales data that will be sent daily to me and I need the email to be piped to, maybe a php script, that will take the attached csv (with the sames data in it) and load it into a MySQL database.
No issues with setting up email piping but issue with getting data from attachement.
I have had a bit of a search but have not had much luck when it comes to the attachement side of things, I am able to receive as a text document if required but again as an attachement to the email.