Issue in importing TC, TS, and TCER into RQM 6.0.3 using Excel Import Utility
Tools used: RQM 6.0.3, Excel 2013, Import Utility 6.0.3, .Net Framework 4.5
Test artifacts consist of Test Cases, Test Scripts, and Test execution Results all in one Excel file.
To verify the RQM Import utility, I have used the following sample Excel and Config files:
- Scripts that create testcases with TCER.xls
- Scripts that create testcases with TCER.cfg
I have the following questions:
- Do I need to import the test case and test script separately then add the imported test script to the test case in RQM test case window?
- What about the execution record? how to import them and ensure they are linked?
-
Is this the right config file to use?
-
What is meant by the execution work items generated? link to RTC work items?
I had the expectation that if I import the test case, it should automatically import the test script (or test steps) and execution results associated with each step along with the pass/fail status for each step. But that did not happen.
Can you please outline the procedure to follow? Thank you.
Accepted answer
Hi, Nadra
When you open Scripts that create testcases with TCER.xls, go to Addin > RQM > Export to Repository
(instead of export to file which you are seeing those files and worrying about the link etc)
Then in the Export To RQM dialog, filling the right RQM repository info
such as RQM server: https://yourserver:port/qm
Enter User Name and Password, then you should be able to see the project area list, select the project you want to Export those artifacts to, then click 'Export', once completed with no problem, you should see them in the project
and the tool will take care of the link itself.(as you are trying the sample, cfg file has done those for you)
I hope this helps.
Comments
Thank you Don for the information. I have followed these steps and was able to see better result by importing into the repository with the same config file,
However, I did not see the actual results per test step. I only saw the execution record for the test case not at the test script level.
Can you please clarify how to import the actual test results at the test step level (not test case level)?
Thank you for your help.
You may want to refer to Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.xls and Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.cfg for the sample on how to export step results and overall result into RQM.
One other answer
Firstly, you need to have the corresponding version to 6.0.3 for the Excel plugin. Uninstall the current and add the new one: https://jazz.net/downloads/rational-quality-manager/releases/6.0.3/RQM-Extras-RQMExcelWordImporter-6.0.3.zip