One incorrect test case creating into RQM using RQMExcelWordImporter
2 answers
in your excel document, are there more than one worksheet and one is blank?
and are you using Excel IMporter 3.x, if so because you are using testcase.dc:title="TC_" & B
even blank worksheet will create new testcase as the title will not be blank, "TC_"+"" -> TC_ as title.
if you don't want to create it, just delete the blank worksheet will be ok.
by the way, we have fix the problem in Excel Importer 4.x in Excel migration when using only static cells and literal strings, empty worksheets still create XMLs (51394)
Comments
There is only one worksheet with test scripts. I don't have any blank worksheet. Excel importer version is "1.0.4465.14983". I am working on client's RQM sandbox on different network & not possible to switch to another version.
can you send me the use case through email?
I am not able, what is use case here? Also please let me know your email id.
Hi Vivek, you can send email to wanhaobj@cn.ibm.com, and send the excel and config file you met the problem, thank you.
Hi Hao, I don't have anything on my system, everything is on client network & not possible to transfer the file from there. I'll try to describe both the file here:
-
Excel sheet: S.No. Test Case Name Subject Step No. Action Expected Owner ------ ---------------------- ---------- ---------- -------- ------------ -------- 1 To check for... Objective: Step 1 Login.. success.. vivek
..... Step 2 ...... .......</n> 2 .......... .......... Step 1 ..... ........ xyz ...... Step 2 ...... ........
-
Config file: Almost (with some changes) similar to sample config file "Scripts that create testcases.cfg". What changes I have made in config file are mentioned in my original question.
Please let me know if you need any other information.
With regards, Vivek Agarwal
Hi Vivek, did you met the same problem when using the sample "Scripts that create testscase"? if not please suggest how to change the sample to recreated the problem you met, so we can better understand your problem.
Hao, problem is not due to changes in excel sheet. Problem is only due to changes in config file. For replicate the issue, you can make changes in config file with the help of first question which I have raised here.
Hi Vivek, I just tried with RQM Excel Importer 3.0.1.4, and using the similar config file as you mentioned, I met the same problem, and I tried with RQM Excel Importer 4.0 and it works fine, so the problem has been fixed in 4.0, if you need this fix in 3.0 please open a defect on 3.x importer.
Hi Hao, this new fix (on 3.x) will not be useful for me as this will not be available on client network. So I have to work on the same version & same fix. Please let me know any work around here.