1.877.226.2662

Use the TTM Export Timesheets options

Use the TTM Export Timesheets options

TTM Configuration Overview TTM Control Panel

In Time Tracking and Management (TTM) timesheet information is maintained in the Timesheets list. Since modifications should not be made to this critical list, TTM provides a tool to allow you to export data from the Timesheets list to another list in the site collection.

When generating timesheet exports keep in mind:

  • The export tool was enhanced in TTM 2.5.

    • The enhanced tool replaces the functionality previously provided with the TTM Console Application.

    • For information on the columns included in the export, click here

    • There are two export options available:

      • Export Now – creates an immediate one-time export of identified timesheet data
      • Schedule Export – uses a timer job to export data on a specified schedule

To export timesheet data:

Link from the TTM Control Panel Click the Export Timesheets link in the TTM Control Panel to access the export tool.

NOTE: To see the link you will need to have Full Control permissions on the TTM site.

# Function
Export Parameters
Export Parameters
1.

TTM Source Site URL
Enter the URL of the TTM site within the same site collection that contains the timesheet data you want to export.

  • Keep the default ./ to export timesheet data from the current site.
2.

Destination list

Enter the name of the list that will be created and populated with timesheet data.

Icon-Warning Important: If you create an export schedule the same list will be continually overwritten with the timesheet data that meets the defined parameters of the export.
3.

Destination Site URL
Enter the URL of the destination site within the same site collection.

  • Keep the default ./ to export timesheet data to a list in the current site.
Export Parameters cont.
Export Parameters
4. Admin tasks in Timesheet Entry displayAdministrative Tasks
Check to include time entered against Administrative tasks in the export.
5. Exported Content

When checked, the export will only include task items that contain a time entry
.
6. Export Approved Timesheets
Check to only include timesheet with an Approved Status in the export.
Timesheet Scope
Scope Parameters
7.

Select one of the options below to identify which timesheets will have data included in the export

  • Resource Scope
    • Export timesheets for all resources
    • Export timesheets for a specific resource
  • Project Scope
    • Export timesheets for a specific project
  • Date Scope
    • Export timesheets for an identified date range
    • Export timesheet for an entire year

Schedule Export
Use these settings only if you want to save an export schedule. Schedule Parameters

NOTE: If you want to create a one-time export, click the Export Now button below.
8
  • A. Define a schedule
    • Use the radio buttons to determine how frequently the defined export will be executed.
    • The export process will be managed by the Bamboo TTM Timer Job Manager (timer job)
  • B. Save Schedule
    • You must select the Save Schedule button if you want to use the schedule defined above
    • You can save one scheduled export.
    • One-time exports that are generated when you click the Export Now button do not impact the settings of a previously saved export.
9 Export Now
Use this button to create an immediate, one-time export of the identified timesheet data.

TTM Configuration Overview TTM Control Panel