Importing Effort from VersionOne to PPM Time Sheets

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

This section details on how to import effort from VersionOne to PPM.

Enabling External Data Option in Time Sheets

For details, see Enable external data option in time sheets.

Adding a VersionOne Instance

For details, see Add a VersionOne agile instance.

Importing Effort from VersionOne

  1. From the menu bar, select Create > Time Sheet. The Create Time Sheet page opens.

  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 VersionOne instance that your administrator configured, and click Next.

  6. In step 2: User Configuration, provide the following information.

    Field (*Required)

    Description
    *Username Username you use to log on to VersionOne
    *Password Password you use to log on to VersionOne
    *Project Select a VersionOne project whose effort is to be imported to the time sheet

  7. Click Next.

    User stories in VersionOne whose time periods partly or fully overlap with the time sheet are retrieved, along with the daily effort logged on these user stories.

    Each of these user stories is imported into the time sheet as a time sheet line.

    Review the list of available external items. Click the icon to remove the items you do not want to import.

  8. Click Submit.

    The imported items are displayed under the External Data section.

  9. Review and edit the time sheet lines if necessary.
  10. 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 VersionOne, 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 Typeto External Data, and Work Item Setto VersionOne, 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 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.