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

Files generated by RQMExcelWordImporter does not have .xml extension

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?

0 votes

Comments

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
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.

0 votes


Permanent link

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

0 votes


Permanent link
 Peter,
After upgrading to 3.x are you now using the corresponding 3.x version of the RQMExcelWordImporter tool as well? 

0 votes


Permanent link
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.

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,019

Question asked: Nov 14 '12, 1:38 p.m.

Question was seen: 6,169 times

Last updated: Nov 16 '12, 6:27 p.m.

Related questions
Confirmation Cancel Confirm