It's all about the answers!

Ask a question

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


Komal Mirchandani (1266) | asked Feb 13 '13, 3:43 a.m.
retagged Feb 15 '13, 2:18 p.m. by Laura W. Hinson (16126)
 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.

Comments
Shashank Bellary commented Feb 15 '13, 2:38 p.m.

Instead of


testcase.XLSLink=testscript

Use this and try,

testcase.ID=testscript.XLSArtifactID 

This line should be added before testcase.XLSStartRow = 1


Komal Mirchandani commented Feb 19 '13, 5:20 a.m.

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
Rajat Singh (59833545) | answered Feb 19 '13, 6:34 a.m.
 Try this:
testscript.XLSStartRow=2
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

Best Regards
Rajat

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.