Timesheet data is missing after changing the Timesheet Tasks Data Source

SYMPTOMS:

Timesheet data is missing from saved and submitted timesheets after the data source for timesheet tasks is changed from a Bamboo List Rollup to a SharePoint Tasks list, or vice versa. All timesheets created using the original data source are affected, and no longer display time that was entered for any administrative or project task. The status of timesheets that were already saved, submitted, approved or rejected now says "Not Created". Reports in the Report Center do not display any data for the affected time periods.

For example:

• Time has been entered for two different time periods:

  

  

• After these timesheets have been saved, the Timesheet Tasks Data Source list is changed. For example:
  • Original configuration:

    

    

  • New configuration:

    

    

• The timesheets for the reporting periods no longer include the hours that were saved in them:

  

  

CAUSE:

If the Timesheet Tasks Data Source setting in the Time Entry Web Part is changed from its previous value (Bamboo List Rollup or SharePoint List), all timesheets created using the original task list are no longer visible in My Timesheets, Timesheet Approval, and Report Center views and reports. Users must re-enter time in affected timesheets.

RESOLUTION:

If you need to recreate data for affected timesheets, take the following steps:

• In the new task list, create the same tasks that were in the original task list.
• In the Timesheet Entry page, re-enter time for the tasks in each affected reporting period.
• Submit the timesheets for approval again and have the timesheet manager approve or reject them as normal.

Note: This process must be repeated for all timesheets that were saved or submitted using the original task list data source.