Re: [GNC] Bizarre happenings
I had this happening to me a while back, and what it turned out to it was the Options dialog was coming up on another screen I had attached to my computer, actually in the room next door, so I was not seeing it. A helpful person on this list reminded me about this possibility. If you have more than one screen on your computer and are running Windows 10, you can get to see the dialog like this. While you are in the report, click on the Options button in the toolbar. If you don't see the dialog, you can bring it to your screen by pressing Win-Shift-Left or Win-Shift-Right depending on whether the other screen is to the left or right of the one you are looking at. You can do both because it will ignore you if you go the wrong way (unless you have 3 screens of course!) Win is the Windows key, Shift is the shift key and Left/Right are the arrow keys. These commands move the window that has the focus so they will only work just after you have called the dialog and not clicked anywhere else that might change the focus. This behaviour is quite puzzling and seems to make the program freeze if the hidden dialog is modal. It can happen with other programs than GNC too. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX quotes not working
Hi Geoff,
Thanks for all your effort too, the least I can do is try to help you
with good feedback. Incidentally I am a recently retired software
developer so, even though I had never worked with Perl, I was pretty
sure I knew what you needed to know.
I can report that, with your new ASX.pm, everything works, inside and
outside GnuCash. All my ASX stocks retrieve and also one from NASDAQ.
Thanks again for your help,
John Bonnett
On 17/10/2020 2:10 pm, Geoff wrote:
Hi John
Thanks for your patience and detailed feedback, it has been very helpful.
Firstly, I installed strawberry-perl-5.18.2.2-32bit and was able to
reproduce the original error you reported on line 138. This was due
to sloppy coding on my part. Later versions of perl are more
forgiving, however that line should in fact be:
$info{$stock,$label} = $decoded_json->{$label_map{$label}};
(The explanation being that $decoded_json is a *reference* to a hash,
and the correct way to dereference it and access its values is with
the "->" notation, not "%$".)
Secondly, the error you encountered with stock "14D" (in your email
below) is not due to the stock code starting with a number, but a lack
of defensive coding on my part. For this stock, the ASX did not
return the "year_range" data element, and the message you saw (which
is only a warning) says that the element has an undefined value. I
have attached an updated version of ASX.pm with a fix for this:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump asx 14d
Finance::Quote fields Gnucash uses:
symbol: 14d <=== required
date: 10/16/2020 <=== recommended
currency: AUD <=== required
last: 0.135 <=\
nav: <=== one of these
price: 0.135 <=/
timezone: <=== optional
Thirdly, I can successfully retrieve prices in GnuCash itself - see
attached screenshot. If you don't mind, can you review your
configuration against that, and try again with the updated ASX.pm module?
Fourthly, the Finance::Quote developers have contacted me and I hope
to be able to submit this as a fix that will go into the distribution.
After some more rigourous testing obviously!
Regards
Geoff
=
On 16/10/2020 3:29 pm, John Bonnett wrote:
Hi Geoff,
I am still not getting all my stocks retrieved inside GnuCash but I
may have made some progress.
I checked the stocks not working using gnc-fq-dump and they all
retrieved except for one I still had that had been de-listed, so that
is as expected, but does not explain why they don't work inside GnuCash.
I retrieved them all in one call to gnc-fq-dump and I noticed there
was an error message at the start. After a little more digging I
found just one stock was causing that problem as follows:
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX 14D
Use of uninitialized value in transliteration (tr///) at
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 141.
Finance::Quote fields Gnucash uses:
symbol: 14D <=== required
date: 10/16/2020 <=== recommended
currency: AUD <=== required
last: 0.145 <=\
nav: <=== one of these
price: 0.145 <=/
timezone: <=== optional
PS C:\Program Files (x86)\gnucash\bin>
It may be that having a stock symbol starting with a number is
causing the problem, but it still retrieves OK. It did occur to me
that, depending on the order that GnuCash does the retrieving
internally, that error may make the program think there are no valid
values after that message and explain why some of the stocks are
missing in the results.
Best regards,
John Bonnett
On 16/10/2020 9:05 am, John Bonnett wrote:
Hi Geoff,
I seem to have partly solved my problem. Following up on a comment
from Bill and your interest in the version of Perl I was running, I
chased up a recent version of Strawberry Perl.
I got v5.32.0 64bit and installed that. It still thought I had the
older 32bit installed so I tried uninstalling that. This broke the
64bit install, so I repaired it and then ran the "Install Online
Price Retrieval for GnuCash" option on the Windows GnuCash menu.
This got the standard installation back. I then followed your
original instructions about replacing ASX.pm and ran your check as
follows:
PS C:\WINDOWS\system32> cd "C:\Program Files (x86)\gnucash\bin"
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
Finance::Quote fields Gnucash uses:
symbol: BHP <=== required
date: 10/15/2020 <=== recommended
currency: AUD <=== required
last: 36.77 <=\
nav: <===
Re: [GNC] ASX quotes not working
Hi Geoff, I am still not getting all my stocks retrieved inside GnuCash but I may have made some progress. I checked the stocks not working using gnc-fq-dump and they all retrieved except for one I still had that had been de-listed, so that is as expected, but does not explain why they don't work inside GnuCash. I retrieved them all in one call to gnc-fq-dump and I noticed there was an error message at the start. After a little more digging I found just one stock was causing that problem as follows: PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX 14D Use of uninitialized value in transliteration (tr///) at C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 141. Finance::Quote fields Gnucash uses: symbol: 14D <=== required date: 10/16/2020 <=== recommended currency: AUD <=== required last: 0.145 <=\ nav: <=== one of these price: 0.145 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> It may be that having a stock symbol starting with a number is causing the problem, but it still retrieves OK. It did occur to me that, depending on the order that GnuCash does the retrieving internally, that error may make the program think there are no valid values after that message and explain why some of the stocks are missing in the results. Best regards, John Bonnett On 16/10/2020 9:05 am, John Bonnett wrote: Hi Geoff, I seem to have partly solved my problem. Following up on a comment from Bill and your interest in the version of Perl I was running, I chased up a recent version of Strawberry Perl. I got v5.32.0 64bit and installed that. It still thought I had the older 32bit installed so I tried uninstalling that. This broke the 64bit install, so I repaired it and then ran the "Install Online Price Retrieval for GnuCash" option on the Windows GnuCash menu. This got the standard installation back. I then followed your original instructions about replacing ASX.pm and ran your check as follows: PS C:\WINDOWS\system32> cd "C:\Program Files (x86)\gnucash\bin" PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 10/15/2020 <=== recommended currency: AUD <=== required last: 36.77 <=\ nav: <=== one of these price: 36.77 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> I then tried running "Get Quotes" from inside GnuCash and it seems to have partly worked. Some of my ASX stocks are still not retrieving but others are. I will investigate using gnc-fq-dump and report back. Thanks for your help, John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX quotes not working
Hi Geoff, I seem to have partly solved my problem. Following up on a comment from Bill and your interest in the version of Perl I was running, I chased up a recent version of Strawberry Perl. I got v5.32.0 64bit and installed that. It still thought I had the older 32bit installed so I tried uninstalling that. This broke the 64bit install, so I repaired it and then ran the "Install Online Price Retrieval for GnuCash" option on the Windows GnuCash menu. This got the standard installation back. I then followed your original instructions about replacing ASX.pm and ran your check as follows: PS C:\WINDOWS\system32> cd "C:\Program Files (x86)\gnucash\bin" PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 10/15/2020 <=== recommended currency: AUD <=== required last: 36.77 <=\ nav: <=== one of these price: 36.77 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> I then tried running "Get Quotes" from inside GnuCash and it seems to have partly worked. Some of my ASX stocks are still not retrieving but others are. I will investigate using gnc-fq-dump and report back. Thanks for your help, John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX quotes not working
Strawberry Perl 5.18.2.2-32bit
On 15/10/2020 4:21 pm, Geoff wrote:
Hmmm. I can't reproduce your problem. What version of perl are you
running please John?
> perl -v
Thanks
Geoff
=
On 15/10/2020 4:09 pm, John Bonnett wrote:
Hi Geoff,
I had an error in naming the file. I had a space between the "X" and
the "."! After fixing that I have a different error, so we are making
progress.
It complains about line 138.
$info{$stock,$label} =
%$decoded_json{$label_map{$label}};
I am not familiar with Perl syntax but I guess it does not like the
"%$". It seems to me from the rest of the code that you have one or
the other but not both as a prefix.
I tried just "%" and got lots of errors and then I noticed on line
116 it looked like "$" was right, so I tried that and got this:
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
Global symbol "%decoded_json" requires explicit package name at
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.
Compilation failed in require at (eval 20) line 1.
BEGIN failed--compilation aborted at (eval 20) line 1.
at gnc-fq-dump line 166.
Undefined subroutine ::Quote::ASX::asx called at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.
PS C:\Program Files (x86)\gnucash\bin>
It is curious that, although I have "$decoded_json", it is referring
to "%decoded_json".
Any thoughts?
John
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX quotes not working
Hi Geoff,
I had an error in naming the file. I had a space between the "X" and the
"."! After fixing that I have a different error, so we are making progress.
It complains about line 138.
$info{$stock,$label} = %$decoded_json{$label_map{$label}};
I am not familiar with Perl syntax but I guess it does not like the
"%$". It seems to me from the rest of the code that you have one or the
other but not both as a prefix.
I tried just "%" and got lots of errors and then I noticed on line 116
it looked like "$" was right, so I tried that and got this:
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
Global symbol "%decoded_json" requires explicit package name at
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.
Compilation failed in require at (eval 20) line 1.
BEGIN failed--compilation aborted at (eval 20) line 1.
at gnc-fq-dump line 166.
Undefined subroutine ::Quote::ASX::asx called at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.
PS C:\Program Files (x86)\gnucash\bin>
It is curious that, although I have "$decoded_json", it is referring to
"%decoded_json".
Any thoughts?
John
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ASX quotes not working
Hi Geoff, Tried your instructions but got an error when I tried to test it. Do we need to build libraries again or something? I am not familiar with Perl development. PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Can't locate Finance/Quote/ASX.pm in @INC (you may need to install the Finance::Quote::ASX module) (@INC contains: C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at (eval 20) line 1. BEGIN failed--compilation aborted at (eval 20) line 1. at gnc-fq-dump line 166. Can't locate object method "methods" via package "Finance::Quote::ASX" (perhaps you forgot to load "Finance::Quote::ASX"?) at C:/strawberry/perl/site/lib/Finance/Quote.pm line 120. PS C:\Program Files (x86)\gnucash\bin> Best regards, John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 error: advanced-portfolio (Lipp F.)
On 27/07/2020 11:56 pm, "Lipp F." wrote:
Just installed 4.1 on Windows 10 and advanced portfolio report throws an
error. The report was working fine on 3.10. Here it is:
Report error
An error occurred while running the report.
In c-interface.scm:
24:4 19 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 18 (catch #t # …)
In c-interface.scm:
29:37 17 (_)
In unknown file:
16 (eval-string "(gnc:report-run 9)" #)
In ice-9/boot-9.scm:
2312:4 15 (save-module-excursion #)
In ice-9/eval-string.scm:
38:6 14 (read-and-eval # #:lang _)
In report-core.scm:
689:4 13 (gnc:report-run _)
In c-interface.scm:
66:2 12 (gnc:backtrace-if-exception _ . _)
24:4 11 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 10 (catch #t # …)
In c-interface.scm:
28:40 9 (_)
In report-core.scm:
691:29 8 (_)
673:25 7 (gnc:report-render-html #< type: "21d7cfc59fc7…> …)
In standard/advanced-portfolio.scm:
1057:10 6 (advanced-portfolio-renderer _)
In ice-9/boot-9.scm:
829:9 5 (catch div/0 # …)
In standard/advanced-portfolio.scm:
428:10 4 (table-add-stock-rows #< col-headers: (("A…> …)
In srfi/srfi-1.scm:
640:9 3 (for-each # …)
In standard/advanced-portfolio.scm:
460:21 2 (_ _)
In srfi/srfi-1.scm:
640:9 1 (for-each # …)
In standard/advanced-portfolio.scm:
515:41 0 (_ #)
In procedure module-lookup: Unbound variable: parent-or-sibling?
___
I also have a problem with the same report on Win10 after upgrading to GNC 4.1.
My traceback is slightly different so, in case that matters, here it is.
Report error
An error occurred while running the report.
18 (apply-smob/1 #)
In c-interface.scm:
24:4 17 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 16 (catch #t # …)
In c-interface.scm:
29:37 15 (_)
In unknown file:
14 (eval-string "(gnc:report-run 2)" #)
In ice-9/boot-9.scm:
2312:4 13 (save-module-excursion #)
In ice-9/eval-string.scm:
38:6 12 (read-and-eval # #:lang _)
In report-core.scm:
689:4 11 (gnc:report-run _)
In c-interface.scm:
66:2 10 (gnc:backtrace-if-exception _ . _)
24:4 9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 8 (catch #t # …)
In c-interface.scm:
28:40 7 (_)
In report-core.scm:
691:29 6 (_)
673:25 5 (gnc:report-render-html #< type: "21d7cfc59fc7…> …)
In standard/advanced-portfolio.scm:
1057:10 4 (advanced-portfolio-renderer _)
In ice-9/boot-9.scm:
829:9 3 (catch div/0 # …)
In standard/advanced-portfolio.scm:
428:10 2 (table-add-stock-rows #< col-headers: (("A…> …)
In srfi/srfi-1.scm:
640:9 1 (for-each # …)
In standard/advanced-portfolio.scm:
570:43 0 (_ _)
In procedure module-lookup: Unbound variable: parent-or-sibling?
Best Regards,
John Bonnett
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Get quotes problem with testing version 3.905
On 17/06/2020 10:39 am, Chris Good wrote: Message: 8 Date: Wed, 17 Jun 2020 08:53:24 +0930 From: John Bonnett To: gnucash-user@gnucash.org Subject: Re: [GNC] Get quotes problem with testing version 3.905 Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Here is my previous email with the graphics replaced by some relevant text. I installed v3.905 to help with testing. I have a problem with getting online quotes which worked fine with the latest release version. Everything else has been OK so far. I get this message now: ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US Although that URL provides lots of good information, none of my active stocks, for which I am trying to get online quotes, are using Alphavantage. I do have some inactive/obsolete stocks which are defaulting to Alphavantage. Most of my active stocks are from the Australian exchange ASX. I have one on NASDAQ for which I am using Yahoo-json but that does not seem to work and did not on the release version either. Here are the versions in my About dialog: Version 3.905 Build ID: 3.905+(2020-06-14) Finance::Quote: 1.47 Should I try to remove all reference to Alphavantage from even inactive stocks? John Bonnett Hi John, If you haven't got a free Alpha Vantage API key and do have stocks that need it, you either need to get an API key or untick 'Get Quotes' in the security editor for those stocks using source alphavantage. If you have accounts using multiple currencies, then you also need to untick 'Get Quotes' in the security editor for all the currencies if you don't want exchange rates to be downloaded. 3.905 now gives you an error message rather that failing with an obscure error msg. See https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US Regards, Chris Good Hi Chris, I had noticed those obscure error messages you mention. I have resolved my problem and it was that I had a currency, which I don't remember ever adding. I actually found out about it by examining my data as uncompressed XML and searching for . I then discovered I had to check a box in the security editor to see it in the GUI. I unchecked 'Get Quotes' for it and now the only messages I get are expected ones. Thanks for you help. John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Get quotes problem with testing version 3.905
Here is my previous email with the graphics replaced by some relevant text. I installed v3.905 to help with testing. I have a problem with getting online quotes which worked fine with the latest release version. Everything else has been OK so far. I get this message now: ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US Although that URL provides lots of good information, none of my active stocks, for which I am trying to get online quotes, are using Alphavantage. I do have some inactive/obsolete stocks which are defaulting to Alphavantage. Most of my active stocks are from the Australian exchange ASX. I have one on NASDAQ for which I am using Yahoo-json but that does not seem to work and did not on the release version either. Here are the versions in my About dialog: Version 3.905 Build ID: 3.905+(2020-06-14) Finance::Quote: 1.47 Should I try to remove all reference to Alphavantage from even inactive stocks? John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Get quotes problem with testing version 3.905
I installed v3.905 to help with testing. I have a problem with getting online quotes which worked fine with the latest release version. Everything else has been OK so far. I get this message now: None of my active stocks, for which I am trying to get online quotes, are using Alphavantage. I do have some inactive/obsolete stocks which are defaulting to Alphavantage. Most of my active stocks are from the Australian exchange ASX. I have one on NASDAQ for which I am using Yahoo-json but that does not seem to work and did not on the release version either. Here is my About dialog Should I try to remove all reference to Alphavantage from even inactive stocks? John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 source asx or australia
Retrieving from ASX with more than 10 stocks works for me and has for several years now. Regards, John Bonnett On 1/06/2020 5:11 pm, Chris Good wrote: Hi, Last thing I remember was that finance quote source asx or Australia (which are now the same thing since yahoo stopped working) either didn't work or was unreliable. It seems to be working OK now. So I can update the documentation, can people who use either asx or Australia as source for stock quotes please let me know if it is working reliably now. I'd also like to know if it works reliably with say > 10 stocks. If your unhappy about putting this info on the mailing list, please email me directly atgoodchri...@gmail.com Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 206, Issue 26
I think that is actually an "n" but the column width is chopping it off and making it look like an "r". On 7/05/2020 8:35 am, gnucash-user-requ...@gnucash.org wrote: Subject: Re: [GNC] Why R in Reconcile From: Bruce Irving Date: 7/05/2020, 8:35 am To: Derek Atkins CC: Gnucash Users attached Bruce Preach the Gospel wherever you go. If necessary, use words. On Wednesday, May 6, 2020, 4:08:29 PM MDT, Derek Atkins wrote: HI, On Wed, May 6, 2020 5:57 pm, Bruce Irving via gnucash-user wrote: I just finished reinstalling my OS. In the process, I'm now on 3.10.I am curious. Why is the reconcile column filled with R? It makes it more difficult for me to see what has been cleared or reconciled. Can you show a screen shot? In my register is see 'n', 'c', and 'y' in the Reconciled column. 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 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cycle between basic, autosplit, transaction views?
Hi Frank, Thanks for that. I can see, by looking at my backup, that I have other changes I have lost by the way I modified the correct file. I will patch that up. I am on V3.9 as of earlier today, before I changed the key bindings. Regards, John On 30/03/2020 4:38 pm, Frank H. Ellenberger wrote: Hi John, Am 30.03.20 um 07:41 schrieb John Bonnett: For Windows users, I found that accelerator-map file in C:\Users\john\.gnucash\accelerator-map that was used by Gnucash 2.x, but not by Gnucash 3.x Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cycle between basic, autosplit, transaction views?
For Windows users, I found that accelerator-map file in C:\Users\john\.gnucash\accelerator-map C:\Users\john\AppData\Roaming\GnuCash\accelerator-map and a backup at C:\Users\john\AppData\Roaming\GnuCash.bkp\accelerator-map I followed David's instructions and tried editing the first one. These are the lines I changed. (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" "2") (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleBasicAction" "1") (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleDoubleLineAction" "4") (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleJournalAction" "3") On restarting GNC, nothing had changed so I tried changing the second one. That did the trick when I restarted GNC. I think you may need to do both to have the change propagate over reboots. You will note I also added the double line toggle too. HTH John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem with reconciling
I had a problem like this a while back and a helpful suggestion from the list sorted me out. It was to do with a "phantom screen" as suggested. The problem also showed up as Scheduled transactions not showing up in registers as well. I am running Windows 10 and I have two screens. One is my TV in the next room which I occasionally send videos to. The symptoms I had with reconcile were similar to what has been described. What was actually happening was one of the reconcile dialogs was appearing on the screen in the other room, even though it was not actually turned on. I didn't immediately notice that the little pop-up window would show when you hover over the GC icon on the task bar. With Scheduled transactions, what was happening was the "Since Last Run" dialog was appearing on the invisible screen and, because I was not acknowledging it, the transactions would not appear in the registers but would accumulate in that dialog. The fix is fairly easy once you know what is happening and applies to many other apps than GC. When you hover over that task bar icon and can see the little image of the missing window, click on it. Now you don't see anything when you do that, but you have just made that invisible window the selected one. You can now bring that window to your visible display using the keyboard. My invisible window was to the left (you can move the displays around in "Display Settings") so I need to move it to the right, so I key Win-Shift-Right and the missing dialog appears. Of course if it needs to move to the left, use Win-Shift-Left. Win is that special "Windows" key and Left and Right are the arrow keys. This is not a GnuCash problem and applies to other apps too, with a similar solution. If you are not on Windows I am sure the other OSs have similar facilities. John --- Sounds like the window is on a phantom screen, still running but not visible. Have you used a second monitor on this system? I don't recall the fix for this problem... David BTW, operating system and Gnucash version number usually help list users help you. On November 15, 2019, at 2:41 AM, Don Young wrote: I recently started having problem reconciling an account. I get the reconcile information screen come upwith the statement date and an ending balance which I can change but as soon as I press "OK" the reconciling process terminates but leave button of the Account name in the Task View bar at the bottom of the screen, but that button will not open. When I put the cursor over the button I see the reconcile screen in a small window. I have upgraded my GnuCash the latest version and have also tried closing the book and starting over with the accounts by exporting and import the accounts. The problem persists. Thanks for any help in advance. Don ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please seehttps://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled Trans shows completed 5/8 but not in register?
I recently had a problem like this and discovered what was happening. I also had a problem with reconcile apparently freezing. It turns out the same thing fixed both. I raised the latter problem on this list and another user told me to make sure I did not have another dialog open, perhaps on another invisible screen. I checked and found the "add interest" dialog was on another screen. Getting that back and closing it fixed my reconcile problem. Also on the other screen was the scheduled transactions "since last run" dialog which seemed to be accumulating scheduled transactions, waiting for me to acknowledge them before entering them in the registers. They were showing as recently last occurred in the scheduled transactions register but were not in the account registers. Getting that dialog back to the main screen, and acknowledging it, entered all the missing transactions. Perhaps you have something like this? John Bonnett On 19/05/2019 3:14 am, Jack Slater wrote: I closed both register window and GC but scheduled transaction (showing last occur 5/8) is not found. Must be a bug! Anything else I can tell you? On Fri, May 17, 2019 at 7:06 AM Maf. King wrote: On Friday, 17 May 2019 12:48:56 BST David Carlson wrote: Jack, I seem to recall that under certain unusual circumstances such. As if the computer crashes after Since Last Run executes but before Gnucash saves the file this might happen. However, I have not tried it. It would help to know more details. David Carlson I think there's a glitch / bug somewhere that an SX running fails to update the register view. try closing & re-opening the register, and / or GC see if that shows up the missing txn. 0.02 Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Hang at start of reconcile
On 13/05/2019 8:59 pm, Maf. King wrote: On Monday, 13 May 2019 12:20:45 BST John Bonnett wrote: I am running the latest GC v3.5 on Windows 10. I have been using GC for quite a while but I just recently have had a problem reconciling one account. It is, of course, the account with most transaction activity! What happens is that, when I initiate the reconcile, the small window for entry of the ending balance appears but almost immediately greys out. At that point the program is unresponsive, and stays that way even if I leave it for an hour or so. The Task Manager shows the program running but using no CPU. I can make it use some CPU time by moving the mouse cursor over the window, so it is not completely frozen. This behavior only occurs with one account. I reconciled a couple of other accounts in the same session before I encountered this problem. I have also reconciled another one since. Suspecting that the account may be damaged, I ran check & repair on all accounts, but that did not help. I have tried restarting GC and rebooting to no avail. I tried turning on the trace file with --debug and --extra, in case I might see some messages at the end, but I don't see anything helpful. I get 15Mb trace files. Any suggestions about what to try? I am a software developer so am happy to try whatever you suggest and provide other info. Some small dialogue box opening behind another (or off screen) and blocking input? 0.02 Maf.. Yes, it was the interest dialog box coming up on my TV in the next room! I have been caught by that before and did not think about it in this case. Thanks again. John ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Hang at start of reconcile
I am running the latest GC v3.5 on Windows 10. I have been using GC for quite a while but I just recently have had a problem reconciling one account. It is, of course, the account with most transaction activity! What happens is that, when I initiate the reconcile, the small window for entry of the ending balance appears but almost immediately greys out. At that point the program is unresponsive, and stays that way even if I leave it for an hour or so. The Task Manager shows the program running but using no CPU. I can make it use some CPU time by moving the mouse cursor over the window, so it is not completely frozen. This behavior only occurs with one account. I reconciled a couple of other accounts in the same session before I encountered this problem. I have also reconciled another one since. Suspecting that the account may be damaged, I ran check & repair on all accounts, but that did not help. I have tried restarting GC and rebooting to no avail. I tried turning on the trace file with --debug and --extra, in case I might see some messages at the end, but I don't see anything helpful. I get 15Mb trace files. Any suggestions about what to try? I am a software developer so am happy to try whatever you suggest and provide other info. John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Updated to 3.1 - lost lots & report
Hi Geert, I have done as you suggested and I got this window along with the usual ones The trace file has this * 14:26:19 WARN error reading group Page 1 key ShowUnused: Key file does not have key “ShowUnused” in group “Page 1” * 14:26:31 WARN [xaccQueryAddAccountMatch()] acct_list has NULL account That second message appears in other trace files and looks like I have a null account. The first message is new. The program seems to be working OK. Is it safe for me to continue with this version or should I revert to the released v3.1? Let me know if you would like me to try anything else. John On 21/06/2018 1:16 AM, Geert Janssens wrote: Thanks for the response. The trace indeed has no messages related to migration. In retrospect it couldn't have :( The migration code itself runs before logging is set up. So any message printed during migration would be sent to the console, but on windows that is not available. There are several other clues though the migration didn't run: - no pop-up window summarizing the migration results - missing saved report configurations - warnings about missing .gcm file I dug into the code and found I already fixed one issue that would prevent the migration right after the release of gnucash 3.1. Can you retry the procedure with a recent nightly build ? For example this one; https://code.gnucash.org/builds/win32/maint/gnucash-3.1-2018-06-18-git-3.1-171-g1e3a44500+.setup.exe Make a backup of your active gnucash book, install this version, move c:\Users \\AppData\Roaming\GnuCash out of the way and start gnucash. Do you see a migration summary window in this case ? Regards, Geert Op zondag 17 juni 2018 03:18:02 CEST schreef Ethan Swint: My response at bottom of post. Message: 3 Date: Sat, 16 Jun 2018 10:53:06 +0200 From: Geert Janssens To: gnucash-user@gnucash.org Cc: John Bonnett Subject: Re: [GNC] Updated to 3.1 - lost lots & report Message-ID: <1761733.q6rmsms...@legolas.kobaltwit.lan> Content-Type: text/plain; charset="us-ascii" Op donderdag 14 juni 2018 10:37:31 CEST schreef John Bonnett: I found it at this path "C:\Users\\.gnucash" Gnucash 3.1 is supposed to migrate from this directory to c:\Users\\AppData\Roaming\GnuCash I don't know why this didn't happen for you. in it I found this file "C:\Users\\.gnucash\saved-reports-2.4" which looked a bit suspicious. In it I found Scheme code for my missing reports. Another folder I found in my search was "C:\Users\\AppData\Roaming\GnuCash" Now this Roaming folder often holds configuration information on Windows. It also had recently dated files in it so was probably related to my recent installation of GnuCash 3.1. This directory should be generated as part of the first-time run of gnucash 3.1. Can you do an experiment to help evaluate the migration step ? Can you 1. quit gnucash if it's still running 2. rename "C:\Users\\AppData\Roaming\GnuCash" to "C:\Users\\AppData\Roaming\GnuCash.bkp" That moves it out of the way of gnucash. 3. Start gnucash => Does it report a migration of meta data ? 4. Quit gnucash 5. Locate the most recent trace file [1] and post it here. I copied the above mentioned saved reports file to "C:\Users\\AppData\Roaming\GnuCash\saved-reports-2.4" and next time I opened GnuCash my reports had returned. Indeed. You manually completed the migration. I would like to figure out why this didn't happen in the first place. Thanks, Geert --- Geert - Thanks for the suggestion - trace file contents below. I didn't see any note about migration of metadata, and Gnucash did not migrate my old reports or lots. The manual migration works, however. Thanks for the responses! Regards, Ethan * 15:42:37 WARN error reading group Page 12 key ShowUnused: Key file does not have key “ShowUnused” in group “Page 12” * 15:42:41 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 15:42:41 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 15:42:41 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 15:42:41 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 15:42:41 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 15:43:59 CRIT [gnc_state_save()] Error: Failure saving state file. Cannot open file C:\Users\XX\AppData\Roaming\GnuCash\books\XXX.gnucash.gcm: No such file or directory * 15:43:59 CRIT Cannot open file C:\Users\X\AppData\Roaming\GnuCash\expressions-2.0: No such file or directory * 15:43:59 WARN Can't save style sheet ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or
[GNC] Updated to 3.1 - lost lots & report
From: Ethan Swint Date: 14/06/2018 3:18 PM Hi - I just made the jump from 2.6 to 3.1, but I found that I lost all of my lot info for stocks and my saved report configurations. My google-fu is not good WRT scanning the list, so if any have encountered similar situation, I'd be much obliged. Thanks! I did the upgrade to 3.1 and also lost my reports. Here is what I did to get them back after looking at some comments by others on the mailing list. By the way I am on Windows 10. I searched using Jam UltraSearch for files and folders with "gnucash" in them. I found quite a few but one in particular was ".gnucash", notice the initial "." which is a convention in Linux for a configuration folder. I found it at this path "C:\Users\\.gnucash" in it I found this file "C:\Users\\.gnucash\saved-reports-2.4" which looked a bit suspicious. In it I found Scheme code for my missing reports. Another folder I found in my search was "C:\Users\\AppData\Roaming\GnuCash" Now this Roaming folder often holds configuration information on Windows. It also had recently dated files in it so was probably related to my recent installation of GnuCash 3.1. I copied the above mentioned saved reports file to "C:\Users\\AppData\Roaming\GnuCash\saved-reports-2.4" and next time I opened GnuCash my reports had returned. I have replaced my username in the above with as yours will likely be different. Hope this helps. John Bonnett ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
