Re: [GNC] User Experience Feedback After 5 Years of Using GnuCash

2025-03-02 Thread NoobAlice via gnucash-user

On 2025-03-02 03:21 PM, Gal Bar Mashiah wrote:

Thank you for the  Transaction --> 'Remove other splits' tip. Was not aware
about this option.



Instructions here: 
https://lists.gnucash.org/pipermail/gnucash-user/2024-June/112083.html

___
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] Quotes again?

2025-03-02 Thread Brad Morrison
Hi Dale/GNUCash users, 

If you do not trust the owners and/or maintainers of the software you
use to manage it for/with you, you may not want to use that software
over the long term. 

Linux Mint 21.3 was released in January 2024, so by not using the
current version, you are basically telling Clem/Linux Mint that all of
the work that he/they have done in the last 14 months is not valuable
enough to use. 

https://www.linuxmint.com/download.php 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-03-01 09:30, Dale Alspach wrote:

> If it ain't broke, don't fix it. 
> 
> In general, unless I am seeing significant issues, I don't upgrade until 
> versions have aged a little and other users have uncovered problems. 
> I do generally apply fixes for individual packages as suggested by "update 
> manager". 
> 
> Dale 
> 
> On Sat, Mar 1, 2025 at 11:07 AM Brad Morrison  wrote: 
> 
>> Hi Dale/GNUCash users, 
>> 
>> https://www.linuxmint.com/download_all.php &
>> https://distrowatch.com/table.php?distribution=mint - the current/latest
>> version of Linux Mint is 22.1, is there a reason that you are still
>> using 21.3? 
>> 
>> ---
>> Thanks, 
>> 
>> Brad - https://www.facebook.com/brad.morrison.12327/ &
>> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
>> https://norcal.social/@BradMorrison 
>> 
>> On 2025-03-01 08:10, Dale Alspach wrote:
>> 
>>> Thanks for this.
>>> I am running the flatpak version 5.10 on linux mint 21.3.
>>> It took a little searching to find YahooJSON.pm in the flatpak
>>> 
>>> In my case this works:
>>> find /var/lib/flatpak/app -name YahooJSON.pm
>>> 
>>> Replacing line 48 as suggested worked.
>>> 
>>> Dale
>>> 
>>> On Wed, Feb 19, 2025 at 9:26 AM Kalpesh Patel  wrote:
>>> 
>>> Yahoo's new changes are fixated on the value of the user agent header
>>> being passed. The quick fix is to replace line 48 of YahooJSON.pm module of
>>> the latest version from:
>>> 
>>> my $browser = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1)
>>> AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36';
>>> 
>>> to:
>>> 
>>> my $browser = 'Mozilla/5.0';
>>> 
>>> -Original Message-
>>> From: Kalpesh Patel 
>>> Sent: Wednesday, February 19, 2025 6:53 AM
>>> To: 'Cam Ellison' 
>>> Cc: 'gnucash-user@gnucash.org' 
>>> Subject: RE: [GNC] Quotes again?
>>> 
>>> Calling http://query2.finance.yahoo.com/v1/test/getcrumb on command line
>>> is failing but browser version works. I would not be surprised if they
>>> introduced some sort of anti-programmatic use measures.
>>> 
>>> I will check if there is fix for it but it will most likely will not be
>>> until the weekends.
>>> 
>>> -Original Message-
>>> From: Cam Ellison 
>>> Sent: Wednesday, February 19, 2025 12:47 AM
>>> To: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Quotes again?
>>> 
>>> Error accessing query2.finance.yahoo.com/v1/test/getcrumb [1].
>>> 
>>> Someone worked out a patch for the original problem 2 years or so back
>>> which involves setting a crumb, but obviously Yahoo has again changed
>>> something and it doesn't work anymore. This particular API apparently
>>> hasn't been supported for some time, so this is hardly a surprise.
>>> 
>>> On 2025-02-18 16:53, David G. Pickett via gnucash-user wrote: Quotes on 
>>> yahoo broke today, something unhappy about getcrumb, I'd cop and paste but 
>>> it does not allow that! ___
>>> 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.
>> ___
>> 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.
 

