It's all about the answers!

Ask a question

Rational Quality Manager Excel Importer, use test case id instead of test case name as unique identifier


Jeffrey Behnke (27218) | asked Nov 30 '16, 10:27 a.m.
Hi. We are using the Excel Importer to import data into the tool. 

After reviewing the sample excel and config files, is there a way to configure the import to look at the unique test case id instead of the test case name to determine if a test case exists? 
If the test case exists, updates would be made to the existing test case. 
If the test case does not exist,  a new test case would be created.

In addition, would this work for a custom attribute field?
The custom attribute field in our example would be a unquie test case id from another quality management tool.

If I have missed in the documentation, please let me know. All feedback and information is appreciated.
Thanks!

Accepted answer


permanent link
Mehul Patel (9695) | answered Dec 02 '16, 5:44 a.m.
FORUM MODERATOR
Jeffrey,

No we can't configure tool to set rules. But if you specify list of test case IDs in a excel column and configure it in cfg file with 'XLSArtifactID' then excel import tool will update the existing test case (whose ID matches with the ID from excel column) and will create new test case for the rest.

For custom attributes, if those attribute’s property matches with the project’s existing attributes then it will be used otherwise new attributes will get created.

Regards,
Mehul
Jeffrey Behnke selected this answer as the correct answer

One other answer



permanent link
Jeffrey Behnke (27218) | answered Dec 02 '16, 7:02 a.m.
Mehul,

Thank you for your reply. We are able to update from an excel file using a column, but this process identifies the test case by the name. We would like to update the Quality Manager test case by using the unique Quality Manager test case id as this is a value that can not be updated by an edit user. The excel would look for test case id rather than name, ex: 93: test_case_0101.

Excel would look for 93 instead of test_case_0101

Thanks,
Jeff

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.