It's all about the answers!

Ask a question

ETM (RQM) Excel Uploader flexible config


Sandro Gross (174) | asked Jun 30 '22, 10:43 a.m.
edited Jun 30 '22, 10:48 a.m.

 Hello together

 Is it possible a search option to create in the RQM uploader config file?

I would like to build a flexible config file which is not dependent on an exactly target cell.

Original from config file

// TC / Preconditions

testcase.customAttributes name=B1.value=B

  

Idea which I have

The name “Preconditions” is anywhere in the row.

(this example is like a VBA makro)

 Set find = Range(“A1:C1”).Find(what:=”Preconditions”, MatchCase:False)

 // TC / Preconditions

testcase.customAttributes name=find.column.value= find.column

One answer



permanent link
Ralph Schoon (63.5k33646) | answered Jul 01 '22, 9:09 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I have no idea, but my best guess would be: Probably Not.

If you want to follow your Idea, I would suggest to use a different approach and instead generate your target excel from your source file. The target Excel needs to follow the ETM conventions, but your source file does not have to.

Comments
Sandro Gross commented Jul 06 '22, 9:05 a.m.

Hello Ralph 


Thanks a lot for your answer.
I thought that is possible, because I came to this idea:

RQM wiki.
requirement.XLSStartRow=FindRow(“Start on this row”)
requirement.dc:title=FindColumn(“Title Header”) 

My source is a csv file by RQM Job Queue download or Report Builder.
Well, I should think about another way (maybe)

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.