Links:
--
[1] http://query2.finance.yahoo.com/v1/test/getcrumb
_

Re: [GNC] Searching mailing lists

2025-03-02 Thread Brad Morrison
Hi Stan/GNUCash users, 

That Nabble link on that GNUCash mailing list search is still not
working for me - https://www.nabble.com/ 

If it does not work for others, should GNUCash contact Nabble for
support, remove that option, or something else? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-03-01 14:39, Stan Brown (using GC 4.14) wrote:

> On 2025-03-01 10:39, Brad Morrison wrote: 
> 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >
>> https://lists.gnucash.org/search/?idxinfo=gnucash-user >
>> https://gnucash.1415818.n4.nabble.com//GnuCash-User-f1415819.html does
>> not work for me right now (server not found), is anyone else also seeing
>> that issue?
> 
> The one you had trouble with (and I did too, to answer your question --
> DNS lookup failed) is a nabble link. As I recall, nabble was discussed a
> few months ago, and I believe the consensus was that it was moribund.
> People who use nabble to post to this list, or read it, have been
> counseled to use email instead.
> 
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
___
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 getting prices from Yahoo as JSON

2025-03-02 Thread Kalpesh Patel
Just to clarify: that will not install the one with Yahoo JSON patch to account 
for latest changes at Yahoo. That patch still needs to be installed manually as 
patch is yet to make it to the official releases. 

 

From: David H  
Sent: Sunday, March 02, 2025 3:32 AM
To: Adrian Holbrook 
Cc: Kalpesh Patel ; gnucash-user@gnucash.org
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON

 

Adrian,

 

Forget downloading anything, just find and run the "Install Online Price 
Retrieval For Gnucash" in the Gnucash folder under all apps which will update 
it for you.  Same deal on Win 10.

 

Works for me everytime.

 

Cheers David H.

 

 



 

On Sun, 2 Mar 2025 at 18:04, Adrian Holbrook mailto:megagru...@hotmail.com> > wrote:

I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q 
1.64_03 file but not sure what to do with it. Is there an installation program 
or do I have to use the command prompts to manually install?

Best regards

Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
Sent: 01 March 2025 14:06
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> 
>; gnucash-user@gnucash.org   
mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON


If you have Unix/Linux then you can run following to get the official interim 
release (literally cut and paste each line when your prompt comes back after 
executing each one) as mentioned by another user on this distro:



cd ~
wget https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz
tar -xvf ./Finance-Quote-1.64_03.tar.gz
cd Finance-Quote-1.64_03/
perl Makefile.PL
make
sudo make install





You haven’t mentioned the OS you are on so hard to get you past the finish line 
…











From: Adrian Holbrook mailto:megagru...@hotmail.com> >
Sent: Saturday, March 01, 2025 4:41 AM
To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >; 
gnucash-user@gnucash.org  
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON



Thanks. Not sure how to install a module from CPAN as suggested by Murugan so 
will attempt to modify the file.



Best regards



Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> 
 >>
Sent: 28 February 2025 22:57
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> 
 >>; 
gnucash-user@gnucash.org  
 > 
mailto:gnucash-user@gnucash.org> 
 >>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON



On Windows it should be:

 C:\Strawberry\perl\site\lib\Finance\Quote

On Unix/Linux it could be in many different places depending on how it was
installed. Try these:

/usr/share/perl5/Finance/Quote
/usr/local/share/perl/5.26.1/Finance/Quote

If not then use find utility to locate it on Unix/Linux or Mac OS'...

# find / -name YahooJSON.pm
/usr/share/perl5/Finance/Quote/YahooJSON.pm
/usr/local/share/perl/5.26.1/Finance/Quote/YahooJSON.pm

For flatpak, I am not sure how.

-Original Message-
From: Adrian Holbrook mailto:megagru...@hotmail.com> 
 >>
Sent: Friday, February 28, 2025 2:38 PM
To: gnucash-user@gnucash.org  
 >
