bulk offline export to RQM server via ExcelImporter: any way to achieve that?
In RQM(4.0.6), when creating batch offline run rqms files, the user can only import to Excel through ExcelImporter one by one, this will be very tedious when the number of rqms files is large. There is an existing RFE workitem for the bulk import mode to be added in the tool.
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=124064
Does anyone know or already has been using any scripting way to make the batch import possible?
Would appreciate if any info can be shared here.
Thank you very much in advance.
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=124064
Does anyone know or already has been using any scripting way to make the batch import possible?
Would appreciate if any info can be shared here.
Thank you very much in advance.
Accepted answer
Hi Don,
You could export each RQMS file to XML and use the RQM Reportable REST API to bulk upload the execution results (see https://jazz.net/wiki/bin/view/Main/RqmApi#Bulk_Upload). However, each RQMS file must be opened and exported so there's no real benefit. Unfortunately, there is no way to invoke the RQM Excel/Word Importer programatically.
You could export each RQMS file to XML and use the RQM Reportable REST API to bulk upload the execution results (see https://jazz.net/wiki/bin/view/Main/RqmApi#Bulk_Upload). However, each RQMS file must be opened and exported so there's no real benefit. Unfortunately, there is no way to invoke the RQM Excel/Word Importer programatically.