Share this page

# Upload data

After you format requirements, tests, and defects in your sheet, you can upload them to OpenText Application Quality Management.

In this topic:

## Considerations for uploading data

- To upload data to OpenText Application Quality Management, you must first map OpenText Application Quality Management fields to the Excel sheet columns. You can manually map fields to sheet columns, or the Microsoft Excel Add-in can map fields automatically. For automatic mapping to succeed, the column headings in your sheet must be identical to the field names.

- When you upload a new or existing requirement, test, or defect to OpenText Application Quality Management, it is created with the user name that you use to upload it.

  Example: If you upload a defect with alex_alm as the user name, the defect’s history shows alex_alm as the person who changed the defect.

- You cannot upload the following OpenText Application Quality Management fields from Excel:

  Module Name | Field Name
  --- | ---
  Requirements | Date, Time, Modified, ReqID, Direct Cover Status
  Test Plan | Modified, Test Step Actual, Test Step Exec Date, Test Step Exec Time, Test Step Source ID, Status
  Defects | Defect ID, Modified

- You must have full create and modify permissions in OpenText Application Quality Management for the type of record that you are uploading.

  Example: If you are uploading tests, you must have permissions for adding and modifying the test plan tree, design steps, and folders.

- You cannot upload automation tests from Excel.

Back to top

## Version control considerations

You can upload requirements or tests from Microsoft Excel to a version control enabled project.

Consider the following when uploading to a version control enabled project:

- When you upload a new requirement or test, it is created in OpenText Application Quality Management, with a checked in status.

- When you upload an existing requirement or test that is checked in, it is automatically checked out and then checked in during the upload. A comment is added to the version history specifying that the requirement or test was updated by uploading from Excel.

- If you upload an existing requirement or test that is checked out by the same user that you use to upload the data, the data is uploaded. If the requirement or test is checked out by another user, the upload fails and an error message is displayed.

For more information on version control, see Version control.

Back to top

## Step 1: Log in

To log in to OpenText Application Quality Management from Excel:

1. Open Microsoft Excel. Go to the ALM Excel Add-in tab, and click Login. dialog box opens.

2. In the login window, enter your credentials and click Authenticate.

   Standard login | Enter the following: Your OpenText Application Quality Management server. The virtual directory name in the format of http://<server name>[:<port number>]/qcbin. Your username. Your password.
   Single sign-on | Enter the following: Your OpenText Application Quality Management server. The virtual directory name in the format of http://<server name>[:<port number>]/qcbin. After clicking Authenticate, you are redirected to your corporate credentials (at a URL belonging to your corporate domain). If your company set up Single-Sign-On with ALM and you already logged in to another application with your corporate credentials, you may be redirected to the ALM application without logging in again.

3. Enter your domain and project.

4. To set your proxy settings, click Show Proxy Settings.

   By default, the connection is done using the system proxy settings. To use a different proxy server, click Use a Proxy Server and enter the proxy details and credentials.

5. Click Login.

To enable access to a server configured with a web server that requires client certificate authentication:

1. Locate the file ExcelAddIn.dll.config in the Excel add-in installation folder:

   - If the Excel add-in is installed for Only for me, this file is located in %localappdata%\Programs\Micro Focus\Addins.
   - If the Excel add-in is installed for Anyone who uses this computer (all users), this file is located in C:\Program Files\Micro Focus\Addins.

1. Open the file, change the value of the following key to "Y" (default value is "N"), and save the file:

   <add key="CLIENT_CERTIFICATE_REQUIRED" value="Y"/>

2. Restart Microsoft Excel.

Back to top

## Step 2: Map data

Map ALM entity fields to Microsoft Excel columns.

Before mapping data

We recommend you add headers in the first row of your sheet or leave the first row empty.

Create new mappings

1. In the ALM Excel Add-in tab, click Mapping.

2. From the Entity type list, select an entity type (Requirements, Defects, or Tests) for the sheet data.

   - The ALM Field area displays all fields of the selected entity type. The ALM Field - Excel Column mapping area lists the required ALM fields to be mapped.

   - If you select Requirements in Entity type, you can choose to assign a single requirement type to all sheet data.

     Click the Assign single requirement type to all option, and select a requirement type.

3. In the ALM Field - Excel Column mapping area, do the following:

   - Specify a Excel column for each required ALM field.

   - To map non-required ALM fields, first move these fields to the ALM Field - Excel Column mapping area, and then specify columns for these fields.

4. If you want to add a header row for your sheet, or you want to update the existing headers with the established mapping, do the following:

   1. Click Auto-map.

   2. In the Specify the row number in Google Sheets where the field labels appear option, enter the row number where headers are added.

      By default, headers are added in the first row. If the first row has entity data, the data is replaced with headers.

   3. Select the Add or update ALM field label as header to Excel option.

5. To save the field mapping in a file for future use, click Save. In the File Name field, specify the name for the file.

   You can use this file to establish mapping next time. See Create mapping using a mapping file.

6. To apply the mapping to the sheet, click OK.

Create mapping using a mapping file

1. In the ALM Excel Add-in tab, click Mapping.

2. In the Field Mapping window, click Open and select the mapping file.

3. To apply the mapping to the sheet, click OK.

Back to top

## Step 3: Validate data

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

To validate your data:

1. Select the cells that contain your data and click Validate. Do not select the header row.

   The Microsoft Excel add-in validates your data against the requirements for each 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 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 add-in validates your data before uploading.

Back to top

## Step 4: Upload data

Upload your Excel sheet data to OpenText Application Quality Management.

To upload your data:

1. In your Excel sheet, open the ALM Excel Add-in tab. Select the rows of data you want to upload.

2. Click Upload to ALM.

   Note: If you click Upload to ALM without first clicking Validate, the add-in 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.

3. Refresh the view in OpenText Application Quality Management. Review the uploaded data and make necessary additions and adjustments.

Back to top

https://admhelp.microfocus.com Application Quality Management 8942
Tips to improve your search results... OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help 26.1 All View Local Help Center View Online Help Center Version: