Versions Compared

Key

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

You can use the Xray's Test Case Importer (a JIRA Importer Plugin extension) to import Manual Tests from a CSV source file. 

Table of Contents
maxLevel3

Before importing

The CSV source file must follow some simple rules.

...

Here is an example of test cases structure:

 

And here is how the CSV file looks like once the test cases above are exported to CSV:

 

 

Info
titleCSV column separator

If you choose the “,” (comma) as the CSV columns separator, you must quote any field that contains commas.

...

  1. Log in with an administrator account
  2. go to System>Import and Export>External System Import
  3. Choose the Xray "Test Case Importer" like shown in the image bellow

Setup Page

Then the basic settings for the importation process must be provided.

...

  • The CSV Delimiter field is where you provide the column delimiter used in your CSV source file.
  • The File Encoding field is where you provide the encoding used in your CSV source file. Make sure that you provide the right encoding.
  • Optionally you can use settings from a previous importation.

Project Page

Next you need to select the Xray project where you want your Manual Test cases to be imported. 

Field Mapping Page

Next you need to map the fields from your CSV to JIRA and Xray fields

...

The fields that aren't mapped will not be imported within to the test case.

Info
titleCustom field mapping

Only custom fields that have the issue type Test selected as one of the applicable issue types, will be available for mapping.

Available custom fields for import:

  • Checkboxes
  • Labels
  • Number fields
  • Radio buttons
  • Select lists
  • Text field
  • URL field
  • User picker

Note: Only single value custom fields are supported.

Value Mapping Page

And in the last step, can Map the CSV column values. In the example above, the Map Field Value checkbox is selected for Priority, so next those values are going to be mapped.

Now just click Begin Import and Xray Test Case Importer will import the manual test cases to the selected project.

Image Added

The importation process is complete. A configuration file can be saved to import other manual test cases using the same configuration.

For any questions regarding this feature, please contact our support team.

Tips for importing CSV data 

Attachments


Info
titleAttachments

It is also possible attach files to Test and to Test Steps.

The attachment may be referred by name (in this case the file:// protocol is assumed), by "file://" or "http(s)://". Multiple files may be specified within one CSV column; for this, the attachments must be delimited by space.

Note: For file protocol, only files in the "<JIRA_DATA_HOME>/import/attachments" folder will be imported.

Test Repository folder

If you want to add the Tests to some folder within the Test Repository, you can specify a column having the Test Repository Path.

Folders and their respective sub-folders must be delimited by "/", as shown in the following example.

Image Added

During the mapping step, you need to map the CSV column containing the path to the "Test Repository Path" Xray's custom field.

Image Added


Info
titlePlease note

The "Test Repository Path" is case insensitive and each folder is trimmed (spaces are removed from the start/end of it).

This means that "components/compA", "components /compA", " components/COMPA", are all the same and will be mapped to the same folder within the Test Repository.

If the folder is not found, then the Test is created but it is not associated with any folder; it will be seen within the "Orphans" meta-folder.



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.

 

Now just click next and Xray Test Case Importer will import the manual test cases to the selected project.

Image Removed

The importation process is complete. A configuration file can be saved to import other manual test cases using the same configuration.

For any questions regarding this feature, please contact our support team.


Comments


Info
titleIssue Comments

??


Other Useful tips

Importing data in any system may be a non-linear process and you may need to run it multiple times until you got the expected result, because simple things such as forgetting to map a field may happen.

...