homepage Welcome to WebmasterWorld Guest from 54.237.98.229
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Question from a newbie (a real green newbie).
mxracer170

5+ Year Member



 
Msg#: 4304420 posted 9:36 pm on Apr 26, 2011 (gmt 0)

I can create a site just fine in Dreamweaver and know quite a bit about SEO. My next project is to take a retailers product data feed and create an affiliate site just for that affiliate. I download the product data feed in csv format and I know I can copy and paste the product name, product description, price ect over one product at a time but with 12,000 it's hardly an efficient way of building a site.


I know there is a way to have my site pull info directly from a spreadsheet but I have no idea where to begin.

Can someone point my in the right direction?
( I don't know any PHP, SQL or ASP code but will learn if it's needed).

Thanks in advance,
Dave

 

Demaestro

WebmasterWorld Senior Member demaestro us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4304420 posted 9:48 pm on Apr 26, 2011 (gmt 0)

Dave,

You will likely have to learn a server side scripting language to do this unless you want to do it in an Ajax solution. I can tell you though if you are dealing with 12,000 rows that Ajax may not be the way to go unless you can figure out how to 'page' the data from that feed. Same with if you need this to be index'ble content

If you want to go Ajax you should check out Spry datasets and regions. It is from Adobe and plays nice in Dreamweaver which is why I mention it.

[labs.adobe.com...]

look at datasets and regions


I think your best option tho is to write an import script that inserts/updates a database and then read the data in from that database using PHP/ASP/PYTHON or whatever server language makes sense to use.

LifeinAsia

WebmasterWorld Administrator lifeinasia us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4304420 posted 9:51 pm on Apr 26, 2011 (gmt 0)

Depending on your DB, you should have a tool or command to import a CSV file into a table.

If it's an ongoing project (with the retailer frequently updating their product feed), you may want to automate the process. You could do it with a scheduled task in the DB or application server (PHP, ASP, etc.).

topr8

WebmasterWorld Senior Member topr8 us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4304420 posted 9:52 pm on Apr 26, 2011 (gmt 0)

2 parts.

1). importing the data into your own database.

2). getting the data from your database into your pages.

...

1) using something like phpMyAdmin you should be able to import a csv format file into a database.

2). extracting the data will require a scripting language, you're going to need to learn the basics of sql (mySQL) and php in order to get started, this is not trivial from a standing start - but go for it, there are thousands of tutorials online.

mxracer170

5+ Year Member



 
Msg#: 4304420 posted 10:07 pm on Apr 26, 2011 (gmt 0)

I've been watching a 200 part tutorial on Youtube and it seems like it's a pretty in depth process. I feel that nothing is "over my head" but it sure is turning out to be an intimidating project.

So far the tutorial has me using xampp and MySQL. Am I correct in guessing that these are 2 of the programs I will need?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved