- Moderated by:
- Support
Postnuke 0.762 Reviews: Importing Data
-
- rank:
-
Freshman
- registered:
- August 2004
- Status:
- offline
- last visit:
- 13.03.07
- Posts:
- 7
Hullo,
I'm currently considering switching over to PN and have a large database of reviews I'm looking to import into pn_reviews. If I add a review on the test site I've installed, the review (once 'posted' by admin) shows up on the reviews page.
When I import data from my other database into pn_reviews, none of these show up.
Is there some other table that requires updating when a review is added?
Could default timestamp (0000-00-00 00:00:00) cause the review not to be displayed possibly?
Help appreciated.
Sam
-
- rank:
-
Freshman
- registered:
- August 2004
- Status:
- offline
- last visit:
- 13.03.07
- Posts:
- 7
I've messed around with this some more and noticed that a review added from front end goes to pn_reviews_add table, and once admin selects 'post review' this moves to pn_reviews table.
When a review is added in this manner the review is displayed when 'reviews' link is selected.
I'm struggling to see the difference between the two tables. Is there some key which is toggled when this move happens?
I have over 5000 reviews so am a tad anxious to find out the answer to this, as I really don't want to click 'post review' that many times...!!
Appreciate anyone's input.
-
- rank:
-
Steering Committee
- registered:
- December 2002
- Status:
- online
- Posts:
- 13418
Quote
I'm struggling to see the difference between the two tables. Is there some key which is toggled when this move happens?
It's a (not very clever) approvals system for user submissions. The _add table is a holding area for unapproved submissions. At least, I believe that to be the case.
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
|
