Re: [GNC] Switching to trading accounts in existing database

[Mike Alexander]

When I implemented trading accounts several years ago they were a bit 
controversial.  Some people thought they were more trouble than they 
were worth and argued that they should be an opt-in choice.  One of the 
initial design goals was that if you didn't turn them on nothing would 
change in the way GnuCash behaved.  The initial implementation had some 
rough edges too, which didn't help.  It's been a while since any 
significant problems have come up with them (although a new bug was 
filed on them today) so maybe this question should be revisited.


It's also the case that the user interface leaves a bit to be desired.  
It is harder than it should be to enter multi-currency transactions with 
trading accounts turned on.  At the time I implemented them there was an 
effort underway to rewrite the code that supports the register UI and 
the new implementation would have improved this.  Unfortunately that 
effort was later abandoned and we're left with the old UI code.  I have 
ideas for how to improve it, but my time and ability to do much coding 
is limited these days so I probably won't get to it soon.  See 
https://bugs.gnucash.org/show_bug.cgi?id=797913 for more information 
about this.


I know what you mean about multiple currencies.  I haven't moved around 
as often as you have, but I've lived in a couple of countries and spend 
a lot of time traveling in various others.  I think I have accounts in 
nearly 30 currencies over a 30 year period.  I used to have income and 
expense accounts in multiple currencies, but this turned out to not work 
well so I now use only one currency for all of them and convert 
transactions in other currencies into USD.  This works for me since it 
is still my home currency although I am under increasing pressure to 
move to Canada.


Mike

On 21 Jan 2021, at 21:06, Lukas Haase wrote:


Hi Christopher,

This is very sad. Sad for various reasons.

I went over these documents previously (but did not read them 
thoroughly).


My takeaway is:
* Storing the conversion rate per transaction makes the accounting 
equation as a function of time inconsistent (but it is consistent for 
each snaphot in time).

* Trading account accounts for these inaccuracies.

My question was more why the trading accounts (which seem to me the 
cleaner, superior and better way) are not enabled by default.


Also, can you comment a bit more why precicely this would be a major 
minefield? (If you know it, of course).


Multiple databases are just extremely hard for some people (like me).

Consider living for a couple of months to a year in a different place. 
There is just no way to separate this in a clean way without 
replicating all the transactions in different databases. BTDT.


Also I moved multiple times. Even then, there is no clear cut: 
Initially I would use credit cards, ATM etc. from previous country. 
Even the first or second rent may be partially paid with funds from 
the previous location. It takes a few months until I could consider 
the books between two countries sufficiently separate. The only ways 
are a) Massive transaction Replication b) booking everything I pay 
with funds from old country into old database. But with my rent 
example, it gets very inconsistent how much I paid rent at the new 
place.


Lastly, simple portfolio accounting (e.g. crypto currencies) if they 
are bought in different countries.


I am curious what the potential mines are so I can try to avoid them.

Lukas



On 2021-01-21 20:20, Christopher Lam wrote:

Multicurrency is a major minefield.
Start from 
https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html

and finish with
https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
background on trading accounts.
 From discussion with accountant, it would seem that the safest 
approach is
to have 1 book per home currency. When you move countries you'd be 
better
off with a new book with a new home currency. Taking temporary trips 
abroad

gets the currencies translated to home currency. AFAIU. IANAA YMMV.
https://techcrunch.com/2010/08/14/internet-must-be-true/

On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:


Hi Mike,

On 2021-01-21 02:24, Mike Alexander wrote:

On 19 Jan 2021, at 20:08, Lukas Haase wrote:


So I got recommended using trading accounts. But suddenly all my
previous multi-currency transactions get a small grey box with a 
cross

(hinting the transaction is inconsistent).

How do I best deal with this?
Is it possible to keep my old multi currency transactions as-is 
and

use trading accounts only for securities/stocks?

If not, how do I migrate while ensuring my ten years worth of data
does not suddenly get inconsistent?


You should be able to use the "Check & Repair" commands in the 
Actions

menu to add the trading account splits to existing transactions.  I
would certainly save a copy of my data before doing this, and try 
it on
a few transactions first.  Your situation is complex enough that it 
is
not 

Re: [GNC] Switching to trading accounts in existing database

[Christopher Lam]

https://www.accaglobal.com/us/en/technical-activities/technical-resources-search/2015/march/frs102-foreign-currency-translation.html

This is all I can offer in supporting information. Experienced users can
undoubtedly offer more.

On Fri, 22 Jan 2021, 12:36 pm w...@theprescotts.com, 
wrote:

