3.6.0 (spreadsheet) export changed

Hi all-

I upgraded from 3.4.4 to 3.6.0 earlier this week, and so far so good.

It is time to create a report that uses some bookmarked searches and I
used to export to csv with the ‘displayed fields only’. I’d take the
results of 3 or so bookmarked links and then paste the values into a
template that is formatted the way I want it. I do believe this may
have been a hack I picked up from the wiki or somewhere.

I went to create the report this week, and realized that the export
directly to .xls new feature exports all fields (which I guess it prob.
should).

Can I add back in my ‘export only displayed results’ to csv (or xls)?!

Does the same hack work in 3.6?

Thanks

duncan

Duncan Shannon
Techfluent, Inc.
P: 612-638-1300

At Thursday 7/6/2006 11:03 PM, Duncan Shannon wrote:

It is time to create a report that uses some bookmarked searches and I
used to export to csv with the ‘displayed fields only’. I’d take the
results of 3 or so bookmarked links and then paste the values into a
template that is formatted the way I want it. I do believe this may
have been a hack I picked up from the wiki or somewhere.
Can I add back in my ‘export only displayed results’ to csv (or xls)?!

Does the same hack work in 3.6?

Hi Duncan,

That sounds like my contrib
(http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields).
I’ve not tested it beyond 3.4.2, but the wiki states that it works OK
up to 3.4.5 at least. The only way to find out if it works on 3.6 is
to try it! If you do find that it works could you add a note to the
bottom of the wiki page?

Thanks,
Steve


Duncan Shannon
Techfluent, Inc.
P: 612-638-1300


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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)

At Monday 7/24/2006 08:18 PM, Adrian Carter wrote:

I went to check out this little hack but noticed the wiki is defaced
at http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields.

Could you restore it or e-mail me the hack ?

Thanks!

Adrian

Hello Adrian,

I just restored it on the wiki.

I don’t have special wiki powers - what worked for me was, for the
article, going to Revisions -> Previous -> Edit and then hitting Save.

Good luck,
Steve

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Stephen Turner

At Monday 7/24/2006 08:18 PM, Adrian Carter wrote:

I went to check out this little hack but noticed the wiki is
defaced at
http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields.

I don’t have special wiki powers - what worked for me was,
for the article, going to Revisions -> Previous -> Edit and
then hitting Save.

I’ve been doing this a lot lately - I’ve personally restored 5-6
pages/day over the last several days. One question for the admins: how
do I get a wiki account and then login? I’d like to have the changes
recorded as being done by me (yes, I like to be accountable for my
actions) but I can’t find an obvious way.

Drew

Drew Taylor wrote:

I’ve been doing this a lot lately - I’ve personally restored 5-6
pages/day over the last several days. One question for the admins: how
do I get a wiki account and then login? I’d like to have the changes
recorded as being done by me (yes, I like to be accountable for my
actions) but I can’t find an obvious way.

http://wiki.bestpractical.com/index.cgi?action=user_preferences

-----Original Message-----
From: Thomas Sibley [mailto:trs@bestpractical.com]
Sent: Tuesday, July 25, 2006 10:49 AM
To: Drew Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] 3.6.0 (spreadsheet) export changed…

Drew Taylor wrote:

I’ve been doing this a lot lately - I’ve personally restored 5-6
pages/day over the last several days. One question for the
admins: how
do I get a wiki account and then login? I’d like to have
the changes
recorded as being done by me (yes, I like to be accountable for my
actions) but I can’t find an obvious way.

http://wiki.bestpractical.com/index.cgi?action=user_preferences

Dang it! Why does the answer always seem obvious after publically
telling the world you can’t find it on your own? :slight_smile:

In my defense, the “login” box doesn’t jump out at me…

Drew