orgmode and a database

orgmode and a database

[Uwe Brauer]

Hello

I am looking for a sort of database I could use with orgmode. Anybody
has a suggestion? What's about recutils?

thanks

Uwe Brauer 

Re: orgmode and a database

[Ken Mankoff]

On 2016-04-04 at 15:46, Uwe Brauer <oub@mat.ucm.es> wrote:
> I am looking for a sort of database I could use with orgmode. Anybody
> has a suggestion? What's about recutils?

Can you be more specific?

Org tables? They can be joined...

Org supports SQLite http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sqlite.html
http://howardism.org/Technical/Emacs/literate-database.html

And many use Org PROPERTY drawers as a database (for example, the address book support/examples).

  -k.

Re: orgmode and a database

[Charles Millar]

Hi,

On 04/04/2016 03:46 PM, Uwe Brauer wrote:
> Hello
>
> I am looking for a sort of database I could use with orgmode. Anybody
> has a suggestion? What's about recutils?
>
>
>
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.

Have you checked out the two recutils mailing lists? Not very active at 
the moment. I mentioned in those lists that perhaps some sort of capture 
much like org-capture might be useful, but have made no further effort 
in that regards.

I picked up a excellent pointers as to using recutils to create org-mode 
tables from Jose Marchesi's and Eric Shulte's ob-rec.el discussion on 
this list back in 2011. I ultimately export the tables and related text 
to LaTeXpdf docs.

A few months ago I added recutils or "rec" to the Babel:languages, Emacs 
Package section - still haven't provided an example though. (It may have 
been Eric who encouraged me to post my entry to Worg, but at the moment 
I cannot recall for sure.)

Charlie Millar

Re: orgmode and a database

[Uwe Brauer]

>>> "Ken" == Ken Mankoff <mankoff@gmail.com> writes:

    > On 2016-04-04 at 15:46, Uwe Brauer <oub@mat.ucm.es> wrote:
    >> I am looking for a sort of database I could use with orgmode. Anybody
    >> has a suggestion? What's about recutils?

    > Can you be more specific?

Well my first shot would be something like a mediawiki software which is
connected say to a mysql server. I can search wiki, but then most likely
I could move files in a directory and run grep.


So what about some functionally openoffice or filemaker (a commercial
software which runs on Mac or on Windows) provide. You write data in a
table and then can run searches which produce new (smaller tables).


    > Org tables? They can be joined...

Now I don't understand what you mean be joined, linked?

    > Org supports SQLite
    > http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sqlite.html
    > http://howardism.org/Technical/Emacs/literate-database.html

Yeah that looks a bit to hackerish to me.

    > And many use Org PROPERTY drawers as a database (for example, the
    > address book support/examples).

That is maybe more what I need, could that be used in tables?

Uwe 

Re: orgmode and a database

[Uwe Brauer]

   > Hi,
   > On 04/04/2016 03:46 PM, Uwe Brauer wrote:

   > 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. 

   > Have you checked out the two recutils mailing lists? Not very
   > active at the moment. I mentioned in those lists that perhaps some
   > sort of capture much like org-capture might be useful, but have
   > made no further effort in that regards.

   > I picked up a excellent pointers as to using recutils to create
   > org-mode tables from Jose Marchesi's and Eric Shulte's ob-rec.el
   > discussion on this list back in 2011. I ultimately export the tables
   > and related text to LaTeXpdf docs.

Could you provide me a link, please?

Uwe Brauer 

Re: orgmode and a database

[Colin Baxter]

> Hello
>
> I am looking for a sort of database I could use with orgmode. Anybody
> has a suggestion? What's about recutils?
>
> thanks
>
> Uwe Brauer 

I've just installed recutils from source. If you do the same then be
aware that as well as the usual linux packages, you will also need
"check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
its obvious that they would be required, but its certainly not
documented - at least as far as I could discover. Sorry that this was
perhaps off-topic, but it might be useful for others.

Colin.

Re: orgmode and a database

[Charles Millar]

Hi,

On 04/05/2016 06:43 AM, Colin Baxter wrote:
>> Hello
>>
>> I am looking for a sort of database I could use with orgmode. Anybody
>> has a suggestion? What's about recutils?
>>
>> thanks
>>
>> Uwe Brauer
> I've just installed recutils from source. If you do the same then be
> aware that as well as the usual linux packages, you will also need
> "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
> its obvious that they would be required, but its certainly not
> documented - at least as far as I could discover. Sorry that this was
> perhaps off-topic, but it might be useful for others.
>
> Colin.
What flavor or OS are you using? I had a Debian Jessie desktop (recently 
relegated to the junk heap; it was a reclaimed from a 2000 - 2001 
machine which originally came with WindowsXT) and a LMDE2 laptop (still 
in use and which I believe is based on Jessie) both of which came with 
recutils-1.6, so last year  installed 1.7 from source on both. As I 
recall I had no problems. Perhaps I loaded the packages you mentioned at 
earlier time.

Charlie Millar

Re: orgmode and a database

[Russell Adams]

> So what about some functionally openoffice or filemaker (a commercial
> software which runs on Mac or on Windows) provide. You write data in a
> table and then can run searches which produce new (smaller tables).

I've been wishing for a dbase III clone or something fast, Postgres
backed, that I could use in a terminal only for CRUD. I'm sick of
webapps for everything.

I may have to check out recutils.

------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: orgmode and a database

[Jose E. Marchesi]

    > I am looking for a sort of database I could use with orgmode. Anybody
    > has a suggestion? What's about recutils?
    >
    > thanks
    >
    > Uwe Brauer 
    
    I've just installed recutils from source. If you do the same then be
    aware that as well as the usual linux packages, you will also need
    "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
    its obvious that they would be required, but its certainly not
    documented - at least as far as I could discover. Sorry that this was
    perhaps off-topic, but it might be useful for others.
    
These dependencies are documented in the README-dev file at the top
directory of the recutils source distribution.  Excerpt:

Dependencies
------------
There are some third party dependencies needed to build some of the
utilities shipped in this distribution.  The configure script checks
for the needed packages and drives the conditional compilation of the
impacted utitilities.  The dependencies are:
- The testing infrastructure uses the Check library.  At the moment
  the svn version of the library if needed.  The configure script will
  check if you have the right version.  libcheck can be obtained at
  http://sourceforge.net/projects/check/.

The following dependencies are optional.  Missing them will result in
a less capable software:
- The GNU Privacy Guard (gnupg) is required in order to support
  encryption.  The following libraries are required: libgpg-error and
  libgcrypt.  Any recent version of those libraries will work.  gnupg
  can be obtained at http://gnupg.org.
- libcurl is required for supporting remote descriptors.  Any
  recent version must work.  The library can be obtained at
  http://curl.haxx.se/libcurl/.
- The mdbtools are required for building the mdb2rec utility.
  mdbtools can be obtained at http://mdbtools.sourceforge.net.
- The UUID library from Theodore Ts'o is required for the uuid type.
  In Debian-like systems that library is packaged under the name
  uuid-dev and the runtime under the name libuuid1.
- The algol68toc compiler is required for building the Algol68
  bindings.

Re: orgmode and a database

[Colin Baxter]

> Hi,
>
> On 04/05/2016 06:43 AM, Colin Baxter wrote:
>>> Hello
>>>
>>> I am looking for a sort of database I could use with orgmode. Anybody
>>> has a suggestion? What's about recutils?
>>>
>>> thanks
>>>
>>> Uwe Brauer
>> I've just installed recutils from source. If you do the same then be
>> aware that as well as the usual linux packages, you will also need
>> "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
>> its obvious that they would be required, but its certainly not
>> documented - at least as far as I could discover. Sorry that this was
>> perhaps off-topic, but it might be useful for others.
>>
>> Colin.
> What flavor or OS are you using? I had a Debian Jessie desktop
> (recently relegated to the junk heap; it was a reclaimed from a 2000 -
> 2001 machine which originally came with WindowsXT) and a LMDE2 laptop
> (still in use and which I believe is based on Jessie) both of which
> came with recutils-1.6, so last year  installed 1.7 from source on
> both. As I recall I had no problems. Perhaps I loaded the packages you
> mentioned at earlier time.
>
>

Hi Charlie,

recutils-1.7 on Debian 3.2.78-1 i686 GNU/Linux. It installed ok, but
gave warnings on "make test". These disappeared on installing the
packages I mentioned.

