linking test suits to test cases while import from Excel to RQM
![](http://jazz.net/_images/myphoto/d2b3561af992508bb5ce34a7f21c4936.jpg)
Hi,
I'd like to use the Excel importer in order to import test suits and test cases and link them.
I found on example in the samples under IBM folder, but I want to link test cases to many test suits - and not to repeat the instance of test case.
Is there a way to do that by one Excel sheet?
Is there a way to do that by one Excel sheet?
One answer
![](http://jazz.net/_images/myphoto/d2b3561af992508bb5ce34a7f21c4936.jpg)
If you don't want to repeat the artifacts in the same Excel file, I can't see a way to make n:m links between the artifacts. When the Excel file is processed, I believe it is always from the top to bottom, and it cannot do a "loop" as in a programming language.
Comments
![](http://jazz.net/_images/myphoto/d2b3561af992508bb5ce34a7f21c4936.jpg)
Thanks Donald,
But couldn't I insert the test suit name/id in the top record and in the next records the test case id's?
for example:
for example:
TS ID: 123
TC ID:
1220
1221
1222
is there a way to link between the first record to the next records? n:m links?
Thanks in advance.
![](http://jazz.net/_images/myphoto/d2b3561af992508bb5ce34a7f21c4936.jpg)
if there this way is impossible - maybe we can do it by linking Existing ID's,
for example:
TS ID: TC ID:
1 23452
1 35467
2 35461
1 46275
By this way I don't have the duplicate artifacts issue - is it possible to implement?
![](http://jazz.net/_images/myphoto/0227396f4efb17d0baa0c12dd70df878.jpg)
The examples that you showed above are both 1:n. In this case, you can find plenty of samples bundled with the ExcelImporter. But I understand that you want to link many test cases to many test suites, aka n:m. No?