> I am probably missing something here.
>
> I have bank accounts in two countries and regularly transfer money between
> them. Whenever I move money, I record the transaction and the amount for
> each side of the transaction. Gnucash automatically makes an entry in the
> Price Database recording the conversion rate.
>
> It seems much cleaner than treating one currency or the other as a
> commodity that is bought or sold at some rate. One thing that is a little
> strange is that the Price Database has separate tables for each direction.
> I suppose it depends on which side of the transaction I use to record the
> transfer. But I almost never look at the Price Database so it doesn't
> bother me much.
>
> Will
>
> On 2021 Jan 21, at 01-21 20:06:04, Lukas Haase  wrote:
>
> Hi Christopher,
>
> This is very sad. Sad for various reasons.
>
> I went over these documents previously (but did not read them thoroughly).
>
> My takeaway is:
> * Storing the conversion rate per transaction makes the accounting
> equation as a function of time inconsistent (but it is consistent for each
> snaphot in time).
> * Trading account accounts for these inaccuracies.
>
> My question was more why the trading accounts (which seem to me the
> cleaner, superior and better way) are not enabled by default.
>
> Also, can you comment a bit more why precicely this would be a major
> minefield? (If you know it, of course).
>
> Multiple databases are just extremely hard for some people (like me).
>
> Consider living for a couple of months to a year in a different place.
> There is just no way to separate this in a clean way without replicating
> all the transactions in different databases. BTDT.
>
> Also I moved multiple times. Even then, there is no clear cut: Initially I
> would use credit cards, ATM etc. from previous country. Even the first or
> second rent may be partially paid with funds from the previous location. It
> takes a few months until I could consider the books between two countries
> sufficiently separate. The only ways are a) Massive transaction Replication
> b) booking everything I pay with funds from old country into old database.
> But with my rent example, it gets very inconsistent how much I paid rent at
> the new place.
>
> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are
> bought in different countries.
>
> I am curious what the potential mines are so I can try to avoid them.
>
> Lukas
>
>
>
> On 2021-01-21 20:20, Christopher Lam wrote:
> > Multicurrency is a major minefield.
> > Start from
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
> > and finish with
> > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
> > background on trading accounts.
> > From discussion with accountant, it would seem that the safest approach
> is
> > to have 1 book per home currency. When you move countries you'd be better
> > off with a new book with a new home currency. Taking temporary trips
> abroad
> > gets the currencies translated to home currency. AFAIU. IANAA YMMV.
> > https://techcrunch.com/2010/08/14/internet-must-be-true/
> > On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
> >> Hi Mike,
> >>
> >> On 2021-01-21 02:24, Mike Alexander wrote:
> >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >>>
>  So I got recommended using trading accounts. But suddenly all my
>  previous multi-currency transactions get a small grey box with a cross
>  (hinting the transaction is inconsistent).
> 
>  How do I best deal with this?
>  Is it possible to keep my old multi currency transactions as-is and
>  use trading accounts only for securities/stocks?
> 
>  If not, how do I migrate while ensuring my ten years worth of data
>  does not suddenly get inconsistent?
> >>>
> >>> You should be able to use the "Check & Repair" commands in the Actions
> >>> menu to add the trading account splits to existing transactions.  I
> >>> would certainly save a copy of my data before doing this, and try it on
> >>> a few transactions first.  Your situation is complex enough that it is
> >>> not unlikely that this won't do exactly what you want, but it's worth a
> >>> try assuming you have good backup.
> >>
> >> Thank you, I think that worked indeed.
> >>
> >> I still need to cross-check everything (at the first glance things look
> >> OK).
> >>
> >> So then I'd have a general question on the multi currency feature:
> >>
> >> 1.) Are "Trading Accounts" just an *alternative* way to handle multi
> >> currencies (and as such have nothing to do with "trading")?
> >>
> >> 2.) Trading Account seem to be way more powerful than storing the
> >> exchange rate in each transaction
> 

Re: [GNC] Switching to trading accounts in existing database

[w...@theprescotts.com]

I am probably missing something here.

I have bank accounts in two countries and regularly transfer money between 
them. Whenever I move money, I record the transaction and the amount for each 
side of the transaction. Gnucash automatically makes an entry in the Price 
Database recording the conversion rate.

It seems much cleaner than treating one currency or the other as a commodity 
that is bought or sold at some rate. One thing that is a little strange is that 
the Price Database has separate tables for each direction. I suppose it depends 
on which side of the transaction I use to record the transfer. But I almost 
never look at the Price Database so it doesn't bother me much.

Will

On 2021 Jan 21, at 01-21 20:06:04, Lukas Haase  wrote:

Hi Christopher,

This is very sad. Sad for various reasons.

I went over these documents previously (but did not read them thoroughly).

My takeaway is:
* Storing the conversion rate per transaction makes the accounting equation as 
a function of time inconsistent (but it is consistent for each snaphot in time).
* Trading account accounts for these inaccuracies.

My question was more why the trading accounts (which seem to me the cleaner, 
superior and better way) are not enabled by default.

Also, can you comment a bit more why precicely this would be a major minefield? 
(If you know it, of course).

Multiple databases are just extremely hard for some people (like me).

Consider living for a couple of months to a year in a different place. There is 
just no way to separate this in a clean way without replicating all the 
transactions in different databases. BTDT.

Also I moved multiple times. Even then, there is no clear cut: Initially I 
would use credit cards, ATM etc. from previous country. Even the first or 
second rent may be partially paid with funds from the previous location. It 
takes a few months until I could consider the books between two countries 
sufficiently separate. The only ways are a) Massive transaction Replication b) 
booking everything I pay with funds from old country into old database. But 
with my rent example, it gets very inconsistent how much I paid rent at the new 
place.

Lastly, simple portfolio accounting (e.g. crypto currencies) if they are bought 
in different countries.

I am curious what the potential mines are so I can try to avoid them.

Lukas



On 2021-01-21 20:20, Christopher Lam wrote:
> Multicurrency is a major minefield.
> Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
> and finish with
> https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
> background on trading accounts.
> From discussion with accountant, it would seem that the safest approach is
> to have 1 book per home currency. When you move countries you'd be better
> off with a new book with a new home currency. Taking temporary trips abroad
> gets the currencies translated to home currency. AFAIU. IANAA YMMV.
> https://techcrunch.com/2010/08/14/internet-must-be-true/
> On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
>> Hi Mike,
>> 
>> On 2021-01-21 02:24, Mike Alexander wrote:
>>> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
>>> 
 So I got recommended using trading accounts. But suddenly all my
 previous multi-currency transactions get a small grey box with a cross
 (hinting the transaction is inconsistent).
 
 How do I best deal with this?
 Is it possible to keep my old multi currency transactions as-is and
 use trading accounts only for securities/stocks?
 
 If not, how do I migrate while ensuring my ten years worth of data
 does not suddenly get inconsistent?
>>> 
>>> You should be able to use the "Check & Repair" commands in the Actions
>>> menu to add the trading account splits to existing transactions.  I
>>> would certainly save a copy of my data before doing this, and try it on
>>> a few transactions first.  Your situation is complex enough that it is
>>> not unlikely that this won't do exactly what you want, but it's worth a
>>> try assuming you have good backup.
>> 
>> Thank you, I think that worked indeed.
>> 
>> I still need to cross-check everything (at the first glance things look
>> OK).
>> 
>> So then I'd have a general question on the multi currency feature:
>> 
>> 1.) Are "Trading Accounts" just an *alternative* way to handle multi
>> currencies (and as such have nothing to do with "trading")?
>> 
>> 2.) Trading Account seem to be way more powerful than storing the
>> exchange rate in each transaction
>> 
>> 3.) Why exactly aren't they enabled by default if they are so superior?
>> Why let people my default use the way that makes things less consistent
>> and error-prone?
>> 
>> Thanks,
>> Lukas
>> 
>> 
>> 
>> 
>> ___
>> 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 

Re: [GNC] Switching to trading accounts in existing database

[Lukas Haase]

Hi Christopher,

This is very sad. Sad for various reasons.

I went over these documents previously (but did not read them thoroughly).

My takeaway is:
* Storing the conversion rate per transaction makes the accounting 
equation as a function of time inconsistent (but it is consistent for 
each snaphot in time).

