I have a Redmine setup that I'd like to migrate to an Atlassian platform. I've seen a few leads on how to migrate Redmine issues into JIRA, but I've not seen anything on migrating Redmine wiki content to Confluence. The only relevant tool seems to be the much-vaunted Universal Wiki Converter which appears to not exist at every possible download location for no apparent reason.
Does anyone know if there's a working tool for this somewhere? Redmine doesn't seem to be very export-friendly, so I'd guess it would either be a DB dump or a script to export each wiki page in turn, and then a conversion to a Confluence-friendly format.
If such a thing doesn't exist, I guess I'll have a go at writing one.
How many pages are we talking about? Before I started at Atlassian I was also using Redmine but went to Confluence as well. I ran into the same problems, UWC wasn't very helpful as Redmine is very unfriendly about exporting data. Therefore I eventually just went ahead copied the content manually. Taxing, but it worked. Another thing you can do is creating a small script that accesses the Redmine db and exports pages to plain html files. From that point on out, you can use this script to insert the html data: HTML To Confluence Converter
Also, check out this page: Importing Content Into Confluence
Hi Dennis, I'll give that a look, thanks. It's really not too many pages (about 100, not all critical), but it strikes me as odd that such an obvious conversion (anyone who's used both Redmine and Confluence would want to upgrade ASAP!) isn't blidningly easy, particularly that Atlassian hasn't made it so themselves. Plus I enjoy data conversion in a perverse kind of way, so it'd be a nice problem to solve for others out there.
At the end of the day, this is what I did because everything else was too hard. Even writing a script to crawl over all the URLs was a pain because Redmine (or at least HostedRedmine) either had IFrames or required authentication or something, I can't even remember. Hopefully someone else will sort it out one day! It's certainly the major competitor to JIRA/Confluence at my university, so weening a few students off the inferior product could lead to a few sales after graduation!
Here's a SQL query to fetch Redmine's wiki data:
SELECT wiki_pages.id AS page_id, wiki_pages.parent_id AS parent_page_id, wiki_pages.title AS page_name, wiki_contents.text AS page_content, users.login AS author, projects.identifier AS project_key, projects.name AS project_name FROM wiki_pages LEFT JOIN wiki_contents ON wiki_contents.page_id = wiki_pages.id LEFT JOIN users ON wiki_contents.author_id = users.id LEFT JOIN wikis ON wiki_pages.wiki_id = wikis.id LEFT JOIN projects ON wikis.project_id = projects.id ORDER BY page_id ASC;
I hope this will help someone. Now you need to create a simple script using, for example https://bobswift.atlassian.net/wiki/display/CSOAP/Documentation
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot