Is there a way to programmatically access Rational Team Concert data through Excel VBA? I currently need to manually log into RTC, run a public query, then manually select the "Export to CSV" option. Ideally, I'd like to bypass all of these manual steps and access RTC data directly (or the set of data returned from a defined query with RTC).
There is an API, a Java one.
This thread mentions there actually two APIs (detailled in this blog post, once you have setup those API):
The Plain Java Client Libraries are considerably smaller than the Client SDK and provide you with only a limited subset of the API.
But only the client SDK one seems to include the com.ibm.team.workitem.rcp.ui.internal.wizards.inport.WorkItemImportWizard class you would need.
That means you would need to:
create an extension to the Eclipse client and reuse the code used in the export wizard, similar to this blog post.