I have a client in a situation where they need to provide physical CSV files on-disk for various and sundry reasons. The CSV would need to be populated with data fetched from the DB.
Now, I can totally prepare a custom template that would result in a CSV-formatted response via HTTP, but how do I save that response to disk? (EDIT: Is there perhaps some way to use a caching method of some sort to write the output to disk?)
In case it helps clarify things, the situation is a client who uses a fulfillment center for hosting and managing their non-EE shop. They now want to move to Expresso Store for the shop, but still use the fulfillment center to manage things. The fulfillment center wants to continue working with their own system of order management, but they can set up their system to fetch via FTP nightly updates in the form of CSV files to update their system with the latest orders from the Expresso Store.