By bradtem on

Testing out if I can move a bunch of stuff, including MT blog, to Drupal. I got the mt-to-drupal.cgi script, which is a great start, but clearly the table stuctures have changed since it was written.

In particular I changed the SELECT vid from vocabulary node where node like blog to
SELECT vid FROM ${db_prefix}vocabulary_node_types WHERE type LIKE '%blog%'"
and that made the basic import go with some errors. It put the wrong UID on all the postings, which I fixed with direct SQL updates.

It almost works, but the comments don't show on the blog postings in blog view. Ie. it doesn't say "3 comments". However, if you go into node view, the comments do show up. I don't see much difference between them and drupal-made comments except for the format and USER fields. These comments are not from registered users.

The aliases didn't work either but I presume that can be figured out.

One of the reasons I started with MT was I figured if I didn't like it, conversion scripts would be easy to find because MT was so popular and all the other systems would want to take users from it. Oh well, ended up having to code again, but would appreciate some thoughts from drupal database experts.

Comments

junyor’s picture

junyor commented

You need to update the node_comment_statistics table.

Bèr Kessels’s picture

Bèr Kessels commented

Next time, please consider filing a support request.

[Bèr Kessels | Drupal services www.webschuur.com]

naudefj’s picture

naudefj commented

Fixed - see http://drupal.org/node/28054

harry slaughter’s picture

harry slaughter
Location Omaha NE USA
commented

i recently used the script to move from MT to Drupal (http://slaughters.com). It wasn't a 'user friendly' type of thing, but any decent site admin should have little trouble.

as i recall, the last DB call in the file fails because it does not reflect the current schema, but the rest of the stuff made it in fine.

oh, one more exception. the script may have wrapped the html from MT and this did cause problems as Drupal can't handle newlines within tags. but it may have been the way they came out of MT, not sure.

overall, without this script, i probably wouldn't have converted to Drupal.

tip if you do convert - browse through your node pages and validate your stuff with the w3 validator. you'll probably find lots of broken html as MT was HTML/transitional and Drupal is XHTML/Strict (i believe :)

--
Living in fear of patch hell?
Want a stable development environment?
Support Dev Releases: http://drupal.org/node/30903
Support Code cleanup too: http://drupal.org/node/28540

--
Devbee - http://devbee.net/