* Trading account accounts for these inaccuracies.

My question was more why the trading accounts (which seem to me the 
cleaner, superior and better way) are not enabled by default.


Also, can you comment a bit more why precicely this would be a major 
minefield? (If you know it, of course).


Multiple databases are just extremely hard for some people (like me).

Consider living for a couple of months to a year in a different place. 
There is just no way to separate this in a clean way without replicating 
all the transactions in different databases. BTDT.


Also I moved multiple times. Even then, there is no clear cut: Initially 
I would use credit cards, ATM etc. from previous country. Even the first 
or second rent may be partially paid with funds from the previous 
location. It takes a few months until I could consider the books between 
two countries sufficiently separate. The only ways are a) Massive 
transaction Replication b) booking everything I pay with funds from old 
country into old database. But with my rent example, it gets very 
inconsistent how much I paid rent at the new place.


Lastly, simple portfolio accounting (e.g. crypto currencies) if they are 
bought in different countries.


I am curious what the potential mines are so I can try to avoid them.

Lukas



On 2021-01-21 20:20, Christopher Lam wrote:

Multicurrency is a major minefield.
Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
and finish with
https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
background on trading accounts.
 From discussion with accountant, it would seem that the safest approach is
to have 1 book per home currency. When you move countries you'd be better
off with a new book with a new home currency. Taking temporary trips abroad
gets the currencies translated to home currency. AFAIU. IANAA YMMV.
https://techcrunch.com/2010/08/14/internet-must-be-true/

On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:


Hi Mike,

On 2021-01-21 02:24, Mike Alexander wrote:

On 19 Jan 2021, at 20:08, Lukas Haase wrote:


So I got recommended using trading accounts. But suddenly all my
previous multi-currency transactions get a small grey box with a cross
(hinting the transaction is inconsistent).

How do I best deal with this?
Is it possible to keep my old multi currency transactions as-is and
use trading accounts only for securities/stocks?

If not, how do I migrate while ensuring my ten years worth of data
does not suddenly get inconsistent?


You should be able to use the "Check & Repair" commands in the Actions
menu to add the trading account splits to existing transactions.  I
would certainly save a copy of my data before doing this, and try it on
a few transactions first.  Your situation is complex enough that it is
not unlikely that this won't do exactly what you want, but it's worth a
try assuming you have good backup.


Thank you, I think that worked indeed.

I still need to cross-check everything (at the first glance things look
OK).

So then I'd have a general question on the multi currency feature:

1.) Are "Trading Accounts" just an *alternative* way to handle multi
currencies (and as such have nothing to do with "trading")?

2.) Trading Account seem to be way more powerful than storing the
exchange rate in each transaction

3.) Why exactly aren't they enabled by default if they are so superior?
Why let people my default use the way that makes things less consistent
and error-prone?

Thanks,
Lukas




___
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 

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

[Justin via gnucash-user]

Hello all, thank you for replying. I'm new to this email list.

Dave, I do have an M1 Mac. Maybe that's part of the problem.

Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't have an 
uninstall option. I did manually upgrade F::Q though, no change. Gnucash-cli 
still thinks it's installed improperly.

Thanks,
Justin

‐‐‐ Original Message ‐‐‐

On Thursday, January 21st, 2021 at 7:05 PM,  wrote:

> Chris, do you have an M1 or Intel Mac?
> 

> > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com wrote:
> > 

> > Just another point of information, I had the same issue, but it was 
> > resolved after reinstalling F::Q as John mentions below.
> > 

> > > On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user 
> > > gnucash-user@gnucash.org wrote:
> > > 

> > > > On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote:
> > > > 

> > > > > On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user 
> > > > > gnucash-user@gnucash.org wrote:
> > > > > 

> > > > > Hello everyone,
> > > > > 

> > > > > I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS 
> > > > > Big Sur (11.0). Despite not being officially supported, GnuCash 
> > > > > itself works great, with the exception of Finance::Quote. The "get 
> > > > > quotes" button in the Price Database is grayed out and the Security 
> > > > > Editor has the warning "Finance::Quote isn't installed properly." 
> > > > > When running Gnucash-cli, there is a similar error:
> > > > > 

> > > > > > $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
> > > > > > /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
> > > > > > 

> > > > > > Application Path 
> > > > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
> > > > > 

> > > > > > (process:2277): gnc.gui-WARNING **: 22:01:17.540: 
> > > > > > [mac_set_languages()] Language list: en:en_US:C
> > > > > > 

> > > > > > -   22:01:17 INFO  [gnc_module_init_backend_dbi] 3 
> > > > > > DBD drivers found
> > > > > > -   22:01:17 INFO  [gnc_module_init_backend_dbi] 
> > > > > > Driver: pgsql
> > > > > > -   22:01:17 INFO  [gnc_module_init_backend_dbi] 
> > > > > > Driver: sqlite3
> > > > > > -   22:01:17 INFO  [gnc_module_init_backend_dbi] 
> > > > > > Driver: mysql
> > > > > > -   22:01:17 INFO  [Gnucash::CoreApp::start] System locale 
> > > > > > returned (null)
> > > > > > -   22:01:17 INFO  [Gnucash::CoreApp::start] Effective 
> > > > > > locale set to en_US.UTF-8.
> > > > > > -   22:01:17 INFO  
> > > > > > [gnc_gsettings_register_cb] schema: general, key: retain-days, 
> > > > > > settings_ptr: 0x7fde7e839430, handler_id: 1
> > > > > > -   22:01:17 INFO  
> > > > > > [gnc_gsettings_register_cb] schema: general, key: 
> > > > > > retain-type-never, settings_ptr: 0x7fde7e839430, handler_id: 2
> > > > > > -   22:01:17 INFO  
> > > > > > [gnc_gsettings_register_cb] schema: general, key: retain-type-days, 
> > > > > > settings_ptr: 0x7fde7e839430, handler_id: 3
> > > > > > -   22:01:17 INFO  
> > > > > > [gnc_gsettings_register_cb] schema: general, key: 
> > > > > > retain-type-forever, settings_ptr: 0x7fde7e839430, handler_id: 4
> > > > > > -   22:01:17 INFO  
> > > > > > [gnc_gsettings_register_cb] schema: general, key: file-compression, 
> > > > > > settings_ptr: 0x7fde7e839430, handler_id: 5
> > > > > > 

