Bulk incident ticket creation from Excel sheet.

[Vengeful]

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?

[Danish Bhairag2 · Accepted solution]

Hi @Vengeful ,

Please check this link. It has detailed steps

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

Thanks,

Danish

[Vengeful]

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

In the incident, the state is New and no comments added.

[Danish Bhairag2]

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

[Vengeful]

Hello @Danish Bhairag2 

Here's the settings

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