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.