> > > > > > No quotes retrieved. Finance::Quote isn't installed properly.
> > > > > > -   22:01:17 INFO  [gnc_hook_lookup] no hook lists
> > > > > 

> > > > > The error message above isn't particularly useful. It gets printed 
> > > > > here:
> > > > > 

> > > > > https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
> > > > > 

> > > > > I'm pretty sure that Finance::Quote itself is installed properly. I'm 
> > > > > not really sure why GnuCash does not recognize it.
> > > > > 

> > > > > > $ sudo gnc-fq-update
> > > > > > 

> > > > > > Reading '/Users/username/.cpan/Metadata'
> > > > > > 

> > > > > > Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
> > > > > > 

> > > > > > Date::Manip is up to date (6.83).
> > > > > > 

> > > > > > Finance::Quote is up to date (1.49).
> > > > > 

> > > > > A basic query shows that it does work:
> > > > > 

> > > > > > $ echo '(yahoo_json "CSCO")' | 
> > > > > > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
> > > > > > 

> > > > > > (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 
> > > > > > 12:00:00") (last . #e45.19) (currency . "USD")))
> > > > 

> > > > BigSur absolutely is supported. What's not yet available yet is a 
> > > > native build for Apple Silicon, but I've found so far that the Intel 
> > > > build of GnuCash works fine with Rosetta2.
> > > > 

> > > > The BigSur upgrade seems to have messed up perl; I had to reinstall 
> > > > F::Q to get it working after I upgraded, but one could also set 
> > > > $PERL5LIB in the environment to include the old /Library/perl/5.18 

Re: [GNC] Switching to trading accounts in existing database

[Christopher Lam]

Multicurrency is a major minefield.
Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
and finish with
https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
background on trading accounts.
>From discussion with accountant, it would seem that the safest approach is
to have 1 book per home currency. When you move countries you'd be better
off with a new book with a new home currency. Taking temporary trips abroad
gets the currencies translated to home currency. AFAIU. IANAA YMMV.
https://techcrunch.com/2010/08/14/internet-must-be-true/

On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:

> Hi Mike,
>
> On 2021-01-21 02:24, Mike Alexander wrote:
> > On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >
> >> So I got recommended using trading accounts. But suddenly all my
> >> previous multi-currency transactions get a small grey box with a cross
> >> (hinting the transaction is inconsistent).
> >>
> >> How do I best deal with this?
> >> Is it possible to keep my old multi currency transactions as-is and
> >> use trading accounts only for securities/stocks?
> >>
> >> If not, how do I migrate while ensuring my ten years worth of data
> >> does not suddenly get inconsistent?
> >
> > You should be able to use the "Check & Repair" commands in the Actions
> > menu to add the trading account splits to existing transactions.  I
> > would certainly save a copy of my data before doing this, and try it on
> > a few transactions first.  Your situation is complex enough that it is
> > not unlikely that this won't do exactly what you want, but it's worth a
> > try assuming you have good backup.
>
> Thank you, I think that worked indeed.
>
> I still need to cross-check everything (at the first glance things look
> OK).
>
> So then I'd have a general question on the multi currency feature:
>
> 1.) Are "Trading Accounts" just an *alternative* way to handle multi
> currencies (and as such have nothing to do with "trading")?
>
> 2.) Trading Account seem to be way more powerful than storing the
> exchange rate in each transaction
>
> 3.) Why exactly aren't they enabled by default if they are so superior?
> Why let people my default use the way that makes things less consistent
> and error-prone?
>
> Thanks,
> Lukas
>
>
>
>
> ___
> 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 on macOS Big Sur "Finance::Quote isn't installed properly"

[davelist--- via gnucash-user]

Chris, do you have an M1 or Intel Mac?

> On Jan 21, 2021, at 6:02 PM, Chris Graves  wrote:
> 
> Just another point of information, I had the same issue, but it was resolved 
> after reinstalling F::Q as John mentions below.
> 
>> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user 
>>  wrote:
>> 
>> 
>> 
>>> On Jan 21, 2021, at 12:12 PM, John Ralls  wrote:
>>> 
>>> 
>>> 
 On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user 
  wrote:
 
 Hello everyone,
 
 I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big 
 Sur (11.0). Despite not being officially supported, GnuCash itself works 
 great, with the exception of Finance::Quote. The "get quotes" button in 
 the Price Database is grayed out and the Security Editor has the warning 
 "Finance::Quote isn't installed properly." When running Gnucash-cli, there 
 is a similar error:
 
> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
> 
 
> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()] 
> Language list: en:en_US:C
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] 3 DBD 
> drivers found
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
> pgsql
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
> sqlite3
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
> mysql
> * 22:01:17  INFO  [Gnucash::CoreApp::start] System locale 
> returned (null)
> * 22:01:17  INFO  [Gnucash::CoreApp::start] Effective locale set 
> to en_US.UTF-8.
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, 
> handler_id: 1
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430, 
> handler_id: 2
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430, 
> handler_id: 3
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430, 
> handler_id: 4
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430, 
> handler_id: 5
> No quotes retrieved. Finance::Quote isn't installed properly.
> * 22:01:17  INFO  [gnc_hook_lookup] no hook lists
 
 The error message above isn't particularly useful. It gets printed here:
 https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
 
 I'm pretty sure that Finance::Quote itself is installed properly. I'm not 
 really sure why GnuCash does not recognize it.
 
> $ sudo gnc-fq-update
> Reading '/Users/username/.cpan/Metadata'
> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
> Date::Manip is up to date (6.83).
> Finance::Quote is up to date (1.49).
 
 A basic query shows that it does work:
 
