Spreadsheet/Export in 3.8.6/3.8.7 has columnheaders/data mixed up. Bug?

RT Users
1

Would anyone that has 3.8.7 installed that also uses custom fields, be willing to use the spreadsheet extract when viewing a queue and let me know if the Custom Field headers match up with their respective data? I’d like to figure out of there is an issue with my installation, or if it is a bug that I should report.

Any help would be greatly appreciated.

2

Not a perl guy, but I believe I figured out the problem. There is a bug in the code for Results.tsv.

Anywhere in particular I should be posting the fix?From: rt-users-bounces@lists.bestpractical.com on behalf of Epp, Christopher CLBC:EX
Sent: Thu 17/12/2009 3:42 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Spreadsheet/Export in 3.8.6/3.8.7 has columnheaders/data mixed up. Bug?

I upgraded 3.8.2 to both 3.8.6 and 3.8.7 in a test environment copied from my production installation.

In both versions I have had problems with the spreadsheet function. At first, it changed output from the previous version by outputting all custom fields, even ones not related to the queue I was exporting. That was fixed when I installed the Parse::BooleanLogic cpan module.

Now the problem is that the CF column headers are mixed up. So for example the CF-FirstName column heading would be over the LastName Data.

Is anyone else having this problem? Is this a bug?

Cheers,
Chris

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

Community help: http://wiki.bestpractical.com http://wiki.bestpractical.com/
Commercial support: sales@bestpractical.com

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

3

Not a perl guy, but I believe I figured out the problem. There is a bug in the code for Results.tsv.

Anywhere in particular I should be posting the fix?

patches can go to the list or to rt-bugs@bestpractical.com

You may want to compare your patch to git commit
1f4fa271b9e9c78104257f729f3046f9c30694e0

-kevin

4

Thanks Kevin,

I’ve never used git before, but that commit is the same fix I did for myself, so I don’t need to submit it then.

Thanks for taking the time to respond and educate me.

Cheers,
ChrisFrom: rt-users-bounces@lists.bestpractical.com on behalf of Kevin Falcone
Sent: Mon 21/12/2009 2:01 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Spreadsheet/Export in 3.8.6/3.8.7 has columnheaders/data mixed up. Bug?

Not a perl guy, but I believe I figured out the problem. There is a bug in the code for Results.tsv.

Anywhere in particular I should be posting the fix?

patches can go to the list or to rt-bugs@bestpractical.com

You may want to compare your patch to git commit
1f4fa271b9e9c78104257f729f3046f9c30694e0

-kevin

From: rt-users-bounces@lists.bestpractical.com on behalf of Epp, Christopher CLBC:EX
Sent: Thu 17/12/2009 3:42 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Spreadsheet/Export in 3.8.6/3.8.7 has columnheaders/data mixed up. Bug?

I upgraded 3.8.2 to both 3.8.6 and 3.8.7 in a test environment copied from my production installation.

In both versions I have had problems with the spreadsheet function. At first, it changed output from the previous version by outputting all custom fields, even ones not related to the queue I was exporting. That was fixed when I installed the Parse::BooleanLogic cpan module.

Now the problem is that the CF column headers are mixed up. So for example the CF-FirstName column heading would be over the LastName Data.

Is anyone else having this problem? Is this a bug?

winmail.dat (5.15 KB)