How to create a batch of multiple cases and a "Draft" status

[Mi4]

Hi,

I want to create multiple HR cases all at once.

And I want to create the created status in "Draft".

There is "Create Bulk Cases" in the OOTB function, but with this, the status is created as "Work in Progress".

How can I create a batch and "Draft" status?

Thanks in advance,

[Jyoti8 · Accepted solution]

Hi MI,

There is one Schedule job behind that "Create Bulk cases"  OOTB function.

Name of that Schedule job is "Bulk case creation".

You can change the status to "Draft as per your requirement"

I hope it will help you.

Please mark Helpful and Correct, if applicable.

Thanks..!

[Mi4]

Thank you!　It was helpful!
Regards,

[Raffy1]

I posted my input to the Idea to improve to the SNOW: https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=db60d48edb4bc0904819fb2439961924&sysparm_idea_table=x_snc_com_ideation_idea&sysparm_module_id=enhancement_requests

In the meantime, I will try to utilize DataSource (File type) to create a HR Case from Excel file.

-------

what content of the Excel file is supposed to be?

The first column seems to be 'user_name', but how about another columns?

We are using the Record Producer to create a HR case for 'Position Change Request'. The script on RP is 'new sn_hr_core.hr_ServicesUtil(current, gs).createCaseFromProducer(producer, cat_item.sys_id);' which filled up Rich Description field of the generated HR Case currently for one Subject Person's HR Case.

I am trying to find a solution to create a multiple HR cases using the 'Create Bulk Cases' OOTB module, but can't figure out how to make it work to create more than one (matched the number of rows minus one in Excel since the first row would be the header of  column).

I thought the column names from 2nd would be the variable names of the RP, but it does not filled up Rich Description filed of the HR cases whose subject to is matched with user_name though.

Any thought?

Moon1