[GNC] gnucash-user Digest, Vol 233, Issue 27
Glenn Fowler
gfowler1 at outlook.com
Mon Aug 8 20:47:11 EDT 2022
I'm assuming you saw the software license for GnuCash which is licensed
under the GNU GPL license. A lot of software licenses are designed to
restrict your freedom with what you can do with the software. GNU promotes
software freedom so you are free to run the program how you wish, free to
distribute it, free to make changes, study it, etc.
More info: https://www.gnu.org/philosophy/free-sw.html
On Mon, Aug 8, 2022 at 8:06 PM David Carlson <david.carlson.417 at gmail.com>
wrote:
> You need a license to go fishing, a different license to drive a car. We
> don't know what you are reading.
>
> On Mon, Aug 8, 2022, 7:01 PM James Baxter via gnucash-user <
> gnucash-user at gnucash.org> wrote:
>
> > I am reading something about a license. I read most of it. As I don't
> > understand it. What is it all about.
> > ThanksJames Baxter Kangaroo52 at yahoo.com
> >
> > Sent from Yahoo Mail on Android
> >
> > On Mon, Aug 8, 2022 at 6:54 PM, gnucash-user-request at gnucash.org<
> > gnucash-user-request at gnucash.org> wrote: 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: gncJobNextID in gncJob.c not in gncJob.h (Robert Simmons)
> > 2. Re: gncJobNextID in gncJob.c not in gncJob.h (Robert Simmons)
> > 3. Re: gncJobNextID in gncJob.c not in gncJob.h (Derek Atkins)
> > 4. Re: Request for two new features in GnuCash (R. Victor Klassen)
> > 5. Re: Request for two new features in GnuCash (Adrien Monteleone)
> > 6. Re: gncJobNextID in gncJob.c not in gncJob.h (Robert Simmons)
> > 7. Re: gncJobNextID in gncJob.c not in gncJob.h (Derek Atkins)
> > 8. Re: gncJobNextID in gncJob.c not in gncJob.h (R. Victor Klassen)
> > 9. Re: gnucash-user Digest, Vol 233, Issue 22
> > (davidcousens49 at gmail.com)
> > 10. Incrementing Counters Saga Continues (Robert Simmons)
> > 11. How to Return a GDate? (Robert Simmons)
> > 12. Re: gncJobNextID in gncJob.c not in gncJob.h (john)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Mon, 8 Aug 2022 15:13:12 -0400
> > From: Robert Simmons <rsimmons0 at gmail.com>
> > To: Mailing List Gnucash <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID:
> > <CA+QLa9DaXjgT2e71ZHpJh8NBc-1c6VwmxfsPE08-+8cpqPJtpQ at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > > we should consider changing the license to GPL-Affero to preclude
> someone
> > using GnuCash in a non-Free software-as-a-service scheme
> >
> > That is a consideration. When I hit the point of needing to write quite a
> > lot of code to get GnuCash to do exactly what I want, I looked into other
> > projects. I took a look at Akaunting which seems to solve the API
> > issues I'm having. The problem with that one is the install process is a
> > bit annoying. I noticed that they use GPL 3, not AGPL too which is
> > interesting.
> >
> > https://github.com/akaunting/akaunting/blob/master/LICENSE.txt
> >
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Mon, 8 Aug 2022 15:21:42 -0400
> > From: Robert Simmons <rsimmons0 at gmail.com>
> > To: Mailing List Gnucash <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID:
> > <CA+QLa9CRfX9AH9jfEkNr9+_XSQ3+yn7TYY-t=37HmYJJ+G-euw at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > > Accounting systems primarily perform the same operation on large
> numbers
> > of data elements.
> >
> > I wish I had time to devote to this. I use graph databases in many of the
> > other systems that I develop. This would be a great pivot point on which
> to
> > create a new open source project and see which paradigm really is better.
> > But really I need to get my data organized and then handed off to an
> > accountant (so I can get back to working on my real work).
> >
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Mon, 8 Aug 2022 15:54:36 -0400
> > From: "Derek Atkins" <derek at ihtfp.com>
> > To: "Robert Simmons" <rsimmons0 at gmail.com>
> > Cc: "Mailing List Gnucash" <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID:
> > <f6bd4b07da93a2c3777756ae08213dfe.squirrel at mail2.ihtfp.org>
> > Content-Type: text/plain;charset=utf-8
> >
> >
> > On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote:
> > >> Accounting systems primarily perform the same operation on large
> numbers
> > > of data elements.
> > >
> > > I wish I had time to devote to this. I use graph databases in many of
> the
> > > other systems that I develop. This would be a great pivot point on
> which
> > > to
> > > create a new open source project and see which paradigm really is
> better.
> > > But really I need to get my data organized and then handed off to an
> > > accountant (so I can get back to working on my real work).
> >
> > My GnuCash database, which has data going back to at least 2007, only
> > contains 26781 transactions, with 59582 splits (at least 2 per
> > transaction), over a total of 564 "accounts".
> >
> > Even if you increase by a factor of 10, I doubt you're going to see any
> > significant performance differences between databases of similar nominal
> > performance.
> >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > --
> > Derek Atkins 617-623-3745
> > derek at ihtfp.com www.ihtfp.com
> > Computer and Internet Security Consultant
> >
> >
> >
> > ------------------------------
> >
> > Message: 4
> > Date: Mon, 8 Aug 2022 16:07:18 -0400
> > From: "R. Victor Klassen" <rvklassen at gmail.com>
> > To: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> > Cc: gnucash-user at lists.gnucash.org
> > Subject: Re: [GNC] Request for two new features in GnuCash
> > Message-ID: <7F863C20-1268-4351-8DCD-D41768A16493 at gmail.com>
> > Content-Type: text/plain; charset=utf-8
> >
> > Actually you can edit the suggested payment amount, and only ?process? a
> > partial payment. Then you can pay again, using Process Payment, and pay
> > with a different account for the second payment.
> >
> > > On Aug 8, 2022, at 11:40 AM, Adrien Monteleone <
> > adrien.monteleone at lusfiber.net> wrote:
> > >
> > > I agree, this is already possible, but *not* using the 'Process
> Payment'
> > feature as it is currently implemented. (that is, if one is paying on a
> > Vendor invoice.)
> > >
> > > To accomplish this, you have to enter the payment with multiple source
> > splits as Frank and others have noted, and AP as the debit split, then
> you
> > have to 'assign as payment' on the AP split using the right-click context
> > menu. (you might have to commit the transaction first, I don't recall if
> it
> > works before commit.)
> > >
> > > This will then let you assign the multi-source payment to an Invoice.
> > >
> > > I see the feature request as changing the Process Payment dialog to
> > support multiple sources. (A request I've seen here before)
> > >
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 8/6/22 11:19 PM, Frank H. Ellenberger wrote:
> > >> Am 07.08.22 um 03:04 schrieb Eric Hammond:
> > >>> The second is the ability to pay bills from more than one source.
> > Example I purchase an oscilloscope and pay for it with a cash incentive
> > from the company and a bank transfer for the rest. My solution at the
> > present is not pretty, nor helpful if I look at it next year.
> > >> Then it's time to claim your easter egg ;-):
> > >> Edit->Peeferences->Register Defaults,
> > >> select Default Style: "Auto-Split ledger" or "Transaction Journal"
> > >> More details in
> > >>
> >
> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
> > >> Then you can easily enter the differnt amounts.
> > >
> > >
> > > _______________________________________________
> > > 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
> > > -----
> > > 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: Mon, 8 Aug 2022 15:29:22 -0500
> > From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> > To: gnucash-user at lists.gnucash.org
> > Subject: Re: [GNC] Request for two new features in GnuCash
> > Message-ID: <tcrrn2$ups$5 at ciao.gmane.io>
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> >
> > That's just another workaround though. It creates multiple transactions
> > when in the real world, there was only one event.
> >
> > The Process Payment feature doesn't really 'support' the desired
> > function, but can still be used to accomplish the the task.
> >
> > I'm personally comfortable using the 'assign payment' function, but I
> > understand why others may prefer or expect the Process Payment window to
> > facilitate this in one go.
> >
> > It isn't an entirely unreasonable request, and it was presented as just
> > that, a request.
> >
> > Regards,
> > Adrien
> >
> > On 8/8/22 3:07 PM, R. Victor Klassen wrote:
> > > Actually you can edit the suggested payment amount, and only ?process?
> a
> > partial payment. Then you can pay again, using Process Payment, and pay
> > with a different account for the second payment.
> >
> >
> >
> >
> > ------------------------------
> >
> > Message: 6
> > Date: Mon, 8 Aug 2022 16:33:10 -0400
> > From: Robert Simmons <rsimmons0 at gmail.com>
> > To: Mailing List Gnucash <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID:
> > <CA+QLa9CArLvUz3=5b1N4aesoSpPM+bZ7MHNXQwDruCUpNFcXrw at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > That makes sense. So, performance would not be an argument for SQL and
> > against a graph database.
> >
> >
> > ------------------------------
> >
> > Message: 7
> > Date: Mon, 8 Aug 2022 17:13:04 -0400
> > From: "Derek Atkins" <derek at ihtfp.com>
> > To: "Robert Simmons" <rsimmons0 at gmail.com>
> > Cc: "Mailing List Gnucash" <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID:
> > <6011f593f0fa7d8b2fdcb6cb1b363545.squirrel at mail2.ihtfp.org>
> > Content-Type: text/plain;charset=utf-8
> >
> >
> > On Mon, August 8, 2022 4:33 pm, Robert Simmons wrote:
> > > That makes sense. So, performance would not be an argument for SQL and
> > > against a graph database.
> >
> > Nor would it be an argument for graph and against SQL. But transactional
> > data is so structured that SQL really does make sense.
> >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> >
> > --
> > Derek Atkins 617-623-3745
> > derek at ihtfp.com www.ihtfp.com
> > Computer and Internet Security Consultant
> >
> >
> >
> > ------------------------------
> >
> > Message: 8
> > Date: Mon, 8 Aug 2022 17:43:13 -0400
> > From: "R. Victor Klassen" <rvklassen at gmail.com>
> > To: Derek Atkins <derek at ihtfp.com>
> > Cc: Robert Simmons <rsimmons0 at gmail.com>, Mailing List Gnucash
> > <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID: <D8A408CC-6058-4265-946A-801BE9AE1DF1 at gmail.com>
> > Content-Type: text/plain; charset=utf-8
> >
> > Just out of curiosity, how does one determine those numbers? An SQL
> > query? grep <pattern> | wc on the xml? Some feature of gnuCash I?ve
> never
> > discovered?
> >
> > > On Aug 8, 2022, at 3:54 PM, Derek Atkins <derek at ihtfp.com> wrote:
> > >
> > >
> > > On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote:
> > >>> Accounting systems primarily perform the same operation on large
> > numbers
> > >> of data elements.
> > >>
> > >> I wish I had time to devote to this. I use graph databases in many of
> > the
> > >> other systems that I develop. This would be a great pivot point on
> which
> > >> to
> > >> create a new open source project and see which paradigm really is
> > better.
> > >> But really I need to get my data organized and then handed off to an
> > >> accountant (so I can get back to working on my real work).
> > >
> > > My GnuCash database, which has data going back to at least 2007, only
> > > contains 26781 transactions, with 59582 splits (at least 2 per
> > > transaction), over a total of 564 "accounts".
> > >
> > > Even if you increase by a factor of 10, I doubt you're going to see any
> > > significant performance differences between databases of similar
> nominal
> > > performance.
> > >
> > >> Please remember to CC this list on all your replies.
> > >> You can do this by using Reply-To-List or Reply-All.
> > >
> > > -derek
> > >
> > > --
> > > Derek Atkins 617-623-3745
> > > derek at ihtfp.com www.ihtfp.com
> > > Computer and Internet Security Consultant
> > >
> > > _______________________________________________
> > > 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
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> >
> >
> > ------------------------------
> >
> > Message: 9
> > Date: Tue, 09 Aug 2022 07:50:48 +1000
> > From: davidcousens49 at gmail.com
> > To: gnucash-user at gnucash.org
> > Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 22
> > Message-ID: <44e48296284e1d0e3a819c69aa012c3aecb6e95b.camel at gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > James,
> >
> > If you are not seeing the transactions you have already entered and the
> > accounts in the account tab it is possible that you have not saved the
> > datafile. To do this use the File-Save As menu item immediately after
> > starting GnuCash up. It will then automatically open the same file next
> > time you startup. You are usually prompted to save the data file when a
> new
> > file is opened however I have had the prompt dialogue get lots behind
> other
> > windows on Linux Mint.
> > It is best if you create a directory in your home directory for the
> > GnuCash data
> > file and then save it with a suitable filename in that directory. Gnucash
> > creates backup and log files each time it is run in the same directory as
> > the
> > data files is located and it is much neater to have all of these in a
> > single
> > directory and it makes backup of your files simpler. There are also
> > preferences
> > for autosaving the file periodically which AFAIK is set at ~20min by
> > default. It
> > is best to exit by the File->Quit (File ->Close only closes the account
> > register which is open) menu item to ensure the data you have entered is
> > saved,
> > although recent changes ensure closing the window by other means will
> also
> > force
> > a data save.
> >
> > David Cousens
> >
> > On Mon, 2022-08-08 at 19:11 +0000, James Baxter via gnucash-user wrote:
> > > David.Thanks for the email. I am not shore about data file. I did get a
> > > transfee going. But I should know next month if it works.
> > > ThanksJames Baxter Kangaroo52 at yahoo.com
> > >
> > > Sent from Yahoo Mail on Android
> > >
> > > On Mon, Aug 8, 2022 at 2:16 PM, David Carlson<
> > david.carlson.417 at gmail.com>
> > > wrote: James,Have you been able to create a test data file and enter a
> > few
> > > transactions modelled on the information in the help manual?
> > >
> > > On Mon, Aug 8, 2022 at 10:01 AM Fred Bone <Fred at mandfb.me.uk> wrote:
> > >
> > > On 08 August 2022 at 13:54, James Baxter said:
> > >
> > > > I am looking for something that I may have already. I have had Linux
> > Mint
> > > > loaded on this laptop for about a month. also have been playing with
> > > > Gnucash about 3 weeks. still getting us to this, As I find it very
> > nice
> > > > program.
> > > > As i dont know if I have a problem with the two of them, I don't
> know.
> > So
> > > > if anybody know if Gnucash will bring down the items it needs to work
> > > > with. I am looking to do a schooling on Linux, go from there.
> > thanksJames
> > > > Baxterkangaroo52 at yahoo.com
> > >
> > > Kindly pay attention to:
> > >
> > > > When replying, please edit your Subject line so it is more specific
> > > > than "Re: Contents of gnucash-user digest..."
> > >
> > > and please trim your posts.
> > >
> > > _______________________________________________
> > > 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
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> > >
> > >
> >
> >
> >
> > ------------------------------
> >
> > Message: 10
> > Date: Mon, 8 Aug 2022 18:42:57 -0400
> > From: Robert Simmons <rsimmons0 at gmail.com>
> > To: Mailing List Gnucash <gnucash-user at gnucash.org>
> > Subject: [GNC] Incrementing Counters Saga Continues
> > Message-ID:
> > <CA+QLa9B=y+OGiRwb3cUfWtRo_ySwPNP-HPHmynkTVrOSnTyxCQ at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > In the theme of "the code is the documentation" I've found a method that
> is
> > almost what I need to increment a counter, but it doesn't look fully
> > implemented.
> >
> > >From the site-packages directory of the Python bindings directory,
> running
> > a grep for "increment" shows one line that is interesting.
> >
> >
> >
> gnucash/gnucash_core.py:Book.add_method('qof_book_increment_and_format_counter',
> > 'increment_and_format_counter')
> >
> > But calling book.increment_and_format_counter() raises an exception. The
> > relevant function in gnucash_core_c does not exist.
> >
> > AttributeError: module 'gnucash.gnucash_core_c' has no attribute
> > 'qof_book_increment_and_format_counter'
> >
> >
> > ------------------------------
> >
> > Message: 11
> > Date: Mon, 8 Aug 2022 18:50:34 -0400
> > From: Robert Simmons <rsimmons0 at gmail.com>
> > To: Mailing List Gnucash <gnucash-user at gnucash.org>
> > Subject: [GNC] How to Return a GDate?
> > Message-ID:
> > <CA+QLa9B50sRCEobqtU_7c-3HOg8pewhvwFWJGb+iSBf2dvAEBQ at mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Following the documentation:
> > https://code.gnucash.org/docs/MAINT/gncEntry_8h.html
> >
> > When creating an Entry (for a Bill or Invoice), the date is to be set
> using
> > a GDate:
> > "DEPRECATED - use gncEntrySetDateGDate() instead!"
> >
> > I see a number of functions that return an existing GDate, so something
> > like this returns a GDate object:
> > gdate = entry.GetDateGDate()
> >
> > However, again grepping for "GDate" in the whole Python bindings shows
> > nothing that lets me create a GDate object denovo.
> >
> > I can use the deprecated SetDate() and it works, but how should I use the
> > non-deprecated function?
> >
> > The following are all the results from the grep.
> >
> > gnucash/gnucash_core_c.py:def xaccTransSetDatePostedGDate(trans:
> > "Transaction *", date: "GDate") -> "void":
> > gnucash/gnucash_core_c.py:
> r"""xaccTransSetDatePostedGDate(Transaction *
> > trans, GDate date)"""
> > gnucash/gnucash_core_c.py: return
> > _gnucash_core_c.xaccTransSetDatePostedGDate(trans, date)
> > gnucash/gnucash_core_c.py:def xaccTransGetDatePostedGDate(trans:
> > "Transaction const *") -> "GDate":
> > gnucash/gnucash_core_c.py: r"""xaccTransGetDatePostedGDate(Transaction
> > const * trans) -> GDate"""
> > gnucash/gnucash_core_c.py: return
> > _gnucash_core_c.xaccTransGetDatePostedGDate(trans)
> > gnucash/gnucash_core_c.py:def qof_book_get_autoreadonly_gdate(book:
> > "QofBook const *") -> "GDate *":
> > gnucash/gnucash_core_c.py: r"""qof_book_get_autoreadonly_gdate(QofBook
> > const * book) -> GDate *"""
> > gnucash/gnucash_core_c.py:def gncInvoiceSetDateOpenedGDate(invoice:
> > "GncInvoice *", date: "GDate const *") -> "void":
> > gnucash/gnucash_core_c.py:
> r"""gncInvoiceSetDateOpenedGDate(GncInvoice *
> > invoice, GDate const * date)"""
> > gnucash/gnucash_core_c.py: return
> > _gnucash_core_c.gncInvoiceSetDateOpenedGDate(invoice, date)
> > gnucash/gnucash_core_c.py:def gncEntrySetDateGDate(entry: "GncEntry *",
> > date: "GDate const *") -> "void":
> > gnucash/gnucash_core_c.py: r"""gncEntrySetDateGDate(GncEntry * entry,
> > GDate const * date)"""
> > gnucash/gnucash_core_c.py: return
> > _gnucash_core_c.gncEntrySetDateGDate(entry, date)
> > gnucash/gnucash_core_c.py:def gncEntryGetDateGDate(entry: "GncEntry const
> > *") -> "GDate":
> > gnucash/gnucash_core_c.py: r"""gncEntryGetDateGDate(GncEntry const *
> > entry) -> GDate"""
> > gnucash/gnucash_core_c.py: return
> > _gnucash_core_c.gncEntryGetDateGDate(entry)
> > gnucash/gnucash_core_c.py:def gnc_pricedb_remove_old_prices(db:
> "GNCPriceDB
> > *", comm_list: "GList *", fiscal_end_date: "GDate *", cutoff: "time64",
> > source: "PriceRemoveSourceFlags", keep: "PriceRemoveKeepOptions") ->
> > "gboolean":
> > gnucash/gnucash_core_c.py:
> r"""gnc_pricedb_remove_old_prices(GNCPriceDB
> > * db, GList * comm_list, GDate * fiscal_end_date, time64 cutoff,
> > PriceRemoveSourceFlags source, PriceRemoveKeepOptions keep) ->
> gboolean"""
> >
> >
> > ------------------------------
> >
> > Message: 12
> > Date: Mon, 8 Aug 2022 15:52:14 -0700
> > From: john <jralls at ceridwen.us>
> > To: "R. Victor Klassen" <rvklassen at gmail.com>
> > Cc: Derek Atkins <derek at ihtfp.com>, Mailing List Gnucash
> > <gnucash-user at gnucash.org>
> > Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
> > Message-ID: <2ECE29A2-77E5-42E8-AE80-8D3FB20100E9 at ceridwen.us>
> > Content-Type: text/plain; charset=utf-8
> >
> > There's no hidden feature in GnuCash.
> >
> > SQL: select count(*) from transactions; and select count(*) from splits;
> >
> > grep an uncompressed XML file: grep -c '<gnc:transaction>'
> > path/to/file.gnucash; use '<trn:split>' to count the splits.
> >
> > You can also look at the top of your XML file between the book slots and
> > the commodities to find a block that looks like
> >
> > <gnc:count-data cd:type="commodity">406</gnc:count-data>
> > <gnc:count-data cd:type="account">757</gnc:count-data>
> > <gnc:count-data cd:type="transaction">34279</gnc:count-data>
> > <gnc:count-data cd:type="schedxaction">4</gnc:count-data>
> > <gnc:count-data cd:type="price">4505</gnc:count-data>
> > <gnc:count-data cd:type="gnc:GncEntry">1</gnc:count-data>
> > <gnc:count-data cd:type="gnc:GncInvoice">1</gnc:count-data>
> > <gnc:count-data cd:type="gnc:GncJob">1</gnc:count-data>
> > <gnc:count-data cd:type="gnc:GncTaxTable">1</gnc:count-data>
> > <gnc:count-data cd:type="gnc:GncVendor">1</gnc:count-data>
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Aug 8, 2022, at 2:43 PM, R. Victor Klassen <rvklassen at gmail.com>
> > wrote:
> > >
> > > Just out of curiosity, how does one determine those numbers? An SQL
> > query? grep <pattern> | wc on the xml? Some feature of gnuCash I?ve
> never
> > discovered?
> > >
> > >> On Aug 8, 2022, at 3:54 PM, Derek Atkins <derek at ihtfp.com> wrote:
> > >>
> > >>
> > >> On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote:
> > >>>> Accounting systems primarily perform the same operation on large
> > numbers
> > >>> of data elements.
> > >>>
> > >>> I wish I had time to devote to this. I use graph databases in many of
> > the
> > >>> other systems that I develop. This would be a great pivot point on
> > which
> > >>> to
> > >>> create a new open source project and see which paradigm really is
> > better.
> > >>> But really I need to get my data organized and then handed off to an
> > >>> accountant (so I can get back to working on my real work).
> > >>
> > >> My GnuCash database, which has data going back to at least 2007, only
> > >> contains 26781 transactions, with 59582 splits (at least 2 per
> > >> transaction), over a total of 564 "accounts".
> > >>
> > >> Even if you increase by a factor of 10, I doubt you're going to see
> any
> > >> significant performance differences between databases of similar
> nominal
> > >> performance.
> > >>
> > >>> Please remember to CC this list on all your replies.
> > >>> You can do this by using Reply-To-List or Reply-All.
> > >>
> > >> -derek
> > >>
> > >> --
> > >> Derek Atkins 617-623-3745
> > >> derek at ihtfp.com www.ihtfp.com
> > >> Computer and Internet Security Consultant
> > >>
> > >> _______________________________________________
> > >> 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
> > >> -----
> > >> 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 at gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> >
> >
> > ------------------------------
> >
> > 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
> > -----
> > 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 233, Issue 27
> > *********************************************
> >
> > _______________________________________________
> > 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
> > -----
> > 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 at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
More information about the gnucash-user
mailing list