org-collector - propview display problems

org-collector - propview display problems

[dche]

Hello 

I tried to use org-collector with the example propose
at this link http://orgmode.org/worg/org-contrib/org-collector.html

I would like to use propview as cited in example but whatever I do,
I get the outputs below.



* Example

#+BEGIN: propview :cols (ITEM amount)
| ITEM                                   | amount |
|----------------------------------------+--------|
| "* Example"                            |      0 |
| "** December Spending"                 |      0 |
| "*** Week One"                         |      0 |
| "**** Grocery Store [2008-12-01 lun.]" |      0 |
| "**** Athletic club [2008-12-02 mar.]" |      0 |
| "*** Week Two"                         |      0 |
| "**** Restaurant [2008-12-08 lun.]"    |      0 |
|----------------------------------------+--------|
|                                        |        |
#+END:

#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols 
(ITEM amount)
| ITEM | amount |
|------+--------|
|------+--------|
|      |        |
#+END:

#+BEGIN: propview :cols (ITEM (+ 400 amount)) :scope tree :match "example"
| ITEM                                   | (+ 400 amount) |
|----------------------------------------+----------------|
| "** December Spending"                 |              0 |
| "*** Week One"                         |              0 |
| "**** Grocery Store [2008-12-01 lun.]" |              0 |
| "**** Athletic club [2008-12-02 mar.]" |              0 |
| "*** Week Two"                         |              0 |
| "**** Restaurant [2008-12-08 lun.]"    |              0 |
|----------------------------------------+----------------|
|                                        |                |
#+END:

** December Spending					
	       :example:
   :PROPERTIES:
   :ID: december
   :END:

*** Week One
**** Grocery Store [2008-12-01 Mon]
     :PROPERTIES:
     :amount: 56.77
     :spendtype: food
     :END:
**** Athletic club [2008-12-02 Tue]
     :PROPERTIES:
     :amount: 75.00
     :spendtype: health
     :END:
*** Week Two 
**** Restaurant [2008-12-08 Mon]
     :PROPERTIES:
     :amount: 30.67
     :spendtype: food
     :END:

The item is not extracted as expected (there are "*" that are also 
displayed corresponding of the level of entries) and the extracted
field is zero whatever of the effective value of this field (here 
amount).

This is test with 8.3.4 and GNU Emacs 24.3.1 (i386-mingw-nt6.1.7601).



Regards

Re: org-collector - propview display problems

[Charles Millar]

Hi,

On 02/29/2016 01:04 PM, dche wrote:
> Hello
>
> I tried to use org-collector with the example propose
> at this link http://orgmode.org/worg/org-contrib/org-collector.html
>
> I would like to use propview as cited in example but whatever I do,
> I get the outputs below.
>
>
>
> * Example
>
> #+BEGIN: propview :cols (ITEM amount)
> | ITEM                                   | amount |
> |----------------------------------------+--------|
> | "* Example"                            |      0 |
> | "** December Spending"                 |      0 |
> | "*** Week One"                         |      0 |
> | "**** Grocery Store [2008-12-01 lun.]" |      0 |
> | "**** Athletic club [2008-12-02 mar.]" |      0 |
> | "*** Week Two"                         |      0 |
> | "**** Restaurant [2008-12-08 lun.]"    |      0 |
> |----------------------------------------+--------|
> |                                        |        |
> #+END:
>
> #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
> (ITEM amount)
> | ITEM | amount |
> |------+--------|
> |------+--------|
> |      |        |
> #+END:
>
> #+BEGIN: propview :cols (ITEM (+ 400 amount)) :scope tree :match "example"
> | ITEM                                   | (+ 400 amount) |
> |----------------------------------------+----------------|
> | "** December Spending"                 |              0 |
> | "*** Week One"                         |              0 |
> | "**** Grocery Store [2008-12-01 lun.]" |              0 |
> | "**** Athletic club [2008-12-02 mar.]" |              0 |
> | "*** Week Two"                         |              0 |
> | "**** Restaurant [2008-12-08 lun.]"    |              0 |
> |----------------------------------------+----------------|
> |                                        |                |
> #+END:
>
> ** December Spending					
> 	       :example:
>     :PROPERTIES:
>     :ID: december
>     :END:
>
> *** Week One
> **** Grocery Store [2008-12-01 Mon]
>       :PROPERTIES:
>       :amount: 56.77
>       :spendtype: food
>       :END:
> **** Athletic club [2008-12-02 Tue]
>       :PROPERTIES:
>       :amount: 75.00
>       :spendtype: health
>       :END:
> *** Week Two
> **** Restaurant [2008-12-08 Mon]
>       :PROPERTIES:
>       :amount: 30.67
>       :spendtype: food
>       :END:
>
> The item is not extracted as expected (there are "*" that are also
> displayed corresponding of the level of entries) and the extracted
> field is zero whatever of the effective value of this field (here
> amount).
>
> This is test with 8.3.4 and GNU Emacs 24.3.1 (i386-mingw-nt6.1.7601).
>
>
>
I believe this is the same problem or bug I reported in April 2015! 
Others have also brought attention it to this, but nothing has been done 
to fix it.

