Share this page

# Import effort from OpenText Software Delivery Management to PPM time sheets

OpenText Software Delivery Management connector enables team members to import effort that is submitted in OpenText Software Delivery Management to PPM time sheets, freeing them from reporting their time repeatedly and thus ensuring consistency between OpenText Software Delivery Management and PPM.

This section details on how to import effort from OpenText Software Delivery Management.

In this topic:

## Enable external data option in time sheets

Effort imported from OpenText Software Delivery Management is grouped under External Data in time sheets.

To enable this option as an administrator:

1. Make sure the `ENABLE_TM_WORK_ITEM_EXTERNAL_DATA` parameter is set to `true`.

   What happens after enabling this parameter?

   The External Data option is available in the following PPM Workbench windows:

   - On the Work Items and Activities tabs of the Time Sheet Policy window.

     Selecting the External Data option on the Work Items tab ensures that,

     - The Add External Data option is available in the Add Items action list of the Time Sheet page.
     - The External Data option is available on the Create Work Allocations page as a work item type.
   - In the Work Item Type drop-down list (under the Dependencies section) of the Override Rule window.

2. In the workbench, enable the External Data option on the Work Items tab of the desired time sheet policy.

   1. Click the Administration button in the masthead.

   2. From the Administration menu, select Workbench > Open Workbench on Desktop (or Open Workbench App).

   3. From the shortcut bar, select Time Mgmt > Time Sheet Policies.

   4. Click List.

   5. From the Results tab, select and open the desired time sheet policy.

   6. Click the Work Items tab.

   7. Select the checkbox for the External Data option.

      Note: The edit to this option applies to new time sheets only. Existing time sheets still load the old time sheet policy, therefore.

   8. Click OK.

## Add an OpenText Software Delivery Management instance

For details, see Add an OpenText Software Delivery Management agile instance.

## Import effort from OpenText Software Delivery Management

To import effort from OpenText Software Delivery Management to PPM time sheets:

1. From the main menu, select Time Management > Time Sheets > Create Time Sheet to open the Create Time Sheet page.

2. Complete the fields or option.

   For detailed descriptions about these fields, see the Time Management User�s Guide.

3. Click Create. The time sheet is created and the Edit Time Sheet page appears.

4. Click Add Items > Add External Data.

   You can only add external data for time sheets where time is entered by Day in Hours policy.

5. From the Select Instance drop-down list, select the OpenText Software Delivery Management instance that your administrator configured, and click Next.

6. In step 2: User Configuration, click the Authenticate access to ALM Octane link to log in OpenText Software Delivery Management.

   If you are in an SSO-enabled environment, this link redirects you to an SSO login page, otherwise, it redirects you to an OpenText Software Delivery Management login page.

7. In the Group timesheet lines by field, select a value.

   - Workspaces: one time sheet line stores effort totals from one workspace.
   - Releases: one time sheet line stores effort totals from one release.
   - Backlog items:.one time sheet line stores effort totals from one backlog item.
8. Click Next.
9. Review the list of available external items. Click the icon to remove the items you do not want to import.

10. Click Submit.

    The imported items are displayed under the External Data section.

11. Review and edit the time sheet lines if necessary.
12. Click Save or Save&Submit.

## Limitations and troubleshooting

### Limitations

- When you run the following Time Management reports, if you set the Work Item Type filter to External Data, and the Work Item Set filter to ALM Octane, no values are available for Work Item:

  - Actual Time Summary
  - Time Sheet Summary
  - Work Allocation Details

- When you set filters for the following Time Management portlets, if you set Work Item Type to External Data, and Work Item Set to ALM Octane, no values are available for Work Item:

  - Time Sheet Totals by Work Item

  - Time Sheet Totals by Resource Group

  - Work Allocation Details

  - Work Item Set Actuals vs. Allocations

- External Data is available for the following Time Management portlets only:

  - Time Sheet Totals for Direct Reports

  - Approve Time Sheets

  - Work Item Set Actuals vs. Allocations

  - Time Sheet Totals by Resource Group
  - Time Sheet Totals by Resource

  - My Time Sheets

- External Data is not available for the following portlets:

  - Time Sheet Totals by Work Item

  - Work Allocation Details

  - My Tasks

  - My Work Items

### Troubleshooting

- Problem: Importing the agile effort data for multiple times during the time period range does not automatically update the effort data in your OpenText PPM time sheet that you imported previously. Instead, it adds new time lines into your time sheets. You need to manually remove the old time lines of data.

  Solution: Import your agile effort only once for each time period, approaching the end of the current period, so that the latest and more accurate effort data can be retrieved and imported.

- Problem: When importing effort from OpenText Software Delivery Management to PPM time sheets, in the User Authentication step, after you click the Authenticate access to ALM Octane link and provide correct credentials on the login page, an "Authentication Failed" error may occur.

  Solution: This is because your Octane site and space require API key authorization for direct REST API access by enabling the RESTRICT_REST_API_TO_API_KEYS_ONLY parameter. Disabling this parameter will solve this problem.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: