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!

[Ct111]

Hi ,

Go through the below link it has ways and steps to import multiple groups simulatenously

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

check response of  eashwar

Mark my ANSWER as CORRECT and HELPFUL if it helped without fail

[Sanjeev Kumar1]

Hi,

You need to create a Data source and then create a tansform map.

and impotr it.

For more detail See @ https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concept/c_ImportDataUsingImportSets.html

[Udom]

Hi Sandeep, 

You can import data from Excel using import set, see link below for details: 

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concept/c_ImportDataUsingImportSets.html

Thanks. 

[Sandeep Deswal1]

Thanks everyone for your responses.

The suggested links from docs would be helpful for importing groups. My ask here is little different. I want to import multiple assignment rules (mentioned in the description)as part of implementing CSM. Challenge is, when an assignment rule is created in Servicenow, the conditions we add are saved in the table in form of SQL I believe. So, having the rules imported directly from Excel is becoming a challenge.

If someone has done it firsthand somehow and can share, that'll be  super helpful.