It's all about the answers!

Ask a question

bulk offline export to RQM server via ExcelImporter: any way to achieve that?


Don Yang (7.4k2195130) | asked Nov 05 '14, 3:51 a.m.
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.

Accepted answer


permanent link
Paul Slauenwhite (8.3k12) | answered Nov 07 '14, 7:13 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.
Don Yang selected this answer as the correct answer

Comments
Don Yang commented Nov 11 '14, 9:41 p.m.

Thanks Paul for the info and confirmation.

Your answer


Register or to post your answer.