Subject: [GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure
how to respond on the thread as the reply arrow was grayed out. I am not
sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find
the file YahooJSOM.pm. Can anyone help?

Thanks

Adrian

___
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] Problems getting prices from Yahoo as JSON

2025-03-02 Thread Kalpesh Patel
If Strawberry perl is installed correctly then running following will work fine 
on any windows version:

 

cpan https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz

 

 


See snippet below: 



C:\Users\kalpesh>cpan 
https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz

CPAN: CPAN::SQLite loaded ok (v0.219)

CPAN: LWP::UserAgent loaded ok (v6.67)

Fetching with LWP:

http://cpan.strawberryperl.com/authors/01mailrc.txt.gz

…

 

From: Kalpesh Patel  
Sent: Sunday, March 02, 2025 10:16 AM
To: 'David H' ; 'Adrian Holbrook' 
Cc: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON

 

Just to clarify: that will not install the one with Yahoo JSON patch to account 
for latest changes at Yahoo. That patch still needs to be installed manually as 
patch is yet to make it to the official releases. 

 

From: David H mailto:hell...@gmail.com> > 
Sent: Sunday, March 02, 2025 3:32 AM
To: Adrian Holbrook mailto:megagru...@hotmail.com> >
Cc: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >; 
gnucash-user@gnucash.org  
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON

 

Adrian,

 

Forget downloading anything, just find and run the "Install Online Price 
Retrieval For Gnucash" in the Gnucash folder under all apps which will update 
it for you.  Same deal on Win 10.

 

Works for me everytime.

 

Cheers David H.

 

 



 

On Sun, 2 Mar 2025 at 18:04, Adrian Holbrook mailto:megagru...@hotmail.com> > wrote:

I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q 
1.64_03 file but not sure what to do with it. Is there an installation program 
or do I have to use the command prompts to manually install?

Best regards

Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
Sent: 01 March 2025 14:06
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> 
>; gnucash-user@gnucash.org   
mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON


If you have Unix/Linux then you can run following to get the official interim 
release (literally cut and paste each line when your prompt comes back after 
executing each one) as mentioned by another user on this distro:



cd ~
wget https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz
tar -xvf ./Finance-Quote-1.64_03.tar.gz
cd Finance-Quote-1.64_03/
perl Makefile.PL
make
sudo make install





You haven’t mentioned the OS you are on so hard to get you past the finish line 
…











From: Adrian Holbrook mailto:megagru...@hotmail.com> >
Sent: Saturday, March 01, 2025 4:41 AM
To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >; 
gnucash-user@gnucash.org  
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON



Thanks. Not sure how to install a module from CPAN as suggested by Murugan so 
will attempt to modify the file.



Best regards



Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> 
 >>
Sent: 28 February 2025 22:57
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> 
 >>; 
gnucash-user@gnucash.org  
 > 
mailto:gnucash-user@gnucash.org> 
 >>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON



On Windows it should be:

 C:\Strawberry\perl\site\lib\Finance\Quote

On Unix/Linux it could be in many different places depending on how it was
installed. Try these:

/usr/share/perl5/Finance/Quote
/usr/local/share/perl/5.26.1/Finance/Quote

If not then use find utility to locate it on Unix/Linux or Mac OS'...

# find / -name YahooJSON.pm
/usr/share/perl5/Finance/Quote/YahooJSON.pm
/usr/local/share/perl/5.26.1/Finance/Quote/YahooJSON.pm

For flatpak, I am not sure how.

-Original Message-
From: Adrian Holbrook mailto:megagru...@hotmail.com> 
 >>
Sent: Friday, February 28, 2025 2:38 PM
To: gnucash-user@gnucash.org  
 >
Subject: [GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure
how to respond on the thread as the reply arrow was grayed out. I am not
sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find
the file YahooJSOM.pm. Can anyone help?

Thanks

Adrian

___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mai

[GNC] Voided Transactions

2025-03-02 Thread Stanley Piorkowski
I am using Windows 11 and GNU version 5.6, Build ID:5.6+(2024-03-30).

I am having a slight problem reconciling but it the process I made a report 
that covered my transactions for this year.  In the process of making this 
report, I found one voided transaction that is still showing on the report.  
I'm not sure why this is showing up with the original transaction amount but in 
the report, it doesn't show as voided.  Why is this?
___
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] Finance::Quote sometimes returns stock prices in pence

2025-03-02 Thread Adrian Holbrook
There is a feature in YahooJSON.pm to convert quotes on the LSE in pence to 
pounds by dividing by 100. This works on the majority of quotes  but there are 
some that it does not work on such as NWG.L (Natwest) and NXR.L (Norcross). 
Looking at the file it appears that the division by 100 is applied if the stock 
currency is identified as GBp or GBX and then the currency is changed to GBP as 
well. So I assume that the currency on Yahoo is incorrectly identified as GBP 
for the two stocks above. I am not sure how to check this but if anyone can 
suggest a mod to correct it I would be grateful.

Regards

adrian
___
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 getting prices from Yahoo as JSON

2025-03-02 Thread Kalpesh Patel
If Strawberry Perl and F::Q are installed correctly then run following in a
command prompt in Windows OS:

 

C:\Strawberry\perl\bin\cpan.bat
https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz

 

Note that there is a space between '.bat' and 'https:' incase cut-&-paste
munges is up.

 

From: Adrian Holbrook  
Sent: Sunday, March 02, 2025 3:03 AM
To: Kalpesh Patel ; gnucash-user@gnucash.org
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON

 

I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q
1.64_03 file but not sure what to do with it. Is there an installation
program or do I have to use the command prompts to manually install?

 

Best regards

 

Adrian

 

 

  _  

From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
Sent: 01 March 2025 14:06
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> >; gnucash-user@gnucash.org
  mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON 

 

If you have Unix/Linux then you can run following to get the official
interim release (literally cut and paste each line when your prompt comes
back after executing each one) as mentioned by another user on this distro:

 

cd ~
wget
https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz
tar -xvf ./Finance-Quote-1.64_03.tar.gz 
cd Finance-Quote-1.64_03/
perl Makefile.PL 
make
sudo make install

 

 

You haven't mentioned the OS you are on so hard to get you past the finish
line .

 

 

 

 

 

From: Adrian Holbrook mailto:megagru...@hotmail.com> > 
Sent: Saturday, March 01, 2025 4:41 AM
To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON

 

Thanks. Not sure how to install a module from CPAN as suggested by Murugan
so will attempt to modify the file.

 

Best regards

 

Adrian

  _  

From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
Sent: 28 February 2025 22:57
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com> >; gnucash-user@gnucash.org
  mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON 

 

On Windows it should be:

 C:\Strawberry\perl\site\lib\Finance\Quote 

On Unix/Linux it could be in many different places depending on how it was
installed. Try these:

/usr/share/perl5/Finance/Quote
/usr/local/share/perl/5.26.1/Finance/Quote

If not then use find utility to locate it on Unix/Linux or Mac OS'...

# find / -name YahooJSON.pm
/usr/share/perl5/Finance/Quote/YahooJSON.pm
/usr/local/share/perl/5.26.1/Finance/Quote/YahooJSON.pm

For flatpak, I am not sure how.

-Original Message-
From: Adrian Holbrook mailto:megagru...@hotmail.com> > 
Sent: Friday, February 28, 2025 2:38 PM
To: gnucash-user@gnucash.org  
Subject: [GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure
how to respond on the thread as the reply arrow was grayed out. I am not
sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find
the file YahooJSOM.pm. Can anyone help?

Thanks

Adrian

___
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 sometimes returns stock prices in pence

2025-03-02 Thread Kalpesh Patel
>From the latest code you can wrap lines 229 through 234 with following
Perl's if condition clause to bypass the conversion :

if  (!( (uc($stocks) eq "NXR.L") or (uc($stocks) eq "NWG.L") )) {
 ... # actual lines 229 through 234 goes here
}


-Original Message-
From: Adrian Holbrook  
Sent: Sunday, March 02, 2025 7:04 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Finance::Quote sometimes returns stock prices in pence

There is a feature in YahooJSON.pm to convert quotes on the LSE in pence to
pounds by dividing by 100. This works on the majority of quotes  but there
are some that it does not work on such as NWG.L (Natwest) and NXR.L
(Norcross). Looking at the file it appears that the division by 100 is
applied if the stock currency is identified as GBp or GBX and then the
currency is changed to GBP as well. So I assume that the currency on Yahoo
is incorrectly identified as GBP for the two stocks above. I am not sure how
to check this but if anyone can suggest a mod to correct it I would be
grateful.

Regards

adrian


___
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 getting prices from Yahoo as JSON

2025-03-02 Thread Adrian Holbrook
I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q 
1.64_03 file but not sure what to do with it. Is there an installation program 
or do I have to use the command prompts to manually install?

Best regards

Adrian



From: Kalpesh Patel 
Sent: 01 March 2025 14:06
To: 'Adrian Holbrook' ; gnucash-user@gnucash.org 

Subject: RE: [GNC] Problems getting prices from Yahoo as JSON


If you have Unix/Linux then you can run following to get the official interim 
release (literally cut and paste each line when your prompt comes back after 
executing each one) as mentioned by another user on this distro:



cd ~
wget https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz
tar -xvf ./Finance-Quote-1.64_03.tar.gz
cd Finance-Quote-1.64_03/
perl Makefile.PL
make
sudo make install





You haven’t mentioned the OS you are on so hard to get you past the finish line 
…











From: Adrian Holbrook 
Sent: Saturday, March 01, 2025 4:41 AM
To: Kalpesh Patel ; gnucash-user@gnucash.org
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON



Thanks. Not sure how to install a module from CPAN as suggested by Murugan so 
will attempt to modify the file.



Best regards



Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>
Sent: 28 February 2025 22:57
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com>>; 
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON



On Windows it should be:

 C:\Strawberry\perl\site\lib\Finance\Quote

On Unix/Linux it could be in many different places depending on how it was
installed. Try these:

/usr/share/perl5/Finance/Quote
/usr/local/share/perl/5.26.1/Finance/Quote

If not then use find utility to locate it on Unix/Linux or Mac OS'...

# find / -name YahooJSON.pm
/usr/share/perl5/Finance/Quote/YahooJSON.pm
/usr/local/share/perl/5.26.1/Finance/Quote/YahooJSON.pm

For flatpak, I am not sure how.

-Original Message-
From: Adrian Holbrook mailto:megagru...@hotmail.com>>
Sent: Friday, February 28, 2025 2:38 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure
how to respond on the thread as the reply arrow was grayed out. I am not
sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find
the file YahooJSOM.pm. Can anyone help?

Thanks

Adrian

___
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] Report gives black screen

2025-03-02 Thread Keith W Jones

There is another thread about this:

https://www.mail-archive.com/gnucash-user@gnucash.org/msg44341.html

I have same issue but with Windows 11. When I print it opens a blank 
window. However when I go to the Tempdirectory, I find the invoice in an 
HTML file which I can print to PDF.So the file is not going into the app.


 C:/Users/USERNAME/AppData/Local/Temp. My graphics card is Intel HD 
Graphics 4600 (Gigabyte) What graphics card do you have? Keith


On 02/03/2025 03:12, Richard Dawson wrote:

Using 5.1, flathub version.  Installed on Kubuntu 24.04.

When I opened the report Gnucash immediately opened a new tab labeled 
"transaction report" that was completely black.  I proceeded to select 
options.  When I closed the options window the screen remained 
entirely black.


This is the first time I have attempted to make reports with version 5 
in which I have been entering data nearly a year. Previously I was 
using the version offered in Ubuntu's repository, I think maybe 2.???  
As I recall, there is no going back, So I need to resolve this problem 
ASAP.


Help!!!

___ 

___
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] Searching mailing lists

2025-03-02 Thread Jim DeLaHunt
More reasons for removing the references to Nabble at the gnucash-user 
list search page:


