HP ALM is one of the widely used application to manage a project. HP provides an add-in to export test cases, defect and requirements to ALM from an excel sheet. Unfortunately, there is no easy way to export test cases from ALM.
Normally we use ALM query builder to export test cases from ALM. This task is difficult because we have to change the project name and other details every time we want to export test cases. In addition to this, excel sheet generated from query builder is not properly formatted and cleaned. So we thought of an add-in that can make things easier for people who use ALM.
Features of ALM to Excel Add-In from Nucleation.
- Save your server details and credentials for repeated use.
- Select domain and project.
- Select the test plan folder or the test set you want to export.
- Live export status.
- Prevents unwanted characters in the generated excel file by cleaning each cell.
- Strip unwanted html tags created due to the formatting done in ALM.
- Nicely formats the excel sheet generated.
- Register HP ALM Client on your machine.
- Launch Excel.
- Open Excel Options.
- Select Add-Ins.
- Click “Go” button at the bottom of the window.
- Browse and select the downloaded add-in file.
- Click OK.
Now you have installed the add-in.
After installing the add-in you can launch the add-in by clicking ‘Import From ALM’ button under the add-ins tab in excel.
- Step 1 of 6
Here you have the option to enter the ALM Server URL. You can save server details and credentials by clicking the settings button on the top of this page. Click ‘Next’ after entering your ALM Server URL.
- Step 2 of 6
Here you have to enter your credentials. If you have saved credentials, then it will get auto populated in respective fields. Click ‘Next’.
- Step 3 of 6
Select your domain and project. Click ‘Next’.
- Step 4 of 6
Select test plan folder. You can see the number of test cases selected for exporting. Click ‘Next’.
- Step 5 of 6
Here you can choose whether to strip HTML or not. If you uncheck this option, the file generated may contain unwanted html tags, which can cause difficulty in reading. Click ‘Next’ after selecting your choice appropriately. If the selected sheet is not blank, tool will prompt you with an option to choose whether to create a new sheet or overwrite the selected sheet.
When you click, ‘Next’ the tool will start importing test cases from ALM.
- Step 6 of 6
Here you can see the status of test case import from ALM. You can choose whether you want a formatted excel sheet or not.
Click here to view a sample excel file generated by the add-in.
Click the button below to download the add-in