Quality Center / ALM User Discussions
cancel

Excel macro to export execution status from ALM

Highlighted
Shadhu
Senior Member.

Excel macro to export execution status from ALM

I have been looking to extract daily execution status from ALM 12.55 to excel sheet through excel macro.

We have two options

1. A Dashboard>>Analysis Veiw, where we get the consolidated status on each day like, Pass, failed, Blocked etc.

2. Test lab>> Test Set folder of respective releases

Could some one help me with this?

2 REPLIES
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: Excel macro to export execution status from ALM

Hello, 

At the moment, we do not have professional resources that can help us to create the code you need.

Yet, we have documentation and examples in where you can follow and customize your own code.

 

 

Test Lab OTA API samples:

https://softwaresupport.softwaregrp.com/group/softwaresupport/search-result/-/facetsearch/document/KM183648

 

OTA API reference guide:

https://admhelp.microfocus.com/alm/en/12.53/online_help/Content/api_guides_main_page.htm

 

How to generate the status report of test in testset using the API

https://softwaresupport.softwaregrp.com/group/softwaresupport/search-result/-/facetsearch/document/KM185939

 

Thank you

Best Regards

Sumeet_Kushwah Super Contributor.
Super Contributor.

Re: Excel macro to export execution status from ALM

It can be easily done using OTA API. You can connect Excel to ALM and then download the data using SQL queries. If you have any questions then you can post specific questions and someone will reply,

You can look into this article to get started with the OTA API 

https://sumeetkushwah.com/2015/03/19/connecting-almqc-using-hps-otaopen-test-architecture-api/

Thanks,
Sumeet Kushwah