WordPress.org

Ready to get started?Download WordPress

Forums

B2Evo Importer (82 posts)

  1. IsaacSchlueter
    Member
    Posted 8 years ago #

    Hey, this script seems to work really well. I've been playing around with it to try to get my stuff over so that I can swap progs without much trouble some time soon.

    Just a few caveats:
    If you have a ' in the name of a category, it's going to choke. Easy enough to work around, since I only have one cat that has a ' in it, but there ought to be a way to escape these, no?

    Also, it would be absolutely awesome if it didn't just import the categories, but also imported the blogs as top-level categories, and then insert the categories themselves as children of the top-level blog category. That would be ideal, since WP categories can do just about everything that multiple blogs can in b2evo, and then I could keep all my permalinks (mostly) stable through the transition.

    I've got a lot going on the next few weeks, but if no one else can get to this sooner than me, then I'll probably look into it.

    Anyway, thanks for the script! It's going to make this a lot easier.

  2. dualravens
    Member
    Posted 8 years ago #

    Okay, I'm moving to a different server and I'm having trouble getting b2evo to move nicely. So, I thought this is the time to move the blog to wordpress, like all of the other blogs I manage. I found this lovely script, was filled with excitement but instead of getting a nice import, I get a page filled with these sorts of errors (I edited out my actual database):

    WordPress database error: [Table '"my b2evo database.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name='fileupload_url'

    This is a whole page of things like this, and while it says by the end things are imported, nothing changes on the wordpress installation, so clearly I've mucked the whole thing up. I suspect I'm entering something wrong, but I don't quite get what it is.

    Help would be most appreciated. B2evo was nice for what it could do, but I keep coming across complications which makes WP my blog of choice now.

  3. IsaacSchlueter
    Member
    Posted 8 years ago #

    DualRavens:
    You have to install WordPress into the same database that you use for b2evolution in order for this to work. Don't worry about overwriting anything: the wordpress tables are wp_ and the b2evo tables are evo_, so they shouldn't conflict by default.

    Is this a problem? If so, I could add that option to the importer. I'm going to be publishing a new version of it soon (ie, in the next few days/weeks.) If you'd like an early copy, send an email to any address of your choosing at IsaacSchlueter.com.

  4. dualravens
    Member
    Posted 8 years ago #

    Ah... yes. That's it. No, it's not a problem. Well, maybe it's a problem with my reading comprehension.

    Thanks so much for the response. I had the strong suspicion it was an error on my side, only I don't know enough to be sure about it. I very much appreciate your help.

  5. IsaacSchlueter
    Member
    Posted 8 years ago #

    MRT and I have tweaked this script a bit more, and added some more functionality to it.

    You can get it from either http://themikecam.com/downloads/import-b2evolution.php.txt or http://isaacschlueter.com/download/import-b2evolution.php

  6. dualravens
    Member
    Posted 8 years ago #

    Hey, I want to say the import tool worked very nicely. Everything is in order. Thanks for all your work with this.

  7. seadawg
    Member
    Posted 8 years ago #

    Good work guys!
    My way was kinda dirty, and only handled the permalink problem. I wasn't really looking forward to maintaining the complete importer. Let me know if you ever need a hand with it though.

  8. hbee
    Member
    Posted 8 years ago #

    Thank you, thank you, thank you! I'll be moving to WordPress in the next couple of days or so. I've just spent another evening wondering why I can't insert a simple picture into a post and why I have to jump through hoops just to use a font tag and why...aw, heck, b2evo is just plain lousy.

  9. rup3rt
    Member
    Posted 8 years ago #

    A brilliant tool that worked like a dream. Thanks!!

    One tiny hiccup (hiccough?) as it cannot handle accents --- at least spanish & portuguese ones. I just get the question marks embedded in black diamonds :-(

    Is there a quick tweak like htmlspecialcharacters that can be applied?

    Please release me from the triple hell (bureaucratic, ugly & badly supported) that is b2evo --- b2EVIL!

    ThanksThanksThanks

    R3

  10. daynah
    Member
    Posted 8 years ago #

    Actually, having a way for people who have WordPress installed in a different database would be nice. A lot of hosting plans now offer a scripts gallery where with two clicks (literally) you have a program installed. Without knowing anything about the program. The one for my host includes both b2evo and WordPress. But this easypeasy way of installing things requires a new database for every script you install. Price you pay for being lazy (or not knowing what the heck your doing).

    I think there are, potentially, a lot more people who need to convert from b2evo to WordPress precisely because of these script galleries. Really. Multiple blogs on the same page just SOUNDS cooler... till you have it... and find yourself oddly stuck with it...

  11. anysuzy
    Member
    Posted 8 years ago #

    tsc tsc i know nothing about it sorry!

  12. gpf
    Member
    Posted 8 years ago #

    http://themikecam.com/downloads/import-b2evolution.php.txt or http://isaacschlueter.com/download/import-b2evolution.php

    Thank you so very much for this script! I am rescued and on my way back to my old happy blogging ways...

  13. PapZ
    Member
    Posted 8 years ago #

    I tried to use it as a b2evo 1.6 (Phoenix apha version) user, but it didn't work out.
    Is this script 1.6 compliant?

    Let me know, please!

    Francesco

  14. itti
    Member
    Posted 8 years ago #

    hi... i have the same problem with special characters. for me the import of the german "umlauts" (äöü) doesn´t work. all i get in wp are questionmark-like symbols. what can i do?

  15. hbee
    Member
    Posted 8 years ago #

    Saving possibly a little bit of face

  16. benchodroff
    Member
    Posted 8 years ago #

    I am a b2evo 1.6 (Phoenix apha version) user and I also could not get the script to work.
    I *really* would appreciate any help! AIM screen name is chodviolin - will work with you to help debug the script.

    Here are the errors I got:
    Importing User records ...

    WordPress database error: [Unknown column 'user_firstname' in 'field list']
    INSERT INTO wp_users (user_login, user_pass, user_firstname, user_lastname, user_nickname, user_icq, user_email, user_url, user_ip, user_domain, user_browser, user_registered, user_level, user_aim, user_msn, user_yim, user_idmode) VALUES ('chod', 'e9614726487f64004164f5c446d3f627', 'Benjamin', 'Chodroff', 'chod', '0', 'benjamin.chodroff@gmail.com', 'http://www.benchodroff.com/', '127.0.0.1', 'localhost', '', '2004-07-02 14:02:06', '10', 'chodviolin', '', '', 'login')
    1 User record(s) imported!
    Importing Category records ...
    4 category record(s) imported!
    Importing Entry records ...
    Invalid query: Unknown column 'post_category' in 'on clause'
    SQL : SELECT * FROM
    evo_posts INNER JOIN evo_categories ON cat_ID = post_category

  17. changbill
    Member
    Posted 8 years ago #

    I'm also having a proble with the importer, I had the user problems noted above but just deleted the users since I only had 2, but then it gave me this error:

    Warning: Invalid argument supplied for foreach() in /home/content/c/h/a/changbill/html/blog/wp-admin/import-b2evolution.php on line 415
    0 category record(s) imported!
    Importing Entry records ...
    0 entry record(s) imported!
    0 comment record(s) imported!
    0 entry category record(s) imported!
    That's all folks!

    Any help would be appreciated.

  18. changbill
    Member
    Posted 8 years ago #

    Ignore the above post I am exceedingly stupid, after throwing in some debugging code I realized I had entered the wrong blog_id number. Sorry.

  19. lenwood
    Member
    Posted 8 years ago #

    I have two questions:

    1) is there a way to test this script before I actually use it? I'm working with a couple of years worth of posts & comments, so I'd like to know what I'm doing before I run this script on that data.

    2) for those of you that are familiar with b2e's backend, what statistics plugin is most similar to b2e's? I'm about to migrate, and that's one of the features that I most love about b2e, I can always see who's been by and how they got there.

  20. pyrofenix
    Member
    Posted 8 years ago #

    Unfortunately I was lazy and used the 'fantastico' installer that my site host provides to install b2evo (version 0.9) and am sick of it and installed WordPress using the same sinstaller. Now i'm trying to figure out how to import my entries.

    Has this script been successful at all with wordpress and b2evo using separate databases?

  21. lenwood
    Member
    Posted 8 years ago #

    @pyrofenix
    I don't *think* this script will work for two separate databases, but this shouldn't be too difficult.

    Uninstall WP using the same Fantastico script. You'll want to use the latest version (2.0.1) anyway.

    Next, follow the installation instructions (its super easy)
    http://codex.wordpress.org/Installing_WordPress

    When you get to the point of defining the database in wp-config, point this new installation to your b2e database.

    Finally, run this script and follow the instructions.

  22. isecore
    Member
    Posted 8 years ago #

    Hello, I'm moving from a B2E blog to WordPress.

    Anyhoo, I try running this script and all that happens is that first I get this error message:

    WordPress database error: [Table 'b2evolution.wp_users' doesn't exist]
    INSERT INTO wp_users (user_login, user_pass, user_firstname, user_lastname, user_nickname, user_icq, user_email, user_url, user_ip, user_domain, user_browser, user_registered, user_level, user_aim, user_msn, user_yim, user_idmode) VALUES (everything hereafter deleted because I am paranoid)

    and after that I get about a billion of these:

    WordPress database error: [Table 'b2evolution.wp_categories' doesn't exist]
    INSERT INTO wp_categories (cat_ID, cat_name, category_nicename, category_parent, category_description) VALUES ('', 'Blandbloggat', 'blandbloggat', '', '')

    Also, since I blog in Swedish I get the umlaut-error. Is there a way around that?

    Now, I've read every post here, Googled the hell outta this thing but so far no help. Anyone have any creative ideas? My B2 isn't new, it's version 0.9.0.11.

    Any help is appreciated!

    EDIT: Sorry, I'm a dickhead. I didn't understand that you had to put WP into the exact same database that B2 was in. Things worked a lot better after that.

    However the problem with the umlauts and questionmarks remain.

  23. lenwood
    Member
    Posted 8 years ago #

    OK, I've now installed b2e & WP, generated dummy posts and comments, then run this conversion a total of four times to get comfortable with it before I run it on my real data. I understand everything that's happening, just have one last question.

    Once you run it, the database is approx twice its original size. I'm not hurting for server space, but just wondering, is it a good idea to clean up all the "evo_" entries once the data has been properly imported?

  24. NBHQ
    Member
    Posted 8 years ago #

    This is not working for me: I get the following error:

    Importing User records ...
    0 User record(s) imported!
    Importing Category records ...
    2 category record(s) imported!
    Importing Entry records ...
    Invalid query: Unknown column 'post_category' in 'on clause'
    SQL : SELECT * FROM evo_posts INNER JOIN evo_categories ON cat_ID = post_category

    I have b2evolution 1.6-Alpha installed

  25. lenwood
    Member
    Posted 8 years ago #

    This script is not designed to work with 1.6 alpha. At the moment I don't know of a script that will work for you. You may want to try webdevelopers.com (or some other forum) for help importing your SQL.

  26. NBHQ
    Member
    Posted 8 years ago #

    I talked to the developer of this script and he said its only compatible with WP 1.5, if thats correct, does anybody know where I could download this?

  27. grantlairdjr
    Member
    Posted 8 years ago #

    Where can I find or download latest version of b2evo to WP v2 converter / importer?

    Thanks!

    gwlj

  28. frankpereiro
    Member
    Posted 8 years ago #

    I've been reading all of this and maybe the best thing is to install wp 1.5 and then upgrade to 2.0.2 after importing all my posts from b2evo.

    The thing is that I can't find a copy of wp 1.5, does anybody know where is kept the older versions of wp so I can download one for me?

    Greetz,

  29. realign
    Member
    Posted 8 years ago #

    ok, like many disgruntled b2evo users, I am here now (ironically I used to run an older WP install) - i'm looking to port my site out of b2evo (mainly because of the lack of spam support/switching off trackbacks etc)

    so, as this seems an organic thread can someone summarise?

    where is the latest version of the conversion script?
    which WP version do I install?
    how do I port over?

    who gets the high five when it works?

    if we can finalise this as a solution its going to make a lot of people happier and make it all more manageable

    touch wood

  30. pgriffy
    Member
    Posted 8 years ago #

    I'm trying to use this script, and am having some trouble. Here is what I did first:

    Installed 2.0.3 via fantastico.
    Used PHPMyAdmin to copy the tables from b2evolution (1.6) into the wp database.

    Ran the script.

    The categories imported, and I can find them. It said it imported users, but I cannot find them. I get an error message when it is importing the entry records:

    All right sparky, this is where the actual import takes place! Do you feel lucky today? :p
    Importing User records ...
    3 User record(s) imported!
    Importing Category records ...
    8 category record(s) imported!
    Importing Entry records ...
    Invalid query: Unknown column 'post_category' in 'on clause'

    SQL : SELECT * FROM
    evo_posts INNER JOIN evo_categories ON cat_ID = post_category WHERE cat_blog_ID IN (5)

    Any help would be awesome!

    Duh! Read the comments first. I ran across someone with the same problem (b2evo version 1.6). Hoping it is fixed now??

Topic Closed

This topic has been closed to new replies.

About this Topic