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