Convert from SMF(Simple Machines Forum) to Kunena forum

Convert SMF to Kunena (Joomla based forum)

The easiest way I found to do this was to install Kunena 1.7 and NOT the latest version. Kunena 1.7 has an importer that works (as of the writing of this post).

               
1. First update SMF to its latest version.

1b. Convert smf forum to match the collation of Joomla by running the following.  If SMF and Joomla tables are in TWO DIFFERENT databases you may need to run the following queries via phpMyAdmin inside the database where your smf tables are located:

ALTER TABLE `smf_admin_info_files` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_approval_queue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_attachments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_ban_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_ban_items` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_boards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_board_permissions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_calendar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_calendar_holidays` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_collapsed_categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_custom_fields` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_custom_fields` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_group_moderators` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_activity` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_banned` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_boards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_digest` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_errors` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_floodcontrol` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_group_requests` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_karma` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_mark_read` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_member_notices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_notify` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_online` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_packages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_polls` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_reported` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_reported_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_scheduled_tasks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_search_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_search_results` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_search_subjects` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_search_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_spider_hits` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_spider_stats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_subscribed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_log_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_mail_queue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_membergroups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_members` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_message_icons` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_moderators` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_openid_assoc` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_package_servers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_permissions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_permission_profiles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_personal_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_pm_recipients` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_pm_rules` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_polls` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_poll_choices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_prefix` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_scheduled_tasks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_smileys` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_spiders` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_subscriptions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_themes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smf_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

2. Install KUNENA 1.7 (not the latest version) it has a forum importer for SMF 2.0 which works.

3. Install Kunena 1.7 importer into Joomla.
http://forge.joomla.org/gf/project/kunena/frs/?action=FrsReleaseView&release_id=16076

4. Navigate to: Joomla > Components > Kunena -Forum – Importer

5. Run the importer 1st. DO NOT add any categories or anything to Kunena
    Relative Path to Forum:  ../smfForum  (the 2 dots means smf is one directory up from your joomla root folder)
    User Import Mode: Use existing Joomla users
    Create Missing Users: Yes, create automatically

6. UNCHECK "Import Session Information"     (!!!!!!!!IMPORTANT!!!!!!!)

7. Hit "TRUNCATE" 1st.  You may also have to hit it after you receive an error message and have to restart again.
    DO NOT delete any database tables

8. After conversion, log into PHPMyAdmin (if you're not already)  and clean up how the text will appear. This is only required if you have a bunch of weird characters inside the body of your posts after converting to Kunena.

Run the following queries in phpMyAdmin to clean up the text:

    
    update jos_kunena_messages_text set message = replace(replace(replace(message,'\\\'','\''),'\\\"','"'),'\\\\','\\');
    
    update jos_kunena_messages set subject = replace(replace(replace(subject,'\\\'','\''),'\\\"','"'),'\\\\','\\');

    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '“', '“');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '“', '“');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '”', '”');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '”', '”');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '’', '’');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '’', '’');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '‘', '‘');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '‘', '‘');

    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '—', '–');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '—', '–');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '–', '—');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '–', '—');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '•', '-');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '•', '-');
    
    UPDATE jos_kunena_messages_text SET message = REPLACE(message, '…', '…');
    UPDATE jos_kunena_messages SET subject = REPLACE(subject, '…', '…');
   

After that and you're happy with your conversion, you can now upgrade to the latest version of Kunena through Joomla