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

[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 that maybe someone else had experienced this and might have 
some tips - I realise this mailing list is for GnuCash, but given Piecash is 
used for manipulating GnuCash files, the thought occurred that others on the 
list may have some tips. The MySQL/PostgreSQL suggestion may be a good one. But 
before I go down this track I'll a browse though the Piecash code.

I'll report back if I find anything or have success in speeding things up.

Cheers,

Tim.

Sent with [ProtonMail](https://protonmail.com/) secure email.

--- Original Message ---
On Sunday, May 8th, 2022 at 15:30, john  wrote:

> Is this about your python program being slow or about GnuCash being slow? 
> Note that Piecash isn't GnuCash and we don't provide any support for it, nor 
> obviously can we provide any support for your program.
>
> If it's a GnuCash problem, please provide more details about exactly what 
> you're doing and what step is taking 20 minutes.
>
> Regards,
> John Ralls
>
>> On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user 
>>  wrote:
>>
>> It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 
>> chip).
>>
>> The slow part seems to be saving the database - inserting the transactions 
>> is fast enough, the save operation is what takes so long. It may be 20 
>> minutes - I haven't timed it. Even closing GnuCash is slow - perhaps 30 
>> seconds to a minute.
>>
>> Sent with ProtonMail secure email.
>> --- Original Message ---
>> On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider 
>>  wrote:
>>
>>> I don’t believe the file is getting too large. If you haven’t looked into 
>>> using an SSD drive at least for the database I highly recommend it. Not 
>>> only will you amazed at how fast data will be written to the file but also 
>>> how fast you will be able to generate reports.
>>>
>>> Ken Schneider
>>>
 On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user 
 gnucash-user@gnucash.org wrote:

 Hi,

 My GnuCash file (SQLite format) has become rather large - 110 MBytes. 
 Every month or two I import a lot more transactions in CSV format. I use 
 piecash in a Python script I wrote, because the importing of CSV data 
 built into GnuCash crashes when I import too many transactions.

 I might be importing perhaps 4000 or 5000 transactions. Saving them into 
 my GnuCash file takes many many minutes. I know my file is getting too 
 large, but it surely shouldn't take 10+ minutes to do this operation? 
 Whilst I do it, I can see Python is taking 100% of a CPU core.

 Come the end of the financial year (30 June) I'm going to start a new 
 file. But this will quickly grow in size, and no doubt I'll run into this 
 problem again. Is there anything I can do to speed this up, or do I just 
 have to live with it?

 Cheers,

 Tim.

 Sent with ProtonMail secure email.
 ___
 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.
>>
>> ___
>> 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_Listsfor 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

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

[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 the database 
every month or two, and I'll just go and do something else while it does its 
work.

Cheers,

Tim.

Sent with ProtonMail secure email.
--- Original Message ---
On Monday, May 9th, 2022 at 07:18, Tim Hume via gnucash-user 
 wrote:


> 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 that maybe someone else had experienced this and might 
> have some tips - I realise this mailing list is for GnuCash, but given 
> Piecash is used for manipulating GnuCash files, the thought occurred that 
> others on the list may have some tips. The MySQL/PostgreSQL suggestion may be 
> a good one. But before I go down this track I'll a browse though the Piecash 
> code.
>
> I'll report back if I find anything or have success in speeding things up.
>
> Cheers,
>
> Tim.
>
> Sent with ProtonMail secure email.
>
> --- Original Message ---
> On Sunday, May 8th, 2022 at 15:30, john jra...@ceridwen.us wrote:
>
> > Is this about your python program being slow or about GnuCash being slow? 
> > Note that Piecash isn't GnuCash and we don't provide any support for it, 
> > nor obviously can we provide any support for your program.
> >
> > If it's a GnuCash problem, please provide more details about exactly what 
> > you're doing and what step is taking 20 minutes.
> >
> > Regards,
> > John Ralls
> >
> > > On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user 
> > > gnucash-user@gnucash.org wrote:
> > >
> > > It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 
> > > chip).
> > >
> > > The slow part seems to be saving the database - inserting the 
> > > transactions is fast enough, the save operation is what takes so long. It 
> > > may be 20 minutes - I haven't timed it. Even closing GnuCash is slow - 
> > > perhaps 30 seconds to a minute.
> > >
> > > Sent with ProtonMail secure email.
> > > --- Original Message ---
> > > On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider 
> > > kschnei...@bout-tyme.net wrote:
> > >
> > > > I don’t believe the file is getting too large. If you haven’t looked 
> > > > into using an SSD drive at least for the database I highly recommend 
> > > > it. Not only will you amazed at how fast data will be written to the 
> > > > file but also how fast you will be able to generate reports.
> > > >
> > > > Ken Schneider
> > > >
> > > > > On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user 
> > > > > gnucash-user@gnucash.org wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > My GnuCash file (SQLite format) has become rather large - 110 MBytes. 
> > > > > Every month or two I import a lot more transactions in CSV format. I 
> > > > > use piecash in a Python script I wrote, because the importing of CSV 
> > > > > data built into GnuCash crashes when I import too many transactions.
> > > > >
> > > > > I might be importing perhaps 4000 or 5000 transactions. Saving them 
> > > > > into my GnuCash file takes many many minutes. I know my file is 
> > > > > getting too large, but it surely shouldn't take 10+ minutes to do 
> > > > > this operation? Whilst I do it, I can see Python is taking 100% of a 
> > > > > CPU core.
> > > > >
> > > > > Come the end of the financial year (30 June) I'm going to start a new 
> > > > > file. But this will quickly grow in size, and no doubt I'll run into 
> > > > > this problem again. Is there anything I can do to speed this up, or 
> > > > > do I just have to live with it?
> > > > >
> > > > > Cheers,
> > > > >
> > > > > Tim.
> > > > >
> > > > > Sent with ProtonMail secure email.
> > > > > ___
> > > > > 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 infor

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

[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: gnucash-user 
[mailto:gnucash-user-bounces+viking2ev=san.rr@gnucash.org] On Behalf Of 
viking...@san.rr.com
Sent: 08 May, 2022 18:49
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing Accounts with non-English Characters

I downloaded v4.10, but the bug remains. It is still not possible to import 
*accounts* using a CSV file (encoded in UTF-8) with non-English characters.
Is there any workaround? I read in the bug report that importing a CSV file 
encoded in windows 1252 may work. However, I have no idea how to save my CSV 
file using Excel and windows 1252 encoding. 

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+viking2ev=san.rr@gnucash.org] On Behalf Of 
viking
Sent: 16 March, 2021 01:32
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing Accounts with non-English Characters

Frank H. Ellenberger-3 wrote
> right, it is on the list:
> https://bugs.gnucash.org/show_bug.cgi?id=785860 - "Export Account Tree 
> to CSV" and "Import Accounts from CSV" should use the same dialogs as 
> "...Transactions..."
> 
> Am 16.03.21 um 09:09 schrieb viking:
>> However, there is no such option when importing *Accounts*.  

Quite an old bug from 2017. Is there a workaround to be able to import accounts 
with non-English characters?

I am also not able to /manually/ create a new account including non-English 
characters. For example, the letter "å" can be typed here by pressing 
"Alt-0229". However, it doesn't work when trying to type this letter in the 
Account name for a New Account. 
Is this another bug?




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.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
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.

___
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 v 2.6.19 or newer on 32bit linux

[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

I also found:

https://askubuntu.com/questions/1376090/latest-version-of-ubuntu-for-i386-architecture-32-bit

Which links to:

http://archive.ubuntu.com/ubuntu/dists/bionic-updates/main/installer-i386/current/images/netboot/

But I don't profess to understand the contents at that second link. I leave it 
to you to sort it out. 

According to the Gnucash wiki, 18.04 has  2.6.19. Such an upgrade might be a 
major undertaking...

David

On May 9, 2022 12:19:28 AM EDT, Jonathan Francoeur  wrote:
>Hi David.  Thank you for asking.  I am using Linux Lite, Ubuntu 16.04 and GNU 
>Cash 2.6.12 on the older machine.  As far as I know, I can not install any 
>newer version of Ubuntu on this 32bit machine.
>
>Hi Adrien.  I'm kinda scared of attempting to build a newer version of GNU 
>Cash without knowing that someone else has done so successfully.  I'm not that 
>good with computers and the list of dependencies looks daunting to me.  Thank 
>you for your suggestions none the less.
>
>On 3/25/22 4:25 AM, David T. via gnucash-user wrote:
>> I think it would be helpful to know a bit more about the versions of Gnucash 
>> on the two machines. The message he got was that he needed *at least* 
>> 2.6.19, not that he needed to use it.
>> 
>> Jonathan, does this imply that your older machine is running Ubuntu 16.04? 
>> The Gnucash wiki says that 16.04 had 2.6.12, while 18.04 had 2.6.19. The 
>> vintage of Ubuntu might affect your options here.
>> 
>> And if your older system has a version greater than 2.6.19 on it, something 
>> else has gone wrong, and more info would be needed.
>> 
>> 
>> On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone 
>>  wrote:
>>> Caveat:
>>> 
>>> You can have some dependency issues on that old machine that might
>>> prevent building the current version or using Flatpak.
>>> 
>>> I'd think you *should* be able to build 2.6.19 or 2.6.21 though. (2.6.21
>>> was the last 2.6 version)
>>> 
>>> Please do report back what you are able to accomplish.
>>> 
>>> If nothing works, consider possibly using RDP or VNC to your 64bit
>>> machine rather than a local install.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> On 3/24/22 8:00 PM, Adrien Monteleone wrote:
 Jonathan,
 
 You should be able to build a current version of Gnucash on your 32bit
 machine.
 
 See the instructions here:
 
 https://wiki.gnucash.org/wiki/Building
 
 And you can update to current on your 64bit machine to match.
 
 You might also be able to use the Flatpak if you don't want to build.
 (I'd try that first)
 
 Regards,
 Adrien
 
 On 3/23/22 2:52 AM, Jonathan Francoeur wrote:
> I have my accounts in dropbox and I was using a newer version of GNU
> cash on my 64bit computer.  Now I"m trying to use the files on my
> older 32bit computer and I get the error:
> 
> 
> This Dataset contains features not supported by this version of
> GnuCash. You must use a newer version of GnuCash in order to support
> the following features:
> * Use account GUID as key for bayesian data and store KVP flat
> (requires at least Gnucash 2.6.19)
> 
> 
> I have not been able to install the Gnucash 2.6.19 from the tar.gz
> files.  I'm used to using .deb files on following instructions by copy
> pasting in to the terminal.  I haven't found anything like that for
> installing a newer version on GNU cash on a 32bit linux machine.  Any
> ideas?
 ___
 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.
>> ___
>> 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 Gma

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

[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 32-bit version installed, 
you can always do a 'do-release-upgrade' on that 32-bit machine and it will 
upgrade to the next release -- on a 32-bit Ubuntu 16.04, do-release-upgrade 
will get you Ubuntu 18.04, then doing it again (after rebooting), you will 
have a 32-bit version of 20.04, and then doing it yet again, you will have 
22.04, still 32-bit.  I don't know if (when?) Ubuntu will stop building 32-bit 
binaries -- I suspect that as long as there remain support for 32-bit in the 
kernel and as long as gcc supports compiling for a 32-bit target, you will be 
able to upgrade a 32-bit machine.  The only really issue is what happens when 
certain critical parts for that 32-bit machine stop being available.  OTOH, 
the only really 32-bit parts (CPU, motherboard, and memory) could last 
indefinately -- the only parts that will wear out would be some of the 
capacitors on the motherboard, which could be replaced.  It should even be 
possible to replace the CPU fan.  I don't know if there are BIOS issues with 
very large disks or if there will be some sort of "brick wall" issue with a 
32-bit kernel dealing with ginormous disks -- I suspect that even a 32-bit 
kernel will have no trouble a 1KT drives, but by then the issue will be 
whether or not a it makes sense to get a hover mod for your Ford model A... 
:-) 


At Mon, 09 May 2022 08:02:00 -0400 "David T."  wrote:

> 
> 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
> 
> I also found:
> 
> https://askubuntu.com/questions/1376090/latest-version-of-ubuntu-for-i386-architecture-32-bit
> 
> Which links to:
> 
> http://archive.ubuntu.com/ubuntu/dists/bionic-updates/main/installer-i386/current/images/netboot/
> 
> But I don't profess to understand the contents at that second link. I leave 
> it to you to sort it out. 
> 
> According to the Gnucash wiki, 18.04 has  2.6.19. Such an upgrade might be a 
> major undertaking...
> 
> David
> 
> On May 9, 2022 12:19:28 AM EDT, Jonathan Francoeur  wrote:
> >Hi David.  Thank you for asking.  I am using Linux Lite, Ubuntu 16.04 
> >and GNU Cash 2.6.12 on the older machine.  As far as I know, I can not 
> >install any newer version of Ubuntu on this 32bit machine.
> >
> >Hi Adrien.  I'm kinda scared of attempting to build a newer version of 
> >GNU Cash without knowing that someone else has done so successfully.  I'm 
> >not that good with computers and the list of dependencies looks daunting to 
> >me.  Thank you for your suggestions none the less.
> >
> >On 3/25/22 4:25 AM, David T. via gnucash-user wrote:
> >> I think it would be helpful to know a bit more about the versions of 
> >> Gnucash on the two machines. The message he got was that he needed *at 
> >> least* 2.6.19, not that he needed to use it.
> >> 
> >> Jonathan, does this imply that your older machine is running Ubuntu 16.04? 
> >> The Gnucash wiki says that 16.04 had 2.6.12, while 18.04 had 2.6.19. The 
> >> vintage of Ubuntu might affect your options here.
> >> 
> >> And if your older system has a version greater than 2.6.19 on it, 
> >> something else has gone wrong, and more info would be needed.
> >> 
> >> 
> >> On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone 
> >>  wrote:
> >>> Caveat:
> >>> 
> >>> You can have some dependency issues on that old machine that might
> >>> prevent building the current version or using Flatpak.
> >>> 
> >>> I'd think you *should* be able to build 2.6.19 or 2.6.21 though. (2.6.21
> >>> was the last 2.6 version)
> >>> 
> >>> Please do report back what you are able to accomplish.
> >>> 
> >>> If nothing works, consider possibly using RDP or VNC to your 64bit
> >>> machine rather than a local install.
> >>> 
> >>> Regards,
> >>> Adrien
> >>> 
> >>> On 3/24/22 8:00 PM, Adrien Monteleone wrote:
>  Jonathan,
>  
>  You should be able to build a current version of Gnucash on your 32bit
>  machine.
>  
>  See the instructions here:
>  
>  https://wiki.gnucash.org/wiki/Building
>  
>  And you can update to current on your 64bit machine to match.
>  
>  You might also be able to use the Flatpak if you don't want to build.
>  (I'd try that first)
>  
>  Regards,
>  Adrien
>  
>  On 3/23/22 2:52 AM, Jonathan Francoeur wrote:
> > I have my accounts in dropbox and I was using a newer version of GNU
> > cash on my 64bit computer.  Now I"m trying to use the files on my
> > older 32bi

[GNC] List of securities with Get Online Quotes

[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 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] Importing Accounts with non-English Characters

[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 10:15 schrieb viking...@san.rr.com:
> 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". 
___
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 hangs

[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 wrote:

Linux: Fedora 35 64-bit
GnuCash 4.10
Finance::Quote 1.51
Online Quote: Alpha Vantage API key: has a value

gnc-fq-check: installed
gnc-fq-dump: installed
gnc-fq-helper: installed
gnc-fq-update: missing

gnucash
  Tools
   Price database
 Get Quotes
gets me a spinning circle.

System Monitor shows
  CPU: 5%
  Memory: 7% used
  Swap: 0 bytes uses
  Network:  minimal

Clicking on the "X" in the top right corner of the Price database
window is ignored.  After a few seconds, get a popup about not
responding and do I want to Cancel or End process.

If I End process, both the Price database window and GnuCash window
exit.

If I restart GnuCash, I get a message about the lock cannot be
obtained.  I can force that with Open Anyway.


___
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] Large GnuCash file very slow to write to

[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 
takes that long to exit, something else is amiss.


Do you have a very large number of tabs open when you exit? (such as 25+ 
reports? This has known to cause slow or hanging re-starts for some 
reports, but perhaps shutdown can be affected as well.)


Note, I'm on an older '13 Mini with BigSur, but my file is only 16.5MB, 
so I can't speak file size alone.


Another variable is the M1. While allegedly non-optimized apps should at 
least run as well as on Intel, perhaps some things don't translate 
well—but I'm way out of my depth there—just hazarding a guess.


Regards,
Adrien

On 5/9/22 2:18 AM, Tim Hume via gnucash-user wrote:

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 that maybe someone else had experienced this and might have 
some tips - I realise this mailing list is for GnuCash, but given Piecash is 
used for manipulating GnuCash files, the thought occurred that others on the 
list may have some tips. The MySQL/PostgreSQL suggestion may be a good one. But 
before I go down this track I'll a browse though the Piecash code.

I'll report back if I find anything or have success in speeding things up.


___
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 v 2.6.19 or newer on 32bit linux

[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 
to continue 32-bit support. Canonical then realized they could continue 
to provide builds, sans stand-alone installers, but with the caveat that 
they won't take bug reports because they got rid of (or have a lack of) 
the physical hardware for testing. I think there are some core packages 
and libraries they try to continue to patch and support however.


I could almost bet that I installed 18.04 with fresh 32-bit installers, 
but I could be misremembering.


Regards,
Adrien

On 5/9/22 7:48 AM, Robert Heller wrote:

*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 32-bit version installed,
you can always do a 'do-release-upgrade' on that 32-bit machine and it will
upgrade to the next release -- on a 32-bit Ubuntu 16.04, do-release-upgrade
will get you Ubuntu 18.04, then doing it again (after rebooting), you will
have a 32-bit version of 20.04, and then doing it yet again, you will have
22.04, still 32-bit.  I don't know if (when?) Ubuntu will stop building 32-bit
binaries -- I suspect that as long as there remain support for 32-bit in the
kernel and as long as gcc supports compiling for a 32-bit target, you will be
able to upgrade a 32-bit machine.  The only really issue is what happens when
certain critical parts for that 32-bit machine stop being available.  OTOH,
the only really 32-bit parts (CPU, motherboard, and memory) could last
indefinately -- the only parts that will wear out would be some of the
capacitors on the motherboard, which could be replaced.  It should even be
possible to replace the CPU fan.  I don't know if there are BIOS issues with
very large disks or if there will be some sort of "brick wall" issue with a
32-bit kernel dealing with ginormous disks -- I suspect that even a 32-bit
kernel will have no trouble a 1KT drives, but by then the issue will be
whether or not a it makes sense to get a hover mod for your Ford model A...
:-)


At Mon, 09 May 2022 08:02:00 -0400 "David T."  wrote:



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

I also found:

https://askubuntu.com/questions/1376090/latest-version-of-ubuntu-for-i386-architecture-32-bit

Which links to:

http://archive.ubuntu.com/ubuntu/dists/bionic-updates/main/installer-i386/current/images/netboot/

But I don't profess to understand the contents at that second link. I leave it 
to you to sort it out.

According to the Gnucash wiki, 18.04 has  2.6.19. Such an upgrade might be a 
major undertaking...

David

On May 9, 2022 12:19:28 AM EDT, Jonathan Francoeur  wrote:

Hi David.  Thank you for asking.  I am using Linux Lite, Ubuntu 16.04 and 
GNU Cash 2.6.12 on the older machine.  As far as I know, I can not install 
any newer version of Ubuntu on this 32bit machine.

Hi Adrien.  I'm kinda scared of attempting to build a newer version of GNU 
Cash without knowing that someone else has done so successfully.  I'm not 
that good with computers and the list of dependencies looks daunting to me.  
Thank you for your suggestions none the less.

On 3/25/22 4:25 AM, David T. via gnucash-user wrote:

I think it would be helpful to know a bit more about the versions of Gnucash on 
the two machines. The message he got was that he needed *at least* 2.6.19, not 
that he needed to use it.

Jonathan, does this imply that your older machine is running Ubuntu 16.04? The 
Gnucash wiki says that 16.04 had 2.6.12, while 18.04 had 2.6.19. The vintage of 
Ubuntu might affect your options here.

And if your older system has a version greater than 2.6.19 on it, something 
else has gone wrong, and more info would be needed.


On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone 
 wrote:

Caveat:

You can have some dependency issues on that old machine that might
prevent building the current version or using Flatpak.

I'd think you *should* be able to build 2.6.19 or 2.6.21 though. (2.6.21
was the last 2.6 version)

Please do report back what you are able to accomplish.

If nothing works, consider possibly using RDP or VNC to your 64bit
machine rather than a local install.

Regards,
Adrien

On 3/24/22 8:00 PM, Adrien Monteleone wrote:

Jonathan,

You should be able to build a current version of Gnucash on your 32bit
machine.

See the instructions here:

https://wik

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

[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 record, it would have been nice if you had used your earlier message on 
the topic to continue this discussion. 

That way, we could have more easily discussed the other aspects of this-- 
notably, that the online retrieval of quotes can take some time, and that there 
are a number of ways that the process can fail. 

In regards to time: I've had times where this process takes an inordinate 
amount of time-- on the order of many minutes. You don't say how many quotes 
you're trying to get. Finance::Quote can be quite slow with large numbers of 
quotes. This can happen for a number of reasons, but they aren't always clear. 
I chalk it up to the wonders of internet latency. You didn't say how long you 
waited before you gave up. 

Second, there have been times where the retrieval of quotes has been limited or 
throttled by Alphavantage. I seem to recall that they imposed some limit (like 
5) per minute. This limitation has tripped up numerous users in the past. You 
didn't say whether you were using Alphavantage or not, although your original 
message included information that might imply it. The workaround I recall was 
to use yahoo_json instead. 

Finally, if you have a bad symbol in your set, that's like the only time you 
actually will get a meaningful error from Finance::Quote. So, I'm guessing that 
your problem has to do with not allowing the process to complete, rather than a 
bad symbol. 

David

On May 9, 2022 10:17:05 AM EDT, Fred Tydeman  wrote:
>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 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] gnucash v 2.6.19 or newer on 32bit linux

[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 download and then use Gdebi or dpkg to install 
from there, but as noted, you might run into dependency problems on 
16.04. But as you can see looking at that list, several newer versions 
that 2.6.12 though sadly 2.6.19/21 are not among them. (this is an 
archive of the versions built for each Ubuntu release, 4.10 didn't make 
it in time for 22.04, so this is the only way one can get it short of 
building or flatpak)


You should only need the gnucash-common and gnucash packages. For 
gnucash-common use the 'all' deb for the version you want, and for 
gnucash, use the matching version i386 with the most recent date. (thus 
if you want version 3.10, you need v3.10 for both files)


As for choosing a version, here's the tough part:

The wiki notes that 2.6.15 (available in the archive) will work on 16.04 
& 16.10, but as you note from the error, that isn't recent enough.


The wiki also notes that 3.0 will work on 18.04, and 3.2 (allegedly the 
last update on that wiki page) is untested on older versions of Ubuntu.


Unfortunately, the archive jumps from 2.6.15 to 3.4, then 3.10, 4.4, & 
4.10, so you're in uncharted territory unless someone else has done this 
already and can chime in.


If you can do-release-upgrade to 18.04, that will help you considerably. 
(likely at least get into the 3.x series) and if you can then get to 
20.04 or better, you should be gravy for 4.x.


Regards,
Adrien

On 5/8/22 11:19 PM, Jonathan Francoeur wrote:
Hi David.  Thank you for asking.  I am using Linux Lite, Ubuntu 16.04 
and GNU Cash 2.6.12 on the older machine.  As far as I know, I can not 
install any newer version of Ubuntu on this 32bit machine.


Hi Adrien.  I'm kinda scared of attempting to build a newer version of 
GNU Cash without knowing that someone else has done so successfully. I'm 
not that good with computers and the list of dependencies looks daunting 
to me.  Thank you for your suggestions none the less.


___
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] List of securities with Get Online Quotes

[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, then hang on 
USD->CAD, then on a subsequent try of CAD first, would retrieve it, then 
several others, then hang on EUR. And I wasn't rapid firing the commands 
either. I would intentionally wait a full minute before each request.


I never did resolve it as eventually all symbols caused a hang 
(including those that should not: EUR, CAD, GBP) and eventually all 
(even some old 'obsolete' currencies) gave me a quote via CLI, so I 
couldn't determine which if any I should remove from the GnuCash Price list.


If these random hangs happen via CLI, then I doubt GnuCash is involved. 
This is likely either an issue with F::Q or Alphavantage. (I didn't try 
other sources after the above tries)


Regards,
Adrien

On 5/9/22 9:17 AM, Fred Tydeman wrote:

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 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 v 2.6.19 or newer on 32bit linux

[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 several.)
> 
> The big push was Steam, but there were some other libraries that needed 
> to continue 32-bit support. Canonical then realized they could continue 
> to provide builds, sans stand-alone installers, but with the caveat that 
> they won't take bug reports because they got rid of (or have a lack of) 
> the physical hardware for testing. I think there are some core packages 
> and libraries they try to continue to patch and support however.

There is *probably* little in the way of 32-bit *specific* bugs at this point. 
And since there is no new 32-bit *specific* hardware, there are not going to 
be new kernel drivers for 32-bit *specific* hardware -- any new kernel driver 
issues will be for 64-bit hardware.  (Probably the only exception to this is 
for 32-bit *arm* processors, but that is something completely different.)

What bugs that are showing up are not word-size specific, so it is just a 
matter of automated re-builds for all supported arches.  And the builds and 
Q/A can be done on generic 32-bit VMs.

> 
> I could almost bet that I installed 18.04 with fresh 32-bit installers, 
> but I could be misremembering.

Misremembering.  You probably did a do-release-upgrade from 16.04.

> 
> Regards,
> Adrien
> 
> On 5/9/22 7:48 AM, Robert Heller wrote:
> > *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 32-bit version installed,
> > you can always do a 'do-release-upgrade' on that 32-bit machine and it will
> > upgrade to the next release -- on a 32-bit Ubuntu 16.04, do-release-upgrade
> > will get you Ubuntu 18.04, then doing it again (after rebooting), you will
> > have a 32-bit version of 20.04, and then doing it yet again, you will have
> > 22.04, still 32-bit.  I don't know if (when?) Ubuntu will stop building 
> > 32-bit
> > binaries -- I suspect that as long as there remain support for 32-bit in the
> > kernel and as long as gcc supports compiling for a 32-bit target, you will 
> > be
> > able to upgrade a 32-bit machine.  The only really issue is what happens 
> > when
> > certain critical parts for that 32-bit machine stop being available.  OTOH,
> > the only really 32-bit parts (CPU, motherboard, and memory) could last
> > indefinately -- the only parts that will wear out would be some of the
> > capacitors on the motherboard, which could be replaced.  It should even be
> > possible to replace the CPU fan.  I don't know if there are BIOS issues with
> > very large disks or if there will be some sort of "brick wall" issue with a
> > 32-bit kernel dealing with ginormous disks -- I suspect that even a 32-bit
> > kernel will have no trouble a 1KT drives, but by then the issue will be
> > whether or not a it makes sense to get a hover mod for your Ford model A...
> > :-)
> > 
> > 
> > At Mon, 09 May 2022 08:02:00 -0400 "David T."  wrote:
> > 
> >>
> >> 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
> >>
> >> I also found:
> >>
> >> https://askubuntu.com/questions/1376090/latest-version-of-ubuntu-for-i386-architecture-32-bit
> >>
> >> Which links to:
> >>
> >> http://archive.ubuntu.com/ubuntu/dists/bionic-updates/main/installer-i386/current/images/netboot/
> >>
> >> But I don't profess to understand the contents at that second link. I 
> >> leave it to you to sort it out.
> >>
> >> According to the Gnucash wiki, 18.04 has  2.6.19. Such an upgrade might be 
> >> a major undertaking...
> >>
> >> David
> >>
> >> On May 9, 2022 12:19:28 AM EDT, Jonathan Francoeur  
> >> wrote:
> >>> Hi David.  Thank you for asking.  I am 
> >>> using Linux Lite, Ubuntu 16.04 and GNU Cash 2.6.12 on the older 
> >>> machine.  As far as I know, I can not install any newer 
> >>> version of Ubuntu on this 32bit machine.
> >>>
> >>> Hi Adrien.  I'm kinda scared of attempting to build a 
> >>> newer version of GNU Cash without knowing that someone else has done so 
> >>> successfully.  I'm not that good with computers and the 
> >>> list of dependencies looks daunting to me.  Thank you 
> >>> for your suggestions none the less.
> >>>
> >>> On 3/25/22 4:25 AM, David T. via gnuc

Re: [GNC] Budget Reporting

[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 expect.

I created a budget to cover the period Oct 21 through to Sept 22.

I am however struggling to get a report to show me my likely closing balance 
based on the differences between my forecast and actual income and outgoings.

Hopefully this question make sense.


Almost. What exactly do you mean by 'likely closing balance'? Closing 
Balance of 'what', the entire book? or just say, your Checking Account?


There is no overall 'closing balance' save perhaps a Net Worth 
calculation. (the result of the full Accounting Equation)


Budget reports can show you the budgeted amount, actual amount, 
difference, and do this by period with a yearly or even year-to-date 
'grand total' if you like. (or even running totals rather then 
individual periods) But this report is 'by-account', and does not show 
an 'overall closing balance'. (whatever that means)


Regards,
Adrien

___
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] Configuration dilemma -- How best to share Gnucash between 2 users

[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 
individual device?

 Prefer to avoid maintaining two separate apps intalled on devices and sharing 
just the data file.  

Is gnucash capable of being launched from the shared volume?


Your thoughts?

Thanks in advance,

Bart

___
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] Configuration dilemma -- How best to share Gnucash between 2 users

[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 to application support files usually found in library
> folder of individual device?
>
>  Prefer to avoid maintaining two separate apps intalled on devices and
> sharing just the data file.
>
> Is gnucash capable of being launched from the shared volume?

On a MAC, the application is fully contained, so yes, it could be run off
a shared fileserver.  Although I don't understand your concern with having
it installed on both machines.

The main gotcha is that only one person can have the data file open at a
time.  This means you will need to coordinate "who is running GnuCash" at
any particular moment.

>
> Your thoughts?
>
> Thanks in advance,
>
> Bart

> 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] Importing Accounts with non-English Characters

[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] Importing Accounts with non-English Characters

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 10:15 schrieb viking...@san.rr.com:
> 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". 

___
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] List of securities with Get Online Quotes

[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 includes a number of fields for display.
>

Thank you.  That allowed me to find many currencies (that I do not care
about) with Get Quotes checked.


> For the record, it would have been nice if you had used your earlier
> message on the topic to continue this discussion.
>

OK.  However, I need an easy way to find out which securities I am getting
quotes for (which the above is perfect).


> That way, we could have more easily discussed the other aspects of this--
> notably, that the online retrieval of quotes can take some time, and that
> there are a number of ways that the process can fail.
>
> In regards to time: I've had times where this process takes an inordinate
> amount of time-- on the order of many minutes. You don't say how many
> quotes you're trying to get. Finance::Quote can be quite slow with large
> numbers of quotes. This can happen for a number of reasons, but they aren't
> always clear. I chalk it up to the wonders of internet latency. You didn't
> say how long you waited before you gave up.
>

There were about 60.  I had waited several minutes.


> Second, there have been times where the retrieval of quotes has been
> limited or throttled by Alphavantage. I seem to recall that they imposed
> some limit (like 5) per minute. This limitation has tripped up numerous
> users in the past. You didn't say whether you were using Alphavantage or
> not, although your original message included information that might imply
> it. The workaround I recall was to use yahoo_json instead.
>

Today, I removed Get Quotes from everything except for one stock.  When I
did Get Quotes, it finished in a couple of seconds.
I then added in 10 mutual funds.  Get Quotes then took one or two minutes.
And, the quotes it got from Alphavantage
were from a mixture of 5/5 (Thursday) and 5/6 (Friday).

I then changed Alphavantage to yahoo_json and Get Quotes finished in a few
seconds.  And the prices are from today 5/9 (Monday).


> Finally, if you have a bad symbol in your set, that's like the only time
> you actually will get a meaningful error from Finance::Quote. So, I'm
> guessing that your problem has to do with not allowing the process to
> complete, rather than a bad symbol.
>

There was one security that had a strange symbol (might have been the
CUSIP).  I changed it to the 5 letter symbol.
I was not getting any error message.

On May 9, 2022 10:17:05 AM EDT, Fred Tydeman  wrote:
>>
>> 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 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] GnuCash 4.10

[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 if there’s any change.

 

Richard

From: Richard Clarkson  
Sent: 08 May 2022 23:02
To: 'Glenn Fowler' 
Subject: RE: [GNC] GnuCash 4.10

 

Thanks Glenn

 

That’s what I tried and it doesn’t open.

 

Thanks for putting your thinking cap on.

 

Richard

 

From: Glenn Fowler mailto:gfowl...@outlook.com> > 
Sent: 08 May 2022 21:01
To: Richard Clarkson mailto:rtclark...@btinternet.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] GnuCash 4.10

 

Your data file for your book which will be in the folder that you specified. 

 

Ex

myfinances.gnucash

vacationhome.gnucash

 

On Sun, May 8, 2022, 1:00 PM Richard Clarkson mailto:rtclark...@btinternet.com> > wrote:

Glenn

 

Can’t see anything called book file. Are you referring to GNUData.gnucash ? If 
so nothing opens.

 

Thanks 

 

Richard 

 

From: Glenn Fowler mailto:gfowl...@outlook.com> > 
Sent: 08 May 2022 16:34
To: Richard Clarkson mailto:rtclark...@btinternet.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] GnuCash 4.10

 

Ok try double clicking directly on your book file and see if it works.

 

On Sun, May 8, 2022 at 11:16 AM Richard Clarkson mailto:rtclark...@btinternet.com> > wrote:

Glenn

 

When installing using the installer there was a message that GnuCash was open, 
so I closed GnuCash and clicked retry.

 

Gnucash.exe didn’t work. I also tried via PowerShell and the GnuCash wasn’t 
found. I’ve tried in Admin mode too.

 

I have uninstalled GnuCash and reinstalled and still have the same issue.

 

Thanks for your help.

 

Richard 

 

From: Glenn Fowler mailto:gfowl...@outlook.com> > 
Sent: 08 May 2022 15:31
To: Richard Clarkson mailto:rtclark...@btinternet.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] GnuCash 4.10

 

