Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Import Test Cases with category (Excel File) RQM 2

Questions
Tags
Users
Badges
Pierre Lemay
(6●1●4●2) Oct 30 '09, 11:51 a.m.
Import Test Cases with an Excel File

When I Import list of Test Cases without Category, all Test Cases in the Excel sheet are generated in an XML file.
(example of the Config file)
testcase.XLSStartRow=3
testcase.dc:title=B
testcase.dc:description=E
testcase.jzalm:owner=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L


When I Import list of Test Cases with at least one Category, only the first Test Case in the Excel sheet is generated in an XML file.
(example of the Config file)
testcase.XLSStartRow=3
testcase.dc:title=B
testcase.dc:description=E
testcase.category term="Category".value=M
testcase.category term="Function".value=N
testcase.category term="Test Phase".value=O
testcase.jzalm:owner=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L

Someone know how to generate all the Test Cases with the Category ?

0 votes

7 answers
12,829 views
0 votes

7 answers

Permanent link
Mark Watson
(21●1) Nov 09 '09, 9:31 a.m.
For what it's worth, I think I'm seeing the same behavior. I don't know how to make it work either.

0 votes

Permanent link
james eisenhauer
(36●5●5) Jan 12 '11, 1:47 p.m.
Has this ever been resolved? I can't get category to work correctly.

0 votes

Permanent link
Derek Lindberg
(26●2●2) Feb 11 '11, 10:46 a.m.
I had no problem...

testcase.XLSStartRow=2
testcase.dc:title=I
testcase.dc:description=L
testcase.category term="Category".value=C
testcase.category term="Function".value=E
testcase.category term="Theme".value=D
testcase.jzalm:owner=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=L
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults", "RQM-KEY-TC-EXPECTED-RESULTS-TITLE")=O

0 votes

Permanent link
Michael Tingey
(83●3●2) Jun 03 '11, 4:33 p.m.
I'm seeing the same thing, anyone have a solution?

testcase.XLSStartRow=2
testcase.jzalm:owner=A
testcase.dc:title=B
testcase.dc:description=C
testcase.category term="FVT Scenario".value=D
testcase.category term="LI".value=E
testcase.category term="Test Domain".value=F

Import Test Cases with an Excel File

When I Import list of Test Cases without Category, all Test Cases in the Excel sheet are generated in an XML file.
(example of the Config file)
testcase.XLSStartRow=3
testcase.dc:title=B
testcase.dc:description=E
testcase.jzalm:owner=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L


When I Import list of Test Cases with at least one Category, only the first Test Case in the Excel sheet is generated in an XML file.
(example of the Config file)
testcase.XLSStartRow=3
testcase.dc:title=B
testcase.dc:description=E
testcase.category term="Category".value=M
testcase.category term="Function".value=N
testcase.category term="Test Phase".value=O
testcase.jzalm:owner=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L

Someone know how to generate all the Test Cases with the Category ?

0 votes

Permanent link
Dan Powers
(6) Jun 09 '11, 11:20 a.m.
Here is my cfg file (below)

I pull in Function, Test Case, Description, Category and even set the test case/script to "underreview" so we can verify them after the import before they are ready to be used.

// this configuration file creates testscripts with testcases using self referential
// and column based data with categories

// Start looking for scripts after row 1
testscript.XLSStartRow=2

//a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
testscript.dc:title=E
//set testscript state to "Approved"
//testscript.alm:state ="com.ibm.rqm.planning.common.approved"
testscript.alm:state="com.ibm.rqm.planning.common.underreview"
testscript.dc:description=F

//step type is defined within the spreadsheet
testscript.steps.type="execution"
testscript.steps.description=I
testscript.steps.expectedResult=K

//test case defined with definite cell locations
testcase.dc:title=A2
//set testcase state to "Approved"
testcase.alm:state="com.ibm.rqm.planning.common.underreview"
testcase.dc:description=B2
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Pre(D2)

testcase.category term="Function".value=V2
testcase.category term="Category".value=U2
testcase.category term="Test Phase".value=W2
testcase.category term="Theme".value=X2

testcase.XLSLink=testscript

0 votes

Permanent link
Michael Tingey
(83●3●2) Jun 09 '11, 11:03 p.m.
Thanks Dan for the post. Examples like your's can save a lot of time.

I used someone else's cfg file and their's loaded fine. I then went back and tried mine again and it started working. Very strange.

Thanks again,

0 votes

Permanent link
Paul Slauenwhite
FORUM MODERATOR / JAZZ DEVELOPER (8.4k●1●2) Jun 10 '11, 3:54 p.m.
Thanks Dan for the post. Examples like your's can save a lot of time.

I used someone else's cfg file and their's loaded fine. I then went back and tried mine again and it started working. Very strange.

Thanks again,


For those you did not know, there are samples with the tool:

https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 30 '09, 11:51 a.m.

Question was seen: 12,829 times

Last updated: Oct 30 '09, 11:51 a.m.

Confirmation Cancel Confirm