Re: [GNC-dev] Data Model Schema

2022-08-21 Thread John Ralls
> On Aug 21, 2022, at 11:22 AM, Michael or Penny Novack > wrote: > > On 8/21/2022 11:42 AM, john wrote: >> >> >>> On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack >>> wrote: >>> >>> I do not understand what you could mean by going back and forth from >>> Quickbools to gnucash (or an

Re: [GNC-dev] Data Model Schema

2022-08-21 Thread Michael or Penny Novack
On 8/21/2022 11:42 AM, john wrote: On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack wrote: I do not understand what you could mean by going back and forth from Quickbools to gnucash (or any other double entry bookkeeping software) as Quickbooks is not double entry. Michael, you're c

Re: [GNC-dev] Data Model Schema

2022-08-21 Thread john
> On Aug 21, 2022, at 7:51 AM, Michael or Penny Novack > wrote: > > I do not understand what you could mean by going back and forth from > Quickbools to gnucash (or any other double entry bookkeeping software) as > Quickbooks is not double entry. Michael, you're confusing Quicken that isn'

Re: [GNC-dev] Data Model Schema

2022-08-21 Thread Michael or Penny Novack
On 8/20/2022 3:06 PM, Scott Morgan wrote: Hi John, Well, I did some work building an open source Java Accounting Model ( adligo.org) a few times of the past two decades. Now I find my self using QuickBooks online, so I have been looking for some collaborators and gnucash seems like the most

Re: [GNC-dev] Data Model Schema

2022-08-20 Thread Scott Morgan
Hi John, Well, I did some work building an open source Java Accounting Model ( adligo.org) a few times of the past two decades. Now I find my self using QuickBooks online, so I have been looking for some collaborators and gnucash seems like the most successful project out there. The enriched

Re: [GNC-dev] Data Model Schema

2022-08-20 Thread john
Scott, No, accounting software isn't a fancy spreadsheet. The math part is a lot simpler, but accounting is all about rules. The rules part is harder. That's not to say that you can't use a spreadsheet to do your accounting, lots of people do, but a relational database approach is a much better

Re: [GNC-dev] Data Model Schema

2022-08-20 Thread john
The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's an attached ERD, but note that it shows secondary keys and auxiliary tables that indicate how GnuCash treats the data once it's loaded. The actual schema defines only a few secondary keys and the data represented in the aux