emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Tassilo Horn <tassilo@member.fsf.org>
To: nicholas.dokos@hp.com
Cc: emacs-orgmode@gnu.org
Subject: Re: Timezone/Encoding issues when exporting as ics and importing to Google Calendar
Date: Tue, 07 Jun 2011 16:58:50 +0200	[thread overview]
Message-ID: <87tyc17knp.fsf@member.fsf.org> (raw)
In-Reply-To: <11790.1307454502@alphaville.dokosmarshall.org> (Nick Dokos's message of "Tue, 07 Jun 2011 09:48:22 -0400")

Nick Dokos <nicholas.dokos@hp.com> writes:

Hi Nick,

>> 2. Timezone: I live in Germany and thus all my timestamps are CEST.  The
>>    exported ics file properly declare X-WR-TIMEZONE:CEST.  However,
>>    since we also have DST, in summer all appointments show up 2 hours
>>    late, and in winter my appointments show up 1 hour late.  Is there
>>    anything I can do about it?  The google calendar settings have CEST
>>    as timezone...
>> 
>
> I don't know if this is the problem you are running into, but
> icalendar--convert-tz-offset is buggy as-is: it looks as if additional
> work was planned for it, but it never got done.  In particular, it
> assumes there is an RRULE in the icalendar file and does not translate
> timezones otherwise.

I don't know the iCalendar spec so I don't know what an RRULE is.  But
as far as I can see, `icalendar--convert-tz-offset' is used while
converting an ics file to the diary format.

> Reading your mail again, I guess you are having problems in the
> other direction,

Right. ;-)

> but IME, if there is a bug somewhere, there is at least one more going
> the other way :-)

Probably.  Looking at the ical spec, this X-WR-TIMEZONE property is an
optional extension nobody has to obey.  Org exports the times like

  DTSTART:20110317T091500

which means "local time".  So probably the google server has UTC as
local time, my preferences say I want to use Berlin-time, so all events
get two hours added in summer.

Now I've tried to explicitly set the timezone information using

    org-icalendar-timezone "Europe/Berlin"
    org-icalendar-date-time-format ";TZID=%Z:%Y%m%dT%H%M%S"

and now the events are like

    DTSTART;TZID=EUROPE/BERLIN:20110322T140000
    DTEND;TZID=EUROPE/BERLIN:20110322T160000

However, that doesn't change anything in google calendar...

Finally, I've set GMT+0 as my current timezone in google calendar, and
now my appointments are shown correctly.  Ok, that's not really a
solution but only a workaround...

Oh, there's another possibility; setting

    org-icalendar-date-time-format ":%Y%m%dT%H%M%SZ"

which then seems to correctly recalculate the local times in my org
files to GMT.  So for an entry that starts at 14:30 and ends an 16:30,
that's what exported.

  DTSTART:20100518T123000Z
  DTEND:20100518T143000Z

Looks good, I'd say.  But when importing that to google calendar, it
shows that entry starting at 16:30 and ending at 18:30 Berlin-time.  Now
what's that?!?

Oh, it seems to be some caching issue.  Although the new ics file is on
the server now, it seems that a reload of google calendar doesn't
reimport all imported calendars.  So I'll wait a bit and report back
what methods work (explicit TZIDs and/or export as UTC).

Bye,
Tassilo

  reply	other threads:[~2011-06-07 14:58 UTC|newest]

Thread overview: 6+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-06-07 12:32 Timezone/Encoding issues when exporting as ics and importing to Google Calendar Tassilo Horn
2011-06-07 13:48 ` Nick Dokos
2011-06-07 14:58   ` Tassilo Horn [this message]
2012-03-15  7:29     ` Kevin Brubeck Unhammer
2012-03-20 11:41       ` Bastien
2012-03-20 12:33         ` Kevin Brubeck Unhammer

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87tyc17knp.fsf@member.fsf.org \
    --to=tassilo@member.fsf.org \
    --cc=emacs-orgmode@gnu.org \
    --cc=nicholas.dokos@hp.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).