Bulk Create RITMs as Historical Information

Edi 8 · ‎10-10-2023

Hi Experts,

I had a question that is similar to this post, but slightly different: https://www.servicenow.com/community/developer-forum/create-bulk-ritm-and-single-request-from-excel/...

Background: we are sunsetting an application and moving processes into ServiceNow. We now need to migrate historical case details from the sunsetting application into SNOW for reference purposes.

Requirement:

- We have an excel file where each row has data for a single RITM/REQ

- We need to populate data from Excel into each RITM's variable(s) and fields on the RITM (sc_req_item) table

- We need to create these RITMs/REQs in an closed complete State and not trigger any notifications

Thank you in advance!

Edi

Edi 8 · ‎10-25-2023

I'm closing this thread as I was able to figure it out. For anyone out there who has a similar use case, I ended up creating records on each table: sc_request, sc_req_item, sc_item_option, sc_item_option in a loop. This way, you can update fields on the REQ/RITM table and also account for each variable that needs to be created.

View solution in original post

Ankur Bawiskar · ‎10-10-2023

@Edi 8

So what did you start with as per that link and where are you stuck?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Edi 8 · ‎10-11-2023

Hi @Ankur Bawiskar - I'm currently stuck with the onComplete transform script. I'm looking to get some help in updating the script in this post to meet my requirements.

Thank you,

Edi

Ankur Bawiskar · ‎10-11-2023

@Edi 8

Please share what you tried in onComplete transform script?

Have you written onComplete to mark state as close complete?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Edi 8 · ‎10-11-2023

I'm having issues updating this onComplete script as I'm seeing that it creates multiple RITMs under the same REQ. I'm also not finding a way to update columns on the RITM table (for example, setting it to close complete). If I can get some assistance with this part, and suggestions on not triggering notifications, I think I can update the rest.