Defect #17550
closed
Spent time in exported CSV is wrong
Added by Albano Freire de Sousa Junior almost 10 years ago.
Updated over 7 years ago.
Description
When choose column spent time to show in issues list, spent time value is correct, which is the sum of spent time of all children and itself.
But in the exported CSV, the spent time value is only of itself, not children.
Files
I'm sorry Thanh, it looks like I removed the wrong issue.
- Category set to Time tracking
I disagree - in the list view only the time booked to the master ticket is shown. In the ticket details page the sum of master plus alls subtickets are shown. Similar to
#16092 the sum of all time entries should be saved in a separate field to be able see correct time sums in list view as expected and to support correct sums in (csv-)exports.
So I would vote for:
- time spent on this ticket (independant of parent or not)
- time spent on all sub (and sub-sub...) tickets only calculated if ticket has no parent_id
- Related to Defect #16092: Parent/subtask: calculation of estimated hours added
- Related to Defect #16159: Wrong calculation of spent time field on Issues report added
Jean-Philippe,
The commit r14273, which has been merged into the 3.1 branch, introduced an error as a "h" label is hard-coded in the function l_hours_short:
"%.2f h" % hours.to_f
This label should be translated through i18n. Asian users will surely report this anomaly.
Fabrice ROBIN wrote:
Jean-Philippe,
The commit r14273, which has been merged into the 3.1 branch, introduced an error as a "h" label is hard-coded in the function l_hours_short: [...]
This label should be translated through i18n. Asian users will surely report this anomaly.
FTR: #21069
Both columns (Spent time and Total spent time) are available now in the CSV export.
- Status changed from New to Needs feedback
- Status changed from Needs feedback to Closed
- Resolution set to Fixed
Fixed in Redmine 3.1 (#11253).
A parent issue displays its own spent time and total spent time.
- Related to Feature #11253: Total time spent from subtasks on the issue list added
Also available in: Atom
PDF
Updated by 
Updated by Toshi MARUYAMA 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 