One incorrect test case creating into RQM using RQMExcelWordImporter
![]()
I have 1to1 mapping in test cases & test scripts. So in my spreadsheet, I have a column "B" representing test case name. Using that column, I am writing below code:
testscript.XLSArtifactID="TS_" & B
testscript.dc:title="TS_" & B
testcase.ID=testscript.XLSArtifactID
//testcase.XLSArtifactID="TC_" & B ---with/ without this, not useful
testcase.dc:title="TC_" & B
for example if I have 2 test scripts in my spreadsheet then 2 test scripts are correctly imported into RQM but there are 3 test cases are imported; 2 are correct & linked correctly with test scripts and 1 incorrect test case (name with TC_ only. no content). Please let me know how can I escape from that incorrect test case?
With regards,
Vivek Agarwal
|
2 answers
![]()
Hi Vivek,
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:
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.
showing 5 of 9
show 4 more comments
|
![]()
Hi Vivek,
one alternative way is using testcase.dc:title=B instead of testcase.dc:title="TC_" & B |
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.