Re: [GNC] In Praise of Excellent Features

[David Klann]

(Replying to the digest summary...)

Hear, Hear NoobAlice! Thank you for this great summary of little-known 
(to me at least) features!


On 6/3/23 11:00, you wrote:

Hello All!


No questions, just joy!  Thank you to all the devs and to everyone who
gives advice in the mailing list!



To this I add my thanks. I have been using GnuCash for about six years 
to keep books for my sole proprietorship consulting practice. Each new 
release brings more satisfaction!



I have been happily using GnuCash for years.  Today I was poking through
the menus to see if I could find an Expand All/Collapse All option for
the accounts tree, when I saw other options I had never previously noticed.


New treats:

Edit > Cascade Account Properties
For an account and all its subaccounts, you can change all the colors,
set placeholder status, and/or set hidden status.

Edit > Renumber Subaccounts
WOW!  This has been the bane of my existence when working with
QuickBooks-using clients who have never numbered their charts of
accounts, as the external program we use requires numbered accounts.
This looks so efficient!  I am accustomed to manually changing account
numbers one. by. one.

Actions > Rename Page
This looks so convenient.  You can even rename the Accounts page!


And my favorite options that are good friends:

Variables
You can use variables in scheduled transactions.  For example, if you
are entering a paycheck and you like to split out taxes and deductions,
you can just fill in the blank for "grosswages" and have GnuCash compute
all the line items.
Credit Salary   grosswages
Debit Income Taxgrosswages*0.10 ### 10%
Debit Retirementgrosswages*0.05 ### 5%
Debit Local Tax 3.98### assuming fixed amount
Debit Health Insurance  100.00  ### assuming fixed amount
Debit Checking Acct grosswages*(1-0.15)-3.98-100### net of above

Spreadsheets
One can just copy a GnuCash report and paste into a spreadsheet for
further manipulation, which is great for generating external reports for
non-coders such as myself.

Custom Shortcuts
Two simple edits to ~/.local/share/gnucash/accelerator-map, and I have
shortcuts to open the Saved Reports list with Ctrl+A and turn
double-line view on/off with Ctrl+D!!!
;
; Double-line register on/off
(gtk_accel_path
"/GncPluginPageRegisterActions/ViewStyleDoubleLineAction"
"d")
;
; Saved reports configuration list
(gtk_accel_path
"/gnc-plugin-menu-additions-actions/AdditionsAction/4d3dcdc8890b11df99dd94cddfd72085Action"
   "a")


To this great list of awesome features I add: thank you for the 
excellent instructions for compiling GnuCash from the git sources.


I recently learned that the 5.1 flatpak (at FlatHub) would not work with 
the Python API. I have been hoping to explore it in order to write a 
custom invoice printing tool. I set off to compile from the git repo and 
was led to the wiki for compiling on Linux. Work perfectly for me on the 
first attempt.


Now to continue my education in the Python interface...

Thank you!

  ~David Klann
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Tidying up an Old Set of Accounts

[David H]

Pete,

Anything with a date in the name like 20221229212946 indicates to me you
are opening a gnucash automatic backup file and not your actual gnucash
data file?  Check the folder you save your gnucash data file in and sort
the files in descending date and time order and see if you can see the
"Kath&PeteAccoounts.gnucash" which would have been your actual gnucash file
and see when it was last modified.  If you did intentionally open a backup
file and wanted to keep it as your data file, it is probably good practice
to rename it to remove the extra date from the name by saving it with the
new name. You should probably also double check that you haven't lost any
txns by going back to a backup file at various times.

Cheers David H.


On Sun, 4 Jun 2023 at 06:09, p.f.cuthb...@btinternet.com p.f.cuthbert---
via gnucash-user  wrote:

