RE: [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:   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:   <a href="" \ <&|/l&>spreadsheet (Excel)</&></a> | <a href="" \ <&|/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="" \ <&|/l&>spreadsheet (Excel)</&></a><br> <a href="" \ <&|/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 [EMAIL PROTECTED] DigitalGlobe ®, An Imaging and Information Company http://www.digitalglobe.com --------------------------------------------------------------------------------- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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."

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com