Cheers, Colin.

Re: orgmode and a database

[Jose E. Marchesi]

    
       > 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

Re: orgmode and a database

[Colin Baxter]

>     > I am looking for a sort of database I could use with orgmode. Anybody
>     > has a suggestion? What's about recutils?
>     >
>     > thanks
>     >
>     > Uwe Brauer 
>     
>     I've just installed recutils from source. If you do the same then be
>     aware that as well as the usual linux packages, you will also need
>     "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
>     its obvious that they would be required, but its certainly not
>     documented - at least as far as I could discover. Sorry that this was
>     perhaps off-topic, but it might be useful for others.
>     
> These dependencies are documented in the README-dev file at the top
> directory of the recutils source distribution.  Excerpt:
>
> Dependencies
> ------------
> There are some third party dependencies needed to build some of the
> utilities shipped in this distribution.  The configure script checks
> for the needed packages and drives the conditional compilation of the
> impacted utitilities.  The dependencies are:
> - The testing infrastructure uses the Check library.  At the moment
>   the svn version of the library if needed.  The configure script will
>   check if you have the right version.  libcheck can be obtained at
>   http://sourceforge.net/projects/check/.
>
> The following dependencies are optional.  Missing them will result in
> a less capable software:
> - The GNU Privacy Guard (gnupg) is required in order to support
>   encryption.  The following libraries are required: libgpg-error and
>   libgcrypt.  Any recent version of those libraries will work.  gnupg
>   can be obtained at http://gnupg.org.
> - libcurl is required for supporting remote descriptors.  Any
>   recent version must work.  The library can be obtained at
>   http://curl.haxx.se/libcurl/.
> - The mdbtools are required for building the mdb2rec utility.
>   mdbtools can be obtained at http://mdbtools.sourceforge.net.
> - The UUID library from Theodore Ts'o is required for the uuid type.
>   In Debian-like systems that library is packaged under the name
>   uuid-dev and the runtime under the name libuuid1.
> - The algol68toc compiler is required for building the Algol68
>   bindings.

I'm afraid my recutils from http://ftp.gnu.org/gnu/recutils/recutils-1.7.tar.gz had no REDADME.dev. It did have a README, which mentions README.dev but no README.dev.

Re: orgmode and a database

[Colin Baxter]

I'm afraid my recutils from http://ftp.gnu.org/gnu/recutils/recutils-1.7.tar.gz had no REDADME.dev. It did have a README, which mentions README.dev but no README.dev. 

Best wishes,

Colin.

05.04.2016, 13:54, "Jose E. Marchesi" <jemarch@gnu.org>:
>     > I am looking for a sort of database I could use with orgmode. Anybody
>     > has a suggestion? What's about recutils?
>     >
>     > thanks
>     >
>     > Uwe Brauer
>
>     I've just installed recutils from source. If you do the same then be
>     aware that as well as the usual linux packages, you will also need
>     "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
>     its obvious that they would be required, but its certainly not
>     documented - at least as far as I could discover. Sorry that this was
>     perhaps off-topic, but it might be useful for others.
>
> These dependencies are documented in the README-dev file at the top
> directory of the recutils source distribution. Excerpt:
>
> Dependencies
> ------------
> There are some third party dependencies needed to build some of the
> utilities shipped in this distribution. The configure script checks
> for the needed packages and drives the conditional compilation of the
> impacted utitilities. The dependencies are:
> - The testing infrastructure uses the Check library. At the moment
>   the svn version of the library if needed. The configure script will
>   check if you have the right version. libcheck can be obtained at
>   http://sourceforge.net/projects/check/.
>
> The following dependencies are optional. Missing them will result in
> a less capable software:
> - The GNU Privacy Guard (gnupg) is required in order to support
>   encryption. The following libraries are required: libgpg-error and
>   libgcrypt. Any recent version of those libraries will work. gnupg
>   can be obtained at http://gnupg.org.
> - libcurl is required for supporting remote descriptors. Any
>   recent version must work. The library can be obtained at
>   http://curl.haxx.se/libcurl/.
> - The mdbtools are required for building the mdb2rec utility.
>   mdbtools can be obtained at http://mdbtools.sourceforge.net.
> - The UUID library from Theodore Ts'o is required for the uuid type.
>   In Debian-like systems that library is packaged under the name
>   uuid-dev and the runtime under the name libuuid1.
> - The algol68toc compiler is required for building the Algol68
>   bindings.

