Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Meeting Tracking #363

Open
inghamn opened this issue Sep 19, 2024 · 4 comments
Open

Meeting Tracking #363

inghamn opened this issue Sep 19, 2024 · 4 comments
Assignees

Comments

@inghamn
Copy link
Member

inghamn commented Sep 19, 2024

So far, OnBoard has never tracked meetings themselves; instead, we've relied on the Google Calendar to be the official meeting. This has limited us and caused some unexpected problems.

For instance, the meeting files sometimes happen to have the same date as the event in the Google Calendar, but not always. The Google Calendar Event can be changed, but no one goes back in and updates the dates on the meeting files, so they're no longer correlated.

We also want to start keeping track of meeting attendance, but do not have a place in the OnBoard database to associate with the meeting.

OnBoard likely needs meetings to be represented in the database. We'll need to figure out how we want to keep the database information in sync with what's in Google Calendar.

@rbdietz
Copy link
Member

rbdietz commented Sep 26, 2024

Liaison needs to be notified periodically of status of boardmembers vis-s-vis remote meeting participation. Need to clearly flag that a member has done too many remote meetings and has to attend in person or cannot vote.

@inghamn
Copy link
Member Author

inghamn commented Oct 10, 2024

Google Calendar API has recommended way of keeping event information in sync.
https://developers.google.com/calendar/api/guides/sync

inghamn added a commit that referenced this issue Oct 10, 2024
Create individual meeting records by reading times from Google Calendar events.  If there is no event for, the use the regularly scheduled time for each committee.

Updates #363
inghamn added a commit that referenced this issue Oct 11, 2024
Meetings are now coming from the database, rather than directly from Google Calendar.  We'll still need to figure out the best way to keep in sync with Google Calendars.

Updates #363
Updates #310
inghamn added a commit that referenced this issue Oct 14, 2024
Now that we have a table of meetings, the meeting information is stored in Meetings, not in the MeetingFiles table.

Updates #363
inghamn added a commit that referenced this issue Oct 16, 2024
Update the database meetings with information from Google Calendars using a CRON.  The plan is hourly so far.

Updates #363
@inghamn
Copy link
Member Author

inghamn commented Nov 19, 2024

We can probably set up push notifications from Google for calendar events.

https://developers.google.com/calendar/api/guides/push
https://cloud.google.com/monitoring/support/notification-options#webhooks

inghamn added a commit that referenced this issue Jan 3, 2025
This lets Committees sync calendar events, rather than needing to request a full calendar's worth of events.

This also sets the stage for registering a watch on a calendar so we can receive push notifications when something on a calendar changes.

Updates #363
@inghamn
Copy link
Member Author

inghamn commented Jan 3, 2025

We still need to pin down what should be done with OnBoard meetings when someone deletes a Google Calendar event.

inghamn added a commit that referenced this issue Jan 17, 2025
This lets Committees sync calendar events, rather than needing to request a full calendar's worth of events.

This also sets the stage for registering a watch on a calendar so we can receive push notifications when something on a calendar changes.

Updates #363
inghamn added a commit that referenced this issue Jan 24, 2025
This lets Committees sync calendar events, rather than needing to request a full calendar's worth of events.

This also sets the stage for registering a watch on a calendar so we can receive push notifications when something on a calendar changes.

Updates #363
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants