By stephthegeek on

I really need to import my four years of Wordpress entries to Drupal 4.7 asap. The migration script (http://lsb.blogdns.net/pages/wordpress-migration-utility) only imports to Drupal 4.6, and unfortunately importing and then upgrading isn't really an option at this point in the game, after I've been developing the 4.7 site for a month. I tried using node_import, which works, but it seems like a much messier solution for a specific need.

What would be involved in updating the WP script to 4.7? I have a friend who's more SQL-inclined than I and knows Wordpress who is willing to help. I know this must be something that others are looking for too. Maybe if we threw in a bit of $ for a bounty it would provide some encouragement?

Need a solution asap!

Thanks everyone!

⋅ Categories: Drupal 4.7.x

Comments

stephthegeek’s picture

stephthegeek commented

I just wanted to add, I know a big change has been to move the node contents from the node table to the node_revisions table. I have no idea if I'm in over my head here, but if there are only a few structural changes like that, maybe updating this script won't be so bad? Does anyone have a definitive list of changes like this between 4.6 and 4.7?

toptek’s picture

toptek commented

Not having an updated script to import Wordpress entries makes me think twice about switching to Drupal. Not just because without the script a regular WP blogger like me would have a hard time migrating, but also because it is telling me that the Drupal community is not really looking to expand the user base to non-geeky folks.

I can tell that Drupal is very powerful, but it seems you need to be a programmer to install it and use it... half of the time I don't even understand exactly what a certain word means, like "node" -- is that the module, the process, the content itself, the url? And of course the "taxonomy" is another huge hurdle word. On top of that, if you comment like I am doing here, people would rush not to help, but to deride my ignorance. Not good, if Drupal wants to grow its userbase -- if you don't, then you are on the right track.

Sincerely,

Your garden variety WP blogger

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

I'm in the process of writing a module that will import WordPress entries into Drupal. It's available at https://svn.bryght.com/dev/browser/wp2drupal but has code that's specific to my settings in WordPress and Drupal, so if you know a little PHP you'll want to make some modifications to the module.

Note that while it's hosted on Bryght's public Subversion repository, it's a personal project--i.e. not necessarily endorsed by the company--that I coded to solve a problem I needed solving. It has bugs, so use the module first on a test install of Drupal before going live, and you may have to import and start your database over a few times in order to get it right. That said, it makes no changes to the WP portion of the database, so it should not affect your WordPress-powered weblog.

If someone wants to help me develop it and submit patches to me I'll happily review and commit them, though I don't spend a lot of time on it.

Drupal's a tool for geeks that can be bent for use by non-geeks for many types of sites, including weblogs. It's not the best open source PHP platform for just blogging (I say that while noting my personal weblog is powered by Drupal, which I find easier to mold into what I want to do, since there are non-bloggy portions of the website that Drupal handles better than WP). WordPress, if you just want a weblog, is the simplest, easiest to use CMS for that.

(Username formerly my full name, Richard Eriksson.)

stephthegeek’s picture

stephthegeek commented

Thanks Richard, but that module doesn't seem to be working for me.

I need to get my WP site moved over ASAP though, so is there anyone out there who would be interested in moving a WP1.5 (or WP2, if it's upgraded) blog to a Drupal 4.7 for some $$?

rickvug’s picture

rickvug commented

I still need to do this as well. I would be able to chip in a few $ for the creation of an import script or module. Nothing much, but if there is a few others this could be a worthwhile fun little project for someone.

Any takers?

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

stephthegeek’s picture

stephthegeek commented

I've actually got someone to do this for me (need it asap) for about $40. The code will be released back to the Drupal community of course. But if anyone would also find it useful and wanted to pitch in $10 or something, I wouldn't object :)

rickvug’s picture

rickvug commented

I would have no problem pitching in. My problem before was that the WP 1.5 > Drupal 4.6 script wasn't working for me, probabbly due to some malformed html in headers or multiple posting on the same day etc... Or maybe because the Wordpress site was actually transfered from Blogger. In the end, I will pitch in if the script works for me, which will hopefully reduce the errors that any user would encounter.

PS - Notice a trend in the upgrade path? :)

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

johsw’s picture

johsw commented

I would be very interested in a wp2.0 -> drupal4.7 migration tool. How did this end up?

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

I think I ended up upgrading the script so that it works for Drupal 4.6 and WP 2.0. I'll see if I can steal some time from the weekend (my weekends usually don' t mind) to get it working for 4.7.

(Username formerly my full name, Richard Eriksson.)

Borek-1’s picture

Borek-1 commented

I have developed a working Wordpress 1.5 or 2.0 to Drupal 4.7 migration module which I will release early (after I migrate my own blog). Leave a comment if you are interested.

Borek, http://borber.com/

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

Good news! I wrote https://svn.bryght.com/dev/browser/wp2drupal to import my WP weblog(s). It's GPL, so go ahead and steal from there if there's anything useful.

There's definitely a demand for easy import into Drupal from other CMS platforms, the hard part for me was migrating URLs (my approach is part hard-coded, part using the WP post slug) and importing categories. I understand someone modified my module to do categories, but haven't heard back on getting my code patched with that update.

(Username formerly my full name, Richard Eriksson.)

rickvug’s picture

rickvug commented

Between these two efforts and the old 4.6 version I'm sure that something pretty solid will be made. I'll be first to test my blog, as it wouldn't transport over to 4.6 before.

-------------------------------------------------------------------
Rick Vugteveen | Image X Media (work) | Blog (personal)

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

apratt’s picture

apratt commented

After struggling with it for a while I finally decided to ask for help...

I added the module.
Set the settings to grab my WP2 blog
and then went to the admin ->content->wp2drupal and got the following error.

warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/.boccacclo/mahara/laughingboomer.com/modules/wp2drupal.module on line 203.

Any thoughts?

apratt
crosseyed discus throwers
- don't set records
- keep the spectators on their toes

--
Angus Pratt
Check out my coolest Drupal project - Joint Apprenctice Refrigeration Training School
http://anguspratt.ca
(778)708-9456

Borek-1’s picture

Borek-1 commented

At the time I had started the development, there was no working migration script so I am sorry that our work is kind of duplicated. But never mind, the main thing is that there will finally be WP2Drupal migration utility.

Some features of mine:

  • Migration of posts, static pages, comments and categories (with correct nesting). Publish status, dates etc. are persisted.
  • Migration of users - you can specify Wordpress-users-to-Drupal-users mapping and if no match is found, new Drupal user is created automatically.
  • Migration is highly configurable - you can specify vocabulary name, description and many other options.
  • pathauto module is supported (but not required)
  • Old URLs are redirected to the new ones (both posts and comments URLs). Unlike any other approaches I have seen, this one is highly flexible and server-software independant (works on both Apache and IIS). Redirection rules are stored in a database table and the actual redirection is done in a simple user-configurable PHP script.

I'm currently finishing works on my own new blog so I could publish my module by the end of this week.

Borek, http://borber.com/

Borek-1’s picture

Borek-1 commented

Hello everyone, working and tested wp2drupal module has been released. Visit http://drupal.org/node/69706 for more information.

Regards,
Borek, http://borber.com/

Mike_s’s picture

Mike_s commented

Hi All,

People here are working on very relevant stuff, congratulation. It turns out that this conversion utility from a wordpress theme to a Drupal theme is precisely what I need.

Unfortunately, I am not an IT guy, I am an IC designer so quite far away from IT concepts and their use.

I am asking myself questions like, how to run a Php scripts? Assuming that this what to do with avalable package to download...

Can you explain more in detail the procedure ?

Thanks a lot.

Mike.