Invision Power Board to Vanilla

Mr K

Okay ... either I'm insane .. or ... desperate 1) www.studiowhiz.com/forums, which I'd just updated and had Invision help fix was hacked for the 3rd straight time last night 2) I'm about to tackle a Invision -> Vanilla port I'm going to do this through a series of scripts 1) import users from invision 2) convert forums to categories 3) filter posts and create discussions 4) convert posts to comments I'm not going to automate these ... I'm going to run them as seperate scripts, they will DUMP any data in the VANILLA files and import all new including ID's (to make matching users and comments easier) I'll then put these files up into the community ... if someone wants to then take these and extend them and write a nice wrapper around it ... please do Fingers crossed I'll have this done ... tonight (if you are a praying person...start praying ... IBF_tables are nasty looking!!)

Jake

IBF is nasty looking anyway, I don't even want to imagine what there tables look like! Good Luck!

Mr K

yeah I can tell you now it's NOT going to be an accurate import! I'm not going to attempt to convert usergroups to roles .. and don't get me started on permissions ha ha

Mr K

Right... I've got it importing users .. (it'll import 1287 users in around 1.17 seconds he he) However, I can't login ... 1) I can find a user 2) I can reset a password 3) it sends details to the user so they can reset passwords 4) I can't log in? The requested username and password combination could not be found. Strange ey ... any thoughts?

Minisweeper

what encryption are IPB passwords?

Jake

Are they MD5?

Mr K

Weee I got it working ... I was leaving the ROLE ID as 0, but it has to be 3 or 4 to login Invision uses a SALT system in their passwords ... and I for one am NOT about to write a MD5 + Salt extraction on this!! So imported users will have to use the FORGOT PASSWORD button ... but it works fine :) Next step ... Forums to Categories

Mr K

Right ... it's now importing the forums and converting them to categories Now ... lets see if I can convert Posts to Comments ... Does anyone know if there is a "resync" script within Vanilla ?? I'd rather do an import then run a script over the database to automatically pull out the firstAuthor and last Author

Minisweeper

resync?

Mr K

okay attempting to import 7000+ topics -> discussions

Mr K

cool .. okay 7289 topics imported & converted to discussions in 4.4 seconds :) weeee I love PHP!! Okay...now to convert posts to comments over 50 000 of these :(

Jake

keep it going!

Mr K

okay this is not going to be clean invision posts include markup tags for quotes, codes and such like ... that Vanilla doesn't So there could be some manual clean up of posts required ...

bigshow

that's what ended the whole data import saga for me. I had too many posts that would need to be hand tweaked to be bothered with it all, so I just did the users. I have a Ruby script for it if anyone is interested.

Toivo

so, how many coffee cups & deadbraincells it takes per one migration, mr.k?

Mr K

ha ha ... well I've had no coffee tonight, but I have had one glass of Sheridons :)

Mr K

WAHOOOO it works ... http://studiowhiz.com/forums/ Now to write a clean up script that runs through and cleans up the Invision BBCode The only extension I have installed is the HTMLFormater ... as when I insterted all the posts .. I flagged them as HTML

Mr K

Oh if you are interested .... 56 000 posts ... took about 52 seconds to import ....

LooZ^

Great job!

Jake

Flippin Heck! Thats good...

c-unit

Charge people money to convert o_0.