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: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of firstname.lastname@example.org
Sent: Wednesday, June 24, 2009 6:55 AM
Subject: [rt-users] Customize spreadsheet output?
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 ?
PLEASE NOTE: This e-mail and any attachments hereto are
confidential, and may contain proprietary, privileged or legally
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.