Where to find examples of use of OSLC API's in Excel?
Hello,
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
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.
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.
Hello,
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 http://git.eclipse.org/c/lyo/org.eclipse.lyo.client.git/tree/org.eclipse.lyo.client.java.sample/src/main/java/org/eclipse/lyo/client/oslc/samples/RQMFormSample.java 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
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 http://git.eclipse.org/c/lyo/org.eclipse.lyo.client.git/tree/org.eclipse.lyo.client.java.sample/src/main/java/org/eclipse/lyo/client/oslc/samples/RQMFormSample.java 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