Charlie Millar

Re: org-collector - propview display problems

[dche]

This function interested me in order to produce subset of data in tabular 
with search criteria included in properties field. I hoped to
use this kind of approach as a kind of database and possibly use one of 
property field to include an information about a link to a file or the use 
of attachment (if possible this way).

This function is in contrib folder. Is this status that makes it not 
supported ?

Regards

Re: org-collector - propview display problems

[Nicolas Goaziou]

Hello,

dche <dchechin92@gmail.com> writes:

> This function interested me in order to produce subset of data in tabular 
> with search criteria included in properties field. I hoped to
> use this kind of approach as a kind of database and possibly use one of 
> property field to include an information about a link to a file or the use 
> of attachment (if possible this way).
>
> This function is in contrib folder. Is this status that makes it not 
> supported ?

Some are supported by their author, others are not. I think this library
is not maintained anymore.

In any case, could you provide an ECM (with an emphasized "M")? I'll try
to have a look at it.

Regards,

-- 
Nicolas Goaziou

Re: org-collector - propview display problems

[dche]

Thank you.

In the first post I used the example proposed in the description of
org-collector that is accessible at this link. 


http://orgmode.org/worg/sources/org-contrib/org-collector-example.org


With this example org-collector is able to gather in a table with the use 
of propview in a #+BEGIN #+END block. To display the table, you have to use
C-c C-c in front of the #+BEGIN: instruction.

With the example proposed in the link  the following results are displayed  :

#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
(ITEM amount)
| "ITEM"                           | "amount" |
|----------------------------------+----------|
| "Grocery Store [2008-12-01 Mon]" |    56.77 |
| "Restaurant [2008-12-08 Mon]"    |    30.67 |
|----------------------------------+----------|
|                                  |          |
#+END:




With my actual configuration Org-mode 8.3.4 and GNU Emacs 24.3.1
(i386-mingw-nt6.1.7601), I get the following output :


#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols 

#+END:

#+BEGIN: propview :cols (ITEM (+ 400 amount)) :scope tree :match "example"
| ITEM                                   | (+ 400 amount) |
|----------------------------------------+----------------|
| "** December Spending"                 |              0 |
| "*** Week One"                         |              0 |
| "**** Grocery Store [2008-12-01 lun.]" |              0 |
| "**** Athletic club [2008-12-02 mar.]" |              0 |
| "*** Week Two"                         |              0 |
| "**** Restaurant [2008-12-08 lun.]"    |              0 |
|----------------------------------------+----------------|
|                                        |                |
#+END:

