Re: [GNC] Database schema documentation
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 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 on > behalf of gnucash-user-requ...@gnucash.org > Sent: Thursday, July 9, 2020 12:00 PM > To: 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 > To: Gnucash Users > 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 >> wrote: >> >> From: Robert Heller >> >> 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
[GNC] Database schema documentation
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 on behalf of gnucash-user-requ...@gnucash.org Sent: Thursday, July 9, 2020 12:00 PM To: 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 To: Gnucash Users 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 > wrote: > > From: Robert Heller > > 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 To: Gnucash Users Cc: Derek Atkins
