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

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

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!

0 votes



5 answers

Permanent link
Could you please copy the error message the system gives.

0 votes


Permanent link
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...

0 votes


Permanent link

I have attached the screenshot above

0 votes


Permanent link
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.

0 votes


Permanent link
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!

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.

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: May 05 '14, 3:51 a.m.

Question was seen: 3,768 times

Last updated: May 05 '14, 5:59 a.m.

Confirmation Cancel Confirm