| 1 | = Importing ticket data = |
| 2 | |
| 3 | == Bugzilla == |
| 4 | |
| 5 | Ticket data can be imported from Bugzilla using the [http://trac.edgewall.org/browser/trunk/contrib/bugzilla2trac.py bugzilla2trac.py] script, available in the contrib/ directory of the Trac distribution. |
| 6 | |
| 7 | {{{ |
| 8 | $ bugzilla2trac.py |
| 9 | bugzilla2trac - Imports a bug database from Bugzilla into Trac. |
| 10 | |
| 11 | Usage: bugzilla2trac.py [options] |
| 12 | |
| 13 | Available Options: |
| 14 | --db <MySQL dbname> - Bugzilla's database |
| 15 | --tracenv /path/to/trac/env - full path to Trac db environment |
| 16 | -h | --host <MySQL hostname> - Bugzilla's DNS host name |
| 17 | -u | --user <MySQL username> - effective Bugzilla's database user |
| 18 | -p | --passwd <MySQL password> - Bugzilla's user password |
| 19 | -c | --clean - remove current Trac tickets before importing |
| 20 | --help | help - this help info |
| 21 | |
| 22 | Additional configuration options can be defined directly in the script. |
| 23 | }}} |
| 24 | |
| 25 | Currently, the following data is imported from Bugzilla: |
| 26 | |
| 27 | * bugs |
| 28 | * bug activity (field changes) |
| 29 | * bug attachments |
| 30 | * user names and passwords (put into a htpasswd file) |
| 31 | |
| 32 | The script provides a number of features to ease the conversion, such as: |
| 33 | |
| 34 | * PRODUCT_KEYWORDS: Trac doesn't have the concept of products, so the script provides the ability to attach a ticket keyword instead. |
| 35 | |
| 36 | * IGNORE_COMMENTS: Don't import Bugzilla comments that match a certain regexp. |
| 37 | |
| 38 | * STATUS_KEYWORDS: Attach ticket keywords for the Bugzilla statuses not available in Trac. By default, the 'VERIFIED' and 'RELEASED' Bugzilla statuses are translated into Trac keywords. |
| 39 | |
| 40 | For more details on the available options, see the configuration section at the top of the script. |
| 41 | |
| 42 | == Sourceforge == |
| 43 | |
| 44 | Ticket data can be imported from Sourceforge using the [http://trac.edgewall.org/browser/trunk/contrib/sourceforge2trac.py sourceforge2trac.py] script, available in the contrib/ directory of the Trac distribution. |
| 45 | |
| 46 | See #Trac3521 for an updated sourceforge2trac script. |
| 47 | |
| 48 | == Mantis == |
| 49 | |
| 50 | The mantis2trac script now lives at http://trac-hacks.org/wiki/MantisImportScript. You can always get the latest version from http://trac-hacks.org/changeset/latest/mantisimportscript?old_path=/&filename=mantisimportscript&format=zip |
| 51 | |
| 52 | Mantis bugs can be imported using the attached script. |
| 53 | |
| 54 | Currently, the following data is imported from Mantis: |
| 55 | * bugs |
| 56 | * bug comments |
| 57 | * bug activity (field changes) |
| 58 | * attachments (as long as the files live in the mantis db, not on the filesystem) |
| 59 | |
| 60 | If you use the script, please read the NOTES section (at the top of the file) and make sure you adjust the config parameters for your environment. |
| 61 | |
| 62 | mantis2trac.py has the same parameters as the bugzilla2trac.py script: |
| 63 | {{{ |
| 64 | mantis2trac - Imports a bug database from Mantis into Trac. |
| 65 | |
| 66 | Usage: mantis2trac.py [options] |
| 67 | |
| 68 | Available Options: |
| 69 | --db <MySQL dbname> - Mantis database |
| 70 | --tracenv /path/to/trac/env - Full path to Trac db environment |
| 71 | -h | --host <MySQL hostname> - Mantis DNS host name |
| 72 | -u | --user <MySQL username> - Effective Mantis database user |
| 73 | -p | --passwd <MySQL password> - Mantis database user password |
| 74 | -c | --clean - Remove current Trac tickets before importing |
| 75 | --help | help - This help info |
| 76 | |
| 77 | Additional configuration options can be defined directly in the script. |
| 78 | }}} |
| 79 | |
| 80 | == Jira == |
| 81 | |
| 82 | The [http://trac-hacks.org/wiki/JiraToTracIntegration Jira2Trac plugin] provides you with tools to import Atlassian Jira backup files into Trac. |
| 83 | |
| 84 | The plugin consists of a Python 3.1 commandline tool that: |
| 85 | |
| 86 | - Parses the Jira backup XML file |
| 87 | - Sends the imported Jira data and attachments to Trac using the [http://trac-hacks.org/wiki/XmlRpcPlugin XmlRpcPlugin] |
| 88 | - Generates a htpasswd file containing the imported Jira users and their SHA-512 base64 encoded passwords |
| 89 | |
| 90 | == Other == |
| 91 | |
| 92 | Since trac uses a SQL database to store the data, you can import from other systems by examining the database tables. Just go into [http://www.sqlite.org/sqlite.html sqlite] command line to look at the tables and import into them from your application. |
| 93 | |
| 94 | === Using a comma delimited file - CSV === |
| 95 | See [http://trac.edgewall.org/attachment/wiki/TracSynchronize/csv2trac.2.py] for details. This approach is particularly useful if one needs to enter a large number of tickets by hand. (note that the ticket type type field, (task etc...) is also needed for this script to work with more recent Trac releases) |
| 96 | Comments on script: The script has an error on line 168, ('Ticket' needs to be 'ticket'). Also, the listed values for severity and priority are swapped. |
| 97 | |
| 98 | === Using an Excel (.xls) or comma delimited file (.csv) === |
| 99 | This plugin http://trac-hacks.org/wiki/TicketImportPlugin lets you import into Trac a series of tickets from a CSV file or (if the xlrd library is installed) from an Excel file. |
| 100 | |
| 101 | You can also use it to modify tickets in batch, by saving a report as CSV, editing the CSV file, and re-importing the tickets. |
| 102 | |
| 103 | This plugin is very useful when starting a new project: you can import a list of requirements that may have come from meeting notes, list of features, other ticketing systems... It's also great to review the tickets off-line, or to do massive changes to tickets. |
| 104 | |
| 105 | Based on the ticket id (or, if no id exists, on the summary) in the imported file, tickets are either created or updated. |
| 106 | |
| 107 | |