Page History
...
Info |
---|
Do you want to migrate tests from other tools? If you are able to export them to a an Excel/CSV file, then you may import the tests to Jira using also using the instructions bellowbelow. Note that Xray's Test Case importer is the recommended tool for this purpose and not Jira's native CSV importer as detailed here. If you need guidance on a specific use case, please contact us. |
...
Note | ||||
---|---|---|---|---|
| ||||
Please note that when using Manual Test Steps Custom field of Type "Date Picker" or "DateTime Picker", Xray uses the format set in the "Look and Feel" of your Jira instance. The format provided in the CSV configuration only refers to Jira custom fields and will not be used by Xray.
The Manual Test Step Custom fields must be configured and enabled in the target project or else Xray won't be able to map the fields and won't import any manual test step custom field
|
Aside from the native issue columns like Summary and Description, you need to specify in the CSV Aside from the native issue columns like Summary and Description, you need to specify in the CSV file additional columns related to Xray Test issues.
...
In order to import Manual Tests in a CSV file to Jira, you need to define the following columns:
- "Test Type", ensuring its value is "Manual"
- "Manual Test Steps"; this is the custom field in the JSON list format representing all your manual steps. Here is Next follows an example of the "Manual Test Steps" custom field:; due to CSV format, double quotes within this field have to be escaped whenever writing it into the CSV.
Code Block | ||
---|---|---|
| ||
[ { "index":1, "fields":{ "Action":"Step 1 action", "Data":"", "Expected Result":"Expected result", "Limit date":"06 Jun 2020" }, "attachments":[ { "fileName":"Xray Unit Testing.docx", "fileIcon":"word.gif", "mimeType":"application/vnd.openxmlformats-officedocument.wordprocessingml.document", "fileIconAlt":"Microsoft Word", "fileSize":"506 kB", "numericalFileSize":517880, "created":"2020-06-04T22:46:21+01:00", "createdDate":"Jun 4, 2020 10:46:21 PM", "author":"admin", "authorFullName":"john", "filePath":"valid/local/path/to/server/inside/jira/directory" } ] }, { "index":2, "fields":{ "Action":"Step 2 action", "Data":"", "Expected Result":"Expected result", "Limit date":"07 Jun 2020" }, "attachments":[ ] } ] |
This is a very basic example containing two test cases, having 2 steps each.
Code Block | ||
---|---|---|
| ||
Summary; Assignee; Reporter; Issue Type; Description; Test Type; Manual Test Steps "Basic Test issue 1"; admin; admin; 10000Test; "This is a basic Test issue"; "Manual"; "[{""index"":1,""fields"":{""action"Action":""Step 1 action"",""data"Data":"""",""expected result"":""Expected result""},""attachments"":[]},{""index"":2,""fields"":{""Action"":""Step 2 action"",""Data"": """", ""Expected result"":""Expected result""},""attachments"":[]}]" "Another basic Test issue"; admin; admin; Test; "This is another basic Test issue"; "Manual"; "[{""index"":1,""fields"":{""action"":""Step 1 action"",""data"":"""",""expected result"":""Expected result""},""attachments"":[]},{""index"":2,""fields"":{""Action"":""Step 2 action"",""Data"": """", ""Expected result"":""Expected result""},""attachments"":[]}]" |
This second example shows more complex/complete scenarios, detailing how to specify attachments, additional Xray step custom fields.
Code Block | ||
---|---|---|
| ||
Summary; Assignee; Reporter; Issue Type; Description; Test Type; Manual Test Steps "Test issue 1"; admin; admin; 10000; "This is a Test issue"; "Manual"; "[{""index"":1,""fields"":{""Action":""Step 1 action"",""Data"":"""",""Expected Result"":""Expected result""},""attachments"":[{""fileName"":""Expected Result":"Expected result","Limit date":"06 Jun 2020"},"attachments":[{"fileName":"Xray Unit Testing.docx"",""fileIcon"":""word.gif"",""mimeType"":""application/vnd.openxmlformats-officedocument.wordprocessingml.document"",""fileIconAlt"":""Microsoft Word"",""fileSize"":""506 kB"",""numericalFileSize"":517880,""created"":""2020-06-04T22:46:21+01:00"",""createdDate":""Jun 4, 2020 10:46:21 PM"",""author"":""admin"",""authorFullName"":""bruce wayne"",""filePath"":""/jira/postgres/870/home/data/attachments/IMCSV/10000/IMCSV-1/xray_3883""}]},{""index"":2,""fields"":{""Action"":""Step 2 action"",""Data"":"""",""Expected Result"":""Expected result"",""Limit date"":"07 Jun 2020""},""attachments"":[]}]" "Test issue 2"; admin; admin; 10000; "This is a Test issue"; "Manual"; "[{""index"":1,""fields"":{""Action"":""Step 1 action"",""Data"":"""",""Expected Result"":""Expected result"",""Limit date"":""06 Jun 2020""},""attachments"":[]},{""index"":2,""fields"":{""Action"":""Step 2 action"","Data":"""",""Expected Result"":""Expected result"",""Limit date"":""07 Jun 2020""},""attachments"":[]}]" |
Tip | ||
---|---|---|
| ||
Some organizations already have Manual Test definitions in spreadsheets. These spreadsheets normally define all Tests to execute and within each Test, their steps. This is the main reason why Xray's Test Case importer is 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. |
...