Calendar Sync Tool

The calendar sync tool allows you to copy events from a selected calendar to the mcc_website_public calendar which is shown on our website.  It also allows bulk deletion from the destination calendar.  

This tool allows the following

• Copying events from a source calendar to a destination calendar. 

• Deleting all entries in a range from the destination calendar. 

Basic operations

• • Allows selecting a source calendar and destination calendar. (for syncing and deleting)

  • selecting a date range for syncing and deleting

Syncing Events from Source to Destination 

• • finding and selecting events to be copied.   

  • It distinguishes between Single events, Series events, and modified Series events. 

  • Allows selecting individual items or groups to be copied. 

  • copies the events. The guests and details are stripped out to protect peoples privacy.  You should choose titles carefully when creating appointments to avoid disclosing private information. 

Deleting Events from the Destination

• • Deleting all events in the range from the destination calendar. (The tool does not change the source calendar)

  • To delete individual events use the google calendar directly.  

  • Alternatively, you could delete the whole range and then sync events to the calendar.  

  • To clear the whole calendar, change the range and be sure to choose 

Details

• • Guests and event details are not copied to the destination. You could manually add these to the public calendar.  

  • When copying a modified series it makes a new copy and updates the title to support syncing (sometimes people change titles to add informative info).  

  • When deleting a series, Selecting "This instance only" will delete just the single event.  Selecting "All Time (series)" will delete the whole series past and future events.  

Prerequisites and Setup:

• You must have r/w permission to the destination calendar. ("make changes to events")

• You must have read access to the source calendar ("see all events details"). If you have only free busy, you'll get un-titled events.  

• You may need to approve permissions for this app and enter your own google credentials (login). 

• The button at the bottom opens the tool in a new window.  

Calendar Sync Tool

Open Calendar Sync Tool in a new window

Old Calendar Page Script

This is our old calendar page script which shows a clean version of the calendar. (dropping descriptions).    

Just in case we want to go back.  

https://script.google.com/macros/s/AKfycbxPzLNdelfJR8BAtD26sSexcbRQ4nh0q5QRd6fxzSjjG2Ne-d2naTvQuoz8WKzCRWyK/exec