Time Sheet Import Template

Cora allows site administrators to import timesheets on spreadsheets to add actuals to existing planned resources on tasks. The template attached is to be used so that the format is correct.

Note: The time sheet import should only be used under the guidance of Cora Systems.

When planning to import timesheets:

• Project Names need to be unique.
• Task Names need to be unique on the project.
• Actual Hours are imported along with the task along with percentage complete (optional)
• However, in the timesheet itself: 
  • Hours can only come in for planned tasks
  • Timesheets are not automatically submitted
  • Comments do not come through the import
• The Date Import on the Import File must be the exact same as the template.
• If approvals are switched on, then all timesheets created via the import will need to be approved before the actual values will appear in the timesheet report.
• A timesheet Placeholder task needs to be created against each project to allow for the data to be populated.