Re: [rt-users] Going crazy with RT 3.8 and Timezones for Display Dates

2010-07-01 Thread Ruslan Zakirov
Hi.
I think you want to construct date object using user who set those cfs and
use timezone user. SetDue method has no diff between 3.6 and 3.8, it takes
ISO in utc.

01.07.2010 16:11 пользователь "Torsten Brumm" 
написал:

Hi Chris,
this i already tried. The problem is more that the timezone offset is only
for display, not for calculation used (so far i figured already) and i have
really no idea how to fix it. one possible way could be:

1. If a user is entering this fields, check the users timezone and use the
offset to work with the utc values...

i will play around a little more...

Torsten

2010/7/1 Christian Loos 


>
> Hi Torsten,
>
> try this:
>
> my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
> ...




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de


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

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

Re: [rt-users] Going crazy with RT 3.8 and Timezones for Display Dates

2010-07-01 Thread Christian Loos
Hi Torsten,

normally you don't need to worry about timezones in date calculations.
You should always normalize all dates to UTC and then do the calculations.

May you can give an example of you date calculations?

Chris

Am 01.07.2010 14:10, schrieb Torsten Brumm:
> Hi Chris,
> this i already tried. The problem is more that the timezone offset is
> only for display, not for calculation used (so far i figured already)
> and i have really no idea how to fix it. one possible way could be:
> 
> 1. If a user is entering this fields, check the users timezone and use
> the offset to work with the utc values...
> 
> i will play around a little more...
> 
> Torsten

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


Re: [rt-users] Going crazy with RT 3.8 and Timezones for Display Dates

2010-07-01 Thread Torsten Brumm
Hi Chris,
this i already tried. The problem is more that the timezone offset is only
for display, not for calculation used (so far i figured already) and i have
really no idea how to fix it. one possible way could be:

1. If a user is entering this fields, check the users timezone and use the
offset to work with the utc values...

i will play around a little more...

Torsten

2010/7/1 Christian Loos 

> Hi Torsten,
>
> try this:
>
> my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
> my $DUETIME = $self->TicketObj->FirstCustomFieldValue('Time');
> my $DUE = $DUEDATE." ".$DUETIME;
> my $DATE = RT::Date->new( $session{'CurrentUser'} );
> $DATE->Set(
>Format => 'unknown',
>Value => $DUE,
>Timezone => 'UTC',
> );
> $self->TicketObj->SetDue( $DATE->ISO );
> return 1;
>
> Chris
>
> Am 30.06.2010 18:44, schrieb Torsten Brumm:
> > Hi RT Users,
> > since we are planing our RT 3.8 migration, we are cross checking all our
> > scrips and some scrips with time calculaltions driving me mad.
> >
> > Example from RT 3.6.x
> >
> > We have two CF's: Date and the other Time
> >
> > CF.Date
> > CF.Time
> >
> > The user is entering the date and the time in utc normally - our RT is
> > running in UTC
> >
> > Then i have a tiny scrip:
> >
> > my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
> > my $DUETIME = $self->TicketObj->FirstCustomFieldValue('Time');
> > my $DUE = $DUEDATE." ".$DUETIME;
> > $self->TicketObj->SetDue($DUE);
> > return 1;
> >
> > Under RT 3.6. RT was setting this simply to the entered values, all was
> > fine.
> >
> > Now with RT 3.8 RT the user is able to enter his timezone offset for
> > Display and RT is adding the Timezone Difference to this value.
> >
> > Any hints how to prevent this? or to make sure to get the correct value,
> > entered by the user?
> >
> > Torsten
> >
> >
> > --
> > MFG
> >
> > Torsten Brumm
> >
> > http://www.brumm.me
> > http://www.elektrofeld.de
> >
> >
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
>


-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

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

Re: [rt-users] Going crazy with RT 3.8 and Timezones for Display Dates

2010-07-01 Thread Christian Loos
Hi Torsten,

try this:

my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
my $DUETIME = $self->TicketObj->FirstCustomFieldValue('Time');
my $DUE = $DUEDATE." ".$DUETIME;
my $DATE = RT::Date->new( $session{'CurrentUser'} );
$DATE->Set(
Format => 'unknown',
Value => $DUE,
Timezone => 'UTC',
);
$self->TicketObj->SetDue( $DATE->ISO );
return 1;

Chris

Am 30.06.2010 18:44, schrieb Torsten Brumm:
> Hi RT Users,
> since we are planing our RT 3.8 migration, we are cross checking all our
> scrips and some scrips with time calculaltions driving me mad.
> 
> Example from RT 3.6.x
> 
> We have two CF's: Date and the other Time
> 
> CF.Date
> CF.Time
> 
> The user is entering the date and the time in utc normally - our RT is
> running in UTC
> 
> Then i have a tiny scrip:
> 
> my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
> my $DUETIME = $self->TicketObj->FirstCustomFieldValue('Time');
> my $DUE = $DUEDATE." ".$DUETIME;
> $self->TicketObj->SetDue($DUE);
> return 1;
> 
> Under RT 3.6. RT was setting this simply to the entered values, all was
> fine.
> 
> Now with RT 3.8 RT the user is able to enter his timezone offset for
> Display and RT is adding the Timezone Difference to this value.
> 
> Any hints how to prevent this? or to make sure to get the correct value,
> entered by the user?
> 
> Torsten
> 
> 
> -- 
> MFG
> 
> Torsten Brumm
> 
> http://www.brumm.me
> http://www.elektrofeld.de
> 
> 
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com


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


[rt-users] Going crazy with RT 3.8 and Timezones for Display Dates

2010-06-30 Thread Torsten Brumm
Hi RT Users,
since we are planing our RT 3.8 migration, we are cross checking all our
scrips and some scrips with time calculaltions driving me mad.

Example from RT 3.6.x

We have two CF's: Date and the other Time

CF.Date
CF.Time

The user is entering the date and the time in utc normally - our RT is
running in UTC

Then i have a tiny scrip:

my $DUEDATE = $self->TicketObj->FirstCustomFieldValue('Date');
my $DUETIME = $self->TicketObj->FirstCustomFieldValue('Time');
my $DUE = $DUEDATE." ".$DUETIME;
$self->TicketObj->SetDue($DUE);
return 1;

Under RT 3.6. RT was setting this simply to the entered values, all was
fine.

Now with RT 3.8 RT the user is able to enter his timezone offset for Display
and RT is adding the Timezone Difference to this value.

Any hints how to prevent this? or to make sure to get the correct value,
entered by the user?

Torsten


-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

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