It's all about the answers!

Ask a question

RQM Excel Import Tool: Test Design losing formatting


Robin Parker (32633739) | asked Mar 18 '14, 6:46 a.m.
Hi all,

I have a problem importing some test cases from a spreadsheet into RQM using the RQM Excel Import tool.

There are some cells that look something like this:
Some text here at the top followed by a colon:
- bullet point 1
- bullet point 2
- bullet point 3
When something like this gets imported in the TestCase Description, the formatting is preserved.  When it gets imported into the TestCase Design, the carriage returns are removed and all of the text is put into one long string which makes it hard to read.

Does anyone have any suggestions about how we might alter this behaviour?

We're using CLM 4.0.6 on the server and the 4.0.6 version of the import tool with Excel 2003 on WinXP SP3.

Many Thanks,

Robin







Comments
Don Yang commented Mar 18 '14, 5:15 p.m.

you may want to provide sample xls and cfg files here for verification.

Accepted answer


permanent link
Diao Xian Feng (361) | answered Mar 19 '14, 10:02 p.m.
Hi Robin,

In Excel, you can try below content in cell:
Some text here at the top followed by a colon:<br />
- bullet point 1<br />
- bullet point 2<br />
- bullet point 3


And for .cfg file, you can use:
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=DivHtml(...) 


Robin Parker selected this answer as the correct answer

Comments
Robin Parker commented Mar 20 '14, 5:01 a.m.

Thanks for your reply.  However, this didn't seem to work for me...  Just to check I'm doing it right, my entry in the cfg file is:
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=DivHtml(C)
where column C is the column holding the required text input.
Am I using it correctly?
Thanks.


Diao Xian Feng commented Mar 20 '14, 5:06 a.m.

Sorry I missed some html codes:

Some text here at the top followed by a colon: <br />

- bullet point 1 <br />

- bullet point 2 <br />

- bullet point 3

Please add the html codes, and try again :)


Robin Parker commented Mar 20 '14, 5:18 a.m.

Ok a quick re-read of the README.html, specifically the 'Modifiers of data' section reveals two modifiers... Pre and Div.  I'm not sure what the difference is yet but I tried Div and that seems to do what we want so I'll consider this question answered.

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.