Customize spreadsheet view with RT-View-ConciseSpreadsheet

I am trying to configure the spreadsheet export to Excel to show only
the selected fields. How do I get this installed?

Here’s what I tried: installed RT::View::ConciseSpreadsheet via CPAN,
and it also installed some dependencies (Text::CSV_XS, maybe others).
When prompted for my RT.pm, I entered the /opt/rt3/lib path. Restarted
apache. Still it shows every possible field upon export. What else
needs to be done to activate the module?

I don’t see any documentation on the RT wiki for this module, yet.

RT version 3.8.7, SLES 10, perl 5.8.8 i586.

Mark Sallee

RT::View::ConciseSpreadsheet created its own link typically at the bottom of the search results, I think the link is Spreadsheet(Concise).

You can modify your html so the new link replaces the top Spreadsheet link.
I will interested to know if RT::View::ConciseSpreadsheet works out of the box for you, I had to do few fixes in ConciseSpreadsheet/Results.tsv to get it to export ticket numbers and field headers.

Regards;

Roy

Mark Sallee wrote:

RT::View::ConciseSpreadsheet created its own link typically at the
bottom of the search results, I think the link is Spreadsheet(Concise).

You can modify your html so the new link replaces the top Spreadsheet
link.
I will interested to know if RT::View::ConciseSpreadsheet works out of
the box for you, I had to do few fixes in
ConciseSpreadsheet/Results.tsv to get it to export ticket numbers and
field headers.

Regards;

Roy

Roy,
Thank you for pointing out the Concise link at the bottom. It is there
and works. But it is missing column headers other than Subject. Would
you be willing to post the changes you made to Results.tsv? And did you
find a way to customize which columns will be displayed?

Thank you,
Mark Sallee