Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Do you want to migrate tests from other tools? If you are able to export them to a Excel/CSV file, then you may import the tests to JIRA using also CSV using the instructions bellow.

Please do contact us if you need some guidance on some specific use case.

...

You can import Test definitions from external sources using CSV files, either by using Xray's Test Case importer (recommended) or JIRA's native CSV importer plugin for importing issues (more info on JIRA's article on Importing Data from CSV).

This page explaing the later procedure, which is more generic and supports importing of all Test types. However, for manual Tests you should use Xray's Test Case importer.

 

You In order to import issues using JIRA's CSV importer, as an administrator, you just have to:

  1. Log in to JIRA as a user with the JIRA Administrators global permission.
  2. Select Administration > System > Import & Export > External System Import > Import button, and then specify the input CSV file.

 You can also import issues as a standard user:

  1. Go to the top "Issues" menu
  2. Select "Import Issues from CSV" 

Image Added

In the CSV file that you'll use for importing, besides native issue columns, like Summary, Description, amongst others, you need to specificy some additional columns related with Xray Test issues:

...

Info
titleLinks to requirements

Whenever importing Tests, it's also possible to specify the links to the requirements that each Test validates. For that purpose, columns must be mapped as Link "Tests".

If the Test covers multiple requirements, then multiple CSV columns must be used, each one being mapped in the same way.

 

Image RemovedImage Added

 

Importing Manual Tests

...

Info
titleRecommended

If you need to import Manual Tests, you should use Xray's Test Case importer instead since it support a more user-friendly CSV file layout for describing Test steps.

...

Note

 Please be aware that if you importing Tests from a CSV and you are linking your tests to an already existing requirement you have to Clear the Requirement Status Cache. Please check Integrity Checker Importing and Exporting Tests (CSV) for more information about on how to clear the requirement status cache.

...

Tip
titleHow to optimize this process

Some organisations have already Manual Test definitions in spreadsheets. These spreadsheets normally define all Tests to execute and within each Test their steps.

This is main reason to choose Xray's Test Case importer as a better alternative for importing Manual Tests.

 

Before Xray for JIRA 2.1, you could use a special converter tool (now deprecated) for converting these spreadsheet Test definitions, more specifically the Test Steps, into the JSON format above expected by Xray and JIRA.

...

Info
titlePlease note

Since JIRA 7.2, JIRA only provides the ability to export issues to CSV in a limited way; recent versions do not support exporting to Excel.

If you need to export issues, including your Tests, to Excel or fully customizable templates then we recommend using the Xporter add-on.



Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

 

Once the data is in XLS format, you must remove header and footers as those are HTML fields, and export data as CSV. 

...

Code Block
titleExample of CSV file with manual tests
Summary; Assignee; Reporter; Issue Type; Type; Condition; Description; Tests associated with Pre Condition
"Standalone PreCondition"; admin; admin; 10; Manual; "calculator must be turned on"; "This is a PreConditon issue";
"PreCondition linked to 2 Tests"; admin; admin; 10; Manual; "calculator must be scientific"; "This is a PreConditon issue"; CALC-779,CALC-756
"PreCondition linked to 1 Test"; admin; admin; 10; Manual; "calculator must be normal"; "This is a PreConditon issue"; CALC-779

Image RemovedImage Added

Test Sets

It's possible to specifiy the Tests by using the "Tests associated with Test Set" mapping upon importing. Multiple Tests may be specified by using the comma (",") delimiter.

Code Block
titleExample of CSV file with manual tests
Summary; Assignee; Reporter; Issue Type; Description; Tests associated with Test Set
"Test Set without Tests"; admin; admin; 8; "This is a Test Set issue"; 
"Test Set with 2 Tests"; admin; admin; 8; "This is a Test Set issue"; CALC-908,CALC-887

 

Image RemovedImage Added

Test Executions

...

Code Block
titleExample of CSV file with manual tests
Fix Version; Summary; Assignee; Reporter; Issue Type; Description; Test Environments; Tests associated with Test Execution
"3.0"; "Test Execution without Tests"; admin; admin; 9; "This is a Test Execution issue";; 
"3.0"; "Test Execution with 2 Tests"; admin; admin; 9; "This is a Test Execution issue"; Android; CALC-908,CALC-887

 

Image RemovedImage Added

Test Plans

It's possible to specifiy the Tests by using the "Tests associated with Test Plan" mapping upon importing. Multiple Tests may be specified by using the comma (",") delimiter.

...