XF 1.2 vBseo Like İmporter

[Mehmet Yavuz]

How can transfer vBSEO likes ?
http://xenforo.com/community/resources/vbseo-likes-importer.2021/ Unfortunately does not work.

 

[0ptima]

You should post why it did not work (eg errors you received, etc) in that thread.

 

[Jake Bunce]

Here is a quick trick I use:

http://xenforo.com/community/threads/importing-from-vb4-with-vbseo-to-latest-xen.46663/#post-503889

That query simply converts the vBSEO likes into reputation clicks which are imported as likes already.

 

[JulianD]

How can transfer vBSEO likes ?
http://xenforo.com/community/resources/vbseo-likes-importer.2021/ Unfortunately does not work.

May I ask what did not work with the importer?

 

[Mehmet Yavuz]

Here is a quick trick I use:

http://xenforo.com/community/threads/importing-from-vb4-with-vbseo-to-latest-xen.46663/#post-503889

That query simply converts the vBSEO likes into reputation clicks which are imported as likes already.

Do not translate directly xenforo this query?

 

[japersonal]

Here is a quick trick I use:

http://xenforo.com/community/threads/importing-from-vb4-with-vbseo-to-latest-xen.46663/#post-503889

That query simply converts the vBSEO likes into reputation clicks which are imported as likes already.

Hi @Jake Bunce, thanks for the tip... but I don't get it. What are reputation clicks? I'm new to XenForo and all I can see from any profile is "Trophy Points" and "Likes Received". What does your query do?

Thanks again!

 

[Jake Bunce]

Hi @Jake Bunce, thanks for the tip... but I don't get it. What are reputation clicks? I'm new to XenForo and all I can see from any profile is "Trophy Points" and "Likes Received". What does your query do?

Thanks again!

Reputation clicks are basically likes in vB. The import from vB to XF already imports them as likes.

 

[japersonal]

Reputation clicks are basically likes in vB. The import from vB to XF already imports them as likes.

Thanks for your reply, @Jake Bunce.

But I'm afraid I still don't get it. If by "Reputation clicks" you mean the "Reputation Level" feature at vBulletin, I don't know how does it working when importing to XenForo.

For instance, two users:

Apolo
vBulletin Reputation Level: 48
vBSEO Likes Received: 26
Likes (once imported to XenForo): 13

turcu
vBulletin Reputation Level: 67
vBSEO Likes Received: 124
Likes (once imported to XenForo): 10

So, user "Apolo" had less Reputation Level than user "turcu" but either way user "Apolo" ended up having more Likes than user "turcu" after migrating to XenForo, so I don't know how does this work.

Also, please note I always had vBSEO installed and its "Likes" feature was the only available to forum members. We never used any "thank you" plugin nor any other similar one.

Thanks for helping me to clarify this issue.

 

[japersonal]

Hmmm... never mind... I guess I've just figured this one out:

Every time a user gave a positive (with at least 1 point of) "Reputation", it counts as 1 Like by XenForo importer. Even if the user gave, say, 5 points of "Reputation", XenForo importer will import it as 1 "Like".

Mystery solved.

 

[japersonal]

Hi again @Jake Bunce

There is no separate import module for the vBSEO likes, but I have handled this manually for previous imports by running this query on the vB database to convert the vBSEO likes into reputation clicks:

INSERT INTO reputation (postid, userid, reputation, whoadded, reason, dateline)
    (SELECT vl.l_contentid, vl.l_dest_userid, 1, vl.l_from_userid, '', vl.l_dateline
    FROM vbseo_likes AS vl)
ON DUPLICATE KEY UPDATE
    postid = VALUES(postid);

I guess that query is to be run _before_ runnning the XenForo import script. What if we have already migrated to XenForo?

For the record, we still have the import log archived in a table and we have also installed the "Import Tools by Waindigo 1.0.1" add-on.

Thank you!

 

[Jake Bunce]

Hi again @Jake Bunce



I guess that query is to be run _before_ runnning the XenForo import script. What if we have already migrated to XenForo?

For the record, we still have the import log archived in a table and we have also installed the "Import Tools by Waindigo 1.0.1" add-on.

Thank you!

I can manually import the likes for you. I would need FTP and phpmyadmin.

 

[japersonal]

Superb!

I will send you the login details vía NC in a minute.

Thanks a lot @Jake Bunce !

 

[Jake Bunce]

FYI for others. I ran this query to directly import vbseo likes to XF following an already completed imported:

INSERT INTO xfdbname.xf_liked_content (content_type, content_id, like_user_id, like_date, content_user_id)
	SELECT 'post', vl.l_contentid, vl.l_from_userid, vl.l_dateline, vl.l_dest_userid
        FROM vbdbname.vbvbseo_likes AS vl
ON DUPLICATE KEY UPDATE
        content_id = VALUES(content_id);

Note that this query assumes the source and destination ids are the same as was the case for japersonal. There is an option during the import to preserve source ids.

Database names and vB's table prefix have been highlighted. Those are the parts you may need to change if you wish to use this query yourself.

You are advised to backup the xf_liked_content table first.

Then I ran the script I posted in this thread:

http://xenforo.com/community/threads/is-there-a-way-to-rebuild-post-profile-post-like-caches.42384/

 

[japersonal]

Thanks a million, @Jake Bunce!!!