"Nabble is not profitable…. Nabble has no future…." by Franklin, the 
apparent main decision-maker at Nabble, 13 June 2020 
.
"We will downsize Nabble to one server.…  Note that we no longer do 
mailing list archiving, so if you own an old mailing list archive, there 
is no point to preserving it." by Franklin, 5 July 2021 



I don't know where to propose edits to the web page 
. There is a 
repo "htdocs" at , but I 
cannot find the string "nabble" there. It looks to me like the source 
code for , not .


Best regards,
  —Jim DeLaHunt


On 2025-03-02 16:54, Brad Morrison wrote:

Hi Stan/GNUCash users,

That Nabble link on that GNUCash mailing list search is still not
working for me - https://www.nabble.com/

If it does not work for others, should GNUCash contact Nabble for
support, remove that option, or something else?

---
Thanks,

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison

On 2025-03-01 14:39, Stan Brown (using GC 4.14) wrote:


On 2025-03-01 10:39, Brad Morrison wrote:


https://lists.gnucash.org/mailman/listinfo/gnucash-user >
https://lists.gnucash.org/search/?idxinfo=gnucash-user >
https://gnucash.1415818.n4.nabble.com//GnuCash-User-f1415819.html does
not work for me right now (server not found), is anyone else also seeing
that issue?

The one you had trouble with (and I did too, to answer your question --
DNS lookup failed) is a nabble link. As I recall, nabble was discussed a
few months ago, and I believe the consensus was that it was moribund.
People who use nabble to post to this list, or read it, have been
counseled to use email instead.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

___
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] Searching mailing lists

2025-03-02 Thread John Ralls
I think that only Derek can edit https://lists.gnucash.org/search/

Regards,
John Ralls


> On Mar 2, 2025, at 18:29, Jim DeLaHunt  wrote:
> 
> More reasons for removing the references to Nabble at the gnucash-user list 
> search page:
> 
> "Nabble is not profitable…. Nabble has no future…." by Franklin, the apparent 
> main decision-maker at Nabble, 13 June 2020 
> .
> "We will downsize Nabble to one server.…  Note that we no longer do mailing 
> list archiving, so if you own an old mailing list archive, there is no point 
> to preserving it." by Franklin, 5 July 2021 
> 
> 
> I don't know where to propose edits to the web page 
> . There is a repo 
> "htdocs" at , but I cannot find 
> the string "nabble" there. It looks to me like the source code for 
> , not .
> 
> Best regards,
>   —Jim DeLaHunt
> 
> 
> On 2025-03-02 16:54, Brad Morrison wrote:
>> Hi Stan/GNUCash users,
>> 
>> That Nabble link on that GNUCash mailing list search is still not
>> working for me - https://www.nabble.com/
>> 
>> If it does not work for others, should GNUCash contact Nabble for
>> support, remove that option, or something else?
>> 
>> ---
>> Thanks,
>> 
>> Brad - https://www.facebook.com/brad.morrison.12327/ &
>> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
>> https://norcal.social/@BradMorrison
>> 
>> On 2025-03-01 14:39, Stan Brown (using GC 4.14) wrote:
>> 
>>> On 2025-03-01 10:39, Brad Morrison wrote:
>>> 
 https://lists.gnucash.org/mailman/listinfo/gnucash-user >
 https://lists.gnucash.org/search/?idxinfo=gnucash-user >
 https://gnucash.1415818.n4.nabble.com//GnuCash-User-f1415819.html does
 not work for me right now (server not found), is anyone else also seeing
 that issue?
>>> The one you had trouble with (and I did too, to answer your question --
>>> DNS lookup failed) is a nabble link. As I recall, nabble was discussed a
>>> few months ago, and I believe the consensus was that it was moribund.
>>> People who use nabble to post to this list, or read it, have been
>>> counseled to use email instead.
>>> 
>>> Stan Brown
>>> Tehachapi, CA, USA
>>> https://BrownMath.com
>> ___
>> 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.

___
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] How to change a scheduled transaction amount

