Share this page

# Upload data to ALM

Log in to your ALM server, map ALM and Google Sheets data, validate the data, and then upload your data to ALM.

In this topic:

## Log into ALM from the add-on

Connect to your ALM project from within the Google Sheets add-on.

1. Open a Google Sheets spreadsheet.

2. Select Add-ons > Micro Focus ALM > Start.

3. In the login page, provide the following information.

   Field | Description
   --- | ---
   Server Address | Enter the ALM server address in the following format: `http://<server name>[:port]/qcbin`
   Authentication Method | Select an authentication method: Username & Password: Select this if you want to log in with your username and password. API Key & Secret: Select this if you want to log in with your API key and API secret.
   Username Password | If you select to use username and password to authenticate, enter your username and password.
   Client ID Secret | If you select to use API key and secret to authenticate, enter your Client ID and secret.
   Automatically log into my last domain and project | Select this if you want to log into your last domain and project after getting authenticated.

   For SSO users: If you already logged into another application with your credentials, you only need to specify the ALM server.

4. Click Authenticate.

5. Select the domain and project you want to connect to.

Back to top

## Map data

You can manually map ALM fields to spreadsheet columns, or the Google Sheets add-on can automatically map them.

To map your data:

1. Select the cells in your Google Sheets spreadsheet that contain the data that you want to upload. Do not include the column headings row in your selection.

2. Click Mapping. The Field Mapping dialog box opens.

3. Click Open to open the file explorer to search for existing mapping files to use for mapping your spreadsheet data. The file contains the entity type and the field mapping to use.

4. Select the entity type (Requirements, Defects, or Tests) to which you are mapping your data. The ALM fields for the selected entity type appear in the lower left pane. The required fields appear in red in the lower right pane.

   Note: If you select Requirements, you can apply a requirement type to assign to all requirements you are uploading.

5. Map your Google Sheets spreadsheet columns to the ALM fields:

   - Manually. Move the non-required ALM fields to which you want to map from the left pane to the right pane, and then enter the Google Sheets spreadsheet column letter that corresponds to each ALM field.

   - Automatically. Click Auto-map and enter the column headings row number.

     Note: The column headings must exactly match the ALM field names.

6. Unselect Add ALM field label as header to Google Sheets if you do not want to create a header row in Excel.

   Note: If you click Auto-map, you will be prompted to unselect Add ALM field label as header to Google Sheets.

7. Click Save if you want to save your field mapping for future use.

8. Click OK to apply your mapping to your Google Sheets spreadsheet.

Back to top

## Validate data

Once you have mapped your data to the ALM fields, you must check that your data is valid for its mapped field. For example, if the ALM field allows only certain values, your data cannot contain other values.

To validate your data:

1. Select the cells that contain your data and click Validate Data. Do not include the column headings row in your selection.

   The ALM Microsoft Excel add-on validates your data against the requirements for each ALM field.

   Any invalid cells are marked in red, and an error message is displayed when you put your cursor on the cell.

2. Correct any invalid cells and click Validate Data again.

Note: If you subsequently add or modify your data, you can validate again, selecting only the modified or added cells or selecting all the cells. If you do not validate prior to uploading your data, the ALM Microsoft Excel Add-in validates your data before uploading.

Back to top

## Upload data

You upload data to ALM from your Google Sheets spreadsheet.

To upload your data:

1. Click Upload Data to ALM. The data is uploaded to ALM.

   Note: If you click Upload Data to ALM without first clicking Validate Data, the ALM Google Sheets add-on validates your data before uploading. Any invalid cells are marked in red, and an error message is displayed when you put your cursor on the cell. If there are no errors, the data is uploaded to ALM.

2. Refresh the view in ALM. Review the uploaded data and make the necessary additions and adjustments.

Back to top

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 16.00 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: