It's all about the answers!

Ask a question

how to import new test cases but not overwrite old ones?


jane zhou (106865) | asked Mar 09 '20, 4:45 p.m.
edited Mar 09 '20, 4:48 p.m.

 

Hi Someone who may concern,

      We used RQM plug-in tool (6.0.6) for excel to upload test cases to RQM. (Microsoft Excel and Word to Rational Quality Manager Import Utility https://jazz.net/downloads/rational-quality-manager/releases/6.0.6/RQM-Extras-RQMExcelWordImporter-6.0.6-ifix003.zip)
      We mean to upload new test cases into RQM, but this plug-in tool has some rule for unique id, if testcase.XLSArtifactID is not given, it will use file name + sheet name+ row number as unique id when uploading, i.e. if it can find the same unique id in RQM, it will not create a new test case, but overwrite the existing test case in RQM. However, since we have many users, and we told them to use different file name for uploading new test cases, but someone always forgot this, and use the same name, and it make test case overwritten unexpectedly.

      So, we are wondering whether IBM provide any configuration in cfg file  to bypass this feature? i.e. ignore the unique id, just create new test case from excel file?

       In fact, we tried to specify a column as unique ID, but some users also make different test case with the same content for this column, so we are wondering whether we can bypass this unique ID checking, because our goal is to upload new test cases.

      If we want to update existing test cases, we will first export those test cases with test case ID in excel file, then define the column with id as unique id in our cfg file. so our test cases can be updated to RQM with the same test case ID.

     Thanks!

Best Regards,
Jane Zhou

  
      

One answer



permanent link
Mehul Patel (9695) | answered Mar 15 '20, 10:13 p.m.
FORUM MODERATOR

Jane,


No, configuration file doesn't support such feature to dynamically create the ID which is always unique/new.

Considering the scope of this add-in it may not be supported because this tool is offered as a one-time setup utility for importing test assets from Excel/Word to ETM and it is not designed to synchronise Excel/Word data with ETM. But you can try making use of Excel formulas to generate unique ID (may be using RAND) and using that ID with XLSArtifactID can solve your problem.

Regards,
Mehul

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.