TODO or checkboxes in org tables

emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

* TODO or checkboxes in org tables
@ 2020-05-01 20:28 Uwe Brauer
  2020-05-02  8:46 ` Axel Kielhorn
  0 siblings, 1 reply; 7+ messages in thread
From: Uwe Brauer @ 2020-05-01 20:28 UTC (permalink / raw)
  To: emacs-orgmode

Hi

I have an orgtable with a lot of useful information, I would like to add
a column either for TODOS or checkboxes but it seems not work any idea
whether such an addon package exist or any change that such a feature
will be implemented?

Regards

Uwe Brauer 

^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-01 20:28 TODO or checkboxes in org tables Uwe Brauer
@ 2020-05-02  8:46 ` Axel Kielhorn
  2020-05-02 19:33   ` Uwe Brauer
  0 siblings, 1 reply; 7+ messages in thread
From: Axel Kielhorn @ 2020-05-02  8:46 UTC (permalink / raw)
  To: Org-Mode Mailing List

Hi Uwe,

> I have an orgtable with a lot of useful information, I would like to add
> a column either for TODOS or checkboxes but it seems not work any idea
> whether such an addon package exist or any change that such a feature
> will be implemented?

I use a different approach.
I store the information in a normal org structure with TODO keywords.
I hide the checkboxes (and other meta information) in a drawer.

From this I generate a column view to present the information in a table.

You can generate different column views from the same data set.
I used the second version for years but recently discovered the :match argument.
If you mark the actual data as :noexport: only the table will be printed.

Greetings
Axel


** Arbeitsfortschritt
:PROPERTIES:
    :EXPORT_FILE_NAME: Beispiele
    :EXPORT_OPTIONS: num:nil
    :COLUMNS:  %50ITEM(Problem) %5PB(Nr BP) %11TODO(Status) %6TAGS(Wer) %10TERMIN(Termin) %7ERLEDIGT(Erledigt){X/} %6SICHERHEIT(Sicher){X/}
    :ID: Aufgaben
:END:

*** 2017-10-19 [5/7]
**** CAD nachpflegen Lasertaster                                     :BKI:
:PROPERTIES:
:TERMIN: 
:PB: 1
:ERLEDIGT: [ ]
:END:
**** DONE Ventilinsel                                                :BKI:
:PROPERTIES:
:ERLMON:   [X]
:PB:       2
:ERLEDIGT: [X]
:END:
- Kollision mit Verkleidung prüfen
**** DONE Schaltschrank
    CLOSED: [2017-11-22 Mi 11:52]
    :PROPERTIES:
    :PB:       3
    :ERLEDIGT:   [X]
    :TERMIN: 2017-12-05
    :END:
**** DONE Schutzverkleidung
    CLOSED: [2017-10-20 Fr 09:29]
    :PROPERTIES:
    :PB:       4
    :ERLEDIGT:   [X]
    :TERMIN: 2017-11-03
    :SICHERHEIT: [ ]
    :END:
**** Projektleiter Bodenverankerung (Bohrtiefe)                       :PL:
    :PROPERTIES:
    :PB:       5
    :ERLEDIGT: [ ]
    :END:
- Befestigung kundenseitig
**** DONE Wartungseinheit
    CLOSED: [2017-11-02 Do 07:54]
    :PROPERTIES:
    :PB:       6
    :ERLEDIGT:   [X]
    :END:
- Luftzuführung
- zusätzlicher Verteiler für gesicherte Luft
- Rejekt und Stopper mit Einzelventilen
**** DONE Roboter Vakuumerzeuger
    CLOSED: [2018-01-16 Di 13:33]
    :PROPERTIES:
    :PB:       7
    :ERLEDIGT: [X]
    :END:
- Bohrung in Rahmen fertig
- Blechteil fehlt noch



*** Aushang Arbeitsfortschritt

#+BEGIN: columnview :hlines 1 :id "Aufgaben" :indent t :match "/-DONE" :format "%50ITEM(Problem) %5PB(Nr) %12TODO %8TAGS(Wer) %12Termin"
#+attr_latex: :align p{3.5cm}rlll  
| Problem                              | Nr | TODO            | Wer   | Termin |
|--------------------------------------+----+-----------------+-------+--------|
| \_  Arbeitsfortschritt               |    |                 |       |        |
| \_    2017-10-19                     |    |                 |       |        |
| \_      Lasertaster                  |  1 | CAD nachpflegen | :BKI: |        |
| \_      Bodenverankerung (Bohrtiefe) |  5 | Projektleiter   | :PL:  |        |
| \_    Aushang Arbeitsfortschritt     |    |                 |       |        |
#+END

*** Aushang Arbeitsfortschritt (alt)

#+BEGIN: columnview :hlines 1 :id "Aufgaben" :indent t :format "%50ITEM(Problem) %5PB(Nr) %12TODO %8TAGS(Wer) %12Termin %7ERLEDIGT(Erledigt){X/}"
| Problem                              | Nr | TODO            | Wer   |     Termin | Erledigt |
|--------------------------------------+----+-----------------+-------+------------+----------|
| \_  Arbeitsfortschritt               |    |                 |       |            | [0/1]    |
| \_    2017-10-19                     |    |                 |       |            | [5/7]    |
| \_      Lasertaster                  |  1 | CAD nachpflegen | :BKI: |            | [ ]      |
| \_      Ventilinsel                  |  2 | DONE            | :BKI: |            | [X]      |
| \_      Schaltschrank                |  3 | DONE            |       | 2017-12-05 | [X]      |
| \_      Schutzverkleidung            |  4 | DONE            |       | 2017-11-03 | [X]      |
| \_      Bodenverankerung (Bohrtiefe) |  5 | Projektleiter   | :PL:  |            | [ ]      |
| \_      Wartungseinheit              |  6 | DONE            |       |            | [X]      |
| \_      Roboter Vakuumerzeuger       |  7 | DONE            |       |            | [X]      |
| \_    Aushang Arbeitsfortschritt     |    |                 |       |            |          |
#+END

^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-02  8:46 ` Axel Kielhorn
@ 2020-05-02 19:33   ` Uwe Brauer
  2020-05-03  7:05     ` Axel Kielhorn
  0 siblings, 1 reply; 7+ messages in thread
