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.

[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.  :)