Google Meet and Teams Meetings Issue

[Juelicher-Trainee]

Hi,

I am not very skilled but I did manage to set up this sync service for a smaller 3rd party calendar. Entries are being copied into my Google Calendar, where I collect the various calendar sources. Works well, thank you.

What does not work: Ig I have a Google Meet entry in the source calendar, it will appear correctly in my destination Google Calendar, BUT it will not contain the URL of the Meeting.
I exported the entry from the source calendar and looked at the ICS file. The URL appears twice

1. In the field DESCRIPTION
2. In the field X-GOOGLE-CONFERENCE
   But the synced entry in the target calendar does not contain either! The DESCRIPTION is cut before the URL appears and the X-GOOGLE-CONFERENCE field does not exist at all.

A similar thing happens with some of the Microsoft TEAMS meetings (but not with all):
The export shows that the URL is in

1. In the field DESCRIPTION
2. In the field X-MICROSOFT-SKYPETEAMSMEETINGURL
   The difference between the two behaviors seem to be: If the URL is at the beginning of the field DESCRIPTION, all is well. If there is a lot of text in that field and the URL comes way down in the text, it does not show in the target calendar.

I don't know what to do, perhaps the fields
X-GOOGLE-CONFERENCE
and
X-MICROSOFT-SKYPETEAMSMEETINGURL
could be added to the synced fields, or the entire DESCRIPTION field would have to be synced.

Or is there any other was to fix this problem?

Thank you for any help,

JT

[jonas0b1011001]

Maybe this is related to #266 ?

[Juelicher-Trainee]

Thank you, it must be.

First I thought that I can simply assign the fields that contain the URL to
X-GOOGLE-CONFERENCE
But that doesn't help. If it is not a real Google Meet conference, a new Meet conference ID will be created and inserted. The only solution is then to make sure that the DESCRIPTION field is not truncated.
Unfortunately, every Conferencing tool uses a different separator, so I will have to see if I can make it work along the lines of #266.

Thanks,
JT

[jonas0b1011001]

Have a look at

GAS-ICS-Sync/Helpers.gs

Line 719 in e0f8c14

if (event.hasProperty('url') && event.getFirstPropertyValue('url').toString().substring(0,4) == 'http'){

You can check if X-GOOGLE-CONFERENCE or X-MICROSOFT-SKYPETEAMSMEETINGURL exists and use that value to set newEvent.source.url.

[Juelicher-Trainee]

Thank you. I think I know what I would have to do. Alas, I cannot do it, I messed up my old script, too and nothing works anymore.
So I wanted to revert to a clean sheet and started to "copy" the current version and configure it from:
https://github.com/derekantrican/GAS-ICS-Sync/tree/e0f8c14ffc8ebadcba9e12fc9307c789f83367af
But what I get if I click this link is an old version of the script not the new one. I notice this by looking at the Helpers.gs file, which would have to be longer now than 1122 lines and there would have to be a filters.gs file, too.

Apologies, I am very much of a beginner. I cannot revert to the working version, either. Bummer.

Thanks for any help.

JT

[Juelicher-Trainee]

Never mind, I was desperate enough to copy the contents of all files from the new version into the ones that copying the project via the link in README produced and added the missing filters.gs file. The script works again.

I also added after this code in helpers.gs (lines 719-725):

if (event.hasProperty('url') && event.getFirstPropertyValue('url').toString().substring(0,4) == 'http'){
    newEvent.source = callWithBackoff(function() {
          return Calendar.newEventSource();
        }, defaultMaxRetries);
    newEvent.source.url = event.getFirstPropertyValue('url').toString();
    newEvent.source.title = 'link';
  }

the following new code

`
// For Infomaniak: Check if X-INFOMANIAK-MEET-ROOM-URL exists and starts with 'https://'
if(event.hasProperty('X-INFOMANIAK-MEET-ROOM-URL') && event.X-INFOMANIAK-MEET-ROOM-URL.startsWith('https://')){
newEvent.source.url = event.X-INFOMANIAK-MEET-ROOM-URL;
newEvent.source.title = 'kMeet link: ';

  Logger.log("kMeet URL fixing reached: " + newEvent.source.url);

}

// For Teams: Check if X-MICROSOFT-SKYPETEAMSMEETINGURL exists and starts with 'https://'
if(event.hasProperty('X-MICROSOFT-SKYPETEAMSMEETINGURL') && event.X-MICROSOFT-SKYPETEAMSMEETINGURL.startsWith('https://')){
newEvent.source.url = event.X-MICROSOFT-SKYPETEAMSMEETINGURL;
newEvent.source.title = 'Teams link: ';

  Logger.log("Teams URL fixing reached: " + newEvent.source.url);

}

// For Google Meet: Check if X-GOOGLE-CONFERENCE exists and starts with 'https://'
if(event.hasProperty('X-GOOGLE-CONFERENCE') && event.X-GOOGLE-CONFERENCE.startsWith('https://')){
newEvent.source.url = event.X-GOOGLE-CONFERENCE;
newEvent.source.title = 'Google Meet link: ';

  Logger.log("Google Meet URL fixing reached: " + newEvent.source.url);

}

// For Zoom: Check if LOCATION exists and starts with 'https://' and contains the word 'zoom'
if(event.hasProperty('LOCATION') && event.LOCATION.startsWith('https://') && event.LOCATION.includes('zoom')){
newEvent.source.url = event.LOCATION;
newEvent.source.title = 'Zoom link: ';

  Logger.log("Zoom URL fixing reached. newEvent.source.url:" + newEvent.source.url);

}
`

Amazingly, it almost works the way I want it (even though I don't really understand what I am doing, as evidenced by the total lack of the Logging Information I wanted to have with the Logger.log() lines).

More precisely: it works for TEAMS, ZOOM and KMEET calls!

But it does not work for Google Meet calls, which have this line in the ICS file if the calendar entry is exported from the source calendar. e.g.:

X-GOOGLE-CONFERENCE:https://meet.google.com/tbo-mbqs-czb

The assignments newEvent.source.title = 'Whatever link: '; do not seem to make any difference and they do not show up anywhere, afaics, but this is not a problem for me.

Since I cannot debug (lack of skills) and don't see / can't generate or find the logging information, I can't go any further. It seems that the Google Meet code above is not executed at all.

It would be very nice to find the problem of these Google Meet URL-s.

Thanks,

JT

[Juelicher-Trainee]

Now, with the addition of this suggestion of yours:

#266 (comment)

i.e.

newEvent.description = icalEvent.description.replace("-", "");

instead of the original on line 758 of helpers.gs

newEvent.description = icalEvent.description;

Everything seem to work as it should, i.e. calendar entries with TEAMS, ZOOM, GOOGLE MEET and KMEET (Infomaniak) video call URL-s are supported!

Thank you very much, I am a happy camper now.

Cheers,

JT