From: Uwe Brauer @ 2020-05-02 19:33 UTC (permalink / raw)
  To: emacs-orgmode

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

>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:

Hi Alex,

I am not sure my first answer made it, so I apologize for a possible
crossposting.

   > Hi Uwe,
   >> I have an orgtable with a lot of useful information, I would like to add
   >> a column either for TODOS or checkboxes but it seems not work any idea
   >> whether such an addon package exist or any change that such a feature
   >> will be implemented?

   > I use a different approach.
   > I store the information in a normal org structure with TODO keywords.
   > I hide the checkboxes (and other meta information) in a drawer.


I thought about this as well, but the table is an import form an excel
documente and contains a row of 70 different persons, so to transform
this to a normal org structure would require some work, I presume.

In any case, thanks for you example I will try it out. 
   > From this I generate a column view to present the information in a table.

   > You can generate different column views from the same data set.
   > I used the second version for years but recently discovered the :match argument.
   > If you mark the actual data as :noexport: only the table will be printed.

A last question, which the command to generate the table
org-insert-dblock:columnview ?

Greetings

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-02 19:33   ` Uwe Brauer
@ 2020-05-03  7:05     ` Axel Kielhorn
  2020-05-07 17:05       ` Uwe Brauer
  0 siblings, 1 reply; 7+ messages in thread
From: Axel Kielhorn @ 2020-05-03  7:05 UTC (permalink / raw)
  To: Org-Mode Mailing List

> Am 02.05.2020 um 21:33 schrieb Uwe Brauer <oub@mat.ucm.es>:
> 
>>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:
> 
> Hi Alex,
> 
> I am not sure my first answer made it, so I apologize for a possible
> crossposting.

It didn’t reach me.

> A last question, which the command to generate the table
> org-insert-dblock:columnview ?

I’m using:

org-columns-insert-dblock

Inserting via

org-dynamic-block-insert-dblock

Section A.6 [Dynymic Blocks]

does not work.

The command is available in the menu <Org><TAGS and Properties>

The manual (7.5.3) says

C-c C-x i (org-insert-columns-dblock)
Insert a dynamic block capturing a column view. Prompt for the scope or ID of the view.

That does not work for me.

Emacs says:

org-insert-columns-dblock is an alias for `org-columns-insert-dblock'.

