Dragonfly import?

[man1c]

I was wondering is it possible to import the members and forums posts from dragonfly cms?

[Jerry]

This http://www.cpgnuke.com/ ?

At the moment no, though depending on the database structure I might be able to write one.

Do you have one you want importing ?

[man1c]

Yes that the one, dragonfly is the new version of cpgnuke.

And yes I have a database that I would love to import as I realy cant face starting my site from scratch again

[Jerry]

Yes that the one, dragonfly is the new version of cpgnuke.

And yes I have a database that I would love to import as I realy cant face starting my site from scratch again

If you can make a mysqldump of the database and tar.gz or zip it up and PM me a URL where I can download it I'll take a look at it.

[Jerry]

It's phpBB2.

• Set the impex config : sourcetableprefix = cms_bb
• Run module 001
• Ignore module 002
• Run module 003
• Set the impex config : sourcetableprefix = cms_
• Comment out line 141 in file impex/systems/phpBB2/004.php ($old_group_ids = $this->get_phpBB2_user......)
• Run module 004
• Do not run 005
• Run 006 - 013 as per normal

[ZeroHour]

Set the impex config : sourcetableprefix = cms_bb

• Run module 001
• Ignore module 002
• Run module 003
• Set the impex config : sourcetableprefix = cms_
• Run module 004
• Do not run 005
• change sourcetableprefix back to cms_bb
• Run 006 - 013 as per normal

That *seems* to have worked for me

[Jerry]

Two and a half years later

Good to know

[ZeroHour]

Np, I will let you know what issues I find. We have a very large migration of a db of a few hundred mb.

[TXC]

Are these steps still mandatory or should choosing dragonfly as the system work with the newest version of impex?

When I ran the 001 module for dragonfly, all of the databases came out green so I figured I was home free. The users gave me time-out issues until I ran the script at 100 units per page. Lowering this value from the default 1000 seemed to help not time-out all the other modules as well. I thought I was doing fine until I hit Import Posts. It seems that it would only execute the first chunk of whatever I told it to run, so running that at 1000 units only converted the first 1000 posts and dumped them into the new vb posts table, returning me back to the Import/Export :: dragonfly page. Running anything much higher than 1000 would time out on me. It is a truly massive forum with some 2000 users, 12000 threads and 100000 posts and the vbulletin is a clean install.

But then, checking back with my testvb, expecting to see the newly populated vbulletin with a host of broken posts, I saw nothing. Nothing had caught. All I saw on the front end was "Main Category - Main Category Description; Main Forum - Main Forum Description". I went back to the admin and saw that the users were there, but that the fora were not. Likewise, skimming over the SQL, there seemed to be stuff everywhere I would expect it to be.

[TXC]

I tried ZeroHour's method, going with PHPBB2+renaming the table prefix half-way through and it looks like it copied threads and posts, but the forums still doesn't show up in either the admin or the front end.

Is there something I am forgetting to do here? I looked through the tables and I don't see anything that looks inherently evil. Maybe it is all the null values? Maybe the parentlist and the childlist columns are miscalculated? Maybe the options column is showing crappy values?

I'm attaching the table (in sql code), please halp.

[TXC]

Oh, jeez never mind! I got it to work...

I can't read directions!

¬_¬

[killerglass]

I see this has been done a while ago

By any change was the Dragonfly version 9.1.1?

I have a huge forum I would like to switch over to VB to match the others for ease of management


Thank you

[Jerry]

The supported version is 9.2.1

[killerglass]

The supported version is 9.2.1

Perfect

Thank you Sir!!