Publishing clocked time

Publishing clocked time

[Ivan Chernetsky]

Hello,

is it possible to publish clocked time of a TODO item? For instance, I
have a TODO item like this:

** TODO <todo item title>   :NEXT:
   - State "STARTED"  from "TODO"  [2009-09-04 Fri 15:56]
   - State "STARTED"    from "TODO"       [2009-09-04 Fri 14:52]
   CLOCK: [2009-09-04 Fri 14:52]--[2009-09-04 Fri 15:56] =>  1:04

When I publish a project that contains a file with this item, I
doesn't see last line with clocked time info. I have the following
settings regarding publishing:

(setq org-clock-persist t)
(org-clock-persistence-insinuate)
(setq org-clock-in-resume t)
(setq org-clock-into-drawer nil)
(setq org-clock-out-remove-zero-time-clocks t)
(setq org-clock-out-when-done nil)
(setq org-agenda-log-mode-items '(clock))

(setq org-todo-keywords '((sequence "TODO(t)" "STARTED(s!)" "|" "DONE(d!/!)")
			  (sequence "WAITING(w@/!)" "SOMEDAY(S!)" "|" "CANCELLED(c@/!)")))
(setq org-use-fast-todo-selection t)
(setq org-todo-state-tags-triggers
      '(("CANCELED" ("CANCELLED" . t))
	("WAITING" ("WAITING" . t) ("NEXT"))
	("SOMEDAY" ("WAITING" . t))
	("DONE" ("NEXT") ("WAITING"))
	("TODO" ("WAITING") ("CANCELLED"))
	("STARTED" ("WAITING") ("NEXT" . t))))
(setq org-tag-alist
      '(("NEXT" . ?N)
	("WAITING" . ?W)
	("CANCELLED" . ?C)))
(setq org-fast-tag-selection-single-key 'expert)
(setq org-agenda-custom-commands
      '(("s" "Started Tasks" todo "STARTED"
((org-agenda-todo-ignore-with-date nil)))
	("w" "Tasks waiting on something" tags "WAITING"
((org-use-tag-inheritance nil)))
	("n" "Next" tags "NEXT-WAITING-CANCELLED/!" nil)))
(setq org-agenda-repeating-timestamp-show-all t)
(setq org-agenda-show-all-dates t)
(setq org-agenda-sorting-strategy
      '((agenda time-up priority-down effort-up category-up)
	(todo priority-down)
	(tags priority-down)))


;; (setq org-agenda-include-diary t)
;; (setq org-agenda-include-all-todo t)

(setq org-agenda-files '("~/org/work/dooster.org"))
(setq org-directory "~/org/")

;; publishing
(setq org-publish-project-alist
      '(("work"
	 :base-directory "~/org/work"
	 :publishing-directory "~/org/published/work"
	 :recursive t
	 :base-extension "org"
	 :publishing-function org-publish-org-to-html
	 :auto-index t)))
(setq org-export-author-info nil)
(setq org-export-creator-info nil)
(setq org-export-html-use-infojs nil)
(setq org-export-with-drawers t)
(setq org-export-html-inline-images t)

Thanks in advance!

Re: Publishing clocked time

[Carsten Dominik]

Hi Ivan,

clocking lines are considered ugly and are therefore not included
during publishing.  I could make an option for it...  Are there
more people interested?

- Carsten

On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:

