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

excel export trac
Ryan Taylor picture Ryan Taylor · Dec 18, 2008 · Viewed 12.7k times · Source

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.

Answer

ANdreaT picture ANdreaT · Jun 30, 2009

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

Related questions

Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More
Export DataTable to Excel File

I have a DataTable with 30+ columns and 6500+ rows.I need to dump the whole DataTable values into an Excel file.Can anyone please help with the C# code.I need each column value to be in a cell.To be …

Read More
Exporting results of a Mysql query to excel?

My requirement is to store the entire results of the query SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) to an Excel file.

Read More