<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>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:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>my @attrs = qw( id
QueueObj->Name Subject Status TimeEstimated TimeWorked TimeLeft Priority
FinalPriority OwnerObj->Name OwnerObj->RealName<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Requestors->UserMembersObj->First->RealName
Requestors->UserMembersObj->First->Organization
Requestors->UserMembersObj->First->Address1<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Requestors->MemberEmailAddressesAsString Cc->MemberEmailAddressesAsString
AdminCc->MemberEmailAddressesAsString<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> DueObj->ISO
ToldObj->ISO CreatedObj->ISO ResolvedObj->ISO LastUpdatedObj->ISO);<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>sme@i-tracing.com<br>
<b>Sent:</b> Wednesday, June 24, 2009 6:55 AM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Customize spreadsheet output?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hello,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I want to use the spreadsheet export with the same columns
as those displayed in the query web result. <o:p></o:p></p>
<p class=MsoNormal>The solution described here (<a
href="http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields">http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields</a>)
is not working with RT 3.8.*<o:p></o:p></p>
<p class=MsoNormal>Does someone have already done a working patch for RT 3.8 ?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks<o:p></o:p></p>
</div>
<p><pre>
******************************************************************
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.
</pre></p>
</body>
</html>