Re: [GNC] SQLite slow to load on macOS but not Linux

[Colin Arndt]

To the Gnucash development team,

This issue has been significantly improved in the latest 5.2 release! 

As noted below, GnuCash 5.1 on my Mac took about 30 seconds to load. This issue 
did not happen on my Fedora box - it loaded instantly.

It’s now almost 2x faster (18 seconds). A big win!

Thanks for all your work. If you have any sense of why it would have sped up so 
much, I’d love to hear.
Colin

> On Jun 3, 2023, at 2:50 PM, Colin Arndt  wrote:
> 
> Hi all,
> 
> I set up Gnucash a few years ago on Linux and have since switched to using it 
> on Mac (Ventura 13.4 on a MacBook Air M1 2020). 
> 
> I’ve mainly run it with the XML file, but wanted to take advantage of some 
> add-ons that require a SQL database. After saving as an sqlite3 file on Mac, 
> it now take 30 seconds to load. The XML file opens instantly. (XML file is 
> 18MB, SQLite DB is 12MB, including 9000 transactions and 6000 prices).
> 
> Out of curiosity I opened the same SQLite file on an Intel Linux box of 
> similar age to my MacBook Air. GnuCash opened instantly. The issue is only on 
> my Mac.
> 
> I’ve taken the following steps time without any difference:
> 
> 1. Checked and Repaired all accounts
> 2. Saved file back to an XML then back to an SQLite file, on both my Mac and 
> Linux box
> 3. Ran sqlite3 database_name 'VACUUM;’ from the Terminal
> 4. Deleted all price data
> 
> Reports of this issue mention 1 CPU spinning up to 100% while the file is 
> loaded into memory - and I see the same behavior.
> 
> Any advice on this?
> 
> Thanks,
> Colin

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 243, Issue 23

[Colin Arndt]

Hi Bruce,

Thank you for your efforts to resolve the Yahoo API issues. I rely on quotes in 
GNC to track the value of portfolios and overall net worth. Your efforts are 
much appreciated!

I’ll install this to help with testing.

Best,
Colin

> Date: Thu, 15 Jun 2023 12:23:42 -0700
> From: Bruce Schuck 
> To: Finance-Quote-News ,
>   Finance-Quote-User , GnuCash
>   User 
> Subject: [GNC] Finance::Quote 1.56_02 Available for Evaluation
> Message-ID: <66d8719e-5324-d74f-d92c-34f259514...@asgard-systems.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Greetings all,
> 
> Non-production release 1.56_02 is available for evaluation/testing.
> 
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz
> 
> It can be installed via cpan/cpanm as 
> 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'.
> 
> Anticipating that Yahoo may block access to the URL used in the 
> YahooJSON (yahoo_json) module, there are 3 new modules that gather 
> information from URLs normally accessed through a browser.
> 
> GoogleWeb (googleweb)
> MarketWatch (marketwatch)
> YahooWeb (yahooweb)
> 
> In addition the Fool module was corrected so it now works.
> 
> Bruce S.
> 
> 
> 
> --
> 
> Subject: Digest Footer
> 
> ___
> 
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> --
> 
> End of gnucash-user Digest, Vol 243, Issue 23
> *

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] SQLite slow to load on macOS but not Linux

[Colin Arndt]

Hi all,

I set up Gnucash a few years ago on Linux and have since switched to using it 
on Mac (Ventura 13.4 on a MacBook Air M1 2020). 

I’ve mainly run it with the XML file, but wanted to take advantage of some 
add-ons that require a SQL database. After saving as an sqlite3 file on Mac, it 
now take 30 seconds to load. The XML file opens instantly. (XML file is 18MB, 
SQLite DB is 12MB, including 9000 transactions and 6000 prices).

Out of curiosity I opened the same SQLite file on an Intel Linux box of similar 
age to my MacBook Air. GnuCash opened instantly. The issue is only on my Mac.

I’ve taken the following steps time without any difference:

1. Checked and Repaired all accounts
2. Saved file back to an XML then back to an SQLite file, on both my Mac and 
Linux box
3. Ran sqlite3 database_name 'VACUUM;’ from the Terminal
4. Deleted all price data

Reports of this issue mention 1 CPU spinning up to 100% while the file is 
loaded into memory - and I see the same behavior.

Any advice on this?

Thanks,
Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Increasing font size on macOS

[Colin Arndt]

Apologies- user error! I'd added an extra subdirectory ‘config’.

This works fine as long as I follow the procedure and set up the file as:

~/Library/Application Support/GnuCash/gtk-3.0.css

Sorry for the spam!
Colin


> On May 31, 2023, at 9:27 AM, Colin Arndt  wrote:
> 
> Hi everyone,
> 
> Running GnuCash 5.1 / macOS Ventura 13.4 (latest) / 2020 MacBook Air M1. 
> 
> I switched to GTK dark mode and like it quite a lot. However, something about 
> the darker background makes the default text size a bit hard to read.
> 
> To increase the font size, I searched the list archives and the latest info I 
> found pointed to the wiki. Create a gtk-3.0.css file under 
> ~/Library/Application Support/GnuCash/config. 
> https://wiki.gnucash.org/wiki/GTK3#Via_css
> 
> I created Gtk-3.0.css and it now contains the following. But it has no impact 
> on the font size in the interface:
> * {
> font: 14pt arial, sans-serif;
>   }
> 
> I know the GTK version has been updated across majors versions of GnuCash, so 
> tried naming it Gtk-4.0.css in case the docs were outdated. But no effect.
> 
> How can I accomplish this?
> 
> Thank you,
> Colin
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Increasing font size on macOS

[Colin Arndt]

Hi everyone,

Running GnuCash 5.1 / macOS Ventura 13.4 (latest) / 2020 MacBook Air M1. 

