Often times, you might have data requirements which are documented in external data source files such as Comma separated Value (CSV) or Microsoft Excel worksheet. Microsoft Excel and Word are popular document formats used by many test organizations to author, store and maintain their test assets. These document formats are easy to use and widely available.
So if any of your project teams are working on such external data sources and want to import the data involving relevant image files into IBM Rational Quality Manager (RQM), they can make use of the RQMExcelImporter utility.
In fact, RQM software helps teams share information seamlessly, use automation to accelerate project schedules and report on metrics for informed release decisions.
Rational Quality Manager helps quality assurance teams by providing the below functionalities.
- Collaborate - share project information and status updates seamlessly so team members can synchronize teamwork throughout the lifecycle.
- Automate - reduce labor-intensive activities to accelerate project schedules.
- Govern - understand and report on project metrics to enable accurate, reliable and timely release decisions.
Below is one such scenario which will describe how to import a few test assets and an image specifically into RQM. It also describes a defect behavior of the imported images (part of Test Case Design section in RQM), not getting exported to PDF file, though the import was successful.
For example: Image is successfully imported into Test case design section, but when we create a comprehensive PDF export, the image does not get exported. Interestingly, if you manually cut past an image within the Test Case Design section in RQM, the import gets exported to PDF successfully.
Debugging this problem, prompted a couple of questions like...
- RQMExcelImporter did import the image and data successfully into RQM. So where does the bottleneck appear??
- Is it the PDF export engine which is not retrieving the images from the relevant section of RQM??
- Did the RQMExcelImporter utility import the image in required format supported by RQM??
Let's analyze this scenario now...
Below is the snapshot of the data which is documented in the MS Excel worksheet.
Following is the Configuration file (CFG file) which will map to each entries present in the rows and columns of this worksheet .
// Start looking for scripts after row 2
//Creating Test Scripts
//Test Script steps are created and updated as given in Excel
testscript.steps.description=H & " " & image(H)
testscript.steps.expectedResult=I & " " & image(I)
// a new script starts when we encounter an empty row
// we want to use the data we got for each test script to create a test case
//Test Case is Created with required fields given below . Test Case is created with the same name of Test Script here.
//Below custom Attribute values are updated.
testcase.category term="Test Type/Application".value=B
Using the RQMExcelImporter utility, import the Excel data into RQM and you should see the data layout as shown below:
So, once you have the data imported, you can export this data to available PDF formats in RQM.
However the exported PDF does not display the image as you can see in the below snapshot:
This behavior is reported as a product defect (APAR PI46577). You may reach out to IBM Rational Support team for any further clarifications on this defect.