How to configure Meeting Invitation to Outlook?

jenny32 · ‎09-14-2015

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

Bradford Shelle · ‎10-12-2015

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

kreddyT · ‎06-09-2016

Hi Bradford,

Thank you so much for you reply.

I wanted to be listed as organizer. Being an attendee is optional. When I tried,

1.adding "FROM" field to be my email address, but for some reason, when I receive an email it shows that it is sent from "instance email".

2. Checking off "Send to Event Creator", I didn't receive any email. The email is not even captured in email logs.

Please help me to find where I went wrong.

Bradford Shelle · ‎06-09-2016

I did a quick test in my personal instance where I set both the ORGANIZER:MAILTO: and the from field in the notification to a dummy email address, and I was able to see from the email log that the ORGANIZER:MAILTO is set to what I want it to be. Could you add a code snipped of what the email log is sending out so we can take a look at it?

kreddyT · ‎06-09-2016

Hi Bradford,

I set the FROM field in notification to my email address. Here are the screenshots,

1. for email template

2. in Email logs, it shows the instance email address.

I would be more than happy to provide you with any other information you may want.

Thank you. I really appreciate your help on this.

kreddyT · ‎06-09-2016

Hi Bradford,

I just tried something and organizer:mailto: shows my email address in email logs. But unfortunately, I didnt receive any email to my inbox. How can that happen? I can see an email sent in email logs but it is not in my inbox.

I set organizer to,

organizer:mailto:${u_assignee.email}

kreddyT · ‎06-10-2016

Hi Bradford,

Thank you so much for all the help. I was able to set myself as an organizer for the meeting invitation I am sending out but unfortunately, it is not added to my calendar. it is added to other participant's calendar only. So I added myself to the participants list, but in this case, I am not even receiving the email. How can I work around to get this meeting added to my calendar as well as my participants?