Bug 474640 - UTC isn't converted into localtime
Summary: UTC isn't converted into localtime
Status: CONFIRMED
Alias: None
Product: KDE Itinerary
Classification: Applications
Component: general (other bugs)
Version First Reported In: unspecified
Platform: Android Android 13.x
: NOR normal
Target Milestone: ---
Assignee: Volker Krause
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-18 04:15 UTC by idoitprone
Modified: 2024-06-14 15:10 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments
kde itinerary export db (1013 bytes, application/octet-stream)
2023-09-18 04:15 UTC, idoitprone
Details
ics format (773 bytes, text/calendar)
2023-09-18 04:15 UTC, idoitprone
Details
kitinerary parsing screenshot (187.07 KB, image/png)
2023-09-18 04:18 UTC, idoitprone
Details
Screenshot from linux. Same issue as the version in f-droid android. (33.79 KB, image/png)
2023-09-18 04:27 UTC, idoitprone
Details
Online only ics (940 bytes, text/calendar)
2023-09-19 16:34 UTC, idoitprone
Details
online only eml confirmation email (46.32 KB, message/rfc822)
2023-09-19 16:35 UTC, idoitprone
Details

Note You need to log in before you can comment on or make changes to this bug.
Description idoitprone 2023-09-18 04:15:04 UTC
Created attachment 161684 [details]
kde itinerary export db

SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols.
See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***


STEPS TO REPRODUCE
1. Import attached ics
2. View the event


OBSERVED RESULT
The time is in UTC

EXPECTED RESULT
The time should be converted to localtime

SOFTWARE/OS VERSIONS
Application Version: 23.11.70(1694968095)
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Cvent//EN
BEGIN:VEVENT
DTSTART:20230922T010000Z
DTEND:20230922T033000Z
SUMMARY:Fall Regional Series: Los Angeles
LOCATION:Hudson Loft, 1200 S Hope Street, Los Angeles, CA 90015 US
DESCRIPTION:This fall, join alumni and friends as UC San Diego heads your way with an inspiring, impactful evening not to be missed.\n
X-ALT-DESC;FMTTYPE=text/html:<div class="ag87-crtemvc-hsbk"><div class="css-vsf5of"><p class="carina-rte-public-DraftStyleDefault-block"><span style="color: rgb(0,0,0);">This fall, join alumni and friends as UC San Diego heads your way with an inspiring, impactful evening not to be missed. </span></p></div></div>
PRIORITY:5
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

ADDITIONAL INFORMATION
I also attached kde itinerary export binary file
Comment 1 idoitprone 2023-09-18 04:15:44 UTC
Created attachment 161685 [details]
ics format

Affected file
Comment 2 idoitprone 2023-09-18 04:18:33 UTC
Created attachment 161686 [details]
kitinerary parsing screenshot
Comment 3 idoitprone 2023-09-18 04:19:12 UTC
````
[
    {
        "@context": "http://schema.org",
        "@type": "Event",
        "description": "This fall, join alumni and friends as UC San Diego heads your way with an inspiring, impactful evening not to be missed.\n",
        "endDate": {
            "@type": "QDateTime",
            "@value": "2023-09-22T03:30:00+00:00",
            "timezone": "UTC"
        },
        "location": {
            "@type": "Place",
            "name": "Hudson Loft, 1200 S Hope Street, Los Angeles, CA 90015 US"
        },
        "name": "Fall Regional Series: Los Angeles",
        "startDate": {
            "@type": "QDateTime",
            "@value": "2023-09-22T01:00:00+00:00",
            "timezone": "UTC"
        }
    }
]
```
Resulting json.
Comment 4 idoitprone 2023-09-18 04:27:24 UTC
Created attachment 161687 [details]
Screenshot from linux. Same issue as the version in f-droid android.
Comment 5 Volker Krause 2023-09-18 15:13:43 UTC
The problem here is that Itinerary doesn't know where the event is (although there is a proper address in the location field), so it doesn't know what the local time is and therefore uses the timezone specified in the iCal, which is UTC.

If you edit the event in Itinerary to have a location that is sufficiently precise to determine the timezone (state/country or geo coordinate in that case I think) it should show the times correctly.
Comment 6 idoitprone 2023-09-19 16:26:36 UTC
(In reply to Volker Krause from comment #5)
> The problem here is that Itinerary doesn't know where the event is (although
> there is a proper address in the location field), so it doesn't know what
> the local time is and therefore uses the timezone specified in the iCal,
> which is UTC.
> 
> If you edit the event in Itinerary to have a location that is sufficiently
> precise to determine the timezone (state/country or geo coordinate in that
> case I think) it should show the times correctly.

The tidbit will be a bit awkward. The school also provide online links in the same format


BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Cvent//EN
BEGIN:VEVENT
DTSTART:20230919T190000Z
DTEND:20230919T200000Z
SUMMARY:Triton Table Talks: Perspectives from Financial Industry Leaders
LOCATION:https://web.cvent.com/event_guest/v1/calendar/v1/calendars/events/c255c7bf-86df-4537-96ab-68330d0e9837/virtualSessionLink?inviteeId=3ba680eb-1812-4187-83f6-50feab73fb4b&sessionId=&g=
DESCRIPTION:Event URL: https://web.cvent.com/event_guest/v1/calendar/v1/calendars/events/c255c7bf-86df-4537-96ab-68330d0e9837/virtualSessionLink?inviteeId=3ba680eb-1812-4187-83f6-50feab73fb4b&sessionId=&g=\n
X-ALT-DESC;FMTTYPE=text/html:Event URL: https://web.cvent.com/event_guest/v1/calendar/v1/calendars/events/c255c7bf-86df-4537-96ab-68330d0e9837/virtualSessionLink?inviteeId=3ba680eb-1812-4187-83f6-50feab73fb4b&sessionId=&g=
PRIORITY:5
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR


[
    {
        "@context": "http://schema.org",
        "@type": "Event",
        "description": "Event URL: https://web.cvent.com/event_guest/v1/calendar/v1/calendars/events/c255c7bf-86df-4537-96ab-68330d0e9837/virtualSessionLink?inviteeId=3ba680eb-1812-4187-83f6-50feab73fb4b&sessionId=&g=\n",
        "endDate": {
            "@type": "QDateTime",
            "@value": "2023-09-19T20:00:00+00:00",
            "timezone": "UTC"
        },
        "location": {
            "@type": "Place",
            "name": "https://web.cvent.com/event_guest/v1/calendar/v1/calendars/events/c255c7bf-86df-4537-96ab-68330d0e9837/virtualSessionLink?inviteeId=3ba680eb-1812-4187-83f6-50feab73fb4b&sessionId=&g="
        },
        "name": "Triton Table Talks: Perspectives from Financial Industry Leaders",
        "startDate": {
            "@type": "QDateTime",
            "@value": "2023-09-19T19:00:00+00:00",
            "timezone": "UTC"
        }
    }
]


Is it possible to online events to locale into localtime?
Comment 7 idoitprone 2023-09-19 16:30:01 UTC
Is it possible to show online events into local time?
Comment 8 idoitprone 2023-09-19 16:34:54 UTC
Created attachment 161729 [details]
Online only ics
Comment 9 idoitprone 2023-09-19 16:35:47 UTC
Created attachment 161730 [details]
online only eml confirmation email
Comment 11 Nate Graham 2024-06-14 15:10:44 UTC
Migrating "reproducible" keyword to "CONFIRMED" status.