It's all about the answers!

Ask a question

Files generated by RQMExcelWordImporter does not have .xml extension


Nur Azlyana Kasdirin (111) | asked Nov 14 '12, 1:38 p.m.
Hi,
I am exporting test script and test case from Excel. However, the files generated does not have .xml extensions. my config file is as follows:

testscript.XLSStartRow=3

testscript.XLSArtifactID=A
testscript.dc:title=A
testscript.dc:description=B

testscript.steps.type="manual"
testscript.steps.description=Q
testscript.steps.title=P
testscript.steps.name=P
testscript.steps.expectedResult=R

testscript.XLSDelimeter=\n
   
testcase.ID=testscript.XLSArtifactID

testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

testcase.owner=C
testcase.weight=K

testcase.category term="Function".value=H
testcase.category term="Test Phase".value="FAT"
testcase.category term="Priority".value="Medium"

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-DESIGN-TITLE")=L
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=M
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=N
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=Q

testcase.XLSLink=testscript

What did I do wrong?

Comments
Ara Masrof commented Nov 14 '12, 8:08 p.m.
JAZZ DEVELOPER

Nur,

When you perform the export in Excel, you are selecting the "Export to File' option, correct? If so, a log file should be created with details of the export attempt; have you looked at that? Does it contain errors or warnings?

Ara

4 answers



permanent link
Nur Azlyana Kasdirin (111) | answered Nov 14 '12, 9:34 p.m.
Nope. No error.
This is the heading:
11/14/2012 3:52:12 PM:
--------------------------------------------------------------------------------
11/14/2012 3:52:12 PM:
SESSION: 11/14/2012 3:52:12 PM

11/14/2012 3:52:12 PM: Getting artifacts from current document TC-TS.xlsx.xls
11/14/2012 3:52:12 PM: Created 186 artifacts, writing to files
11/14/2012 3:52:12 PM: Writing testscript 0 named R3000_VAR_001
11/14/2012 3:52:12 PM: Writing testcase 1 named R3000_VAR_001
11/14/2012 3:52:12 PM: Writing testscript 2 named R3000_CON_001
11/14/2012 3:52:12 PM: Writing testcase 3 named R3000_CON_001
11/14/2012 3:52:12 PM: Writing testscript 4 named R3000_CON_002
11/14/2012 3:52:12 PM: Writing testcase 5 named R3000_CON_002
11/14/2012 3:52:12 PM: Writing testscript 6 named R3400_HSK_000
11/14/2012 3:52:12 PM: Writing testcase 7 named R3400_HSK_000
11/14/2012 3:52:12 PM: Writing testscript 8 named R3100_ASB_001
11/14/2012 3:52:12 PM: Writing testcase 9 named R3100_ASB_001
11/14/2012 3:52:12 PM: Writing testscript 10 named R3100_BMS_001

This is the end:
11/14/2012 3:52:14 PM: Writing testscript 178 named R3400_HSK_001_BM_INT_LOG
11/14/2012 3:52:14 PM: Writing testcase 179 named R3400_HSK_001_BM_INT_LOG
11/14/2012 3:52:14 PM: Writing testscript 180 named R3400_HSK_001_BM_INT_TAB
11/14/2012 3:52:14 PM: Writing testcase 181 named R3400_HSK_001_BM_INT_TAB
11/14/2012 3:52:14 PM: Writing testscript 182 named R3400_HSK_003_BM_DW_LOG
11/14/2012 3:52:14 PM: Writing testcase 183 named R3400_HSK_003_BM_DW_LOG
11/14/2012 3:52:14 PM: Writing testscript 184 named R3400_HSK_003_BM_DW_TAB
11/14/2012 3:52:14 PM: Writing testcase 185 named R3400_HSK_003_BM_DW_TAB
11/14/2012 3:52:14 PM: finished writing artifacts

Sure, it is easy enough to use Notepad++ and do a global replace using Regular Expression. I was just wondering if there was something I was missing.

permanent link
Peter Storey (1137) | answered Nov 16 '12, 8:13 a.m.

Hi,

I am having exactly the same problem. Just wondering if you got to the bottom of it?

It only happened for me when I upgraded to 3.0.1

thanks,

Peter


permanent link
Ara Masrof (3.2k15) | answered Nov 16 '12, 8:22 a.m.
JAZZ DEVELOPER
 Peter,
After upgrading to 3.x are you now using the corresponding 3.x version of the RQMExcelWordImporter tool as well? 

permanent link
Nur Azlyana Kasdirin (111) | answered Nov 16 '12, 6:27 p.m.
Ara,
Yes I am using the corresponding 3.x RQMExcelWordImporter.
If I am to do just testcase by itself, the file generated does have .xml extension

Nur.

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.