This part describes possibilities for exports and imports in X-Ray. Note there are some limitations you should know about, it will help you choose the correct setup for your project.
Basic limitations are:
Format - Supported format for imports and exports is csv. There are some other options in some cases but in general, expect using csv files.
No test steps - Exported tests don’t contain test steps in a nice, readable form. It is possible to export also test steps, but it can be a bit time consuming because there is some manual work needed. So if you expect you will export your test cases (for example for the customer) - good option is to write enough details to Description field of the test case (issue type Test) as this field can be exported easily.
File structure - You can use the attached template for import - it can be useful especially when it is more comfortable for you to create the whole set of test cases, because you can easily copy texts between different test cases. There are mandatory fields you need to import (like Summary field), but otherwise, you can import values to every field you see on the screen when you are creating your test case manually in X-Ray, just simply add column to csv file you are using for import.
No links to user stories - Note that when you are importing test cases from csv file, those test cases are not linked with any user stories. In case those links are necessary, they must be created manually after the import is finished. I can be no issue for UAT phase, but it can be quite time consuming for Feature Sprints.
EXPORT
Example of Test export from our internal project:
Click on Issues on left menu in Jira
2. Write down filter for filtering Tests - for example “project = "PFTQA" and issuetype = "Test" ORDER BY created DESC“
3. Choose correct type of export from Export issues drop down menu (like “Export CSV (all fields)”)
4. Export will be generated and it can be opened. Example of generated file is here:
IMPORT
Click on Issues on left menu in Jira
Click on “ … “ button (on the right side) and select “Import issues from CSV“
Choose the csv source file (created manually or modified file from export) and press Next button
Example of a very simple csv file for import is here:
Select the right project for import (“Test QA“ in this case), correct coding (“UTF-8”) and delimiter (“ ; “). Note that the right setting should be based on the file you are using for import. Press Next button.
Map the columns from the file to the correct fields in JIRA:
In this case I wanted to import Description, Issue Type and Summary , sometimes also other fields can be useful for import, like Assignee
Press Next button.
On the next screen, you can first Validate your import settings or Begin Import right away.
This is an example of a validation screen, when there are no issues found:
