Batch upload of offline cases into newly created HR service

[T_55]

Hi Snug Toronto, 

We have created a new HR Service (July) and want to be able to batch or bulk upload all previous year to date cases that were managed outside of ServiceNow prior to the creation of this new service (~200 cases) so that we can utilize the quarterly and annual reporting we have created for this service.

Any ideas on how to achieve this that doesn't require us to individually create the 200 offline cases?  This is a pensioner death service for context.  These prior cases have been closed, so the pensioner has been terminated (we use alumni accounts for our pensioners).

Thanks in advance. 

[minaz · Accepted solution]

Provide the HR team with an Excel Template of the fields on the HR Service Table. Once completed, you can create an Import Set/Transform Map.

However, be aware that different HR Services maps to different Tables. For example:

General Inquiry Maps to sn_hr_core_case table/CoE

Payroll Inquiry Maps to sn_hr_case_payroll table/CoE

So there are few ways you can do it:

1. Create a Transform Map to insert data to in to its appropriate Table. Would require scripting.

2. Create multiple Transform Maps for each HR Service/CoE

3. Use an intern to create these services.

Creating one transform map, importing the data and then changing the values would NOT work.

I hope this helps.