Date/Time in exported spreadsheet wrong

Hi list,

we are using RT 3.6.5 RC2 and I observe the following problem.
We like to export search data to a spreadsheet, but there is a different
between the date in the web-UI and the exported data. In our case its 2
hours.

Our RT_SiteConfig.pm

$Timezone is used to convert times entered by users into GMT and back

again

It should be set to a timezone recognized by your local unix box.

Set($Timezone , ‘Europe/Berlin’);

Thanks for any input!

bjoern

Hi Bjoern,

I have noticed the same issue in RT 3.6.0. I’m not sure if I got to the
bottom of it but I believe that the time recorded in the database is always
GMT. When you view times and dates via the web front end, the settings in
RT_SiteConfig.pm come into effect, adjusting the time for your location.
However the export function always outputs data direct from the DB.

I hope there’s a straightforward way to fix this because it’s quite
frustrating for users.

Andrew

Hi Andrew,
yes, it is GMT. Jesse gave the hint some day ago. But I haven’t got an
idea to fix it.

cheers, Bjï¿œrn

Andrew Dike schrieb:

I haven’t looked at the code, but logic would imply that there is a function
somewhere that will convert Date and Time based on the time zone setting
within RT. For some reason the export process doesn’t use this function. If
I were trying to fix this problem (and I will probably have to when I have
time), I would find this function and see if I can use this function in the
export process. Or I would go directly to the code that performs the export
and create my own function to apply the timezone to the necessary fields.

As a side note, I don’t know of a logical reason for RT not exporting the
data which the correct timezone by default. GMT is of little use to anyone
not in the GMT timezone…

Hope this helps,

AndrewOn 10/9/07, Bjoern Schulz bjoern.schulz@desy.de wrote:

Hi Andrew,
yes, it is GMT. Jesse gave the hint some day ago. But I haven’t got an
idea to fix it.

cheers, Björn

Andrew Dike schrieb:

Hi Bjoern,

I have noticed the same issue in RT 3.6.0. I’m not sure if I got to the
bottom of it but I believe that the time recorded in the database is
always
GMT. When you view times and dates via the web front end, the settings
in
RT_SiteConfig.pm come into effect, adjusting the time for your location.
However the export function always outputs data direct from the DB.

I hope there’s a straightforward way to fix this because it’s quite
frustrating for users.

Andrew

Date: Tue, 02 Oct 2007 09:18:39 +0200

From: Bjoern Schulz bjoern.schulz@desy.de
Subject: [rt-users] Date/Time in exported spreadsheet wrong

Hi list,

we are using RT 3.6.5 RC2 and I observe the following problem.
We like to export search data to a spreadsheet, but there is a
different
between the date in the web-UI and the exported data. In our case its 2
hours.

Our RT_SiteConfig.pm

$Timezone is used to convert times entered by users into GMT and back

again

It should be set to a timezone recognized by your local unix box.

Set($Timezone , ‘Europe/Berlin’);

Thanks for any input!

bjoern



The rt-users Archives

Community help: 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