Adding multiple assignment groups in one go

[Sandeep Deswal1]

Hi

While implementing CSM for my client. We realised the customer has lot of assignment rules (say approx. 400-500) based on various combinations. One way is to create them all one-by-one in Servicenow. I wanted to check if there is a way to directly import them from an excel file or something. Please share if you've come across such a requirement and the best option selected to deal with it. I'm inclined to think there should be a way to build them outside of servicenow and import them all together (be it in an excel file or something else).

Thanks!

[Community Alums]

Hi Sandeep,

Yes, we can import multiple Assignment rules into the ServiceNow instance through an Excel file.

You will have to follow the same procedure of load data. i.e Load data -> creating on import set table -> creation of transform map -> transform it. After this, automatically you will get data into your table.

I did imported few Assignment rule records into another service now instance now, and its working fine. 

Hope it helps. Please let me know if any queries. 

[Sandeep Deswal1]

Thanks Brunda.

Would you be able to share a sample excel file that you used for import?

[Community Alums]

Hi Sandeep,

I have attached the file. Please check and let me know further. I just tried importing some 15-20 records. 

[Sandeep Deswal1 · Accepted solution]

Thanks Brunda (SN Developer). The excel file you provided was useful. It seems like it may have been used for incidents etc. In my case of creating the assignment rule for CSM cases. We need to add condition as well and since it is saved in the backend as a query, I had to modify my excel file to have the condition listed in that query format. Please find the sample attached file.

Thanks everyone again for your responses.

[Smith Johnson]

Hello all,

is it a way to make a multiple assignment from one single assignment rule?