I switched to GTK dark mode and like it quite a lot. However, something about 
the darker background makes the default text size a bit hard to read.

To increase the font size, I searched the list archives and the latest info I 
found pointed to the wiki. Create a gtk-3.0.css file under 
~/Library/Application Support/GnuCash/config. 
https://wiki.gnucash.org/wiki/GTK3#Via_css

I created Gtk-3.0.css and it now contains the following. But it has no impact 
on the font size in the interface:
* {
font: 14pt arial, sans-serif;
  }

I know the GTK version has been updated across majors versions of GnuCash, so 
tried naming it Gtk-4.0.css in case the docs were outdated. But no effect.

How can I accomplish this?

Thank you,
Colin

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Revisiting Quotes (Bruce Schuck)

[Colin Arndt]

Hi Bruce,

Thanks for all your work to keep up this past month. The latest 1.56 update 
fixes price retrieval within GnuCash.

> This means modules will need to be rewritten to parse the HTML. Doable, 
> but not as simple as parsing JSON.

There is an excellent python module ‘yfinance’ which does exactly this - 
scrapes price data from Yahoo!’s website. This might not be of any use because 
it’s written in python instead of Perl, but nonetheless wanted to make sure 
you’re aware of it.

https://pypi.org/project/yfinance

Best,
Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Colin Arndt]

Thank you Bruce. That fixed it and was a lot quicker than changing ~30 
securities to a new provider.

For anyone else on macOS, the location was:
/Library/Perl/5.30/Finance/Quote/YahooJSON.pm 

Best,
Colin

> On May 6, 2023, at 3:19 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> --
> 
> Message: 8
> Date: Sat, 6 May 2023 12:12:12 -0700
> From: Bruce Schuck  >
> To: gnucash-user@gnucash.org 
> Cc: farle...@gmail.com 
> Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error
> Message-ID: <37705e31-b6a2-6faf-3007-83a0e9ce5...@asgard-systems.com 
> >
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Ken,
> 
> I am currently evaluating which of the alternatives is the best 
> replacement. I'm also a little hopeful that in the meantime the 
> functionality of the current URL/API is restored before the time is 
> spent to not only make the changes, but the related housekeeping 
> necessary before pushing an official release to CPAN.
> 
> In the mean time, for those savvy enough to find and edit the 
> YahooJSON.pm file on their system, a quick fix is to change this line:
> 
> my $YIND_URL_HEAD = 
> 'https://query1.finance.yahoo.com/v7/finance/quote?symbols=';
> 
> to:
> 
> my $YIND_URL_HEAD = 
> 'https://query1.finance.yahoo.com/v6/finance/quote?symbols=';
> 
> Be wary that there may be multiple versions of the YahooJSON.pm file and 
> a system, so be certain to modify the correct one.
> 
> - Bruce S.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Monthly period in charts should use end-of-month values, not start

[Colin Arndt]

Hello fellow GnuCashers,

I’ve used GnuCash very happily the last few years - it’s a fantastic 
application with superlative support from both the developers and fellow users 
on this list. But here’s my issue.

Today I created a bar chart report tracking my cash across bank accounts over 
time. 

When using Month as the period (step size), the report returns the balance at 
the start of the month, not the end.

I was looking at the bar for January of this year, confused why it didn’t 
include a bonus I got at work. It took me a moment to realize the report used 
January 1st balances. Therefore, that deposit wasn’t reflected until February. 
This means when interpreting the bar values, I have to mentally shift them all 
back one month.

Another example. If I want to see the cash balance at the end of 2021, I have 
to look at the January 2022 bar, not the December 2021 one.

Do you see my point? In some cases I can see this making sense, but not for 
this use case. A period’s balance should be calculated from the end of the 
period, not the start.

Could an option be added to use the end of a period vs the start? 

Thanks for considering,
Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

[Colin Arndt]

Mystery solved - FlatHub dropped support for 32-bit ARM OS’s, which is what I’m 
on. 

This means my issue is separate from Pagar’s. Sorry for muddying the thread.

> On Apr 26, 2022, at 1:28 PM, Colin Arndt  wrote:
> 
> One more note: 
> 4.4 was the current version when I installed GnuCash last year. My issue 
> might be different from Parag’s then.
> 
> - My install was current at the time of install, but has been frozen since. 
> 
> - Parag’s install seems to be offering him an ancient version from the start.
> 
>> On Apr 26, 2022, at 1:25 PM, Colin Arndt > <mailto:colinfar...@gmail.com>> wrote:
>> 
>> Hi Frank,
>> 
>> I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let 
>> me update beyond 4.4 in Flathub, because it doesn’t detect any newer 
>> versions.
>> 
>> I’ve run the commands you sent, with the output redirected to files, but the 
>> files don't show any fields beyond what Parag posted. 
>> 
>> They’re attached. In essence they show my architecture is arm and that the 
>> latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).
>> 
>> Thanks,
>> Colin
>> 
>> 
>> 
>> 
>> 
>>> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org 
>>> <mailto:gnucash-user-requ...@gnucash.org> wrote:
>>> 
>>> Message: 6
>>> Date: Tue, 26 Apr 2022 13:41:26 +0200
>>> From: "Frank H. Ellenberger" >> <mailto:frank.h.ellenber...@gmail.com>>
>>> To: parag puranik mailto:parag_pura...@yahoo.com>>
>>> Cc: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>" 
>>> mailto:gnucash-user@gnucash.org>>
>>> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>>> but only installs lower ver. 3.7
>>> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
>>> <mailto:5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com>>
>>> Content-Type: text/plain; charset=UTF-8
>>> 
>>> Hi,
>>> 
>>> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
>>> shortened away. Can you redo them in a full screen window or by
>>> redirecting into a file like:
>>> 
>>> flatpak remotes -d >fp-state
>>> flatpak search gnucash >>fp-state
>>> 
>>> Regards
>>> Frank
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

