RQM-How to efficiently mark several TCs as supported for new product category/attribute
Hello,
In each TC, we have information to mention this TC can be used in which product. Normally, it can be used/tested in several products.
I implemented "Supported products" by creating category with same name (Supported Products), multiple valued. It contains product list such as: prod1, prod2, prod3,...
Assume that we have a new product, called prod4. And we need to mark several TCs as supported for prod4, but have no ideas to do it in bulk. Can you advise?
P/S:
1. I tried with TC view, select several TCs (TC1, TC2,..) and change category "Supported Products" to prod4, but this action erases all previous supported products of these TCs, not as my purpose: append prod4.
Before
TC1 Supported products: prod1,prod2,prod3
TC2 Supported products: prod1,prod2
After
TC1 Supported products: prod4
TC2 Supported products: prod4
My purpose
TC1 Supported products: prod1,prod2,prod3,prod4
TC2 Supported products: prod1,prod2,prod4
2. Tried with attribute, seem it is not better than implementation as Category
3. Probably we need to have many categories. The number of category equals to the number of products? Each TC will mark YES/NO at each product category column. If so, we have at least 90-100 product models, ie. 90-100 categories
Look it is not efficient, or will be limited in total number of category is 50 as mentioned here
3. Use RQMExcelImporter to upload TC with new supported product information to overwrite the same TC with "old" supported product information?
2 answers
To properly update a multi-valued attribute, you have to retrieve the old value first, unless you don't care what the original value is.
You can probably do something like this using Excel (on a high level).
1. Export the TCs to a Excel sheet, including the attribute to be updated.
2. Add a column to the Excel sheet with value ",prod4".
3. Merge the columns (by using a function or some sort).
4. Import the TCs back to RQM.
Comments
I suggest you can try the RQMURLUtility.
1) Create a query with filter which selects the Testcases and their attributes (products category). Run the query.
2) Download this result set as a CSV.
3) Use RQMURL utility to GET testcases as XML. Hint: Use the CSV file, RQMURLutility in a batch file to do this.
4) Use notepad++ or similar tool to make the changes to XML (add prod4 etc) using find and replace.
5) Do a POST in RQMURLUtility and VOILA!! you should be done.
Hope this helps.