7pace Timetracker's "Times Explorer" Page

ID	Description
1	With each worklog (row) that you select, this field updates - the first number displays the total number of worklogs you have checked/selected and the number in parenthesis displays the total time tracked in hours for those selected worklogs. For example, if you select three rows of worklog details and there is a total of 2.6 hours associated with those selected worklogs, this field will display as 3 (2.6h). If you have no rows selected, it displays as 0 (0 h), as depicted in the screenshot above.
2	The "Select All/Deselect All" checkbox.
3	The checkboxes by each row on the page allow you to cherry-pick the worklogs you want to view (with each worklogs you check or uncheck, the rows-selected and hours associated to those rows update in the "0 (0 h)" field at the beginning of the header row - see #1, above). You can also click anywhere on a row on the page and that row is automatically selected and the corresponding checkbox is checked. When a row is checked, #4, #5, #6, and #7, below, display as options.
4	"Assign Budget" This selection only displays when a row or rows are selected/checked. This opens a dialog box that allows you to assign a budget to the checked worklogs.  By default, each work item inherits the budget assigned to the corresponding iteration. However, you can assign different budgets to a specific work item.  The Budget column displays assigned budgets in the following ways: Budget Name: This indicates the name of the budget assigned. NA: This indicates that there is no budget set for the worklogs. (Processing ..): This indicates that the budget for the worklog has not yet been computed. It appears when adding worklogs of the recently added work item. Budget name displayed in blue, preceded by an exclamation mark (!): This indicates that the budget assigned to the work item is different than the budget assigned to the iteration of that work item. The work item is not inheriting the budget from the iteration. The Budgets filter list displays the following filter criteria: (No Budget Set): This criteria displays the work items that are not assigned to any budget. (Custom Budget per Time): This criteria displays the work items that do not inherit the budget assigned to the iteration. These are the work items to which you have assigned a different budget. (Inherited): This criterion displays all work items that inherit the budget assigned to the corresponding iteration. (!<budget_name>): This criterion displays all work items to which you assigned a budget different than the iteration budget. All such custom budget names are listed only if you have assigned them to a work item. For example, !DistributeMe budget is listed only if you have assigned the DistrubuteMe budget to a work item. For more information, see "Budgets" Page Overview and other articles related to "Budgets".
5	"Billable" This selection only displays when a row or rows are selected/checked. You can cherry-pick/select specific worklog details on the page, click on the "Billable" button, and then choose "Mark as Billable". These specific worklogs can then be billed to your customer. Alternatively, you can also click this "Billable" button again and choose "Mark as Unbillable".  Once selected and marked as “Billable”, the billable hours data is then available when you create reports via the “Times Explorer” export, “Budgets” export, and the Reporting API export process.
6	"Change Activity Type" This selection only displays when a row or rows are selected/checked and when your administrator has enabled the "Activity Types" feature in "Configuration". When both of these preconditions exist, the "Times Explorer" page displays a "Change Activity Type" button that allows you to select multiple worklogs and assign activity types to them in bulk. Additionally, "Activity Type" also displays as a selection when you click on the "Columns" button. Adding this column allows you to assign activity types to your v one-by-one, or filter and group by activity types like you do with other columns on this page. For more information, see our Activity Types article.
7	"Delete" This selection only displays when a row or rows are selected/checked. You can select multiple rows and delete worklogs in bulk with the "Delete" button.
8	You can click anywhere in the "Times Explorer" grid, on a row, and the row will automatically be checked/highlighted.
9	Editable blue links display where further action can be taken by the user. Click on a blue highlighted link and you will be prompted to take additional action if desired.

Making Changes to "Layouts"

When you make edits or changes to any of your "Layouts", (for example, moving a column to a different location, filtering certain rows to view specific time details, or cherry-picking certain columns to display on the page, etc.), those changes are immediately saved in the Timetracker database. If you open the "Times Explorer" page on a different PC or browser, you will still see the page in exactly the same state as you left it. If you make any changes to an existing layout, the "Save" button will display by the name of the layout:

You can then choose to "Save" by simply clicking the button or you can click the () icon to "Rename", "Delete", or "Undo Changes".

If you make changes to a layout and then navigate away from it without saving, you will receive the following prompt:

Work Item Form Integration

On the "7pace Timetracker" tab of the work item form, under "Work Item", an () icon displays next to "Hours" tracked on that work item. 

Clicking on it opens its details on the "Times Explorer" page:

Grouping

Grouping is powerful functionality that exists within the "Times Explorer" page that allows you to filter and group fields within existing worklogs data in a more concise but in-depth way. Each column header within the "Times Explorer" table contains different fields in its dropdown list (for example, the "Month" column header contains the calendar months in the dropdown during which time was tracked). By clicking on the grouping symbol () in the top-right corner of each column header, you can add the column - and subsequently, the fields - you want to group, in the details panel below. The column you group first is the top-level group, and every subsequent grouped column then displays one level below that. You can then get a filtered snapshot of the number of rows and the totals within each group that you create.

1. In the "Times Explorer" table, hover your mouse pointer over the top-right corner of the column header you want to be the top-level group.

2. Click the Add group icon -> The page filters and displays the time details of just that column, grouped accordingly (in this example, below, the "Person" column grouping displays the various Timetracker users and the worklogs associated with them. 

Note: You can group time details only for the fields that display the "Add group" () icon by the column header. You can group time details for multiple fields by clicking the respective column headers. Once you group the time details of a specific column, the field names in the column header display the () icon without you having to hover over it.

3. (Optional) Click the group header icon arrow to expand the group and view the worklogs in that group.

4. (Optional) Click the group header icon arrow that points down to collapse group and hide the worklogs in that group.

5. (Optional) Click the Remove Filters button or simply click the grouping () icon again to remove the grouping and display all worklog details in the table. 

Adding a New Worklog

1. On the "Times Explorer" page, click the Add Time button.

The system displays the "Add Time" dialog box.

Note: The interface of the Add Time dialog box is based on the mode that you set in "Settings" -> "General" ->"Rules". For more information, see Settings: General: Rules

If a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section, if you try to add time to a workitem that is in closed status, the system will prevent you from saving.

The top username field defaults to the logged-in user. As an administrator, this field will display to you as a droplist list that contains team members who have access to 7pace Timetracker. Users with lesser permissions, such as "Team" will only see their own name here.

2. Enter the appropriate values in other fields.

3. Click the Save button.

Editing a Worklog

1. In the worklog details table, click or hover over the pencil () icon for the worklog/row that you want to edit.

Note: The pencil () icon is enabled only for the worklogs that the logged in user has tracked/added/imported unless you have a user role that has been configured to edit/delete the worklogs of others. If the pencil () icon is disabled/grayed out next to a worklog, that means that the workitem to which it belongs is closed and a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section.

If you try to bulk-edit worklogs by selecting multiple checkboxes/worklogs at the same time and some of the workitems of those worklogs were closed, the system will inform you that only "x number of worklogs out of <insert total> were updated". 

The system displays the "Edit Time" dialog box.

2. Change the values you wish to change in the required fields.

3. Click the Save button.

Note: If a user is tracking time and edits (removes) the worklog currently being tracked by the Windows Client or the Timetracker Web Client, the system will automatically stop tracking.

Deleting a Worklog

Note: You can only delete the time details that you, yourself, have tracked on the system, however, an administrator can enable the option on the "Settings" page to allow another user role to edit or delete worklogs as well. For more information, see Settings: General: Rules

You can delete time two ways on the "Times Explorer" page. 

1. To delete multiple worklogs simultaneously, in the worklog details table, select the worklogs that you want to delete by clicking on the checkboxes by the specific rules. 

The "Delete" button is enabled on the toolbar.

2. You can either click the Delete button or you can also click the bin () icon for the worklogs that you want to delete.

Note: The bin () icon is enabled only for open worklogs that the logged in user has tracked unless you belong to the user group that has been configured to edit/delete time. If the bin () icon is disabled/grayed out next to a worklog, that means that the workitem to which it belongs is closed and a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section. If you try to bulk-delete worklogs by selecting multiple checkboxes/worklogs at the same time and some of the workitems of those worklogs were closed, the system will inform you that some of the worklogs can't be deleted and once you continue, you'll receive a message that only "x number of worklogs out of <insert total> were deleted". 

If a user is tracking time and edits (removes) the worklog currently being tracked by the Windows Client or the Timetracker Web Client, the system will automatically stop tracking.

Changing displayed time worklogs temporarily 

By clicking on the "Change Dates" link on the Times Explorer page, team members can temporarily change the date range of displayed worklog details. If that team member visits another page within Timetracker, however, and returns to the "Times Explorer" page, that temporary setting will return to the configured setting. This configured date range can be changed more permanently by an administrator within Timetracker's settings. We will show you how to do both, below.

1. On the 7pace Timetracker menu bar, click Times Explorer.

2. Click the Change Dates link.



Side-by-side calendars display:

3. On the left-side calendar, select the From date.

4. On the right-side calendar, select the To date.

5. Click the OK button.

The date range of displayed worklogs is updated temporarily on the "Times Explorer" page. 

Changing displayed time worklogs permanently

Note: You have to have an administrator user role to do this.

1. On the 7pace Timetracker menu bar, click Settings -> Rules. 

2. Under Times Explorer Preloaded Timeframe, type in the preferred number of months you want to be preloaded on the "Times Explorer" page prior to the current month.  

The page refreshes automatically and the changes are saved. "Times Explorer" will now always show this date range on the page when you and your team members navigate to that page. 

Single-Assigning a Budget

On the Times Explorer page, on the row/worklog to which you want to assign a budget, under the Budget column, click by "NA" or the name of the already-assigned budget if you want to change it.

When the list of budget names populate/display, click on the budget you want to assign to the worklog.

The selected budget is verified and assigned to the specific worklog.

Bulk-Assigning Budgets

To assign a budget to multiple worklogs, select multiple rows or worklogs. When you do this, additional menu items display on the toolbar next to the "Add Time" button, including the "Assign Budget" button:

When you click the Assign Budget button, the "Assign Budget" dialog box displays a list of configured budgets.

In the Title column, click the budget name that you want to assign and click "Assign to selected". The bulk budget assignment confirmation dialog box will display, asking you if you'd like to continue. If a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section, you’ll receive a message from the system that not all worklogs can't be updated. 

When you click the Assign button, the Budget column now displays the chosen budget for the selected worklogs (that are not in a closed state).

Removing a Budget

To remove a budget from a worklog, select the worklog/row or highlight it with your mouse. In the Budget column, but still within the same row, click the budget name so that the list of budgets display.

In the budgets list, click the [Inherited budget] budget. The previously-assigned budget for the selected time worklog is removed. 

Note: If the budget of the parent work item or the iteration is removed, the worklog, which inherits that budget, will display NA  in the Budget column.

If a budget name is preceded by an exclamation mark (!), this indicates that the budget assigned to the work item is different than the budget assigned to the iteration of that work item. It displays if the work item is not inheriting the budget from the iteration.

Importing worklogs

To import worklogs that you've tracked outside of 7pace Timetracker, you simply copy data from the source application (like Excel) and paste it into the "Import Times" popup window of the Times Explorer page. You then associate each worklog detail to the specific field in the Timetracker database. Once verified, the imported worklogs are stored in our database.
Import can be performed via the UI, but it can also be performed by using the workLogs endpoint from our REST CRUD API and also our NPM package.

If the system finds any errors, the import process will stop and the errors will display for you to correct before attempting to import again. 

1. On the 7pace Timetracker menu bar, click Times Explorer.

2. On the Times Explorer page, click Import.

The Import Times page displays:

3. Paste time details that you copied from the source application (like Excel). 

4. Click the Next button.

Timetracker analyzes the data that you pasted and displays it in a tabular format so you can properly associate each time detail in the column headers to the appropriate Timetracker field.

5. (Optional) In the far-left column, check the boxes for the time details you want to import. By default, all are selected.

6. Select the "Date Format" and the "Time Format" of your preference for the import.*

*Note: If you'd like to customize or change the format for your import, please find additional information at this link - Custom Date and Format Strings - and/or simply use the most popular formats (we used standard .NET Framework DateTime object format settings):

Basic Format Specifiers:

mm: minutes

MM: month

dd: day of month

h: hour in format 1-12 without leading zero

hh: hour in format 1-12 with leading zero

H: hour in 24h format without leading zero

HH: hour in 24h format with leading zero

mm: minutes with leading zero

tt: am/pm designator

yyyy: year

Templates for Date/Time Formats

Date Format	Time Format
MM/dd/yyyy	h:mm tt
dd.MM.yyyy	HH:mm
yyyy-MM-dd	HH:mm

7. Copy-paste the Date Format and Time Format of your choice into the corresponding fields.

8. In the Column Name headers, click the dropdown arrows on each and select the appropriate header names for the time details below.

9. Click the Import Now button.

While importing, if there are any issues with the data, those issues will be highlighted and an error message will display.

10. (Optional) Check "Rows With Errors Only" to see just the rows that are causing issues in your import.

11. (Optional) After correcting your errors, if any, click the Import Now button again.

Once the time details are successfully imported, you can view these details on the "Times Explorer" page.  

Exporting worklogs 

You can export worklogs to an Excel file that will have the following naming convention format: timetracker_<export_date>-<export_time>.xlsx.

Before exporting, filter the worklogs on the page to suit your needs and then export only those worklogs displaying on the page after matching the filter criteria. 

1. On the 7pace Timetracker menu bar, click Times Explorer.

2. (Optional) Filter the worklogs as per your requirements.

3. On the toolbar, click the Export to Excel button.

The browser downloads the Excel file containing the worklogs shown on the "Times Explorer" page.