> Hello,
>
> is it possible to publish clocked time of a TODO item? For instance, I
> have a TODO item like this:
>
> ** TODO <todo item title>   :NEXT:
>   - State "STARTED"  from "TODO"  [2009-09-04 Fri 15:56]
>   - State "STARTED"    from "TODO"       [2009-09-04 Fri 14:52]
>   CLOCK: [2009-09-04 Fri 14:52]--[2009-09-04 Fri 15:56] =>  1:04
>
> When I publish a project that contains a file with this item, I
> doesn't see last line with clocked time info. I have the following
> settings regarding publishing:
>
> (setq org-clock-persist t)
> (org-clock-persistence-insinuate)
> (setq org-clock-in-resume t)
> (setq org-clock-into-drawer nil)
> (setq org-clock-out-remove-zero-time-clocks t)
> (setq org-clock-out-when-done nil)
> (setq org-agenda-log-mode-items '(clock))
>
> (setq org-todo-keywords '((sequence "TODO(t)" "STARTED(s!)" "|"  
> "DONE(d!/!)")
> 			  (sequence "WAITING(w@/!)" "SOMEDAY(S!)" "|" "CANCELLED(c@/!)")))
> (setq org-use-fast-todo-selection t)
> (setq org-todo-state-tags-triggers
>      '(("CANCELED" ("CANCELLED" . t))
> 	("WAITING" ("WAITING" . t) ("NEXT"))
> 	("SOMEDAY" ("WAITING" . t))
> 	("DONE" ("NEXT") ("WAITING"))
> 	("TODO" ("WAITING") ("CANCELLED"))
> 	("STARTED" ("WAITING") ("NEXT" . t))))
> (setq org-tag-alist
>      '(("NEXT" . ?N)
> 	("WAITING" . ?W)
> 	("CANCELLED" . ?C)))
> (setq org-fast-tag-selection-single-key 'expert)
> (setq org-agenda-custom-commands
>      '(("s" "Started Tasks" todo "STARTED"
> ((org-agenda-todo-ignore-with-date nil)))
> 	("w" "Tasks waiting on something" tags "WAITING"
> ((org-use-tag-inheritance nil)))
> 	("n" "Next" tags "NEXT-WAITING-CANCELLED/!" nil)))
> (setq org-agenda-repeating-timestamp-show-all t)
> (setq org-agenda-show-all-dates t)
> (setq org-agenda-sorting-strategy
>      '((agenda time-up priority-down effort-up category-up)
> 	(todo priority-down)
> 	(tags priority-down)))
>
>
> ;; (setq org-agenda-include-diary t)
> ;; (setq org-agenda-include-all-todo t)
>
> (setq org-agenda-files '("~/org/work/dooster.org"))
> (setq org-directory "~/org/")
>
> ;; publishing
> (setq org-publish-project-alist
>      '(("work"
> 	 :base-directory "~/org/work"
> 	 :publishing-directory "~/org/published/work"
> 	 :recursive t
> 	 :base-extension "org"
> 	 :publishing-function org-publish-org-to-html
> 	 :auto-index t)))
> (setq org-export-author-info nil)
> (setq org-export-creator-info nil)
> (setq org-export-html-use-infojs nil)
> (setq org-export-with-drawers t)
> (setq org-export-html-inline-images t)
>
> Thanks in advance!
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Publishing clocked time

[Sébastien Vauban]

Hi Carsten,

Carsten Dominik wrote:
> On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:
>>
>> is it possible to publish clocked time of a TODO item?
>
> clocking lines are considered ugly and are therefore not included during
> publishing. I could make an option for it... Are there more people
> interested?

Yes, quite interested, even if not absolutely required.

I needed that when I transferred my "billing" info to our company's
accountant, so that she was able to correctly bill the clients, and check that
I worked enough time on the month.

However, as the LaTeX export was quite empty of those info, I switched back to
sending the info as plain text email.

Though, would that be available, yes, I would definitely use it...

Seb

-- 
Sébastien Vauban



_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Re: Publishing clocked time

[Russell Adams]

Actually on this topic, I'd like to be able to make a simple table of
all time itemized by day. It'd be prettier than the clocktable lines,
and lower maintenance than the existing reports.


On Mon, Sep 07, 2009 at 05:35:56PM +0200, S??bastien Vauban wrote:
> Hi Carsten,
> 
> Carsten Dominik wrote:
> > On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:
> >>
> >> is it possible to publish clocked time of a TODO item?
> >
> > clocking lines are considered ugly and are therefore not included during
> > publishing. I could make an option for it... Are there more people
> > interested?
> 
> Yes, quite interested, even if not absolutely required.
> 
> I needed that when I transferred my "billing" info to our company's
> accountant, so that she was able to correctly bill the clients, and check that
> I worked enough time on the month.
> 
> However, as the LaTeX export was quite empty of those info, I switched back to
> sending the info as plain text email.
> 
> Though, would that be available, yes, I would definitely use it...
> 
> Seb
> 
> -- 
> S??bastien Vauban
> 
> 
> 
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
> 


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: Re: Publishing clocked time

[Ivan Chernetsky]

> Actually on this topic, I'd like to be able to make a simple table of
> all time itemized by day.

I am definitely subscribing to it. Also it would be wonderful if there
will be an option to include a table with tasks that was done or was
being done, by day. IMHO, such options allow to use org-mode at work
more freely and effectively.

