It's all about the answers!

Ask a question

Is it possible import an image and text from excel to a TEST CASE section (eg TestCaseDesign) using RQMExcelImporter?.


Robert Quinn (111) | asked Mar 10 '14, 9:29 a.m.
I know it is possible to import to a Test Script but I can not get it to work to a Test Case section. When using the RQMExcelImporter it is possible to

  • import an excel cell containing an image and text to a field in the Test Script
  • import the text to a Test Case section and image as an attachment

but I want to import both text and image into a Test Case section. Is this possible?

2 answers



permanent link
Diao Xian Feng (361) | answered Mar 11 '14, 12:07 a.m.
hi Robert,

This is not support now, here we have a enhancement for this:
image not imported inside rich text section of Test Case using RQMExcelImporter 4.0.3 (90768)

permanent link
Don Yang (7.7k21110139) | answered Mar 11 '14, 1:41 a.m.
edited Mar 11 '14, 1:50 a.m.
Yes, this is possible.
For example, if you use sample "Test Cases made from scripts with images.cfg" and add the line like
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=image(F16)

in the end and then use the sample Test Cases made from scripts with images.xls to import to RQM, you should be able to see text with image(hammer in this case) added to Test Case Design section.
I tested with v4.0.5 RQM+4.0.6ExcelImporter and it works for me.

Please refer to https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter for more details on the usage.

Hopefully this helps.

Comments
Robert Quinn commented Mar 11 '14, 6:46 a.m.

Hi

I was using rqm4.0.5 and excelimporter4.0.5 and could only get the text.

Using your suggestion of rqm4.0.5 and excelimporter4.0.6 I am able to import either the image or the text but not both. Whichever is first is imported. eg if I use

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=image(B) & " " & B

I get the image imported but not text.


Don Yang commented Mar 11 '14, 10:01 p.m.

concatenation does seem to have problem in v4.0.6 when image and text are involved. you can put both text and image into the same cell so that using image() you can import both of them together.  Here is what it looks like using the sample Test Cases made from scripts with images.xls from the v4.0.6:







Robert Quinn commented Mar 12 '14, 7:06 a.m.

I still do not get the text. Looks like your screenshot is just the image without text which is what I also get.


Don Yang commented Mar 12 '14, 6:49 p.m.

Sorry that I missed out that part. you are right that only image or text will be imported in v4.0.6, concatenation does not work at this moment.

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.