Do us a favour and type the exact title of this discussion into a topic search. Let us know what it comes up with cause I'm pretty sure if you cant find the migrator then the search function is broken.
thanks i searched about 20 different terms and even + zip and nothing turned up. i'm pretty good at research but this is difficult. its no where to download in the add-ons either.
Is it really that hard to find? When just filling in phpbb migrator and clicking search (so you get topic search), three discussions come up. This one, one about errors, and finally one called [v0.2] phpBB Migrator which is the main discussion about the migrator, with the download link posted several times, for instance here. Doing a comment search for phpbb migrator zip returns links as well.
Edit your first and last post in the migrator thread and add a download link there? TBH it's a bit hidden since it's neither on the first nor the last page there. Still, people should be able to find it now with another thread devoted to the migrator ;)
The development of the phpBB migrator seems to be as good as dried up to me. I recently migrated a phpBB forum to vanilla using a modified version of the 0.2 migrator.
I would still like to clean up the code and there are some small bugs left that I only figured out after the migration. However if nobody is maintaining it anymore, I would be happy to fix all of this and post a new version.
You're more than welcome to make an updated version of the migrator. And if you need any help during the process I'm sure there are enough of us who are willing to come with suggestions! :)
I must say I'm also more than happy for you to patch up the migrator and release a fixed up version of it. I really started it as a project to refresh myself because it was such an in demand script. I'll be first to admit it's not the tidiest or most efficient code and it's reached a point with bbcode issues and whatnot that it's a bit above my lazy level. As bjrn says though, if you need a hand with anything or working out why i've done it a certain way i'll try and point you in the right direction...
Just to let everyone know that I'm looking into releasing my updated code. I'm busy with some other stuff at the moment, I hope to release an updated version somewhere next week.
Just a heads up on what is coming: * Fixed some bugs in Minisweeper's original code. * Added support for Attachments (migration from PHPBB extension to Vanilla Add On - optional). * Added some initial support to populate the tables of the Discussion Tags extension (based on reg-exp parsing).
Minisweeper, if you like I can send you my code and you can merge it into yours.
If you're happy to take over the extension in general then feel free to just upload it to the Addons site. Mine never made it on there but there is at least one other migrator on there that i'm aware of so I dont see why you shouldnt :)
* Added support for Attachments (migration from PHPBB extension to Vanilla Add On - optional).
Hi Mvhaen, I transferred my tables from phpBB -> Vanilla a while ago but would it be possible to go back and just add the old attachments from my phpBB database?
miss-one, this shouldn't be a problem. They are completely seperate tables and if you did not remove the phpbb columns that the migrator adds to the vanilla tables then you should be OK, and even if you did that it should be possible to migrate them with some additional effort.
It contains the following new features features: * Vanilla 1.1.2 Compatibility * Fixed some bugs in Minisweeper's original code. * Slightly improved BBCode migration (most compatible with the 'BBCodeParser' Add On, 'Better BB Code' has some problems). * Added support for Attachments (migration from PHPBB extension to Vanilla Add On - optional). And yes, attachments can be migrated whenever you want, just as long as you did not remove the phpbb entries added to the LUM tables. * Added some initial support to populate the tables of the Discussion Tags extension (based on reg-exp parsing).
Note that I added a query at the bottom of comments.php to update the firstCommentId field of the Discussion table. firstCommentId is first set to the phpbb-id in discussions.php and we need to fix this afterwards If this is not done then you will not be able to modify the topic titles anymore. I did this operation manually for my database a while back and I've just written this code without testing it so please give me some feedback on this. Additionally since the phpBBpostid in the Post table is set to -1 and this id never occurs, this query is also safe if you want to fix an older migration.
TODO: better migration of the BBCode.
I'll wait for comments and bugs before posting this as an add-on.
Also, I gather I'm supposed to have the same MySQL database for both my old phpBB and my new Vanilla boards? I don't - the Vanilla information is in a different database. Is it possible to transfer the old phpBB data into my new MySQL database, and then run this migrator? Thanks!
Assuming it's not changed too radically from the one I wrote, you use it by uploading the files it contains to any dir on your web server, browsing to that dir, and running through the links in order to migrate your data.
You can move the data from one database to another by using phpmyadmin or something to dump the data from one db then import it to another. That should be a fairly easy process in a mysql manager (phpmyadmin) and there are instructions how to do it on the web if you do a quick search..
Hope it is welcome, but I made some tweaks to the migrator script and thought I would share them.
Some of the sql was malformed for me, backticked values, single instead of doublequote. Fixing that made it run for me, and add the ability to import categories, forums and discussions with apostrophe's in their title (something that chokes v0.3).
I also added a proper prefix variable, so you only need to set your value at the top, and all references to your database tables will use that appropriate prefix (one for phpbb, one for vanilla). For my personal installation, the time execution calls at the bottom were causing errors. Sadly, instead of looking into this, I simple commented the code out. It serves no purpose though it adds a nice feedback to the user. The attachments and tag files were left untouched, because I never used those mods.
Anyway, with this snap of code I was successfully able to merge my phpbb2 database.