How do I create cases from an import file?

[jrusso]

We recently added a catalog item and HR Service.  However, the team managing this process had been collecting request data and tracking in Excel.  They would like to create HR Cases from their excel file so that last year's requests can be included in ServiceNow and they can report on all cases from ServiceNow. 

We would like to import the case details with a State of Closed Complete, as these are have all been addressed.  I don't believe Bulk Case creation would work in this situation.  We do not want these newly added closed cases to generate any emails to the employee since the case is already closed.

Is there a defined process for doing something like this? 

[AshishKM]

Hi, please check the configured email notification on case closed state. If the notification checks the condition like " State changes to Closed Complete" and the transform map script is directly setting the state = closed complete then email should not trigger. 

also, you can try with onBefore() and use the setWorkflow(false).

try with this approach and share the details.

-Thanks

[jrusso]

Thanks for the information.  I will make sure to check that.

I am looking for a process to create HR Cases from an import.  How would I go about doing that?

[AshishKM]

Hi, assuming you already have a transform map and staging table to map with HR Case table. 

did you try the use [Script] based column mapping with State column on target table. In Script part you can set the state = closed complete.

Try this and share if it works or not. 

[jrusso]

Thanks... I am not familiar with that process but it helps to point me in the right direction.