It's all about the answers!

Ask a question

Where to find examples of use of OSLC API's in Excel?

Pascal Jean (6011933) | asked Nov 17 '14, 11:33 a.m.
edited Nov 17 '14, 2:52 p.m. by Benjamin Silverman (4.1k610)


I'm using RQM 4.0.3.
I would like to use OSLC apis to populate Excel Worksheet.
I browse the official RQM documentation but there is no good starting examples. I don't find any good simple example using Excel VBA to have a good base for starting.   
Do you know a link where such information exists?

Thank you in advance
Pascal Jean

2 answers

permanent link
Benjamin Silverman (4.1k610) | answered Nov 17 '14, 2:13 p.m.
Hi Jean

I'm not familiar with using OSLC API's in Excel/VBA, but if you have plans to upgrade to 5.0.1 you can use the Jazz Reporting Service (JRS) to provide live query results to Excel via a web query.  I've attached some screenshots of how this looks after going through a simple exercise to show all Work Items in one of my RTC repositories.  JRS is bundled free with RRDI if you wanted to explore this in a sandbox first.  Hope it helps,

I get a report back with a page that looks like this:

My report is simple, but there are a lot of nice ways to slice and dice the data using the JRS editor, and any of those queries can be exported to Excel in the same way.  Maybe this will be an easier solution than what you are intending to do with 4.0.3?  However the minimum version of CLM needs to be 5.0.1 before you can use this method.

Pascal Jean commented Nov 18 '14, 11:11 a.m.

Thank you Benjamin,
This looks interesting. However we do not plan to upgrade within the next 6 months...
I'll keep your answer in mind until the upgrade.
Thank again
Pascal Jean

permanent link
Jean-Luc Johnson (8115) | answered Nov 18 '14, 11:16 a.m.
edited Nov 18 '14, 11:18 a.m.

I'm very familiar with OSCL. it is possible to extract the QM artifacts in the OSLC way to Excel. This could be done not only with VBA (I'm not good enough in VBA), but with a java library for Excel like Apache POI. Eclipse Lyo is an SDK to help developers extend their applications with OSLC capabilities. You could use the LYO class at to fetch the test cases from RQM. Then you could save them to an Excel sheet.
It is possilble to develop the same library purely in VBA but you would need to parse all the RDF/XML documents by yourself from the rootservices document, to every single QM artifact.

Best regards,
Jean-Luc Johnson

Your answer

Register or to post your answer.