search

GCalTools / Sheets2GCal

Issue Tracker for Sheets2GCal Google Sheets Add-on
1 stars 2 forks source link

Timezone for the automatic import > export #32

Open simran-d13 opened 11 months ago

simran-d13 commented 11 months ago

I set up an automated import>export at 6, then import happened at 1:20am. What is the timezone of runing the import>export?

simran-d13 commented 11 months ago

Also, what does the colors in the columns "Delete" - Red and " Update" - Green mean after the import>export? Sometimes I see the colors when there are no changes at all.

GCalToolkit commented 11 months ago

That's a good question... without checking I'm not 100% sure but I do know that Google doesn't guarantee the exact time at which it runs for the first time, and that subsequent triggers are supposed happen at the same time as the first one.

I'm at GMT+1 so I may not have noticed if the trigger runs at UTC instead of local time, but you can check the time and timezone yourself for a trigger that has been set by Sheets2GCal here: https://script.google.com/home/triggers

GCalToolkit commented 11 months ago

For the colours: red in the delete column means the event was deleted successfully, green in the update column means that the event was updated, and orange means that the event was updated and the change modified other events in the sheet - for example if you change a repeat event and this affects occurrences which have been edited and therefore show up in the sheet separately from the main repeat.

Sometimes events are modified by Google or third-party software that is synced with Google Calendar in ways that aren't obvious and this can result in events being updated that haven't changed in any meaningful way. This shouldn't happen very often though, so if you are seeing a lot of these updates there might be an issue that needs fixing.

To test if this is the case without waiting for automatic imports to run you can push all your sheet edits to Google Calendar (then no "Update" cells are checked), then run "Check Sheet vs Calendar" and see which events are flagged to "Update".

To help resolve the issue I'd need some screenshots and read access to a copy of a Sheet/Calendar that has this problem, so it would be easier to organise that elsewhere: please see http://www.gcaltools.com for various contact methods.

simran-d13 commented 11 months ago

Thanks for the precisions! I will look into it but that makes sense my calendar is connected to other tools…not too many are affected but it seemed strange because no changes are visible on Google calendar.