Customize spreadsheet output?

Some managers at my site would like to use RT (3.4.2) to create some
metrics. However, the spreadsheet output (the link at the bottom of
query results) appears to have the same fields every time, regardless of
the format specification of the original query.

This is odd, since RT definitely passes the format specifier to the
spreadsheet module, but it seems to ignore it.

Does anyone have a canned solution to this problem?

Rick Russell
For computer help, call xHELP (x4357 or 713-348-4357)
OpenPGP/GnuPG Public Key at ldap://certificate.rice.edu
761D 1C20 6428 580F BD98 F5E5 5C8C 56CA C7CB B669
Helpdesk Supervisor, Client Services
IT/Academic & Research Computing
Rice University
Voice: 713.348.5267 Fax: 713.348.6099

At Friday 6/10/2005 01:25 PM, Rick Russell wrote:

Some managers at my site would like to use RT (3.4.2) to create some
metrics. However, the spreadsheet output (the link at the bottom of
query results) appears to have the same fields every time, regardless of
the format specification of the original query.

This is odd, since RT definitely passes the format specifier to the
spreadsheet module, but it seems to ignore it.

Does anyone have a canned solution to this problem?

Yes - we developed a download that downloads the displayed fields. I’ll try
to post something on the wiki in the next few days.

There is a slight glitch with our solution that shows on some, but not all,
of our RT instances - it’s possible to work around it, but perhaps if I
share it someone can figure out the problem.

Steve

Sounds great. Fortunately we only have one RT instance…

Rick R.

At Friday 6/10/2005 01:43 PM, Rick Russell wrote:

Sounds great. Fortunately we only have one RT instance…

That means you have a 50% chance of it working right!

Steve

At Friday 6/10/2005 01:25 PM, Rick Russell wrote:

Some managers at my site would like to use RT (3.4.2) to create some
metrics. However, the spreadsheet output (the link at the bottom of
query results) appears to have the same fields every time, regardless of
the format specification of the original query.

This is odd, since RT definitely passes the format specifier to the
spreadsheet module, but it seems to ignore it.

Does anyone have a canned solution to this problem?

I’ve posted our solution at:

http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields

Steve

Hello,

I want to use the spreadsheet export with the same columns as those
displayed in the query web result.

The solution described here
(http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields) is not
working with RT 3.8.*

Does someone have already done a working patch for RT 3.8 ?

Thanks

Hello,

I want to use the spreadsheet export with the same columns as those
displayed in the query web result.

The solution described here
(http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields) is not
working with RT 3.8.*

Does someone have already done a working patch for RT 3.8 ?

http://search.cpan.org/~jesse/RT-View-ConciseSpreadsheet-0.002/ is worth
trying

Hi,

in 3.8.2, 3.8.3 and 3.8.4 I used this extension:

http://search.cpan.org/~elacour/RT-Extension-SearchResults-XLS-0.05/

Z.

Sébastien Mesnard wrote:

Hello,

I want to use the spreadsheet export with the same columns as those
displayed in the query web result.

The solution described here
(http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields) is
not
working with RT 3.8.*

Does someone have already done a working patch for RT 3.8 ?

Thanks


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

View this message in context: http://www.nabble.com/Customize-spreadsheet-output--tp24182660p24206611.html

I have gone through and added extra columns to the spreadsheet by just updating /share/html/Search/Results.tsv. It took some testing to get the right fields down but it was a simple edit. This is what I currently have:

my @attrs = qw( id QueueObj->Name Subject Status TimeEstimated TimeWorked TimeLeft Priority FinalPriority OwnerObj->Name OwnerObj->RealName
Requestors->UserMembersObj->First->RealName Requestors->UserMembersObj->First->Organization Requestors->UserMembersObj->First->Address1
Requestors->MemberEmailAddressesAsString Cc->MemberEmailAddressesAsString AdminCc->MemberEmailAddressesAsString
DueObj->ISO ToldObj->ISO CreatedObj->ISO ResolvedObj->ISO LastUpdatedObj->ISO);From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of sme@i-tracing.com
Sent: Wednesday, June 24, 2009 6:55 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Customize spreadsheet output?

Hello,

I want to use the spreadsheet export with the same columns as those displayed in the query web result.
The solution described here (http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields) is not working with RT 3.8.*
Does someone have already done a working patch for RT 3.8 ?

Thanks

PLEASE NOTE: This e-mail and any attachments hereto are
confidential, and may contain proprietary, privileged or legally
protected information.
If you are not the intended recipient, please delete this email
and all attachments without making copies and notify the sender
by telephone or e-mail.
E-mail transmissions are inherently subject to disruption,
corruption, late or incomplete delivery, and viruses.
The sender does not accept responsibility for any errors,
omissions or other consequences resulting from the transmission
of this e-mail.
This notice applies to all TerpSys e-mails and attachments
appearing in all e-mail strings containing the message to which
this notice is appended.