From Wordpress > Drupal 4.7 RC

By rickvug on 1 Apr 2006 at 02:33 UTC

I decided to take the plunge and switch over my Wordpress blog to Drupal, which I will be using to build my company's site. I want to take advantage of many of the new features in 4.7 but there doesn't seem to be a way to be a way to import my data. The script mentioned in other threads does not do the trick.

Any suggestions? I'd assume (and hope) that there would be a lot of people in my situation, especially when 4.7 is final. Anyone care to work out the bugs on me?

Any help would be great!
Rick

Comments

Process to Import Wordpress 2.0 to Drupal 4.7

sami_k commented 1 April 2006 at 03:24

I recently upgrade Wordpress 2.0 to Drupal 4.7 and I have to say that it's not all that easy. Basically, there is a script that downgrades Wordpress 2.0 to 1.5, so you need that if you're using Wordpress 2.0. Then there is another script that will import posts from Wordpress 1.5 to Drupal 4.6, so you essentially need a 4.6 site install. Then after it has imported everything into the 4.6 install, you can upgrade that to 4.7 by just pointing the 4.7 install to the 4.6 database and calling the update.php. There are also some bugs in the import script so if you have two entries of the same date the script will fail. The way to get around this is to disable creating url-aliases in the script and instead using pathauto after the install to create the paths.

Good luck.
--
showcase | blog | rob's book

Thanks for the info! It's

rickvug commented 1 April 2006 at 03:34

Thanks for the info!

It's Friday night, so I don't think that I'll get to this today. Luckily, I never did upgrade to Wordpress 2.0 and I'm working with a clean install. I thought that I might have to import via 4.6 then upgrade. I have never done and upgrade before, so this should be good practice for me.

Take care,
Rick

-------------------------------------------------------------------
Rick Vugteveen |rickvug.com @rickvug on Twitter

I tried to run the script...

rickvug commented 1 April 2006 at 22:00

Hi again,

I tried to run the script on a fresh 4.6 database but to no avail, even with the clean urls turned off. Here is the output and error that I get:

Conect?ndose a WP por contenidos
(mysql): SELECT id, user_login,user_pass,user_email,user_url,user_level FROM wp_users  
(mysql): SELECT ID,post_date,post_title,post_category, post_content,post_excerpt,post_name,post_author,post_status,comment_status FROM wp_posts ORDER BY post_date  
(mysql): SELECT cat_id,cat_name,category_nicename,category_description,category_parent from wp_categories  
(mysql): SELECT post_id,category_id FROM wp_post2cat  
(mysql): SELECT * from wp_comments  
Column 'uid' cannot be null

Guessing about the point where it freezes up, it looks like its choking on the comments section. Possibly because I allowed comments without registration (user id)? Anyone else who has had similar problems is welcome to help!
Rick

-------------------------------------------------------------------
Rick Vugteveen |rickvug.com @rickvug on Twitter