[GNC] Database schema documentation

Thu Jul 9 22:29:45 EDT 2020

has anyone created a data dictionary of the database that is created if you save your gnucash data in a DB format. It doesn't matter the database, it seems to create same table structures in SQLite and PostgreSQL that I checked.

what I'm looking for is, definitions on the data that the tables hold and how you can connect those tables together on a sql statement. foreign keys to those tables would also be helpful.
I'm hoping that I can write selects to look for transactions and/or create reports out of my data.

thank you

________________________________
From: gnucash-user <gnucash-user-bounces+tomhatz=hotmail.com at gnucash.org> on behalf of gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>
Sent: Thursday, July 9, 2020 12:00 PM
To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: gnucash-user Digest, Vol 208, Issue 36

Send gnucash-user mailing list submissions to
        gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
        gnucash-user-request at gnucash.org

You can reach the person managing the list at
        gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

   1. Re:  GnuCash list (Adrien Monteleone)
   2. Re:  Gnucash - user (flywire)
   3.  Reconcile also opens Interest Payment box? (lj)
   4. Re:  Reconcile also opens Interest Payment box? (jean laroche)
   5. Re:  Gnucash - user (Liz)
   6.  Unable to compile gnucash-4.0 on one computer
      (Md. Aminul Islam Khan)

----------------------------------------------------------------------

Message: 1
Date: Wed, 8 Jul 2020 15:45:31 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] GnuCash list
Message-ID: <205F824D-2AB5-4979-83D5-14650BCB9406 at lusfiber.net>
Content-Type: text/plain;       charset=utf-8

> On Jul 8, 2020 w28d190, at 7:02 AM, Bruce Irving via gnucash-user <gnucash-user at gnucash.org> wrote:
>
> From: Robert Heller <heller at deepsoft.com>
>
> Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL,
> Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they would
> be reading postings in an actual webforum.  The idea of an "E-Mail List" as
> something separate from a forum is actually foreign to these people.  And yes
> many people would prefer a web-forum (not me -- I hate web forums and avoid
> them whenever possible).
>
> Thank you, Robert.  Yes, it is foreign to me.
> Unfortunately, I do not save the messages.  I needed to reinstall my OS and all my applications.  They do offer gnucash version 1:2.6.19-1.  They also offer flatpak which is currently 4.0-3.
> After reading the difficulties, I was going to wait until it smoothed out before installing but, in this case, had no choice but to upgrade.  Now, I have a couple of nits to pick:
>
> I started bookkeeping BC (before computer) so I'm familiar with debits and credits.  Unfortunately. I couldn't find where to use formal accounting rules.

Preferences > Accounts > Labels > Use Formal Accounting Labels

The ?rules? of GnuCash are double-entry.

You still have to know how to structure your transactions though. It won?t do that for you. (the ?business features? can handle this somewhat)

>  I recently made an entry, (I work in the general ledger.) and, as usual double checked it in the account register where it looked wrong.  So I corrected it and looked at it in the other account where it again looked wrong.  After 3 corrections, I finally realized the the accounts were different from what I was used to.

What were you seeing that you think looked wrong and what are you used to?

> I had heard several express difficulty with column widths.

The Help manual covers this. It is a matter of dragging the header separator as needed. For the moment, this has to be done per account, though Invoices/Bills can now (as of 4.0) have a layout ?remembered?.

> I usually work with two or more windows open at once.  But now, GNC requires me to use full screen.

No it does not. I don?t use it full screen. And while opening two instances with two different books side-by-side isn?t ?usual?, it can be done. Each OS may be a bit different in how you accomplish it though. You can also specify Preferences > Register Defaults > Other Defaults > Register opens in a new window.

> In both of those cases, I had read there was a solution.  With a mailing list, I can't browse through the previous posts to find the answers to my issues.

There is an archive of the list here: https://lists.gnucash.org/pipermail/gnucash-user/

The search feature is currently broken, but you can use ?site:lists.gnucash.org search terms? in your favorite search engine to search only the mailing list server for ?search terms?

Regards,
Adrien

------------------------------

Message: 2
Date: Thu, 9 Jul 2020 09:11:58 +1000
From: flywire <flywire0 at gmail.com>
To: Gnucash Users <gnucash-user at gnucash.org>
Cc: Derek Atkins <derek at ihtfp.com>
Subject: Re: [GNC] Gnucash - user
Message-ID:
        <CAOthWL11SeXRO-Co+uXQiLxnOAwTaK33f=ar0p28_0Tgy2_png at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

