Re: from table to properties the inverse columview operation

[TRS-80 <lists.trs-80@isnotmyreal.name>]

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