[GNC] GnuCash 5.1-2 for macOS
There's a gtk3 regression in Gnucash-5.1-1. Nobody's reported hitting it yet, but it's there: I left a patch out when I updated gtk3 to 3.34.37 just before the 5.1 release. I've re-packaged with a correctly-patched library. This also has a patch to fix https://bugs.gnucash.org/show_bug.cgi?id=798906 for those users with a dual-monitor setup where one monitor is Retina and the other isn't. 65a67bdffbe2d50e5dbe69b7193acfde6d8964a0fbd631edfd0d064fbaea03d3 Gnucash-Intel-5.1-2.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.1/Gnucash-Intel-5.1-2.dmg https://github.com/Gnucash/gnucash/releases/download/5.1/Gnucash-Intel-5.1-2.dmg Regards, John Ralls ___ 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] Yahoo JSON - throwing unauthorized error
In case someone doesn't like yahoo_json (don't have to wait until their releases are synched up on all CDN servers and prime time ready) and Alphavantage (beat the throttling wait) ... the python way. Working on multi-threaded one to make it faster ... https://github.com/ka-patel/dl_quotes -- Message: 1 Date: Mon, 8 May 2023 15:18:40 -0400 From: "John Layman" To: "'R Losey'" , "'David G. Pickett'" Cc: Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Message-ID: <01d981e1$e67c22a0$b37467e0$@laymanandlayman.com> Content-Type: text/plain; charset="utf-8" I used to get prices from Alphavantage but switched to Yahoo JSON somewhere along the line. My recent switch back to Alphavantage was a failure until I brought F::Q up to date. It's slow for the 40 quotes I routinely fetch, but I think I need to re-acclimate to the slowness. It appears to me that Yahoo has intended all along to fully monetize their service and the loopholes are just oversight on their part. So I am giving up on Yahoo as a source. I do however daily download prices into Excel using the new financial market information data type of Microsoft 365. It's just a trial, and I am invested in a rather new American bond fund whose ticker goes unrecognized, but it might ultimately provide a means of putting together an alternative method of importing quotes. -Original Message- From: gnucash-user On Behalf Of R Losey Sent: Monday, May 8, 2023 2:06 PM To: David G. Pickett Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Others will probably report this, but Alphavantage has a built-in one minute delay for every 5 (I think 5)prices you look up; for example: 4 stocks: may take 7 seconds; 6 proces: 1 minute, 7 seconds; 12 prices: 2 minutes, 10 seconds... I am talking about the free version of Alphavantage, but the way. On Sat, May 6, 2023 at 3:08?PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > PS: I give up on Yahoo! > Switching all my securities to Alphadvantage was tiresome, as the gui > was no responsive to the keyboard, but I found the source could be > found using page up. Some display at the security editor main screen > or somewhere would help to see which is running quotes where, how many currently owned. > I have many stocks not currently owned, and so they should not be quoted. > I got more info out of an strace. Having the security editor sort each > list might be much nicer, too. Ditto for the portfolio report. Most > reports in this world sort left to right, for some silly reason. > > Now it is so slow, and while some work, it locks up on some security. > Maybe it needs a timeout error? I resolves the host name over and over. > Eventually only perl is running, and then nothing. It takes a long > time just to get to "Found Finance::Quote version 1.5301." I ran an > strace on the batch quotes, found a few stocks still on Yahoo by > accident (but yahoo was at least not hanging), reran, still running, > showing occasional activity, but really slow, so slow I was sure it > was dead, but no! I can send the strace if it would help! The yahoo > when working ran all my stocks in a few seconds. OK for midnight > crontab but for the get quotes button is too slow. > dgp@dgp-p6803w:~$ time trussx flatpak run --command=gnucash-cli > org.gnucash.GnuCash --quotes get -- > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2>tmp/quote.trFound > Finance::Quote version 1.5301. > real6m3.619suser0m5.033ssys 0m12.509sdgp@dgp-p6803w:~$ time > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- > /home/dgp/GnuCash/ubuntu-DGPickett.gnucashFound Finance::Quote version > 1.5301. real5m15.338suser0m0.056ssys 0m0.025sdgp@dgp-p6803w > :~$ > I can send the strace, or make an strace, optionally with usec time > stamps, if desired. POGSX did not have a 5/5 quote, only 5/4 for some > reason! > > -Original Message- > From: David G. Pickett > To: gnucash-user@gnucash.org > Sent: Sat, May 6, 2023 1:51 pm > Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error > > Yeah, it's back. >- Is Yahoo aware of their server rejects? >- Is there some magic cookie or such we need to be authorized? > Many previous fixes proposed, which did not seem to prevent its return! > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription
Re: [GNC] How to upgrade to 5.1 in Ubuntu
Thanks, I have some experience with flatpak, albeit some of of it negative. I suppose I should uninstall my apt installed version 4.8 first first then, correct? On 2023/05/08 20:02, Carsten Hütter wrote: Hello Roland! To being able to keep GnuCash up to date, you should install a flatpak version. The wiki tells you how to do that. GnuCash wiki flatpak German: https://wiki.gnucash.org/wiki/De/Flatpak My preferred way is to download the flatpak package from the GnuCash build-server. GnuCash build-server GnuCash 5.1 (release) flatpak: https://code.gnucash.org/builds/flatpak/stable/gnucash-stable-C5.1-D5.1.flatpakref To quickly get bug corrected nightly flatpaks, you can choose one of the other ones in: https://code.gnucash.org/builds/flatpak/stable/ E. g. the lastest nightly build GnuCash 5.1-14: https://code.gnucash.org/builds/flatpak/stable/gnucash-stable-C5.1-14-g73337cff5a-D5.1.flatpakref The tarball only holds the source code, so you have to compile it by yourself on your system. Can be done, but is a lot more cumbersome. BTDT... HTH! Regards Carsten Am 08.05.23 um 10:13 schrieb Roland Giesler via gnucash-user: Hi all, I'm looking for some details on how to upgrade to GNUCash 5.1 on Ubuntu 22.04. I installed GNUCash from the repositories (v 4.8), but the new version is not in the repos yet. So, if I install manually, I'll probably end up having both versions installed, not? Question 1: Is there a Debian or Ubuntu repository somewhere that I could install from? Question 2: Failing q1 above, should I uninstall my GNUCash and then install from the tarball? thanks in advance for your valued responses! Roland ___ 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 upgrade to 5.1 in Ubuntu
Apologies for the duplicate, I received a message from the list that my mail could not be delivered (error 450) claiming by address was not verified... It seems it was a temporary error. On 2023/05/09 18:12, Roland Giesler via gnucash-user wrote: Hi all, I'm looking for some details on how to upgrade to GNUCash 5.1 on Ubuntu 22.04. I installed GNUCash from the repositories (v 4.8), but the new version is not in the repos yet. So, if I install manually, I'll probably end up having both versions installed, not? Question 1: Is there a Debian or Ubuntu repository somewhere that I could install from? Question 2: Failing q1 above, should I uninstall my GNUCash and then install from the tarball? thanks in advance for your valued responses! Roland ___ 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.
[GNC] How to upgrade to 5.1 in Ubuntu
Hi all, I'm looking for some details on how to upgrade to GNUCash 5.1 on Ubuntu 22.04. I installed GNUCash from the repositories (v 4.8), but the new version is not in the repos yet. So, if I install manually, I'll probably end up having both versions installed, not? Question 1: Is there a Debian or Ubuntu repository somewhere that I could install from? Question 2: Failing q1 above, should I uninstall my GNUCash and then install from the tarball? thanks in advance for your valued responses! Roland ___ 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] Turn of drop list when entering data in memo/description line
Am 08.05.2023 um 22:31 schrieb Geert Janssens: Carsten, Do you already have gnucash installed from flathub or only from code.gnucash.org? To update with this procedure, you'd need to have the flathub gnucash package installed. Yes, done that beforehand. And I don't know what happens if you have gnucash installed from multiple repositories. That may need some extra consideration... Yes, right now there are both code.gnucash.org and flathub flatpaks installed. Maybe that arises the issue. But at this time this quirk has a very low personal priority. Nevertheless, thank you very much! Desalniettemin heel erg bedankt voor je moeite! [...] Vele groeten Carsten ___ 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] Auto commit with auto save?
One of the remarkably slick features of Microsoft Money was that it kept track of the last date on which it downloaded a day's adjusted close, and worked forward from that to the present whenever there was a gap. -Original Message- From: gnucash-user On Behalf Of David T. via gnucash-user Sent: Monday, May 8, 2023 3:00 PM To: David G. Pickett Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Auto commit with auto save? Yes, one can imagine that. I can imagine that it would be possible to add something like that into the get quotes function that already exists, but I'm not a programmer, so I accept that if I want to track commodity values in GnuCash, I have to click the get quotes button. The get quotes button is as close to a listening socket as I'll get. I'm curious-- does auto save complete its process if a transaction is open? I'd imagine that it doesn't. You might want to check on that. It would be a drag to discover after the fact that a series of edits were lost because auto save didn't complete-- especially if you're going to keep using an external cron job script that relies on an unrelated function (auto save) to preserve your financial data. David T. On May 8, 2023, 5:55 PM, at 5:55 PM, "David G. Pickett" wrote: >I use auto save, and if the app is running, the cron kills it and >removes the lock before running the quote fetch. > >One can imagine the app having a listening socket to let you ask it to >get quotes from a cron script. Or having it maintain a schedule where >it gets all quotes, like an internal crontab. > > >-Original Message- >From: David T. >To: David G. Pickett >Cc: David G. Pickett via gnucash-user >Sent: Sun, May 7, 2023 11:34 pm >Subject: Re: [GNC] Auto commit with auto save? > >Nope and nope. Sorry. > >It seems to me that leaving GnuCash open and running a con job against >the open app is a recipe for troubles just like the ones you have >encountered. You could tell the script to abort if it found the lock >file, but that would require you to close the app every night, which >you're not doing now. > >David T. On May 7, 2023, at 9:25 PM, "David G. Pickett" > wrote: >Any suggestions on a) how a shell script tells that the auto save is >incomplete, b) even if it knew, what it could do about it? > > > -Original Message- > From: David T. > To: David G. Pickett > Cc: gnucash-user@gnucash.org > Sent: Sun, May 7, 2023 1:28 am > Subject: Re: [GNC] Auto commit with auto save? > >I agree that it would be nice to have some visual cue that a >transaction has been edited but not saved; that would be useful. I'm >honestly not sure why that hasn't been implemented. > >The app does throw a dialog onscreen when a user tries to save with an >open transaction. Unfortunately, the message is generic, and a user is >forced to look through the open tabs and try to figure out which >register holds this transaction. Others have commented on this in the >past. > >If I recall correctly, you were having trouble because you have a cron >job set up to retrieve quotes at a specified time each day, and this >job causes the file to close dirty if there is an open transaction. The >problem in this case, is that this cron job doesn't have necessary >fault testing and tolerance. I'd suggest working on ensuring that this >cron job was properly set up to handle your specific situation. > >David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via >gnucash-user" < gnucash-user@gnucash.org> wrote: >"Don't do that!" does not prevent data loss from human error, which for >this app behavior is too easy to create and not realize. > > > >If the commit was automatic every time you modified a transaction when >the new state was valid, then I would not leave the tab in an >uncommitted state, but that is not how it was devised. I leave because >it looks fine. There is no indication of an uncommitted transaction I >can see. In terms of human factors, one might go to another tab for >information to complete a transaction, so we do not want to prevent the >user leaving a tab with an uncommitted, possibly invalid transaction. >Maybe we should color the tab red while in this state? Or pop up a >dialog if it persists a bit too long, or if auto save fires on its >timer? But the user may have left, trusting in auto save, so I suggest >an auto commit if valid on auto save. > >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
Re: [GNC] Yahoo JSON - throwing unauthorized error
I used to get prices from Alphavantage but switched to Yahoo JSON somewhere along the line. My recent switch back to Alphavantage was a failure until I brought F::Q up to date. It's slow for the 40 quotes I routinely fetch, but I think I need to re-acclimate to the slowness. It appears to me that Yahoo has intended all along to fully monetize their service and the loopholes are just oversight on their part. So I am giving up on Yahoo as a source. I do however daily download prices into Excel using the new financial market information data type of Microsoft 365. It's just a trial, and I am invested in a rather new American bond fund whose ticker goes unrecognized, but it might ultimately provide a means of putting together an alternative method of importing quotes. -Original Message- From: gnucash-user On Behalf Of R Losey Sent: Monday, May 8, 2023 2:06 PM To: David G. Pickett Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Others will probably report this, but Alphavantage has a built-in one minute delay for every 5 (I think 5)prices you look up; for example: 4 stocks: may take 7 seconds; 6 proces: 1 minute, 7 seconds; 12 prices: 2 minutes, 10 seconds... I am talking about the free version of Alphavantage, but the way. On Sat, May 6, 2023 at 3:08 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > PS: I give up on Yahoo! > Switching all my securities to Alphadvantage was tiresome, as the gui > was no responsive to the keyboard, but I found the source could be > found using page up. Some display at the security editor main screen > or somewhere would help to see which is running quotes where, how many > currently owned. > I have many stocks not currently owned, and so they should not be quoted. > I got more info out of an strace. Having the security editor sort each > list might be much nicer, too. Ditto for the portfolio report. Most > reports in this world sort left to right, for some silly reason. > > Now it is so slow, and while some work, it locks up on some security. > Maybe it needs a timeout error? I resolves the host name over and over. > Eventually only perl is running, and then nothing. It takes a long > time just to get to "Found Finance::Quote version 1.5301." I ran an > strace on the batch quotes, found a few stocks still on Yahoo by > accident (but yahoo was at least not hanging), reran, still running, > showing occasional activity, but really slow, so slow I was sure it > was dead, but no! I can send the strace if it would help! The yahoo > when working ran all my stocks in a few seconds. OK for midnight > crontab but for the get quotes button is too slow. > dgp@dgp-p6803w:~$ time trussx flatpak run --command=gnucash-cli > org.gnucash.GnuCash --quotes get -- > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2>tmp/quote.trFound > Finance::Quote version 1.5301. > real6m3.619suser0m5.033ssys 0m12.509sdgp@dgp-p6803w:~$ time > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- > /home/dgp/GnuCash/ubuntu-DGPickett.gnucashFound Finance::Quote version > 1.5301. real5m15.338suser0m0.056ssys 0m0.025sdgp@dgp-p6803w > :~$ > I can send the strace, or make an strace, optionally with usec time > stamps, if desired. POGSX did not have a 5/5 quote, only 5/4 for some > reason! > > -Original Message- > From: David G. Pickett > To: gnucash-user@gnucash.org > Sent: Sat, May 6, 2023 1:51 pm > Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error > > Yeah, it's back. >- Is Yahoo aware of their server rejects? >- Is there some magic cookie or such we need to be authorized? > Many previous fixes proposed, which did not seem to prevent its return! > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Untick multiple checkboxes in Importer
I'm not at a machine right now, but what happens if you CTRL-click? Same: I can select individual records, however tick/untick action works only on the last one. -- With regards, A ___ 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.