simple-review.com
September 04, 2010, 01:39:36 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Help now open.
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Import Reviews via PHP MyAdmin  (Read 204 times)
EUSS
Newbie
*
Posts: 4



View Profile WWW
« on: July 04, 2010, 06:53:57 AM »

I've seen that there is no option to automatically import reviews and that this feature is on Current Working Request List, but it is very low priority. Since I need to import around 700 reviews I'd like to know how to import it using PHP MyAdmin. I could probably figure it myself, but I want to be sure that I have not missed anything and that I do it properly. Thanks in advance,
Adnan
Logged
row1
SR Sole Developer
Hero Member
*****
Posts: 824



View Profile
« Reply #1 on: July 06, 2010, 09:35:34 PM »

If via PHPMyAdmin you export all the simple review tables you can then just import them.
Logged

If you find Simple Review useful please submit a Review (http://extensions.joomla.org/extensions/communities-&-groupware/ratings-&-reviews/4725/details), your positive reviews will help keep me going!
Please also make suggestions and possible improvements in the forum!
EUSS
Newbie
*
Posts: 4



View Profile WWW
« Reply #2 on: July 07, 2010, 12:06:28 AM »

I meant how to import from CSV. Nonetheless, I probably will not be able to use this extension, though I find it very interesting, because as somebody replied to on another thread I opened, it is not possible to display reviews for appropriate articles bellow articles. Is that correct? Thanks, Adnan
Logged
row1
SR Sole Developer
Hero Member
*****
Posts: 824



View Profile
« Reply #3 on: July 07, 2010, 04:27:40 AM »

Importing from CSV is not possible.

The plan (probably version 2.3) is to allow Simple Review tags to be used in any article, for example you could put the below tag in an article and the review would be displayed:
{sr:review23}
Logged

If you find Simple Review useful please submit a Review (http://extensions.joomla.org/extensions/communities-&-groupware/ratings-&-reviews/4725/details), your positive reviews will help keep me going!
Please also make suggestions and possible improvements in the forum!
EUSS
Newbie
*
Posts: 4



View Profile WWW
« Reply #4 on: July 07, 2010, 04:41:08 AM »

So it is possible to display review I want? Great Smiley What I meant by importing from CSV is that I would prepare content as CSV or SQL queries and using import to database in PHP MyAdmin I would import it in database. What I am concerned is that if some data is required in some other tables then jos_reviews. To make it simple, question is:
How should I prepare data to directly import to database? What data is needed.

Thank you very much. I'll make a note to give you positive review on JED as I like your component, and your support is very good for free extension. Thanks again, Adnan
Logged
row1
SR Sole Developer
Hero Member
*****
Posts: 824



View Profile
« Reply #5 on: July 08, 2010, 07:53:02 AM »

When it gets implemented it will be possible to display the review in an article, you will need to specify the review ID in {sr:reviewXXX}

As long as your reviews don't contain any custom titles then it *should* work and it *should* be quite straight forward.
The two tables you want are:
jos_simplereview_category
jos_simplereview_review

You will want to first create a category, then use that category ID when creating a review. I would strongly suggest creating/maintaining any categories using the Simple Review administration page - the category table does require calculated values to create a hierarchy and if you insert invalid data it will break.
Logged

If you find Simple Review useful please submit a Review (http://extensions.joomla.org/extensions/communities-&-groupware/ratings-&-reviews/4725/details), your positive reviews will help keep me going!
Please also make suggestions and possible improvements in the forum!
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!