RQM Excel Import Tool: Test Design losing formatting
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: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.
- bullet point 1
- bullet point 2
- bullet point 3
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
Accepted answer
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(...)
Comments
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.
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 :)
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.
Comments
Don Yang
Mar 18 '14, 5:15 p.m.you may want to provide sample xls and cfg files here for verification.