gVectors Team

Professional WordPress Plugins and Services. wpDiscuz, WooDiscuz, Advanced Post Pagination

Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
Plugin Support
wpDiscuz
How-To and Troubles...
Import Comments wit...
 
Notifications
Clear all

Import Comments with Rating

  ✦ Summarize Topic
How-To and Troubleshooting
Last Post by nrichard 8 years ago
3 Posts
2 Users
0 Reactions
2,765 Views
RSS
nrichard
 nrichard
(@nrichard)
Active Member
Joined: 8 years ago
Posts: 11
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
19/10/2017 11:44 pm   [#1681]

Hello

I need to import some comments with rating from another system to wpDiscuz. Importing data to tables 'wp_comments' and 'wp_commentmeta' (in particular meta custom_field_rating) is not too complicated, but a meta wpdiscuz_rating_count is also needed in table 'wp_postmeta' (this meta summarizes all the ratings for the post).

This is a bit more tricky, is there a way I can calculate this meta afterwards in admin, e.g. by editing post or a comment? As I have approximately 200 posts, this would be acceptable.

Thanks for your help



   
Quote
 Tom
(@tomson)
Famed Member Admin
Joined: 11 years ago
Posts: 4245
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
23/10/2017 12:06 am  

Hi nrichard,

I'm sorry but there is no an easy way to do this. This requires a PHP code to collect all rating data from source database, then find the correct post in target database and insert according value in wp_postmeta. This is a PHP/MySQL job. I'm sorry but there is no any tool to perform this.



   
ReplyQuote
nrichard
 nrichard
(@nrichard)
Active Member
Joined: 8 years ago
Posts: 11
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
23/10/2017 3:39 pm  

Thank you for your answer, I know what I have to do now 😉



   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share:
Scroll to top