是否有可通过Excel的VBA直接拉动RTC数据的API？ [英] Is there an API available to directly pull RTC data through Excel VBA?

问题描述

有没有一种方式，通过Excel的VBA编程访问Rational Team Concert的数据？我现在需要手动登录到RTC，运行公共查询，然后手动选择导出到CSV选项。理想情况下，我想绕过所有这些手动步骤并直接（从RTC定义的查询或数据集返回）访问RTC数据。

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).

推荐答案

有是一个API，一个Java的。结果
<一href=\"https://jazz.net/forum/questions/96838/api-or-command-line-to-import-workitems-from-csv-to-rtc\"相对=nofollow>此线程提到实际上有两种API（在此的博客文章，一旦你的设置这些API ）：

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):

• 是在RTC（和JTS）
的服务器部分使用的服务器API

• 所使用的Eclipse客户端和普通的Java客户端库
客户端API

• The Server API that is used in the server part of RTC (and JTS)
• The Client API that is used by the Eclipse Client and the Plain Java Client Libraries

普通的Java客户端库比客户端SDK相当小，并为您提供只有API的有限子集。

The Plain Java Client Libraries are considerably smaller than the Client SDK and provide you with only a limited subset of the API.

但是，只有在客户端SDK人似乎包括 com.ibm.team.workitem.rcp.ui.internal.wizards.inport.WorkItemImportWizard 类，你将需要。

But only the client SDK one seems to include the com.ibm.team.workitem.rcp.ui.internal.wizards.inport.WorkItemImportWizard class you would need.

这意味着你将需要：

创建一个扩展Eclipse客户端和重用在导出向导使用code，类似<一个href=\"http://jorgediazblog.word$p$pss.com/2013/02/06/custom-bugzilla-importer-for-non-consecutive-bug-ids/\"相对=nofollow>这个博客帖子。

create an extension to the Eclipse client and reuse the code used in the export wizard, similar to this blog post.

这篇关于是否有可通过Excel的VBA直接拉动RTC数据的API？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！