It's all about the answers!

Ask a question

Import of Excel into RQM-how to import TestSuite Name?


Vinaya Bhat (579) | asked May 05 '14, 3:51 a.m.
Hi,

I am trying to import an Excel into RQM.In this,I am mainly interested in TestSuite Name as the rest are working fine.

I looked into the Samples provided by the Excel Exporter-"Testsuite with testcases that have testscripts.xls" and "Testsuite with testcases that have testscripts.cfg"

Added the below in my cfg file.Inspite of this addition,it gives an error while importing.

testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase



Can anyone please help me as what could I have probably missed?

Thanks!

5 answers



permanent link
anoop mc (74811196221) | answered May 05 '14, 5:01 a.m.
Could you please copy the error message the system gives.

permanent link
Vinaya Bhat (579) | answered May 05 '14, 5:14 a.m.
Initializing.....
Reading Configuration File....
Getting artifacts from document - "US50957_20140505115413.xls".....
Sending artifacts to https://xxx.com
Sending testscript 0 named US50957_20140505115413_US50957_Show_new_Icon_i_1.xml...
Sending testcase 1 named US50957_20140505115413_US50957_Show_new_Icon_i_1.xml...
Sending testscript 2 named US50957_20140505115413_US50957_Show_new_Icon_i_2.xml...
Sending testcase 3 named US50957_20140505115413_US50957_Show_new_Icon_i_2.xml...
Sending testsuite 4 named US50957_20140505115413_US50957_Show_new_Icon_i_1.xml...
Error sending to server US50957_20140505115413_US50957_Show_new_Icon_i_1.xml of type testsuite
The remote server returned an error: (500) Internal Server Error.
Sending executionworkitem 5 named US50957_20140505115413_US50957_Show_new_Icon_i_1.xml...
Sending executionworkitem 6 named US50957_20140505115413_US50957_Show_new_Icon_i_2.xml...


permanent link
Vinaya Bhat (579) | answered May 05 '14, 5:22 a.m.

I have attached the screenshot above

permanent link
anoop mc (74811196221) | answered May 05 '14, 5:47 a.m.
Look like these are the custom lines added by you.

testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase

I dont think we have an option to import testsuite name.

My Suggestion: After importing the testcases and testscripts why dont you create a Testsuites Manually and map the respective testcases under that.

permanent link
Vinaya Bhat (579) | answered May 05 '14, 5:59 a.m.
Hi Anoop,

Yes,these were the lines added by me.
testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase

I do not want to create TestSuites manually(I will keep this as the last option). I want to import 'TestSuite' from the Excel itself so that once I login into RQM,I see my testcases,testscripts and testsuites all ready and no manual work required.

Thanks!

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.