AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

AI Assistant

Notifications

Clear all

Importing votes

✦ Summarize Topic

How-to and Troubleshooting

Last Post by powcom 5 years ago

3 Posts

2 Users

0 Reactions

1,552 Views

RSS

Posts: 19

powcom

Topic starter

Translate ▼

Aug 20, 2020 5:34 pm

(@powcom)

Eminent Member

Joined: 5 years ago

[#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?

Topic Tags

importing votes data migration

2 Replies

Posts: 8210

Asti

Support

Translate ▼

Aug 21, 2020 12:28 pm

(@asti)

Illustrious Member

Joined: 8 years ago

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.

Posts: 19

powcom

Topic starter

Translate ▼

Aug 21, 2020 4:48 pm

(@powcom)

Eminent Member

Joined: 5 years ago

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! 😀 )