Skip to content

Instantly share code, notes, and snippets.

@tim-jansen
Created August 18, 2013 19:40
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save tim-jansen/6263586 to your computer and use it in GitHub Desktop.
Save tim-jansen/6263586 to your computer and use it in GitHub Desktop.
Script to bulk import textile files into Confluence Wiki. Very useful to convert a redmine wiki to Confluence. To export redmine wiki pages to textile you can use http://stbuehler.de/blog/article/2011/06/04/exporting_redmine_wiki_pages.html We used this and "https://bitbucket.org/simbtecnologia/github-to-jira" to migrate from github/redmine tool…
"""
Script to import multiple directories with textile files into Confluence Wikis. Can be used with OnDemand instances.
To use as redmine migration tool, you need to export wiki pages in textile format. One way is described in: http://stbuehler.de/blog/article/2011/06/04/exporting_redmine_wiki_pages.html
~/redmine $ RAILS_ENV=production ./script/console -s
def export_text(p)
c = p.content_for_version(nil)
"#{c.text}"
end
def export_wiki(dir, wiki)
dir = dir + "/" + wiki.project.identifier
Dir.mkdir(dir)
wiki.pages.each { |p|File.open(dir + "/" + p.title + ".textile", "w") { |f| f.write(export_text(p)) } }
true
end
Project.all
export_wiki("/tmp", Project.find(2).wiki)
"""
import sys
import os
import re
from xmlrpclib import ServerProxy, Fault
# Connects to confluence server with username and password
site_URL = "https://yoursite.atlassian.net/wiki/"
server = ServerProxy(site_URL + "/rpc/xmlrpc")
username = "confluence_username"
pwd = "confluence_password"
token = server.confluence2.login(username, pwd)
spaces = {
"your_redmine_project_name":"CONFLUENCECODE"
}
def save(space, filename, pagename):
# Retrives text from a file
f = open(filename, 'r')
content = f.readlines()
content = '\n'.join(content[1:])
content = re.subn(r'([{}])',r'\\\1',content, flags=re.S)[0]
content = re.subn(r'@(.*?)@',r'{{\1}}}',content)[0]
content = re.subn(r'<pre>(.*?)</pre>',r'{code}\1{code}',content, flags=re.S)[0]
f.close()
# Creates a new page to insert in the new space from text file content
content = server.confluence2.convertWikiToStorageFormat(token, content)
newpage = {"title":pagename, "space":space, "content":content}
server.confluence2.storePage(token, newpage)
for project_dir, subdirs, files in os.walk('.'):
try:
project_name = project_dir.split('/')[1]
except IndexError:
continue
for filename in files:
if filename[-8:] == '.textile':
pagename = filename[:-8].replace('_',' ').strip()
else:
continue
try:
server.confluence2.getPage(token,spaces[project_name],pagename)
except KeyError:
print "Project %s not mapped" % project_name
break
except Fault:
pass
else:
print "Page %s exists" % pagename
continue
print "Saving page %s"% pagename
save(spaces[project_name], os.path.join(project_dir,filename),pagename)
server.confluence2.logout(token)
@sergeyirl
Copy link

Thanks for the script.
I've extended it a bit to allow attachments conversion.
https://github.com/vile/redmine2confluence-wiki

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment