It's all about the answers!

Ask a question

Excel export to custom section in RQM


Shivanand Divekar (621112) | asked Jul 20 '12, 1:30 a.m.

Hi,

I am using RQM Excel imort export utility (RQM 4.0 RC5 version) to export test artifact data to RQM. I have a custom section created in test case template. This custom section has grid with 4 columns and variable number of rows.

I want to know how do I format the excel file and write corresponding cfg file so as to export this data from excel to grid in custom section.

Has anybody tried this out.

One answer



permanent link
Hao Wan (1.5k35) | answered Jul 23 '12, 11:21 a.m.
JAZZ DEVELOPER
hi Shivanand,
you can try to copy the grid html content to one excel and do and get to the testcase to see the section id and do a get to the testcase this can refer to https://jazz.net/wiki/bin/view/Main/RqmApi#HTTP_GET_Requests

if the section is like
<dynamicSection_1343056482810 extensionDisplayName="my section"><div xmlns="http://www.w3.org/1999/xhtml">rich content</div></dynamicSection_1343056482810>
you can use the
testcase.Section("dynamicSection_1343056482810","my section")=Div(E10)  // cell E10 is the  cell contains the grid html

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.