> $ echo '(yahoo_json "CSCO")' | 
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") 
> (last . #e45.19) (currency . "USD")))
 
>>> 
>>> BigSur absolutely is supported. What's not yet available yet is a native 
>>> build for Apple Silicon, but I've found so far that the Intel build of 
>>> GnuCash works fine with Rosetta2.
>>> 
>>> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to 
>>> get it working after I upgraded, but one could also set $PERL5LIB in the 
>>> environment to include the old /Library/perl/5.18 as a workaround. If you 
>>> did that in a shell rc file it would make gnc-fq-helper work from terminal 
>>> but not from GnuCash when run from LaunchServices.
>>> 
>>> Does F::Q work when starting GnuCash from the terminal?
>>> 
>>> Regards,
>>> John Ralls
>> 
>> 
>> I can confirm the same issue - quotes work from the command line (after 
>> re-installing finance quote) but in gnucash, the "get quotes" button is 
>> disabled. I am running this on an M1 Mac (so obviously Big Sur). My old Mac 
>> (where quotes work) is running Catalina (and the M1 Mac was set up from a 
>> Time Machine backup of the old Maco) so I don't know if it's a M1 issue or a 
>> Big Sur issue.
>> 
>> Justin, are you using an M1 Mac?
>> 
>> Thanks,
>> 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.
>> -

Re: [GNC] Switching to trading accounts in existing database

[Lukas Haase]

Hi Mike,

On 2021-01-21 02:24, Mike Alexander wrote:

On 19 Jan 2021, at 20:08, Lukas Haase wrote:

So I got recommended using trading accounts. But suddenly all my 
previous multi-currency transactions get a small grey box with a cross 
(hinting the transaction is inconsistent).


How do I best deal with this?
Is it possible to keep my old multi currency transactions as-is and 
use trading accounts only for securities/stocks?


If not, how do I migrate while ensuring my ten years worth of data 
does not suddenly get inconsistent?


You should be able to use the "Check & Repair" commands in the Actions 
menu to add the trading account splits to existing transactions.  I 
would certainly save a copy of my data before doing this, and try it on 
a few transactions first.  Your situation is complex enough that it is 
not unlikely that this won't do exactly what you want, but it's worth a 
try assuming you have good backup.


Thank you, I think that worked indeed.

I still need to cross-check everything (at the first glance things look OK).

So then I'd have a general question on the multi currency feature:

1.) Are "Trading Accounts" just an *alternative* way to handle multi 
currencies (and as such have nothing to do with "trading")?


2.) Trading Account seem to be way more powerful than storing the 
exchange rate in each transaction


3.) Why exactly aren't they enabled by default if they are so superior? 
Why let people my default use the way that makes things less consistent 
and error-prone?


Thanks,
Lukas




___
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 on macOS Big Sur "Finance::Quote isn't installed properly"

[Chris Graves]

Just another point of information, I had the same issue, but it was resolved 
after reinstalling F::Q as John mentions below.

> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user 
>  wrote:
> 
> 
> 
>> On Jan 21, 2021, at 12:12 PM, John Ralls  wrote:
>> 
>> 
>> 
>>> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user 
>>>  wrote:
>>> 
>>> Hello everyone,
>>> 
>>> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big 
>>> Sur (11.0). Despite not being officially supported, GnuCash itself works 
>>> great, with the exception of Finance::Quote. The "get quotes" button in the 
>>> Price Database is grayed out and the Security Editor has the warning 
>>> "Finance::Quote isn't installed properly." When running Gnucash-cli, there 
>>> is a similar error:
>>> 
 $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
 /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
 Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
 
>>> 
 (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()] 
 Language list: en:en_US:C
 * 22:01:17  INFO  [gnc_module_init_backend_dbi] 3 DBD 
 drivers found
 * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
 pgsql
 * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
 sqlite3
 * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
 mysql
 * 22:01:17  INFO  [Gnucash::CoreApp::start] System locale 
 returned (null)
 * 22:01:17  INFO  [Gnucash::CoreApp::start] Effective locale set 
 to en_US.UTF-8.
 * 22:01:17  INFO  [gnc_gsettings_register_cb] 
 schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, 
 handler_id: 1
 * 22:01:17  INFO  [gnc_gsettings_register_cb] 
 schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430, 
 handler_id: 2
 * 22:01:17  INFO  [gnc_gsettings_register_cb] 
 schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430, 
 handler_id: 3
 * 22:01:17  INFO  [gnc_gsettings_register_cb] 
 schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430, 
 handler_id: 4
 * 22:01:17  INFO  [gnc_gsettings_register_cb] 
 schema: general, key: file-compression, settings_ptr: 0x7fde7e839430, 
 handler_id: 5
 No quotes retrieved. Finance::Quote isn't installed properly.
 * 22:01:17  INFO  [gnc_hook_lookup] no hook lists
>>> 
>>> The error message above isn't particularly useful. It gets printed here:
>>> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>>> 
>>> I'm pretty sure that Finance::Quote itself is installed properly. I'm not 
>>> really sure why GnuCash does not recognize it.
>>> 
 $ sudo gnc-fq-update
 Reading '/Users/username/.cpan/Metadata'
 Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
 Date::Manip is up to date (6.83).
 Finance::Quote is up to date (1.49).
