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.