Categories need to be uploaded from RQMExcelImporter.
I have created some categories and sub-categories in Test Case and I am trying to upload some Test case via RQMExcelImporter.
I made changes to my .cfg file as below:
testscript.XLSStartRow=2
testscript.XLSArtifactID=A
testscript.dc:title=A
testscript.jzalm:state=D
testscript.steps.type="execution"
testscript.steps.title=B
testscript.steps.name=B
testscript.steps.description=C
testscript.steps.expectedResult=D
testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=E
testcase.dc:description=F
testcase.dc.Capability=G
testcase.dc.Sub-Capability = H
testcase.jzalm:state=D
testcase.XLSLink=testScript
it didn't populate the values given in spreadsheet.
version 6.0
I made changes to my .cfg file as below:
testscript.XLSStartRow=2
testscript.XLSArtifactID=A
testscript.dc:title=A
testscript.jzalm:state=D
testscript.steps.type="execution"
testscript.steps.title=B
testscript.steps.name=B
testscript.steps.description=C
testscript.steps.expectedResult=D
testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=E
testcase.dc:description=F
testcase.dc.Capability=G
testcase.dc.Sub-Capability = H
testcase.jzalm:state=D
testcase.XLSLink=testScript
it didn't populate the values given in spreadsheet.
version 6.0
2 answers
Sousan,
Please refer RQM Excel Importer wiki for category related syntax. Installer copies sample file 'WOW Test Cases.cfg' which describes category related syntax.
Hope it helps.
Regards,
Mehul
You have 2 options to do it easily.
Quick Manual Work
1. I suppose you have data in Excel Sheet then just copy column with all values and then go to "Manage Project Properties" --> Artifact Categories --> Just click Create value and in New Value column , Just paste data you copied from excel you will be able to paste all values and save.
Using RQM Excel Importer
2. use below line to fetch category values
testcase.category term="Test Environment".value=J
Note "Test Environment" --> This value should be same as name in RQM.
If you find the answer helpful please mark it as correct.
Quick Manual Work
1. I suppose you have data in Excel Sheet then just copy column with all values and then go to "Manage Project Properties" --> Artifact Categories --> Just click Create value and in New Value column , Just paste data you copied from excel you will be able to paste all values and save.
Using RQM Excel Importer
2. use below line to fetch category values
testcase.category term="Test Environment".value=J
Note "Test Environment" --> This value should be same as name in RQM.
If you find the answer helpful please mark it as correct.