Re: orgmode and a database

[Charles Millar]

Hi,

On 04/05/2016 09:04 AM, Colin Baxter wrote:
>> Hi,
>>
>> On 04/05/2016 06:43 AM, Colin Baxter wrote:
>>>> Hello
>>>>
>>>> I am looking for a sort of database I could use with orgmode. Anybody
>>>> has a suggestion? What's about recutils?
>>>>
>>>> thanks
>>>>
>>>> Uwe Brauer
>>> I've just installed recutils from source. If you do the same then be
>>> aware that as well as the usual linux packages, you will also need
>>> "check", "uuid-dev" and "bash-builtins" for a successful build. Perhaps
>>> its obvious that they would be required, but its certainly not
>>> documented - at least as far as I could discover. Sorry that this was
>>> perhaps off-topic, but it might be useful for others.
>>>
>>> Colin.
>> What flavor or OS are you using? I had a Debian Jessie desktop
>> (recently relegated to the junk heap; it was a reclaimed from a 2000 -
>> 2001 machine which originally came with WindowsXT) and a LMDE2 laptop
>> (still in use and which I believe is based on Jessie) both of which
>> came with recutils-1.6, so last year  installed 1.7 from source on
>> both. As I recall I had no problems. Perhaps I loaded the packages you
>> mentioned at earlier time.
>>
>>
> Hi Charlie,
>
> recutils-1.7 on Debian 3.2.78-1 i686 GNU/Linux. It installed ok, but
> gave warnings on "make test". These disappeared on installing the
> packages I mentioned.
>
> Cheers, Colin.
>
I forgot!! Very conveniently, i might add. Last fall I discovered that 
although recutils-1.7 was apparently installed correctly, it was not. I 
could not use the readrec bash built-in. So I had to reinstall making 
sure that I downloaded all the other required packages that listed in 
the README-dev which Jose mentions in his recent message to this thread.

Re: orgmode and a database

[Eric S Fraga]

On Tuesday,  5 Apr 2016 at 14:04, Colin Baxter wrote:

[...]

> Hi Charlie,
>
> recutils-1.7 on Debian 3.2.78-1 i686 GNU/Linux. It installed ok, but
> gave warnings on "make test". These disappeared on installing the
> packages I mentioned.

Colin et al.,

All this talk of recutils motivated me to try it again as I do have a
task that would benefit from this, currently managed using org
properties but unwieldy as a result.

However, I cannot get it working in emacs.  There is a (setq) line in
rec-mode that is ill-formed and I cannot navigate through a database.  I
am using

ii  recutils       1.7-1+b1     amd64        text-based databases called recfiles

on Debian testing.

How do others actually create and manage the rec databases in Emacs?

Thanks,
eric

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 25.0.92.1, Org release_8.3.4-668-g809a83

Re: orgmode and a database

[Jose E. Marchesi]

    I'm afraid my recutils from
    http://ftp.gnu.org/gnu/recutils/recutils-1.7.tar.gz had no
    REDADME.dev. It did have a README, which mentions README.dev but no
    README.dev.

Aha, looks like README.dev is not included in the distribution tarball.
Time to fix that :)

Re: orgmode and a database

[Jose E. Marchesi]

    > Hi Charlie,
    >
    > recutils-1.7 on Debian 3.2.78-1 i686 GNU/Linux. It installed ok, but
    > gave warnings on "make test". These disappeared on installing the
    > packages I mentioned.
    
    Colin et al.,
    
    All this talk of recutils motivated me to try it again as I do have a
    task that would benefit from this, currently managed using org
    properties but unwieldy as a result.
    
    However, I cannot get it working in emacs.  There is a (setq) line in
    rec-mode that is ill-formed and I cannot navigate through a database.  I
    am using

You could try to use rec-mode.el from the git version of recutils, as it
contains several fixes since the 1.7 release:

http://git.savannah.gnu.org/cgit/recutils.git/tree/etc/rec-mode.el