>
> Hi Everybody
>
>
> Many thanks for the clear instructions for consolidating accounts.  That
> worked a treat.
>
> When coming to do a backup I encountered something of a surprise (see
> attached screen shot).  The Accounts were previoulsy known as
> "Kath&PeteAccoounts.gnucash.20221229212946.gnucash" but from 5/5/23 the
> name has been changed to "01Jan2023 QIF
> Imports.gnucash.20230506111943.gnucash".  I have no recollection of
> making such a change, not to mention wondering what ever happened to
> entries for January, February, March, and April although the actual
> transactions entered in those months are in the current file. I am also
> intrigued as to why the file name type has changed to QIF imports.
>
> I do find that GNU Cash is full of little surprises.
>
> Best wishes
>
> Pete
>
>
> -- Original Message --
> From: "Murugan Muruganandam" 
> To: "gnucash-user@gnucash.org" ;
> "p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com"
> 
> Sent: Friday, 2 Jun, 2023 At 22:20
> Subject: Re: [GNC] Tidying up an Old Set of Accounts
>
>   back up your file before you do the following
>
>
>
>
>
> 1.  make sure interest earned account is not a place holder (edit
> account will give you the details)
> 2.  Delete the sub account, the pop-up will ask to which account you
> want to transfer.
> 3.  Choose Interest Earned as your receipient account.
> 4.  On accepting, the transactions will move to your Interest Earned
> account.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Saludos Cordiales
>
> Murugan
>
>
>
>
>
>
> From: gnucash-user
>  on behalf
> of p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user
> 
>   Sent: Friday, June 2, 2023 5:08 PM
>   To: gnucash-user@gnucash.org 
>   Subject: [GNC] Tidying up an Old Set of Accounts
>
>
>
>
>   Hi Folks
>
>   I have moved to GNU Cash from Quicken (about 1987 version plus
> Milenium
>   option) so have a rather 'messy' set of accounts that reflect my
>   differeing needs over the years.
>
>   I now wish to do some sonsolidation.  For example I am in the silly
>   poition of having three acounts for interest earned - Interest Earned,
>   Interest Gross, Interest Net.
>
>   In this case I would like to simply merge the two sub-accounts into
> the
>   Interest Earned account.  Having tried working through the Help
> section
>   I cannot seem to find a suitable tool.
>
>   Your advice would be appreciated.
>
>   Regards
>
>   Pete
>
>   Dr Peter Cuthbert
>   Creuddyn
>   Coedlan Y Plas
>
>   Llangawsai
>   Aberystwyth
>   Ceredigion
>   SY23 1HJ
>   01970 623 447
>   ___
>   gnucash-user mailing list
>   gnucash-user@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.
>
>
>
>
> Dr Peter Cuthbert
> Creuddyn
> Coedlan Y Plas
>
> Llangawsai
> Aberystwyth
> Ceredigion
> SY23 1HJ
> 01970 623 447
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Finance::Quote Quote Throttling

[Bruce Schuck]

On 6/3/23 13:40, Mike Alexander wrote:

I would pay a few dollars a month for a key to avoid throttling. I 
looked into buying a key from IEXCloud, but the cheapest one that

seems to do the trick is $1500 a month. :-)


In other words, your answer is no.

Obviously we are aware of the cost of the various vendors' API offerings 
and have no control over that. So the question was not meant to assume a 
hypothetical "if the vendors reduced their pricing would you...". Rather 
than looking to see if anybody may already be paying for premium keys or 
were thinking about it but are aware that F::Q throttles regardless of 
key type.


Thanks for the response though.

Bruce
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Tidying up an Old Set of Accounts

[Murugan Muruganandam]

for screenshots you have to attach it as an image, embedded images will not be 
displayed




Saludos Cordiales


Murugan


From: p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com 

Sent: Saturday, June 3, 2023 4:07 PM
To: Murugan Muruganandam ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Tidying up an Old Set of Accounts

Hi Everybody


Many thanks for the clear instructions for consolidating accounts. That worked 
a treat.


When coming to do a backup I encountered something of a surprise (see attached 
screen shot). The Accounts were previoulsy known as 
"Kath&PeteAccoounts.gnucash.20221229212946.gnucash" but from 5/5/23 the name 
has been changed to "01Jan2023 QIF Imports.gnucash.20230506111943.gnucash". I 
have no recollection of making such a change, not to mention wondering what 
ever happened to entries for January, February, March, and April although the 
actual transactions entered in those months are in the current file. I am also 
intrigued as to why the file name type has changed to QIF imports.


I do find that GNU Cash is full of little surprises.


Best wishes


Pete



-- Original Message --
From: "Murugan Muruganandam" 
To: "gnucash-user@gnucash.org" ; 
"p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com" 

Sent: Friday, 2 Jun, 2023 At 22:20
Subject: Re: [GNC] Tidying up an Old Set of Accounts

back up your file before you do the following


  1.  make sure interest earned account is not a place holder (edit account 
will give you the details)
  2.  Delete the sub account, the pop-up will ask to which account you want to 
