Unable to import testcases from excel to Xray

[Piyush Sahu]

I am getting the below-attached message: 

Please note: A Jira Summary, Xray Test Case Identifier and Custom Fields [Action] are required to enable import.

[Massimo Grandillo]

I have a CSV file with many test cases that I would like to import in XRay. I noticed that it is giving me errors when i import because some of the test steps/expected results have blank cells. In order to  make it work I have to manually do the change in the Excel file which is long and tedious. Is there a way to bypass this and make the import work without having to add something in the empty Steps/Expected results cells?

[José Domingues [Xray]]

HI @Piyush Sahu 

The "Step" as been renamed to "Action" as you can see on the section of manual steps:

When using the Test Case Importer the correct mapping should be the "Action".

Then to recap, right now, by default, each Test Step has the following fields:

Action* - the action to be reproduced by the tester
Data - any data the related step requests (e.g., login credentials) to be used by the tester
Expected Result - the behavior the step should accomplish.
Attachments - external files that provide additional information related to the corresponding step. Attachments can only be added or removed in the Test Issue view page.

*Only the Action field is mandatory. All other default fields are optional.

However, to correctly import, you need to map Summary, Test Case Identifier, and Action.

Best Regards,

Team Xray

[akshay kumar]

Hi Jose,

can you please help with steps detailed here ..?

[akshay kumar]

@José Domingues [Xray] ,

Please help with steps here, i am also getting same issue.

[Siddhesh Patil]

I am also getting error and could not able to import test cases 

[Rogério Paiva - Xray Xporter]

Hi @Siddhesh Patil 

It looks like the action column is missing from your file, please add the column like described in the documentation here.

If you need further help, please contact the Xray Support (http://xraysupport.xpand-it.com) so that we can request additional information and investigate further.

Kind regards,
Rogério Paiva [Xray Support Team]

[Megha Debnath]

Hi,

I also faced the same error msg as Siddhesh Patil. The thing that worked for me was the file. Although the data was exactly the same, by copying the data and pasting it a new sheet I was able to import the file.

[Yasir Kotwal]

Trying to import as CSV, getting below error can someone help here.

*Missing mandatory Summary Field*

Does anyone has the answer to this?

[Anil Bagaria]

Try writing one test case in X-ray, then export this text case and compare it with your existing JIRA test case csv file.  :)

[Sangeeta]

{
"errors": [
{
"elementNumber": 0,
"errors": [
{
"xray": "Step 25 is missing following required fields: action."
}
]
}
],
"issues": []
}


I am also getting the above error, 

[Senthil Kannan]

If you are exporting from xLS to CSV there could be empty spaces that is accounted as a value, try deleting and clear formatting any additional columns or rows beyond your test case rows. This approach solved this error in my case.