You can export worklog details from the "Budgets" page. By default, 7pace Timetracker exports these time details in the form of an Excel file.
1. On the 7pace Timetracker menu bar, click "Budgets".
2. In the left pane, click .
The "Export Time Report" dialog box displays.
3. Click in the "From" field and select the start date from when you want to export the worklogs.
4. Click the "To" field and select the end date up to which you want to export the worklogs.
5. (Optional) Select one of the following options to export your worklog details:
- Add sum of effort/storypoints to topmost parent items
- Group identical data for same work item ID by dates
- Include Billable and Billable Hours columns in Export
In the "Projects" list, check the projects for which you want to export the worklogs.
Note: In the projects list, you can only view the projects to which you have access/permissions.
7. Click the "Get Report" button.
The system downloads the report as an Excel file with extension
Add Sum of Effort/Story Points to Top-Most Parent Items
When you select this option, 7pace Timetracker first adds the effort/story points of all child work items to the effort/story points of the respective parent work item and then exports the work items. With this calculation, the exported Excel file displays the effort/story point details as the total of the effort/story points of the parent work item and all corresponding child work items.
Timetracker also adds a new column - Top Work Item Story Point - in the exported Excel file. The Top Work Item Story Point column displays the total number of effort/story points of all child work items and their parent work item.
If you don't choose this option, Timetracker separately exports the worklog details of the parent and and child work items.
Warning: Selecting this option might take additional time to populate results, as 7pace Timetracker needs to calculate the efforts/story points of all child work items and their parent items.
Exported Excel File Without Selecting This Option
The exported excel file only contains the Parent Work Item Story Point column and not the Top Work Item Story Point column. The Parent Work Item Story Point column displays the efforts/story points of all work items.
Exported File With This Option
The exported Excel file contains the additional Top Work Item Story Point column. This column displays the total of the efforts/story points of the parent work item and all corresponding child work items.
Group Totals of All Worklogs with Same Work Item ID Together Per Calendar Day
If, on a particular date, you work on the same work item at different times during the day, 7pace Timetracker separately records each time you work on that work item and for how long.
When you select this option, 7pace Timetracker exports your worklogs by grouping the time of the work item that you tracked on a particular date, but at different times on that date, together. The exported file displays the work item only once, with the date and time details grouped into the "Record Date" column. In the Excel file, the "Tracked" column displays the total time tracked for the same work item at different times.
When you export your worklogs without selecting this option, the Excel file separately displays the date and time details of the same work item, tracked at different times during that date, in separate rows.
Exported File Without Selecting This Option
The exported Excel file contains separate entries for the same work item. The "Start" and "End" columns and the "Tracked" column display the worklog details separately for the same work item.
Exported File with This Option
When you select this option, the exported Excel file contains the "Record Date" column instead of the "Start" and "End" columns.