>>> 
>>> A basic query shows that it does work:
>>> 
 $ echo '(yahoo_json "CSCO")' | 
 /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
 (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") 
 (last . #e45.19) (currency . "USD")))
>>> 
>> 
>> BigSur absolutely is supported. What's not yet available yet is a native 
>> build for Apple Silicon, but I've found so far that the Intel build of 
>> GnuCash works fine with Rosetta2.
>> 
>> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to 
>> get it working after I upgraded, but one could also set $PERL5LIB in the 
>> environment to include the old /Library/perl/5.18 as a workaround. If you 
>> did that in a shell rc file it would make gnc-fq-helper work from terminal 
>> but not from GnuCash when run from LaunchServices.
>> 
>> Does F::Q work when starting GnuCash from the terminal?
>> 
>> Regards,
>> John Ralls
> 
> 
> I can confirm the same issue - quotes work from the command line (after 
> re-installing finance quote) but in gnucash, the "get quotes" button is 
> disabled. I am running this on an M1 Mac (so obviously Big Sur). My old Mac 
> (where quotes work) is running Catalina (and the M1 Mac was set up from a 
> Time Machine backup of the old Maco) so I don't know if it's a M1 issue or a 
> Big Sur issue.
> 
> Justin, are you using an M1 Mac?
> 
> Thanks,
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To 

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

[davelist--- via gnucash-user]

> On Jan 21, 2021, at 12:12 PM, John Ralls  wrote:
> 
> 
> 
>> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user 
>>  wrote:
>> 
>> Hello everyone,
>> 
>> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big 
>> Sur (11.0). Despite not being officially supported, GnuCash itself works 
>> great, with the exception of Finance::Quote. The "get quotes" button in the 
>> Price Database is grayed out and the Security Editor has the warning 
>> "Finance::Quote isn't installed properly." When running Gnucash-cli, there 
>> is a similar error:
>> 
>>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
>>> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>>> 
>> 
>>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()] 
>>> Language list: en:en_US:C
>>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] 3 DBD 
>>> drivers found
>>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>>> pgsql
>>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>>> sqlite3
>>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>>> mysql
>>> * 22:01:17  INFO  [Gnucash::CoreApp::start] System locale returned 
>>> (null)
>>> * 22:01:17  INFO  [Gnucash::CoreApp::start] Effective locale set 
>>> to en_US.UTF-8.
>>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>>> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, 
>>> handler_id: 1
>>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>>> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430, 
>>> handler_id: 2
>>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>>> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430, 
>>> handler_id: 3
>>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>>> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430, 
>>> handler_id: 4
>>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>>> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430, 
>>> handler_id: 5
>>> No quotes retrieved. Finance::Quote isn't installed properly.
>>> * 22:01:17  INFO  [gnc_hook_lookup] no hook lists
>> 
>> The error message above isn't particularly useful. It gets printed here:
>> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>> 
>> I'm pretty sure that Finance::Quote itself is installed properly. I'm not 
>> really sure why GnuCash does not recognize it.
>> 
>>> $ sudo gnc-fq-update
>>> Reading '/Users/username/.cpan/Metadata'
>>>  Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>>> Date::Manip is up to date (6.83).
>>> Finance::Quote is up to date (1.49).
>> 
>> A basic query shows that it does work:
>> 
>>> $ echo '(yahoo_json "CSCO")' | 
>>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") (last 
>>> . #e45.19) (currency . "USD")))
>> 
> 
> BigSur absolutely is supported. What's not yet available yet is a native 
> build for Apple Silicon, but I've found so far that the Intel build of 
> GnuCash works fine with Rosetta2.
> 
> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to 
> get it working after I upgraded, but one could also set $PERL5LIB in the 
> environment to include the old /Library/perl/5.18 as a workaround. If you did 
> that in a shell rc file it would make gnc-fq-helper work from terminal but 
> not from GnuCash when run from LaunchServices.
> 
> Does F::Q work when starting GnuCash from the terminal?
> 
> Regards,
> John Ralls


I can confirm the same issue - quotes work from the command line (after 
re-installing finance quote) but in gnucash, the "get quotes" button is 
disabled. I am running this on an M1 Mac (so obviously Big Sur). My old Mac 
(where quotes work) is running Catalina (and the M1 Mac was set up from a Time 
Machine backup of the old Maco) so I don't know if it's a M1 issue or a Big Sur 
issue.

Justin, are you using an M1 Mac?

Thanks,
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] Updates on Windows

[Liz Dodd]

On Thu, 21 Jan 2021 09:09:19 -0500
"David T. via gnucash-user"  wrote:

> Derek,
> 
> Thanks for the quick reply. Not being a Linux user (much), I
> immediately wonder whether the Linux removal and reinstallation
> process removes existing menu shortcuts that a user may have
> implemented, such as placing an icon on the OS menu bar. Do you know?
> 
> David

My menu (user-level) with 4 shortcuts to each of my files works
continuously.

LIz
___
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] Updates on Windows

[David Cousens]

David,

On Linux Mint any orphan menu items are not removed automatically from the
users menu but the uninstall process reports orphaned menu items  after an
app is removed and asks you if you want to remove or retain them, at least
when the uninstall is triggered from the menu system.  I can't recall
whether it does that for a manual uninstall of the program or when an
uninstall is triggered from a build directory using "ninja uninstall".

David Cousens



-
David Cousens
--
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.

Re: [GNC] Updates on Windows

[John Ralls]

> On Jan 21, 2021, at 5:53 AM, David T. via gnucash-user 
>  wrote:
> 
> Hello,
> 
> I've used GnuCash for a very long time, under different operating systems 
> (currently GC4.4 on WIndows 10), and I have a minor question about the 
> upgrade process under Windows.
> 
> When I updated under MacOS, I was able to install multiple versions in 
> parallel simply by renaming the app bundle in Applications (for example, from 
> Gnucash.app to Gnucash-3.11.app). It was then possible to run either version, 
> if needed. Under Windows, however, the installation process begins by 
> removing the earlier version from the system.
> 
> Setting aside the wisdom or folly aspect of having or running multiple 
> versions of GnuCash, I am curious why it is that the Windows installer always 
> removes the previous version before installing the next. While this is a 
> minor point, it *does* have an effect in my daily usage. I pin the Gnucash 
> icon to the taskbar, to make it easy to find and run (Aside: one of the 
> things I like least about Windows 10 is its management of the Apps menu). 
> When the new version gets installed, this is not preserved, and I have to 
> re-pin the icon after every update. As I've already noted, this is a minor 
> point, but it's the kind of oddity that sticks in my brain.
> 
> Could someone explain this oddity to me?

As Derek says, macOS is the odd one out because it alone has self-contained 
application bundles. Windows hard-codes paths in all sorts of metadata that 
make it difficult-to-impossible to have more than one installation of any 
particular program. Package managers, including MacPorts and Fink on macOS 
(Homebrew just downloads our dmg), have a fixed directory heirarchy that 
affords only one installation of any particular program. Users with enough 
knowledge of GnuCash's pieces can move things around and set up different 
environments to have more than one version installed, but that's beyond the 
average user.

I suspect what's going on is that the pinned shortcut in the taskbar is a 
pointer or flag of some sort on the Start menu shortcut. The uninstaller 
deletes that and the installer makes a new one that doesn't have the flag set. 
You might try creating a separate shortcut that the installer doesn't know 
about and pinning that to the taskbar.

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] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

[John Ralls]

> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user 
>  wrote:
> 
> Hello everyone,
> 
> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big Sur 
> (11.0). Despite not being officially supported, GnuCash itself works great, 
> with the exception of Finance::Quote. The "get quotes" button in the Price 
> Database is grayed out and the Security Editor has the warning 
> "Finance::Quote isn't installed properly." When running Gnucash-cli, there is 
> a similar error:
> 
>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
>> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>> 
> 
>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()] 
>> Language list: en:en_US:C
>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] 3 DBD 
>> drivers found
>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>> pgsql
>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>> sqlite3
>> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
>> mysql
>> * 22:01:17  INFO  [Gnucash::CoreApp::start] System locale returned 
>> (null)
>> * 22:01:17  INFO  [Gnucash::CoreApp::start] Effective locale set to 
>> en_US.UTF-8.
>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, handler_id: 
>> 1
>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430, 
>> handler_id: 2
>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430, 
>> handler_id: 3
>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430, 
>> handler_id: 4
>> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
>> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430, 
>> handler_id: 5
>> No quotes retrieved. Finance::Quote isn't installed properly.
>> * 22:01:17  INFO  [gnc_hook_lookup] no hook lists
> 
> The error message above isn't particularly useful. It gets printed here:
> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
> 
> I'm pretty sure that Finance::Quote itself is installed properly. I'm not 
> really sure why GnuCash does not recognize it.
> 
>> $ sudo gnc-fq-update
>> Reading '/Users/username/.cpan/Metadata'
>>   Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>> Date::Manip is up to date (6.83).
>> Finance::Quote is up to date (1.49).
> 
> A basic query shows that it does work:
> 
>> $ echo '(yahoo_json "CSCO")' | 
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") (last 
>> . #e45.19) (currency . "USD")))
> 

BigSur absolutely is supported. What's not yet available yet is a native build 
for Apple Silicon, but I've found so far that the Intel build of GnuCash works 
fine with Rosetta2.

The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to get 
it working after I upgraded, but one could also set $PERL5LIB in the 
environment to include the old /Library/perl/5.18 as a workaround. If you did 
that in a shell rc file it would make gnc-fq-helper work from terminal but not 
from GnuCash when run from LaunchServices.

Does F::Q work when starting GnuCash from the terminal?

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] Updates on Windows

[Joseph St. Denis via gnucash-user]

My experience with upgrading Gnu cash in Windows 10 the previous icons are 
removed but are promptly restored to the latest version when the new version is 
finalized.

Joseph St. Denis

Get Outlook for Android


From: gnucash-user  on 
behalf of Derek Atkins 
Sent: Thursday, January 21, 2021 9:15:09 AM
To: David T. 
Cc: Gnucash Users 
Subject: Re: [GNC] Updates on Windows

David,

On Thu, January 21, 2021 9:09 am, David T. wrote:
> Derek,
>
> Thanks for the quick reply. Not being a Linux user (much), I immediately
> wonder whether the Linux removal and reinstallation process removes
> existing menu shortcuts that a user may have implemented, such as
> placing an icon on the OS menu bar. Do you know?

It shouldn't remove those bindings, as the bindings are stored in the
user-data area and not in the program-data area.

> David

-derek

>   On 1/21/2021 8:58 AM, Derek Atkins wrote:
>> David,
>>
>> I will just suggest that it is Mac tht is the oddity here.
>> Linux packages also remove older versions when upgrading.
>>
>> -derek
>>
>> On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:
>>> Hello,
>>>
>>> I've used GnuCash for a very long time, under different operating
>>> systems (currently GC4.4 on WIndows 10), and I have a minor question
>>> about the upgrade process under Windows.
>>>
>>> When I updated under MacOS, I was able to install multiple versions in
>>> parallel simply by renaming the app bundle in Applications (for
>>> example,
>>> from Gnucash.app to Gnucash-3.11.app). It was then possible to run
>>> either version, if needed. Under Windows, however, the installation
>>> process begins by removing the earlier version from the system.
>>>
>>> Setting aside the wisdom or folly aspect of having or running multiple
>>> versions of GnuCash, I am curious why it is that the Windows installer
>>> always removes the previous version before installing the next. While
>>> this is a minor point, it *does* have an effect in my daily usage. I
>>> pin
>>> the Gnucash icon to the taskbar, to make it easy to find and run
>>> (Aside:
>>> one of the things I like least about Windows 10 is its management of
>>> the
>>> Apps menu). When the new version gets installed, this is not preserved,
>>> and I have to re-pin the icon after every update. As I've already
>>> noted,
>>> this is a minor point, but it's the kind of oddity that sticks in my
>>> brain.
>>>
>>> Could someone explain this oddity to me?
>>>
>>> TIA,
>>>
>>> David
>>>
>>> ___
>>> 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.
>>>
>>
>


--
   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.
___
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] Updates on Windows

[Derek Atkins]

David,

On Thu, January 21, 2021 9:09 am, David T. wrote:
> Derek,
>
> Thanks for the quick reply. Not being a Linux user (much), I immediately
> wonder whether the Linux removal and reinstallation process removes
> existing menu shortcuts that a user may have implemented, such as
> placing an icon on the OS menu bar. Do you know?

It shouldn't remove those bindings, as the bindings are stored in the
user-data area and not in the program-data area.

> David

-derek

>   On 1/21/2021 8:58 AM, Derek Atkins wrote:
>> David,
>>
>> I will just suggest that it is Mac tht is the oddity here.
>> Linux packages also remove older versions when upgrading.
>>
>> -derek
>>
>> On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:
>>> Hello,
>>>
>>> I've used GnuCash for a very long time, under different operating
>>> systems (currently GC4.4 on WIndows 10), and I have a minor question
>>> about the upgrade process under Windows.
>>>
>>> When I updated under MacOS, I was able to install multiple versions in
>>> parallel simply by renaming the app bundle in Applications (for
>>> example,
>>> from Gnucash.app to Gnucash-3.11.app). It was then possible to run
>>> either version, if needed. Under Windows, however, the installation
>>> process begins by removing the earlier version from the system.
>>>
>>> Setting aside the wisdom or folly aspect of having or running multiple
>>> versions of GnuCash, I am curious why it is that the Windows installer
>>> always removes the previous version before installing the next. While
>>> this is a minor point, it *does* have an effect in my daily usage. I
>>> pin
>>> the Gnucash icon to the taskbar, to make it easy to find and run
>>> (Aside:
>>> one of the things I like least about Windows 10 is its management of
>>> the
>>> Apps menu). When the new version gets installed, this is not preserved,
>>> and I have to re-pin the icon after every update. As I've already
>>> noted,
>>> this is a minor point, but it's the kind of oddity that sticks in my
>>> brain.
>>>
>>> Could someone explain this oddity to me?
>>>
>>> TIA,
>>>
>>> David
>>>
>>> ___
>>> 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.
>>>
>>
>


-- 
   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] Updates on Windows

[David T. via gnucash-user]

Derek,

Thanks for the quick reply. Not being a Linux user (much), I immediately 
wonder whether the Linux removal and reinstallation process removes 
existing menu shortcuts that a user may have implemented, such as 
placing an icon on the OS menu bar. Do you know?


