Migrate Redmine Wiki to Confluence?

[Oliver Lade]

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.

[Dennis Kromhout van der Meer · Accepted solution]

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

[Oliver Lade]

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.

[Oliver Lade]

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!

[Sergey Sobolev]

I hope this script would be able to help others https://github.com/vile/redmine2confluence-wiki

That is something we come up with to migrate our redmine wiki into confluence

[Matt Harasymczuk]

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