Calendar Timezone Issues

Jonsar

Not sure if anyone else is having this problem, but the start times in my calendar are different from my Outlook entries. Usually, they are off by 4 hours (I’m in EDT). The only time it displays the correct time is when the calendar entry was entered in UTC. This seems to be a new issue as it was working previously. Thoughts?

sdetweil

@Jonsar I created a set of calendar fixes for 2.13 and next. if you switch to the develop branch these should be resolved

see the instructions in the 2.13 office calendar topic at the top.of the troubleshooting section

Jonsar

@sdetweil Thank you. I have updated to v2.13.0 and still have the issue. Sorry for the dumb question, but how do I pull only from the develop branch?

sdetweil

@Jonsar my fault
see here
https://forum.magicmirror.builders/topic/13774/2-13-back-screen-translation-file-error-fix/2

Jonsar

@sdetweil Thank you for all your help. Unfortunately, it still has the timezone issue i.e. all times displayed UTC-4 (I’m in EDT). It appears that the times that are pulled from Outlook are not recognized as already in EDT and are being treated as UTC (hence the additional -4 hours). I’ll keep working on it.

sdetweil

@Jonsar can u share the ics file , email, same userid on gmail

it is a text file, so if u have to change the event names, it just an editor required

the ics spec says events with time ( T120000) (noon) MUST be in UTC
events that say DATE-ONLY, are in local time.

if there are NOT UTC, then they must supply a TZID= value

Windows uses non-standard timezone values, and IF you make up your own that aren’t in the
https://github.com/unicode-org/cldr/blob/master/common/supplemental/windowsZones.xml
official list, then you will get random results…

while a timezone MAY be defined IN the ics file, none of the ics handler libraries use it

here is an event from Office 365, using a recognized windows timezone

BEGIN:VEVENT
DESCRIPTION:test new event 1
UID:040000008200E00074C5B7101A82E0080000000070DE40F38786D601000000000000000
 010000000D2A9BA8A3668CA4ABB2CC6838268179F
SUMMARY:test
DTSTART;TZID=W. Europe Standard Time:20200910T090000
DTEND;TZID=W. Europe Standard Time:20200910T093000
CLASS:PUBLIC
PRIORITY:5
DTSTAMP:20200909T160350Z
TRANSP:OPAQUE
STATUS:CONFIRMED
SEQUENCE:0
LOCATION:
X-MICROSOFT-CDO-APPT-SEQUENCE:0
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-DONOTFORWARDMEETING:FALSE
X-MICROSOFT-DISALLOW-COUNTER:FALSE
END:VEVENT

here is an owa event with just date (whole day event)

BEGIN:VEVENT
UID:040000008200E00074C5B7101A82E00800000000104D9270F49BD601000000000000000
 0100000001BDF375044B13F4EB90D0876F5F54174
SUMMARY:some event name
DTSTART;VALUE=DATE:20201012
DTEND;VALUE=DATE:20201013
CLASS:PUBLIC
PRIORITY:5
DTSTAMP:20201007T210922Z
TRANSP:TRANSPARENT
STATUS:CONFIRMED
SEQUENCE:0
LOCATION:
X-MICROSOFT-CDO-APPT-SEQUENCE:0
X-MICROSOFT-CDO-BUSYSTATUS:FREE
X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY
X-MICROSOFT-CDO-ALLDAYEVENT:TRUE
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-DONOTFORWARDMEETING:FALSE
X-MICROSOFT-DISALLOW-COUNTER:FALSE
END:VEVENT

Jonsar

@sdetweil The ics file is generated with Microsoft Exchange Server 2010.

UID:55CA88B7-8EF2-4AB5-AD4E-557F33C33FBE
SUMMARY: TEST
DTSTART;TZID="(UTC-05:00) Eastern Time (US & Canada)":20201028T133000
DTEND;TZID="(UTC-05:00) Eastern Time (US & Canada)":20201028T150000
CLASS:PUBLIC
PRIORITY:5
DTSTAMP:20201015T165939Z
TRANSP:OPAQUE
STATUS:CONFIRMED
SEQUENCE:0
X-MICROSOFT-CDO-APPT-SEQUENCE:0
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-DONOTFORWARDMEETING:FALSE
X-MICROSOFT-DISALLOW-COUNTER:FALSE
END:VEVENT

