It's all about the answers!

Ask a question

Categories need to be uploaded from RQMExcelImporter.


sousan hussain (29754) | asked Nov 17 '16, 2:44 a.m.
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

2 answers



permanent link
Mehul Patel (9695) | answered Nov 17 '16, 9:06 a.m.
FORUM MODERATOR
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


permanent link
Salman Shaikh (23412873) | answered Nov 17 '16, 5:28 p.m.
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.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.