[Colin Arndt]

One more note: 
4.4 was the current version when I installed GnuCash last year. My issue might 
be different from Parag’s then.

- My install was current at the time of install, but has been frozen since. 

- Parag’s install seems to be offering him an ancient version from the start.

> On Apr 26, 2022, at 1:25 PM, Colin Arndt  wrote:
> 
> Hi Frank,
> 
> I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let me 
> update beyond 4.4 in Flathub, because it doesn’t detect any newer versions.
> 
> I’ve run the commands you sent, with the output redirected to files, but the 
> files don't show any fields beyond what Parag posted. 
> 
> They’re attached. In essence they show my architecture is arm and that the 
> latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).
> 
> Thanks,
> Colin
> 
> 
> 
> 
> 
>> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org 
>> <mailto:gnucash-user-requ...@gnucash.org> wrote:
>> 
>> Message: 6
>> Date: Tue, 26 Apr 2022 13:41:26 +0200
>> From: "Frank H. Ellenberger" > <mailto:frank.h.ellenber...@gmail.com>>
>> To: parag puranik mailto:parag_pura...@yahoo.com>>
>> Cc: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>" 
>> mailto:gnucash-user@gnucash.org>>
>> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>>  but only installs lower ver. 3.7
>> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
>> <mailto:5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com>>
>> Content-Type: text/plain; charset=UTF-8
>> 
>> Hi,
>> 
>> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
>> shortened away. Can you redo them in a full screen window or by
>> redirecting into a file like:
>> 
>> flatpak remotes -d >fp-state
>> flatpak search gnucash >>fp-state
>> 
>> Regards
>> Frank
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

[Colin Arndt]

Hi Frank,

I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let me 
update beyond 4.4 in Flathub, because it doesn’t detect any newer versions.

I’ve run the commands you sent, with the output redirected to files, but the 
files don't show any fields beyond what Parag posted. 

They’re attached. In essence they show my architecture is arm and that the 
latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).

Thanks,
Colin



> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 6
> Date: Tue, 26 Apr 2022 13:41:26 +0200
> From: "Frank H. Ellenberger"  >
> To: parag puranik mailto:parag_pura...@yahoo.com>>
> Cc: "gnucash-user@gnucash.org " 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>   but only installs lower ver. 3.7
> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
> >
> Content-Type: text/plain; charset=UTF-8
> 
> Hi,
> 
> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
> shortened away. Can you redo them in a full screen window or by
> redirecting into a file like:
> 
> flatpak remotes -d >fp-state
> flatpak search gnucash >>fp-state
> 
> Regards
> Frank

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 4.10 cannot be opened on macOS Big Sur w/Apple Silicon

[Colin Arndt]

I can confirm. Running 4.10 off the GitHub .dmg on Monterey 12.3, MacBook Air 
with M1 CPU.

As soon as I start entering text in the description field of a transaction, the 
application crashes.

Thanks,
Colin

> On Mar 28, 2022, at 4:34 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> --
> 
> Message: 6
> Date: Tue, 29 Mar 2022 06:03:26 +1000
> From: David H mailto:hell...@gmail.com>>
> To: john mailto:jra...@ceridwen.us>>
> Cc: William Prescott mailto:w...@theprescotts.com>>, 
> GnuCash Users
>   mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] 4.10 cannot be opened on macOS Big Sur w/Apple
>   Silicon
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> John,
> 
> FYI it doesn't work for me on Monterey on an Intel based MacBook Pro. It
> opens at least but when adding a new txn as soon as I type a single letter
> in the description Gnucash just disappears entirely :-( On Big Sur it
> doesn't open just displays the error message reported by others.
> 
> Cheers David H.

___
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] 4.10 cannot be opened on macOS Big Sur w/Apple Silicon

[Colin Arndt]

I can confirm. Running 4.10 off the GitHub .dmg on Monterey 12.3, MacBook Air 
with M1 CPU.

As soon as I start entering text in the description field of a transaction, the 
application crashes.

Thanks,
Colin

> On Mar 28, 2022, at 4:34 PM, gnucash-user-requ...@gnucash.org 
>  wrote:
> 
> --
> 
> Message: 6
> Date: Tue, 29 Mar 2022 06:03:26 +1000
> From: David H mailto:hell...@gmail.com>>
> To: john mailto:jra...@ceridwen.us>>
> Cc: William Prescott mailto:w...@theprescotts.com>>, 
> GnuCash Users
>   mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] 4.10 cannot be opened on macOS Big Sur w/Apple
>   Silicon
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> John,
> 
> FYI it doesn't work for me on Monterey on an Intel based MacBook Pro. It
> opens at least but when adding a new txn as soon as I type a single letter
> in the description Gnucash just disappears entirely :-( On Big Sur it
> doesn't open just displays the error message reported by others.
> 
> Cheers David H.
___
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] Bitcoin is legal currency in El Salvador - why not add BTC?

[Colin Arndt]

I see those ? marks all the time, it’s not just you. 

I'd guess the mailman system either doesn’t support characters in your message… 
or my Mac doesn’t support what mailman is generating. The fact that I get 
messages as digests could have something to do with it too.

