How do I export Trac tickets to MS Excel including the ticket description, with formatting?

Question

I need to be able to export Trac tickets from a report or custom query to Excel, including the ticket description. The catch is that the description must be formatted as defined by the wiki syntax rather than displaying the raw text.

Solution 1

Unfortunately, it does not appear possible export the tickets to MS Excel, including proper formatting of the ticket description. This appears to be more of a limitation with Excel (HTML formatting w/in a cell) than with Trac itself.

Solution 2

you can just go to "View Tickets" and chose "Custom Query" there you select all the columns you want to see. There will not be a "Description" column, cause it could be wiki formatted, therefore it is available only as a "row" option. But you can still edit the query manually, and add a: &col=description in it, so you will have the description "unformatted" as a table column.

Than chose download as Comma Delimited Text, and open it in Excel ;-)

HTH

Solution 3

I've had the same issue. I've tried ExcelExportPlugin, but it is not better than exporting in CSV. In particular, it doesn't format the "description".

I've had better luck saving the whole HTML report, isolating the html table, and importing it as html file in Excel : It keeps well all the formatting.

Hope this helps.

Solution 4

I had good success with the technique offered by ANdreaT above. The only addition I would make is just to highlight that you aren't able to reach the point where you can add the "&col=description" to the query is after you have clicked on the "Save Query" button at the bottom of your existing report.

Hope that saves you the few minutes that it cost me.

View more solutions

Comments

[Ryan Taylor]

I tried this too, unfortunately it was not able to handle importing bulleted lists or images well. It seems complex formatting is not well supported inside a single cell.

[Justin T Conroy]

To modify the query and add &col=description to it, you'll have to use the "Save Query" button at the bottom of the page.