2025-03-02 Thread Liz
On Sat, 1 Mar 2025 21:48:57 -0600
Edwin Booth  wrote:

> Hi All,
> 
> I get a Social Security payment each month 
snip
> 
> I hope I explained my problem well and that someone can help me with
> what I think is an easy problem to solve. PLEASE tell me if I did or
> I didn’t explain properly. I just need to understand how to update my
> Scheduled Transaction account. Maybe I need to delete last year’s
> scheduled transaction and create a new, 2025,  one?
> 

Stephen has described one way, I suggest another option.
Delete the 2024 scheduled transaction.
Enter in your checking account the 2025 version on the correct date in
January. Finalise the transaction with the enter key.
Now right click on the transaction and choose
"Schedule" which is three from the bottom.
Now edit this to monthly, and what other things you like in the
Scheduled Transactions editor screen, then save.

Liz
___
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] Voided Transactions

2025-03-02 Thread Michael or Penny Novack via gnucash-user

On 3/2/2025 2:43 PM, Stanley Piorkowski wrote:

I am using Windows 11 and GNU version 5.6, Build ID:5.6+(2024-03-30).

I am having a slight problem reconciling but it the process I made a report 
that covered my transactions for this year.  In the process of making this 
report, I found one voided transaction that is still showing on the report.  
I'm not sure why this is showing up with the original transaction amount but in 
the report, it doesn't show as voided.  Why is this?


How did you "void" the transaction? In other words, what do you mean? 
(process)


