Import CSV and GZ datafeeds in to MySQL with php script

[submantom]

Tweet

Could someone point me in the right direction to a script that will import Awin, Buy.at etc xml/csv datafeeds from a url in to my mysql database please?

I have been using this script, http://www.legend.ws/blog/tips-tricks/csv-php-mysql-import/ , but it will only download unzipped csv files - At the moment it is working but will only import the first 400-500 lines of the csv file. I suspect this could be because the datafeed is too large for it to handle in one go.

Can anyone suggest any other methods? preferably to import the zipped datafeed in gz format?

Thanks
Tom

[submantom]

I managed to solve this using the Buy.At guide found here....

http://files.perfiliate.com/solutions/BuyAtParseProductFeedsGuideFeb09.pdf

[ilmart]

If you need more advanced options like filtering and shaping data, take a look at my script: DF/Manager (link in signature). There's a demo at Home - DF/Manager demo if you want to try the possibilities.