AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant

Notifications

Clear all

Importing votes

✦ Summarize Topic

How-to and Troubleshooting

Last Post by powcom 6 years ago

3 Posts

2 Users

0 Reactions

1,679 Views

RSS

powcom

(@powcom)

Posts: 19

Eminent Member

Topic starter

Translate ▼

[#724]

Hi all - We've been happily running wpDiscuz for some time and have quite a number of votes stored within the wp_wc_users_voted table.

We now want to bring in the votes from our old voting system into wpDiscuz.

We've compared the structure of old table to the wp_Discuz one and the conversion of the data seems pretty simple.

The one question we had - As there are already a number of records within our wp_wc_users_voted table, will there any issue with us adding the old vote information at the end of the wp_wc_users_voted table?

ie Will it matter that the old voting records from last year are being stored in the most recent part of the wpDiscuz table?

Posted : 20/08/2020 5:34 pm

Topic Tags

importing votes data migration

Asti

(@asti)

Posts: 8257

Illustrious Member Support

Translate ▼

Hi @powcom,

The one question we had - As there are already a number of records within our wp_wc_users_voted table, will there any issue with us adding the old vote information at the end of the wp_wc_users_voted table?

No, you'll not get any issues. However, you'll need to update the date in the comment_meta table ( meta key is wpdiscuz_votes).

Then navigate to Dashboard > wpDiscuz > Tools admin page, click on the "Regenerate Comments' Data" link. It'll open the new tools. You'll need to click on the "Regenerate Vote Metas" button.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 21/08/2020 12:28 pm

powcom

(@powcom)

Posts: 19

Eminent Member

Topic starter

Translate ▼

Many thanks for the reply Asti. Great news that importing old votes won't be an issue.

So I understand fully what you're saying, in the wp_commentmeta table, each comment that has had votes cast on it has a running total of those votes stored in meta_key / wpdiscuz_votes against its comment_id?

BUT I don't need to go and generate the correct value in that meta_key / wpdiscuz_votes, as you've programmed a "Regenerate Comments' Data" link that will do this totalling for me?

(Just want to double check, to make sure I don't do something wrong! 😀 )

Posted : 21/08/2020 4:48 pm