In my project, We follow agile methodology for our software development & we have release once in every 4 weeks. With continuous development, build & testing, we used to spend a lot of time in sending out a detailed status email on defects for each project to higher management.
In this article, I would like to show how I have implemented an automated status report email for my project where HP ALM(QC) is used for defect management.
HP ALM:
ALM (Application life cycle management) is a web based application from HP used to manage the project planning, requirements, test cases, defects etc. It used to be called Quality Center (QC) till its version 10.
Design / Framework:
- There is an external property file which contains ALM project details to send this automated email for any project just by updating the property file.
- I have created a .Net exe which contains 4 important modules/classes.
- ALMUtil – to connect ALM & get the information from ALM server for the given project.
- ChartUtil – to create nice graphs for the given data.
- ResultBuilder – to combine the chart & other information into a nice readable status report.
- MailUtil – to send the email to the team.
Sample Defect Status EMail:
Summary:
By using ALM API – I came up with an executable which has been scheduled to run @5PM daily to send the defects status to the entire team. It has been designed to be customized for any project.
It saves 30-45 mins of our time from sending daily status email & It can also help us in sending the status more often.
Hello,
This article looks amazing.
However, i cannot implement the same things for my ALM since i do not have your .Net exe files…
I wonder if it is ok to ask you that you can share these exe files.
Thank you,
Esti
Hi, this post is amazing! Could you share your .Net exe files if you don’t mind?
Thank you!
Ismael.
Hi,
The report looks awesome…
Even we are planning to do such reports in our project aswell. As part of this it would be very helpful if you share the below details.
1. What tool have you used to prepare this report
2. Which language have you used?
Kindly provide these details so that we can also impliment this in our project.
Thanks in advance!
Thanks.
I did not use any tools for this. I created my own exe in .net which will
pull the data from QC/ALM using its API
create the tables & images
send the status mail
Can you please elaborate on creating these reports please. It would be very helpful if you could guide us by sharing how you started and the step by step process so that we can also do the same in our projects.
Hi,
if possible Can you share .net exe files.
thnx
Friend, Unfortunately I can not share it. I am really sorry about that!!
Did you store the data into an excel sheet then read from that or use virtual storage. I am trying to create similar for my company but when i use a virtual store its causing a few problems.
Just wondering what storing method you used for your API pull out?
Sir..sorry that i do not understand what you mean by storing method. I just call the API to get the data for the given filters, then write the data in a HTML format.
Hi I am looking to create similar utilities , can you some pointer – may be like setp by step approach of doing a similar stuff
Hi,
Are you selling this .exe file? I would be happy to buy
Lol come on dude!……..im sure you were lying
Please share those files…..sharing is caring
Hi,
Can I get your contact details. Need to find out more on this.
Regards,
Dipali
Somehow this went to spam. You still need information on this? mail to vino.infy@gmail.com
May I ask, how long did it take you to do this? Awesome work!
Chart creation part took some time. I was doing this after office hours for more than a week – almost for 2 hrs a day.
That’s awesome – I need to learn .net, because what you did looks great. Last question, I’m trying to do something similar, but extract data, process it into a file, then push it back into QC. Does the API allow for data to go back in? Sorry if it’s a noobie question, just trying to learn.
Ofcourse you can push the data to ALM. ALM12 exposes REST API I believe. You do not have to learn .net just for this. you should be able to use any language. Good luck.
Thanks! And thanks for taking the time to answer!
Hi.. Its a great tool. I’m expected a tool like this for QTEST.. Is it possible to do the same for that.. If so could you help me out
Arun, I never used QTEST. As long as there is an API for QTEST, there should not be any issue in doing this. I did exactly the same for JIRA as well which has a set of API to get the data.
Can you please tell me the name of the API you have used for pulling the data from ALM. Please reply as soon as possible, as it is very urgent.
I had used ALM OTA lib for extracting data when I had done this many years ago – http://alm-help.saas.hpe.com/en/12.50/api_refs/ota/webframe.html
Hi, this looks promising. Did u use SMTP for email? Does ALM rest api have emailing?
Yes, I used SMTP for emailing. It was done many years ago using ALM COM API. not REST. But the concept remains same anyway.