Hi Richard, 

 

Do you get an error message? 

Did you install using the installer? 

 

On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user 
mailto:gnucash-user@gnucash.org> > wrote:

Have just updated from previous version to GnuCash 4.10 on Windows 11.



GnuCash now refuses to open (have tried from PowerShell too). I have tried
reinstalling but no change.



Any idea how I can rectify this issue?

Many thanks



Richard 

___
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] Importing Accounts with non-English Characters

[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
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 4.10

[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 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 if there’s any change.


___
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 4.10

[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 trying to do something for a 
few seconds, then nothing...

Think I will wait for the next update to see if that works for me.

Thanks for your response - just wish I could do the Check and Repair on 4.10, 
but that's a no go as I can't open GnuCash. Thanks for telling me to do thqt 
qfter every update.

Richard



-Original Message-
From: gnucash-user  
On Behalf Of Adrien Monteleone
Sent: 09 May 2022 21:58
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash 4.10

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 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 if there’s any change.

___
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] Calculation of Unrealized Losses

[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 fund and the average-cost
> algorithm used in the trial balance report doesn't work well in that case.
>
> Regards,
> John Ralls
>
>
>
>
> > On May 2, 2022, at 7:54 PM, David Carlson 
> wrote:
> >
> > Bill,
> >
> > If I recall correctly, one or more of the methods GnuCash uses to
> calculate
> > exchange rates for reports is technically not correctly defined , so it
> > obscures the  fact that it is not calculating the expected value.  That
> is
> > leading to strange results when, for example, one attempts to do a trial
> > balance.   I know very little about accounting so I cannot tell you
> details
> > about that.
> >
> > Some of the developers can help with some of those issues.  Hopefully
> they
> > can at least tell you which calculation methods to avoid when you want
> > accurate results .
> >
> > On Mon, May 2, 2022, 9:27 PM Bill Dika  wrote:
> >
> >> Can anyone help me with this?
> >>
> >> Do I have to supply more/different information?
> >>
> >> I have been using gnucash personally for a couple of years now and would
> >> like to develop more confidence in the program.
> >>
> >> Thank you in advance for your help.
> >>
> >> Bill Dika
> >>
> >> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika  wrote:
> >>
> >>> My default currency is Canadian dollars. I have some US dollar
> >>> accounts in my balance sheet.
> >>>
> >>> I have an unrealized loss in the equity section of my balance sheet at
> >>> July 31 2021 of $12.68 and cannot figure out how it was calculated. I
> >>> also have US dollar accounts expressed in Canadian dollars that I am
> >>> unable to determine how the translation from US dollars to Canadian
> >>> dollars occurs.
> >>>
> >>> For example I have a US dollar account of $353.75 for Tesla (see
> >>> us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22
> >>> in Canadian dollars at July 31 2021 (see
> >>> us-dollar-accts-july-31-2021.png). This is an exchange rate of
> >>> 1.28966. I am unable to figure out how Gnucash arrives at that rate
> >>> (see us-dollar-rates-price-database.png). It is not the rate at July
> >>> 31 2021. It is not the average rate for all rates I have up to July 31
> >>> 2021 and it is not the average rate for all rates I have in the price
> >>> database.
> >>>
> >>> Also the $12.68 loss arises from only one change in the US dollar
> >>> accounts from June 30 2021 to July 31 2021. That is a $524.80 US
> >>> dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see
> >>> change-in-us-dollar-acct-july-2021.png).
> >>>
> >>> Attached are images of the following:
> >>> equity-jun-30-2021.png = showing the equity section almost balanced
> >>> (.01 unrealized gain) (in Canadian dollars)
> >>> equity-july-31-2021.png = showing the $12.68 unrealized loss (in
> >>> Canadian dollars)
> >>> us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts
> >>> (in US dollars)
> >>> us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian
> >>> dollars)
> >>> us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet
> >>> accounts (in US dollars)
> >>> us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian
> >>> dollars)
> >>> change-in-us-dollar-acct-july-2021.png = shows the only change in the
> >>> US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US
> >>> dollars)
> >>> us-dollar-rates-price-database.png = all the US to Canadian exchange
> >>> rates in my database
> >>>
> >>> I am a Canadian CPA and feel quite confident about the accounting in
> >>> the gnucash file. I have reviewed the journal entries for the period
> >>> and they all balance. The only thing I can ascertain is that the
> >>> unrealized loss arises from the US dollar accounts but I cannot figure
> >>> out how gnucash is calculating it nor can I figure out how gnucash
> >>> translates US dollars to Canadian dollars for those accounts.
> >>>
> >>> I have searched the list but cannot find anything that helps me in my
> >>> calculation.
> >>>
> >>> I am on Arch linux using Gnucash 4.9.
> >>>
> >>> Any help would be much appreciated.
> >>>
> >>> Thank you.
> >>>
> >>> Bill Dika
> >>>
> >> ___
> >> 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 maili

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

[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 older version.  Clicked on the "X" to shut down
> and had not saved first.  In the dialogue I clicked on Cancel, but it still
> shutdown.  I expected "Cancel" to cancel the operation (shutdown), am I
> wrong.  What operation is it canceling?  All 3 options have the same
> result,  They all close the program without saving and upon restart, I got
> the message that "GnuCash could not obtain the lock for
> C:\Users\*\OneDrive\Documents\GNUCash\**.gnucash." (see pic 2)  "***"
> for my specific system names.
>
> [cid:5ce6c5d0-06c4-4be7-88c9-51e0ab733c10]
>
> [cid:5082774d-7534-4039-ace7-d5b0d8aa2efa]
>
> I will try to remember to "Save" first, however when I do forget it is
> frustrating that this built in safeguard doesn't work.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
> ___
> 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] List of securities with Get Online Quotes

[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 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, then hang on USD->CAD, then on a 
>subsequent try of CAD first, would retrieve it, then several others, then hang 
>on EUR. And I wasn't rapid firing the commands either. I would intentionally 
>wait a full minute before each request.
>
>I never did resolve it as eventually all symbols caused a hang (including 
>those that should not: EUR, CAD, GBP) and eventually all (even some old 
>'obsolete' currencies) gave me a quote via CLI, so I couldn't determine which 
>if any I should remove from the GnuCash Price list.
>
>If these random hangs happen via CLI, then I doubt GnuCash is involved. This 
>is likely either an issue with F::Q or Alphavantage. (I didn't try other 
>sources after the above tries)
>
>Regards,
>Adrien
>
>On 5/9/22 9:17 AM, Fred Tydeman wrote:
>> 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 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] List of securities with Get Online Quotes