> On Dec 10, 2021, at 1:21 PM, gcul...@mynym.us wrote:
> 
> No big deal, I have the same problem in person, but agree text can make it 
> worse.  Any clue where those question marks in the quote of my e-mail are 
> coming from?  I didn't type them and don't see them in my sent message, but 
> they certainly make it look disingenuous.
> 
> On 12/10/21 4:08 PM, Colin Arndt wrote:
>> Hi Dustin,
>> 
>> Allow me to apologize as well, if I misread your message as being harsher 
>> than it was. It’s easy to do that over text and it wouldn’t be my first 
>> time. At the very least - I learned what shotgun argumentation is!
>> 
>> I’ll take a crack at that new wiki section soon. 
>> 
>> Thanks everyone,
>> Colin
>> 
>>> On Dec 10, 2021, at 12:28 PM, gnucash-user-requ...@gnucash.org 
>>> <mailto:gnucash-user-requ...@gnucash.org> wrote:
>>> 
>>> Dave & group,
>>> 
>>> In case Colin is correct, allow me to apologize (hopefully not equally 
>>> poorly) for being out of line here and now.? I'm sorry if I seemed 
>>> accusatory or offensive, as that was not my intent.? While I do believe 
>>> that this conversation has run its course, I would like to elaborate a 
>>> bit on my choice of words.? Perhaps ad hominem is not the correct 
>>> definition for the ISO discussion, but I do believe that the number of 
>>> bullet points provided with little-to-nothing to do with currency does 
>>> qualify as shotgun argumentation.? Regardless my intent was to instill 
>>> self-reflection, not recoil.
>>> 
>>> Colin,
>>> 
>>> While I have no official capacity here, I would encourage you to go 
>>> ahead with the wiki contributions if you have relevant access.? After 
>>> all, it is a wiki.
>>> 
>>> Dustin
>> 

___
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] Bitcoin is legal currency in El Salvador - why not add BTC?

[Colin Arndt]

Hi Dustin,

Allow me to apologize as well, if I misread your message as being harsher than 
it was. It’s easy to do that over text and it wouldn’t be my first time. At the 
very least - I learned what shotgun argumentation is!

I’ll take a crack at that new wiki section soon. 

Thanks everyone,
Colin

> On Dec 10, 2021, at 12:28 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Dave & group,
> 
> In case Colin is correct, allow me to apologize (hopefully not equally 
> poorly) for being out of line here and now.? I'm sorry if I seemed 
> accusatory or offensive, as that was not my intent.? While I do believe 
> that this conversation has run its course, I would like to elaborate a 
> bit on my choice of words.? Perhaps ad hominem is not the correct 
> definition for the ISO discussion, but I do believe that the number of 
> bullet points provided with little-to-nothing to do with currency does 
> qualify as shotgun argumentation.? Regardless my intent was to instill 
> self-reflection, not recoil.
> 
> Colin,
> 
> While I have no official capacity here, I would encourage you to go 
> ahead with the wiki contributions if you have relevant access.? After 
> all, it is a wiki.
> 
> Dustin

___
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] Bitcoin is legal currency in El Salvador - why not add BTC?

[Colin Arndt]

Dave,

For what it’s worth, I think the accusations of you using ad hominem and 
shotgun arguments were more out of line than your original message. I re-read 
what you wrote after those comments were made and was left scratching my head. 
I didn’t see those things in the points you raised or the manner in which you 
raised them. 

I think we all respect the developers’ decisions here and I would ask people 
not to be so quick to accuse people otherwise. GnuCash is after all an 
open-source project and open discussion is part of the process.

In my view, this thread has reiterated the strong feelings that Bitcoin and 
cryptocurrencies raise in supporters and non-supporters *both*. This is why I 
kept my comments more muted in my earlier message and didn’t advocate for 
changes to GnuCash. I just didn’t want to wade into the mud. 

Having said that, I have been completely satisfied with the workaround. It’s 
quite easy to set up and use crypto as securities in GnuCash - I’d really 
suggest anyone interested give that a try.

Do I need permission from someone in particular to update the wiki as suggested 
earlier, or can I just go ahead and do it? Afterwards I can post here for 
review if desired.

Thanks,
Colin

> Date: Fri, 10 Dec 2021 16:29:45 +
> From: "Dr. David Kirkby" 
> Cc: GNU Cash User 
> Subject: Re: [GNC] Bitcoin is legal currency in El Salvador - why not
>   add BTC?
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
> 
> On Fri, 10 Dec 2021 at 16:12, Dustin Henning  wrote:
> 
>> 
>> To be frank, considering all of that makes
>> it look to me like you have an agenda here.  The team has already given
>> you an appropriate answer, and now you are resorting to ad hominem and
>> shotgun argumentation.
> 
> 
> That was not my intention. I will cease the discussion.
> 
> Dave
> 
___
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] Bitcoin is legal currency in El Salvador - why notadd BTC?

[Colin Arndt]

To set the record straight, David is correct. Over a long period of time I had 
BTC set up as a custom security bringing in quotes via Yahoo JSON. You simply 
need to enter ‘BTC-USD’ as the symbol, since this is the format Yahoo Finance 
uses, as well as allow 8 decimal places (Fraction traded = 1/100,000,000). 
Attached is a screenshot of the full settings I used in the Security Editor.

Michael, it seems your concern with bringing in quotes is that Bitcoin is not 
sufficiently liquid or available for public trading? In a former life I traded 
Bitcoin and I can tell you that is certainly not the case (unless you live in 
China or a handful of other oppressive countries where it is banned). John made 
the point earlier that its primary use is as a speculative vehicle, not a 
currency, used by traders. That is certainly true. Others have mentioned how 
much is traded daily (I can’t remember how many billions it is at the moment). 
It is highly liquid.

Considering this is an issue that regularly comes up on the list, it might save 
everyone some time if there were a statement or section on the Wiki. (Just 
searched around and didn’t find one). 

I would be happy to contribute something incorporating John’s earlier comments: 
Bitcoin is not supported as a currency in GnuCash and will not be until it is 
added to [insert ISO standard he mentioned]. However, it can be added as a 
custom security with [lengthier version of the instructions I gave above]. 

Best,
Colin



