No doubt, Excel is often software developers’ go-to choice when it comes to managing and documenting test cases. It's affordable and easy to use, but here's the thing: it doesn't have all the essential features that dedicated test management software offers. Especially as teams grow in size and complexity, the limitations of Excel spreadsheets might become more and more apparent. Then, it's definitely worth considering importing your test cases into Jira.
What are some of the advantages? Moving your test cases to Jira allows for:
- More centralized test management: teams can consolidate all their project-related work, including test management, within the same tool. This results in better visibility and coordination. As test cases become easily accessible to every team member, it’s easier for everyone to be on the same page, exchange information, and address issues promptly.
- Enhanced traceability: importing test cases into Jira enables teams to establish connections between test cases and other project elements, such as user stories, requirements, and bugs. By establishing these connections, teams can easily trace the relationships between test cases and these project elements which helps to gain a holistic view of the project's progress.
- Streamlined collaboration: once you’ve imported your test cases to Jira, you can utilize its features that promote enhanced collaboration, such as assigning test cases to specific team members, adding comments and attachments, and tracking test execution status.
- Efficient test reporting: since all the important data is stored in one central place, you don't have to spend time manually collecting and combining information from different sources.
- Standardized processes: you can establish consistent templates, fields, and workflows for managing tests. It makes things scalable, so you can handle larger projects without losing track. By having standardized practices, you ensure that everyone follows the same guidelines. This kind of setting helps you minimize mistakes. Also, it makes it easier for new team members to get up to speed quickly.
Importing test cases from a spreadsheet to Jira with QAlity Plus
If you're using Jira and want to import test cases from a spreadsheet, you first need to make sure that it was saved as a CSV file. If it wasn't, open the spreadsheet you want to convert, click File, and Save As. Then, select "CSV" from the "Save as type" drop-down menu and click Save.
Once your CSV file is ready, you can easily import your test cases with the help of QAlity Plus by following this 3-step process:
Step 1: Configuration
To begin the test case import process, open the QAlity Plus menu in Jira and click Import.
Then, you can specify the details of your CSV file and configure the import settings. Here's what you need to do:
Step 2: Mapping CSV Columns to Jira Fields
In the second step, you need to map the columns in your CSV file to the corresponding fields in Jira. Identify which column from your CSV file corresponds to the test case name, test steps, expected results, and any other required fields in Jira. The test case name is used to differentiate between different test cases and is also used as the name for newly created test cases.
Here are a few things you should remember:
QAlity Plus supports the following field types for the import:
Please note that multi-select fields and date fields are not currently supported.
Step 3: Import and Import Summary
When you map all the fields, you can start the import process by clicking Start Import.
Remember to not close your browser while the import is in progress.
Once it's completed, you will see a summary of the process. Here's what you can do in the summary screen:
More information about QAlity Plus
QAlity Plus - Test Management for Jira is a tool designed to streamline the testing process within Jira. It offers a user-friendly interface that allows you to effectively plan, organize, and execute test cases and test cycles. The function to report defects and gain insights from previous executions helps to improve manual testing practices. With QAlity Plus, you can make sure that you maintain a clear overview of the system's quality.
Kinga -SolDevelo-
1 comment