https://wiki.gnucash.org/wiki/SQL
There's a linked ERD that also shows how the various key-value parameters (also called slots) relate to the data stored in tables. Regards, John Ralls > On Jul 9, 2020, at 7:29 PM, Tom Hatzigeorgiou <tomh...@hotmail.com> wrote: > > 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....@gnucash.org> on > behalf of gnucash-user-requ...@gnucash.org <gnucash-user-requ...@gnucash.org> > Sent: Thursday, July 9, 2020 12:00 PM > To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Subject: gnucash-user Digest, Vol 208, Issue 36 > > Send gnucash-user mailing list submissions to > gnucash-user@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-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@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.montele...@lusfiber.net> > To: Gnucash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash list > Message-ID: <205f824d-2ab5-4979-83d5-14650bcb9...@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@gnucash.org> wrote: >> >> From: Robert Heller <hel...@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 <flywi...@gmail.com> > To: Gnucash Users <gnucash-user@gnucash.org> > Cc: Derek Atkins <de...@ihtfp.com> > Subject: Re: [GNC] Gnucash - user > Message-ID: > <CAOthWL11SeXRO-Co+uXQiLxnOAwTaK33f=ar0p28_0tgy2_...@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 <lj...@pobox.com> > To: gnucash-u...@lists.gnucash.org > Subject: [GNC] Reconcile also opens Interest Payment box? > Message-ID: <re5fbf$d4n$1...@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 <rip...@gmail.com> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Reconcile also opens Interest Payment box? > Message-ID: <aa23a73d-11d6-8bfb-1e01-8f54d2a11...@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@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 <ed...@billiau.net> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Gnucash - user > Message-ID: <20200709214925.67316...@billiau.net> > Content-Type: text/plain; charset=US-ASCII > > On Tue, 7 Jul 2020 15:03:20 +0100 > david whiting <d...@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" <aikhan...@gmail.com> > To: Gnucash user list <gnucash-user@gnucash.org> > Subject: [GNC] Unable to compile gnucash-4.0 on one computer > Message-ID: > <CAGzip+wMABHaSiLqa6NQwNBWiQwA5h=5tbkayrx-zszby9a...@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@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 > ********************************************* > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. _______________________________________________ gnucash-user mailing list gnucash-user@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.