I posted this question already but it was too vague and so was closed so I hope this is a bit better.
We have a php based application which reads a csv report that is then added to a database and/or displayed in a graphic way for customers and ourselves. This works well but the issue we have is in getting the csv where we need it.
We receive reports automatically from a separate system which is not in our control. These arrive as attachement in emails sent regularly to a number of different email addresses. Currently we have software that will take the email from the email server (mostly google), extracts the csv file, renames it per our requirements and using ftp puts it in one of a number of locations depending on the address it arrives from. Though this works it runs on a local machine in our offices and needs to run constantly. What we need is to cut this out of the set up. I'm a website coder and not very strong when it comes to the server side so I don't know for sure but is there a way we can achieve the same results without the need for the software running on the machine?
- retrieves an email from the email server (it can go to any email address we need, we just currently use google for handiness)
- extracts the csv file
- renames the csv file
- adds it to a folder on our server
Thanks! If you think this is too vague or needs more info just ask please rather than just marking it wrong, I'm trying to be clear but without the jargon it can be difficult.