Page 1 of 1

Converting posts and topics from Drupal

Posted: Mon Jul 04, 2011 7:30 am
by Ger

I've been asked to convert an old forum to phpBB3. The old forum is from a neglected Drupal forum-extension. The owner is not entirly sure wich version the old forum is, he thinks it's form Drupal 4. For easy reference in this post I'll call it "the Drupal forum".
Now, basically the Drupal forum is one of the simplest type of forum there is. There aren't categories, no seperate forums, basically no forum structure at all, just 1 big forum with all the topics in it. There's also no BBcode used.

I've read the sticky about importing the users, that shouldn't be much of a problem. But the second step is to import the topics and posts. How do I do that? All I have is a huge SQL file (~120 MB) of the entire Drupal site (forum + anything else one can put in Drupal). I've figured out what tables are related to topics and posts, so I guess I should copy those to a separate SQL file to make it more manageble. But then what? Since I don't have an XML file, I can't use the sticky for Generic Message Import. I guess the best approach is to loop over all the topics in the Drupal-DB and look for the related posts and then insert them step-by-step in de phpBB-DB.

Some questions though:
  1. Can I be sure that the import-users tool preserves the user-ids from the Drupal-forum? Otherwise, the poster-info for each post will be broken.
  2. Is there some generic function or SQL command for inserting topics and posts in the phpBB-DB?
  3. What's the chance of the server getting stuck on such a task? I think I should batch this process, any tips for that?
  4. Any other tips or thing I should consider before doing this?

Re: Converting posts and topics from Drupal

Posted: Mon Jul 04, 2011 7:14 pm
by D¡cky
The User import Tool assigns new user_ids.

The best approach is to import your sql file(s) into a database, then modify the phpBB2 to phpBB3 convertor to convert the Drupal tables to phpBB3. This convertor does do the conversion in batches.

Have a look at what others have done to convert their Drupal database:
Drupal posts
Migration from Drupal 5.x to phpbb3 - DONE
Converting from drupal forums to phpbb3

Re: Converting posts and topics from Drupal

Posted: Fri Jul 08, 2011 8:17 am
by Ger
Thanks, I'll look into those.