Create multiple incidents from EXCEL

Koushick Vikram
Tera Contributor

End user with ITIL has to create multiple incidents in a single shot with the help of excel.
is there any way the can send a mail to myinstance@service-now.com with an excel attachment, then incidents has to be created for all records in the excel rows. whether this can be achieved? or any other way to achieve this?

2 REPLIES 2

Kieran Anson
Kilo Patron

Hi,

Yes you can send an excel attachment via email and then read the email content.

Look into the following on creating a data source and transform map for this:

Loading data from an email attachment

Stacy1
Mega Guru

Is this something they need to do often or just occassionally.

Because you can go to the incident list, add all the fields that are required to create a new incident. Make sure you don't include the number.

Right click and go to 'import'. 

Click on 'insert'

Uncheck 'include all fields'.

Then Create Excel Template.

Have them fill it in.  The drop downs for fields with drop down values will be there.

If they need specific reference values to be put in you can provide them the sysid of those.  Such as CMDB reference or group or user.

Then when they provide that back to you, go back to the same screen and add the attachment.

Load it.  It will create an import record for you.  It will show you if the data is valid (sometimes you will get an invalid reference when you put a sysid on a reference field but it still works).

Then complete import and all records will be created.

I always do a test run of the import in my dev or test environment to make sure they provided correct values.

 

Best of luck,

Stacy

 

find_real_file.png