iCalendar (.ics) file and email body

[geoffcox]

I have succeeded in getting an iCalendar attachment (.ics file) on an email message. Now, however, the body of the email is empty. Is there a way to populate the body of the email message AND attach an .ics file on the same email?

[Bhupinder1]

Hi Geoff,

Need your help on Icalendar issue.

I'm running into issue with Integration of ServiceNow and Gmail calendar for meeting invites in the change management process. Here's the summary-

1. Change Request is integrated with Gmail calendar (which uses ICS format) and meeting invites are sent properly which is working well

2. Issue 1 - Meeting Cancellation invites are not working well. If I change Assignee or Planned Start/End date then new meeting invitation is sent but old meeting invites are not removed from user's calendar though the user's are getting cancellation email.

3. Issue 2 - Cancellation email being sent captures the current planned and start date but not the previous dates. How can we use the previous dates?

Action taken so far

I have taken below action so far to handle the Issue 1 but still no luck.

Action 1: Updated Import Export Map icalendar.change_request listed in the table sys_impex_map.list. In this I added new field mapping for sys_id and UID as below

Action2: Updated two email templates change.calendar.integration and change.calendar.integration.remove   updated the mapping in the message field from UID:${uid} to UID:${sys_id}.

After making all the above changes Issue 1   is still not resolved. Also, I haven't thought on Issue2. any help on both issues would be much appreciated.

Regards

Bhupinder

[geoffcox]

Hi, sorry for the delayed reply (just got back from vacation).

I suggest you launch a new thread with your question so that the existing thread doesn't go off in a strange direction, and other users can chime in on the new subject.

Plus, unfortunately I haven't any experience in sending cancellation emails. If I do any further work on .ics emails, I'll try to do some testing around cancellations.

[Bhupinder1]

Thanks for response. In fact I was able to resolve the issue so may not create new thread

[vinothkumar]

Hi Bhupinder,

I have a requirement that needs to send meeting invite to the group, based on the selection of date and time variables, I have used two date time variables, say

1) URL date change

2) Cert Date Change

Whenever the user select the two dates in the request, it has to send the meeting invite to the group. I   have created a email notification with type as meeting invitation, but when i trigger that event in the workflow, I am getting the attachment in the email as Not Supported Calender Message.

FYI, Am also using one more variable in the same catalog item and also created in import/export table and this was set as $[dstart] in request item table and for this one it was working as expected.

Can any one help me how to send, two meeting invite to the same request based on the date time variable?

Thanks in Advance for your help!!

Regards,

Vinoth kumar M

[Bhupinder1]

Hi Vinoth,

I think you need to create import export map for below variables and match to dtstart/dtend only then it should create entry in calendar-

1) URL date change

2) Cert Date Change

Also, as far as I know you will be able to create 1 field map per field and what I understood from your above post that you want to map two variables to dtstart field on conditional basis and if its true this needs to be yet explored by me.