Defect #17550

Spent time in exported CSV is wrong

Added by Albano Freire de Sousa Junior over 3 years ago. Updated 11 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Time tracking
Target version:-
Resolution:Fixed Affected version:

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.

spent_time.png (64.3 KB) Marius BALTEANU, 2016-12-18 17:19


Related issues

Related to Redmine - Defect #16092: Parent/subtask: calculation of estimated hours Closed
Related to Redmine - Defect #16159: Wrong calculation of spent time field on Issues report Closed
Related to Redmine - Feature #11253: Total time spent from subtasks on the issue list Closed

Associated revisions

Revision 14273
Added by Jean-Philippe Lang over 2 years ago

Display time spent on the issue and the total time spent like estimated hours (#17550).

History

#2 Updated by Etienne Massip over 3 years ago

I'm sorry Thanh, it looks like I removed the wrong issue.

#3 Updated by Toshi MARUYAMA over 3 years ago

  • Category set to Time tracking

#4 Updated by Heiko Robert about 3 years ago

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

#5 Updated by Toshi MARUYAMA about 3 years ago

  • Related to Defect #16092: Parent/subtask: calculation of estimated hours added

#6 Updated by Toshi MARUYAMA about 3 years ago

  • Related to Defect #16159: Wrong calculation of spent time field on Issues report added

#7 Updated by Fabrice ROBIN about 2 years ago

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.

#8 Updated by Toshi MARUYAMA about 2 years ago

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

#9 Updated by Marius BALTEANU 12 months ago

Both columns (Spent time and Total spent time) are available now in the CSV export.

#10 Updated by Mischa The Evil 12 months ago

  • Status changed from New to Needs feedback

#11 Updated by Go MAEDA 11 months ago

  • 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.

#12 Updated by Go MAEDA 11 months ago

  • Related to Feature #11253: Total time spent from subtasks on the issue list added

Also available in: Atom PDF