Migrate Redmine Wiki to Confluence?

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.

3 answers

1 accepted

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!

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

Here's a SQL query to fetch Redmine's wiki data:

    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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Statuspage

194 years of downtime: looking back on incident data from 2018

Statuspage customers logged more than 194 years of collective incidents in 2018. That’s a whopping 87% increase from the  104 years logged in 2017 , and we aren’t even through December yet....

56 views 1 5
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you