> Date: Thu, 9 Dec 2021 17:57:05 -0500
> From: Michael or Penny Novack 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Bitcoin is legal currency in El Salvador - why
>   notadd BTC?
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> On 12/9/2021 4:20 PM, David G. Pickett via gnucash-user wrote:
>> I would think you can treat it as a security and probably get quotes 
>> imported just like for stocks.? But I suppose that begs the question of how 
>> easily you could receive BTC or the like into one of your security 
>> accounts.? Does GNUCash do income in securities?
> 
> I will repeat, it is a big assumption "probably get quotes imported just 
> like for stocks". You can get quotes for widely held publicly traded 
> stocks. Stocks that are liquid. Far less easy to place a value on 
> closely held stocks or any stocks that are not publicly traded on a 
> major exchange. Do you know what OTC or "pink sheets" mean?
> 
> Michael D Novack
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Serious issues with Mac OS update - 12.0.1

[Colin Arndt]

I’m on an M1 MacBook Air and the issues people reported for Monterey showed up 
for me as well. They were also resolved with 4.8-2.

This makes sense because we’re all running the same binary. GnuCash is not 
currently being built for Apple Silicon. (macOS takes care of translating 
x86_64 binaries to aarm64 on first launch)

Best,
Colin

On Oct 26, 2021, at 10:18 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> --
> 
> Message: 12
> Date: Wed, 27 Oct 2021 16:17:10 +1100
> From: prl mailto:p...@ozemail.com.au>>
> To: gnucash.dg...@ncf.ca , 
> gnucash-user@gnucash.org 
> Subject: Re: [GNC] Serious issues with Mac OS update - 12.0.1
> Message-ID:  >
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Yes, I saw that. I fixed it by installing Intel GnuCash 4.8-2, even 
> though the GnuCash release notes for 4.8 say "[t]he macOS and Win32 
> GnuCash bundles were not affected".
> 
> Perhaps that could be corrected, since 4.8-2 seems to have fixes for 
> macOS 12.0.1 Monterey, at least for Intel Macs.
> 
> I'm not sure whether there are similar problems for the M1 Macs.
> 
> Cheers,
> Peter

___
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] Net Worth Linechart report - can't select hidden accounts

[Colin Arndt]

Yes, this is exactly it. The line chart shows a span of time. I currently have 
5 years’ history in GnuCash and that includes several accounts which are no 
longer active. For example, I’ve moved a couple times since then and opened and 
closed credit union accounts as a result. 

Show Hidden Accounts is already an option in the report settings, it just 
doesn’t work in the current software, for who knows what reason.

I opened a bug report for this issue here: 
https://bugs.gnucash.org/show_bug.cgi?id=798348

The GnuCash dev team is fantastic and I’m sure they'll get to it when they can.

Thanks,
Colin

> On Oct 26, 2021, at 9:00 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> --
> 
> Message: 7
> Date: Mon, 25 Oct 2021 19:45:56 -0400
> From: "D." 
> To: Adrien Monteleone 
> Cc: GnuCash-User 
> Subject: Re: [GNC] Net Worth Linechart report - can't select hidden
>   accounts
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8
> 
> Not to put words into Colin's mouth, but the linechart report covers a period 
> of time, which can be configured in options. So, it's entirely possible 
> (likely, in fact), that such a report would need to draw on hidden accounts 
> to determine overall status, even if they are now zero balance. 
> 
> 
>  Original Message 
> From: Adrien Monteleone 
> Sent: Mon Oct 25 17:53:36 EDT 2021
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Net Worth Linechart report - can't select hidden accounts
> 
> You are no longer using those accounts (have hidden them) and they do 
> not contain a zero balance?
> 
> While maybe the setting *should* stick, I think it a fair assumption not 
> to use hidden accounts in a NetWorth chart/report as they should 
> generally have a zero balance and thus not affect the equation at all.
> 
> Including them or not, should not have an affect on the chart/report.
> 
> (unless you are hiding them for some reason other than that they are now 
> zero, and no longer needed)
> 
> Regards,
> Adrien
> 
> On 10/15/21 4:59 PM, Colin Arndt wrote:
>> Since the Net Worth report goes back several years, it includes accounts 
>> that I?ve since sunsetted and hidden in GnuCash. If I can?t include these in 
>> the report, it?s not nearly as accurate or useful.
>> 
>> Thanks for any help on this,
>> Colin
> 
> ___
> 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.
> 
> 
> --
> 
> Message: 8
> Date: Mon, 25 Oct 2021 19:27:50 -0500
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Net Worth Linechart report - can't select hidden
>   accounts
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Yes, sorry. I wasn't thinking that if the chart covers a time period 
> where the account is involved, that may show assets or liabilities 
> increasing or decreasing across that part of the chart, which wouldn't 
> be possible if those accounts were not included.
> 
> I was only thinking of a snapshot of the present.
> 
> Regards,
> Adrien
> 
> On 10/25/21 6:45 PM, D. via gnucash-user wrote:
>> Not to put words into Colin's mouth, but the linechart report covers a 
>> period of time, which can be configured in options. So, it's entirely 
>> possible (likely, in fact), that such a report would need to draw on hidden 
>> accounts to determine overall status, even if they are now zero balance.
> 
> 
> 
> --
> 
> Subject: Digest Footer
> 
> ___
> 
> 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.
> 
> 
> --
> 
> End of gnucash-user Digest, Vol 223, Issue 61
> *

___
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] Net Worth Linechart report - can't select hidden accounts

[Colin Arndt]

Thanks David. I’ll file a bug report on this if I don’t hear any other 
responses in the next few days.

Best,
Colin

