Converting posts and topics from Drupal

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
Locked
User avatar
Ger
Recognised Extension Developer
Posts: 1981
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Converting posts and topics from Drupal

Post by Ger »

Hello,

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?
My extensions:
Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP, Live topic update, Modern Quote, Quoted Where (GDPR) and Autoresponder.
Newest: FAQ manager for 3.2

Like my work? Buy me a coffee to keep it coming. :ugeek:

-Don't PM me for support-
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Converting posts and topics from Drupal

Post 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
Have you hugged someone today?
User avatar
Ger
Recognised Extension Developer
Posts: 1981
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Re: Converting posts and topics from Drupal

Post by Ger »

Thanks, I'll look into those.
My extensions:
Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP, Live topic update, Modern Quote, Quoted Where (GDPR) and Autoresponder.
Newest: FAQ manager for 3.2

Like my work? Buy me a coffee to keep it coming. :ugeek:

-Don't PM me for support-
Locked

Return to “[3.0.x] Convertors”