Jump to content


Modify number of article ratings in Knowledgebase

knowledgebase ratings import

2 replies to this topic

#1 lzst3rer

    Advanced Member

  • Members
  • PipPipPip
  • 98 posts

Posted 16 October 2017 - 05:18 PM

I am importing Knowledgebase articles from a different system and I would like to set the number of likes/dislikes (ratings) on those articles as if they were with LiveZilla since the beginning.

Is there any way to do this in the database?

Thanks!

Attached Thumbnails

  • Attached Image: livezilla-kb-ratings.png


#2 Patrick Keil

    Administrator

  • Administrators
  • 3506 posts
  • LocationSingen, Germany

Posted 17 October 2017 - 07:29 AM

Hi,

Unfortunately, there's no easy way to do this. Ratings are stored in the MySQL tables "feedbacks" and "feedbacks_critera". You may want to have a look at these tables.

#3 lzst3rer

    Advanced Member

  • Members
  • PipPipPip
  • 98 posts

Posted 17 October 2017 - 05:35 PM

Seems like feedbacks table stores ratings separately with an IP hash and then feedbacks_criteria counts these ratings. It seems like an over-engineered solution but should work fine for small/medium websites.

Thanks.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users