openerp-india team mailing list archive

[lln78 <1006974@xxxxxxxxxxxxxxxxxx>]

The error arrive only when I want to add to the calendar (using 
Thunderbird) the events I received from Outlook and Lotus Note.
As you can see In the attached file, problem occurs on an ics WITH daylight.

But the problem, as you can see in the traceback, is not related to 
daylight but only to timezone id / name.

It's not a trivial problem, because openerp saves timezones using the 
olson name identifier in meetings.
Using caldav, when you want to add an event, Openerp wants to put the 
given TZID in the vtimezone field, and there's an error when the TZID 
given in the ics file is not a name from the olson database. When you 
use thunderbird, there's no problem because the TZID are olson names, 
but Outlook gives the Windows timezone names and Lotus Note also.

In the iCalendar specifications (RFC 2445 
<http://www.ietf.org/rfc/rfc2445.txt>) it is said that you can give the 
name you want to this tzid, but you have to describe it.

So the possible resolutions are:
- Find an olson name using the given timezone informations
     - you will have to parse the TIMEZONE elements from the ICS file 
(with DAYLIGHT and STANDARD, DTSTART, TZOFFSETFROM, TZOFFSETTO and the 
most difficult part : RRULE)
     - Then search an olson timezone with the same specifications : the 
problem is that you don't have an unique name for these specifications
     - It's hard to parse and hard to find the good olson name
- The most elegant way :
     -    parse the timezone element and calculate the UTC time : 
there's no need to save the timezone
- The bad hack (that will work in most cases) :
      - Use a correspondance table to map the Unicode/Windows name to an 
olson name : you can find one in the Unicode CLDR ( Common Locale Data 
Repository <http://www.unicode.org/cldr/>) in common / supplemental 
/windowsZones.xml : it's up to date, easy to parse (xml). The problem is 
that you don't have the windows short names in it... (not Romance but 
"Romance Standard Time" for example
     - Another problem is that there is no unique correspondance : for 
example, for romance you have Europe/Paris, Europe/Berlin, etc. This is 
because these timezone have no history like in the timezone database.

Hope it helps

Le 12/06/2012 13:25, Ravish(OpenERP) a écrit :
> Hello lln78,
>
> I have checked your issue. Are you getting this error when you are using
> TZ without daylight in ics file? or getting this error  for all TZ.
>
> Please describe more on this.
>
>
> Thanks for support..!!
>
>
> ** Changed in: openobject-addons
>         Status: New =>  Incomplete
>

-- 
Laurent Lauden Ijinus

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1006974

Title:
  [6.1] Caldav and Timezones

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Invitations coming from Outlook or Lotus Notes and received on
  thunderbird can't be added to the synchronized calendar.

  In ics files, timezones are defined with an arbitrary timezone id 
  (and all the needed information like standard/daylight start, stop and offset)
  But it seems that OpenErp is waiting for a timezone id (TZID) which is a timezone name from the olson database to transform the ics to an Openerp calendar event.

  exemple timezone definition from http://www.kanzaki.com/docs/ical/vtimezone.html :
  BEGIN:VTIMEZONE
    TZID:US--Fictitious-Eastern
    LAST-MODIFIED:19870101T000000Z
    BEGIN:STANDARD
    DTSTART:19671029T020000
    RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
    TZOFFSETFROM:-0400
    TZOFFSETTO:-0500
    TZNAME:EST
    END:STANDARD

    BEGIN:DAYLIGHT
    DTSTART:19870405T020000
    RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4;UNTIL=19980404T070000Z
    TZOFFSETFROM:-0500
    TZOFFSETTO:-0400
    TZNAME:EDT
    END:DAYLIGHT
    END:VTIMEZONE

  Traceback from OpenErp :
  2012-05-31 15:23:53,589 16743 WARNING ? webdav: Cannot create A38A1A3EA4943F5BC1257A060042FEBC-Lotus_Notes_Generated.ics: ('ValidateError', u'The value "romance" for the field "crm_meeting.vtimezone" is not in the selection')
  2012-05-31 15:23:53,589 16743 WARNING ? webdav: Cannot PUT to http://10.29.32.5:8169/production/calendars/users/llauden/c/Meetings/A38A1A3EA4943F5BC1257A060042FEBC-Lotus_Notes_Generated.ics: Operation failed
  2012-05-31 15:23:53,590 16743 INFO ? werkzeug: 10.29.1.11 - - [31/May/2012 15:23:53] "PUT /webdav/production/calendars/users/llauden/c/Meetings/A38A1A3EA4943F5BC1257A060042FEBC-Lotus_Notes_Generated.ics HTTP/1.1" 403 -

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1006974/+subscriptions