> On Oct 18, 2021, at 7:05 PM, D.  wrote:
> 
> 
> I see the same behavior with GC 4.8 under Windows 10, with the Net Worth 
> Linechart as well as with other reports that use the View Hidden Accounts 
> option. It's probably related to the fix for bug 363339 
> (https://bugs.gnucash.org/show_bug.cgi?id=363339), which was closed as fixed 
> in 2009. Odd that no one noticed before this. 
> 
> As a short term fix, I'd unhide the accounts in question, which can be 
> quickly done from the Chart of Accounts page if you have the hidden flag set 
> to show in the tree. You can check and uncheck as many accounts as you like 
> (of course, set the view to show hidden accounts).
> 
> David T. 
> 
> By the way, it usually takes a little more time for people to respond to 
> issues raised on the list-- especially when the issue is a technical one, 
> like this one is. Patience is a virtue.
> From: Colin Arndt 
> Sent: Mon Oct 18 12:03:24 EDT 2021
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Net Worth Linechart report - can't select hidden accounts
> 
> Just bumping this question. Does anyone have experience or thoughts on this? 
> 
> Thanks,
> Colin
> 
>>  On Oct 15, 2021, at 2:59 PM, Colin Arndt  wrote:
>>  
>>  Running the latest 4.8-2 on macOS, and for some time now, I’ve noticed if I 
>> select any hidden accounts for this report, the setting doesn’t stick. 
>>  
>>  Going into Options, I select Accounts, then “Show Hidden Accounts.” After 
>> selecting the relevant accounts, I click Apply and close out the window. 
>> When I come back to the Options screen and re-display Hidden Accounts to 
>> verify they’re active... I see they’ve unselected themselves.
>>  
>>  Since the Net Worth report goes back several years, it includes accounts 
>> that I’ve since sunsetted and hidden in GnuCash. If I can’t include these in 
>> the report, it’s not nearly as accurate or useful.
>>  
>>  Thanks for any help on this,
>>  Colin
> 
> 
> 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] Net Worth Linechart report - can't select hidden accounts

[Colin Arndt]

Just bumping this question. Does anyone have experience or thoughts on this? 

Thanks,
Colin

> On Oct 15, 2021, at 2:59 PM, Colin Arndt  wrote:
> 
> Running the latest 4.8-2 on macOS, and for some time now, I’ve noticed if I 
> select any hidden accounts for this report, the setting doesn’t stick. 
> 
> Going into Options, I select Accounts, then “Show Hidden Accounts.” After 
> selecting the relevant accounts, I click Apply and close out the window. When 
> I come back to the Options screen and re-display Hidden Accounts to verify 
> they’re active... I see they’ve unselected themselves.
> 
> Since the Net Worth report goes back several years, it includes accounts that 
> I’ve since sunsetted and hidden in GnuCash. If I can’t include these in the 
> report, it’s not nearly as accurate or useful.
> 
> Thanks for any help on this,
> Colin

___
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] Net Worth Linechart report - can't select hidden accounts

[Colin Arndt]

Running the latest 4.8-2 on macOS, and for some time now, I’ve noticed if I 
select any hidden accounts for this report, the setting doesn’t stick. 

Going into Options, I select Accounts, then “Show Hidden Accounts.” After 
selecting the relevant accounts, I click Apply and close out the window. When I 
come back to the Options screen and re-display Hidden Accounts to verify 
they’re active... I see they’ve unselected themselves.

Since the Net Worth report goes back several years, it includes accounts that 
I’ve since sunsetted and hidden in GnuCash. If I can’t include these in the 
report, it’s not nearly as accurate or useful.

Thanks for any help on this,
Colin
___
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] Add a donate button in GnuCash (Glenn Fowler)

[Colin Arndt]

Hi Glenn,

Thank you for mentioning this. I'm embarassed to admit I've been a heavy user 
since setting up GnuCash almost a year ago - but didn't realize the website had 
a donate button until you mentioned it!
Therefore I agree about adding tastefully to the program. In my case, I can 
only imagine I saw the donate option on the website when I first learned of 
GnuCash, but didn't consider donating as someone who hadn't tried it yet. Since 
then, I've spent my time in the program itself or on the mailing list rather 
than the website, so had completely forgotten about that option.
Headed to the website now to donate,
Colin