(org-insert-columns-dblock)

This function is obsolete since Org 9.0;
use ‘org-columns-insert-dblock’ instead.

For more information check the manuals.

Create a dynamic block capturing a column view table.

C-c C-x i is undefined for me.

I’m sending a bug report in a separate mail.

Greetings Axel

^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-03  7:05     ` Axel Kielhorn
@ 2020-05-07 17:05       ` Uwe Brauer
  2020-05-08  4:37         ` Axel Kielhorn
  0 siblings, 1 reply; 7+ messages in thread
From: Uwe Brauer @ 2020-05-07 17:05 UTC (permalink / raw)
  To: emacs-orgmode

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

>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:

Hi Alex
   >> Am 02.05.2020 um 21:33 schrieb Uwe Brauer <oub@mat.ucm.es>:
   >> 
   >>>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:
   >> 
   >> Hi Alex,
   >> 
   >> I am not sure my first answer made it, so I apologize for a possible
   >> crossposting.

   > It didn’t reach me.

   >> A last question, which the command to generate the table
   >> org-insert-dblock:columnview ?

   > I’m using:

   > org-columns-insert-dblock


That seems to be the same function I use. 

However I set the cursor on 
** Arbeitsfortschritt, 
use that function and I obtain 

#+BEGIN: columnview :hlines 1 :id local
| ITEM                                       | TODO | PRIORITY | TAGS  |
|--------------------------------------------+------+----------+-------|
| Arbeitsfortschritt                         |      | B        |       |
| 2017-10-19                                 |      | B        |       |
| CAD nachpflegen Lasertaster                |      | B        | :BKI: |
| Ventilinsel                                | DONE | B        | :BKI: |
| Schaltschrank                              | DONE | B        |       |
| Schutzverkleidung                          | DONE | B        |       |
| Projektleiter Bodenverankerung (Bohrtiefe) |      | B        | :PL:  |
| Wartungseinheit                            | DONE | B        |       |
| Roboter Vakuumerzeuger                     | DONE | B        |       |
| Aushang Arbeitsfortschritt                 |      | B        |       |
| Aushang Arbeitsfortschritt (alt)           |      | B        |       |
#+END:


Which is not what you seemed to get. What is my mistake?

Thanks and regards

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-07 17:05       ` Uwe Brauer
@ 2020-05-08  4:37         ` Axel Kielhorn
  2020-05-08  9:21           ` Uwe Brauer
  0 siblings, 1 reply; 7+ messages in thread
From: Axel Kielhorn @ 2020-05-08  4:37 UTC (permalink / raw)
  To: Org-Mode Mailing List



