e107 to WordPress v0.8: import images and preferences

The 8th version of my e107 to WordPress import script is out ! This version is quite special because this is the first one that support all features I planned to implement in the road map I write for the first alpha release.

Here is the changelog:

  • Import images embedded in e107 news and custom pages,
  • Import e107 site preferences (like site name and description),
  • Better import of user profile data,
  • An existing user on the blog can be detected and updated automatically,
  • Fix the profanity filter bug,
  • Tested with latest WordPress 2.1.3.

21 thoughts on “e107 to WordPress v0.8: import images and preferences

  1. Hi Kevin, where I should upload the e107.php file and the folder e107-includes?

    mydomain.com/my-wordpress-dir/wp-admin/import/ it’s fine?

    Thanks in advance

  2. mydomain.com/my-wordpress-dir/wp-admin/import/

    Yes, that’s right ! But don’t forget to include there the sub /e107-includes directory and its files (you can find everything in the archive).

  3. Thank you kevin! I got an error:

    e107 Import: preferences and users

    Database connexion successful !

    All e107 preferences imported.

    Fatal error: Call to a member function on a non-object in /home/myusername/public_html/wp/wp-admin/import/e107.php on line 525
    

    I am using WordPress 2.2

  4. Hi again. I am doing something wrong?, let me explain:

    The e107 site was installed on the server root, the WordPress site resides in the subdirectory: wp

    The e107.php and e107-includes folder in: mydomain.com/my-wordpress-dir/wp-admin/import/

    Databases; the e107 database: myusername_george, the WordPress db: myusername_wp

    Following the process i get something like this:

    WordPress database error: [Table 'myusername_george.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'e107_mail_user' LIMIT 1
    

    Thanks in advance

  5. Hi Kevin, you welcome. I thought that the problem was related to the Worldpress version 2.2 that I am using right now.

    Looking at the ‘e107.php‘ code i’ve found this:

     // $user_image // XXX how to handle this ? export to gravatar ???
    
          $user_data = array(
              'first_name'      => $GLOBALS['e107db']->escape($first_name)
            , 'last_name'       => $GLOBALS['e107db']->escape($last_name)
            , 'nickname'        => $GLOBALS['e107db']->escape($user_name)
            , 'display_name'    => $GLOBALS['e107db']->escape($display_name)
            , 'user_email'      => $GLOBALS['e107db']->escape($user_email)
            , 'user_registered' => $this->mysql_date($user_join)
            , 'user_url'        => $GLOBALS['e107db']->escape($user_homepage)
            , 'aim'             => $GLOBALS['e107db']->escape($user_aim)
            , 'yim'             => $GLOBALS['e107db']->escape($user_msn)  // Put MSN contact here because they have merged with Yahoo!: http://slashdot.org/articles/05/10/12/0227207.shtml
            , 'description'     => $GLOBALS['e107db']->escape($desc)
            );
    

    e107db‘ is fine, or it should be ‘e107_db‘ ?

    Keep in mind that I am not a programmer, so it could be wrong :)

    Thank you very much.

  6. Problem SOLVED!

    What I did:

    1. Install WordPress 2.1.3
    2. Upload e107 to WordPress v0.8 (the file e107.php and the folder e107-includes) into wp-admin/import
    3. Open your e107 database with any text editor, rename — Database: `my-old-e107-db-username_my-old-e107-db-name` to `my-wordpress-username_my-wordpress-db-name` select all and copy.
    4. open phpmyadmin, click SQL and paste, click GO! wait until the process is finished.
    5. Go to your site admin, click manage, import, and follow the simple steps, that’s all! :)
  7. Congratulation George, and thank you to share your solution with us !

    But I still feel ashamed of my inability to reproduce this bug.

  8. Kevin, don’t feel ashamed: your script is perfect!!! I am very impressed with this script, it’s very easy to use, even for a n00b like me.

    About the “bug”, i believe that the scrip only recognizes the WordPress database, so by inserting the e107 tables into the WP database is just fine, and the script works like a charm.

    Oh, i forgot to say something: after the conversion delete all e107_ tables in your WordPress database.

  9. Just tried your e107 plugin (on my test site), and it converted the users great. However, when it gets to the news archive posts, it seems to either timeout, or just not do it. Is there maybe a way to go directly to this part of the script instead of going through the user portion first again, and/or maybe even allowing you to convert a certain amount of articles at a time? kthx for the great script btw.

  10. Hey Kev, I’m having the same problem that Dave reported. Your script imports the users, categories, and then starts on the news… for my site, it gets about 85-90% done and then just stops. — It moved over 744/789 news items and probably a good 200 “attachments”, which looks like they were mainly the banners and a few other odds and ends.

    Maybe move this to another step, or give the user the option to skip this completely? — Personally, I don’t really care about the old banners/attachments, though I’m sure others might.

  11. Looking at it a bit more, it looks like I was wrong about it trying to import the banners. Though it is trying to import something, which it is putting in as a 'post_status'=inherit. Not sure what these items are, or should be but I can see they are not something I need.

    Looks like it might be a link or img that was used in the post.

  12. Alright, whatever was causing my problem is related to line 730:

    $this->importImagesFromPost($post_id);
    

    I commented that line out, and it was able to import everything. Well, except for the images. :D

  13. hi
    the “upgrade” is stops after this for me:

    e107 Import: preferences and users
    Database connexion successful !
    All e107 preferences imported.

    no buttons, no other options.
    the user table was imported perfectly!

  14. I’d like to convert http://www.rotaryblast.com to wordpress. I d/l’d the script & gave it a try, but encountered the same error mentioned previously.

    Would one of you programmer-types care to try this for me? My club would be very appreciative.

    Thanks – Ken

  15. Yo tengo la versión Word Press 3.01
    Funciona la migración para esta versión?
    Gracias…

  16. Pingback: e107 to Wordpress migration : v0.9 plug-in released | Kevin Deldycke

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.