It's all about the answers!

Ask a question

RQM Import Utility 6.0.2 - Issue in importing


Achla Mahendroo (13110) | asked May 02 '18, 4:12 a.m.

I am getting below issues when executing the RQM Import Utility:

1. The Test case imported from excel doesn’t contains Description & Pre-Conditions. Is there any way to include them?

2. In the imported excels few blank columns are present which is not required. Is there any way to filter them out before importing?

3. Can we have Test Case name just before the Steps column in the imported excel?

4.Unable to import bulk Test Cases in excel?

2 answers



permanent link
Don Yang (7.7k21109138) | answered May 02 '18, 11:10 p.m.

Hi, Achla

1. Are you referring to Samples in installed ExcelImporter? Many samples on test case would have description
testcase.dc:description defined in cfg file.
For Pre-Conditions, https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
would provide those info

Pre-Condition
id: com.ibm.rqm.planning.editor.section.testCasePreCondition
extensionDisplayName: RQM-KEY-TC-PRE-COND-TITLE

2.  If something is related to Excel file, you may hide those columns or rows. That is not related to the tool at all, pure Excel feature

3. Sure you can have Test Case name before steps column, it is up to your cfg file configuration pointing to which column to be test case name

4. If you try with Samples on Test Case, you would see the result in creating many test cases in RQM, not only one. You can refer to the sample and create your own excel file or cfg.
You can tell the tool like
// a new case starts when we encounter an empty row
testcase.XLSDelimeter=\n

to create multiple testcases so long as you have an empty row for each test case
   


permanent link
sreenath v (78167) | answered May 09 '18, 2:34 a.m.

 add those steps in configuration file and map again.It will get updated


//adding precondition and post condition step
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "Pre-Condition")=I
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition", "Post-Condition")=J

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.