Spreadsheet on reports coming as tsv

Phanoko · August 17, 2006, 4:35pm

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Jesse_Vincent · August 17, 2006, 4:36pm

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet format. (Though we mark
it as an excel file, so the right thing happens when end-users click on
it)

Phanoko · August 17, 2006, 4:42pm

Perfect.
Thanks Jessee.— Jesse Vincent jesse@bestpractical.com wrote:

On Thu, Aug 17, 2006 at 09:35:21AM -0700, Phanoko wrote:

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet
format. (Though we mark
it as an excel file, so the right thing happens when
end-users click on
it)

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Mike_Taht · August 17, 2006, 4:43pm

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet format. (Though we mark
it as an excel file, so the right thing happens when end-users click on
it)

In my case, I’ve yet to convince firefox on linux to do the right thing and
hand off tsvs to openoffice in a format it understands - they get tossed
into the writer not the spreadsheet module.

The rt-users Archives

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

Mike Taht
PostCards From the Bleeding Edge
http://the-edge.blogspot.com
“In the kingdom of the blind, the one-eyed man is usually overworked.”

Phanoko · August 17, 2006, 4:47pm

Just did it with the same results as Mike.
Change it to a CSV and OO opens it fine in
spreadsheet.
Going to try to find the place to now to auto name the
file csv rather than tsv so OO can handle it easier.

When I select the spreadsheet option after doing
a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet
format. (Though we mark
it as an excel file, so the right thing happens
when end-users click on
it)

In my case, I’ve yet to convince firefox on linux to
do the right thing and
hand off tsvs to openoffice in a format it
understands - they get tossed
into the writer not the spreadsheet module.

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

–
Mike Taht
PostCards From the Bleeding Edge
http://the-edge.blogspot.com
“In the kingdom of the blind, the one-eyed man is
usually overworked.”

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Nick_Metrowsky · August 17, 2006, 4:49pm

Hi Everyone,

The following works on Linux, Firefox with OpenOffice V2>

1.1. Spreadsheet Functionality

When running Request Tracker on a Windows system, one can get a seamless
interface to Excel. That is, when one “clicks” on the spreadsheet
option, Request Tracker calls Excel, open up Excel and sends the desired
data to Excel. If the same thing is done on a Linux or UNIX system,
using OpenOffice, than the data is sent to OpenOffice Writer and not
OpenOffice Calc.

What is happening is Request Tracker is generating an output file with a
tsv extension, as the data is produced in a Tab Separated Value format.
Microsoft Excel recognizes a tsv file with no problem; however,
OpenOffice Calc does not. So, OpenOffice converts the results to an
ordinary text file, as it does not “support” the tsv file extension.
However, OpenOffice does support the csv (Comma Separated Values)
extension. There is a work around for this, as follows:

When one “clicks” on spreadsheet, than save the file to disk; it
will be called Results.tsv, Results-1.tsv, etc.
Rename Results.tsv to Results.csv.
Run OpenOffice Calc and open Results.csv. Calc will ask for
format of the file, in the Separated By section of the pop-up screen,
click on Tab and uncheck Comma.
Once these steps are followed, Calc will display the desired
data in spreadsheet format.

The following steps can be taken, to create a seamless interface for
UNIX and Linux users:

cd /opt/rt3/share/html/Search

ln -s Results.tsv Results.csv

Edit index.html and make the following changes:

\

<&|/l&>spreadsheet (Excel)</&> |

\

<&|/l&>spreadsheet (OpenOffice)</&> |

Another change, for Results.html, changes the order of the Ticket
display on the results page.

Change line 138 to read: $Order = ‘DESC’

Notice: The user should be made aware that spreadsheet (Excel) will only
work on Windows systems, and spreadsheet (OpenOffice) will only work on
Linux and UNIX systems.

If AssetTracker is also installed, then do the following:

cd /opt/rt3/share/html/AssetTracker/Search

ln -s Results.tsv Results.csv

Edit index.html and make the following changes:

\ <&|/l&>spreadsheet (Excel)</&>

\

<&|/l&>spreadsheet (OpenOffice)</&>

Issue the following commands:

/usr/local/apache2/bin/apachectl stop

rm -rf /opt/rt3/var/mason_data/obj

/usr/local/apache2/bin/apachectl start

Take care!

Nick

Nick Metrowsky

Consulting System Administrator

303-684-4785 Office

303-684-4100 Fax

nmetrowsky@digitalglobe.com mailto:nmetrowsky@digitalglobe.com

DigitalGlobe (r), An Imaging and Information Company

http://www.digitalglobe.com http://www.digitalglobe.comFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Mike Taht
Sent: Thursday, August 17, 2006 10:44 AM
To: Jesse Vincent
Cc: RT Users
Subject: Re: [rt-users] Spreadsheet on reports coming as tsv

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet format. (Though we mark
it as an excel file, so the right thing happens when end-users click on
it)

In my case, I’ve yet to convince firefox on linux to do the right thing
and hand off tsvs to openoffice in a format it understands - they get
tossed into the writer not the spreadsheet module.

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

Mike Taht
PostCards From the Bleeding Edge
http://the-edge.blogspot.com
“In the kingdom of the blind, the one-eyed man is usually overworked.”

Todd_Chapman1 · August 17, 2006, 5:49pm

Can you apply my patch to ConciseSpreadsheet extension?

Also, can we change the default extension to CSV for
the extension?On Thu, Aug 17, 2006 at 12:36:48PM -0400, Jesse Vincent wrote:

On Thu, Aug 17, 2006 at 09:35:21AM -0700, Phanoko wrote:

When I select the spreadsheet option after doing a
search I only get TSV files.
Did I forget a module install?

Nope. TSV is a perfectly servicable spreadsheet format. (Though we mark
it as an excel file, so the right thing happens when end-users click on
it)

The rt-users Archives

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

Jesse_Vincent · August 17, 2006, 5:46pm

Can you apply my patch to ConciseSpreadsheet extension?

I’ll have a look before I next release it.

Also, can we change the default extension to CSV for
the extension?

No. CSV is for comma-separated-values. I’m not going to do something
non-standard to support a misconfigured openoffice on linux.