from table to properties the inverse columview operation

from table to properties the inverse columview operation

[Uwe Brauer]

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/

Re: from table to properties the inverse columview operation

[TRS-80]

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

Re: from table to properties the inverse columview operation

[Uwe Brauer]

[-- 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 --]