Excel Library/API for RTC?

paul ballard

(11●1●2) edited

Sep 28 '16, 8:31 a.m.

Hello,

Is there a library/reference that can be used to connect to RTC and download defects and execution stats in vba?

I saw

http://www.ibm.com/developerworks/rational/library/rational-team-concert-visual-basic/index.html?ca=drs-&cm_mc_uid=56866854873914749900596&cm_mc_sid_80200000=1475065521

but thats stand alone visual basic application or im misreading it.

I want to download a data dump from clicking a button.

Cheers,

Paul

0 votes

1 answer

6,940 views

0 votes

One answer

Permanent link

Miguel Tomico

(500●14●23) Sep 28 '16, 10:25 a.m.

I'm not sure if I understand your question. If you are looking into downloading work items from Excel via a macro, I would suggest to consider Jazz Reporting Service, which does that natively.

Check this out:

https://jazz.net/forum/questions/165207/looking-for-excel-macro-code-to-auto-refresh-jrs-live-data-data

(It's a bit old but still applicable, I think).

0 votes

Comments

paul ballard

Sep 29 '16, 4:44 a.m.

Thanks for that, but not quite right. I have multiple queries on RTC which I want to run and then download the results into an excel without ever actually opening RTC in a browser.

I would need to understand the business goal behind such a specific requirement to give you a proper answer, because there are several possibilities. I can think of: - Write a vba program to make OSLC calls to retrieve the work items, as explained in your original post. That requires some considerable effort. - Use CURL or write a program to download automatically those multiple queries as csv, then merge them to an Excel file using a macro. - Use JRS, as I suggested in my previous post. In my opinion, this would be the most elegant solution (and also effortless).

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

extending

× 11,106

rational-quality-manager

× 11,039

clm

× 7,622

rational-requirements-composer

× 3,951

Question asked: Sep 28 '16, 8:29 a.m.

Question was seen: 6,940 times

Last updated: Sep 29 '16, 6:19 a.m.

Excel Library/API for RTC?

paul ballard

1 answer

6,940 views

0 votes

One answer

Miguel Tomico

Comments

paul ballard

Miguel Tomico

Your answer

Follow this question

Question details

Related questions