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

RQM Import Utility 6.0.2 - Issue in importing

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?

0 votes



2 answers

Permanent link

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
   

0 votes


Permanent link

 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

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
× 218
× 173

Question asked: May 02 '18, 4:12 a.m.

Question was seen: 2,625 times

Last updated: May 09 '18, 2:34 a.m.

Confirmation Cancel Confirm