homepage Welcome to WebmasterWorld Guest from 54.205.59.78
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Accredited PayPal World Seller

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

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




msg:4304422
 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




msg:4304427
 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




msg:4304429
 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




msg:4304430
 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




msg:4304433
 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved