[GNC] Errors after restarting GnuCash 4.10 from terminal or bash script

2022-05-09 Thread davidcousens49
I have just setup getting finance quotes for Gnucash for the first time for GC 4.10 on Linux Mint 20.3. I was setting up a shell script to shutdown GnuCash, update the finance quotes and restart GnuCash after the quotes had been written to the datafile. The finance quote seems to work ok but when

[GNC] Setting Currency Format when importing from CSV?

2022-05-09 Thread viking2ev
The CSV Transaction Importer only has 3 options for currency format: Locale, Comma and Period. Is there some way to change it to something else? For example in the CSV file, I have "10 550,50" which would translate to "10,500.50" (in the US). Can I make GnuCash translate this properly?

Re: [GNC] default local currency

2022-05-09 Thread David Long
Hi, Actually, I tried a re-install, thinking I had missed a trick in the installation process, but exactly the same. Regards David From: David H Sent: May 10, 2022 11:45 AM To: David Long Cc: Gnucash Users Subject: Re: [GNC] default local currency Ah yeah forget that :-)

Re: [GNC] default local currency

2022-05-09 Thread Adrien Monteleone
Preferences > Accounts > Default Currency. Your choices are: 1. Locale (set by your OS preferences) 2. Specify one from the drop down. Regards, Adrien On 5/9/22 10:20 PM, David Long wrote: I have been using GnuCash on a Desktop, and installed it on my laptop too. It was a messy installation

Re: [GNC] default local currency

2022-05-09 Thread David H
Ah yeah forget that :-) On Tue, 10 May 2022 at 13:42, David H wrote: > Preferences >> Accounts >> Default Currency in Gnucash 4.10 ??? > > Cheers David H. > > > On Tue, 10 May 2022 at 13:21, David Long > wrote: > >> >> >> >> >> >> >> I have been using GnuCash on a Desktop, and installed it on

Re: [GNC] default local currency

2022-05-09 Thread David H
PS what is your locale currency set to ?? Cheers David. On Tue, 10 May 2022 at 13:42, David H wrote: > Preferences >> Accounts >> Default Currency in Gnucash 4.10 ??? > > Cheers David H. > > > On Tue, 10 May 2022 at 13:21, David Long > wrote: > >> >> >> >> >> >> >> I have been using GnuCash

Re: [GNC] default local currency

2022-05-09 Thread David H
Preferences >> Accounts >> Default Currency in Gnucash 4.10 ??? Cheers David H. On Tue, 10 May 2022 at 13:21, David Long wrote: > > > > > > > I have been using GnuCash on a Desktop, and installed it on my laptop too. > It was a messy installation , probably due to a hardware issue, so I did >

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread Adrien Monteleone
Except it didn't matter if I waited a minute or so in between each call. It even failed some days on the first call. That's what had me stumped. But yeah, if another sources works reliably, it is probably the source and not F::Q. Regards, Adrien On 5/9/22 9:49 PM, David T. via gnucash-user

[GNC] default local currency

2022-05-09 Thread David Long
I have been using GnuCash on a Desktop, and installed it on my laptop too. It was a messy installation , probably due to a hardware issue, so I did not go through a normal GnuCash routine for setting up a new set of accounts. However, I managed to open GnuCash and upload the GnuCash

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Your reply strongly suggests that you were getting throttled by Alphavantage retrieval limits. The fact that one Alphavantage quote was quick, but 10 took much longer supports my hypothesis. The fact that yahoo_json appears to have fixed the time lag also supports it. On May 9, 2022 2:12:07

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Adrien, Your experience suggests the Alphavantage throttle I mentioned in my post. I seem to recall that being an issue specifically with currencies on that source. David On May 9, 2022 12:45:04 PM EDT, Adrien Monteleone wrote: >Fred, > >See my reply in your 'Hang' thread. > >As soon as I

Re: [GNC] Shutdown using the "X" in windows 11

2022-05-09 Thread Glenn Fowler
Hi, Just checking if someone has posted or was going to post a bug report on Bugzilla. I don't mind doing it but didn't want to start if someone else is already in progress. On Sun, Apr 24, 2022 at 7:18 PM Gyle McCollam wrote: > Using Windows 11 and GnuCash 4.10 > > Also had this issue in an

Re: [GNC] Calculation of Unrealized Losses

2022-05-09 Thread Bill Dika
Thank you John. I will look into it. Bill Dika On Thu, May 5, 2022 at 4:48 PM John Ralls wrote: > David is referring to https://bugs.gnucash.org/show_bug.cgi?id=797796, > which is probably the issue you're seeing: You have some three-commodity > transactions involving USD, CAD, and a Vanguard

Re: [GNC] GnuCash 4.10

2022-05-09 Thread Richard Clarkson via gnucash-user
Adrien No, I was on 4.9. I've managed to get back to 4.9 now with no problem getting the GnuCash.exe to work. I tried looking at the registry and resetting .exe etc to default settings. As soon as I try to upgrade to 4.10-1 I get the problem that the exe file doesn't work. It looks like it's

Re: [GNC] GnuCash 4.10

2022-05-09 Thread Adrien Monteleone
So you originally jumped from 3.11 to 4.10? If 4.0 works, did you run Actions > Check & Repair > Check & Repair all after the upgrade to 4.0? (you should do that after each major version jump) Regards, Adrien On 5/9/22 1:16 PM, Richard Clarkson via gnucash-user wrote: Reverting to GnuCash

Re: [GNC] Importing Accounts with non-English Characters

2022-05-09 Thread Frank H. Ellenberger
I fear Windows 7 is too old and also no longer mainained by MS. Am 09.05.22 um 20:01 schrieb viking...@san.rr.com: > I am using Windows 7 Is there such a setting in WIN7? I haven’t been able > to find it. > ___ gnucash-user mailing list

Re: [GNC] GnuCash 4.10

2022-05-09 Thread Richard Clarkson via gnucash-user
Reverting to GnuCash 3.11 works perfectly. Upgrading from that to GnuCash 4.0 works but only after clicking through lots of error messages. Upgrading to GnuCash 4.10-1 doesn’t work at all. Bizarre! Ran DISM Restore Health and sfc /scannow but no change. Will wait for next update to see

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread Fred Tydeman
On Mon, May 9, 2022 at 9:22 AM David T. wrote: > To answer this question, the security editor screen can be configured to > show both the Get Quotes toggle, as well as the price source. Resizing the > default tiny screen bigger will show you the drop down button on the far > right, which

Re: [GNC] Importing Accounts with non-English Characters

2022-05-09 Thread viking2ev
@Frank, I am using Windows 7 Is there such a setting in WIN7? I haven’t been able to find it. -Original Message- From: Frank H. Ellenberger [mailto:frank.h.ellenber...@gmail.com] Sent: 09 May, 2022 08:15 To: viking...@san.rr.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC]

Re: [GNC] Configuration dilemma -- How best to share Gnucash between 2 users

2022-05-09 Thread Derek Atkins
Hi, On Mon, May 9, 2022 12:57 pm, Westshire Realty wrote: > Small business (2 mac users) wishing to share a gnucash db over network > share volume. Question is what are the respective do’s and donts. > > Would one application AND data file(s) installed on shared volume work > best. What happens

[GNC] Configuration dilemma -- How best to share Gnucash between 2 users

2022-05-09 Thread Westshire Realty
Small business (2 mac users) wishing to share a gnucash db over network share volume. Question is what are the respective do’s and donts. Would one application AND data file(s) installed on shared volume work best. What happens to application support files usually found in library folder of

Re: [GNC] Budget Reporting