I understand it is a word-picture.

The wheel is a big technological improvement to reduce the work of moving a
sled, a flat device for moving an irregularly shaped object across the
ground.
btw, almost no snow in Australia.

>> mailman3 would put wheels on the sled.
> >
> >I must admit I don't know exactly what you mean by this.  :-)
>

------------------------------

Message: 3
Date: Wed, 8 Jul 2020 17:54:47 -0400
From: lj <lj618 at pobox.com>
To: gnucash-user at lists.gnucash.org
Subject: [GNC] Reconcile also opens Interest Payment box?
Message-ID: <re5fbf$d4n$1 at ciao.gmane.io>
Content-Type: text/plain; charset=UTF-8; format=flowed

Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)

For just one of my accounts, the following odd thing started happening this
month. I open the register and click Reconcile.  The expected Reconcile
Information dialog box opens, but on top of that I get an Interest Payment
box. Why would this pop up over Reconcile? Why only for one account? It
started this month. What did I do to cause this?

------------------------------

Message: 4
Date: Wed, 8 Jul 2020 16:59:41 -0700
From: jean laroche <ripngo at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Reconcile also opens Interest Payment box?
Message-ID: <aa23a73d-11d6-8bfb-1e01-8f54d2a111dd at gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed

There's a Preference for that under Register, Reconciling
Jean

On 7/8/2020 2:54 PM, lj wrote:
> Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)
>
> For just one of my accounts, the following odd thing started happening
> this month. I open the register and click Reconcile.? The expected
> Reconcile Information dialog box opens, but on top of that I get an
> Interest Payment box. Why would this pop up over Reconcile? Why only for
> one account? It started this month. What did I do to cause this?
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

------------------------------

Message: 5
Date: Thu, 9 Jul 2020 21:49:25 +1000
From: Liz <edodd at billiau.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Gnucash - user
Message-ID: <20200709214925.6731603b at billiau.net>
Content-Type: text/plain; charset=US-ASCII

On Tue, 7 Jul 2020 15:03:20 +0100
david whiting <dw at davidwhiting.me.uk> wrote:

> If you do a google search for "gnucash forum" the top two hits are
> results from nabble. If you click on either one of these you'll see
> the login/register link top left that sign you up to nabble.
>
> Perhaps this is how some people think that this is the correct way to
> sign up. They are doing something that is normal these days, a google
> search for what they want to find (gnucash forum) and aren't aware of
> the subtle difference between using nabble and signing up to the
> mailing list. There's a very good chance they won't get close to the
> wiki so perhaps it will make no difference how clearly it is
> described in the wiki.
>
> See attached.
>
> David

I use DDG, and just checked, Gnucash.org is the first entry returned.

I s'pose Google would like us to buy ads to get to the top of their
search??

Liz

------------------------------

Message: 6
Date: Thu, 9 Jul 2020 20:10:38 +0600
From: "Md. Aminul Islam Khan" <aikhanlab at gmail.com>
To: Gnucash user list <gnucash-user at gnucash.org>
Subject: [GNC] Unable to compile gnucash-4.0 on one computer
Message-ID:
        <CAGzip+wMABHaSiLqa6NQwNBWiQwA5h=5tbKayrX-ZSZbY9aTVw at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Hello all,
