How to import testcase in JIRA(from CSV) and what would be proper format of CSV file

[Bimleshsharma]

I was trying to import my testcases that was in csv format, i had 4 columns say Desc, Steps, Expected result and assignee but i am facing different issues.

[Bimleshsharma]

What happened , there is no response after providing screenshots?

[Milan Chheda [INFOSYSTA]]

Are you using Zephyr and importing testcases using the same? Or Are you importing in an issue type having custom fields as Steps, Expected result?

Also, can you share the error message or screenshot as that would help understand the problem better.

[Bimleshsharma]

Screenshot 2019-02-20 at 2.39.02 PM

[Milan Chheda [INFOSYSTA]]

That usually means the second line is empty. Either it genuinely is, or you have ended the first line with something that it cannot handle. Also, check which delimiter is used in the csv and make sure, that you choose that delimiter while importing the issues.

[Deleted user]

Hi @Bimleshsharma ,

Hope you have gone through the documentation page. The error might be related with date format or might be other, please try once again and check the log file.

Regards,
Kishore Kumar Gangavath.

[Bimleshsharma]

Hi I tried with below template of csv.

Summary, Assignee, Reporter, Issue Type, Description, Priority
"Test issue", Bimlesh Sharma, Bimlesh Sharma, 5, This is description ,

Imported csv with following steps.

CReated Testexecution task

Test => testcase imported. 

Added csv file and click on Next and i got below error.

Second line (after header row) in CSV file is blank