Using external file test scripts
Hi all,
Bit of background... I'm in an environment which is fairly new to test management tools and they have thousands of test scripts in MS Word and in varying styles/formats.
Even if an import tool was available, I probably still wouldn't want to reformat all those Word docs. So, I want to be able to link a Word doc (or any other file) to a test case/script, and execute it.
I can do this reasonably well in CQTM by; defining a File Location, associating a file to a CTC (as a test script), then being able to add a Test Log against the CTC.
I'm guessing I need an Adapter for this??? Any ideas?
Thank you.
Bit of background... I'm in an environment which is fairly new to test management tools and they have thousands of test scripts in MS Word and in varying styles/formats.
Even if an import tool was available, I probably still wouldn't want to reformat all those Word docs. So, I want to be able to link a Word doc (or any other file) to a test case/script, and execute it.
I can do this reasonably well in CQTM by; defining a File Location, associating a file to a CTC (as a test script), then being able to add a Test Log against the CTC.
I'm guessing I need an Adapter for this??? Any ideas?
Thank you.
9 answers
There is an existing framework that can be used to import test plans, test scripts and test cases for Excel and Word...this is a Visual Studio project with C# code that allows you to manipulate formats programmatically. This utility works for 1.0 and 1.0.1. Import capabilities are now being designed for next generation RQM.
Currently work is being done on this utility (referred to as MSO2RQM) to add several other typical formats so that import is an easier job. The utility is officially unsupported based on the risks that users can add code to augment the capabilities, which would make it impossible to support in the field unfortunately.
Please reach out to me directly to obtain the utility - it is on an open source location as well which I will find and post.
Currently work is being done on this utility (referred to as MSO2RQM) to add several other typical formats so that import is an easier job. The utility is officially unsupported based on the risks that users can add code to augment the capabilities, which would make it impossible to support in the field unfortunately.
Please reach out to me directly to obtain the utility - it is on an open source location as well which I will find and post.
There is an existing framework that can be used to import test plans, test scripts and test cases for Excel and Word...this is a Visual Studio project with C# code that allows you to manipulate formats programmatically. This utility works for 1.0 and 1.0.1. Import capabilities are now being designed for next generation RQM.
Currently work is being done on this utility (referred to as MSO2RQM) to add several other typical formats so that import is an easier job. The utility is officially unsupported based on the risks that users can add code to augment the capabilities, which would make it impossible to support in the field unfortunately.
Please reach out to me directly to obtain the utility - it is on an open source location as well which I will find and post.
Hi pmancini,
We just browsed thorugh this post as we are having the requirement of uploading the manual test scripts into RQM which are maintained currently in an Microsoft Excel sheet. The code/utility that you were talking about will be very helpful to us fulffil our requirement.
Can you please send us the share location to my emailid
Kindly email the link to the utility;
I would like toimport excel test scripts into RQM
piyush
piyushsharma@rogers.com
I would like toimport excel test scripts into RQM
piyush
piyushsharma@rogers.com
There is an existing framework that can be used to import test plans, test scripts and test cases for Excel and Word...this is a Visual Studio project with C# code that allows you to manipulate formats programmatically. This utility works for 1.0 and 1.0.1. Import capabilities are now being designed for next generation RQM.
Currently work is being done on this utility (referred to as MSO2RQM) to add several other typical formats so that import is an easier job. The utility is officially unsupported based on the risks that users can add code to augment the capabilities, which would make it impossible to support in the field unfortunately.
Please reach out to me directly to obtain the utility - it is on an open source location as well which I will find and post.
I believe this is the link you all are looking for. I've been learning to use this import tool the past few days and have had some success with it.
https://jazz.net/downloads/rational-quality-manager/releases/2.0.0.1?p=allDownloads
Scroll down to the bottom of the page to the Extras section to find the link for the import tool, as well as other tools.
https://jazz.net/downloads/rational-quality-manager/releases/2.0.0.1?p=allDownloads
Scroll down to the bottom of the page to the Extras section to find the link for the import tool, as well as other tools.