From mboxrd@z Thu Jan 1 00:00:00 1970 From: Uwe Brauer Subject: Re: orgmode and a database Date: Tue, 05 Apr 2016 16:37:51 +0000 Message-ID: <87zit8t3j4.fsf@mat.ucm.es> References: <87shz1f97s.fsf@mat.ucm.es> <5702CE16.8020704@verizon.net> <871t6kl50k.fsf@mat.ucm.es> <87r3ek8aj7.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:46007) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anTzU-0006AH-Os for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:38:09 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1anTzR-0000aR-U9 for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:38:08 -0400 Received: from plane.gmane.org ([80.91.229.3]:51269) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anTzR-0000a3-Ml for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:38:05 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1anTzN-0008RF-Az for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 18:38:01 +0200 Received: from gilgamesch.quim.ucm.es ([147.96.12.99]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 05 Apr 2016 18:38:01 +0200 Received: from oub by gilgamesch.quim.ucm.es with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 05 Apr 2016 18:38:01 +0200 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 --=-=-= Content-Type: text/plain >>> "Jose" == Jose E Marchesi writes: >> 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 Thanks. Could you please send me the mydate file otherwise that will not work (and I don't know enough recfiles syntax to cook up my own. > 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 That is odd, since I obtain an error which I attach: of course I have sh installed on my system Which sh /bin/sh > The recutils manual is available at the recutils webpage [2]. thanks Uwe > [1] https://www.reddit.com/r/emacs/comments/1u52eu/can_people_share_their_orgmode_workflows/ > [2] http://www.gnu.org/software/recutils --=-=-= Content-Type: text/plain Content-Disposition: attachment; filename=rec-bug1.txt Debugger entered--Lisp error: (error "No org-babel-execute function for sh!") signal(error ("No org-babel-execute function for sh!")) error("No org-babel-execute function for %s!" "sh") org-babel-execute-src-block(nil) org-babel-execute-src-block-maybe() org-babel-execute-maybe() org-babel-execute-safely-maybe() run-hook-with-args-until-success(org-babel-execute-safely-maybe) org-ctrl-c-ctrl-c(nil) funcall-interactively(org-ctrl-c-ctrl-c nil) call-interactively(org-ctrl-c-ctrl-c nil nil) command-execute(org-ctrl-c-ctrl-c) --=-=-=--