vB4 Importer 3.6b2

[Jake Bunce]

Thanks for your hint.
It is the first time I hear that vB4's CMS articles are stored as threads in a hidden forum.
Do you meant the forum named "Cms comment "(which was created by default when we install vbcms) or does ivbulletin have another hidden forum to stored articles?
If it is the "cms comment " forum, it stored only comment (not all the articles)?

That's the one.

 

[vplusasia]

Hello
I have tried import again with xenforo default importer and as you said, it imported the forum
vBCms Comments for me. Howerver, the content of threads of this forum are only a link to the article which is located in "cms" system!

Some think like this

"You can view the page at......."

 

[Jake Bunce]

Hello
I have tried import again with xenforo default importer and as you said, it imported the forum
vBCms Comments for me. Howerver, the content of threads of this forum are only a link to the article which is located in "cms" system!

Some think like this

"You can view the page at......."

Then you can use this unofficial importer. I have no idea about your character encoding problem though. I would have to debug it.

 

[vplusasia]

Thanks for your help. I have tried to use all the unofficial importer but my character encoding are broken. I will manually move the articles.
If you have time please debug it.

Thanks again.

 

[Bob_R]

Can I use only the xml for the thanks while using the Official Importer to import from vBulletin?

 

[Jake Bunce]

Can I use only the xml for the thanks while using the Official Importer to import from vBulletin?

That is possible with custom programming. You would have to copy that step from this importer and paste it into the official one.

Or here is another option:

http://xenforo.com/community/threads/post-thank-you-hack-into-likes.23660/#post-291959

 

[hterrag]

Hi, I've just imported and so far so good but I can't see the users who liked, it just shows the number of likes. Is there a way to fix this? Help please...

 

[Jake Bunce]

Hi, I've just imported and so far so good but I can't see the users who liked, it just shows the number of likes. Is there a way to fix this? Help please...

Run this script:

http://xenforo.com/community/thread...t-profile-post-like-caches.42384/#post-457352

 

[hterrag]

Thank you very much!

 

[Claudio]

I did an import recently that had a dbtech_thanks_entry table. I modified this step in the myvbulletin4.php file to import from that table. Copy/paste this step into that file, replacing the existing function of the same name:

    public function stepPostThanks($start, array $options)
    {
        $options = array_merge(array(
            'limit' => 200,
            'max' => false
        ), $options);

        $sDb = $this->_sourceDb;
        $prefix = $this->_prefix;

        /* @var $model PostThanksImporter_Model_Import */
        $model = $this->_importModel;
       
        if ($options['max'] === false)
        {
            $options['max'] = $sDb->fetchOne('
                SELECT MAX(entryid)
                FROM ' . $prefix . 'dbtech_thanks_entry
            ');
        }

        $postThanks = $sDb->fetchAll($sDb->limit(
            '
                SELECT pt.*, post.userid as content_userid
                FROM ' . $prefix . 'dbtech_thanks_entry AS pt
                LEFT JOIN ' . $prefix . 'post AS post ON (post.postid = pt.contentid)
                WHERE pt.entryid > ?
                ORDER BY pt.entryid
            ', $options['limit']
        ), $start);
        if (!$postThanks)
        {
            return true;
        }

        $next = 0;
        $total = 0;

        $userIds = array();
        $postIds = array();
        foreach ($postThanks AS $thanks)
        {
            $userIds[] = $thanks['userid'];
            $userIds[] = $thanks['content_userid'];
            $postIds[] = $thanks['contentid'];
        }
        $userIdMap = $model->getImportContentMap('user', $userIds);
        $postIdMap = $model->getImportContentMap('post', $postIds);
        XenForo_Db::beginTransaction();

        foreach ($postThanks AS $thanks)
        {
            $next = $thanks['entryid'];

            $likeUserId = $this->_mapLookUp($userIdMap, $thanks['userid']);
            $contentUserId = $this->_mapLookUp($userIdMap, $thanks['content_userid']);
            $postId = $this->_mapLookUp($postIdMap, $thanks['contentid']);
            if (!$likeUserId OR !$contentUserId OR !$postId)
            {
                continue;
            }
           
            $model->importPostThanks($postId, $contentUserId, $likeUserId, $thanks['dateline']);
            $total++;
        }


        XenForo_Db::commit();

        $this->_session->incrementStepImportTotal($total);
       
        // 1.0.0 Beta 2 introduces percentage progress format
        if (XenForo_Application::$versionId > 1000031)
        {
            return array($next, $options, $this->_getProgressOutput($next, $options['max']));
        }
        else
        {
            return array($next, $options, "$next / $options[max]");
        }
    }

Hi Jake

Do you have a similar code for the official vB4 importer or some query?

Thanks!

 

[tr1cky]

Anyway to only import dbtech thanks/like without doing the other steps`? I already have the forums running so I would only need the thanks/likes.

 

[Chris D]

Import Tools by @Waindigo

 

[tr1cky]

Import Tools by @Waindigo

Doesn't work, as users have to be imported to match the user id's.

 

[framer]

Has anyone use this importer with VB4.x > XF1.4.x? Just checking to see if it's still current.

Thanks,

framer

 

[Jake Bunce]

Has anyone use this importer with VB4.x > XF1.4.x? Just checking to see if it's still current.

Thanks,

framer

I have not tested this on XF 1.4. This unofficial vB4 importer is no longer supported since the official importer was added.

Without testing it, I would say that it will probably work in XF 1.4.

 

[Amin Sabet]

I used the official importer to import my vB4 board, but it didn't import Post Thanks. I installed this importer to try and import thanks. How do I run it and do that import?

 

[Jake Bunce]

I used the official importer to import my vB4 board, but it didn't import Post Thanks. I installed this importer to try and import thanks. How do I run it and do that import?

https://xenforo.com/community/threads/manually-import-post-thanks.86740/

 

[Amin Sabet]

https://xenforo.com/community/threads/manually-import-post-thanks.86740/

Thanks, Jake. I re-did the import from scratch using your importer rather than the official importer, and it imported the likes perfectly.

I am about to transition a much larger forum from VB to XF. Is there any advantage to using the official importer and doing the thanks separately over using your importer?

 

[Jake Bunce]

Thanks, Jake. I re-did the import from scratch using your importer rather than the official importer, and it imported the likes perfectly.

I am about to transition a much larger forum from VB to XF. Is there any advantage to using the official importer and doing the thanks separately over using your importer?

There is no advantage unless you want the extras from this importer like social groups and blogs. Otherwise the official importer is recommended.

 

[Amin Sabet]

There is no advantage unless you want the extras from this importer like social groups and blogs. Otherwise the official importer is recommended.

But I like being able to do the thanks/likes. Does the official importer have an specific advantages?