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?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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)

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
http://mail.yahoo.com

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."

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
http://mail.yahoo.com

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:

  1. When one “clicks” on spreadsheet, than save the file to disk; it
    will be called Results.tsv, Results-1.tsv, etc.
  2. Rename Results.tsv to Results.csv.
  3. 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.
  4. 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 ®, 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."

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)


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

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.