Re: orgmode and a database

[Uwe Brauer <oub@mat.ucm.es>]

[-- Attachment #1: Type: text/plain, Size: 1468 bytes --]

>>> "Jose" == Jose E Marchesi <jemarch@gnu.org> 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



[-- Attachment #2: rec-bug1.txt --]
[-- Type: text/plain, Size: 550 bytes --]

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)