[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] orgmode and a database

From: Jose E. Marchesi
Subject: Re: [O] orgmode and a database
Date: Tue, 05 Apr 2016 15:12:12 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.0.50 (gnu/linux)

       > I have been using recutils with orgmode for more than year - still
       > learning of course. So far, my experience has been fine. I am still
       > developing some sort of standard databases, e.g. one for contacts,
       > another for finance type of records, etc.
    Do you have some example or a pointer or so. I don't know even how to

AFAIK you can read data from a recfile and generate org-mode tables
dynamically in at least two ways:

1) Using ob-rec.el (part of recutils)

   #+begin_src rec :data mydata.rec :type milestone :fields ProjectID,Name
     Year == 2014

2) Using babel and sh blocks (I found this example in [1])

   #+begin_src sh :exports results :results output replace :results value table
     recsel -t milestone -e "Year == 2014"  -p 'ProjectID,Name' milestones.rec 
| rec2csv

In both cases evaluating these blocks with C-cC-c must give you a nice
table that then you can export to a report.

The recutils manual is available at the recutils webpage [2].

[2] http://www.gnu.org/software/recutils

reply via email to

[Prev in Thread] Current Thread [Next in Thread]