[GNC] gnucash-user Digest, Vol 233, Issue 27

James Baxter kangaroo52 at yahoo.com
Mon Aug 8 20:00:02 EDT 2022


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
*********************************************
  


More information about the gnucash-user mailing list