> Am 07.05.2020 um 19:05 schrieb Uwe Brauer <oub@mat.ucm.es>:
> 
>>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:
> 
> Hi Alex
>>> Am 02.05.2020 um 21:33 schrieb Uwe Brauer <oub@mat.ucm.es>:
>>> 
>>>>>> "AK" == Axel Kielhorn <org-mode@axelkielhorn.de> writes:
>>> 
>>> Hi Alex,
>>> 
>>> I am not sure my first answer made it, so I apologize for a possible
>>> crossposting.
> 
>> It didn’t reach me.
> 
>>> A last question, which the command to generate the table
>>> org-insert-dblock:columnview ?
> 
>> I’m using:
> 
>> org-columns-insert-dblock
> 
> 
> That seems to be the same function I use. 
> 
> However I set the cursor on 
> ** Arbeitsfortschritt, 
> use that function and I obtain 
> 
> #+BEGIN: columnview :hlines 1 :id local
> | ITEM                                       | TODO | PRIORITY | TAGS  |
> |--------------------------------------------+------+----------+-------|
> | Arbeitsfortschritt                         |      | B        |       |
> | 2017-10-19                                 |      | B        |       |
> | CAD nachpflegen Lasertaster                |      | B        | :BKI: |
> | Ventilinsel                                | DONE | B        | :BKI: |
> | Schaltschrank                              | DONE | B        |       |
> | Schutzverkleidung                          | DONE | B        |       |
> | Projektleiter Bodenverankerung (Bohrtiefe) |      | B        | :PL:  |
> | Wartungseinheit                            | DONE | B        |       |
> | Roboter Vakuumerzeuger                     | DONE | B        |       |
> | Aushang Arbeitsfortschritt                 |      | B        |       |
> | Aushang Arbeitsfortschritt (alt)           |      | B        |       |
> #+END:
> 
> 
> Which is not what you seemed to get. What is my mistake?

I’m sorry, I didn’t tell you the whole truth.

„Projektleiter“ and „CAD Nachpflegen“ are defined as TODO keywords.

(A special case of WAITNG and an ALLMOST DONE state)

You have to add the additional options yourself:

:indent t :format "%50ITEM(Problem) %5PB(Nr) %12TODO %8TAGS(Wer) %12Termin %7ERLEDIGT(Erledigt){X/}"

I hope that helps
Axel




^ permalink raw reply	[flat|nested] 7+ messages in thread

* Re: TODO or checkboxes in org tables
  2020-05-08  4:37         ` Axel Kielhorn
@ 2020-05-08  9:21           ` Uwe Brauer
  0 siblings, 0 replies; 7+ messages in thread
From: Uwe Brauer @ 2020-05-08  9:21 UTC (permalink / raw)
  To: emacs-orgmode

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



   > I’m sorry, I didn’t tell you the whole truth.

   > „Projektleiter“ and „CAD Nachpflegen“ are defined as TODO keywords.

   > (A special case of WAITNG and an ALLMOST DONE state)

   > You have to add the additional options yourself:

   > :indent t :format "%50ITEM(Problem) %5PB(Nr) %12TODO %8TAGS(Wer) %12Termin %7ERLEDIGT(Erledigt){X/}"

Thanks for clarifying 

Like this

:PROPERTIES:
       :EXPORT_FILE_NAME: Beispiele
       :EXPORT_OPTIONS: num:nil
       :COLUMNS:  %50ITEM(Problem) %5PB(Nr BP) %11TODO(Status) %6TAGS(Wer) %10TERMIN(Termin) %7ERLEDIGT(Erledigt){X/} %6SICHERHEIT(Sicher){X/}:indent t :format "%50ITEM(Problem) %5PB(Nr) %12TODO %8TAGS(Wer) %12Termin %7ERLEDIGT(Erledigt){X/}"
       :ID: Aufgaben
   :END:

Sorry I am not very acquainted with these environments.

In any case it it not help, so I presume I misunderstood something
fundamentally.

Shall we take this off the list and continue privately?

Regards

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

^ permalink raw reply	[flat|nested] 7+ messages in thread

end of thread, other threads:[~2020-05-08  9:21 UTC | newest]

Thread overview: 7+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2020-05-01 20:28 TODO or checkboxes in org tables Uwe Brauer
2020-05-02  8:46 ` Axel Kielhorn
2020-05-02 19:33   ` Uwe Brauer
2020-05-03  7:05     ` Axel Kielhorn
2020-05-07 17:05       ` Uwe Brauer
2020-05-08  4:37         ` Axel Kielhorn
2020-05-08  9:21           ` Uwe Brauer

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).