Test case upload through utility importer

Question

Is it possible to upload test cases with steps and result.

I tried to import test cases with Label,test step,expected result,priority,test data but after importing Issue id is created in JIRA with all information from Excel except Test step and Expected result.

Can someone assist me on this , also please provide the Excel template to upload test cases if any.

Screen Shot 2016-02-08 at 4.33.05 PM.png

Brian Ross_27j5g5 · Answer

When you open your zfj-importer-utility.jar you should see this screen

Screen Shot 2016-02-08 at 4.33.05 PM.png

Set the discriminator to "by empty row"

In your excel spread sheet, if you have information in rows 2,3,4,5 and a blank in row 6, then the information in rows 2,3,4,5 will be test steps for the test case name they are related to.  Keep in mind, the test case name has to be present in all the rows, or the tool will have an issue determining the blank row.

John K3 · Answer

Hi Brian,

Just curious on how to do "Set the "Discriminator" to "By Empty Row"", could please tell this more specific? Or give me an example?

Thanks!

Regards,

John K

Brian Ross_27j5g5 · Answer

Hello Manoj,

I normally don't import Priority into my test cases, so I don't have a good answer for that.

My recommendation would be to create a test case manually and see what all the options are for priority.  Then enter one of the priorities into your import template priority field and see what happens when you import it.