Announcement

Collapse
No announcement yet.

import from Kunena to vbulletin 4.2.1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • import from Kunena to vbulletin 4.2.1

    I followed this guide http://www.technopat.net/forum/web-p...n-4-2-0-a.html

    but are not detected all sections and not detected all thread/post

    can you help me?
    Last edited by s_cocis; Tue 3rd Dec '13, 12:34pm.

  • #2
    during import there is not 4.2,* from menu option "Select version and product to export to :: "

    Comment


    • #3
      Import from Kunena with users, forums, threads and posts worked fine for me after some adjustments with base from http://www.technopat.net/forum/web-p...n-4-2-0-a.html. Thanks for that! :-)

      You need a new database with a backup of your kunena / joomla database in it.
      You have to delete every table in new database except the following tables:
      (The Table have to be renamed after import from [tableprefix_]kunena_groups to kunena_groups or [tableprefix_]users to users!)

      kunena_attachments
      kunena_categories
      kunena_favorites
      kunena_groups
      kunena_messages
      kunena_messages_text
      kunena_moderation
      kunena_sessions
      kunena_smileys
      kunena_subscriptions
      kunena_users
      kunena_whoisonline

      and the joomla -tables users and usergroups
      ******************
      Now download impex and install it to your new VBulletin (tested with 4.2.2). Please remind your self to fill the config file!
      Delete every system from impex\systems\* except impex\systems\fireboard.
      Open the file impex\systems\fireboard\000.php and replace the following codes:

      mark at row 51:
      PHP Code:
      var $_valid_tables = array (
              
      'fb_announcement''fb_attachments''fb_categories''fb_favorites''fb_groups''fb_messages''fb_messages_text''fb_moderation',
              
      'fb_ranks''fb_sessions''fb_smileys''fb_subscriptions''fb_users''fb_whoisonline'
          
      ); 
      replace with this:
      PHP Code:
      var $_valid_tables = array (
              
      'attachments''categories''favorites''groups''messages''messages_text''moderation',
              
      'sessions''smileys''subscriptions''users''whoisonline'
          
      ); 
      mark at 91:
      PHP Code:
      if ($databasetype == 'mysql')
              {
                  
      $sql "SELECT users.id, users.username
                  FROM 
      {$tableprefix}users as users
                  LEFT JOIN 
      {$tableprefix}fb_users AS fb_users ON (users.id = fb_users.userid)
                  WHERE users.id > 
      {$start_at}
                  ORDER by users.id
                  LIMIT 
      {$per_page}";
                  
                  
      $dataset $Db_object->query($sql);

                  while (
      $row $Db_object->fetch_array($dataset))
                  {
                      
      $return_array["$row[id]"] = $row['username'];
                  } 
      replace with:
      PHP Code:
      if ($databasetype == 'mysql')
              {
                  
      $sql "SELECT users.id, users.name
                  FROM 
      {$tableprefix}users
                  LEFT JOIN users ON (
      {$tableprefix}users.userid = users.id)
                  WHERE users.id > 
      {$start_at}
                  ORDER by users.id
                  LIMIT 
      {$per_page}";
                  
                  
      $dataset $Db_object->query($sql);

                  while (
      $row $Db_object->fetch_array($dataset))
                  {
                      
      $return_array["$row[id]"] = $row['username'];
                  } 
      mark at 119:
      PHP Code:
      if ($databasetype == 'mysql')
              {
                  
      $sql "SELECT users.*,
                   fb_users.*
                  FROM 
      {$tableprefix}users as users
                  LEFT JOIN 
      {$tableprefix}fb_users AS fb_users ON (users.id = fb_users.userid)
                  WHERE users.id > 
      {$start_at}
                  ORDER by users.id
                  LIMIT 
      {$per_page}";
                  
                  
      $dataset $Db_object->query($sql);

                  while (
      $row $Db_object->fetch_array($dataset))
                  {
                      
      $return_array['data']["$row[id]"] = $row;
                      
      $return_array['lastid'] = $row['id'];
                  } 
      replace with:
      PHP Code:
      if ($databasetype == 'mysql')
              {
                  
      $sql "SELECT users.*,
                   
      {$tableprefix}users.*
                  FROM 
      {$tableprefix}users
                  LEFT JOIN users ON (
      {$tableprefix}users.userid = users.id)
                  WHERE users.id > 
      {$start_at}
                  ORDER by users.id
                  LIMIT 
      {$per_page}";
                  
                  
      $dataset $Db_object->query($sql);

                  while (
      $row $Db_object->fetch_array($dataset))
                  {
                      
      $return_array['data']["$row[id]"] = $row;
                      
      $return_array['lastid'] = $row['id'];
                  } 
      Now you have to search every "fb_" (prefix) and replace it with "" (NULL) in every file ... 000.php till 007.php
      In some files may no fb_ tags be! Don't wonder!

      Now you could start the import!
      Take step after step and you will have your data at VBulletin.

      If you have any issues while install or import-beginning please google first! There was a error with Mysam engine or somting like that for me ... googled and fixed!

      Hope that will help you!

      regards
      CJ
      Last edited by Ivan Beser; Sat 1st Feb '14, 2:06am.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X