phw198/OutlookGoogleCalendarSync

Option to include only specific calendar entries by name (exclude everything except)

Closed this issue · 5 comments

I managed to get access to a shared calendar, but I don't want to sync every event it contains since it's not mine.
I was looking for an option to exclude everything BUT specific (word filter) events.
The goal is to sync the calendar entries where he is away so I can use his parking lot 😁
If I can set a specific reminder for these events it would be great, so i can get a reminder in the morning.

This should already be possible - you can exclude items by subject, so you just need to figure out the regular expression for the inverse (ie match where word isn't included).

For example, to only sync items where Parking is in the subject, exclude items where it is not in the subject: ^((?!Parking).)*$

Oh you're right! I missed that option...
But I can't check if it works, since iI get an error sying I don't have permission to access the calendar...

Maybe related to #1775 ?

The Log:

2024-05-21 14:54:08,022 DEBUG  1 OutlookGoogleCalendarSync.Sync.Engine [98] -  ActiveProfile set to: None
2024-05-21 14:54:19,490 DEBUG  1 OutlookGoogleCalendarSync.Sync.SyncTimer [54] -  Scheduled sync triggered for profile: Paul
2024-05-21 14:54:20,370 INFO  1 OutlookGoogleCalendarSync.Sync.Engine+Job+Queue [61] -  Scheduled sync started (AutoSyncTimer) for profile: Paul
2024-05-21 14:54:20,371 DEBUG  1 OutlookGoogleCalendarSync.Sync.Engine [98] -  ActiveProfile set to: Paul
2024-05-21 14:54:20,372 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [269] -  CALENDAR SYNC SETTINGS
2024-05-21 14:54:20,373 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [270] -  Profile: Paul
2024-05-21 14:54:20,373 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [272] -  Last Synced: 01.01.0001 00:00:00
2024-05-21 14:54:20,374 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [273] -  OUTLOOK SETTINGS:-
2024-05-21 14:54:20,374 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [273] -    Service: SharedCalendar
2024-05-21 14:54:20,374 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [275] -    Shared Calendar: /o=ExchangeLabs/ou=Exchange Administrative Group (FYDIBOHDLT)/cn=Recipients/cn=6b95d39186354-asdf.asdf
2024-05-21 14:54:20,375 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [280] -    Calendar: Kalender (ID: 00000000FBA5182E170E59DB902EEC2CC00000000010D0000)
2024-05-21 14:54:20,375 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [281] -    Category Filter: Exclude
2024-05-21 14:54:20,375 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [282] -    Delete When Excluded: True
2024-05-21 14:54:20,376 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [283] -    Categories: 
2024-05-21 14:54:20,376 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [284] -    Only Responded Invites: False
2024-05-21 14:54:20,376 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [285] -    Filter String: g
2024-05-21 14:54:20,376 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [287] -    GAL Blocked: False
2024-05-21 14:54:20,377 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [288] -  GOOGLE SETTINGS:-
2024-05-21 14:54:20,377 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [289] -    Calendar: ho******e@gmail.com (ID: ho******e@gmail.com)
2024-05-21 14:54:20,377 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [290] -    Colour Filter: Include
2024-05-21 14:54:20,378 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [291] -    Delete When Excluded: True
2024-05-21 14:54:20,378 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [292] -    Colours: <Default calendar colour>,Banana,Basil,Blueberry,Flamingo,Grape,Graphite,Lavendar,Peacock,Sage,Tangerine,Tomato
2024-05-21 14:54:20,378 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [293] -    Exclude Declined Invites: True
2024-05-21 14:54:20,379 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [294] -    Exclude Goals: True
2024-05-21 14:54:20,379 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [295] -    Include Google Meet: True
2024-05-21 14:54:20,379 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [297] -    Cloak Email: True
2024-05-21 14:54:20,380 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [297] -  SYNC OPTIONS:-
2024-05-21 14:54:20,380 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [300] -   How
2024-05-21 14:54:20,380 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [301] -    SyncDirection: Outlook → Google
2024-05-21 14:54:20,381 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [302] -    MergeItems: True
2024-05-21 14:54:20,381 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [303] -    DisableDelete: False
2024-05-21 14:54:20,381 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [304] -    ConfirmOnDelete: True
2024-05-21 14:54:20,382 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [305] -    SetEntriesPrivate: False
2024-05-21 14:54:20,382 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [306] -    SetEntriesAvailable: False
2024-05-21 14:54:20,383 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [306] -    SetEntriesColour: False
2024-05-21 14:54:20,383 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [320] -    SingleCategoryOnly: False
2024-05-21 14:54:20,383 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [320] -    Obfuscate Words: False
2024-05-21 14:54:20,384 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [330] -   When
2024-05-21 14:54:20,384 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [331] -    DaysInThePast: 1
2024-05-21 14:54:20,384 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [332] -    DaysInTheFuture:60
2024-05-21 14:54:20,384 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [333] -    SyncInterval: 1
2024-05-21 14:54:20,384 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [334] -    SyncIntervalUnit: Hours
2024-05-21 14:54:20,385 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [335] -    Push Changes: False
2024-05-21 14:54:20,386 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [336] -   What
2024-05-21 14:54:20,386 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [337] -    AddLocation: True
2024-05-21 14:54:20,386 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [338] -    AddDescription: True; OnlyToGoogle: True
2024-05-21 14:54:20,386 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [339] -    AddAttendees: False <200
2024-05-21 14:54:20,387 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [340] -    AddColours: False
2024-05-21 14:54:20,388 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [341] -    AddReminders: True
2024-05-21 14:54:20,388 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [342] -      UseGoogleDefaultReminder: True
2024-05-21 14:54:20,388 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [343] -      UseOutlookDefaultReminder: False
2024-05-21 14:54:20,389 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [344] -      ReminderDND: False (22:00-06:00)
2024-05-21 14:54:20,389 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [345] -    ExcludeFree: False
2024-05-21 14:54:20,389 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [346] -    ExcludeTentative: False
2024-05-21 14:54:20,389 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [347] -    ExcludePrivate: False
2024-05-21 14:54:20,390 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [348] -    ExcludeAllDay: False; that are marked Free: False
2024-05-21 14:54:20,390 INFO  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [349] -    ExcludeSubject: True; Regex: ^((?!Mobiles Arbeiten).)*$
2024-05-21 14:54:20,635 DEBUG  1 OutlookGoogleCalendarSync.Telemetry [144] -  Retrieving URL: https://www.google-analytics.com/collec...
2024-05-21 14:54:20,638 DEBUG  1 OutlookGoogleCalendarSync.Telemetry [228] -  GA4: {"client_id":"...","user_id":"...","non_personalized_ads":true,"user_properties":{"ogcs_version":{"value":"2.10.5.0"},"benefactor":{"value":"False"},"account_present":{"value":"True"},"profiles":{"value":"2"},"outlook_version":{"value":"16.0.0.17425"},"outlook_name":{"value":"O365HomePremRetail"},"continent":{"value":"Europe"},"country":{"value":"Germany"},"country_code":{"value":"DE"},"region":{"value":"..."},"city":{"value":"..."}},"events":[{"name":"sync","params":{"type":"calendar","sync_count":6455}}]}
2024-05-21 14:54:20,639 DEBUG  1 OutlookGoogleCalendarSync.Console [231] -  Sync version: 2.10.5.0
2024-05-21 14:54:20,639 DEBUG  1 OutlookGoogleCalendarSync.Console [231] -  Profile: Paul
2024-05-21 14:54:20,639 DEBUG  1 OutlookGoogleCalendarSync.Console [231] -  Sync started at 21.05.2024 14:54:20
2024-05-21 14:54:20,640 DEBUG  1 OutlookGoogleCalendarSync.Console [231] -  Syncing from 20.05.2024 to 21.07.2024
2024-05-21 14:54:20,640 DEBUG  1 OutlookGoogleCalendarSync.Console [231] -  Outlook → Google
2024-05-21 14:54:20,902 WARN  1 OutlookGoogleCalendarSync.Telemetry [286] -  Failed to access URL 
2024-05-21 14:54:20,902 FAIL  1 OutlookGoogleCalendarSync.Telemetry [286] -  Der Remotename konnte nicht aufgelöst werden: 'www.google-analytics.com'
2024-05-21 14:54:20,903 WARN  1 OutlookGoogleCalendarSync.Telemetry [286] -  Failed to access URL 
2024-05-21 14:54:20,903 FAIL  1 OutlookGoogleCalendarSync.Telemetry [286] -  Der Remotename konnte nicht aufgelöst werden: 'www.google-analytics.com'
2024-05-21 14:54:20,916 DEBUG  1 OutlookGoogleCalendarSync.SettingsStore.Calendar [238] -  Changing active settings profile: Paul
2024-05-21 14:54:20,924 INFO  1 OutlookGoogleCalendarSync.Outlook.Calendar [75] -  Resetting connection to Outlook.
2024-05-21 14:54:20,924 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [120] -  De-referencing all Outlook application objects.
2024-05-21 14:54:20,960 INFO  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [135] -  Disconnecting from Outlook application.
2024-05-21 14:54:21,117 INFO  1 OutlookGoogleCalendarSync.Outlook.Calendar [1107] -  Attaching to the already running Outlook process.
2024-05-21 14:54:21,120 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [31] -  Setting up Outlook connection.
2024-05-21 14:54:21,123 INFO  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [50] -  Exchange server version: 15.20.7611.13
2024-05-21 14:54:21,124 INFO  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [52] -  Exchange connection mode: olCachedConnectedFull
2024-05-21 14:54:21,127 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [266] -  Getting active window inspector
2024-05-21 14:54:21,132 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [271] -  Done.
2024-05-21 14:54:21,145 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [67] -  Get the folders configured in Outlook
2024-05-21 14:54:21,148 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [374] -  Finding shared calendar
2024-05-21 14:54:21,301 DEBUG  1 OutlookGoogleCalendarSync.Outlook.Categories [147] -  Accessing categories through Outlook 2010 store.
2024-05-21 14:54:21,303 WARN  1 OutlookGoogleCalendarSync.Outlook.Errors [32] -  [0x80004003] >> Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
2024-05-21 14:54:21,304 WARN  1 OutlookGoogleCalendarSync.Outlook.Categories [159] -  Failed getting non-default mailbox categories. Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
2024-05-21 14:54:21,304 DEBUG  1 OutlookGoogleCalendarSync.Outlook.Categories [160] -  Reverting to default mailbox categories.
2024-05-21 14:54:21,310 INFO  1 OutlookGoogleCalendarSync.Outlook.ExplorerWatcher [20] -  Setting up Explorer event watchers.
2024-05-21 14:54:21,312 DEBUG  1 OutlookGoogleCalendarSync.Outlook.ExplorerWatcher [21] -  Watcher needed for 1 existing explorers.
2024-05-21 14:54:21,315 DEBUG  1 OutlookGoogleCalendarSync.Outlook.ExplorerWatcher [35] -  Adding listener for Explorer 'Posteingang - H***********n@domain.com - Outlook'
2024-05-21 14:54:21,329 DEBUG  1 OutlookGoogleCalendarSync.Outlook.OutlookNew [731] -  Refreshing categories...
2024-05-21 14:54:21,332 DEBUG  1 OutlookGoogleCalendarSync.Outlook.Categories [147] -  Accessing categories through Outlook 2010 store.
2024-05-21 14:54:21,332 WARN  1 OutlookGoogleCalendarSync.Outlook.Errors [32] -  [0x80004003] >> Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
2024-05-21 14:54:21,333 WARN  1 OutlookGoogleCalendarSync.Outlook.Categories [159] -  Failed getting non-default mailbox categories. Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
2024-05-21 14:54:21,333 DEBUG  1 OutlookGoogleCalendarSync.Outlook.Categories [160] -  Reverting to default mailbox categories.
2024-05-21 14:54:21,374 DEBUG  1 OutlookGoogleCalendarSync.Forms.Main [311] -  Find calendar folders
2024-05-21 14:54:29,356 WARN  1 OutlookGoogleCalendarSync.Exception [19] -  Failed to get EntryID for folder: Archive
2024-05-21 14:54:29,357 FAIL  1 OutlookGoogleCalendarSync.Exception [22] -  System.Runtime.InteropServices.COMException: Die Datei '\\?\UNC\... - local archive - \Outlook\archive.pst' kann nicht gespeichert werden, da ein Fehler aufgetreten ist. Schließen Sie alle Anwendungen, die mit E-Mail in Verbindung stehen, und starten Sie sie erneut. Möglicherweise müssen Sie den Computer neu starten.
2024-05-21 14:54:29,358 FAIL  1 OutlookGoogleCalendarSync.Exception [22] -  Code: 0x8C54011D,-1940651747; Location: get_EntryID() in <Unknown File>
2024-05-21 14:54:29,365 DEBUG  1 OutlookGoogleCalendarSync.Forms.Main [347] -  List Calendar folders
2024-05-21 14:54:29,368 WARN  1 OutlookGoogleCalendarSync.Forms.Main [1409] -  Outlook calendar selection changed to: Kalender (ID: 00000000FBA5182E170E594881DB6CF99AF7EEEFE0C2CC00000000010D0000)
2024-05-21 14:54:29,433 INFO  14 OutlookGoogleCalendarSync.Console [351] -  Finding Calendar Entries
2024-05-21 14:54:29,548 INFO  14 OutlookGoogleCalendarSync.Console [351] -  Scanning Outlook calendar...
2024-05-21 14:54:29,634 ERROR  14 OutlookGoogleCalendarSync.Console [347] -  Unable to access the Outlook calendar.
2024-05-21 14:54:30,008 WARN  14 OutlookGoogleCalendarSync.Outlook.Errors [32] -  [0x80070005] >> Sie besitzen nicht die erforderlichen Berechtigungen, um diesen Vorgang auszuführen. Wenden Sie sich an die Kontaktperson dieses Ordners oder an Ihren Administrator.
2024-05-21 14:54:30,009 ERROR  14 OutlookGoogleCalendarSync.Exception [29] -  System.UnauthorizedAccessException: Sie besitzen nicht die erforderlichen Berechtigungen, um diesen Vorgang auszuführen. Wenden Sie sich an die Kontaktperson dieses Ordners oder an Ihren Administrator.
2024-05-21 14:54:30,015 ERROR  14 OutlookGoogleCalendarSync.Exception [22] -  Code: 0x80070005,-2147024891; Location: get_Count() in <Unknown File>
2024-05-21 14:54:30,017 ERROR  14 OutlookGoogleCalendarSync.Exception [66] -     bei Microsoft.Office.Interop.Outlook._Items.get_Count()
   bei OutlookGoogleCalendarSync.Outlook.Calendar.FilterCalendarEntries(Calendar profile, Boolean filterBySettings, Boolean noDateFilter, String extraFilter, Boolean suppressAdvisories) in C:\Users\Paul\Git\OutlookGoogleCalendarSync\src\OutlookGoogleCalendarSync\Outlook\OutlookCalendar.cs:Zeile 161.
   bei OutlookGoogleCalendarSync.Outlook.Calendar.GetCalendarEntriesInRange(Calendar profile, Boolean suppressAdvisories) in C:\Users\Paul\Git\OutlookGoogleCalendarSync\src\OutlookGoogleCalendarSync\Outlook\OutlookCalendar.cs:Zeile 136.
   bei OutlookGoogleCalendarSync.Sync.Engine.Calendar.synchronize() in C:\Users\Paul\Git\OutlookGoogleCalendarSync\src\OutlookGoogleCalendarSync\Sync\Calendar.cs:Zeile 307.
   bei OutlookGoogleCalendarSync.Sync.Engine.Calendar.<>c__DisplayClass11_1.<StartSync>b__0(Object o, DoWorkEventArgs args) in C:\Users\Paul\Git\OutlookGoogleCalendarSync\src\OutlookGoogleCalendarSync\Sync\Calendar.cs:Zeile 134.
2024-05-21 14:54:30,017 ERROR  14 OutlookGoogleCalendarSync.Console [347] -  Sie besitzen nicht die erforderlichen Berechtigungen, um diesen Vorgang auszuführen. Wenden Sie sich an die Kontaktperson dieses Ordners oder an Ihren Administrator.
2024-05-21 14:54:30,484 DEBUG  1 OutlookGoogleCalendarSync.Extensions.MessageBox [75] -  Sync Failed: The synchronisation failed - check the Sync tab for further details.
Do you want to try again?
2024-05-21 14:54:30,513 INFO  1 OutlookGoogleCalendarSync.Forms.Main [1025] -  Application window restored.
2024-05-21 14:54:33,883 DEBUG  1 OutlookGoogleCalendarSync.Extensions.MessageBox [91] -  Response: No
2024-05-21 14:54:33,884 INFO  1 OutlookGoogleCalendarSync.Sync.Engine+Calendar [99] -  User opted to abandon further syncs.
2024-05-21 14:54:33,885 ERROR  1 OutlookGoogleCalendarSync.Console [347] -  Sync aborted after 1 failed attempts!
2024-05-21 14:54:33,902 INFO  1 OutlookGoogleCalendarSync.Console [351] -  Another sync has been scheduled to automatically run in 15 minutes time.
2024-05-21 14:54:33,917 INFO  1 OutlookGoogleCalendarSync.Sync.SyncTimer [103] -  Next sync scheduled for profile 'Paul' at Dienstag, 21. Mai 2024 @ 15:09:33
2024-05-21 14:54:33,918 DEBUG  1 OutlookGoogleCalendarSync.Sync.Engine [98] -  ActiveProfile set to: None

I suspect the path "C:\Users\Paul\Git\OutlookGoogleCalendarSync..." since my user is not Paul, but the new profile name in OGCS and not the installation path of OGCS...

The pertinent error message when trying to access the items in the shared calendar is "Sie besitzen nicht die erforderlichen Berechtigungen, um diesen Vorgang auszuführen. Wenden Sie sich an die Kontaktperson dieses Ordners oder an Ihren Administrator." - so it seems you need more permissions than you currently have 🙁

Hmm.. I found out, that his calendar shows up as calendar in my mailbox and works now. So I did not get it to work via "Shared calendar". I don't know which rights are missing. He shares his calendar with the whole company excluding details. But even with disabled options "Location" and "Description" or by pressing "Test" it shows the error 🤨

Yeah it's failing on just trying to count the number of items in the shared calendar, so it's not really functional at all.

Glad you got it working as a standard calendar in your mailbox though!