| 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. |