[Plugin: WP Customer Reviews] New website with existing reviews?

I have a similar question. I need to move my reviews to a new install of WP. Export of pages/posts didn’t do it, and I don’t see reviews as an export option for custom posts. Can’t find an export or backup function in the plugin settings either. Please advise on how to make the migration. Thank you!

Yep looking forward to the answer since I don’t want to loose al those precious reviews.

I wouldn’t think you would lose the reviews if you are just changing themes on the same wordpress install (same database). I switched databases, though, and just saw some post about doing it thru myPHPadmin on the hosting cpanel. What a pain in my arse, I am getting tons of errors. But hopefully I can figure it out soon!

Thanks!
But I am building an entirely new website.
Also a 2nd one with a different URL…

Success! It is possible through myPHPadmin! Do you have access to that through your hosting cpanel? Here is roughly what I did:

-exported the old wp_wpcreviews table from my old WP database using custom settings to CSV with columns separated with $ and cleared the values for enclosed and escaped (do not use ” , : or ; anywhere b/c the custom field data uses those characters and it will get messed up)
-opened CSV in Notepad and added a column (by adding a “$) after the review-text column. (for some reason my old database only had 12 columns but the new one had 13 – review_response was added in there) Don’t know if that applies to you, but you can compare the structures.
-imported new data into wp_wpcreviews table in new site’s database using “CSV using Load Data” … make sure you type in the $ for columns separated and delete the other ” , ; or ;

Hope that helps you (and others) a little!

Wow that’s a advanced work around for me…
Thanks!

Will give this a try later today.

Rogier

Big Thank You to teamdesign for the tip on migrating existing WP Customer Reviews into a new WorpPress site. Worked great for me as described, going from a single WP site to a Multisite site.

Had to edit 6 records in the db table by hand after import. I didn’t insert the $ in my csv file to accommodate for a 13th field – which you did in your process – and that might have been why I had those 6 exceptions.

Since these were “only” 24 reviews. I simply cut and pasted all off them to the new site.
When approving the review you can also cut and paste the date and time ??

Rogier