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

RQM Excel Importer 4.0.1 - Cfg file with prev version not working

 Hello,

I am trying to migrate data from Excel to RQM. For this I am using RQMExcelImporter 4.0.1 so that I can make use of 'RichText' tag.
The configuration file mentioned below worked fine with previous version of Excel Importer. But it is not giving me correct results with 4.0.1 importer.
Please let me know if anywhere syntax to be modified


testscript.XLSStartRow=1
testscript.dc:title=B
testscript.dc:description=B
testscript.scripttype="Manual"
testscript.steps.type="Execution"
testscript.steps.description=K
testscript.steps.title=K
testscript.steps.name=K
testscript.steps.expectedResult=L
testscript.XLSDelimeter=\n 

testcase.XLSStartRow=1
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=G
testcase.dc:title=B
testcase.dc:description=F
testcase.category term="Execution Type".value=H
testcase.category term="Importance".value=I
testcase.category term="Category".value=N
testcase.category term="SubCategory1".value=O
testcase.category term="SubCategory2".value=P
testcase.category term="SubCategory3".value=Q
testcase.jzalm:state="com.ibm.rqm.planning.common.underreview"
testcase.XLSLink=testscript


Thanks.

0 votes

Comments

Instead of


testcase.XLSLink=testscript

Use this and try,

testcase.ID=testscript.XLSArtifactID 

This line should be added before testcase.XLSStartRow = 1

Thanks Shashank. I modified cfg file as you suggested.
But when I am trying to export from excel using this cfg, it is only exporting testscripts (not the testcases).
Please let me know if I am missing something



One answer

Permanent link
 Try this:
testscript.XLSStartRow=2
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

Best Regards
Rajat

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
× 12,020

Question asked: Feb 13 '13, 3:43 a.m.

Question was seen: 6,544 times

Last updated: Feb 19 '13, 6:34 a.m.

Confirmation Cancel Confirm