Bug #73054 for RT-Extension-SearchResults-XLS: XLS does not reflect chosen fields

Tue Dec 06 13:30:33 2011 jblaine [...] kickflop.net - Ticket created

Subject:	XLS does not reflect chosen fields
Date:	Tue, 06 Dec 2011 13:30:17 -0500
To:	bug-RT-Extension-SearchResults-XLS [...] rt.cpan.org
From:	Jeff Blaine <jblaine [...] kickflop.net>

Hi, First, thanks for this extension. We're having a problem where, in the Query Builder, if we select the 'Started' field for display in the search results, the web UI shows the field but the generated .XLS does not. Any advice would be appreciated. Jeff Blaine jblaine --ATSIGN-- kickflop --DOT-- net

Mon Dec 12 08:20:16 2011 ELACOUR [...] cpan.org - Correspondence added

That's the way RT works, this extension purpose is to just do exactly the same as the RT TSV export, but using XLS format. So such bug/feature should be reported to RT ;)

Mon Dec 12 08:20:17 2011 The RT System itself - Status changed from 'new' to 'open'

Mon Dec 12 08:20:17 2011 ELACOUR [...] cpan.org - Status changed from 'open' to 'rejected'

Wed Dec 14 15:33:25 2011 jblaine [...] kickflop.net - Correspondence added

Subject:	Re: [rt.cpan.org #73054] XLS does not reflect chosen fields
Date:	Wed, 14 Dec 2011 15:33:07 -0500
To:	bug-RT-Extension-SearchResults-XLS [...] rt.cpan.org
From:	Jeff Blaine <jblaine [...] kickflop.net>

On 12/12/2011 8:20 AM, Emmanuel Lacour via RT wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=73054> > > That's the way RT works, this extension purpose is to just do exactly > the same as the RT TSV export, but using XLS format. So such bug/feature > should be reported to RT ;)

Emmanuel, [ Just so you're aware of it ] RT 4.x allows for reporting on the selected fields (not just all fields). RT 3.8.x does not allow for this, as you have indicated above. However, there is a solution for 3.8.x TSV output at the following URL which could be integrated into your extension, since you package your own "Results.xxx" file. It's just a matter of whether or not you want to bother. See "3.8" here: http://requesttracker.wikia.com/wiki/SpreadsheetDisplayedFields

Wed Dec 14 15:33:26 2011 The RT System itself - Status changed from 'rejected' to 'open'

Thu Dec 22 13:27:31 2011 jblaine [...] kickflop.net - Correspondence added

Subject:	Re: [rt.cpan.org #73054] XLS does not reflect chosen fields
Date:	Thu, 22 Dec 2011 13:27:10 -0500
To:	bug-RT-Extension-SearchResults-XLS [...] rt.cpan.org
From:	Jeff Blaine <jblaine [...] kickflop.net>

I wrote a 'ScreenResults.xls' (report only on the fields chosen) based on your code and the 'SpreadsheetDisplayFields' code in the wiki. Would you like it? On 12/12/2011 8:20 AM, Emmanuel Lacour via RT wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=73054> > > That's the way RT works, this extension purpose is to just do exactly > the same as the RT TSV export, but using XLS format. So such bug/feature > should be reported to RT ;)

Wed Mar 12 13:28:52 2014 ELACOUR [...] cpan.org - Correspondence added

I just uploaded 0.08 which is for RT 4.2.x and export only choosen fields as RT 4.2 does.

Wed Mar 12 13:28:53 2014 ELACOUR [...] cpan.org - Status changed from 'open' to 'resolved'

Wed Mar 12 13:28:53 2014 ELACOUR [...] cpan.org - Taken