Bulk incident ticket creation from Excel sheet.

Vengeful
Mega Sage

We have a requirement: Create a bulk of incident tickets using an Excel sheet and it should be auto-resolve.

Anyone can assist me for transform map script for this request?

1 ACCEPTED SOLUTION

Danish Bhairag2
Tera Sage
Tera Sage

Hi @Vengeful ,

 

Please check this link. It has detailed steps

 

https://www.servicenowelite.com/blog/2013/11/24/incident-data-load

 

Thanks,

Danish

 

View solution in original post

16 REPLIES 16

Danish Bhairag2
Tera Sage
Tera Sage

Hi @Vengeful ,

 

Please check this link. It has detailed steps

 

https://www.servicenowelite.com/blog/2013/11/24/incident-data-load

 

Thanks,

Danish

 

Hi @Danish Bhairag2 
I followed the article and somehow it works.

There are fields that did not work.

Like the state, comments and work notes.

In my excel I put Resolved

Merza_0-1700638805189.png
In the incident, the state is New and no comments added.

 

Merza_1-1700638946303.png

 

 

Hi @Vengeful ,

 

By any chance in transform map is the Run business rule checkbox unchecked?

also for state resolved doesn't it asks Resolution Code & Resolution Note as Mandatory Maybe thats y it was not able to update state.

 

Thanks,

Danish

 

Hello @Danish Bhairag2 

Here's the settings

Merza_0-1700696167410.png

In my excel, I included the close notes and close code

Merza_1-1700696220663.png