To create multiple RITM's based on Excel sheet attached

[Atchamma D]

Hi Everyone,

Currently new to Service-now and were trying to implement bulk creation on service catalog. As we have some users that are requesting for access for like 50 users and up and Add to Cart function is not okay for them.

1. The requirement is for the users to attach an excel sheet on a catalog item

2. Service-now will then have to process the attachment and create multiple requested items per row on the attached sheet

3. This should be one REQUEST generated with MULTIPLE RITM based on the rows on the attachment.

Not much of an expert on scripting as well...

Has anyone implemented same process?

Thank you in advance,

[Jacques G]

@Atchamma D I had a similar requirement before and we created a multi-row variable set and used GlideExcelParser to parse the contents of the excel and pass the contents to the multi-row variable sets. Then each row data would be used to generate in our case multiple catalog task instead of a request item using a flow. You can opt to skip the part of creating a multi-row variable set and just parse the excel contents on the flow to generate request items and under the same request.

[Akshay Bhonde]

Hello Jacques,

I came across this article as I have also exactly similar requirement and I was searching for some help.

I have created one normal ritm flow but now I want to check the attachment added in the catalog request. If attachment contains multiple rows inside it then need to take the count of rows in attachment and those many tasks should be created under the same RITM request.

Can you please provide a detailed step by step guide on how can I achieve the

[brahmandlapally]

I have similar requirement now if you acheived it plz help me.

[MihirY]

Here are my thoughts.

1. Once RITM was submitted write a business rule to read the attachment and create required number of RITMs.  You may think that business rule may get execute for every RITM creation, but you can restrict that based on short description given to the RITM. 
2. In this case you will have one additional RITM along with the rows in the excel sheet. 
3. I don't think there will be an issue with that RITM because, it will hold the variables data that will be submitted by user.
4. You can try similar approach with flow as well. 
5. Alternately you can create a schedule job to check for the Request creation may be for every 10mins to initiate the RITM creation process. In this case business rule is not needed. This depends on the usage of catalog item.