Spreadsheets/Export missing Custom Fields

I have just upgraded from RT version 3.6.6 to version 4.0.10.

One function the users utilize frequently is to Search for Tickets with specific criteria and then Export them to a Spreadsheet.
In the old version they would get the ticket including all the custom fields.
After the upgrade to 4.0.10, we now get only the fields that are showing on the Search Results windows.

Any ideas?
Thanks

Rolf Krogstad
Pace Analytical Services Inc.
rgk [at] pacelabs [dot] com

The email and documents accompanying this transmission contain confidential information belonging to the sender who is legally privileged. The information is intended only for the use of the individual(s) or entity(ies) named herein. If you are not the intended recipient, you are hereby notified that any disclosure, copying distribution or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this in error, please immediately notify us by telephone (1.888.990.PACE) to arrange for return of the original documents.

I have just upgraded from RT version 3.6.6 to version 4.0.10.
One function the users utilize frequently is to Search for Tickets with
specific criteria and then Export them to a Spreadsheet.
In the old version they would get the ticket including all the custom
fields.
After the upgrade to 4.0.10, we now get only the fields that are showing
on the Search Results windows.
Any ideas?

I believe the export will not show the CFs unless they
are selected for display at the bottom of the search
form.

I have just upgraded from RT version 3.6.6 to version 4.0.10.

One function the users utilize frequently is to Search for Tickets with specific criteria and
then Export them to a Spreadsheet.
In the old version they would get the ticket including all the custom fields.
After the upgrade to 4.0.10, we now get only the fields that are showing on the Search Results
windows.

This change in 4.0 fixed a longstanding bug in previous RT versions
which would ignore your carefully constructed display format and just
spew everything into your spreadsheet. In fact, there was a popular
extension that implemented the current 4.0 behavior.

As noted by Jeff Blaine, you’ll want to have your users update the
Display Format of their searches and save them.

It’s certainly possible to create a second export that brings back the
old behavior if you’re so inclined…

-kevin

Thanks, Kevin.

How would I get all the custom fields into the Display Format drop down lists …
or How would I get all the Fields into the Export specs?

I tried putting the Results.tsv file from v3.6.6 and put that into v4.0.10, but it made no difference.
That was in my /opt/rt4/share/html/Search directory.
I assume that there is no compile needed to do such a change, but I know nothing about changing the software.
My experience is limited to installing and upgrading RT.

Thanks

Rolf

Kevin Falcone falcone@bestpractical.com 2/21/2013 2:39 PM >>>

I have just upgraded from RT version 3.6.6 to version 4.0.10.

One function the users utilize frequently is to Search for Tickets with specific criteria and
then Export them to a Spreadsheet.
In the old version they would get the ticket including all the custom fields.
After the upgrade to 4.0.10, we now get only the fields that are showing on the Search Results
windows.

This change in 4.0 fixed a longstanding bug in previous RT versions
which would ignore your carefully constructed display format and just
spew everything into your spreadsheet. In fact, there was a popular
extension that implemented the current 4.0 behavior.

As noted by Jeff Blaine, you’ll want to have your users update the
Display Format of their searches and save them.

It’s certainly possible to create a second export that brings back the
old behavior if you’re so inclined…

-kevin

The email and documents accompanying this transmission contain confidential information belonging to the sender who is legally privileged. The information is intended only for the use of the individual(s) or entity(ies) named herein. If you are not the intended recipient, you are hereby notified that any disclosure, copying distribution or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this in error, please immediately notify us by telephone (1.888.990.PACE) to arrange for return of the original documents.

How would I get all the custom fields into the Display Format drop down lists …
or How would I get all the Fields into the Export specs?

They show up for me, CustomField.{Foo} at the bottom of the Add Column
box.

I tried putting the Results.tsv file from v3.6.6 and put that into v4.0.10, but it made no
difference.
That was in my /opt/rt4/share/html/Search directory.
I assume that there is no compile needed to do such a change, but I know nothing about
changing the software.
My experience is limited to installing and upgrading RT.

I suggest you revert this change as quickly as possible.
Next time someone clears your mason cache, that code will start
running and explode.

-kevin