Skip to main content

Technical

Uploading Test Cases to ALM via Excel

Shutterstock 321821180

A Quick Manual on how to Upload Test Cases to ALM using Excel

Creating test cases on HP Application Life-cycle Management (ALM) sometimes could be frustrating; the application may be running slow, it could be under maintenance, or maybe the tester has the test cases on a spreadsheet. Luckily we have Excel to save the day. Below are the steps needed to create and upload test cases into ALM.

  1. Go to your ALM application.

  2. Click on the Help menu on the left panel.

3.  Click on the Add-ins button:

Add-ins

  1. Click on the Microsoft Excel Add-In button.

HPE

  1. Click the Download Version link to save and install the downloaded file.

  2. Open Microsoft Excel; at the top menu, click on “HP ALM Upload Add-in.”

  3. Click on the ALM Login button:

Login

  1. Enter the ALM address, user, password, domain, and project fields. Click on Login.

  2. On the spreadsheet, create the following columns, and take a look at how each test case is identified; in the example below, we have two test cases: Test1 and Test2.

Table 1

Column Subject is the location within Test Plan where the test cases will be placed; the next columns are self-explanatory.

  1. Click on the Mapping button within the HP ALM Upload Add-in menu. Select “Tests” as the Entity type and create the following mapping:

Table 2

  1. Click on Validate button within the HP ALM Upload Add-in menu; a process will run, and then a confirmation message will be prompted: “The validation has passed.”

  2. Finally, Click on Upload to ALM.

After the process runs and confirmation is prompted, go into ALM and look for the test cases under the Test Plan section.

This is a very convenient way to create test cases; maybe you can find it faster than creating them directly on ALM.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Fernando Cortés

More from this Author

Categories
Follow Us
TwitterLinkedinFacebookYoutubeInstagram