PDA

View Full Version : Adding items from an existing database.



Sleepless
04-11-2005, 07:42 PM
Hi Tim,
My database for my site is mysql. Is there any way to use that info to popualte the tables for the reviews? I don't want to have enter each item individually.
Thanks,
Kelly

imported_Tim Mousel
04-12-2005, 04:34 AM
Hi,

Using phpMyAdmin you can export your current database and then import the appropriate fields into the review_items table.

You definitely do not have to do it individually!

Tim

Anonymous
04-19-2005, 05:02 AM
How exactly do you import to that table, using phpmyadmin?

Sorry for the noob question :)

I have a list of item descriptions I'd like to import but can't see how to do that directly. I see that I can do it via a txt file, but I'm no sure exactly how to structure the text file?

Any tips would be appreciated :)

imported_Tim Mousel
04-21-2005, 10:03 PM
Matt,

Look at the fields for the review_items table. Determine which of your current database fields would match the appropriate review_items field. You could then export your current database to Excel, manipulate it as needed and then import it back into the review_items table. It's really hard for me to be more specific as there are so many variables unique to each users database. If you'd like a quote, email me at mousel@defend.net.

Thanks,

Tim