Import data from CA Clarity into Excel using VBA

Question

I am trying to download resource names and hours for a specific project from CA Clarity PPM using Excel. I need the macro to access clarity PPM(www.abcd.hosting.ca.com) using username and password and download resource details if login is correct. Any suggestions how this can be done using VBA?

Thanks for your help.

score 2 · Answer 1 · answered Apr 08 '14 at 22:31

For every NSQL query that is created in Clarity a web service is also created. You could write something in VBA to authenticate to the web service and pull the information and then parse it appropriately.

Here is an example of VBA calling a web service:

http://www.webcontinuum.net/ws_4.aspx

Here is a link to get you started on integrations:

https://communities.ca.com/web/ca-clarity-global-user-community/message-board/-/message_boards/message/2295385

See the question "Q : Web Services Interface (WSDL)"

score 0 · Answer 2 · edited May 23 '17 at 11:59

0

If this can help other... I started the same work here but I am struggling myself to get information from Clarity ppm using their webservices...

Export Project List from Clarity PPM To Excel

Also, I Found this thread that provides great VBA Example : https://communities.ca.com/thread/117927268

edited May 23 '17 at 11:59

Community

1
1

answered Apr 30 '15 at 07:43

Raphaël Koch

21
6

Import data from CA Clarity into Excel using VBA

2 Answers2