Duplicate Test Cases in Test Sets when uploading via XLS

Wednesday, July 3, 2013 2:21:03 PM
When using the XLS import tool for Excel 2007, after assigning test case numbers to a test set if i then export them all works fine. If however I export again it assigns the test cases to the test set twice, would you not normally just have a test case assigned to a test set once in which case this is a fault?

Thanks
Grant
3 Replies
Wednesday, July 3, 2013 2:37:53 PM
Avatar
re: GBell on Wednesday, July 3, 2013 2:21:03 PM
Using Excel 2007 and Spiratest v4.0 (011)
Wednesday, August 28, 2013 10:13:10 AM
Avatar
re: GBell on Wednesday, July 3, 2013
Hi,

you can add manually the same test case to a test set as many times as you want. This is because the test case can have parameters in it, and can be set to different vaules when you link the test case to a test set.

Since this can be done manually, it should be able to do it through the excel addin too. Although the real problem is that you can't set the parameters through the addin.

Regards,
Zoltan
Friday, February 14, 2014 2:13:52 PM
Avatar
re: z.major on Wednesday, August 28, 2013
Hello

I have noticed a similar problem yesterday and I had to manually remove the test cases from the test sets. This is what I followed and observed:
- Export test cases into Spira Team from the TEMPLATE spreadsheet.
- Export Test sets into Spira Team from the TEMPLATE spreadsheet.
- Update the Test set id in the Test cases sheet to link the test cases to test sets.
- Export the test cases into Spira Team. In Spira Team, you will now see test sets linked to test cases.
- Now, use the TEMPLATE spreadsheet to update test case description for a test case.
- Export the test cases again into Spira Team. 

What you will observe now is the test case description is updated for the test case in Spira Team; however the test set to which this
test case was linked to will have an additional entry with the same id. So in effect, the test set now contains 
1. the original test case before making the change
2. another test case with the same id after making the change.

Spira Team 4.0 with Excel 2007.

P.S.
Grant: Is this the same what you were reporting?

Statistics
  • Started: Wednesday, July 3, 2013 2:21:03 PM
  • Last Reply: Friday, February 14, 2014 2:13:52 PM
  • Replies: 3
  • Views: 1182