Using Ubuntu 18.04 on two computers, was using gnucash-3.9 on both.
Directories are identical. I could compile gnucash-4.0 on one computer.
Same commands used in both computers:
1. cd build-gnucash-3.9, sudo ninja uninstall, sudo ninja clean
2. Downloaded the source file, gnucash-4.0, extracted.
3. mkdir build-gnucash-4.0, cd build-gnucash-4.0
4. cmake -GNinja -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash-4.0
5. sudo ninja
The other computer results in:------------------------------
[741/894] Generating
../../../../lib/x86_64-linux-gnu/guile/2.0/site-ccache/tests/test-qif-parse.go
wrote
`/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/x86_64-linux-gnu/guile/2.0/site-ccache/tests/test-qif-parse.go'
[742/894] Linking CXX executable bin/gnucash
FAILED: bin/gnucash
: && /usr/bin/c++  -Wno-error=deprecated-declarations  -Werror -Wall
-Wmissing-declarations -Wno-unused -Wno-error=parentheses
gnucash/CMakeFiles/gnucash.dir/gnucash.cpp.o
gnucash/CMakeFiles/gnucash.dir/gnucash-commands.cpp.o
gnucash/CMakeFiles/gnucash.dir/gnucash-core-app.cpp.o
gnucash/CMakeFiles/gnucash.dir/gnucash-gresources.c.o  -o bin/gnucash
 -Wl,-rpath,/home/aikhan/Applications_src_build/build-gnucash-4.0/lib:/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/gnucash:
lib/libgnc-module.so lib/gnucash/libgnc-qif-import.so
lib/gnucash/libgnc-csv-import.so lib/gnucash/libgnc-csv-export.so
lib/gnucash/libgnc-log-replay.so lib/gnucash/libgnc-bi-import.so
lib/gnucash/libgnc-customer-import.so -lguile-2.0 -lgc -lglib-2.0
/usr/lib/x86_64-linux-gnu/libboost_date_time.so
/usr/lib/x86_64-linux-gnu/libboost_regex.so
/usr/lib/x86_64-linux-gnu/libboost_locale.so
/usr/lib/x86_64-linux-gnu/libboost_filesystem.so
/usr/lib/x86_64-linux-gnu/libboost_system.so
/usr/lib/x86_64-linux-gnu/libboost_program_options.so
lib/gnucash/libgnc-generic-import.so lib/libgnc-gnome.so
lib/gnucash/libgnc-ledger-core.so lib/gnucash/libgnc-report.so
/usr/lib/x86_64-linux-gnu/libboost_locale.so
/usr/lib/x86_64-linux-gnu/libboost_filesystem.so
/usr/lib/x86_64-linux-gnu/libboost_system.so
/usr/lib/x86_64-linux-gnu/libboost_program_options.so
lib/gnucash/libgnc-register-gnome.so lib/gnucash/libgnc-register-core.so
lib/gnucash/libgnc-gnome-search.so lib/libgnc-html.so
/usr/lib/x86_64-linux-gnu/libwebkit2gtk-4.0.so /usr/lib/x86_64-linux-gnu/
libsoup-2.4.so /usr/lib/x86_64-linux-gnu/libjavascriptcoregtk-4.0.so
lib/gnucash/libgnc-gnome-utils.so /usr/lib/x86_64-linux-gnu/libgtk-3.so
/usr/lib/x86_64-linux-gnu/libgdk-3.so /usr/lib/x86_64-linux-gnu/
libpangocairo-1.0.so /usr/lib/x86_64-linux-gnu/libpango-1.0.so
/usr/lib/x86_64-linux-gnu/libatk-1.0.so
/usr/lib/x86_64-linux-gnu/libcairo-gobject.so
/usr/lib/x86_64-linux-gnu/libcairo.so /usr/lib/x86_64-linux-gnu/
libgdk_pixbuf-2.0.so /usr/lib/x86_64-linux-gnu/libgio-2.0.so
/usr/lib/x86_64-linux-gnu/libgobject-2.0.so /usr/lib/x86_64-linux-gnu/
libglib-2.0.so lib/libgnc-backend-xml-utils.so -lz -ldl -lsecret-1
lib/libgnc-app-utils.so lib/libgnucash-guile.so lib/libgnc-locale-tax.so
-lguile-2.0 -lgc -lgio-2.0 -lxslt -lxml2 lib/libgnc-engine.so
/usr/lib/x86_64-linux-gnu/libboost_date_time.so
/usr/lib/x86_64-linux-gnu/libboost_regex.so -lgobject-2.0 -licui18n -licuuc
-licudata -Wl,--export-dynamic -lgmodule-2.0 -pthread
lib/libgnc-core-utils.so -lglib-2.0 && :
lib/gnucash/libgnc-csv-import.so: undefined reference to
`boost::re_detail_106501::icu_regex_traits_implementation::do_transform(int
const*, int const*, icu_65::Collator const*) const'
collect2: error: ld returned 1 exit status
[743/894] Generating
../../lib/x86_64-linux-gnu/guile/2.0/site-ccache/gnucash/report/trep-engine.go
wrote
`/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/x86_64-linux-gnu/guile/2.0/site-ccache/gnucash/report/trep-engine.go'
ninja: build stopped: subcommand failed.
-----------------------------------------------------
Help please.
Regards,
aikhan

------------------------------

Subject: Digest Footer

_______________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

------------------------------

End of gnucash-user Digest, Vol 208, Issue 36
*********************************************