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 [email protected]
Sent from Yahoo Mail on Android On Mon, Aug 8, 2022 at 6:54 PM, [email protected]<[email protected]> wrote: Send gnucash-user mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 ([email protected]) 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 <[email protected]> To: Mailing List Gnucash <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <ca+qla9daxjgt2e71zhpjh8nbc-1c6vwmxfspe08-+8cpqpj...@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 <[email protected]> To: Mailing List Gnucash <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <CA+QLa9CRfX9AH9jfEkNr9+_XSQ3+yn7TYY-t=37hmyjj+g-...@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" <[email protected]> To: "Robert Simmons" <[email protected]> Cc: "Mailing List Gnucash" <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <[email protected]> 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 [email protected] www.ihtfp.com Computer and Internet Security Consultant ------------------------------ Message: 4 Date: Mon, 8 Aug 2022 16:07:18 -0400 From: "R. Victor Klassen" <[email protected]> To: Adrien Monteleone <[email protected]> Cc: [email protected] Subject: Re: [GNC] Request for two new features in GnuCash Message-ID: <[email protected]> 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 > <[email protected]> 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 > [email protected] > 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 <[email protected]> To: [email protected] Subject: Re: [GNC] Request for two new features in GnuCash Message-ID: <[email protected]> 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 <[email protected]> To: Mailing List Gnucash <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <CA+QLa9CArLvUz3=5b1n4aesosppm+bz7mhnxqwdrucupnfc...@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" <[email protected]> To: "Robert Simmons" <[email protected]> Cc: "Mailing List Gnucash" <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <[email protected]> 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 [email protected] www.ihtfp.com Computer and Internet Security Consultant ------------------------------ Message: 8 Date: Mon, 8 Aug 2022 17:43:13 -0400 From: "R. Victor Klassen" <[email protected]> To: Derek Atkins <[email protected]> Cc: Robert Simmons <[email protected]>, Mailing List Gnucash <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <[email protected]> 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 <[email protected]> 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 > [email protected] www.ihtfp.com > Computer and Internet Security Consultant > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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: [email protected] To: [email protected] Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 22 Message-ID: <[email protected]> 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 [email protected] > > Sent from Yahoo Mail on Android > > On Mon, Aug 8, 2022 at 2:16 PM, David Carlson<[email protected]> > 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 <[email protected]> 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 > > [email protected] > > 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 > [email protected] > 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 <[email protected]> To: Mailing List Gnucash <[email protected]> Subject: [GNC] Incrementing Counters Saga Continues Message-ID: <CA+QLa9B=y+ogirwb3cufwtro_yswpnp-hphmynktvrosnty...@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 <[email protected]> To: Mailing List Gnucash <[email protected]> Subject: [GNC] How to Return a GDate? Message-ID: <ca+qla9b50srceobqtu_7c-3hog8pewhvwfwjgb+isbf2dva...@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 <[email protected]> To: "R. Victor Klassen" <[email protected]> Cc: Derek Atkins <[email protected]>, Mailing List Gnucash <[email protected]> Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h Message-ID: <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 >> [email protected] www.ihtfp.com >> Computer and Internet Security Consultant >> >> _______________________________________________ >> gnucash-user mailing list >> [email protected] >> 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 > [email protected] > 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 [email protected] 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 [email protected] 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.