The formal process mimics the old days of pen and ink on paper in bound 
books so nothing once entered was ever removed. Instead a 
correction/offset transaction would be entered. Depending on the date 
done, I could see this happening (mistake made last year, corrected in 
this year.


If you followed informal practice and simply deleted the transaction, 
did you rerun the report after? Deleting the transaction would not 
change an open report.


Michael D Novack


___
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 sometimes returns stock prices in pence

2025-03-02 Thread Adrian Holbrook
Thanks for that. I think that the coding should work but there is probably an 
error on the Yahoo data where they probably identify the currency as GBP not as 
GBp. I am wondering if all the UK LSE stocks are quoted in pence but the 
currency identifier is sometimes incorrect - in which case it would be better 
to just use the first two letters "GB" to identify which stocks should be 
divided by 100?
 Could I test this by just changing the line:

 if ( ($info{$stocks,"currency"} eq "GBp")

To use a wild card instead of the "p"? Or is there a way to just test the first 
two characters?




From: Kalpesh Patel 
Sent: 02 March 2025 17:53
To: 'Adrian Holbrook' ; gnucash-user@gnucash.org 

Subject: RE: [GNC] Finance::Quote sometimes returns stock prices in pence

>From the latest code you can wrap lines 229 through 234 with following
Perl's if condition clause to bypass the conversion :

if  (!( (uc($stocks) eq "NXR.L") or (uc($stocks) eq "NWG.L") )) {
 ... # actual lines 229 through 234 goes here
}


-Original Message-
From: Adrian Holbrook 
Sent: Sunday, March 02, 2025 7:04 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Finance::Quote sometimes returns stock prices in pence

There is a feature in YahooJSON.pm to convert quotes on the LSE in pence to
pounds by dividing by 100. This works on the majority of quotes  but there
are some that it does not work on such as NWG.L (Natwest) and NXR.L
(Norcross). Looking at the file it appears that the division by 100 is
applied if the stock currency is identified as GBp or GBX and then the
currency is changed to GBP as well. So I assume that the currency on Yahoo
is incorrectly identified as GBP for the two stocks above. I am not sure how
to check this but if anyone can suggest a mod to correct it I would be
grateful.

Regards

adrian


___
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 getting prices from Yahoo as JSON

2025-03-02 Thread Adrian Holbrook
Thank you

From: Kalpesh Patel 
Sent: 02 March 2025 17:34
To: 'Adrian Holbrook' ; gnucash-user@gnucash.org 

Subject: RE: [GNC] Problems getting prices from Yahoo as JSON


If Strawberry Perl and F::Q are installed correctly then run following in a 
command prompt in Windows OS:



C:\Strawberry\perl\bin\cpan.bat 
https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz



Note that there is a space between ‘.bat’ and ‘https:’ incase cut-&-paste 
munges is up.



From: Adrian Holbrook 
Sent: Sunday, March 02, 2025 3:03 AM
To: Kalpesh Patel ; gnucash-user@gnucash.org
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON



I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q 
1.64_03 file but not sure what to do with it. Is there an installation program 
or do I have to use the command prompts to manually install?



Best regards



Adrian







From: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>
Sent: 01 March 2025 14:06
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com>>; 
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON



If you have Unix/Linux then you can run following to get the official interim 
release (literally cut and paste each line when your prompt comes back after 
executing each one) as mentioned by another user on this distro:



cd ~
wget https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz
tar -xvf ./Finance-Quote-1.64_03.tar.gz
cd Finance-Quote-1.64_03/
perl Makefile.PL
make
sudo make install





You haven’t mentioned the OS you are on so hard to get you past the finish line 
…











From: Adrian Holbrook mailto:megagru...@hotmail.com>>
Sent: Saturday, March 01, 2025 4:41 AM
To: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>; 
gnucash-user@gnucash.org
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON



Thanks. Not sure how to install a module from CPAN as suggested by Murugan so 
will attempt to modify the file.



Best regards



Adrian



From: Kalpesh Patel mailto:kalpesh.pa...@usa.net>>
Sent: 28 February 2025 22:57
To: 'Adrian Holbrook' mailto:megagru...@hotmail.com>>; 
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON



On Windows it should be:

 C:\Strawberry\perl\site\lib\Finance\Quote

On Unix/Linux it could be in many different places depending on how it was
installed. Try these:

/usr/share/perl5/Finance/Quote
/usr/local/share/perl/5.26.1/Finance/Quote

If not then use find utility to locate it on Unix/Linux or Mac OS'...

# find / -name YahooJSON.pm
/usr/share/perl5/Finance/Quote/YahooJSON.pm
/usr/local/share/perl/5.26.1/Finance/Quote/YahooJSON.pm

For flatpak, I am not sure how.

-Original Message-
From: Adrian Holbrook mailto:megagru...@hotmail.com>>
Sent: Friday, February 28, 2025 2:38 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure
how to respond on the thread as the reply arrow was grayed out. I am not
sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find
the file YahooJSOM.pm. Can anyone help?

Thanks

Adrian
___
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] User Experience Feedback After 5 Years of Using GnuCash

2025-03-02 Thread Gal Bar Mashiah
Thank you for the  Transaction --> 'Remove other splits' tip. Was not aware
about this option.

On Sun, Mar 2, 2025 at 12:16 AM Tommy Trussell 
wrote:

>
>
> On Sat, Mar 1, 2025 at 11:55 AM Gal Bar Mashiah  wrote:
>
>>   4.
>>
>>*Register View Behavior for 'Description' and 'Transfer' Fields*: When
>>entering a new transaction in the register view, leaving the
>> 'Description'
>>field with the 'Tab' key causes the 'Transfer' field to be auto-filled
>> with
>>the most recent transaction that has the same Description. While this
>> is
>>generally useful, there are times when I would prefer the Transfer
>> field to
>>remain empty. This issue occurs when the previous transaction involved
>>splits with many accounts, but the current transaction only has one
>> other
>>account. Perhaps a different keyboard shortcut could be used instead of
>>'Tab' to avoid this?
>>
>
> Instead of modifying the register code as you suggest, how about adding a
> key binding to
>
> Transaction --> Remove other splits
>
> This is the command I use all the time when the circumstance you describe
> comes up, mostly because I previously entered multiple different types of
> purchases at a large store, and need to key in a new transaction for a
> different shopping trip. If you're not aware of the function, give it a try
> and see if it does what you need.
>
> You may be able to add the keybinding yourself. (I haven't looked to see
> if that function provides for it.)
>
>
>> -
>> 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.