Blog Documentation Book a Demo

Invision Power Board to Vanilla

Mr KMr K
edited July 2006 in Vanilla 1.0 Help
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!!)
«1

Comments

  • JakeJake
    IBF is nasty looking anyway, I don't even want to imagine what there tables look like! Good Luck!
  • Mr KMr 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 KMr 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?
  • MinisweeperMinisweeper New
    what encryption are IPB passwords?
  • JakeJake
    Are they MD5?
  • Mr KMr 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 KMr 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
  • MinisweeperMinisweeper New
    resync?
  • Mr KMr K
    okay attempting to import 7000+ topics -> discussions
  • Mr KMr 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 :(
  • JakeJake
    keep it going!
  • Mr KMr 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 ...
  • bigshowbigshow
    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.
  • ToivoToivo New
    edited July 2006
    so, how many coffee cups & deadbraincells it takes per one migration, mr.k?
  • Mr KMr K
    ha ha ... well I've had no coffee tonight, but I have had one glass of Sheridons :)
  • Mr KMr 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 KMr K
    Oh if you are interested .... 56 000 posts ... took about 52 seconds to import ....
  • LooZ^LooZ^
    Great job! :)
  • JakeJake
    Flippin Heck! Thats good...
  • c-unitc-unit
    Charge people money to convert o_0.
This discussion has been closed.