Is there a way to Import an On-call Calendar from an Excel Spreadsheet

[troyholmes]

I have a team that has created a fairly complicated formula using excel to create an On-Call schedule. Is there a way to import their on-call schedule from an excel spreadsheet to create their on-call calendar?

[Jace Benson]

You can import anything into servicenow, via the transform maps.  Just would take some time to line up the columns to servicenow's columns.

Further reading;

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/script/server-scripting/conc...

[troyholmes]

I knew that I import data all the time I am struggling with which table houses the on-call calendar.

[Jace Benson]

The oncall plugin is old.  Like really old.  It's fine but it has some interesting choices about it.

If you wanted to import it manually, i'd recomend creating a Scheduled Entry

Further Reading: https://docs.servicenow.com/bundle/istanbul-it-service-management/page/administer/on-call-scheduling...

Now a few things to note, the when might be an odd field type and formatting their oncall to match that stuff might be interesting.

I'd tie them to cmn_schedule_span until they can similify their oncall rotation.