2022-05-09 Thread Adrien Monteleone
On 5/7/22 8:39 AM, iwaddo via gnucash-user wrote: I’m new to gnucash so please let me know if this is not the correct way to get support. This is *one* of the right places. IRC is another option. I have successfully entered all my transactions back to Oct 21, everything balances as I

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Robert Heller
At Mon, 9 May 2022 11:19:48 -0500 adrien.montele...@lusfiber.net wrote: > > If I recall correctly, the original plan was to stop 32-binaries & > installers for 18.04, but the outcry resulted in a back-track. > (thankfully, too many good machines in perfect working order out there, > I manage

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread Adrien Monteleone
Fred, See my reply in your 'Hang' thread. As soon as I got my second hang in GnuCash, I resorted to CLI, keeping GnuCash Price DB open to check each of the symbols one-by-one. F::Q/Alphavantage would hang on the CLI too for random symbols. Sometimes it would instantly retrieve say USD->EUR,

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Adrien Monteleone
Check out the GnuCash Wiki concerning using the Debian Archive: https://wiki.gnucash.org/wiki/Ubuntu#GnuCash_.40_Debian_Archive It is linked there, but you can look at the list of available .deb packages here: http://ftp.us.debian.org/debian/pool/main/g/gnucash/ Theoretically, you could

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Fred, To answer this question, the security editor screen can be configured to show both the Get Quotes toggle, as well as the price source. Resizing the default tiny screen bigger will show you the drop down button on the far right, which includes a number of fields for display. For the

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Adrien Monteleone
If I recall correctly, the original plan was to stop 32-binaries & installers for 18.04, but the outcry resulted in a back-track. (thankfully, too many good machines in perfect working order out there, I manage several.) The big push was Steam, but there were some other libraries that needed

Re: [GNC] Large GnuCash file very slow to write to

2022-05-09 Thread Adrien Monteleone
'Saves' with SQLite are supposed to be instant. That is, all commits on changes happen right away, not on a schedule or only on exit. (same with the other two db backends, and those are more difficult to manage/administer) If you've removed Piecash temporarily from the workflow, and it still

Re: [GNC] Get Quotes hangs

2022-05-09 Thread Adrien Monteleone
I had similar problems on MacoS BigSur just before and after the release of 4.10, and it would hang either via GnuCash or via CLI. I figured it was just a F::Q or Alphavantage problem. And indeed, it cleared up, but I haven't tried it lately. Regards, Adrien On 5/8/22 9:17 PM, Fred Tydeman

Re: [GNC] Importing Accounts with non-English Characters

2022-05-09 Thread Frank H. Ellenberger
Another "workaround" is described in https://bugs.gnucash.org/show_bug.cgi?id=782850#c11 That "fixing of Windows" has only to be done once, not for each file. Perhaps I should have sent you directly to that bug instead of ssending a link that again links there. Regards Frank Am 09.05.22 um

[GNC] List of securities with Get Online Quotes

2022-05-09 Thread Fred Tydeman
Is there a way to get a report of all the securities that have Get Online Quotes checked? Perhaps I have a bad Symbol/abbreviation and that is what is causing the Get Quotes to hang. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread Robert Heller
*I* know for sure that Ubuntu 18.04 will run on a 32-bit machine (I have it on a VM). The deal is this: Ubuntu no longer provides *installers* for 32-bit machines -- I believe 16.04 is the last version of Ubuntu that includes installer / live CD ISOs for 32-bit machines. Once you have a

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread David T. via gnucash-user
Jonathan, I'm not a Linux person, but a search online turned up https://askubuntu.com/questions/768415/where-can-i-find-32-bit-version-of-ubuntu Which suggested that 18.04 was available for 32-bit: https://cdimage.ubuntu.com/xubuntu/releases/18.04.5/release/xubuntu-18.04.5-desktop-i386.iso

Re: [GNC] Importing Accounts with non-English Characters

2022-05-09 Thread viking2ev
I found a workaround (in case anyone else has the same issue): I opened the UTF-8 encoded CSV file in Notapad++, selected "Encoding|convert to ANSI" and saved the file. I could then import the CSV file into GnuCash without the Account names being "corrupted". -Original Message- From:

Re: [GNC] Large GnuCash file very slow to write to

2022-05-09 Thread Tim Hume via gnucash-user
In case anyone is interested, I think I found where the slowness of my Python script occurs. Piecash uses something called SQLAlchemy, and it seems the slowness is in this package when committing new data to the database. I'm going to put up with the slowness. I only import new transactions to

Re: [GNC] Large GnuCash file very slow to write to

2022-05-09 Thread Tim Hume via gnucash-user
Hi people, I guess the underlying issue is probably Piecash - or possibly the way it interacts with SQLite. Though GnuCash itself is pretty slow at exit time too (maybe 30 seconds to a minute) - but not in the same league of slowness as my Python program using Piecash. I was simply hoping