If it is sending from now until 30 minutes later, the name of your sys_impex_map record is wrong. It HAS to be
icalendar.{table_name} so therefore there can only be one record per table in the sys_impex_map table.

Hope this helps!

I was having the same issue and found it was due to not naming my Import Export Map correctly. The mapping must be named “icalendar.” or it will not work. I found this in http://wiki.servicenow.com/index.php?title=Email_Templates#Creating_iCalendar_Invitations_for_Custom_Tables.

Hopefully this helps some of you having the same issue.

Hi Valor,

Please share the fix, i having the same issue which the event start time is request time date and end date is always is30 mins later.
Actually i tried to send the calendar notification based on the request variable by using the sc_req_variables. i created import export mapping in sc_req_variables mapping field as question

Thanks
Senthil.R

http://wiki.servicenow.com/index.php?title=Email_Templates#Creating_iCalendar_Invitations_for_Custom_Tables

I’m having the same issue. Did you ever come up with a solution?

I was hoping to use a mail script to do this, which needs to be done in the email notification (since mail scripts don’t work in templates).
However, I can’t get a correct iCalendar invite to go out using just the email notification, even when I hard-code everything in it to a plain-text (non-scripted) calendar invite! It says in this article that it’s possible…

Email notification Options:
Type is Meeting Invitation, the content type is HTML and plain text, and I’m omitting the watermark.

Every time the iCalendar email I attempted to create is sent out, the message body is blank.
(In WORKING iCalendar emails using the email template method, the message body is NOT blank.)

We’re running Calgary.

Has ANYONE managed to get an iCalendar invite sent out correctly if just using the email notification and NOT using an email template?

Thanks!
-Rita

I’ve used the “Insert & Stay” approach to exactly copy all required records (sys_impex mapping, notification, template) and so far I can conclude that this functionality is not working for custom tables. I will try to get some help from ServiceNow; hopefully they can help us out.

Regards,
Bas

In our instance I created date fields on the Task Form named Begin Time and Date and End Time and Date.

Navigated to sys_impex_map.list
Mapped Name: icalendar.sc_task
Mapped Table: Catalog Task
Type: icalendar
Mapped u_end_time_and_date to external name dtend on the sc_task Table.
Mapped u_begin_time_and_date to external name dtstart on the sc_task Table.

Here’s the rest of my work.

Business Rule Created (upon Insert and Update on the Catalog Task Table. Named icalendar.sc_task)
if (current.u_begin_time_and_date.changes() || current.u_end_time_and_date.changes() || current.assigned_to.changes()) {
if (!current.u_begin_time_and_date.nil() && !current.u_end_time_and_date.nil() && !current.assigned_to.nil()) {
gs.eventQueue(“icalender.sc_task.inserted”, current, current.assigned_to, previous.assigned_to);
}

// Remove from previous assigned to, due to assigned to changing
if (!previous.assigned_to.nil()) {
if (!current.assigned_to.nil() && current.assigned_to.changes() &&
(!previous.u_begin_time_and_date.nil() && !u_end_time_and_date.nil())) {
gs.eventQueue(“icalender.sc_task.updated”, current, current.assigned_to, previous.assigned_to);
}
}
// Remove old calendar from current assigned to, due to date changing
else if (!current.assigned_to.nil()) {
if ((u_begin_time_and_date.changes() && !previous.u_end_time_and_date.nil()) ||
(current.u_end_time_and_date.changes() && !previous.u_end_time_and_date.nil())) {
gs.eventQueue(“icalender.sc_task.notify.remove”, current, current.assigned_to, current.assigned_to);
}
}

}

Event Registry Entries Created on the Catalog Task Table named icalender.sc_task.inserted, icalender.sc_task.updated and icalender.sc_task.remove

Email Template for New Invite and when time changes it sends an updated invite…
BEGIN:VCALENDAR
PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=FALSE:MAILTO:company@service-now.com
ORGANIZER:MAILTO:company@service-now.com
DTSTART:${dtstart}
DTEND:${dtend}
LOCATION:${location}
TRANSP:OPAQUE
SEQUENCE:${sys_mod_count}
UID:${sys_id}
DTSTAMP:${dtstamp}
DESCRIPTION:${description}
SUMMARY:${summary}
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC

Template for Cancel
BEGIN:VCALENDAR
PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:CANCEL
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=FALSE:MAILTO:wagged@service-now.com
ORGANIZER:MAILTO:wagged@service-now.com
DTSTART:${dtstart}
DTEND:${dtend}
LOCATION:${location}
TRANSP:OPAQUE
SEQUENCE:${sys_mod_count}
UID:${sys_id}
DTSTAMP:${dtstamp}
DESCRIPTION:${description}
SUMMARY:${summary}
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
STATUS:CANCELLED
END:VEVENT
END:VCALENDAR

Triggered Email Notifications using insert of time on said fields on form, update to fields and when some chooses cancel as the category.

Any update on this? I am having the same issue in which the event start time is the time the email was sent and the end time is always 30 min later. Please Help