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.