[rt-users] Spreadsheet on reports coming as tsv

[Nick Metrowsky]

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:

 

<a href="<%$RT::WebPath%>/Search/Results.tsv<%$QueryString%>"> \

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

<a href="<%$RT::WebPath%>/Search/Results.csv<%$QueryString%>"> \

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

 

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:

 

<a
href="<%$RT::WebPath%>/AssetTracker/Search/Results.tsv<%$QueryString%>">
\ <&|/l&>spreadsheet (Excel)</&></a><br>

<a
href="<%$RT::WebPath%>/AssetTracker/Search/Results.csv<%$QueryString%>">
\

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

 




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 at digitalglobe.com <mailto:nmetrowsky at digitalglobe.com> 

DigitalGlobe (r), An Imaging and Information Company

http://www.digitalglobe.com <http://www.digitalglobe.com> 

------------------------------------------------------------------------
---------

________________________________

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at 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

 

 

On 8/17/06, Jesse Vincent <jesse at 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)


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060817/4cbbbf9d/attachment.htm>