|   | 1 | = Importing ticket data =  | 
                  
                          |   | 2 |   | 
                  
                          |   | 3 | == Bugzilla ==  | 
                  
                          |   | 4 |   | 
                  
                          |   | 5 | Ticket data can be imported from Bugzilla using the [http://trac.edgewall.org/browser/trunk/contrib/bugzilla2trac.py bugzilla2trac.py] script, available in the contrib/ directory of the Trac distribution.  | 
                  
                          |   | 6 |   | 
                  
                          |   | 7 | {{{  | 
                  
                          |   | 8 | $ bugzilla2trac.py  | 
                  
                          |   | 9 | bugzilla2trac - Imports a bug database from Bugzilla into Trac.  | 
                  
                          |   | 10 |   | 
                  
                          |   | 11 | Usage: bugzilla2trac.py [options]  | 
                  
                          |   | 12 |   | 
                  
                          |   | 13 | Available Options:  | 
                  
                          |   | 14 |   --db <MySQL dbname>              - Bugzilla's database  | 
                  
                          |   | 15 |   --tracenv /path/to/trac/env      - full path to Trac db environment  | 
                  
                          |   | 16 |   -h | --host <MySQL hostname>     - Bugzilla's DNS host name  | 
                  
                          |   | 17 |   -u | --user <MySQL username>     - effective Bugzilla's database user  | 
                  
                          |   | 18 |   -p | --passwd <MySQL password>   - Bugzilla's user password  | 
                  
                          |   | 19 |   -c | --clean                     - remove current Trac tickets before importing  | 
                  
                          |   | 20 |   --help | help                    - this help info  | 
                  
                          |   | 21 |   | 
                  
                          |   | 22 | Additional configuration options can be defined directly in the script.  | 
                  
                          |   | 23 | }}}  | 
                  
                          |   | 24 |   | 
                  
                          |   | 25 | Currently, the following data is imported from Bugzilla:  | 
                  
                          |   | 26 |   | 
                  
                          |   | 27 |   * bugs  | 
                  
                          |   | 28 |   * bug activity (field changes)  | 
                  
                          |   | 29 |   * bug attachments  | 
                  
                          |   | 30 |   * user names and passwords (put into a htpasswd file)  | 
                  
                          |   | 31 |   | 
                  
                          |   | 32 | The script provides a number of features to ease the conversion, such as:  | 
                  
                          |   | 33 |   | 
                  
                          |   | 34 |   * PRODUCT_KEYWORDS:  Trac doesn't have the concept of products, so the script provides the ability to attach a ticket keyword instead.  | 
                  
                          |   | 35 |   | 
                  
                          |   | 36 |   * IGNORE_COMMENTS:  Don't import Bugzilla comments that match a certain regexp.  | 
                  
                          |   | 37 |   | 
                  
                          |   | 38 |   * STATUS_KEYWORDS:  Attach ticket keywords for the Bugzilla statuses not available in Trac.  By default, the 'VERIFIED' and 'RELEASED' Bugzilla statuses are translated into Trac keywords.  | 
                  
                          |   | 39 |   | 
                  
                          |   | 40 | For more details on the available options, see the configuration section at the top of the script.  | 
                  
                          |   | 41 |   | 
                  
                          |   | 42 | == Sourceforge ==  | 
                  
                          |   | 43 |   | 
                  
                          |   | 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 | == Mantis ==  | 
                  
                          |   | 47 |   | 
                  
                          |   | 48 | NB! The mantis2trac script now lives at http://trac-hacks.org/wiki/MantisImportScript . You can always get the latest version from http://trac-hacks.org/changeset/latest/mantisimportscript?old_path=/&filename=mantisimportscript&format=zip  | 
                  
                          |   | 49 |   | 
                  
                          |   | 50 | Mantis bugs can be imported using the attached script.  | 
                  
                          |   | 51 |   | 
                  
                          |   | 52 | Currently, the following data is imported from Mantis:  | 
                  
                          |   | 53 |   * bugs  | 
                  
                          |   | 54 |   * bug comments  | 
                  
                          |   | 55 |   * bug activity (field changes)  | 
                  
                          |   | 56 |   * attachments (as long as the files live in the mantis db, not on the filesystem)   | 
                  
                          |   | 57 |   | 
                  
                          |   | 58 | If you use the script, please read the NOTES section (at the top of the file) and make sure you adjust the config parameters for your environment.  | 
                  
                          |   | 59 |   | 
                  
                          |   | 60 | mantis2trac.py has the same parameters as the bugzilla2trac.py script:  | 
                  
                          |   | 61 | {{{  | 
                  
                          |   | 62 | mantis2trac - Imports a bug database from Mantis into Trac.  | 
                  
                          |   | 63 |   | 
                  
                          |   | 64 | Usage: mantis2trac.py [options]   | 
                  
                          |   | 65 |   | 
                  
                          |   | 66 | Available Options:  | 
                  
                          |   | 67 |   --db <MySQL dbname>              - Mantis database  | 
                  
                          |   | 68 |   --tracenv /path/to/trac/env      - Full path to Trac db environment  | 
                  
                          |   | 69 |   -h | --host <MySQL hostname>     - Mantis DNS host name  | 
                  
                          |   | 70 |   -u | --user <MySQL username>     - Effective Mantis database user  | 
                  
                          |   | 71 |   -p | --passwd <MySQL password>   - Mantis database user password  | 
                  
                          |   | 72 |   -c | --clean                     - Remove current Trac tickets before importing  | 
                  
                          |   | 73 |   --help | help                    - This help info  | 
                  
                          |   | 74 |   | 
                  
                          |   | 75 | Additional configuration options can be defined directly in the script.  | 
                  
                          |   | 76 | }}}   | 
                  
                          |   | 77 |   | 
                  
                          |   | 78 | == Other ==  | 
                  
                          |   | 79 |   | 
                  
                          |   | 80 | Since trac uses a SQL database to store the data, you can import from other systems by examining the database tables. Just go into [http://www.sqlite.org/sqlite.html sqlite] command line to look at the tables and import into them from your application.  | 
                  
                          |   | 81 |   | 
                  
                          |   | 82 | === Using a comma delimited file - CSV ===  | 
                  
                          |   | 83 | 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)  | 
                  
                          |   | 84 |   |