Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV test case upload onto Jira uploads my teststeps in a single line

sahitya
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 25, 2019

When i upload the CSV file with my test steps , as attached, they are come in one line, how to get them in separate lines

 

Is there a way i can modify my CSV , so that after upload the steps and expected results are automatically shown in different / new lines?Test steps CSV.PNGOn Jira Uploaded as.PNG

1 answer

0 votes
Dave Theodore [Coyote Creek Consulting]
Community Champion
March 25, 2019

Check out the CSV import docs. This seemingly trivial thing is actually fairly complicated. I'd suggest a thorough read over the doc if you haven't.

With regard to your question, what delimiter is being used on the CSV file? Jira expects comma (,) as the delimiter, so if you are using TAB, Space or something else, you will need to convert the file to use that delimiter.  I would recommend against using MS Excel if you need to hand edit CSV files.  Use OpenOffice instead.  For unexplainable reasons, MSFT imposes limits on CSV cell size and doesn't handle cells with commas well (it screws up the "" that is supposed to encapsulate the cell containing commas.) OpenOffice does a better job of this.  In the end, you may need to hand edit in a text editor, though.  We frequently find that it's the only way to clean some things up. I hope that helps.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events