TeamTime Extensibility - Timesheets
A read-only copy of TeamTime's timesheet list can be unhidden to allow the raw data to be directly read from the site. This setting can be found under the Extensibility section of the Settings page.
Once unhidden, the Timesheets list can be found by clicking All Site Content link on the quick launch menu on the left of the page (at the top in 2007, and the bottom in 2010, 2013 and 2016).
The data in this list isn't in itself read-only, but any modifications will be reset when it is synchronised via the Settings page.
List Data
Below is a reference of the list's fields. The list contains an item for each timesheet entry, rather than an entire timesheet. An entry contains data for a Person/Week/Project/Task combination.
| Name | Type | Description |
| Person | User | The owner of a timesheet entry |
| Project | Lookup (Projects list) | The Project an entry relates to |
| Task | Lookup (Tasks list) | The Task an entry relates to |
| Project Task | Text | The Project and Task an entry relates to (concatentated for ease of reporting) |
| Week Commencing | DateTime (Date only) | The date of the first day of the week the timesheet entry is for |
| Monday | Number | The number of hours worked on Monday |
| Tuesday | Number | The number of hours worked on Tuesday |
| Wednesday | Number | The number of hours worked on Wednesday |
| Thursday | Number | The number of hours worked on Thursday |
| Friday | Number | The number of hours worked on Friday |
| Saturday | Number | The number of hours worked on on Saturday |
| Sunday | Number | The number of hours worked on Sunday |
| Notes | Text | Any notes about the entry, added by the user |
Suggested uses
This list can be used to extract data directly from TeamTime, for use in custom reporting or integrating third party solutions.
For example, data could be extracted for a client projects and used to produce invoices; with a full run down of the time spent on the tasks that make up that invoice.