Re: orgmode and a database

[Eric S Fraga]

On Tuesday,  5 Apr 2016 at 16:40, Jose E. Marchesi wrote:

[...]

> You could try to use rec-mode.el from the git version of recutils, as it
> contains several fixes since the 1.7 release:
>
> http://git.savannah.gnu.org/cgit/recutils.git/tree/etc/rec-mode.el

Thanks.  I'll give that a shot.

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 25.0.92.1, Org release_8.3.4-668-g809a83

Re: orgmode and a database

[Uwe Brauer]

[-- 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)

Re: orgmode and a database

[Jose E. Marchesi]

    
       > 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.

Sure.  This could be an example of a recfile:

-- mydata.rec --
%rec: milestone

ProjectID: 1
Name: GNU Recutils
Year: 2012

ProjectID: 2
Name: Another
Year: 2014

ProjectID: 3
Name: GNU Emacs
Year: 1985

ProjectID: 4
Name: Foo
Year: 2014
-- end of mydata.rec --

Evaluating this block from an org file (note the 's around 2014 that I
forgot to use in the example above):

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

It produces:

#+RESULTS:
| ProjectID | Name    |
|-----------+---------|
|         2 | Another |
|         4 | Foo     |

Re: orgmode and a database

[Uwe Brauer]

    
    
   >     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.

   > Sure.  This could be an example of a recfile:

Thanks that worked nicely!

Re: orgmode and a database

[Charles Millar]

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

Uwe,

On 04/05/2016 06:32 AM, Uwe Brauer wrote:
>     > Hi,
>     > On 04/04/2016 03:46 PM, Uwe Brauer wrote:
>
>     > 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.
>
>     
A caveat - I am slowly learning lisp - of any kind - and I have not 
programmed in over 45 years (college).

See the attached files - one is a template for entering data into a 
recfile and the other is a sample of how I use some of the data in that 
recfile. I also have a couple of remote-descriptors so that I don't have 
reinvent the wheel for every recfile.

Originally I set up an org capture template and switched modes for 
entries into a refile, but this was not a "good" solution. In the 
recutils list I mentioned org capture and perhaps it could be modified 
to recutils, but I never sent Jose a use case.

> > Have you checked out the two recutils mailing lists? Not very
>     > active at the moment. I mentioned in those lists that perhaps some
>     > sort of capture much like org-capture might be useful, but have
>     > made no further effort in that regards.
>
>     > I picked up a excellent pointers as to using recutils to create
>     > org-mode tables from Jose Marchesi's and Eric Shulte's ob-rec.el
>     > discussion on this list back in 2011. I ultimately export the tables
>     > and related text to LaTeXpdf docs.
>
> Could you provide me a link, please?

Here's the thread on Gmane

http://article.gmane.org/gmane.emacs.orgmode/37697/match=ob+rec+el
> Uwe Brauer
Charlie Millar

