I will be building a site soon that requires the use of CSV files zipped up on an ftp which I have never tried before. I will have to connect to an FTP server via PHP, collect a zip file, unpack the CSV file and then use the values in there to display the contents as a feed on a page. Sounds a little over the top to create a simple feed but that's how the system works. The zip file will be updated twice a day so I'll either have to create a cron job to download this to the local server and unpack or just connect to the zip at random points of the day.
My question is, has anyone here had any experience in doing this, if so do you have any pointers on how best to achieve creating a feed from the CSV. Preferably a json feed.
Many thanks.