QMetry (JIRA Plugin) enables bulk test case creation and import.

Introduction:

Does every test case have to be drafted separately on a different user interface? Or would you rather draft everything in a single spreadsheet and then simply copy and paste what you need to keep things consistent?

Have it peer-reviewed later or reviewed by an SME (Subject Matter Expert) in an easy-to-read format (.xls) for any SME. Why not upload them all at once in a few simple steps after the changes and improvements are finished?

Pros of Using the Import Method:

1. Time efficiency: Bulk importing saves time, particularly when dealing with many test cases.
2. Easy review process: Excel allows users to customize views, apply filters, and sort data based on specific criteria, allowing for a tailored approach to reviewing test cases and adding comments. It is easily shareable and accessible.
3. Data Accuracy: Reduces the likelihood of errors associated with manual data entry, ensuring data accuracy throughout the import process.
4. Consistency: Enables standardized test case creation by importing data from a structured template, promoting consistency across multiple tests.
5. Flexibility: Simple to implement because there is no initial setup required and the test case template is already created and maintained.
6. Data Migration: Bulk import allows for data migration from other test case management systems or tools, preserving valuable testing information.

Cons of Using the Import Method:

1. Errors due to limitations: When importing test cases, errors may occur due to character type and character count. (In that case, these limitations must be manually addressed in the test case template and re-uploaded)
2. Limitations when dealing with business components: Following the bulk import of test cases, if ‘business components’ are required, a manual editing step is required to add links with ‘business components.

Step Guide — Creating the Test Cases from Template Sheet:

Step #1: To create test cases, use the “QMetry Import Testcase Template.xlsx” sheet from the link below.

Link / Google Drive: QMetry Import Testcase Template.xlsx

Step #2: Get the drafted test cases reviewed and signed off on by the SME (subject matter experts: BA’s, stakeholders), peers, and developers to ensure that they have catered to your validations during implementations.

Step Guide — Import the test cases from the Template Sheet:

Step #1: Go to Project on Jira > QMetry.

Step #2: Make a folder for the story/test scenarios.

Step #3: Click the “Import” button.

Step #4: Select the Test Case Sheet (Template Sheet).

Step #5: Select the Attribute Mapping of Excel Sheet with QMetry and Proceed
(Summary, Description, Priority, Label, Fix Version, Steps, Expected Result)

Must map all mandatory fields. Some fields (for example, Automatable, Automated, Module, Test Layer, and Test Type) may be mandatory or optional depending on the project.

Step #6: Click Proceed/Import

Test Case Import : Success Notification

Step Guide — Create the Test Cycle and Link Test Cases:

Step #1: Click on Test Cycles.

Step #2: Create a folder for the Story/Test Scenarios
(similar to the Test Case Tab).

Step #3: Click on New.

Step #4: Create a Test Cycle by filling out the Cycle Details
(Summary, Status, and Fix Version).

Step #5: Navigate to the ‘Test Case’ tab and select Link Test Cases to execute them within the Test Cycle.

Step #6: Select Test Cases from Checkboxes.

Step #7: Click the link and close.

Step #8: Link the Test Cycle to the Story.

Step #9: Click on Create.

Step Guide — Execute Test Cycle:

Step #1: Choose the Test Cycle from the Test Cycle Tab.

Step #2: Click the Play Button.

Step #3: Run each test case and update the status.