{"action":"created","issue":{"url":"https://api.github.com/repos/Runalyze/Runalyze/issues/1779","repository_url":"https://api.github.com/repos/Runalyze/Runalyze","labels_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/1779/labels{/name}","comments_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/1779/comments","events_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/1779/events","html_url":"https://github.com/Runalyze/Runalyze/issues/1779","id":147339124,"number":1779,"title":"Wrong times (1 hour off) for imported activities","user":{"login":"grzeg1","id":8179857,"avatar_url":"https://avatars.githubusercontent.com/u/8179857?v=3","gravatar_id":"","url":"https://api.github.com/users/grzeg1","html_url":"https://github.com/grzeg1","followers_url":"https://api.github.com/users/grzeg1/followers","following_url":"https://api.github.com/users/grzeg1/following{/other_user}","gists_url":"https://api.github.com/users/grzeg1/gists{/gist_id}","starred_url":"https://api.github.com/users/grzeg1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grzeg1/subscriptions","organizations_url":"https://api.github.com/users/grzeg1/orgs","repos_url":"https://api.github.com/users/grzeg1/repos","events_url":"https://api.github.com/users/grzeg1/events{/privacy}","received_events_url":"https://api.github.com/users/grzeg1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Runalyze/Runalyze/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/Runalyze/Runalyze/milestones/41","html_url":"https://github.com/Runalyze/Runalyze/milestones/Runalyze%20v2.5","labels_url":"https://api.github.com/repos/Runalyze/Runalyze/milestones/41/labels","id":1491036,"number":41,"title":"Runalyze v2.5","description":"Runalyze with timezones.","creator":{"login":"mipapo","id":2135076,"avatar_url":"https://avatars.githubusercontent.com/u/2135076?v=3","gravatar_id":"","url":"https://api.github.com/users/mipapo","html_url":"https://github.com/mipapo","followers_url":"https://api.github.com/users/mipapo/followers","following_url":"https://api.github.com/users/mipapo/following{/other_user}","gists_url":"https://api.github.com/users/mipapo/gists{/gist_id}","starred_url":"https://api.github.com/users/mipapo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mipapo/subscriptions","organizations_url":"https://api.github.com/users/mipapo/orgs","repos_url":"https://api.github.com/users/mipapo/repos","events_url":"https://api.github.com/users/mipapo/events{/privacy}","received_events_url":"https://api.github.com/users/mipapo/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":28,"state":"open","created_at":"2016-01-08T08:03:46Z","updated_at":"2016-04-11T07:28:10Z","due_on":"2016-04-08T22:00:00Z","closed_at":null},"comments":4,"created_at":"2016-04-11T07:28:10Z","updated_at":"2016-04-11T07:50:41Z","closed_at":null,"body":"File type: TCX (did not test others)\r\nTimestamps inside the file are like this: 2016-04-10T18:41:01.000+01:00\r\nTime zone set to Europe/Warsaw\r\nResulting time is 18:41 instead of 19:41\r\nIs it DST related? Not sure where to start debugging."},"comment":{"url":"https://api.github.com/repos/Runalyze/Runalyze/issues/comments/208210390","html_url":"https://github.com/Runalyze/Runalyze/issues/1779#issuecomment-208210390","issue_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/1779","id":208210390,"user":{"login":"mipapo","id":2135076,"avatar_url":"https://avatars.githubusercontent.com/u/2135076?v=3","gravatar_id":"","url":"https://api.github.com/users/mipapo","html_url":"https://github.com/mipapo","followers_url":"https://api.github.com/users/mipapo/followers","following_url":"https://api.github.com/users/mipapo/following{/other_user}","gists_url":"https://api.github.com/users/mipapo/gists{/gist_id}","starred_url":"https://api.github.com/users/mipapo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mipapo/subscriptions","organizations_url":"https://api.github.com/users/mipapo/orgs","repos_url":"https://api.github.com/users/mipapo/repos","events_url":"https://api.github.com/users/mipapo/events{/privacy}","received_events_url":"https://api.github.com/users/mipapo/received_events","type":"User","site_admin":false},"created_at":"2016-04-11T07:50:41Z","updated_at":"2016-04-11T07:50:41Z","body":"The sqlite/spatialite is not necessary for the recognition of the timezone during the upload. \r\nIt just fills the timezone_offset field in the database (may be used for statistics in the future)\r\nYou could manually access the sqlite db:\r\n```\r\n# sqlite timezonedb.sqlite\r\nsqlite> select load_extension('/usr/lib/x86_64-linux-gnu/libspatialite.so.5');\r\nsqlite> SELECT spatialite_version();\r\nsqlite> SELECT tzid FROM tz_world WHERE ST_Contains(geometry,MakePoint(-122.420706, 37.776685));\r\n```\r\nDuring the upload of the activity we look at the timestamp of the tcx file and try to figure out the UTC time:\r\n2016-04-10T18:40:58.000+01:00 -> in UTC: 17:40\r\nthan we add the offset by the date with your timezone configuration. This will be added to the UTC time and saved in the time field.\r\n\r\nJust don't know why it's not working in your case. What is your current offset in Europe/Warsaw? \r\n+2? \r\nMh - Runalyze should show up 19:40 in the end"}}