By the way, are there any means of extensibility of publishing, not
touching the source code of org-mode? If no, what are plans about it
in the near future?

Re: Re: Publishing clocked time

[Carsten Dominik]

On Sep 7, 2009, at 5:56 PM, Russell Adams wrote:

> Actually on this topic, I'd like to be able to make a simple table of
> all time itemized by day. It'd be prettier than the clocktable lines,
> and lower maintenance than the existing reports.

This is not enough information to act upon.

- Carsten

>
>
> On Mon, Sep 07, 2009 at 05:35:56PM +0200, S??bastien Vauban wrote:
>> Hi Carsten,
>>
>> Carsten Dominik wrote:
>>> On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:
>>>>
>>>> is it possible to publish clocked time of a TODO item?
>>>
>>> clocking lines are considered ugly and are therefore not included  
>>> during
>>> publishing. I could make an option for it... Are there more people
>>> interested?
>>
>> Yes, quite interested, even if not absolutely required.
>>
>> I needed that when I transferred my "billing" info to our company's
>> accountant, so that she was able to correctly bill the clients, and  
>> check that
>> I worked enough time on the month.
>>
>> However, as the LaTeX export was quite empty of those info, I  
>> switched back to
>> sending the info as plain text email.
>>
>> Though, would that be available, yes, I would definitely use it...
>>
>> Seb
>>
>> -- 
>> S??bastien Vauban
>>
>>
>>
>> _______________________________________________
>> Emacs-orgmode mailing list
>> Remember: use `Reply All' to send replies to the list.
>> Emacs-orgmode@gnu.org
>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>
>
>
> ------------------------------------------------------------------
> Russell Adams                            RLAdams@AdamsInfoServ.com
>
> PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/
>
> Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Re: Publishing clocked time

[Carsten Dominik]

On Sep 9, 2009, at 9:47 AM, Ivan Chernetsky wrote:

>> Actually on this topic, I'd like to be able to make a simple table of
>> all time itemized by day.
>
> I am definitely subscribing to it. Also it would be wonderful if there
> will be an option to include a table with tasks that was done or was
> being done, by day. IMHO, such options allow to use org-mode at work
> more freely and effectively.

Same here.  WIthout an example, nothing actionable here.

>
> By the way, are there any means of extensibility of publishing, not
> touching the source code of org-mode? If no, what are plans about it
> in the near future?

What do you mean???

- Carsten

Re: Re: Publishing clocked time

[Carsten Dominik]

On Sep 7, 2009, at 5:35 PM, Sébastien Vauban wrote:

> Hi Carsten,
>
> Carsten Dominik wrote:
>> On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:
>>>
>>> is it possible to publish clocked time of a TODO item?
>>
>> clocking lines are considered ugly and are therefore not included  
>> during
>> publishing. I could make an option for it... Are there more people
>> interested?
>
> Yes, quite interested, even if not absolutely required.
>
> I needed that when I transferred my "billing" info to our company's
> accountant, so that she was able to correctly bill the clients, and  
> check that
> I worked enough time on the month.
>
> However, as the LaTeX export was quite empty of those info, I  
> switched back to
> sending the info as plain text email.
>
> Though, would that be available, yes, I would definitely use it...

No a single post in this thread does explain what exactly would be  
useful.. :-(

- Carsten

Re: Re: Publishing clocked time

[Russell Adams]

Sorry,

I think I'd chipped in here at one point, the idea is for routine
"timecards" a simple list of hours aggregated by date would be useful.

I could see aggregate hours for task by ALL dates unless otherwise
specified.

* Timecard

** Customer X
   CLOCK: [2009-09-01 Thu 09:00]--[2009-09-01 Thu 12:00] =>  3:00
   CLOCK: [2009-09-02 Thu 09:00]--[2009-09-02 Thu 12:00] =>  3:00
   CLOCK: [2009-09-03 Thu 09:00]--[2009-09-03 Thu 12:00] =>  3:00
   CLOCK: [2009-09-04 Thu 09:00]--[2009-09-04 Thu 12:00] =>  3:00
   CLOCK: [2009-09-05 Thu 09:00]--[2009-09-05 Thu 12:00] =>  3:00
   CLOCK: [2009-09-01 Thu 12:00]--[2009-09-01 Thu 17:00] =>  5:00
   CLOCK: [2009-09-02 Thu 12:00]--[2009-09-02 Thu 17:00] =>  5:00
   CLOCK: [2009-09-03 Thu 12:00]--[2009-09-03 Thu 17:00] =>  5:00
   CLOCK: [2009-09-04 Thu 12:00]--[2009-09-04 Thu 17:00] =>  5:00
   CLOCK: [2009-09-05 Thu 12:00]--[2009-09-05 Thu 17:00] =>  5:00

#+BEGIN timecard

|------------+------------+---------|
|     *Date* | *Task*     | *Hours* |
|------------+------------+---------|
| 2009-09-01 | Customer X |       8 |
| 2009-09-02 | Customer X |       8 |
| 2009-09-03 | Customer X |       8 |
| 2009-09-04 | Customer X |       8 |
| 2009-09-05 | Customer X |       8 |
|------------+------------+---------|
|    *Total* |            |      40 |
|------------+------------+---------|
#+END

I would anticipate that it may be optional to sort by date or by task
(if you include sublevels), though I have mixed feelings about adding
subtotal lines between aggregates.

Comments?

FYI, I'm learning LISP as we speak! Perhaps I can start customizing
things soon!

On Fri, Sep 11, 2009 at 05:51:45AM +0200, Carsten Dominik wrote:
>
> On Sep 7, 2009, at 5:35 PM, S?bastien Vauban wrote:
>
>> Hi Carsten,
>>
>> Carsten Dominik wrote:
>>> On Sep 4, 2009, at 5:32 PM, Ivan Chernetsky wrote:
>>>>
>>>> is it possible to publish clocked time of a TODO item?
>>>
>>> clocking lines are considered ugly and are therefore not included  
>>> during
>>> publishing. I could make an option for it... Are there more people
>>> interested?
>>
>> Yes, quite interested, even if not absolutely required.
>>
>> I needed that when I transferred my "billing" info to our company's
>> accountant, so that she was able to correctly bill the clients, and  
>> check that
>> I worked enough time on the month.
>>
>> However, as the LaTeX export was quite empty of those info, I switched 
>> back to
>> sending the info as plain text email.
>>
>> Though, would that be available, yes, I would definitely use it...
>
> No a single post in this thread does explain what exactly would be  
> useful.. :-(
>
> - Carsten
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: Publishing clocked time

[Peter Jones]

[-- Attachment #1: Type: text/plain, Size: 1341 bytes --]

Russell Adams <RLAdams@AdamsInfoServ.Com> writes:
> #+BEGIN timecard
>
> |------------+------------+---------|
> |     *Date* | *Task*     | *Hours* |
> |------------+------------+---------|
> | 2009-09-01 | Customer X |       8 |
> | 2009-09-02 | Customer X |       8 |
> | 2009-09-03 | Customer X |       8 |
> | 2009-09-04 | Customer X |       8 |
> | 2009-09-05 | Customer X |       8 |
> |------------+------------+---------|
> |    *Total* |            |      40 |
> |------------+------------+---------|
> #+END

I've attached my org-invoice.el file which does something very close to
this.  I use it to generate reports in table form like what you are
requesting, and I have another .el file that uses org-invoice as a
library to collect the same data and submit it to my invoicing system.

Example output:

#+BEGIN: invoice
| Task / Date                   |  Time |  Price |
|-------------------------------+-------+--------|
| Friday, August 21, 2009       | 03:00 |  55.00 |
| Blah Blah Blah                | 03:00 |  55.00 |
|-------------------------------+-------+--------|
| Friday, August 28, 2009       | 06:00 |  10.00 |
| Blah Blah Blah                | 06:00 |  10.00 |
|-------------------------------+-------+--------|
| Total:                        | 09:00 |  65.00 |

#+END:

You can disable the price calculation.


[-- Attachment #2: org-invoice.el --]
[-- Type: application/emacs-lisp, Size: 16297 bytes --]

[-- Attachment #3: Type: text/plain, Size: 64 bytes --]



-- 
Peter Jones - 303-219-0226
pmade inc.  - http://pmade.com

[-- Attachment #4: Type: text/plain, Size: 204 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Re: Publishing clocked time

[Russell Adams]

I noticed in the comments you're working on a way to upload to
Freshbooks! That quite exciting, given I use them too!

On Fri, Sep 11, 2009 at 08:02:26AM -0600, Peter Jones wrote:
> Russell Adams <RLAdams@AdamsInfoServ.Com> writes:
> > #+BEGIN timecard
> >
> > |------------+------------+---------|
> > |     *Date* | *Task*     | *Hours* |
> > |------------+------------+---------|
> > | 2009-09-01 | Customer X |       8 |
> > | 2009-09-02 | Customer X |       8 |
> > | 2009-09-03 | Customer X |       8 |
> > | 2009-09-04 | Customer X |       8 |
> > | 2009-09-05 | Customer X |       8 |
> > |------------+------------+---------|
> > |    *Total* |            |      40 |
> > |------------+------------+---------|
> > #+END
> 
> I've attached my org-invoice.el file which does something very close to
> this.  I use it to generate reports in table form like what you are
> requesting, and I have another .el file that uses org-invoice as a
> library to collect the same data and submit it to my invoicing system.
> 
> Example output:
> 
> #+BEGIN: invoice
> | Task / Date                   |  Time |  Price |
> |-------------------------------+-------+--------|
> | Friday, August 21, 2009       | 03:00 |  55.00 |
> | Blah Blah Blah                | 03:00 |  55.00 |
> |-------------------------------+-------+--------|
> | Friday, August 28, 2009       | 06:00 |  10.00 |
> | Blah Blah Blah                | 06:00 |  10.00 |
> |-------------------------------+-------+--------|
> | Total:                        | 09:00 |  65.00 |
> 
> #+END:
> 
> You can disable the price calculation.
> 


> 
> 
> -- 
> Peter Jones - 303-219-0226
> pmade inc.  - http://pmade.com

> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode



------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: Publishing clocked time

[Peter Jones]

Russell Adams <RLAdams@AdamsInfoServ.Com> writes:
> I noticed in the comments you're working on a way to upload to
> Freshbooks! That quite exciting, given I use them too!

Unfortunately (for you) I'm no longer working with the client that
required me to use Freshbooks.  So, I don't expect to finish that code.

-- 
Peter Jones - 303-219-0226
pmade inc.  - http://pmade.com

Re: Re: Publishing clocked time

[Carsten Dominik]

Hi Peter,

should we add org-invoice.el to the contrib directory?
Also, I would like to add org-crypt.el, actually to the core.
Do you agree, and do you have a copyright agreement signed
with the FSF?

- Carsten

On Sep 11, 2009, at 4:02 PM, Peter Jones wrote:

> Russell Adams <RLAdams@AdamsInfoServ.Com> writes:
>> #+BEGIN timecard
>>
>> |------------+------------+---------|
>> |     *Date* | *Task*     | *Hours* |
>> |------------+------------+---------|
>> | 2009-09-01 | Customer X |       8 |
>> | 2009-09-02 | Customer X |       8 |
>> | 2009-09-03 | Customer X |       8 |
>> | 2009-09-04 | Customer X |       8 |
>> | 2009-09-05 | Customer X |       8 |
>> |------------+------------+---------|
>> |    *Total* |            |      40 |
>> |------------+------------+---------|
>> #+END
>
> I've attached my org-invoice.el file which does something very close  
> to
> this.  I use it to generate reports in table form like what you are
> requesting, and I have another .el file that uses org-invoice as a
> library to collect the same data and submit it to my invoicing system.
>
> Example output:
>
> #+BEGIN: invoice
> | Task / Date                   |  Time |  Price |
> |-------------------------------+-------+--------|
> | Friday, August 21, 2009       | 03:00 |  55.00 |
> | Blah Blah Blah                | 03:00 |  55.00 |
> |-------------------------------+-------+--------|
> | Friday, August 28, 2009       | 06:00 |  10.00 |
> | Blah Blah Blah                | 06:00 |  10.00 |
> |-------------------------------+-------+--------|
> | Total:                        | 09:00 |  65.00 |
>
> #+END:
>
> You can disable the price calculation.
>
> <org-invoice.el>
>
> -- 
> Peter Jones - 303-219-0226
> pmade inc.  - http://pmade.com
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Publishing clocked time

[Peter Jones]

Carsten Dominik <carsten.dominik@gmail.com> writes:
> should we add org-invoice.el to the contrib directory?
> Also, I would like to add org-crypt.el, actually to the core.
> Do you agree, and do you have a copyright agreement signed
> with the FSF?

Yes, yes, and yes.

-- 
Peter Jones - 303-219-0226
pmade inc.  - http://pmade.com