sdetweil

@Jonsar yeh, that is a challenge… its broken in both the parser and the magic mirror code that handles the cal entries

I can get it ‘mostly’ right

the problem is that TZ= has stuff we can’t process…
“(UTC-05:00) Eastern Time (US & Canada)”

we can get the offset, and look up some timezone with the SAME offset to get back to UTC

except, the 1st entry America/Atikokan, doesn’t do Daylight savings,

and the date conversion library appears to have a bug, saying Daylight savings in the US is in effect on Oct 28, 2020, even tho its NOT til Nov 1, 2020

the rest of the text doesn’t match anything in the Windows timezone list.

so, it will be 1 hour off for a while.

sdetweil

@Jonsar I have found a solution and have submitted changes to the ics parser library
https://github.com/jens-maus/node-ical/issues/32
and will submit changes to MM to match.
https://github.com/MichMich/MagicMirror/issues/2171

if U are interested I could send u the test files, chat message me if u are interested.

Jonsar

@sdetweil Not sure what changed but the times are now displaying as starting 5 hours before they are supposed to.

sdetweil

@Jonsar do another git pull. Latest update accepted on friday

Jonsar

@sdetweil I’m still on the branch origin/develop and it says I’m up to date.

sdetweil

@Jonsar hm… show me a vevent entry please.

Jonsar

@sdetweil

As you can see, this event is scheduled to begin at 10:00am but is actually displaying on the calendar as starting at 5:00am.

BEGIN:VEVENT
UID:00D4F0F7-BF5A-45C4-B92F-41B8C771E111
SUMMARY:TEST
DTSTART;TZID="(UTC-05:00) Eastern Time (US & Canada)":20201123T100000
DTEND;TZID="(UTC-05:00) Eastern Time (US & Canada)":20201123T103000
CLASS:PUBLIC
PRIORITY:5
DTSTAMP:20201122T204236Z
TRANSP:OPAQUE
STATUS:CONFIRMED
SEQUENCE:0
X-MICROSOFT-CDO-APPT-SEQUENCE:0
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-DONOTFORWARDMEETING:FALSE
X-MICROSOFT-DISALLOW-COUNTER:FALSE
END:VEVENT

sdetweil

@Jonsar I don’t see that

only your vevent in ics file, tz set to us eastern

Sunday, November 22, 2020
10:50:31pm
NEXT EVENT
TEST Tomorrow at 10:00 AM

if u set debug in config.js this is what I see

	logLevel: ["INFO", "LOG", "WARN", "ERROR","DEBUG"],

this is what I see

 start=Mon Nov 23 2020 10:00:00 GMT-0500 (Eastern Standard Time) end=Mon Nov 23 2020 10:30:00 GMT-0500 (Eastern Standard Time)
initial tz=(UTC-05:00) Eastern Time (US & Canada)
corrected TZ=America/New_York
corrected tz=America/New_York
start date/time=Mon Nov 23 2020 10:00:00 GMT-0500 (Eastern Standard Time)
start offset=-300
start date/time w tz =Mon Nov 23 2020 10:00:00 GMT-0500 (Eastern Standard Time)
event date=Mon Nov 23 2020 10:00:00 GMT-0500 (Eastern Standard Time)
event offset=-300 hour=10 event date=Mon Nov 23 2020 10:00:00 GMT-0500 (Eastern Standard Time)
adjustHours=0

Jonsar

@sdetweil You’re right. Was totally on my end. Didn’t realize I had a file that was preventing the upgrade. After upgrading, works like a charm. Thanks for your help as always.

sdetweil

@Jonsar cool, glad u found it, and it works as you expected!
Thanks for the fast feedback