Spreadsheet / Export columns

RT Users
1

I can’t seem to find the template/settings that control the output columns
for the spreadsheet for search???

Anyone ???

smime.p7s (3.28 KB)

2

I can’t seem to find the template/settings that control the output columns
for the spreadsheet for search???
It exports everything; not that hard to remove columns once downloaded.
Otherwise, see the wiki for a patch to limit the dump to what you have
displayed.

Cambridge Energy Alliance: Save money. Save the planet.

3

That is what I thought. However, my install is limiting the columns shown.
I only see:

id Queue Subject Status TimeEstimated TimeWorked TimeLeft
Priority FinalPriority Owner Requestors Cc AdminCc Due
Told Created Resolved LastUpdated

I need additional columns…

I am sure I can figure this out, just thought it may be a quick solution…-----Original Message-----
From: Jerrad Pierce [mailto:jpierce@cambridgeenergyalliance.org]
Sent: Tuesday, August 18, 2009 11:12 AM
To: Joel Hartshorn
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Spreadsheet / Export columns

On Tue, Aug 18, 2009 at 14:06, Joel Hartshornjhartshorn@seattletimes.com wrote:

I can’t seem to find the template/settings that control the output
columns for the spreadsheet for search???
It exports everything; not that hard to remove columns once downloaded.
Otherwise, see the wiki for a patch to limit the dump to what you have
displayed.

Cambridge Energy Alliance: Save money. Save the planet.

smime.p7s (3.28 KB)

4

That is what I thought. However, my install is limiting the columns shown.
I only see:

id Queue Subject Status TimeEstimated TimeWorked TimeLeft
Priority FinalPriority Owner Requestors Cc AdminCc Due
Told Created Resolved LastUpdated
Umm, that’s all there is, other than any custom fields you might have added.

Cambridge Energy Alliance: Save money. Save the planet.

5

Is there a way to insert user’s real names into the search spreadsheet?

Nathan Hurt-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jerrad Pierce
Sent: Tuesday, August 18, 2009 2:12 PM
To: Joel Hartshorn
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Spreadsheet / Export columns

On Tue, Aug 18, 2009 at 14:06, Joel Hartshornjhartshorn@seattletimes.com wrote:

I can’t seem to find the template/settings that control the output columns
for the spreadsheet for search???
It exports everything; not that hard to remove columns once downloaded.
Otherwise, see the wiki for a patch to limit the dump to what you have
displayed.

Cambridge Energy Alliance: Save money. Save the planet.
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

Check out the Barracuda Spam & Virus Firewall - offering the fastest
virus & malware protection in the industry: Spam, Malware, and Advanced Threat Protection | Barracuda Networks

6

Is there a way to insert user’s real names into the search spreadsheet?

You have to make a local copy of Results.tsv and add something like:

push(@attrs, map {“Requestors->UserMembersObj->First->$_”}
qw(RealName HomePhone WorkPhone Address1 Address2 Zip)) if
$session{‘CurrentUser’}->HasRight(Object => $RT::System, Right =>
‘AdminUsers’);

below my @attrs =

Note that you have to have the ACLs, and it seems to slow the
loading of the spreadhseet.

Cambridge Energy Alliance: Save money. Save the planet.