freescout icon indicating copy to clipboard operation
freescout copied to clipboard

ics calendar attachments not displayed in MS Teams invitations

Open endoflevelboss opened this issue 3 years ago • 13 comments

Is there any special feature that handles ics calendar attachments differently from other attachments? I can find the ics attachments stored in app/attachment but they are not at all displayed in the respective conversation. All other attachment types are displayed. Anything I can check or configure to make these attachments become visible?

Any pointer is highly appreciated. Thanks in advance.

endoflevelboss avatar Jun 17 '22 15:06 endoflevelboss

Sorry. Duplicate of #1412 and #1003

endoflevelboss avatar Jun 17 '22 15:06 endoflevelboss

Can you send a test email to [email protected]

freescout-helpdesk avatar Jun 18 '22 14:06 freescout-helpdesk

Done. Thanks!

endoflevelboss avatar Jun 18 '22 15:06 endoflevelboss

The .ics file is received and can be downloaded.

2022-06-18_18-12-42

freescout-helpdesk avatar Jun 18 '22 15:06 freescout-helpdesk

Weird. Checking the attachments table in the database shows that all (at least all I checked) ics attachments are in the database. They are also saved to the app/storage folder. However, they are still not displayed in the conversation. I'll try to dig a little deeper later.

Anything I can check in my particular installation? Can you think of any locale or other settings that could affect whether a file is displayed?

endoflevelboss avatar Jun 18 '22 15:06 endoflevelboss

It's hard to tell what may cause this. It need to be debugged.

freescout-helpdesk avatar Jun 18 '22 16:06 freescout-helpdesk

Try to find .ics attachment in attachments table and check embedded field. If embedded=true it means the attachment by some reason has been detected as embedded in the text of the message (like embedded image).

freescout-helpdesk avatar Jun 19 '22 08:06 freescout-helpdesk

Just checked. None of the ics files in the attachments table is embedded. mime_type is correctly set to "text/calendar".

Additionally, I double checked a few random attachments (embedded and non-embedded) with the original emails and all of them are correctly registered as well.

endoflevelboss avatar Jun 20 '22 07:06 endoflevelboss

This is where attachment are being displayed: https://github.com/freescout-helpdesk/freescout/blob/dist/resources/views/conversations/partials/thread_attachments.blade.php

freescout-helpdesk avatar Jun 22 '22 07:06 freescout-helpdesk

Thank you for the pointer to the has_attachment flag I noticed only now. Checking a few samples indeed show conversations with "has_attachment 0" where actually an attachment was received. That's something I can start investigating from. I'll dig deeper for a pattern as soon as I can.

endoflevelboss avatar Jun 23 '22 11:06 endoflevelboss

Have you found a solution?

freescout-helpdesk avatar Jul 06 '22 06:07 freescout-helpdesk

AFK right now. I will continue to look into this hopefully next week when I‘m back to my desk.

endoflevelboss avatar Jul 06 '22 07:07 endoflevelboss

Finally I could do some more research. Here's my findings.

  1. There indeed are some ics attachments in the database. I was following a few entries back through the threads and conversation tables to locate the original email. Can't see any issues here. ics attachments are properly shown in the conversation!

None of the attachments has been "embedded", in case that's important.

  1. Going the other way round, I picked random invites from my inbox and followed them down through the freescout database. I could not see the pattern before, but all affected ics attachments are sent from M$ teams. I can't exclude that there are other sources that are also affected. I found invites with customized layouts that still seem to be sent from M$ Teams or derivatives.

Double checking, there is no single ics attachment (out of those M$ Teams invites I checked) properly stored in the database. All checked invites have "has_attachment=0" in the conversations table and nothing is in the attachments table consequently.

I think the problem lies with parsing the automated emails sent by M$ Teams. Unfortunately, I don't have access to M$ Teams and can't send you a test invite. Only thing I can do is providing you the header of an actual M$ Teams invite from my inbox.

Interestingly, the M$ Teams invites do not have the meeting date/time printed in the email plain text, what makes the missing attachment critical. Users can't make sense of the invite without access to the original email. Only M$ knows why this information is not in the email, just for convenience.

endoflevelboss avatar Jul 18 '22 08:07 endoflevelboss

Duplicate of https://github.com/freescout-helpdesk/freescout/issues/1412

freescout-helpdesk avatar Dec 19 '22 11:12 freescout-helpdesk