The org-collector function is previously loaded with (require 'org-collector)

Regards

Re: org-collector - propview display problems

[Nicolas Goaziou]

Hello,

dche <dchechin92@gmail.com> writes:

> With my actual configuration Org-mode 8.3.4 and GNU Emacs 24.3.1
> (i386-mingw-nt6.1.7601), I get the following output :
>
>
> #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols 
>
> #+END:

It should be ((string= SPENDTYPE "food")).

> #+BEGIN: propview :cols (ITEM (+ 400 amount)) :scope tree :match "example"

Here: (ITEM (+ 400 AMOUNT))

Properties are returned upper-cased by `org-entry-properties'.


Regards,

-- 
Nicolas Goaziou

Re: org-collector - propview display problems

[dche]

Thank you.

I have just done the test and I have the following ouptut 


#+BEGIN: propview :id "december" :conds ((string= SPENDTYPE "food")) :cols 
(ITEM AMOUNT)
| ITEM                                   | AMOUNT |
|----------------------------------------+--------|
| "**** Grocery Store [2008-12-01 lun.]" |  56.77 |
| "**** Restaurant [2008-12-08 lun.]"    |  30.67 |
|----------------------------------------+--------|
|                                        |        |
#+END:


Which is nearly the same as the example provides :

#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
(ITEM amount)
| "ITEM"                           | "amount" |
|----------------------------------+----------|
| "Grocery Store [2008-12-01 Mon]" |    56.77 |
| "Restaurant [2008-12-08 Mon]"    |    30.67 |
|----------------------------------+----------|
|                                  |          |
#+END:


I don't know if it is possible to get rid of the stars for the ITEM 
entries. 
Thank you again. I will use org-collector again.

Regards

Re: org-collector - propview display problems

[Nicolas Goaziou]

Hello,

dche <dchechin92@gmail.com> writes:

> I have just done the test and I have the following ouptut 
>
> #+BEGIN: propview :id "december" :conds ((string= SPENDTYPE "food")) :cols 
> (ITEM AMOUNT)
> | ITEM                                   | AMOUNT |
> |----------------------------------------+--------|
> | "**** Grocery Store [2008-12-01 lun.]" |  56.77 |
> | "**** Restaurant [2008-12-08 lun.]"    |  30.67 |
> |----------------------------------------+--------|
> |                                        |        |
> #+END:
>
> Which is nearly the same as the example provides :
>
> #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
> (ITEM amount)
> | "ITEM"                           | "amount" |
> |----------------------------------+----------|
> | "Grocery Store [2008-12-01 Mon]" |    56.77 |
> | "Restaurant [2008-12-08 Mon]"    |    30.67 |
> |----------------------------------+----------|
> |                                  |          |
> #+END:
>
>
> I don't know if it is possible to get rid of the stars for the ITEM 
> entries.

This is already the case in the development version.

Regards,

-- 
Nicolas Goaziou

Re: org-collector - propview display problems

[Charles Millar]

Nicolas,

On 03/14/2016 08:36 AM, Nicolas Goaziou wrote:
> Hello,
>
> dche <dchechin92@gmail.com> writes:
>
>> I have just done the test and I have the following ouptut
>>
>> #+BEGIN: propview :id "december" :conds ((string= SPENDTYPE "food")) :cols
>> (ITEM AMOUNT)
>> | ITEM                                   | AMOUNT |
>> |----------------------------------------+--------|
>> | "**** Grocery Store [2008-12-01 lun.]" |  56.77 |
>> | "**** Restaurant [2008-12-08 lun.]"    |  30.67 |
>> |----------------------------------------+--------|
>> |                                        |        |
>> #+END:
>>
>> Which is nearly the same as the example provides :
>>
>> #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
>> (ITEM amount)
>> | "ITEM"                           | "amount" |
>> |----------------------------------+----------|
>> | "Grocery Store [2008-12-01 Mon]" |    56.77 |
>> | "Restaurant [2008-12-08 Mon]"    |    30.67 |
>> |----------------------------------+----------|
>> |                                  |          |
>> #+END:
>>
>>
>> I don't know if it is possible to get rid of the stars for the ITEM
>> entries.
> This is already the case in the development version.
>
> Regards,
>
Thank you for clarifying this. I just tried the example file again 
(after changing all properties to upper-case) and it now works as 
expected. (BTW I am using Org-mode version 8.3.4 
(release_8.3.4-655-g9fb077 @ 
/usr/local/share/emacs/site-lisp/org-mode/lisp/)

Charlie Millar

Re: org-collector - propview display problems

[Charles Millar]

Nicolas,

On 03/14/2016 08:36 AM, Nicolas Goaziou wrote:
> Hello,
>
> dche <dchechin92@gmail.com> writes:
>
>> I have just done the test and I have the following ouptut
>>
>> #+BEGIN: propview :id "december" :conds ((string= SPENDTYPE "food")) :cols
>> (ITEM AMOUNT)
>> | ITEM                                   | AMOUNT |
>> |----------------------------------------+--------|
>> | "**** Grocery Store [2008-12-01 lun.]" |  56.77 |
>> | "**** Restaurant [2008-12-08 lun.]"    |  30.67 |
>> |----------------------------------------+--------|
>> |                                        |        |
>> #+END:
>>
>> Which is nearly the same as the example provides :
>>
>> #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
>> (ITEM amount)
>> | "ITEM"                           | "amount" |
>> |----------------------------------+----------|
>> | "Grocery Store [2008-12-01 Mon]" |    56.77 |
>> | "Restaurant [2008-12-08 Mon]"    |    30.67 |
>> |----------------------------------+----------|
>> |                                  |          |
>> #+END:
>>
>>
>> I don't know if it is possible to get rid of the stars for the ITEM
>> entries.
> This is already the case in the development version.
>
> Regards,
>
Please let me know what I am missing or if I am just plain nuts.

I copied the org-collector example into my scratchorg file. Before 
executing he first propview block, I killed the following entry

**** Grocery Store [2008-12-01 Mon]
      :PROPERTIES:
      :amount: 56.77
      :spendtype: food
      :END:

I made sure that spendtype and amount in all other entries and in the 
propview blocks were upper cased.
I made sure that the first propview block had no results so it was just

#+BEGIN: propview :id "december" :conds ((string= SPENDTYPE "food")) 
:cols (ITEM AMOUNT)
#+END:

When executed (C-c C-c) the result still was

#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols (ITEM amount)
| "ITEM"                           | "amount" |
|----------------------------------+----------|
| "Grocery Store [2008-12-01 Mon]" |    56.77 | - how possible if there is no entry??????
| "Restaurant [2008-12-08 Mon]"    |    30.67 |
|----------------------------------+----------|
|                                  |          |
#+END:

In the example is :id somehow "hardwired" into the expected results. 
Please note that I also entered, not copied,  the first propview block 
(without the results) character by character into the buffer, executed 
and the Grocery Store still showed up!

If I upper case ID, I get the expected results

#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols (ITEM amount)
| "ITEM"                           | "amount" |
|----------------------------------+----------|
| "Restaurant [2008-12-08 Mon]"    |    30.67 |
|----------------------------------+----------|
|                                  |          |
#+END:

Should all options be upper cased as well? Or what should I read as to 
:id properties?

Charlie Millar

Re: org-collector - propview display problems

[dche]

Many thanks, I am going to use org-collector again.

It would be great if org-collector could implement kind of regular 
expression in the research of string.
For example with the example provides for org-collector something like 
:conds ((string= SPENDTYPE "health|food")) 
to look for health or food
I don't even know if it possible and I don't have the skill in programming 
to implement such function. Just an expression of a wish. 

Thank you again.