Create RITM from the Excel file

[Gopinath4]

Hi Friends, 

I have a service catalog item in which, an excel file will be uploaded and from that excel file, I need to create multiple RITMs .

I need to create multiple RITM's from each row of the Excel file.

How to do it.

Please help me..

[Ankur Bawiskar · Accepted solution]

Hi Gopinath,

you would require an after insert business rule on sc_req_item table with condition as Catalog Item is yours and if it has attachments

you need ExcelParser script to parse the excel row by row and create RITM with all the variable info

https://developer.servicenow.com/app.do#!/api_doc?v=newyork&id=GEPS-GlideExcelParser

this link will help you as well

https://community.servicenow.com/community?id=community_article&sys_id=9ed305e2db63fb845129a851ca961...

Script to create RITM with variable info

https://community.servicenow.com/community?id=community_question&sys_id=928a9f4ddb73ab805ed4a851ca96...

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Mohit Kaushik]

Hi Gopinath,

Please refer the below links, it might help you.

https://community.servicenow.com/community?id=community_question&sys_id=31318be5db98dbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=dd308b61db98dbc01dcaf3231f96...

Kindly mark this helpful if it helped you at all.

Thanks,

Mohit Kaushik

[Ankur Bawiskar]

Hi Gopinath,

I am glad to hear my comment has helped.

Saying this, I will appreciate if you close this thread, as answered.

Have a great weekend.

Regards

Ankur