Create Excel-Config for Category-Values
Hello,
I'm very new to this and I'm struggling with some basics.
-> How do I map columns in Excel to Categories in RQM? SOLVED (see comment below)
-> How can I prevent the RQM to create new categories?
We have:
- A RQM with TestCases
- custom Categories (already created)
- no SubCategories
- some are MultiValued
- some are "Required"
- some have space characters in the name
-
An Excel with many TestCases and columns for each Category
We want:
- Import new TestCases from Excel to the RQM
I already found:
- Sample "Categories and Types"
- Is this used to create new Categories in RQM? (Or is it necessary for the importer Add-In?)
- Sample "TestCases 001 with custom attributes"
- Is this the sample I'm looking for?
-
Documentation
Many thanks for any advice or direction you could provide.
Patrick
One answer
I found a solution. This is how my config looks now:
testcase.XLSStartRow=15The column "F" contains a category which does not exist in the RQM.
testcase.dc:title=A
testcase.dc:description=B
testcase.jzalm:owner=C
testcase.category term="Function".value=D
testcase.category term="Test Phase".value=E
testcase.category term="notExisting".value=F
After uploading the Excel file, the new category "notExisting" is created in the RQM automatically.
-> How can I prevent the RQM to create new categories?
If the user has a typo in his Excel I want to see an error message or something...