Converting bBlog 0.76 to WordPress 2.0 (Import/Export) Script

I had this hanging around for a while so I thought I may aswell publish it.

I tried quite a few import scripts to get my posts and comments from my old bBlog install over to my new WordPress 2.0.1 installation, but none of them worked properly.

I found one in php which worked for WordPress 1.5.2 and tweaked until it worked on 2.0.x series, it also imports some extra info like commentors IP addresses. (I suggest this one for 1.5.x)

It took me a long time to get it to update the comment count on WordPress properly.

Imports categories properly, simplified it and I straightened up the workflow a bit.

bBlog Import

If you have a newer version of bBlog it should be pretty trivial to get it to work.

The original came from here:

Taj bBlog WordPress Importer

So here you go, an easy to use and reliable bBlog to WordPress import script!

You can download my bBlog to WordPress 2.0 converter here.

Comments

comments

Subscribe

You can subscribe via e-mail to get my posts in your Inbox, or stalk me on numerous other platforms.

Follow my Dayre!

, , , , , , ,


18 Responses to Converting bBlog 0.76 to WordPress 2.0 (Import/Export) Script

  1. suanie July 4, 2006 at 3:33 pm #

    oO bBlog.. blast from the past… and paul’s current object of wrath

  2. Nicktay July 4, 2006 at 4:18 pm #

    i didn’t realized people still used bBlog :)

  3. ShaolinTiger July 4, 2006 at 5:19 pm #

    suanie: Yah I still have some problems because of it.

    Nicktay: I guess they don’t if they have any sense haha

  4. Desmond Lee December 31, 2006 at 9:22 pm #

    Hello,

    I tried your script and kept getting the error below (credentials changed and worked for bblog and WordPress):

    Warning: Invalid argument supplied for foreach() in …\import-bblog.php on line 164
    couldn’t get post ID

    [
    at import-bblog.php source line 164:

    foreach($post->sections as $section) {
    $categories[]=$section;
    }

    ]

    My old bblog 0.76 is at http://www.leedesmond.com/blog/ and am trying to migrate to WordPress 2.0.5 at above new site.

    Thanks ShaolinTiger for the help.

  5. Jim March 23, 2007 at 3:21 am #

    Thanks so much for this script. You saved me the time it would have taken to write it from scratch. I worked flawlessly to migrate from bblog 0.76 to WordPress 2.1.2. Good on you.

    Jim

  6. Andrew Casad April 16, 2007 at 1:19 pm #

    Thanks for the excellent script, however, I have two concerns. I have a running version of WordPress 2.1.3 and bBlog 0.7.6. I have the PhotobBlog plugin installed, with the photobblog photos linked to my gallery. How should I edit the script to also import the associated photos (it uses the bBlog post number)? Also, when trying to use the script, I am not able to get to Step 1. The script stops loading, but the page has not changed; no error codes, etc. Any suggestions? Thanks!

  7. Mithfindel December 3, 2007 at 1:12 am #

    Hi,

    I’ve been desperately trying to find a migration script from bBlog to WP2 and Google sent me right here. However, it seems that your file is not available anymore; is there anywhere on the Internet where I can download it ? I’d rather give it a try than try to figure it by myself with my newbie PHP/SQL skills.

    Thanks in advance !

  8. ShaolinTiger December 3, 2007 at 2:35 am #

    Mithfindel: I’ve uploaded the file again, it got lost in the recent crash. Do note it won’t work if you try and convert to the latest 2.3 version of WP so do convert to an older version. Cheers!

  9. Dan Ashby January 29, 2008 at 7:47 pm #

    Hi Shaolin,

    Any news on the question from Andrew Casad? I’m where he is with the picture plugin and it appears to make the script break. Any help would be great…

    Dan

  10. ShaolinTiger January 29, 2008 at 7:53 pm #

    Do note this is for WordPress 2.0.x only, not tested with 2.1.x or above.

    No idea about the picture plugin, you’ll have to hack it yourselves.

  11. Dan Ashby January 29, 2008 at 10:01 pm #

    Thanks for the reply – interesting the ‘Jim’ said he had it working with 2.1.2, which I couldn’t. I’ll downgrade and let you know.

    Dan

  12. Jim January 29, 2008 at 10:16 pm #

    Dan Ashby, what failed for you? Perhaps you have some non-standard modifications to your bblog database structure. It’s been ages since I migrated so I’m afraid I won’t be much help, but you should post the problem your having specifically.

  13. Dan Ashby January 29, 2008 at 10:23 pm #

    The first problem is that $HTTP_GET_VARS is deprecated so I changed it to $GET which leaves me with:

    WordPress database error: [Field ‘post_excerpt’ doesn’t have a default value]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_title,post_status, comment_status, ping_status, post_name) VALUES (‘1′, ‘-05-16 ‘, ‘-05-16 ‘, ‘Jeez, I just couldn\’t be bothered, and it probably would have taken 5 years anyway, to make my own full feautured blog program. So I\’m using this one. It seems pretty easy to drive so there we go. If I can\’t import the old blog entries, I\’ll just put a link up to the old stuff – I guess that\’s easiest and I\’m tired with all this now anyhoo…’, ‘A new way to blog’, ‘publish’, ‘open’, ‘open’, ‘a-new-way-to-blog’)

    couldn’t get post ID

  14. ShaolinTiger January 30, 2008 at 12:03 am #

    Dan it looks like post_excerpt is a not null field, so you have to find out what order to add it in and then add a value for it, might be as much as just adding ‘ ‘

  15. Dan Ashby January 30, 2008 at 12:06 am #

    OK,

    I had to allow NULL entries in the following fields:

    wp_posts:
    post_excerpt
    to_ping
    pinged
    post_content_filtered

    wp_categories:
    category_description

    And also change the date formatting from %G to %Y:

    $post_date=strftime(“%Y-%m-%d %T”, $post->posttime);

    Hey BINGO! It works, thanks for a great script.

    Dan

  16. Alison November 1, 2008 at 11:26 am #

    Thanks so much for this. Good thing WP 2.0 is legacy supported and available for download, with the “Debian philosophy”. I’ll convert to WP 2.0 then upgrade.

    Any thoughts on converting over the theme?

  17. Jim November 1, 2008 at 6:44 pm #

    I don’t have any advice to offer regarding converting themes. I started over and expect you will too.

    I’m really surprised to learn that someone is still using bBlog. It’s been years since it was supported. Wow!