convert Trac tickets to Github issues
Tratihubis converts Trac tickets to Github issues by using the following steps:
- The user manually exports the Trac tickets to convert to a CSV file.
- Tratihubis reads the CSV file and uses the data to create Github issues and milestones.
To install tratihubis, use pip or easy_install:
$ pip install tratihubis
If needed, this also installs the PyGithub package.
Information about Trac tickets to convert has to be provided in a CSV file. To obtain this CSV file, create a new Trac queries using the SQL statement stored in query_tickets.sql and query_comments.sql. Then execute the queries and save the results by clicking “Download in other formats: Comma-delimited Text” and choosing for example /Users/me/mytool/tickets.csv and /Users/me/mytool/comments.csv as output files.
Next create a config file to describe how to login to Github and what to convert. For example, you could store the following in ~/mytool/tratihubis.cfg:
[tratihubis] user = someone password = secret repo = mytool tickets = /Users/me/mytool/tickets.csv comments = /Users/me/mytool/comments.csv
$ tratihubis ~/mytool/tratihubis.cfg
This tests that the input data and Github information is valid and writes a log to the console describing which operations would be performed.
To actually create the Github issues, you need to enable to command line option --really:
$ tratihubis --really ~/mytool/tratihubis.cfg
Be aware that Github issues and milestones cannot be deleted in case you mess up. Your only remedy is to remove the whole repository and start anew. So make sure that tratihubis does what you want before you enable --really.
In case the Trac users have different user names on Github, you can specify a mapping. For example:
users = johndoe: jdoe78, *: me
This would map the Trac user johndoe to the Github user jdoe78 and everyone else to the user me. The default value is:
users = *:*
This maps every Trac user to a Github user with the same name.
Github labels somewhat mimic the functionality Trac stores in the type and resolution field of tickets. By default, Github supports the following labels:
Trac on the other hand has a type field which by default can be:
Furthermore closed Trac tickets have a resolution which, among others, can be:
The labels config option allows to map Trac fields to Github labels. For example:
labels = type=defect: bug, type=enhancement: enhancement, resolution=wontfix: wontfix
Here, labels is a comma separated list of mappings taking the form <trac-field>=<trac-value>:<github-label>.
In case types or labels contain other characters than ASCII letters, digits and underscore (_), put them between quotes:
labels = type="software defect": bug
The author of Github issues and comments always is the user specified in the config, even if a different user opened the original Trac ticket or wrote the original Trac comment.
Github issues and comments have the current time as time stamp instead if time from Trac.
Github issue descriptions contains the raw Trac Wiki markup, there is no translation to Github markdown.
The due date of Trac milestones is not migrated to Github milestones, so when the conversion is done, you have to set it manually.
Trac Milestone without any tickets are not converted to Github milestone.
In case of questions and problems, open an issue at <https://github.com/roskakori/tratihubis/issues>.
To obtain the source code or create your own fork to implement fixes or improvements, visit <https://github.com/roskakori/tratihubis>.
Copyright (c) 2012, Thomas Aglassinger. All rights reserved. Distributed under the BSD License.
Version 0.4, 2012-05-04
- Added config option labels to map Trac status and resolution to Github labels.
Version 0.3, 2012-05-03
- Added config option comments to convert Trac ticket comments.
- Added closing of issue for which the corresponding Trac ticket has been closed already.
- Added validation of users issues are assigned to. They must have an active Github user.
Version 0.2, 2012-05-02
- Added config option users to map Trac users to Github users.
- Added binary in order to run tratihubis instead of python -m tratihubis.
- Changed supposed issue number in log to take existing issues in account.
Version 0.1, 2012-05-01
- Initial release.