RT 3.6.5 Bug - Ticket attribute values in spreadsheet download are not localized

RT Developers
1

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized.
This came up as an issue for us as we have use localization to rename
the ‘stalled’ status to ‘waiting’.

Patch to Search/Results.tsv below.

Thanks,
Steve

diff -u share/html/Search/Results.tsv local/html/Search/Results.tsv
— share/html/Search/Results.tsv 2007-04-24 13:21:42.000000000 -0400
+++ local/html/Search/Results.tsv 2007-12-05 17:03:03.000000000 -0500
@@ -81,7 +81,7 @@
$row->{$attr} = “”;
} else {
my $method = ‘$Ticket->’.$attr.’()’;

  •        $row->{$attr} = eval $method;

  •        $row->{$attr} = loc(eval $method);
        if ($@) {die "Failed to find $attr - ". $@};
    }
}
2

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized. This
came up as an issue for us as we have use localization to rename the
‘stalled’ status to ‘waiting’.

I’m sorry that this is not directly related, but I was wondering how you
implemented this renaming of the status. We are thinking of doing
something similar in our infrastructure.

Matthew Ekstrand-Abueg
Systems Administrator
Network Infrastructure, RSSP-IT
UC Berkeley

3

At Thursday 12/6/2007 03:39 AM, Matthew Ekstrand-Abueg wrote:>On 17:05 Wed 05 Dec , Stephen Turner wrote:

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized. This
came up as an issue for us as we have use localization to rename the
‘stalled’ status to ‘waiting’.

I’m sorry that this is not directly related, but I was wondering how you
implemented this renaming of the status. We are thinking of doing
something similar in our infrastructure.

That’s a good question - I didn’t find anything on the wiki or in the
RT book. Here’s what we’ve done:

  • Created a file $RTHOME/local/po/XXXX/en.po
    (where XXXXX can be any string)

  • The format of the content in this file matches that of
    $RTHOME/lib/RT/I18N/en.po . Here are the entries that translate our
    status value of ‘stalled’ to ‘waiting’:

msgid “stalled”
msgstr “waiting”

msgid “Stalled”
msgstr “Waiting”

I believe when you make changes to this file, you have to stop &
start the web server - and possibly clear the mason cache.

Steve

4

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized.
This came up as an issue for us as we have use localization to rename
the ‘stalled’ status to ‘waiting’.

I can see doing this for status, but running loc on other values…may
have unintended consequences. Are there other things we should be
locing?

5

At Friday 12/7/2007 03:32 PM, Jesse Vincent wrote:>On Wed, Dec 05, 2007 at 05:05:49PM -0500, Stephen Turner wrote:

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized.
This came up as an issue for us as we have use localization to rename
the ‘stalled’ status to ‘waiting’.

I can see doing this for status, but running loc on other values…may
have unintended consequences. Are there other things we should be
locing?

I see the point - would a better approach be to change Ticket’s
Status method to return a loc’d value?

Steve

6

RT 3.6.5.

Ticket attribute values in spreadsheet download are not localized.
This came up as an issue for us as we have use localization to rename
the ‘stalled’ status to ‘waiting’.

I can see doing this for status, but running loc on other values…may
have unintended consequences. Are there other things we should be
locing?

I see the point - would a better approach be to change Ticket’s
Status method to return a loc’d value?

I worry about the double-localization that will cause with existing code
that localizes status. I suspect we just want to special case it there.