[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Re: lisp/org-clock.el: Add param :properties to list properties in c
From: |
Bernt Hansen |
Subject: |
[O] Re: lisp/org-clock.el: Add param :properties to list properties in clocktable |
Date: |
Sun, 27 Mar 2011 08:13:49 -0400 |
User-agent: |
Gnus/5.110015 (No Gnus v0.15) Emacs/23.2 (gnu/linux) |
Niels Giesen <address@hidden> writes:
> Bernt Hansen <address@hidden> writes:
>
> [...]
>
>> Could you provide a sample clock report using this patch to get a
>> better idea of why you find this useful?
>
> Yes, here you are, along with the contents of a sample file, so that you
> may get a gist of my need for inheritance.
>
> * Clocktables
> #+BEGIN: clocktable :maxlevel 2 :scope file :properties ("Costcenter"
> "Billable") :inherit-props t
> Clock summary at [2011-03-27 Sun 12:04]
>
> | Costcenter | Billable | Headline
> | Time | |
>
> |-----------------------------------+----------+---------------------------------+--------+------|
> | | | *Total time*
> | *3:08* | |
>
> |-----------------------------------+----------+---------------------------------+--------+------|
> | A-102: General Administration | | TODO Travel cost
> declaration | 0:42 | |
> | A-102: General Administration | | TODO December 2007-2009
> | | 0:37 |
> | O-100: General overhead | | Making coffee for the lot
> of us | 0:06 | |
> | C-100: Customer relations general | | Helpdesk
> | 1:10 | |
> | C-100: Customer relations general | | Categorize our helpdesk
> e-mails | | 0:20 |
> | C-101: Customer A | [X] | Help out customer a
> | | 0:10 |
> | C-102: Customer B | [?] | Help out customer b on
> issue x | | 0:20 |
> | C-100: Customer relations general | | Help out potential
> customer c | | 0:20 |
> | W-100: Web Development | | Develop our main web app
> | 1:10 | |
> | W-100: Web Development | | that
> | | 0:41 |
> | C-102: Customer B | [?] | something only customer b
> wants | | 0:29 |
> #+END:
>
> Actually, my boss needs something more like the table below, which I
> can export to something that Outlook Times also spits out (some
> clocking plugin for MS Outlook that the rest of us uses, and I was
> supposed to use too, you may understand that that is just a silly idea
> for someone used to org-mode).
>
> Patches 1 and 3 allowed me to get this specific output using a custom
> formatter and a #+TBLFM: line, which I may post to Worg if people are
> interested.
>
> #+BEGIN: clocktable :formatter org-clocktable-write-outlook-times-style
> :maxlevel 2 :scope file :inherit-props t :properties ("Costcenter"
> "Billable") :date t :block day
> Clock summary at [2011-03-27 Sun 12:04], for Sunday, March 27, 2011.
>
> | Date | Headline |
> Time | Costcenter | Billable |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | | *Total time* |
> *3.05* | | |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | TODO Travel cost declaration |
> 0.00 | A-102: General Administration | |
> | 27-03-2011 | TODO Travel cost declaration, TODO December 2007-2009 |
> 0.62 | A-102: General Administration | |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Making coffee for the lot of us |
> 0.10 | O-100: General overhead | |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Helpdesk |
> 0.00 | C-100: Customer relations general | |
> | 27-03-2011 | Helpdesk, Categorize our helpdesk e-mails |
> 0.33 | C-100: Customer relations general | |
> | 27-03-2011 | Helpdesk, Help out customer a |
> 0.17 | C-101: Customer A | [X] |
> | 27-03-2011 | Helpdesk, Help out customer b on issue x |
> 0.33 | C-102: Customer B | [?] |
> | 27-03-2011 | Helpdesk, Help out potential customer c |
> 0.33 | C-100: Customer relations general | |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Develop our main web app |
> 0.00 | W-100: Web Development | |
> | 27-03-2011 | Develop our main web app, that |
> 0.68 | W-100: Web Development | |
> | 27-03-2011 | Develop our main web app, something only customer b wants |
> 0.48 | C-102: Customer B | [?] |
> #+TBLFM: $2='(if (string= "$0" "@-I") "$0" (concat "@-I" ", "
> "$0"));L::$4='(if (string= "$0" "") "@-I" "$0");L
> #+END:
> * TODO Travel cost declaration
> DEADLINE: <2011-04-01 vr .+1m>
> - State "DONE" from "TESTING" [2011-02-01 di 10:02]
> :LOGBOOK:
> CLOCK: [2011-03-02 wo 09:17]--[2011-03-02 wo 09:22] => 0:05
> :END:
> - State "DONE" from "TESTING" [2011-01-04 di 09:40]
> :PROPERTIES:
> :COSTCENTER: A-102: General Administration
> :END:
> ** TODO December 2007-2009
> :CLOCK:
> CLOCK: [2011-03-27 Sun 09:28]--[2011-03-27 Sun 10:05] => 0:37
> :END:
> Find out what were my costs during this hazy period of my life.
Hi Niels,
Thanks for the example. That helps a lot. I think posting this to Worg
would be very useful.
Thanks for sharing this!
Regards,
--
Bernt