[-- Attachment #2: cm-estate-recfile-entries.el --]
[-- Type: text/x-emacs-lisp, Size: 1796 bytes --]


(defun cm-estate-rec-entries (Description File &optional Memo AccountDate AccountAmount Shares AccountSchedule1 AccountSchedule2 EstateTaxSchedule FiduciaryTaxSchedule ProceedsDate ProceedsAmount AccountSchedule3 AccountSchedule4 Beneficiary OtherAccount1 &optional CheckDate CheckNumber CheckAmount)
  (goto-char (point-max))
  (newline)
  (interactive "sDescription:  \nsFile: \nsMemo: \nsAccountDate: \nsAccountAmount: \nsShares: \nsAccountSchedule: \nsAccountSchedule:  \nsEstateTaxSchedule: \nsFiduciaryTaxSchedule: \nsProceedsDate: \nsProceedsAmount: \nsAccountSchedule: \nsAccountSchedule: \nsBeneficiary: \nsOtherAccount: \nsCheckDate:  \nsCheckNumber: \nsCheckAmount: ")
  (insert "Description: " Description) (newline)
  (insert "File: " File) (newline)
  (insert "Memo: " Memo) (newline)
  (insert "AccountDate: " AccountDate) (newline)
  (insert "AccountAmount: " AccountAmount) (newline)
  (insert "Shares: " Shares) (newline)
  (insert "AccountSchedule: " AccountSchedule1) (newline)
  (insert "AccountSchedule: " AccountSchedule2) (newline)
  (insert "EstateTaxSchedule: " EstateTaxSchedule) (newline)
  (insert "FiduciaryTaxSchedule: " FiduciaryTaxSchedule) (newline)
  (insert "ProceedsDate: " ProceedsDate) (newline)
  (insert "Proceeds: " ProceedsAmount) (newline)
  (insert "AccountSchedule: " AccountSchedule3) (newline)
  (insert "AccountSchedule: " AccountSchedule4) (newline)
  (insert "Beneficiary: " Beneficiary) (newline)
  (insert "OtherAccount: " OtherAccount1)
  (if (y-or-n-p "Are those checkbook entries necessary?")
      (progn
	(newline)
	(insert "OtherAccount: Checkbook") (newline)
	(insert "CheckDate: " CheckDate) (newline)
	(insert "CheckNumber: " CheckNumber) (newline)
	(insert "CheckAmount: " CheckAmount) (newline))
    (progn
      (newline))))






[-- Attachment #3: cm-sample-recutil-latex.org --]
[-- Type: text/plain, Size: 1436 bytes --]

Not sure if this will help, but here is a sample set up for one of my documents that usually have 15 - 20 tables which first are called from a recutils and then passed to a source block for the table. (Please note that I use the numprint package, which does not "like" any text in a number only column, so there is a separate line for the initial row. I am still playing wihtthis)

#+Begin_example

Some text here which is followed by a table

#+LATEX:
\label{SCHEDA}
\begin{center}
\textbf{SCHEDULE A\\PRINCIPAL RECEIVED}
\end{center}
\setlength{\extrarowheight}{8pt}
\vspace{-3.0ex}
\ofoot{Schedule A}

#+NAME: SCHEDAP
#+ATTR_LATEX: :mode table :environment longtable :align p{60pt}p{60pt}p{240pt}p{60pt}
|       Date | {{{cmhfill}}} Shares | Description                                              | Inventory {{{cm2space}}} Value |
#+begin_src rec :data foo.rec :type Finance :fields AccountDate,Description,AccountAmount :results silent
 (File = 'bar' && AccountSchedule = 'A')
#+end_src
#+RESULTS: SCHEDAP
#+NAME: SCHEDA
#+HEADER: :eval no
#+begin_src emacs-lisp :var table=SCHEDAP :exports results
  (setq table (cons 'hline table))
  (setq table (append table '(("|Total Schedule A"))))
  (setq table (append table '(("\n#+TBLFM: at>$>=vsum(atI$>..at>>$>);%.2f::"))))
  table
#+end_src
#+ATTR_LATEX: :mode table :environment longtable :align p{60pt}N{6}{3}p{250pt}N{8}{2}
#+RESULTS: SCHEDA

Some  more text here

#+End_example

Re: orgmode and a database

[Charles Millar]

On 04/04/2016 04:27 PM, Charles Millar wrote:
> Hi,
>
> On 04/04/2016 03:46 PM, Uwe Brauer wrote:
>> Hello
>>
>> I am looking for a sort of database I could use with orgmode. Anybody
>> has a suggestion? What's about recutils?
>>
>>
>>
>
> A few months ago I added recutils or "rec" to the Babel:languages, 
> Emacs Package section - still haven't provided an example though. (It 
> may have been Eric who encouraged me to post my entry to Worg, but at 
> the moment I cannot recall for sure.)
>
It was Nick Dokos.

Charlie Millar

Re: orgmode and a database

[Uwe Brauer]

>>> "Jose" == Jose E Marchesi <jemarch@gnu.org> writes:

   >> 1) Using ob-rec.el (part of recutils)
    
   >> #+begin_src rec :data mydata.rec :type milestone :fields ProjectID,Name
   >> Year == 2014
   >> #+end_src
    

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

   > It produces:

   > #+RESULTS:
   > | ProjectID | Name    |
   > |-----------+---------|
   > |         2 | Another |
   > |         4 | Foo     |



BTW is the inverse operation possible:

from an orgtable to one or more fields in a recfile?

Uwe