| 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. |
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 | | |
| 96 | ---- |
| 97 | See also: |
| 98 | * to import/export wiki pages: TracAdmin, |
| 99 | * to export tickets: TracTickets, TracQuery |