Export actual times
Overview
Actual time data entered in TimeTracker NX can be output to an external file in Excel or CSV format.
- Time data can be aggregated as desired in Excel or used for linking with external applications.
- By using Excel's pivot analysis function, exported actual data can also be analyzed by specifying a period for each item.
Exporting actual times
You can output actual times in CSV or Excel format.
Operation procedure
-
Click the icon to the right of the login name displayed in the global navigation.
-
Select "Export Actual Time".
-
Select the file format.
-
Select the unit to be aggregated.
-
Specify the period for which data is to be output.
-
Select the output columns.
-
Select a filter. Use the filter to narrow down the users to be aggregated.
For projects or organizations, you can specify users by that unit.
-
Select the target users, projects, etc.
-
Click the "Done" button.
-
Click the "Download" button in the "Export" dialog.
Output items for exporting results
| Aggregation unit | ||||
|---|---|---|---|---|
| Results | Day/Week/Month | |||
| Output items | Work items | Projects | Work items | Projects |
| User name | ○ | ○ | ○ | ○ |
| User code | ○ | ○ | ○ | ○ |
| Current organization | ○ | ○ | ○ | ○ |
| Current organization code | ○ | ○ | ○ | ○ |
| Organization on the relevant day | ○ | ○ | ○ | ○ |
| Organization code on the relevant day | ○ | ○ | ○ | ○ |
| Project name | ○ | ○ | ○ | ○ |
| Project code | ○ | ○ | ○ | ○ |
| Project category 1 to 50 *1 | ○ | ○ | ○ | ○ |
| Date | ○ | ○ | ○ | ○ |
| Start time | ○ | ○ | - | - |
| End time | ○ | ○ | - | - |
| Actual time | ○ | ○ | ○ | ○ |
| Actual man-hours (min) | ○ | ○ | ○ | ○ |
| Actual cost *2 | ○ | ○ | ○ | |
| Memo | ○ | ○ | - | - |
| Process category group | ○ | ○ | ○ | - |
| CProcess category | ○ | ○ | ○ | - |
| Time entry category group | ○ | ○ | ○ | - |
| Time entry category | ○ | ○ | ○ | - |
| Item name | ○ | - | ○ | - |
| Item type | ○ | - | ○ | - |
| Item code | ○ | - | ○ | - |
| Item number | ○ | - | ○ | - |
| Folder name *3 | ○ | - | ○ | - |
| Folder code *3 | ○ | - | ○ | - |
| Hierarchy information *4 | ○ | - | ○ | - |
*1 Only project categories with "Allow grouping" checked in the project category settings will be output.
*2 If the logged-in user does not have the "View costs" permission, 0 will be output.
*3 The folder with the closest hierarchy to the target work item will be targeted.
*4 For details on hierarchy information, please refer to the following.
Output column: Hierarchy information
If you select "Output hierarchy information" in the output column selection dialog, you can also output the parent item name.
You can display the output results in your preferred view by inputting them into Excel's pivot analysis function, etc.
If you want to output, check the checkbox and select the hierarchy to output.
For details, please refer to the following link: "Excel pivot analysis" (https://timetracker.commmune.com/view/knowledgebase/post/481)"
Notes
If there are no items in the specified hierarchy, this will be left blank.
For example, if you specify up to 15 levels and the 5th level is a terminal item, the following will be output.
- 1st to 4th levels: Parent item name
- 5th to 15th levels: Blank