From mboxrd@z Thu Jan 1 00:00:00 1970 From: jemarch@gnu.org (Jose E. Marchesi) Subject: Re: orgmode and a database Date: Tue, 05 Apr 2016 15:12:12 +0200 Message-ID: <87r3ek8aj7.fsf@gnu.org> References: <87shz1f97s.fsf@mat.ucm.es> <5702CE16.8020704@verizon.net> <871t6kl50k.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:57142) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anQec-0006IW-SS for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 09:04:26 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1anQeW-0002YF-U1 for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 09:04:22 -0400 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:47576) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anQeW-0002Y9-Rb for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 09:04:16 -0400 Received: from ukc1-proxy-mwg07-o.oracle.com ([141.143.212.232]:46079 helo=termi.gnu.org) by fencepost.gnu.org with esmtpsa (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1anQeW-0006K1-83 for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 09:04:16 -0400 In-Reply-To: <871t6kl50k.fsf@mat.ucm.es> (Uwe Brauer's message of "Tue, 05 Apr 2016 10:32:59 +0000") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org > 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 start. 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 #+end_src 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 #+end_src 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]. [1] https://www.reddit.com/r/emacs/comments/1u52eu/can_people_share_their_orgmode_workflows/ [2] http://www.gnu.org/software/recutils