wiki:ExportImportXlsPlugin

Import/Export XLS spreadsheets

Description

This plugin adds an admin panel to allow the export and import of Trac tickets using an Excel spreadsheet, ie in xls format. The dependencies are the Python packages xlwt and xlrd.

The plugin is designed to export a ticket list into an Excel file and import the tickets back into the same Trac environment. This Excel file can be modified, but the columns Id and summary must be maintained. To add new tickets, the Id column must stay empty.

See also: TicketImportPlugin

Bugs/Feature Requests

Existing bugs and feature requests for ExportImportXlsPlugin are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out ExportImportXlsPlugin from here using Subversion, or browse the source with Trac.

Screenshots

Admin page.

Feedback

Are you using Import/Export XLS plugin?
  • Yes, it's usefull. (ben_12)
  • No, it's useless.
  • No, I don't need it.
  • I think it will help

  • You don't have permission to vote. You may need to login.

Known issues

Ticket Summary Status Owner Type Priority Severity
#11426 Import if column label equals column translation new ben_12 defect normal normal

Recent Changes

[13359] by ben_12 on 2013-08-21 14:46:03
Set excel cell number format to "@" for text and longtext.
So, if the excel file has been edited, the text cells with number characters are not imported as number (ex: "12" text is imported as "12" and not as "12.0").
[13231] by ben_12 on 2013-05-24 10:51:17
Sorting fields by weight.
[12648] by ben_12 on 2013-02-22 11:05:34
refs #10887 : fix for list field in Trac 1.0. Trac does not accept None value, but return None for old value or default value?

Author/Contributors

Author: ben_12
Maintainer: ben_12
Contributors:

Last modified 7 weeks ago Last modified on Mar 4, 2015, 7:02:52 PM

Attachments (1)

Download all attachments as: .zip