RE: [rt-users] Spreadsheet view displays more columns than in search
Just an FYI, it was the double quote that was causing the issues with Excel and rows not showing properly. I am using Excel 2003. I ended up doing this: $val =~ s/[^\032-\041\043-\176]/ /g; -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:55 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search After reviewing my changes further I believe I came up with a better solution for escaping tabs. In the file rtroot/share/html/Search/Elements/Results.tsv Instead of the line: $val =~ s/(\n|\r)//g; And instead of the previous change I suggested: $val =~ s/(\n|\r|\t)//g; I am going to change it to this: $val =~ s/\s/ /g; My thinking is if the intent of a newline, tab, or other whitespace character was to separate data, then a single space would be more fitting than nothing at all. Hope this helps someone else. Also wouldn't be a bad idea to add this fix to future versions even if it doesn't match what I did above. I would think having tabs escaped would be required for a tab delimited file to work properly. -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:16 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search Woops, just found this: $val =~ s/(\n|\r)//g; Looks like I just need to change to: $val =~ s/(\n|\r|\t)//g; -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:15 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search I think I found the root of the problem. It doesn't appear that tab characters or newlines are being escaped from the result set. This would cause issues with the presentation in Excel. I will add some coding to do this to the rows after I apply the patch. I am surprised this never affected anyone before. Thanks, -Tim -Original Message- From: Stephen Turner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 9:04 AM To: Flynn, Timothy J; rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote: 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 The mechanism use in searching for the web view is different from that used in the full spreadsheet download. That said, you should still see the same number of rows. When you get 14 rows in the web view are you actually seeing 14 tickets in the list, or is that number from the 'Found 14 tickets' message? It's just possible that you only have permission to see 11 of the 14 rows returned. Steve ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Spreadsheet view displays more columns than in search
On Thu, May 25, 2006 at 08:42:35AM -0500, Flynn, Timothy J wrote: Just an FYI, it was the double quote that was causing the issues with Excel and rows not showing properly. I am using Excel 2003. I ended up doing this: Thanks! It sure looks like our escaping isn't up to snuff. We should likely be using the relevant CPAN module. I've opened a ticket. Jesse $val =~ s/[^\032-\041\043-\176]/ /g; -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:55 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search After reviewing my changes further I believe I came up with a better solution for escaping tabs. In the file rtroot/share/html/Search/Elements/Results.tsv Instead of the line: $val =~ s/(\n|\r)//g; And instead of the previous change I suggested: $val =~ s/(\n|\r|\t)//g; I am going to change it to this: $val =~ s/\s/ /g; My thinking is if the intent of a newline, tab, or other whitespace character was to separate data, then a single space would be more fitting than nothing at all. Hope this helps someone else. Also wouldn't be a bad idea to add this fix to future versions even if it doesn't match what I did above. I would think having tabs escaped would be required for a tab delimited file to work properly. -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:16 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search Woops, just found this: $val =~ s/(\n|\r)//g; Looks like I just need to change to: $val =~ s/(\n|\r|\t)//g; -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:15 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search I think I found the root of the problem. It doesn't appear that tab characters or newlines are being escaped from the result set. This would cause issues with the presentation in Excel. I will add some coding to do this to the rows after I apply the patch. I am surprised this never affected anyone before. Thanks, -Tim -Original Message- From: Stephen Turner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 9:04 AM To: Flynn, Timothy J; rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote: 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 The mechanism use in searching for the web view is different from that used in the full spreadsheet download. That said, you should still see the same number of rows. When you get 14 rows in the web view are you actually seeing 14 tickets in the list, or is that number from the 'Found 14 tickets' message? It's just possible that you only have permission to see 11 of the 14 rows returned. Steve ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support
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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:57 PM To: Flynn, Timothy J; rt-users@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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:32 PM To: Flynn, Timothy J; rt-users@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: [EMAIL PROTECTED] 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
RE: [rt-users] Spreadsheet view displays more columns than in search
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 8:05 AM To: rt-users@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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:57 PM To: Flynn, Timothy J; rt-users@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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:32 PM To: Flynn, Timothy J; rt-users@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: [EMAIL PROTECTED] 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 ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Spreadsheet view displays more columns than in search
After reviewing my changes further I believe I came up with a better solution for escaping tabs. In the file rtroot/share/html/Search/Elements/Results.tsv Instead of the line: $val =~ s/(\n|\r)//g; And instead of the previous change I suggested: $val =~ s/(\n|\r|\t)//g; I am going to change it to this: $val =~ s/\s/ /g; My thinking is if the intent of a newline, tab, or other whitespace character was to separate data, then a single space would be more fitting than nothing at all. Hope this helps someone else. Also wouldn't be a bad idea to add this fix to future versions even if it doesn't match what I did above. I would think having tabs escaped would be required for a tab delimited file to work properly. -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:16 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search Woops, just found this: $val =~ s/(\n|\r)//g; Looks like I just need to change to: $val =~ s/(\n|\r|\t)//g; -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Timothy J Sent: Wednesday, May 24, 2006 9:15 AM To: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search I think I found the root of the problem. It doesn't appear that tab characters or newlines are being escaped from the result set. This would cause issues with the presentation in Excel. I will add some coding to do this to the rows after I apply the patch. I am surprised this never affected anyone before. Thanks, -Tim -Original Message- From: Stephen Turner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 9:04 AM To: Flynn, Timothy J; rt-users@lists.bestpractical.com Subject: RE: [rt-users] Spreadsheet view displays more columns than in search At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote: 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 The mechanism use in searching for the web view is different from that used in the full spreadsheet download. That said, you should still see the same number of rows. When you get 14 rows in the web view are you actually seeing 14 tickets in the list, or is that number from the 'Found 14 tickets' message? It's just possible that you only have permission to see 11 of the 14 rows returned. Steve ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
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: [EMAIL PROTECTED] 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
RE: [rt-users] Spreadsheet view displays more columns than in search
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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:32 PM To: Flynn, Timothy J; rt-users@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: [EMAIL PROTECTED] 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
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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:32 PM To: Flynn, Timothy J; rt-users@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: [EMAIL PROTECTED] 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