View Single Post
Old 06-10-2014, 03:30 PM  
robber
Web Developer
 
Industry Role:
Join Date: Jan 2011
Location: UK
Posts: 264
Hi,

If you're still having issues trying to get this to work, then drop me an email and I will see what I can do for you, depending on how you have the feeds setup it could be something as simple as converting the csv file into an mysql statement you can run against your database, or loading in a script which will do it for you and apply the changes to your database, to display your required content.

If you're going down the mysql statement route, you would be looking at something like

"Insert into ##tablename## ('field1','field2',....) Values ('row1-value1','row1-value2'...),('row2-value1','row2-value2'...),....."

you can create this as an output for you to copy and paste into phpmyadmin or run it directly with a PHP to give you the desired effect.

To build the file, you want to read the csv file, split out the rows and then the fields to provide you with an array which you can then build the datafeed with, to make it flexible to different providers feeds you could have headers on the first row and then match the fields up that way, if you wanted to only include specific ones then add the additional logic for this, or write the post content you need on the fly using the details.

The choice as to how you handle this is all your choice, as there are alot of different methods you could employ.

Kind Regards

Rob
FD Networks
robber is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook