Excel export to custom section in RQM
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
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
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