On May 1 2021, at 9:58 am, gnucash-user-requ...@gnucash.org wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
> 1. Re: Finance Quote after a MacOS update (David Reiser)
> 2. Re: Cut & Paste transaction problem (John Ralls)
> 3. Re: Separate file for each financial year vs single file (Uttam)
> 4. [MAINT] Unplanned network outage (Derek Atkins)
> 5. Re: Finance Quote after a MacOS update (Outlook)
> 6. Permission to use GNUCash (Andrew O'Neill)
> 7. Add a donate button in GnuCash (Glenn Fowler)
>
>
> --
> Message: 1
> Date: Fri, 30 Apr 2021 12:23:51 -0400
> From: David Reiser 
> To: Outlook 
> Cc: John Ralls , Gnucash Users
> 
> Subject: Re: [GNC] Finance Quote after a MacOS update
> Message-ID: <6165ee62-5598-444c-82f9-c38785d06...@icloud.com>
> Content-Type: text/plain; charset=utf-8
>
> Apple is not including the Perl headers location in CPATH these days. I?ve 
> never figured out authoritatively how to avoid installing two versions of the 
> Command Line Tools, so if you follow the following recipe, you?ll likely have 
> one set inside XCode and one in /Library/Developer
> xcode-select ?install
> export 
> CPATH=/Library/Developer/CommandLineTools/SDKs/MacOSX11.3.sdk/System/Library/Perl/5.30/darwin-thread-multi-2level/CORE:$CPATH
>
> then run the cpan commands
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Apr 30, 2021, at 11:27 AM, Outlook  wrote:
> >
> > sudo /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> >
> > Reported
> >
> > Can't locate JSON/Parse.pm in @INC (you may need to install the JSON::Parse 
> > module) (@INC contains: /Library/Perl/5.30/darwin-thread-multi-2level 
> > /Library/Perl/5.30 /Network/Library/Perl/5.30/darwin-thread-multi-2level 
> > /Network/Library/Perl/5.30 
> > /Library/Perl/Updates/5.30.2/darwin-thread-multi-2level 
> > /Library/Perl/Updates/5.30.2 
> > /System/Library/Perl/5.30/darwin-thread-multi-2level 
> > /System/Library/Perl/5.30 
> > /System/Library/Perl/Extras/5.30/darwin-thread-multi-2level 
> > /System/Library/Perl/Extras/5.30) at 
> > /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> > BEGIN failed--compilation aborted at 
> > /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> > Compilation failed in require at (eval 293) line 1.
> > BEGIN failed--compilation aborted at (eval 293) line 1.
> > at /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check line 91.
> > Can't locate object method "methods" via package 
> > "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line 
> > 120.
> >
> >
> > sudo cpan -f -i JSON::Parse
> >
> > Reported errors as below
> >
> > Parse.xs:1:10: fatal error: 'EXTERN.h' file not found
> > #include "EXTERN.h"
> > ^~
> > 1 error generated.
> > make: *** [Parse.o] Error 1
> > BKB/JSON-Parse-0.61.tar.gz
> > /usr/bin/make -- NOT OK
> >
> > Stuck here??
> >
> >
> >> David Reiser mailto:dbrei...@icloud.com>> ? 
> >> 2021?4?28? ??5:44 ???
> >>
> >> Done.
> >> --
> >> Dave Reiser
> >> dbrei...@icloud.com 
> >>
> >>
> >>
> >>
> >>
> >>> On Apr 27, 2021, at 12:50 AM, John Ralls  wrote:
> >>>
> >>> Having seen David's earlier post I did
> >>> sudo cpan install Test2
> >>> sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
> >>>
> >>> which ran successfully, after which 
> >>> /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check reported 
> >>> the usual list of sources.
> >>>
> >>> Anyone care to open an issue at 
> >>> 

Re: [GNC] Lost all settings after Flatpak update

[Colin Arndt]

Hi Ken,

Thanks for bringing this up. I experienced the same thing on Fedora 33 but 
didn't take the time to ask about it.
The welcome screen and tips displayed again and I had to re-enter my 
preferences for register display, etc. I remember thinking this was odd, which 
leads me to believe it hasn't happened with prior Flatpak updates. Would be 
curious to hear more about what might have happened.
Best,
Colin

> Message: 7
> Date: Thu, 1 Apr 2021 22:40:52 +0800
> From: km22 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Lost all settings after Flatpak update
> Message-ID: <1de79af5-bfe4-9028-be63-e137b5eb3...@gmx.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> Hi,
> I am a Debian user and install Gnucash using Flatpak. I think Flatpak is
> setup to update automatically and the latest version of Gnucash seems to
> have been installed as of March 28th.
>
> When I started Gnucash I was presented with the typical popup tips and
> dialogs to set up a new user file from scratch.? The system did not
> remember any of my recently used files.? When I opened a recent gnucash
> file it loaded but all my settings are gone. For instance my tabs are
> all horizontal at the top of the screen rather than vertically to the left.
>
> Do you know whether it is normal for Flatpak updates to case user
> settings to be lost?? Is there a way to restore my previous settings?
>
> Thanks,
> Ken
>
___
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] Access GNUCash From Different Devices

[Colin Arndt]

The Android app hasn't been updated in almost 3 years now, unfortunately. The 
maintainer kept up with it for 6 years beforehand, so I certainly don't 
begrudge him for moving on with his life. In the github threads someone offered 
to release a fork with the pull requests merged, but the link he included is no 
longer good.

I'd be genuinely interested in how others handle the use case for the mobile 
app. Seeing reports and charts from my phone could be useful. But as far as the 
data entry side, I don't think I'm missing out there. (Disclaimer: I tried 
importing my books into the Android app but it errored out, so I haven't seen 
it in action).
My workflow is to update my books once a week, mostly from QFX imports or 
manual entry off of online statements. It takes maybe 10 minutes total. Cash 
transactions are the only thing I need to record on my phone and a simple text 
note works for that. I do almost nothing in cash these days and so manually 
entering these in GnuCash takes 1-2 minutes.
Given that workflow, entering them more formally in a mobile app, exporting the 
CSV and importing it into GnuCash on my computer would not be worth the extra 
work.
Cheers,
Colin

>
> Date: Sat, 6 Mar 2021 06:55:55 +1000
> From: David H 
> To: David Carlson 
> Cc: Kenneth Schneider , GnuCash Users List
> 
> Subject: Re: [GNC] Access GNUCash From Different Devices
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> Dated but probably still usable ?
> https://github.com/codinguser/gnucash-android
>
> Cheers David H.
>
___
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] systemd / sqlite 3 file not found error

[Colin Arndt]

Hi John and Will,

Thanks for the responses and help troubleshooting!
It was super simple to specify this to be run as my user account in the service 
file. The technique is to add a "User=" line. In case anyone else is 
interested, here's what worked. Change the path and username to suit.
/etc/systemd/system/priceget.service has the contents:
[Unit]
Description=Get price quotes in GnuCash

[Service]
Type=simple
ExecStart=/usr/bin/flatpak run --command=gnucash-cli org.gnucash.GnuCash 
--quotes get /path/to/books.gnucash
User=yourusername

[Install]
WantedBy=multi-user.target

/etc/systemd/system/priceget.timer has the contents:
[Unit]
Description=Get price quotes in GnuCash

[Timer]
OnCalendar=Mon 09:00:00
Persistent=true

[Install]
WantedBy=timers.target

Best,
Colin