transfer.
  3.  Choose Interest Earned as your receipient account.
  4.  On accepting, the transactions will move to your Interest Earned account.







Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user 

Sent: Friday, June 2, 2023 5:08 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Tidying up an Old Set of Accounts

Hi Folks

I have moved to GNU Cash from Quicken (about 1987 version plus Milenium
option) so have a rather 'messy' set of accounts that reflect my
differeing needs over the years.

I now wish to do some sonsolidation. For example I am in the silly
poition of having three acounts for interest earned - Interest Earned,
Interest Gross, Interest Net.

In this case I would like to simply merge the two sub-accounts into the
Interest Earned account. Having tried working through the Help section
I cannot seem to find a suitable tool.

Your advice would be appreciated.

Regards

Pete

Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447
___
gnucash-user mailing list
gnucash-user@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.


Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai

Aberystwyth
Ceredigion
SY23 1HJ

01970 623 447
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[Alun Champion]

I was also having this same problem on my M1 Mac when upgrading to Gnucash
5+ (it worked fine in 4.X). After some digging it looks like my environment
meant that gnucash 5+ was using the wrong version of cpan for the perl it
was using (there are 2 installed by default - 5.3 and 5.34, I also had 5.36
installed by HomeBrew) and I saw the logs JSON::Parse was missing but
gnc-fq-update was reporting it up-to-date.

Fixing the environment
(/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment)
meant that it started working however I was now getting this error:

* NASDAQ:GOOGL Finance::Quote reported failure with error: Error retrieving
quote for GOOGL. Attempt to fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/GOOGL?modules=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 501 (Not Implemented)

When you paste the URL directly into a browser
https://query2.finance.yahoo.com/v11/finance/quoteSummary/GOOGL?modules=price,summaryDetail,defaultKeyStatistics
it works fine.

I had chosen to use the homebrew Perl, I found that Net::SSLeay was not
installed correctly which was causing LWP::Protocol::https to fail, after
fixing (brew install openssl) everything was working again. I'm assuming
that it was silently falling back to http which was causing the 501.

Not sure if this helps anyone

On Thu, Mar 30, 2023 at 1:31 AM Outlook  wrote:

> I have the same problem with quote update on version 5.0, and now I have
> to return back to version 4.13 and it works fine.
>
> Some quotes from Taiwan stock, for example 0050.TW updated from Yahoo as
> JSON on macOS 13.3/
>
> Thanks!
>
> > David G. Pickett via gnucash-user  於
> 2023年3月29日 上午7:30 寫道：
> >
> > Poking aroun more, I see in Edit Security DIA it says "Warning: Finance
> Quote is not installed properly.".
> >
> > Checking my cron job log, it says:
> >
> > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucashF: X11 socket /tmp/.X11-unix/X0
> does not exist in filesystem, trying to use abstract socket instead.Missing
> data file parameter
> > gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
> small business finance:
> > Common Options:  -h [ --help ]  Show this help message  -v [
> --version ]   Show GnuCash version  --debugEnable
> debugging mode: provide deep detail in the  logs.
>This is equivalent to: --log "=info" --log
> "qof=info"  --log "gnc=info"  --extra
>   Enable extra/development/debugging features.  --log arg  Log
> level overrides, of the form
> "modulename={debug,info,warn,crit,error}" Examples:
> "--log qof=debug" or "--log  gnc.backend.file.sx=info"
>This can be invoked multiple times.  --paths
> Show paths  --logto argFile to log into; defaults to
> "/tmp/gnucash.trace";  can be "stderr" or "stdout".
> > Price Quotes Retrieval Options:  -Q [ --quotes ] argExecute price
> quote related commands. The following  commands are
> supported.info: Show
> Finance::Quote version and exposed quote
> sources.get: Fetch current quotes for all
> foreign  currencies and stocks in the given
> GnuCash  datafile.
>  dump: Fetch current quotes for specified currencies
>   or stocks from a specified namespace and print
>  the results to the console.
>  This must be followed with a source and one or
>  more symbols, unless the source is "currency"
> in which case it must be followed with two or
> more symbols, the first of which is the
>   currency in which exchange rates for the rest
>   will be quoted.   --namespace arg
> Regular expression determining which namespace
> commodities will be retrieved for when using the get
>   command  -V [ --verbose ]   When using the dump command list all of
> the parameters Finance::Quote returns for the
> symbol instead of the  ones that Gnucash requires.
> > Report Generation Options:  -R [ --report ] argExecute report
> related commands. The following  commands are
> supported.list: Lists
> available reports.   show: Describe the options
> modified in the named  report. A datafile
> may be specified to  describe some saved
> options.   run: Run the named report in the given
> GnuCash datafile.
>  --name arg Name of the report to run
>  -

