1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 vBseo Like İmporter

Discussion in 'Installation, Upgrade, and Import Support' started by Mehmet Yavuz, Aug 3, 2013.

  1. Mehmet Yavuz

    Mehmet Yavuz Member

  2. 0ptima

    0ptima Well-Known Member

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

    Jake Bunce XenForo Moderator Staff Member

    japersonal likes this.
  4. JulianD

    JulianD Well-Known Member

  5. Mehmet Yavuz

    Mehmet Yavuz Member

  6. japersonal

    japersonal Member

  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Reputation clicks are basically likes in vB. The import from vB to XF already imports them as likes.
     
    thomas1 and japersonal like this.
  8. japersonal

    japersonal Member

    Thanks for your reply, @Jake Bunce. (y)

    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. :)
     
  9. japersonal

    japersonal Member

    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.
     
  10. japersonal

    japersonal Member

    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! (y)
     
  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

    japersonal Member

    Superb! (y)

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

    Thanks a lot @Jake Bunce ! :)
     
  13. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

    Code:
    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 and rainmotorsports like this.
  14. japersonal

    japersonal Member

Share This Page