= Import or update tickets in batch from an Excel or CSV file into Trac = == Description == This plugin lets you import into Trac a series of tickets from an CSV file or (if the [http://pypi.python.org/pypi/xlrd xlrd] library is installed) from an Excel file. 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. 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. Based on the ticket id in the imported file, tickets are either created or updated. It is used by software products development teams daily on several projects in at least three companies. == Installation == For a machine-wide installation, run as root on your machine: * `easy_install http://trac-hacks.org/svn/ticketimportplugin/0.10` for Trac 0.10, or * `easy_install http://trac-hacks.org/svn/ticketimportplugin/0.1`` for Trac 0.11, or For an installation for only one Trac instance (on Trac 0.10, requires the Admin plugin): * Download * [http://trac-hacks.org/attachment/wiki/TicketImportPlugin/TicketImport-0.6-py2.5.egg?format=raw TicketImport-0.6-py2.4.egg] for python 2.4 for Trac 0.10, or * [http://trac-hacks.org/attachment/wiki/TicketImportPlugin/TicketImport-0.6-py2.4.egg?format=raw TicketImport-0.6-py2.5.egg] for Python 2.5 for Trac 0.10, or * [http://trac-hacks.org/attachment/wiki/TicketImportPlugin/TicketImport-0.6-py2.4.egg?format=raw TicketImport-0.7-py2.4.egg] for Python 2.4 for Trac 0.11, or * [http://trac-hacks.org/attachment/wiki/TicketImportPlugin/TicketImport-0.6-py2.4.egg?format=raw TicketImport-0.7-py2.5.egg] for Python 2.5 for Trac 0.11 * Install using the Admin UI in Trac. == Bugs/Feature Requests == This plugin has been tested extensively on Trac 0.11, and a little on Trac 0.10. Please report any issue ! Existing bugs and feature requests for TicketImportPlugin are [report:9?COMPONENT=TicketImportPlugin here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=TicketImportPlugin&owner=farialima new ticket]. == Download == Download the zipped source from [download:ticketimportplugin here]. == Source == You can check out TicketImportPlugin from [http://trac-hacks.org/svn/ticketimportplugin here] using Subversion, or [source:ticketimportplugin browse the source] with Trac. == Example == Once you have enabled the plugin and given yourself IMPORT_EXECUTE permission, you will see a new '''Import''' tab in the main navigation. This tab contains a complete documentation on exactly how the import works, as well as a form to select the CSV or XLS file to upload: [[Image(import-wizard.png,width=300)]] Once you have uploaded it, a preview screen shows you what will be imported and let you confirm the import. == Recent Changes == [[ChangeLog(ticketimportplugin, 3)]] == Author/Contributors == '''Author:''' [wiki:farialima] [[BR]] '''Contributors:'''