hey guys! jira is a bit alien to me , can any one plz help me, how to upload test cases which are written in excel

[azeez khan]

hey guys! jira is a bit alien to me , can any one plz help me out, how to upload test cases which are written in excel,

as v generally desing test cases in excel and upload them with results so iam expecting the same is possible with jira too.........help me out guys

[Renjith Pillai]

You can import data into Jira using CSV as explained here http://confluence.atlassian.com/display/JIRA044/Importing+Data+From+CSV

But remember this is an admin funtionality and not for regular users. So doing this on a continuous basis is not a practical solution.

If you are looking at regular sync between Excel and Jira you need to explore other options like writing a SOAP based program to do the same.

You could try to use the Jira Command Line Interface also.

[Bob Swift]

Specifically, Renjith's last point is discussed in more detail here - https://answers.atlassian.com/questions/28223/jira-issue-excel-import-external-user/28241

[azeez khan]

thanx a lot bro for such an useful stuff u shared vd me hope il get used to jira soon as u guys r....

cheers

[Emily Schneider]

Hello,

In case you have not heard or checked it out, Zephyr for JIRA would really help you out in this situation. Zephyr for JIRA allows you to import test cases from an excel file into your JIRA. Below is a link to the Zephyr for JIRA product. There is a 30 day free trial too to make sure that the product is right for you:

https://marketplace.atlassian.com/plugins/com.thed.zephyr.je

And below this is a link to the Zephyr for JIRA Tests Utility Importer:

https://bitbucket.org/zfjdeveloper/zfj-importer/downloads/

Kind Regards,

Emily

[azeez khan]

thanx buddy dat was an useful stuff u xplained.......sry fr making u wonder bt wt i meant was about QC in dat v generally upload the test cases by using excel add-in along with d screenshots .........i was jz looking the same in jira anyways thanx for ur time bro

cheers

[Ian D]

Your comment about "...and upload them with results ..." makes me wonder if you really/actually even need to upload the Test Cases. Why not use the excel sheet as the basis of tracking your regression testing, and in event of defects being found create bug report issues on the fly using JIRA - and importantly: including the screenshots and details, assign to the right person, etc ... all in realtime (rather than having to wait for some upload).

However, if the purpose is to also be able to portray the status/progress of planned regression testing then of course import them as issues using the mechanism already described by others above.

Important:

• I'd *strongly* suggest you develop and test your approach to doing the import on a test instance of jira first.
• There will probably be a fair amount of data sifting/augmenting in your csv before it's suitable/successful. Particularly: alignment of the assignee username/s, dates, fixVerion (release), special character encoding in the description+summary, etc.