Updating the Custom Attributes when importing test cases from excel using Excel importer utility
![]()
Shashank Bellary (46●1●6●7)
| asked Feb 15 '13, 4:22 a.m.
retagged Feb 15 '13, 3:34 p.m. by Laura W. Hinson (161●2●6)
Hi,
We recently migrated to RQM 4.0.01 and I am using excel importer utility to export the test cases from Excel to RQM Repository. Before 4.0.* Custom Attributes were not supported to be exported using excel but I came to know that it is supported after 4.0.* but it is not working for me.
Below is my config file content
testscript.XLSStartRow=6
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C
testscript.steps.type="execution"
testscript.steps.description=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F
testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.alm:state="Approved"
testcase.weight=I
testcase.category term="TestType".value="Functional"
testcase.category term="TemplateFolder".value="FeatureSpecific"
testcase.category term="Test Phase".value="Functional Test"
testcase.category term="Feature".value=K
testcase.category term="SubFeature".value=L
testcase.customAttributes identifier="User_Story_".name="User Story#".type="INTEGER".value="12345"
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=C
testplan.identifier="urn:com.ibm.rqm:testplan:1428"
testplan.XSLLink=testcase
executionworkitem.XLSStartRow=1
executionworkitem.XLSLink=testscript
executionworkitem.dc:title=testcase.dc:title
executionworkitem.dc:description=testscript.dc:description
executionworkitem.category term="TrackedUnder".value=C3
executionworkitem.category term="PlannedFor".value=C1
executionworkitem.category term="MileStone".value=C2
I am trying to export a test case which has test script and an Test Execution Record.
Test Case has Custom Attributes ( Marked in Bold ) in the above config file content.
It is not getting updated.
I am also trying to link the newly created test case to an existing test plan . That is also not getting linked.
Please have a look and let me know what is wrong in the config file.
Thanks,
_Shashank
|
5 answers
![]()
Hi Shashank,
The version 4.0.1 information center contains several topics about exporting test artifacts into the QM application. See http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.rational.test.qm.doc/topics/c_import_word_excel.html and the topics within that section. In particular, the topics about creating configuration files might be helpful. |
![]()
Hi Shashank, the format of specifying the id is
testplan.XLSArtifactId="urn:com.ibm.rqm:testplan:1428" not testplan.identifier="urn:com.ibm.rqm:testplan:1428" you can change you config file and exporting again. |
![]()
Hello Hao Wan,
Thanks for the reply, yes I did try this. It did not work.
Getting this error after adding that line,
02/20/2013 3:26:25 PM: sending testplan3 named sampletest_1_1.xml
02/20/2013 3:26:27 PM: Server returned code InternalServerError
02/20/2013 3:26:27 PM: Error sending to server sampletest_1_1.xml of type testplan
02/20/2013 3:26:27 PM: Internal Server Error
02/20/2013 3:26:27 PM: sending testplan4 named sampletest_1_2.xml
02/20/2013 3:26:29 PM: Server returned code InternalServerError
02/20/2013 3:26:29 PM: Error sending to server sampletest_1_2.xml of type testplan
02/20/2013 3:26:29 PM: Internal Server Error
02/20/2013 3:26:29 PM: sending testplan5 named sampletest_1_3.xml
02/20/2013 3:26:31 PM: Server returned code InternalServerError
02/20/2013 3:26:31 PM: Error sending to server sampletest_1_3.xml of type testplan
02/20/2013 3:26:31 PM: Internal Server Error
02/20/2013 3:26:31 PM: sending testplan6 named sampletest_1_4.xml
02/20/2013 3:26:33 PM: Server returned code InternalServerError
02/20/2013 3:26:33 PM: Error sending to server sampletest_1_4.xml of type testplan
02/20/2013 3:26:33 PM: Internal Server Error
02/20/2013 3:26:33 PM: sending testplan7 named sampletest_1_5.xml
02/20/2013 3:26:36 PM: Server returned code InternalServerError
02/20/2013 3:26:36 PM: Error sending to server sampletest_1_5.xml of type testplan
02/20/2013 3:26:36 PM: Internal Server Error
02/20/2013 3:26:36 PM: sending testplan8 named sampletest_1_6.xml
02/20/2013 3:26:39 PM: Server returned code InternalServerError
02/20/2013 3:26:39 PM: Error sending to server sampletest_1_6.xml of type testplan
02/20/2013 3:26:39 PM: Internal Server Error
02/20/2013 3:26:39 PM: sending testplan9 named sampletest_1_7.xml
02/20/2013 3:26:41 PM: Server returned code InternalServerError
02/20/2013 3:26:41 PM: Error sending to server sampletest_1_7.xml of type testplan
02/20/2013 3:26:41 PM: Internal Server Error
02/20/2013 3:26:41 PM: sending testplan10 named sampletest_1_8.xml
02/20/2013 3:26:43 PM: Server returned code InternalServerError
02/20/2013 3:26:43 PM: Error sending to server sampletest_1_8.xml of type testplan
02/20/2013 3:26:43 PM: Internal Server Error
And it is sending test plan for each line in the sheet. How do I make it once per sheet ?
_Shashank
|
![]()
I got the Custom attributes working,
My config file has the below lines now,
testcase.customAttributes.identifier="My_Custom_Attribute"
testcase.customAttributes.name="My Custom Attribute"
testcase.customAttributes.type="INTEGER"
testcase.customAttributes.value="12345"
Linking to Test Plan still did not work :(
|
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.