Is it possible to generate request tickets from a microsoft excel spreadsheet?

[Jill Achanzar]

The reason I am asking, is because our Imprivata IDG system is set to email Service Now and create request tickets.  We are not at the point yet where we are ready to integrate these 2 systems together yet.

This is the second time this feature has stopped working and now I have 56 tickets that need to be created manually. 

Is there any way that I can create request tickets in bulk from the excel spreadsheet I have?

I am desperate. 

Any assistance would be truly appreciated. 

Thnak you so very much,

Jill 

[Animesh Das2]

Hi @Jill Achanzar ,

One of the easy ways, you can do that easily with the help of 'Load data' module present in the filter navigator,

1. Once you click on that the form opens you can follow the steps. PFB SS,

2. You need to have proper formatted excel with the data which means the column names in your excel sheet should match the field names of the incident table and choose that file as 'Source of the import'.

3. Then just follow step by step where you need to create a transform map after data is loaded into stage table.

Lastly run that created transform map and the new incidents will be created with proper new incident numbers.

You can quickly go thorough this ServiceNow documentation as well for your reference.

Load Data from file 

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

[Diogo Ramos]

When you say request tickets, is this meaning Service Requests (catalog items?), for normal tables you could use the easy import feature https://docs.servicenow.com/bundle/xanadu-integrate-applications/page/administer/import-sets/concept... or the import set capabilities https://developer.servicenow.com/dev.do#!/learn/courses/washingtondc/app_store_learnv2_importingdata...

And a bit more advanced, api based batch imports: https://docs.servicenow.com/bundle/xanadu-api-reference/page/integrate/inbound-rest/concept/batch-ap...

There is also a cart api for catalog https://docs.servicenow.com/bundle/xanadu-api-reference/page/integrate/inbound-rest/concept/c_Servic...

Cheers