| | 2 | [[PageOutline]] |
| | 3 | |
| | 4 | By means of migrating from other issue-tracking systems, perform some external actions over tickets or simply synchronize different data bases, there are some available tools, plug-ins or scripts which lets you import or up-date tickets into Trac. |
| | 5 | |
| | 6 | Below, follows a collection of some of those. |
| | 7 | |
| | 8 | == !TicketImportPlugin == |
| | 9 | |
| | 10 | [http://trac-hacks.org/wiki/TicketImportPlugin TicketImportPlugin] :: mainly, but not only, this plug-in lets you import or up-date into Trac a series of tickets from a '''CSV file''' or (if the [http://pypi.python.org/pypi/xlrd xlrd library] is installed) from an '''Excel file'''. |
| | 11 | |
| | 12 | == !ExportImportXlsPlugin == |
| | 13 | |
| | 14 | [http://trac-hacks.org/wiki/ExportImportXlsPlugin ExportImportXlsPlugin] :: this plug-in add an admin panel for export and import tickets via '''XLS file'''. |
| | 15 | * It depends on the python packages xlwt/rxld. |
| 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. |
| | 60 | [http://trac-hacks.org/wiki/JiraToTracIntegration JiraToTracIntegration] :: provides tools to import Atlassian Jira backup files into Trac. The plug-in consists of a Python 3.1 commandline tool that: |
| | 61 | - Parses the Jira backup XML file |
| | 62 | - Sends the imported Jira data and attachments to Trac using the [http://trac-hacks.org/wiki/XmlRpcPlugin XmlRpcPlugin] |
| | 63 | - Generates a htpasswd file containing the imported Jira users and their SHA-512 base64 encoded passwords |
| 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 |
| | 79 | [http://trac-hacks.org/wiki/ScarabToTracScript ScarabToTracScript] :: script that migrates Scarab issues to Trac tickets |
| | 80 | * Requires [http://trac-hacks.org/wiki/XmlRpcPlugin XmlRpcPlugin] |
| 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 |
| | 86 | Also, 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. |
| 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) |
| | 92 | === Comma delimited file - CSV === |
| | 93 | See [http://trac.edgewall.org/attachment/wiki/TracSynchronize/csv2trac.2.py 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) |
| | 94 | 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. |