An Excel utility to export ALM project customization
I have developed an Excel utility which can export ALM project customization. My purpose is to:
- Backup the ALM project customization. Before this utility, I record all customization in excel format manually.
- Easy and simple way for me to check if ALM project customization is as planning
- Can export the most entities fields customization, Project List, User groups and Users, Site parameters
- It use OTA and can work with ALM 11.00, 11.52 & 12.x.
Please see the attached zip file for Excel utility and pdf for screenshots. I want to share this with you and get some feedback to help me improve this utility. Thank you.
2016/4/29 - Removed the Chinese Sub name in the marco.
2016/5/10 - Support ALM 11.52 which doesn't have sanitization field property.
2016/05/13 - Connection error handling enhancment and fix Site Administrator fixed URL defect. Add Login dialog to hide the password
2016/05/17 - Support ALM 11 (Use GetTDVersion instead of GetTDVersionEx which ALM 11 doesn't have GetTDVersionEx)
Thanks Gary.With this new version,I was not able to see the rows 1 to 4 and row 5 being empty which usually used to ask the server URL and credentials along with domain\project info.I was able to see from rows 5 as attached in the screeenshot.
Please check if the rows are hidden in the updated version.I didn't have this issue with the previous version.
Thanks Gary,how do i get to this dialog box??When I open this spreadsheet it is not popping up any dialog box and I couldn't find the same in ALM tab as well.Please let me know if I am missing anything.
It looks like a very interesting utility. Though when I try to run the utility I get the following error:
I have registered HP ALM Client and I am using Windows 8. Any thoughts?