David

 On 1/21/2021 8:58 AM, Derek Atkins wrote:

David,

I will just suggest that it is Mac tht is the oddity here.
Linux packages also remove older versions when upgrading.

-derek

On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:

Hello,

I've used GnuCash for a very long time, under different operating
systems (currently GC4.4 on WIndows 10), and I have a minor question
about the upgrade process under Windows.

When I updated under MacOS, I was able to install multiple versions in
parallel simply by renaming the app bundle in Applications (for example,
from Gnucash.app to Gnucash-3.11.app). It was then possible to run
either version, if needed. Under Windows, however, the installation
process begins by removing the earlier version from the system.

Setting aside the wisdom or folly aspect of having or running multiple
versions of GnuCash, I am curious why it is that the Windows installer
always removes the previous version before installing the next. While
this is a minor point, it *does* have an effect in my daily usage. I pin
the Gnucash icon to the taskbar, to make it easy to find and run (Aside:
one of the things I like least about Windows 10 is its management of the
Apps menu). When the new version gets installed, this is not preserved,
and I have to re-pin the icon after every update. As I've already noted,
this is a minor point, but it's the kind of oddity that sticks in my
brain.

Could someone explain this oddity to me?

TIA,

David

___
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] Updates on Windows

[Derek Atkins]

David,

I will just suggest that it is Mac tht is the oddity here.
Linux packages also remove older versions when upgrading.

-derek

On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:
> Hello,
>
> I've used GnuCash for a very long time, under different operating
> systems (currently GC4.4 on WIndows 10), and I have a minor question
> about the upgrade process under Windows.
>
> When I updated under MacOS, I was able to install multiple versions in
> parallel simply by renaming the app bundle in Applications (for example,
> from Gnucash.app to Gnucash-3.11.app). It was then possible to run
> either version, if needed. Under Windows, however, the installation
> process begins by removing the earlier version from the system.
>
> Setting aside the wisdom or folly aspect of having or running multiple
> versions of GnuCash, I am curious why it is that the Windows installer
> always removes the previous version before installing the next. While
> this is a minor point, it *does* have an effect in my daily usage. I pin
> the Gnucash icon to the taskbar, to make it easy to find and run (Aside:
> one of the things I like least about Windows 10 is its management of the
> Apps menu). When the new version gets installed, this is not preserved,
> and I have to re-pin the icon after every update. As I've already noted,
> this is a minor point, but it's the kind of oddity that sticks in my
> brain.
>
> Could someone explain this oddity to me?
>
> TIA,
>
> David
>
> ___
> 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.
>


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

[GNC] Updates on Windows

[David T. via gnucash-user]

Hello,

I've used GnuCash for a very long time, under different operating 
systems (currently GC4.4 on WIndows 10), and I have a minor question 
about the upgrade process under Windows.


When I updated under MacOS, I was able to install multiple versions in 
parallel simply by renaming the app bundle in Applications (for example, 
from Gnucash.app to Gnucash-3.11.app). It was then possible to run 
either version, if needed. Under Windows, however, the installation 
process begins by removing the earlier version from the system.


Setting aside the wisdom or folly aspect of having or running multiple 
versions of GnuCash, I am curious why it is that the Windows installer 
always removes the previous version before installing the next. While 
this is a minor point, it *does* have an effect in my daily usage. I pin 
the Gnucash icon to the taskbar, to make it easy to find and run (Aside: 
one of the things I like least about Windows 10 is its management of the 
Apps menu). When the new version gets installed, this is not preserved, 
and I have to re-pin the icon after every update. As I've already noted, 
this is a minor point, but it's the kind of oddity that sticks in my brain.


Could someone explain this oddity to me?

TIA,

David

___
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] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

[Justin via gnucash-user]

Hello everyone,

I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big Sur 
(11.0). Despite not being officially supported, GnuCash itself works great, 
with the exception of Finance::Quote. The "get quotes" button in the Price 
Database is grayed out and the Security Editor has the warning "Finance::Quote 
isn't installed properly." When running Gnucash-cli, there is a similar error:

> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get 
> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
> 

> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()] 
> Language list: en:en_US:C
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] 3 DBD 
> drivers found
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: pgsql
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: 
> sqlite3
> * 22:01:17  INFO  [gnc_module_init_backend_dbi] Driver: mysql
> * 22:01:17  INFO  [Gnucash::CoreApp::start] System locale returned 
> (null)
> * 22:01:17  INFO  [Gnucash::CoreApp::start] Effective locale set to 
> en_US.UTF-8.
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, handler_id: 1
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430, 
> handler_id: 2
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430, 
> handler_id: 3
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430, 
> handler_id: 4
> * 22:01:17  INFO  [gnc_gsettings_register_cb] 
> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430, 
> handler_id: 5
> No quotes retrieved. Finance::Quote isn't installed properly.
> * 22:01:17  INFO  [gnc_hook_lookup] no hook lists

The error message above isn't particularly useful. It gets printed here:
https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91

I'm pretty sure that Finance::Quote itself is installed properly. I'm not 
really sure why GnuCash does not recognize it.

> $ sudo gnc-fq-update
> Reading '/Users/username/.cpan/Metadata'
>   Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
> Date::Manip is up to date (6.83).
> Finance::Quote is up to date (1.49).

A basic query shows that it does work:

> $ echo '(yahoo_json "CSCO")' | 
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") (last . 
> #e45.19) (currency . "USD")))

Thanks,
JT

publickey - jtraglia@pm.me - 0x04DB65EA.asc
Description: application/pgp-keys


signature.asc
Description: OpenPGP digital signature
___
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] Where does gnucash put the lock file on Linux?

[Chris Green]

On Wed, Jan 20, 2021 at 05:20:16PM -0800, John Ralls wrote:
> Do I remember correctly that you're using the SQL backend? That works a 
> bit differently because there's no way to have a lock file if you're 
> connected 
> to a DB server. Instead of a lock file it has a lock table inside the 
> database. 
> If you copy the database (and with SQLite3 it looks just like a file) when 
> there's a lock record in the lock table then GnuCash will put up the "unable 
> to obtain the lock" dialog box. 
> 
You're absolutely right, I'm using sqlite, the above would exactly
explain what I'm seeing, thank you.

With sqlite it would, of course, be OK to use a lock file as it's not
a client/server system but I suppose it just shares the way things
work with mySql/postgresql.


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