Re: [GNC] Tidying up an Old Set of Accounts

[p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user]

Hi Everybody


Many thanks for the clear instructions for consolidating accounts.  That 
worked a treat.


When coming to do a backup I encountered something of a surprise (see 
attached screen shot).  The Accounts were previoulsy known as 
"Kath&PeteAccoounts.gnucash.20221229212946.gnucash" but from 5/5/23 the 
name has been changed to "01Jan2023 QIF 
Imports.gnucash.20230506111943.gnucash".  I have no recollection of 
making such a change, not to mention wondering what ever happened to 
entries for January, February, March, and April although the actual 
transactions entered in those months are in the current file. I am also 
intrigued as to why the file name type has changed to QIF imports.


I do find that GNU Cash is full of little surprises.

Best wishes

Pete


-- Original Message --
From: "Murugan Muruganandam" 
To: "gnucash-user@gnucash.org" ; 
"p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com" 


Sent: Friday, 2 Jun, 2023 At 22:20
Subject: Re: [GNC] Tidying up an Old Set of Accounts

 back up your file before you do the following





   1.  make sure interest earned account is not a place holder (edit 
account will give you the details)
   2.  Delete the sub account, the pop-up will ask to which account you 
want to transfer.

   3.  Choose Interest Earned as your receipient account.
   4.  On accepting, the transactions will move to your Interest Earned 
account.





















Saludos Cordiales

Murugan






From: gnucash-user 
 on behalf 
of p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user 


 Sent: Friday, June 2, 2023 5:08 PM
 To: gnucash-user@gnucash.org 
 Subject: [GNC] Tidying up an Old Set of Accounts




 Hi Folks

 I have moved to GNU Cash from Quicken (about 1987 version plus 
Milenium

 option) so have a rather 'messy' set of accounts that reflect my
 differeing needs over the years.

 I now wish to do some sonsolidation.  For example I am in the silly
 poition of having three acounts for interest earned - Interest Earned,
 Interest Gross, Interest Net.

 In this case I would like to simply merge the two sub-accounts into 
the
 Interest Earned account.  Having tried working through the Help 
section

 I cannot seem to find a suitable tool.

 Your advice would be appreciated.

 Regards

 Pete

 Dr Peter Cuthbert
 Creuddyn
 Coedlan Y Plas

 Llangawsai
 Aberystwyth
 Ceredigion
 SY23 1HJ
 01970 623 447
 ___
 gnucash-user mailing list
 gnucash-user@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.




Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447
___
gnucash-user mailing list
gnucash-user@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.

[GNC] SQLite slow to load on macOS but not Linux

[Colin Arndt]

Hi all,

I set up Gnucash a few years ago on Linux and have since switched to using it 
on Mac (Ventura 13.4 on a MacBook Air M1 2020). 

I’ve mainly run it with the XML file, but wanted to take advantage of some 
add-ons that require a SQL database. After saving as an sqlite3 file on Mac, it 
now take 30 seconds to load. The XML file opens instantly. (XML file is 18MB, 
SQLite DB is 12MB, including 9000 transactions and 6000 prices).

Out of curiosity I opened the same SQLite file on an Intel Linux box of similar 
age to my MacBook Air. GnuCash opened instantly. The issue is only on my Mac.

I’ve taken the following steps time without any difference:

1. Checked and Repaired all accounts
2. Saved file back to an XML then back to an SQLite file, on both my Mac and 
Linux box
3. Ran sqlite3 database_name 'VACUUM;’ from the Terminal
4. Deleted all price data

Reports of this issue mention 1 CPU spinning up to 100% while the file is 
loaded into memory - and I see the same behavior.

Any advice on this?

Thanks,
Colin
___
gnucash-user mailing list
gnucash-user@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.

[GNC] New Finance-Quote-User email List at SourceForge

[Bruce Schuck]

Greetings all,

Just an FYI. I created a new finance-quote-u...@lists.sourceforge.net 
email list. This will augment any ongoing discussions on 
https://github.com/finance-quote/finance-quote/discussions.


Have a good weekend.

Bruce S.
___
gnucash-user mailing list
gnucash-user@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.