How to import Test cases in JIRA,I am a junior tester so i don't have access to administrator accnt?

[Mann]

I am working as a software executive in a company and I recently got the task in which i have to find out how to import test cases created in excel to jira.I don't have the access to administrator account as for now but if required I can ask for it.So please tell me all the steps by which i can understand how to import test cases in Jira.

Thank you in advance

[Phill Fox]

Hi Manish
The first thing to consider is how would you like your test cases to be represented in Jira? Are you looking at them as subtasks or are you using an app that handles Test Cases such as Test Manager for Jira or Zephyr?
When we know how you are representing your Test Cases we can provide advice on how best to import them.

Phill

[Mann]

Hello Sir

I am not using any app I am very new to testing and I want to know how to import normally created test cases in excel to my Project in JIRA if i need any app for importing these test cases then I am ready to install the app too.

[Phill Fox]

Ok so can you create a Test Case in Jira through the User Interface? If so can you attach a screenshot (with any sensitive information removed) showing where it would appear in the UI.

I am suspecting this will either appear as a subtask or as a linked item. 

[Mann]

Hello sir below is the image in which i have attached the format how we have create test cases in excel.I guess actual results and expected results are missing from the image.

We do not write test cases in JIRA we write them in excel and that's why i want to ask you how to import this excel in JIRA with the fields i have written in excel is that possible? That is my concern and i am not getting a proper way of doing it so please help if you can.

[Nic Brough -Adaptavist-]

We cannot help you until we know how you want to represent your test cases in Jira.

[Mann]

Sir I am ready to represent it in any form i request to tell me about the standard which is followed by most of the Software Testers.As i told you the place where i am working there is no such process and i want to introduce this myself so i am all ears.

[Nic Brough -Adaptavist-]

Most testers using Jira will reach for an add-on to help them.  Jira is an issue tracker off-the-shelf, and does not directly support test plans. 

To give you a rough idea of why that matters, think of a "to do list".  You have stuff that needs doing, so you write down each item, and then cross it off when you've done it.  Jira gives you very powerful ways of managing your to-do lists, but at its heart, it really is a to-do list. 

Testing something is indeed representable as one of those to-do items, but your tests themselves are different - they are repeatable and have to be done against items on your to-do list.

A very simple implementation of test plans in Jira would be to create a set of issues (sub-tasks usually) linked to each story that needs them.  But that immediately drops you into a rabbit-hole of possible problems.  Imagine your users have 100 stories, and you have 7 standard tests.  You now have 700 possible test issues to apply and deal with.  All separate issues, that you have to create and link somehow.  That's not really a sane way to do it, what you really want is probably a task somewhere that says "test this story" for the humans to track, and a library of standard tests that you can point at and say "run these for each story".  Which, Jira doesn't do.

So, most of us reach for add-ons that help.  All the add-ons I've used have the concept of repeatable tests to be applied to stories, albeit handled in several different ways, and they all do reporting on test runs, allow for automation and so-on.

Much as I am a Jira fan, I would never try to use it for test management off-the-shelf.  All the testers I know get a Test Management add-on for it.  Have a look through https://marketplace.atlassian.com/search?product=jira&query=test and please, get one of them.  (Yes, I am biased because I work for one of the vendors, but I'd say the same even if I didn't - plain Jira is not a test management tool, it needs an add-on)