Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,462,453
Community Members
 
Community Events
176
Community Groups

Unable to import testcases from excel to Xray

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.

2 answers

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?

0 votes

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

Hi Jose,

 

can you please help with steps detailed here ..?

@José Domingues [Xray] ,

 

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

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

 

error 297.PNG

Like Sangeeta likes this

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]

Like Asia DevOps Team likes this

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.

Like Rishivansh Patnaik likes this

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

*Missing mandatory Summary Field*

Does anyone has the answer to this?

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

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


I am also getting the above error, 

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.

Suggest an answer

Log in or Sign up to answer