Getting hours in a csv task report

55 views
Skip to first unread message

Emiliano Heyns

unread,
Apr 9, 2013, 11:39:04 AM4/9/13
to taskjugg...@googlegroups.com
Can I force TJ3 to report effort in hours and not roll them up in days/weeks etc?

John Hendy

unread,
Apr 9, 2013, 6:37:02 PM4/9/13
to taskjugg...@googlegroups.com
Can you give an example? Maybe just a few tasks with effort attributes
and what you want vs. what you get?


Thanks!
John
> --
> You received this message because you are subscribed to the "TaskJuggler
> Users" group.
> To post to this group, send email to taskjugg...@googlegroups.com
> To unsubscribe from this group, send email to
> taskjuggler-us...@googlegroups.com
> For more information about TaskJuggler visit http://www.taskjuggler.org
> ---
> You received this message because you are subscribed to the Google Groups
> "TaskJuggler Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to taskjuggler-us...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

Emiliano Heyns

unread,
Apr 10, 2013, 4:41:37 AM4/10/13
to taskjugg...@googlegroups.com
I've reworked one of the taskjuggler samples to show the issue. When ran, "All open TODOs.csv" shows effort for "build boat" as 0.3; I would like to have a number in hours instead.
effort.tjp

John Hendy

unread,
Apr 19, 2013, 4:52:04 PM4/19/13
to taskjugg...@googlegroups.com
On Wed, Apr 10, 2013 at 3:41 AM, Emiliano Heyns
<emilian...@iris-advies.com> wrote:
> I've reworked one of the taskjuggler samples to show the issue. When ran,
> "All open TODOs.csv" shows effort for "build boat" as 0.3; I would like to
> have a number in hours instead.
>

Sorry, took me a while to get to this. See the textreport attribute `loadunit`
- All textreport attributes:
http://www.taskjuggler.org/tj3/manual/textreport.html
- loadunit: http://www.taskjuggler.org/tj3/manual/loadunit.html

I changed your report to this:

taskreport "All open TODOs" {
formats csv
loadunit hours
hidetask plan.complete >= 100
journalattributes date, headline, summary, details
}

The resultant csv is this:

"Name";"Effort"
"Long term projects";523.0
" Build boat";2.0
"Errands";357.0
" Pickup Jacket from dry cleaner";8.0
" Buy present for wife";1.0

Hopefully that's what you were looking for.


John
Reply all
Reply to author
Forward
0 new messages