How to configure Meeting Invitation to Outlook?

jenny32
Tera Guru

Hi All,

I have been trying to send Meeting Invitation to Outlook. I have created Email Template and import export map ( from Email Templates - ServiceNow Wiki ).I have been able to send an email with "not supported calendar message.ics" file attachment.   When i open that attachment in notepad, the content is same as the template message.

I have used this code in Email Template.

Message Text:

BEGIN:VCALENDAR

PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN

VERSION:2.0  

METHOD:REQUEST

BEGIN:VEVENT

ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:${to}

ORGANIZER:MAILTO:${from}

DTSTART:${dtstart}  

DTEND:${dtend}  

UID:${sys_id}  

DTSTAMP:${dtstamp}  

DESCRIPTION:${u_description}

X-MICROSOFT-CDO-BUSYSTATUS:BUSY  

X-MICROSOFT-DISALLOW-COUNTER:TRUE  

X-SNSYSID:{$sys_id}  

BEGIN:VALARM  

TRIGGER:-PT15M  

ACTION:DISPLAY  

DESCRIPTION:Reminder  

END:VALARM  

END:VEVENT

END:VCALENDAR

In my Email Notification,type is Meeting Invitation.

When i check in Email log(outgoing mail), the body field is empty.

Can anyone tell where i am going wrong?

Thanks,

Jennifer

1 ACCEPTED SOLUTION

I'd recommend heading back to the sys_impex_map table and looking there. The new record you added into this table needs to be name icalendar.your_table_name . Also ensure that the fields you are referencing for dtstart and dtend are date/time fields. Not just date fields.



Going to shamelessly self plug an article I whipped together as well: ServiceNow Calendar Invites - Bradford Shelley



I apologize for the poor formatting. Hopefully the gibberish I've typed in there can help out as well.


View solution in original post

30 REPLIES 30

Hmmm the behavior is indicative of needing "Send to Event Creator" checked off since emails normally won't be sent to yourself if you're the one generating it. At the same time I remember your previous comment about trying to check it off and nothing happening. Beyond that I'm not quite sure what is going wrong unfortunately.


Hello Jenny, I found this thread and got the same issue that you had with the file named "not supported calendar message.ics". It seems that you solved it when writing this post. Do you recall what your issue was and how you got the invitation to show up in Outlook?


Hey Henrik,



Noticed you posted into my thread talking a bit more in depth about calendar invites, but wanted to throw the link to the troubleshooting portion of the write up in here just in case: https://community.servicenow.com/docs/DOC-5811#troubleshooting



In a nutshell:


  • Make sure that the notification Type is a Meeting Invitation, that the Content type is Plain text only, and that you are using an Email Template to house the iCalendar code.
  • From there, check to make sure that your iCalendar code is placed in the Message Box or Message Text Box in the template, and not the Message HTML Box if you are using Eureka or higher versions of ServiceNow
  • Finally check to make sure that you have created and mapped your fields in the sys_impex_map table.


Hope everything gets solved!


Hi Bradford and thanks for the feedback to my post.


I've done everything according to your three bullets except using an email template thinking that would not have the impact of if the meeting invitation. I'll take a look at that specific part right away and let you know right after that.



Cheers!


Ok, so it appears that I has to be sent using a template and not just enter the text into the "Message text" box using plain text.


A bit odd and to me it sounds like a bug/feature, but really good to find the issue behind the irritating error!



Thanks a lot Bradford!