[rt-users] Spreadsheet view displays more columns than in search

Flynn, Timothy J timothy-flynn at uiowa.edu
Wed May 24 09:17:56 EDT 2006


Eric,

	I just dumped the TSV results to a txt file and opened with
ultraedit and the data is fine.  Excel is messing up the data somehow.
Doesn't appear to be an RT issue, but it might be an escaping issue due
to some of the content in the ticket.

	Thanks for the link on the patch for the columns!

-Tim
 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 8:05 AM
To: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

-----Original Message-----
From: Schultz, Eric [mailto:ESchultz at corp.untd.com] 
Sent: Tuesday, May 23, 2006 3:57 PM
To: Flynn, Timothy J; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Only thing I can think of is that you somehow modified the query before
doing one query vs. the other?  Maybe using the browser navigation vs.
the application navigation?  If the spreadsheet had more, I would say it
could be something with that query being less restrictive, but that's
not the case.

> Thanks Eric,  do you know why I'd be getting different results in
> spreadsheet vs the web list?  On one report I am getting 14 tickets in
> the web view and in the spreadsheet I am getting 11 and the data is
> wrong..  FYI the web results are correct and the spreadsheet 
> is not.  Is
> something not being escaped that is affecting the query?
> 
> -Tim
>  
> 
> -----Original Message-----
> From: Schultz, Eric [mailto:ESchultz at corp.untd.com] 
> Sent: Tuesday, May 23, 2006 3:32 PM
> To: Flynn, Timothy J; rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] Spreadsheet view displays more columns than in
> search 
> 
> 
> > When my users are searching for tickets, they select the 
> columns they
> > want and then search.  A lot of them like the spreadsheet 
> view so they
> > can make reports.  One problem is in the spreadsheet view 
> there are a
> > lot of extra columns that they didn't add.  They appear to 
> be most of
> > the default time fields in RT (IE, told date, due date, etc). 
> >  Is there
> > a way to omit these?
> > 
> > RT 3.4.5
> 
> This is what you want:
> http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
> It was vandalized, so I reverted to the previous saved version.
> 
> Eric Schultz
> United Online
> 
_______________________________________________
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


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html



More information about the rt-users mailing list