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