emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* from table to properties the inverse columview operation
@ 2022-03-06 18:30 Uwe Brauer
  2022-05-05  1:21 ` TRS-80
  0 siblings, 1 reply; 3+ messages in thread
From: Uwe Brauer @ 2022-03-06 18:30 UTC (permalink / raw)
  To: emacs-orgmode


Hi

I have for example 

* Grupos                                                           :noexport:
  :PROPERTIES:
  :EXPORT_OPTIONS: num:t
  :COLUMNS:  %10GRP(Grupos) %10HOJA(Hoja Nr) %10EJ(Ejericio Nr) %17DATE(Date) %7STATUS(Status){X/}
  :ID:       Grupos
  :END:

** WAIT 1 <2022-02-03 jue 16:30> :Annu22: User
   :PROPERTIES:
   :ID:       6c53abda-5351-4651-8ec0-60138b248baa
   :Email:    user@gmail.com
   :Grp:      Gr1
   :Usuario1: User1
   :Email1:   user1@gmail.com
   :Usuario2: User2
   :Email2:   user2@gmail.com
   :StEnv1:   [X]
   :H1:       9 
   :P1:       5
   :End:

** <2022-03-06 dom 18:16> : Ejercicios elegidos de la Hoja1: quien puede hablar el día <2022-03-07 lun>
#+TBLNAME: hoja1
#+BEGIN: columnview :maxlevel 2 :skip-empty-rows t :indent nil :hlines 1  :format "%5TODO(Status) %5Grp(Grupo) %5Usuario1(Miembro1) %5H1(Ejercicio elegido) %5P1(Porcentaje) %7StEnv1(Solución enviado){X/}"
| Status | Grupo | Miembro1 | Ejercicio elegido | Porcentaje | Solución enviado |
|--------+-------+----------+-------------------+------------+------------------|
|        |       |          |                   |            | [1/1]            |
| WAIT   | Gr1   | User1    |                 9 |          5 | [X]              |
#+END


So a table is generated based on earlier entries. 

Is there the inverse operation? Given a table I recover the original
properties?

Regards

Uwe Brauer 

-- 
I strongly condem Putin's war of agression against the Ukraine.
I support to deliver weapons to Ukraine’s military. 
I support the ban of Russia from SWIFT. I support the EU membership of the Ukraine. https://how-to-help-ukraine-now.super.site/




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

* Re: from table to properties the inverse columview operation
  2022-03-06 18:30 from table to properties the inverse columview operation Uwe Brauer
@ 2022-05-05  1:21 ` TRS-80
  2022-06-12 15:27   ` Uwe Brauer
  0 siblings, 1 reply; 3+ messages in thread
From: TRS-80 @ 2022-05-05  1:21 UTC (permalink / raw)
  To: emacs-orgmode

Uwe Brauer <oub@mat.ucm.es> writes:

> Hi
>
> I have for example 
>
> * Grupos                                                           :noexport:
>   :PROPERTIES:
>   :EXPORT_OPTIONS: num:t
>   :COLUMNS:  %10GRP(Grupos) %10HOJA(Hoja Nr) %10EJ(Ejericio Nr) %17DATE(Date) %7STATUS(Status){X/}
>   :ID:       Grupos
>   :END:
>
> ** WAIT 1 <2022-02-03 jue 16:30> :Annu22: User
>    :PROPERTIES:
>    :ID:       6c53abda-5351-4651-8ec0-60138b248baa
>    :Email:    user@gmail.com
>    :Grp:      Gr1
>    :Usuario1: User1
>    :Email1:   user1@gmail.com
>    :Usuario2: User2
>    :Email2:   user2@gmail.com
>    :StEnv1:   [X]
>    :H1:       9 
>    :P1:       5
>    :End:
>
> ** <2022-03-06 dom 18:16> : Ejercicios elegidos de la Hoja1: quien puede hablar el día <2022-03-07 lun>
>
> #+TBLNAME: hoja1
> #+BEGIN: columnview :maxlevel 2 :skip-empty-rows t :indent nil :hlines 1  :format "%5TODO(Status) %5Grp(Grupo) %5Usuario1(Miembro1) %5H1(Ejercicio elegido) %5P1(Porcentaje) %7StEnv1(Solución enviado){X/}"
>
> | Status | Grupo | Miembro1 | Ejercicio elegido | Porcentaje | Solución enviado |
> |--------+-------+----------+-------------------+------------+------------------|
> |        |       |          |                   |            | [1/1]            |
> | WAIT   | Gr1   | User1    |                 9 |          5 | [X]              |
> #+END
>
> So a table is generated based on earlier entries. 
>
> Is there the inverse operation? Given a table I recover the original
> properties?

I think it might be easier to do in awk than ELisp.  And I am better in
Elisp than awk, but awk was made for almost exactly this sort of thing.

Anyway, if some existing (Elisp) function exists for this, I would like
to know about it as well[0].

Cheers,
TRS-80

[0] I have already re-implemented too many things which already
existed, that I just did not know about at the time!  :D



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

* Re: from table to properties the inverse columview operation
  2022-05-05  1:21 ` TRS-80
@ 2022-06-12 15:27   ` Uwe Brauer
  0 siblings, 0 replies; 3+ messages in thread
From: Uwe Brauer @ 2022-06-12 15:27 UTC (permalink / raw)
  To: emacs-orgmode

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


> Uwe Brauer <oub@mat.ucm.es> writes:

> I think it might be easier to do in awk than ELisp.  And I am better in
> Elisp than awk, but awk was made for almost exactly this sort of thing.

> Anyway, if some existing (Elisp) function exists for this, I would like
> to know about it as well[0].



It  does

 org-transform-tree-table/toggle 
 URL: https://github.com/jplindstrom/emacs-org-transform-tree-table

It is in melpa I think




-- 
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine. 

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

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

end of thread, other threads:[~2022-06-12 15:28 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2022-03-06 18:30 from table to properties the inverse columview operation Uwe Brauer
2022-05-05  1:21 ` TRS-80
2022-06-12 15:27   ` 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).