Wrong date/time (export)

RT Users
1

Hi there,

I have weird problem with my RT (4.0.4) - when I’m trying to use
export option to CSV/XML file, my timezone is not taken into account.
I was looking for answer for many hours with no success.

My actual settings:

at RT:
Set($Timezone, “Europe/Warsaw”);

at SERWER:
root@hathor:~# cat /etc/timezone
Europe/Warsaw

I believe this sets are correct. However, for some reason my(user’s)
RT is ignoring them and puts incorrect (GMT) timezone value into
CSV/XLS files.

When searched for the solution throughout forums I saw many users had
the same type of problem, unfortunately none of them found the right
answer to this issue.
I’m having difficulties in finding the cause therefore, any assistance
would be helpful.

I’ m waiting for leads.

Regards,
Martin

2

I have weird problem with my RT (4.0.4) - when I’m trying to use
export option to CSV/XML file, my timezone is not taken into account.
I was looking for answer for many hours with no success.

The spreadsheet link for me provides Created dates in the same
timezone (eastern) that my RT is configured for. Are you using some
extension? In 3.8, there were bugs around this, but 4.0’s builtin
spreadsheet export should account for the user’s timezone.

-kevin

3

Hi Kevin,

We’re using this extensions:

Set(@Plugins,(qw(RTx::Calendar
RT::Extension::ExtractCustomFieldValues
RT::Extension::SLA
RT::Extension::ActivityReports
RT::Extension::JSGantt)));

Regards,
Martin

4

Please reply to the list, there’s no need to send me private mail.On Wed, Aug 08, 2012 at 07:09:25PM +0200, Marcin Łabuz wrote:

We’re using this extensions:

Set(@Plugins,(qw(RTx::Calendar
RT::Extension::ExtractCustomFieldValues
RT::Extension::SLA
RT::Extension::ActivityReports
RT::Extension::JSGantt)));

None of these should override the spreadsheet download. I’d go
looking for local customizations, RT4 should obey user timezones when
outputting dates/times.

-kevin