ICS/ICAL sync timezone issue

[derekantrican]

From Google-Apps-Script-Library created by derekantrican : derekantrican/Google-Apps-Script-Library#6

The following function is having trouble parsing timezones and needs to be improved:

function GetUTCTime(parameter){
  parameter = parameter.substr(1); //Remove leading ; or : character
  if (parameter.includes("TZID")){
    var tzid = parameter.split("TZID=")[1].split(":")[0];
    var time = parameter.split(":")[1];
    return Moment.moment.tz(time,tzid).tz("Etc/UTC").format("YYYYMMDDTHHmmss") + "Z";    
  }
  else
    return parameter;
}

The solution is to use regex to parse out the parts of the string. Here is documentation on how this parameter is formatted: https://www.kanzaki.com/docs/ical/dtstart.html

[derekantrican]

Some regex's: https://regex101.com/r/Nstcrr/3

[arjanvdberg]

As far as I can see in the documentation you reference, the TZID must be a reference to a VTIMEZONE component. Thus the TZID can be anything, and can't be parsed directly. You probably need to correctly interpret the VTIMEZONE (including daylight saving stuff) to apply the correct offset for a calendar entry.
https://www.kanzaki.com/docs/ical/tzid.html

[derekantrican]

Here is an example of the VTIMEZONE object we need to parse:

BEGIN:VTIMEZONE
TZID:Mountain Standard Time
BEGIN:STANDARD
DTSTART:16010101T020000
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010101T020000
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=2SU;BYMONTH=3
END:DAYLIGHT
END:VTIMEZONE

Here's another:

BEGIN:VTIMEZONE
TZID;X-RICAL-TZSOURCE=TZINFO:America/Chicago
BEGIN:DAYLIGHT
DTSTART:20180311T020000
RDATE:20180311T020000
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
END:DAYLIGHT
END:VTIMEZONE

[jdeluyck]

I tried out this script, and while it works 'fairly' good for a lot of entries, I have noticed that items which are supposed to be 'full day events' being scheduled form 9AM to 9AM - over two days, which is weird.

My timezone is CEST (Belgium), source feed is coming from Outlook 365.

[derekantrican]

@jdeluyck Could you please email me all or part of your ICS file? derekantrican@gmail.com

[jdeluyck]

Sent, together with some comments

[ravem]

I have a similar problem.

Every appointment/meeting I add to my office 365 calendar is correctly added to Google calendar but the time zone is ignored.
For example I have the attached ICS (where the TZID is W. Europe Standard Time) and the appointment is added to my Google calendar one hour later (I have renamed it as .txt).
prova.ics.txt

In the Stackdriver log of the script execution I have:
severity: "ERROR"
textPayload: "Moment Timezone has no data for W. Europe Standard Time. See http://momentjs.com/timezone/docs/#/data-loading/."

I'm no developer, so forgive me if the comment is needless :-D

[IssueHuntBot]

@marketingthriveworks has funded $300.00 to this issue. See it on IssueHunt

[ravem]

I have a similar problem.

FYI I solved the problem with a simple and dirty hack.
I did the math between the original start and end time and the one synced
with GC, and I changed on line 320 of Code.gs
return Moment.moment.tz(time,tzid).tz("Etc/UTC").format("YYYYMMDDTHHmmss") + "Z";
that Etc/UTC with a timezone that gives what I expect, in my case Atlantic/Cape_Verde.

[derekantrican]

Anyone that has been having problems with this (@ravem @marketingthriveworks @jdeluyck ) please make a copy of this script and check to see if the problem is resolved: https://script.google.com/d/1jD1oiON1ID4Cx46b3U_6nxn4Q-SNJ-J_gekVoQ_hLD2VOhGCnL6HzRn6/edit?usp=sharing

[marketingthriveworks]

TypeError: Cannot read property "id" from undefined. (line 151, file "Code")

[derekantrican]

@marketingthriveworks thanks for catching that. I just fixed it. It's accessible at the same link as before (you can either make a copy again or just copy all of the Code.gs file and replace your current Code.gs file)

[marketingthriveworks]

Issue remains still. I have to change appsscripts.json to my timezone for the calendar appointments to reflect the correct timezone.

"timeZone": "America/New_York",

[derekantrican]

@marketingthriveworks Please send me a link to the script that you are using derekantrican@gmail.com

[ravem]

@derekantrican my problem seems to be fixed.
Great work!

[IssueHuntBot]

@derekantrican has rewarded $270.00 to @derekantrican. See it on IssueHunt

• 💰 Total deposit: $300.00
• 🎉 Repository reward(0%): $0.00
• 🔧 Service fee(10%): $30.00