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?

[DanielCordick]

To change the state via transform map or script, you will need to use number associated to it not the display value.  Also how did you transform the work_notes field? 

[Vengeful]

@DanielCordick 

Here's the transform map

[DanielCordick]

I believe it’s it’s work_notes and not the comments and work_notes 

[Vengeful]

Hello @Danish Bhairag2 

I already fix the state, but the work notes and additional comments (visible to customer) fields are not working.

Also, if you can help me with to add in the script to auto-populate the location.

I wanted to remove the location in the excel and just auto-populate base on the user location.

[Danish Bhairag2]

Hi @Vengeful ,

For additional comments & workNotes the target field should be "comments" & "work_notes" please reverify this.

Also to populate users location via script u can create an onBefore or onAfter script in the transform map & use below script.

var user = new GlideRecord ('sys_user');

user.addQuery('user_name',source.u_name);

user.query();

if(user.next()){

target.setValue('location',user.location);

}

Thanks,

Danish