On Dec 13 2020, at 12:59 pm, John Ralls  wrote:
> No, but using flatpak (or any other container system) adds constraints on 
> what you can do because of the sandbox. Surely you can get systemd to run the 
> job as you instead of as root.
>
> Regards,
> John Ralls
>
> > On Dec 13, 2020, at 10:28 AM, Colin Arndt  wrote:
> >
> > Hi John,
> >
> > Flatpak access makes sense as the culprit.
> >
> > The .gnucash file is in my home folder.
> >
> > The command completes when I run it as my user. Run as root, it fails.
> >
> > Perhaps I'm trying to do something in a way it's not designed to be used?
> >
> > Thanks again,
> > Colin
> >
> >
> > On Dec 13 2020, at 10:10 am, John Ralls  wrote:
> >
> >
> > > On Dec 13, 2020, at 9:57 AM, Colin Arndt  wrote:
> > >
> > > Hi all,
> > >
> > > On Fedora Linux here, and I am trying to set up a systemd timer to pull 
> > > price quotes once a week using gnucash-cli. Previously I was using cron 
> > > to accomplish this, but would like to migrate to a systemd timer because 
> > > this is on a laptop and I never know when it will be on or off. Systemd 
> > > timers can handle missed execution times gracefully by simply running the 
> > > command the next time the system is up.
> > > I've set it up to execute this command:
> > > /usr/bin/flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes 
> > > get /path/to/Books-sql.gnucash
> > >
> > > Strangely, this produces a file not found error even though I've verified 
> > > the path is correct.
> > > * 09:50:20 WARN  [GncDbiBackend::session_begin()] 
> > > Sqlite3 file Books-sql.gnucash not found
> > > * 09:50:20 ERROR  [scm_cleanup_and_exit_with_failure()] Session 
> > > Error: Sqlite3 file Books-sql.gnucash not found
> > > This isn't an issue with how I've set up the systemd timer or service, 
> > > because when I run it as root from the command line, I get the same 
> > > result.
> > > Thanks for any insight!
> >
> > Is /path/to somewhere accessible by the flatpak's sandbox?
> >
> > Regards,
> > John Ralls
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] systemd / sqlite 3 file not found error

[Colin Arndt]

Hi John,

Flatpak access makes sense as the culprit.
The .gnucash file is in my home folder.
The command completes when I run it as my user. Run as root, it fails.
Perhaps I'm trying to do something in a way it's not designed to be used?
Thanks again,
Colin

On Dec 13 2020, at 10:10 am, John Ralls  wrote:
>
>
> > On Dec 13, 2020, at 9:57 AM, Colin Arndt  wrote:
> >
> > Hi all,
> >
> > On Fedora Linux here, and I am trying to set up a systemd timer to pull 
> > price quotes once a week using gnucash-cli. Previously I was using cron to 
> > accomplish this, but would like to migrate to a systemd timer because this 
> > is on a laptop and I never know when it will be on or off. Systemd timers 
> > can handle missed execution times gracefully by simply running the command 
> > the next time the system is up.
> > I've set it up to execute this command:
> > /usr/bin/flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get 
> > /path/to/Books-sql.gnucash
> >
> > Strangely, this produces a file not found error even though I've verified 
> > the path is correct.
> > * 09:50:20 WARN  [GncDbiBackend::session_begin()] 
> > Sqlite3 file Books-sql.gnucash not found
> > * 09:50:20 ERROR  [scm_cleanup_and_exit_with_failure()] Session 
> > Error: Sqlite3 file Books-sql.gnucash not found
> > This isn't an issue with how I've set up the systemd timer or service, 
> > because when I run it as root from the command line, I get the same result.
> > Thanks for any insight!
>
> Is /path/to somewhere accessible by the flatpak's sandbox?
> Regards,
> John Ralls
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] systemd / sqlite 3 file not found error

[Colin Arndt]

Hi all,

On Fedora Linux here, and I am trying to set up a systemd timer to pull price 
quotes once a week using gnucash-cli. Previously I was using cron to accomplish 
this, but would like to migrate to a systemd timer because this is on a laptop 
and I never know when it will be on or off. Systemd timers can handle missed 
execution times gracefully by simply running the command the next time the 
system is up.
I've set it up to execute this command:
/usr/bin/flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get 
/path/to/Books-sql.gnucash

Strangely, this produces a file not found error even though I've verified the 
path is correct.
* 09:50:20 WARN  [GncDbiBackend::session_begin()] 
Sqlite3 file Books-sql.gnucash not found
* 09:50:20 ERROR  [scm_cleanup_and_exit_with_failure()] Session Error: 
Sqlite3 file Books-sql.gnucash not found
This isn't an issue with how I've set up the systemd timer or service, because 
when I run it as root from the command line, I get the same result.
Thanks for any insight!
Colin
___
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] Run gnucash-cli commands with Flaptak install?

[Colin Arndt]

Hi all,

I recently switched from an Arch-based system where I had a cron job running 
gnucash-cli once a week to update my security quotes. Now I'm on Fedora 32 and 
would like to set up a systemd timer to do the same thing (because as it turns 
out, systemd is way better at this. What did I know?)
The only issue is now I'm on the Flatpak version, and of course the host system 
does not possess the gnucash-cli command. I'm not sure how to automate it now.
I used to run:
gnucash-cli --quotes get /path/to/GnuCashfile

>From the docs I can see I need to enter the following to enter the GnuCash 
>command line environment:
flatpak run --command=sh org.gnucash.GnuCash

Can these be combined into a single command on the host system? Feel free to 
let me know if this is more of a Flatpak question than a GnuCash one, though I 
figured others may have experience with this. If nothing else, getting the 
solution in the list here gets it into the archives if others want to replicate 
it.
Thanks,
Colin

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