[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 PM EDT, Fred Tydeman  wrote:
>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 includes a number of fields for display.
>>
>
>Thank you.  That allowed me to find many currencies (that I do not care
>about) with Get Quotes checked.
>
>
>> For the record, it would have been nice if you had used your earlier
>> message on the topic to continue this discussion.
>>
>
>OK.  However, I need an easy way to find out which securities I am getting
>quotes for (which the above is perfect).
>
>
>> That way, we could have more easily discussed the other aspects of this--
>> notably, that the online retrieval of quotes can take some time, and that
>> there are a number of ways that the process can fail.
>>
>> In regards to time: I've had times where this process takes an inordinate
>> amount of time-- on the order of many minutes. You don't say how many
>> quotes you're trying to get. Finance::Quote can be quite slow with large
>> numbers of quotes. This can happen for a number of reasons, but they aren't
>> always clear. I chalk it up to the wonders of internet latency. You didn't
>> say how long you waited before you gave up.
>>
>
>There were about 60.  I had waited several minutes.
>
>
>> Second, there have been times where the retrieval of quotes has been
>> limited or throttled by Alphavantage. I seem to recall that they imposed
>> some limit (like 5) per minute. This limitation has tripped up numerous
>> users in the past. You didn't say whether you were using Alphavantage or
>> not, although your original message included information that might imply
>> it. The workaround I recall was to use yahoo_json instead.
>>
>
>Today, I removed Get Quotes from everything except for one stock.  When I
>did Get Quotes, it finished in a couple of seconds.
>I then added in 10 mutual funds.  Get Quotes then took one or two minutes.
>And, the quotes it got from Alphavantage
>were from a mixture of 5/5 (Thursday) and 5/6 (Friday).
>
>I then changed Alphavantage to yahoo_json and Get Quotes finished in a few
>seconds.  And the prices are from today 5/9 (Monday).
>
>
>> Finally, if you have a bad symbol in your set, that's like the only time
>> you actually will get a meaningful error from Finance::Quote. So, I'm
>> guessing that your problem has to do with not allowing the process to
>> complete, rather than a bad symbol.
>>
>
>There was one security that had a strange symbol (might have been the
>CUSIP).  I changed it to the 5 letter symbol.
>I was not getting any error message.
>
>On May 9, 2022 10:17:05 AM EDT, Fred Tydeman  wrote:
>>>
>>> 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 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.

[GNC] default local currency

[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 data file I last used 
on the desktop and everything looked fine, except the reporting. It turned out 
that the default local currency  on my laptop (new installation) is USD, 
whereas I am working in Malaysian Ringgit and that is the default currency on 
my Desktop.

 

I searched high and low under preferences, but cannot find where to change the 
default currency, although I can see where to change the reporting currency to 
MYR. But having wrong locale currency may have an impact elsewhere that I 
cannot foresee.

 

Anyway I can change the Default local currency?

 

thanks

___
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] List of securities with Get Online Quotes

[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 wrote:

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.


___
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] default local currency

[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
> 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 data
> file I last used on the desktop and everything looked fine, except the
> reporting. It turned out that the default local currency  on my laptop (new
> installation) is USD, whereas I am working in Malaysian Ringgit and that is
> the default currency on my Desktop.
>
>
>
> I searched high and low under preferences, but cannot find where to change
> the default currency, although I can see where to change the reporting
> currency to MYR. But having wrong locale currency may have an impact
> elsewhere that I cannot foresee.
>
>
>
> Anyway I can change the Default local currency?
>
>
>
> thanks
>
> ___
> 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] default local currency

[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 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 data
>> file I last used on the desktop and everything looked fine, except the
>> reporting. It turned out that the default local currency  on my laptop (new
>> installation) is USD, whereas I am working in Malaysian Ringgit and that is
>> the default currency on my Desktop.
>>
>>
>>
>> I searched high and low under preferences, but cannot find where to
>> change the default currency, although I can see where to change the
>> reporting currency to MYR. But having wrong locale currency may have an
>> impact elsewhere that I cannot foresee.
>>
>>
>>
>> Anyway I can change the Default local currency?
>>
>>
>>
>> thanks
>>
>> ___
>> 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] default local currency

[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 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 data
>> file I last used on the desktop and everything looked fine, except the
>> reporting. It turned out that the default local currency  on my laptop (new
>> installation) is USD, whereas I am working in Malaysian Ringgit and that is
>> the default currency on my Desktop.
>>
>>
>>
>> I searched high and low under preferences, but cannot find where to
>> change the default currency, although I can see where to change the
>> reporting currency to MYR. But having wrong locale currency may have an
>> impact elsewhere that I cannot foresee.
>>
>>
>>
>> Anyway I can change the Default local currency?
>>
>>
>>
>> thanks
>>
>> ___
>> 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] default local currency

[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 , 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 data file I last used 
on the desktop and everything looked fine, except the reporting. It turned out 
that the default local currency  on my laptop (new installation) is USD, 
whereas I am working in Malaysian Ringgit and that is the default currency on 
my Desktop.


___
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] default local currency

[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 :-)

 

 

On Tue, 10 May 2022 at 13:42, David H mailto:hell...@gmail.com> > wrote:

Preferences >> Accounts >> Default Currency in Gnucash 4.10 ???

 

Cheers David H.

 

 

On Tue, 10 May 2022 at 13:21, David Long mailto:davidvernonl...@gmail.com> > 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 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 data file I last used 
on the desktop and everything looked fine, except the reporting. It turned out 
that the default local currency  on my laptop (new installation) is USD, 
whereas I am working in Malaysian Ringgit and that is the default currency on 
my Desktop.



I searched high and low under preferences, but cannot find where to change the 
default currency, although I can see where to change the reporting currency to 
MYR. But having wrong locale currency may have an impact elsewhere that I 
cannot foresee.



Anyway I can change the Default local currency?



thanks

___
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.

[GNC] Setting Currency Format when importing from CSV?

[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? 

___
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] Errors after restarting GnuCash 4.10 from terminal or bash script

[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 I restarted GnuCash
from the script, the following appeared in the terminal after the script exited.

$ Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 14, in
swig_import_helper
return importlib.import_module(mname)
  File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
  File "", line 1014, in _gcd_import
  File "", line 991, in _find_and_load
  File "", line 975, in _find_and_load_unlocked
  File "", line 657, in _load_unlocked
  File "", line 556, in module_from_spec
  File "", line 1166, in create_module
  File "", line 219, in _call_with_frames_removed
ImportError: libgncmod-app-utils.so: cannot open shared object file: No such
file or directory

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/share/gnucash/python/init.py", line 2, in 
from gnucash import *
  File "/usr/lib/python3/dist-packages/gnucash/__init__.py", line 6, in 
from gnucash.gnucash_core import *
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core.py", line 31, in

import gnucash.gnucash_core_c as gnucash_core_c
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 17, in

_gnucash_core_c = swig_import_helper()
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 16, in
swig_import_helper
return importlib.import_module('_gnucash_core_c')
  File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
ModuleNotFoundError: No module named '_gnucash_core_c'
Found Finance::Quote version 1.51.

I get the same error with no additional info restarting GnuCash from the command
line with --debug. It seems to be more associated with the python bindings than
anything to do with getting online quotes. I do compile  with -D WITH_PYTHON+ON
when I build it. Haven't ever started GC from a script or terminal recently but
I presume this happens from the desktop launcher as well, just isn't visible.

Has anyone struck this before?

___
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.