Re: [GNC] Problem retrieving exchange rates

[John Ralls]

> On Oct 20, 2018, at 1:39 PM, harold  wrote:
> 
> Hi,
> I'm a new gnucash user running on macOS Mojave. I've installed gnucash and
> run the finance quotes updater app.
> 
> When I try to "Get Quotes", gnucash returns an error message saying
> 
>> There was a system error when retrieving the price quotes
> 
> 
> When running the finance quotes updater app it completes, but there seem to
> be some error messages, which I don't know what to do about. Here are the
> last few lines of the file:
> 
> ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at
> Makefile.PL line 8.
> 
> BEGIN failed--compilation aborted at Makefile.PL line 8.
> 
> Warning: No success on command[/usr/bin/perl Makefile.PL]
> 
>  SBECK/Date-Manip-6.72.tar.gz
> 
>  /usr/bin/perl Makefile.PL -- NOT OK
> 
> Running make test
> 
>  Make had some problems, won't test
> 
> Running make install
> 
>  Make had some problems, won't install
> 
> Could not read metadata file. Falling back to other methods to determine
> prerequisites
> Finance::Quote is up to date (1.47).
> 
> Does anyone have any ideas on how to fix this?

I just ran gnc-fq-update (which is what Finance::Quote Update does, wrapped in 
an AppleScript) on 10.14.1 Developer Beta 18867a without any issues. It updated 
Date-Manip-6.72 cleanly. Digging in a bit more I find that I have an updated 
MakeMaker.pm as well as the 6.66 apparently distributed by Apple. You can 
probably fix that with 
  sudo cpan install ExtUtils::MakeMaker
in Terminal.

That said, as long as you have some version of Date::Manip you should be OK on 
that front, and you do have the latest Finance::Quote. The problem you’re 
having is likely with the stocks you’re trying to get quotes for.

Try running GnuCash from Terminal:
  /Applications/Gnucash.app/Contents/MacOS/Gnucash --log gnc.scm=debug
That should print each symbol as it requests it along with the result of the 
request. It might provide some more info about the errors.

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] Problem retrieving exchange rates

[harold]

Hi,
I'm a new gnucash user running on macOS Mojave. I've installed gnucash and
run the finance quotes updater app.

When I try to "Get Quotes", gnucash returns an error message saying

> There was a system error when retrieving the price quotes


When running the finance quotes updater app it completes, but there seem to
be some error messages, which I don't know what to do about. Here are the
last few lines of the file:

ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at
Makefile.PL line 8.

BEGIN failed--compilation aborted at Makefile.PL line 8.

Warning: No success on command[/usr/bin/perl Makefile.PL]

  SBECK/Date-Manip-6.72.tar.gz

  /usr/bin/perl Makefile.PL -- NOT OK

Running make test

  Make had some problems, won't test

Running make install

  Make had some problems, won't install

Could not read metadata file. Falling back to other methods to determine
prerequisites
Finance::Quote is up to date (1.47).

Does anyone have any ideas on how to fix this?

Thanks
Harold
___
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] OFX Importer Matching: too many false positives in matching with repeated transactions

[Liz]

On Sat, 20 Oct 2018 15:25:03 +0200
Milan Knížek  wrote:

> Unfortunatelly, the importer tries to match as much as possible,
> which results in considering many repeated transactions (utility
> pmts, rent, etc.) as already existing in the ledger and proposes to
> "reconcile" or "update and reconcile".
> 
> However, there is no such transaction in the current month - it
> probably tries to match with a similar item from prior periods.

Thinking sideways
If you have recurrent transactions, eg rent, putting them in the
scheduled transaction system would ensure that you have the
transactions for each month (week, etc) in the ledger.

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.

[GNC] Mnemonics Tip for GnuCash 3 users

[Chris Good]

GnuCash 3 uses GTK3. GTK Mnemonics are underlined characters in a label,
used for keyboard navigation. Examples of labels which may include a
mnemonic are the text on a button, the label of a field, and the text in a
menu line. The mnemonic is activated by pressing the mnenomic activator key
(Alt for Linux and Windows, Command (I think) for MacOS) at the same time as
the underlined character.

 

Since GTK 3.10 the underlines of the mnenomics are only visible after
pressing the mnenomic activator key.

 

The way this works doesn't seem to be well documented, but give it a go and
you'll soon see the keyboard shortcuts that were always visible in GnuCash
versions before 3.

 

Regards, Chris Good

 

___
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] OFX Importer Matching: too many false positives in matching with repeated transactions

[David Cousens]

Milan,

The reconcile and import matcher windows use different code even though
there are some similarities in identifying matching transactions.

Which version of the matching are you using in the importer (see
Edit->Preferences-Online Banking and the bayesian matching checkbox)?

The importer matches on the basis of "tokens" for the data in the
transaction fields. Repeated transactions with the same amount from the same
source tend to get matched even though the dates are "wrong". As dates
between manually entered data and data imported from a bank may very
considerably, the developers seem to have erred on the side of making it
likely to pick up any possible matching transaction to avoid duplicating
transactions. I don't think the current methodology has any way of knowing
about the period of repeated transactions. It may be possible as a future
development if for example some specific transaction sources could be
flagged as periodic and  tokens developed to flag this and the expected
periodicity.

If you think this is needed raise a feature request at bugs.gnucash.org.

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] MySQL on GCP

[David Cousens]

On Sat, 2018-10-20 at 14:39 -0400, Charles Gagnon wrote:
> 
> My question is around online transactions. After importing, I would
> typically spend some time in the window assigning the right accounts to the
> transactions. This process is now terribly slow with the cloud DB so I'm
> assuming it was written with lot of backend interactions. The workaround is
> fairly simple, I import the transactions as-is (with or without an account)
> and I re-visit in the register window to assign an account.

Charles,

It is hard to understand why the process of importing transactions with 
unassigned destination accounts and editing them
in the register window is actually more efficient than assigning the accounts 
in the import matcher. The register
possibly writes the data directly to the db as each account is assigned while 
the import matcher only appears to up date
the Bayesian matcher data as each account is assigned and only updates the 
actual transaction data in the db when the OK
button is pressed in the matcher window as far as I can seen in the code on a 
quick look. It may be possible that the
process of writing out the matcher data is less efficient than that of writing 
the transaction data perhaps. My
understanding of the GnuCash code is still fairly limited even though I have 
looked through hat area recently.

Is it the apparent delay in having to assign the transfer accounts singly to 
all transactions in the matcher window
which makes this process appear to be slower for you?

There is one improvment coming up in V4 which will enable multiple selection in 
the matcher window for assignment of a
single transfer account to all selected  transactions, which should at least 
speed up the initial assignment of transfer
accounts, but once the Bayesian matcher gets educated, I am finding that the 
matcher automatically assigns the correct
transfer account in many cases.

Somewhere in the changeover from 2.6.19 to v3.0, I appeared to have lost my 
previous matcher data. It may heve been that
I changed the preference on Bayesian matching in the Online Banking preferences 
during that process as well.

David Cousens


> I figured I'd share and start a conversation. I also wanted to bring up the
> online transactions situation even though it's easy to work around.
> 
> Regards,
> 
> PS: With a GCP based Linux desktop and the right packages to run gnucash
> with a mysql backend, I could end-up with a completely portable solution
> with the current codebase.
> ___
> 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] Preferences for latest version

[John Ralls]

No, we moved to Gtk3 because WebKitGtk no longer supports Gtk2 and we were 
getting dropped from major distros for using an old version of WebKitGtk. 

Regards,
John Ralls


> On Oct 20, 2018, at 1:27 PM, Adrien Monteleone 
>  wrote:
> 
> Yes, but as I noted, the Accounts page is not designed in a way that you can 
> target the individual lines using those (even/odd) pseudo selectors. It is 
> also unknown if Gnome even implemented pseudo selectors at all for Gtk3. (I 
> think I’ve tried some on other elements and they did not work)
> 
> The layout choices aren’t really from the GnuCash devs. They moved to Gtk3 
> because Gtk2 is no longer being developed. (Gtk4 is already in the works by 
> Gnome) Many of the differences people see are a result of the defaults for 
> the UI toolkit changing, not necessarily individual intentional changes by 
> the GnuCash devs.
> 
> Regards,
> Adrien
> 
>> On Oct 20, 2018, at 2:00 PM, Stan Brown  wrote:
>> 
>>> Date: Sat, 20 Oct 2018 08:46:29 +0100
>>> From: Jill Terry 
>> 
>>> Could you tell me how to have even and odd rule for the account
>>> page???
>> 
>> I'm still at version 2 of GC, but what I'm hearing about the, er, "odd"
>> formatting choices for 3.3 isn't encouraging me to upgrade.
>> 
>> Adrien already posted where to find the CSS.
>> 
>> For your specific question, I googled
>>  "even and odd rule" css
>> The first hit was from w3.org, always a good choice for CSS and HTML
>> matters:
>> https://www.w3.org/Style/Examples/007/evenodd.en.html
>> 
>> --
>> Regards,
>> Stan Brown, Tompkins County, NY, USA
>> http://Brownmath.com
>> http://oakroadsystems.com
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Preferences for latest version

[Adrien Monteleone]

Yes, but as I noted, the Accounts page is not designed in a way that you can 
target the individual lines using those (even/odd) pseudo selectors. It is also 
unknown if Gnome even implemented pseudo selectors at all for Gtk3. (I think 
I’ve tried some on other elements and they did not work)

The layout choices aren’t really from the GnuCash devs. They moved to Gtk3 
because Gtk2 is no longer being developed. (Gtk4 is already in the works by 
Gnome) Many of the differences people see are a result of the defaults for the 
UI toolkit changing, not necessarily individual intentional changes by the 
GnuCash devs.

Regards,
Adrien

> On Oct 20, 2018, at 2:00 PM, Stan Brown  wrote:
> 
>> Date: Sat, 20 Oct 2018 08:46:29 +0100
>> From: Jill Terry 
> 
>> Could you tell me how to have even and odd rule for the account
>> page???
> 
> I'm still at version 2 of GC, but what I'm hearing about the, er, "odd"
> formatting choices for 3.3 isn't encouraging me to upgrade.
> 
> Adrien already posted where to find the CSS.
> 
> For your specific question, I googled
>   "even and odd rule" css
> The first hit was from w3.org, always a good choice for CSS and HTML
> matters:
> https://www.w3.org/Style/Examples/007/evenodd.en.html
> 
> --
> Regards,
> Stan Brown, Tompkins County, NY, USA
> http://Brownmath.com
> http://oakroadsystems.com
> ___
> 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] Capital losses in Advanced Portfolio Report

[Richard Ullger]

On 20/10/2018 17:19, José Antonio Fernández Troncoso wrote:
> Hello,
> 
> In my advanced porfolio report, capital losses linked to a stock account are 
> added to the Income column as if they were dividends. 
> 
> Could anyone using this report provide some feedback as to whether this also 
> happens to them? Is there a bug in the report or am I doing something wrong?
> 
> I'm using GnuCash Version: 3.2. Build ID: 3.2+ (2018-06-24).

I've been using this report for some time and have never seen this
behaviour. I'm currently using Build ID: git 3.3+ (2018-09-29)

The income column reflects the income that I have recorded against the
stock.

A capital loss is shown as a negative amount in the Realised Gain
column. However there appears to be a bug in the amount of Realised
Gain. The report seems to try to calculate the gain/loss rather than
report on any gain/loss recorded against the stock.

A loss in the valuation is shown as a negative amount in the Unrealised
Gain column.

Regards,

Richard.

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

Re: [GNC] Time zone workaround?

[John Ralls]

A better idea would be to start GnuCash with `TZ=EST5EDT gnucash`.

I think the simplest way to address the different timezone problem is to change 
the XML backend to always store the time in UTC like the SQL backend does. A 
time with a TZ mark is really UTC anyway, and internally all timestamps are 
UTC, so why spend the extra effort to convert and parse timezones?

And nobody here is paid so there's no way to um, "influence our priorities" 
with money.

Regards,
John Ralls


> On Oct 20, 2018, at 11:40 AM, Clayton Dewey  wrote:
> 
> Thanks, that's a good idea. I'll take that approach in the meantime.
> Long term, is this issue scheduled to be fixed in a future release?
> Would some level of financial support help make that happen? I imagine
> this is an issue for other geographically distributed companies.
> 
> Thanks,
> Clayton
> 
> On 10/20/18 12:08 PM, Adrien Monteleone wrote:
>> Possibly create a separate user account on the computer just for using 
>> GnuCash and set it to EST — not convenient, but certainly avoiding 
>> confusion. Consider setting a different screen background so you know at a 
>> glance which user you are working with.
>> 
>> Regards,
>> Adrien
>> 
>>> On Oct 20, 2018, at 12:59 PM, Clayton Dewey  wrote:
>>> 
>>> Hi All,
>>> 
>>> I recently joined a company that uses GnuCash and have been enjoying
>>> learning the application.
>>> 
>>> We are a distributed company and do all business in EST, while I reside
>>> in MST. I know there is a bug in GnuCash where if I save a file in my
>>> timezone it overrides the transaction date and time to MST.
>>> 
>>> To avoid this, it seems that I would need to somehow tell GnuCash to
>>> ignore my computer's timezone and keep it in Eastern Standard Time. Is
>>> this currently possible? Are there any workarounds I can employ other
>>> than changing my computer's time zone to EST (I tried that and it just
>>> confused me :))?
>>> 
>>> Thanks in advance,
>>> Clayton
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] Preferences for latest version

[Stan Brown]

> Date: Sat, 20 Oct 2018 08:46:29 +0100
> From: Jill Terry 

> Could you tell me how to have even and odd rule for the account
> page???

I'm still at version 2 of GC, but what I'm hearing about the, er, "odd"
formatting choices for 3.3 isn't encouraging me to upgrade.

Adrien already posted where to find the CSS.

For your specific question, I googled
"even and odd rule" css
The first hit was from w3.org, always a good choice for CSS and HTML
matters:
https://www.w3.org/Style/Examples/007/evenodd.en.html

--
Regards,
Stan Brown, Tompkins County, NY, USA
http://Brownmath.com
http://oakroadsystems.com
___
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] Time zone workaround?

[Adrien Monteleone]

A developer would have to chime in on those questions.

Regards,
Adrien

> On Oct 20, 2018, at 1:40 PM, Clayton Dewey  wrote:
> 
> Thanks, that's a good idea. I'll take that approach in the meantime.
> Long term, is this issue scheduled to be fixed in a future release?
> Would some level of financial support help make that happen? I imagine
> this is an issue for other geographically distributed companies.
> 
> Thanks,
> Clayton
> 
> On 10/20/18 12:08 PM, Adrien Monteleone wrote:
>> Possibly create a separate user account on the computer just for using 
>> GnuCash and set it to EST — not convenient, but certainly avoiding 
>> confusion. Consider setting a different screen background so you know at a 
>> glance which user you are working with.
>> 
>> Regards,
>> Adrien
>> 
>>> On Oct 20, 2018, at 12:59 PM, Clayton Dewey  wrote:
>>> 
>>> Hi All,
>>> 
>>> I recently joined a company that uses GnuCash and have been enjoying
>>> learning the application.
>>> 
>>> We are a distributed company and do all business in EST, while I reside
>>> in MST. I know there is a bug in GnuCash where if I save a file in my
>>> timezone it overrides the transaction date and time to MST.
>>> 
>>> To avoid this, it seems that I would need to somehow tell GnuCash to
>>> ignore my computer's timezone and keep it in Eastern Standard Time. Is
>>> this currently possible? Are there any workarounds I can employ other
>>> than changing my computer's time zone to EST (I tried that and it just
>>> confused me :))?
>>> 
>>> Thanks in advance,
>>> Clayton
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
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] Time zone workaround?

[Clayton Dewey]

Thanks, that's a good idea. I'll take that approach in the meantime.
Long term, is this issue scheduled to be fixed in a future release?
Would some level of financial support help make that happen? I imagine
this is an issue for other geographically distributed companies.

Thanks,
Clayton

On 10/20/18 12:08 PM, Adrien Monteleone wrote:
> Possibly create a separate user account on the computer just for using 
> GnuCash and set it to EST — not convenient, but certainly avoiding confusion. 
> Consider setting a different screen background so you know at a glance which 
> user you are working with.
> 
> Regards,
> Adrien
> 
>> On Oct 20, 2018, at 12:59 PM, Clayton Dewey  wrote:
>>
>> Hi All,
>>
>> I recently joined a company that uses GnuCash and have been enjoying
>> learning the application.
>>
>> We are a distributed company and do all business in EST, while I reside
>> in MST. I know there is a bug in GnuCash where if I save a file in my
>> timezone it overrides the transaction date and time to MST.
>>
>> To avoid this, it seems that I would need to somehow tell GnuCash to
>> ignore my computer's timezone and keep it in Eastern Standard Time. Is
>> this currently possible? Are there any workarounds I can employ other
>> than changing my computer's time zone to EST (I tried that and it just
>> confused me :))?
>>
>> Thanks in advance,
>> Clayton
>>
>> ___
>> 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.
> 



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.

[GNC] MySQL on GCP

[Charles Gagnon]

I wanted to share something quickly and ask a question at the same time.

I've been using gnucash since ~ 2001-2002 for my personal finances. I was
"closing" and starting fresh every year until 2006 at which point I just
started accumulated into the same file. So I currently have data in a
single file dating back to 2006.

I switched to MySQL backend years ago. I recently decided it would be nice
to get rid of some of my home lab machines so I made an experiment with
Google Cloud.

I had never read of anyone trying it but I restored my MySQL DB in a GCP
instance and have been using it as my main DB for several months. It opens
slower than my local database but it seems gnucash loads up the bulk of
what it needs in memory. So for normal day-to-day operations, you really
cannot tell the difference between the local instance and the cloud
instance.

My question is around online transactions. After importing, I would
typically spend some time in the window assigning the right accounts to the
transactions. This process is now terribly slow with the cloud DB so I'm
assuming it was written with lot of backend interactions. The workaround is
fairly simple, I import the transactions as-is (with or without an account)
and I re-visit in the register window to assign an account.

I figured I'd share and start a conversation. I also wanted to bring up the
online transactions situation even though it's easy to work around.

Regards,

PS: With a GCP based Linux desktop and the right packages to run gnucash
with a mysql backend, I could end-up with a completely portable solution
with the current codebase.
___
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] Time zone workaround?

[Adrien Monteleone]

Possibly create a separate user account on the computer just for using GnuCash 
and set it to EST — not convenient, but certainly avoiding confusion. Consider 
setting a different screen background so you know at a glance which user you 
are working with.

Regards,
Adrien

> On Oct 20, 2018, at 12:59 PM, Clayton Dewey  wrote:
> 
> Hi All,
> 
> I recently joined a company that uses GnuCash and have been enjoying
> learning the application.
> 
> We are a distributed company and do all business in EST, while I reside
> in MST. I know there is a bug in GnuCash where if I save a file in my
> timezone it overrides the transaction date and time to MST.
> 
> To avoid this, it seems that I would need to somehow tell GnuCash to
> ignore my computer's timezone and keep it in Eastern Standard Time. Is
> this currently possible? Are there any workarounds I can employ other
> than changing my computer's time zone to EST (I tried that and it just
> confused me :))?
> 
> Thanks in advance,
> Clayton
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

[GNC] Time zone workaround?

[Clayton Dewey]

Hi All,

I recently joined a company that uses GnuCash and have been enjoying
learning the application.

We are a distributed company and do all business in EST, while I reside
in MST. I know there is a bug in GnuCash where if I save a file in my
timezone it overrides the transaction date and time to MST.

To avoid this, it seems that I would need to somehow tell GnuCash to
ignore my computer's timezone and keep it in Eastern Standard Time. Is
this currently possible? Are there any workarounds I can employ other
than changing my computer's time zone to EST (I tried that and it just
confused me :))?

Thanks in advance,
Clayton



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] Preferences for latest version

[Jill Terry]

Thank you so much for your help Adrien.  Very much appreciated!

It does seem rather strange to step backward in display when upgrading a 
program!  I would stick to the older version (with it's zebra striping 
on the account tree LOL!) but for some strange reason the search 
function just suddenly stopped working! Progress isn't always a good 
thing :(


Thanks again

Jill


On 20/10/2018 18:32, Adrien Monteleone wrote:

Jill,

Unfortunately, this does not appear to be possible at the present time. You can 
only target the entire background, not individual lines for zebra striping.

I did find a possibility of having grid lines, but this will need to be done 
via code by the developers.

I’d suggest filing a bug report as an RFE (Request for Enhancement). The 
gridlines should be easy enough for them to implement (as an option, similar to 
how they implement it for the registers) but the zebra striping might be more 
difficult.

You do have another option in the meantime:

Set account colors for some/all/blocks of accounts.

If you select an account in the tree and click the ‘Edit’ icon, you’ll see in 
the top section of your options, the ability to set an account color. Click the 
color bar on the left to bring up a standard gtk color palette to choose from, 
or use the custom option to specify your own.

Then in Preferences > Accounts, use the Account Color options to either show as 
background, on tabs, or both as desired. (note, while the tab option updates as 
you select or unselect it with the preferences window open, the background option 
seems buggy and the change is only visible once you exit the preferences window.)

This way, you can either color individual accounts, or maybe at least color all 
assets the same, all expenses the same et cetera for a visual break-up of the 
page.

Regards,
Adrien


On Oct 20, 2018, at 2:46 AM, Jill Terry  wrote:

Hi Adrien

First of all sorry for delay in replying and thank you very much for this.

Could you tell me how to have even and odd rule for the account page?   Prior 
to upgrading, it used to display white but with every other line in grey, which 
is much easier to read.

Cheers
Jill

On 19/10/2018 19:48, Adrien Monteleone wrote:

Jill,

Try this:

Close GnuCash.

Using a text editor (such as ’TextEdit.app’) create a file named gtk-3.0.css 
and place it in /yourusername/Library/Application Support/Gnucash

have it contain the following three CSS declarations:

* {
   font-size: 12px;
   font-family: Helvetica, sans-serif;
}

#account_tree, .GncAccountPage {
   background-color: lightgrey;
}

treeview button {
   background-color: lightgrey;
   color: black;
}

Save the file as ‘Plain Text’. (Format > Make Plain Text)

Start GnuCash to see your changes.

--
Here’s what this code does:

* {
  font-size: 12px;
  font-family: Helvetica, sans-serif;
}


“font-size: 12px;” sets the font size for all (*) elements in the windows for 
the entire application. Set to the size you find appropriate. 12px (pixels) is 
a readably small size on most displays.

“font-family: Helvetica, sans-serif;” sets the font family to be ‘Helvetica’ or 
the closest generic system sans-serif font available if Helvetica is not on 
your system. You can use any font here you like. I just included Helvetica as 
an example. The default (‘San Francisco’ on a Mac) is pretty good, so you don’t 
need to even include this line if you like it as is, just use the font-size 
rule.

--

#account_tree, .GncAccountPage {
  background-color: lightgrey;
}


“#account_tree” targets the main part of the Account page window, 
“.GncAccountPage” targets the small background behind the Totals bar which 
appears to be part of the page. You can put them together as I have done here 
in a list to apply the same rule to both, or write separate declarations for 
each with their own rules if you want the colors to be different.

You can also set specified font-sizes and font-families here as well if you 
want them different than the rest of the window. Just add those rules into 
those declarations. I’ve included a background color rule here because that is 
what you asked for, with the ‘lightgrey’ example. Depending on what you are 
looking for, or what color you choose, you may need to also set a foreground 
(text) color to balance properly. See the next declaration for an example.

--

treeview button {
  background-color: lightgrey;
  color: black;
}


“treeview button” targets the header bar at the top of the Account table. 
Again, you might need to include a foreground color rule here as this 
particular background color makes the header labels harder to read. (simply 
“color”)

For colors you can specify a ‘named websafe color’ (do a search on that term 
for possible color names) or you can use RGB integer or hex values if you want 
to specify a non-named color. (you don’t have to use names 

Re: [GNC] Preferences for latest version

[Adrien Monteleone]

Jill,

Unfortunately, this does not appear to be possible at the present time. You can 
only target the entire background, not individual lines for zebra striping.

I did find a possibility of having grid lines, but this will need to be done 
via code by the developers.

I’d suggest filing a bug report as an RFE (Request for Enhancement). The 
gridlines should be easy enough for them to implement (as an option, similar to 
how they implement it for the registers) but the zebra striping might be more 
difficult.

You do have another option in the meantime:

Set account colors for some/all/blocks of accounts.

If you select an account in the tree and click the ‘Edit’ icon, you’ll see in 
the top section of your options, the ability to set an account color. Click the 
color bar on the left to bring up a standard gtk color palette to choose from, 
or use the custom option to specify your own.

Then in Preferences > Accounts, use the Account Color options to either show as 
background, on tabs, or both as desired. (note, while the tab option updates as 
you select or unselect it with the preferences window open, the background 
option seems buggy and the change is only visible once you exit the preferences 
window.)

This way, you can either color individual accounts, or maybe at least color all 
assets the same, all expenses the same et cetera for a visual break-up of the 
page.

Regards,
Adrien

> On Oct 20, 2018, at 2:46 AM, Jill Terry  wrote:
> 
> Hi Adrien
> 
> First of all sorry for delay in replying and thank you very much for this.
> 
> Could you tell me how to have even and odd rule for the account page?   Prior 
> to upgrading, it used to display white but with every other line in grey, 
> which is much easier to read.
> 
> Cheers
> Jill
> 
> On 19/10/2018 19:48, Adrien Monteleone wrote:
>> Jill,
>> 
>> Try this:
>> 
>> Close GnuCash.
>> 
>> Using a text editor (such as ’TextEdit.app’) create a file named gtk-3.0.css 
>> and place it in /yourusername/Library/Application Support/Gnucash
>> 
>> have it contain the following three CSS declarations:
>> 
>> * {
>>   font-size: 12px;
>>   font-family: Helvetica, sans-serif;
>> }
>> 
>> #account_tree, .GncAccountPage {
>>   background-color: lightgrey;
>> }
>> 
>> treeview button {
>>   background-color: lightgrey;
>>   color: black;
>> }
>> 
>> Save the file as ‘Plain Text’. (Format > Make Plain Text)
>> 
>> Start GnuCash to see your changes.
>> 
>> --
>> Here’s what this code does:
>> 
>>  * {
>>font-size: 12px;
>>font-family: Helvetica, sans-serif;
>>  }
>> 
>> 
>> “font-size: 12px;” sets the font size for all (*) elements in the windows 
>> for the entire application. Set to the size you find appropriate. 12px 
>> (pixels) is a readably small size on most displays.
>> 
>> “font-family: Helvetica, sans-serif;” sets the font family to be ‘Helvetica’ 
>> or the closest generic system sans-serif font available if Helvetica is not 
>> on your system. You can use any font here you like. I just included 
>> Helvetica as an example. The default (‘San Francisco’ on a Mac) is pretty 
>> good, so you don’t need to even include this line if you like it as is, just 
>> use the font-size rule.
>> 
>> --
>> 
>>  #account_tree, .GncAccountPage {
>>background-color: lightgrey;
>>  }
>> 
>> 
>> “#account_tree” targets the main part of the Account page window, 
>> “.GncAccountPage” targets the small background behind the Totals bar which 
>> appears to be part of the page. You can put them together as I have done 
>> here in a list to apply the same rule to both, or write separate 
>> declarations for each with their own rules if you want the colors to be 
>> different.
>> 
>> You can also set specified font-sizes and font-families here as well if you 
>> want them different than the rest of the window. Just add those rules into 
>> those declarations. I’ve included a background color rule here because that 
>> is what you asked for, with the ‘lightgrey’ example. Depending on what you 
>> are looking for, or what color you choose, you may need to also set a 
>> foreground (text) color to balance properly. See the next declaration for an 
>> example.
>> 
>> --
>> 
>>  treeview button {
>>background-color: lightgrey;
>>color: black;
>>  }
>> 
>> 
>> “treeview button” targets the header bar at the top of the Account table. 
>> Again, you might need to include a foreground color rule here as this 
>> particular background color makes the header labels harder to read. (simply 
>> “color”)
>> 
>> For colors you can specify a ‘named websafe color’ (do a search on that term 
>> for possible color names) or you can use RGB integer or hex values if you 
>> want to specify a non-named color. (you don’t have to use names either, you 
>> can use the actual color value for ‘lightgrey’ if you want)
>> 
>> For example, if you wanted to match the background color of the tabs area, 
>> you’d use:
>> 
>> 

Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

[John Ralls]

Ah, sorry, that wasn’t obvious to me.

Try running GnuCash with ‘--log gnc.scm=debug’ instead of ‘--debug’. That 
should produce a listing of each price retrieved and its values as 
price-quotes.scm processes them and may offer a clue about the problem.

Regards,
John Ralls


> On Oct 20, 2018, at 9:26 AM, rsbrux via gnucash-user 
>  wrote:
> 
> Dear John,
> The error message was in my subject line:
>> Unable to retrieve quotes for these items:, CURRENCY:EUR
> Thanks for your support!
> 
> 
> Sent from my iPad
> 
>> On 20.10.2018, at 18:00, 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:  Preferences for latest version (Jill Terry)
>>  2.  Unable to retrieve quotes for these items:, CURRENCY:EUR (rsbrux)
>>  3.  OFX Importer Matching: too many false positives in matching
>> with repeated transactions (Milan Kn??ek)
>>  4. Re:  Size of Windows, tabs, Fonts, etc Twice as big in 3.3 vs
>> 3.2 (John Ralls)
>>  5. Re:  Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . .
>> .=c73e0385e4d13ab79. . . . . . . (John Ralls)
>>  6. Re:  Unable to retrieve quotes for these items:, CURRENCY:EUR
>> (John Ralls)
>>  7. Re:  Associate file with transaction path (Anthony Marrian)
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> ___
>> 
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Thanks

[David Both]

Thank you for a great product. I have been using GnuCash for over 12 
years and I have never been happier with any other financial software 
for my home or business.


I have just donated to the project.

PS: I am happy to see the amounts are back next to the checkboxes in the 
reconciliation window. Thanks for moving those columns back to where 
they should be, close together.



--

*
David P. Both
*
The value of any software lies in its usefulness
not in its price.

— Linus Torvalds
*

___
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] Unable to retrieve quotes for these items:, CURRENCY:EUR

[rsbrux via gnucash-user]

Dear John,
The error message was in my subject line:
>  Unable to retrieve quotes for these items:, CURRENCY:EUR
Thanks for your support!


Sent from my iPad

> On 20.10.2018, at 18:00, 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:  Preferences for latest version (Jill Terry)
>   2.  Unable to retrieve quotes for these items:, CURRENCY:EUR (rsbrux)
>   3.  OFX Importer Matching: too many false positives in matching
>  with repeated transactions (Milan Kn??ek)
>   4. Re:  Size of Windows, tabs, Fonts, etc Twice as big in 3.3 vs
>  3.2 (John Ralls)
>   5. Re:  Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . .
>  .=c73e0385e4d13ab79. . . . . . . (John Ralls)
>   6. Re:  Unable to retrieve quotes for these items:, CURRENCY:EUR
>  (John Ralls)
>   7. Re:  Associate file with transaction path (Anthony Marrian)
> 
> 
> 
> 
> 
> 
> 
> ___
> 
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Capital losses in Advanced Portfolio Report

[José Antonio Fernández Troncoso]

Hello,

In my advanced porfolio report, capital losses linked to a stock account are 
added to the Income column as if they were dividends. 

Could anyone using this report provide some feedback as to whether this also 
happens to them? Is there a bug in the report or am I doing something wrong?

I'm using GnuCash Version: 3.2. Build ID: 3.2+ (2018-06-24).

Cheers,
Jose Troncoso



___
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] Associate file with transaction path

[Anthony Marrian]

No solution. Windows 10 Pro 64 bit. The path (Edit / Preferences / General / 
Path head for Transaction Association Files) is to a folder on a mapped network 
drive. The preference is ignored; I am simply provided with a list of files in 
Recent. The quickest work-around is to select a file in the Recent list, then 
add the transaction association a second time; at the second attempt the 
correct folder is opened. It would be *wonderful* if you could fix this.

Best - Anthony

-Original Message-
From: gnucash-user 
 On Behalf Of 
Adrien Monteleone
Sent: 28 August 2018 04:36
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Associate file with transaction path

Anthony,

Did you find a solution?

What OS and is this a local path, external drive, network location?

Also, if Linux is your OS, did you by chance install using the flatpak?

Regards,
Adrien

> On Aug 11, 2018, at 5:24 AM, Anthony Marrian  
> wrote:
> 
> So sorry: version 3.2
> 
> From: Anthony Marrian
> Sent: 11 August 2018 11:23
> To: 'gnucash-user@gnucash.org' 
> Subject: Associate file with transaction path
> 
> The preference I've set under Edit / Preferences / General / Path Head for 
> Transaction Associated Files is ignored. Any tips, please?
> 
> With best wishes - Anthony
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


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

Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

[John Ralls]

> On Oct 20, 2018, at 2:20 AM, rsbrux via gnucash-user 
>  wrote:
> 
> I am using GC 2.6.19 under Ubuntu Studio 18.04 and cannot get Online Quotes 
> to work.
> 
> I have a few currencies enabled for quotation and several stocks. All of them 
> work except for EUR.  My base currency is CHF
> 
> I have successfully tested all of the currencies for which I have Online 
> Quotes enabled successfully using both gnc-fq-dump and gnc-fq-helper.
> 
> I have created a trace by:
> 
> 1. gnucash --debug
> 2. Open Price Editor
> 3. Get Quotes (error message appears)
> 4. Close Price Editor
> 5. Close GnuCash
> 
> However, I find no relevant info in the trace file.
> 
> I also repeated the above using gnucash --debug --extra, but the trace files 
> appear the same.  the --extra option produced a lot of output in the terminal 
> window, but nothing which appeared interesting or relevant.
> 
> Please advise on how to proceed.  Is anyone interested in my trace file?  
> What else can I do to troubleshoot this problem?


What’s the error message?

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] Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . . .=c73e0385e4d13ab79. . . . . . .

[John Ralls]

> On Oct 19, 2018, at 10:07 PM, Leonidas Giorgallis  
> wrote:
> 
> Hello everybody ,
> 
> 
> 
> I have a small business and I am using with GnuCash for many years now up to
> 2.21.6 without  any problem.
> 
> 
> 
> After I update to 3.1 and or 3.3 I am getting error Bad URL:
> owner=c:76e7c13664c9ad99e. . . . . . . . .=c73e0385e4d13ab79. . . . . . .
> 
> 
> 
> When I  trying to access the Customer Report from Customer Listing Page
> click on the total amount.
> 
> 
> 
> And  Bad URL: owner=v:25d36d07e2dfdfee. . . . .=682a6e0889aabfc949e . . . .
> . . .
> 
> 
> 
> When I  trying to access the Vendor Report from Vendor Listing Page click on
> the total amount.
> 
> 
> 
> I using windows 10 Ver. 1803 OS Build 17134.345
> 
> 
> 
> Unfortunately after I spent a hundreds of hours trying everything  I
> couldn't solve this Error.
> 
> 
> 
> Anybody can help Please?
> 
> 
> 
> Thanks 


Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=795188 
, which Geert fixed last 
week.

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] Size of Windows, tabs, Fonts, etc Twice as big in 3.3 vs 3.2

[John Ralls]

I guess it’s a matter of opinion whether it's a bug or not. It was an effort to 
get text scaling right on Retina, see 
https://bugzilla.gnome.org/show_bug.cgi?id=795188 
 for the full discussion.

Regards,
John Ralls


> On Oct 19, 2018, at 2:25 PM, Adrien Monteleone 
>  wrote:
> 
> Create a file using Text Edit.app and put this in it:
> 
> * {
>  font-size: 12px;
> }
> 
> Use Format > Make Plain Text to convert it to plain text, then save it as 
> “gtk-3.0.css” and put it in “/yourusername/Library/Application 
> Support/Gnucash”
> 
> This will cause the entire app to have a text size similar to the default for 
> your Mac.
> 
> Note, this and more customizations are documented on the wiki. Check the FAQ 
> in the Configuring & Customizing section. There you will find links to CSS 
> and GTK3 pages detailing your options.
> 
> If Geert & John are reading this: was this a change to accommodate retina 
> scaling or is this a bug?
> 
> Regards,
> Adrien
> 
>> On Oct 19, 2018, at 3:21 PM, DenverJim  wrote:
>> 
>> Hi.  This a more annoying issue than anything else.  When i upgraded to 3.3,
>> the entire GUI, along with everything else, is much larger.  I used to be
>> able to see everything i needed on my screen, but now have to scroll the app
>> horizontally to see everything.  Font sizes are much bigger, Tabs widths
>> bigger, entire width of the overall guy is wider.  
>> 
>> I've looked at preferences and read help manual, but see nothing about how
>> to resize everything back the way it was in 3.2.  
>> 
>> Any help appreciated.  
>> 
>> Running 3.3 on MacOs High Sierra on MBP.
>> 
>> Thanks,
>> 
>> 
>> 
>> 
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] OFX Importer Matching: too many false positives in matching with repeated transactions

[Milan Knížek]

Hi,

Although I assume that the Importer GUI was primarily made to reconcile 
the previously manually entered transactions with the actual bank 
statement, I use it purely for getting the transactions to GnuCash. That 
said, I have other process to check the bank statements rather than 
reconciling it in GnuCash.


Unfortunatelly, the importer tries to match as much as possible, which 
results in considering many repeated transactions (utility pmts, rent, 
etc.) as already existing in the ledger and proposes to "reconcile" or 
"update and reconcile".


However, there is no such transaction in the current month - it probably 
tries to match with a similar item from prior periods.


Is there any way how to make the importer less agressive at matching? 
E.g. limiting the time span +/- days?


P.S. Note that I still like and use the matching - e.g. when a 
transaction is already entered manually or imported via other bank 
account.


Best regards,
Milan

--
Milan Knížek | knizek.co...@gmail.com
___
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] Unable to retrieve quotes for these items:, CURRENCY:EUR

[rsbrux via gnucash-user]

I am using GC 2.6.19 under Ubuntu Studio 18.04 and cannot get Online 
Quotes to work.


I have a few currencies enabled for quotation and several stocks. All of 
them work except for EUR.  My base currency is CHF


I have successfully tested all of the currencies for which I have Online 
Quotes enabled successfully using both gnc-fq-dump and gnc-fq-helper.


I have created a trace by:

1. gnucash --debug
2. Open Price Editor
3. Get Quotes (error message appears)
4. Close Price Editor
5. Close GnuCash

However, I find no relevant info in the trace file.

I also repeated the above using gnucash --debug --extra, but the trace 
files appear the same.  the --extra option produced a lot of output in 
the terminal window, but nothing which appeared interesting or relevant.


Please advise on how to proceed.  Is anyone interested in my trace 
file?  What else can I do to troubleshoot this problem?


___
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] Preferences for latest version

[Jill Terry]

Hi Adrien

First of all sorry for delay in replying and thank you very much for this.

Could you tell me how to have even and odd rule for the account page?   
Prior to upgrading, it used to display white but with every other line 
in grey, which is much easier to read.


Cheers
Jill

On 19/10/2018 19:48, Adrien Monteleone wrote:

Jill,

Try this:

Close GnuCash.

Using a text editor (such as ’TextEdit.app’) create a file named gtk-3.0.css 
and place it in /yourusername/Library/Application Support/Gnucash

have it contain the following three CSS declarations:

* {
   font-size: 12px;
   font-family: Helvetica, sans-serif;
}

#account_tree, .GncAccountPage {
   background-color: lightgrey;
}

treeview button {
   background-color: lightgrey;
   color: black;
}

Save the file as ‘Plain Text’. (Format > Make Plain Text)

Start GnuCash to see your changes.

--
Here’s what this code does:

* {
  font-size: 12px;
  font-family: Helvetica, sans-serif;
}


“font-size: 12px;” sets the font size for all (*) elements in the windows for 
the entire application. Set to the size you find appropriate. 12px (pixels) is 
a readably small size on most displays.

“font-family: Helvetica, sans-serif;” sets the font family to be ‘Helvetica’ or 
the closest generic system sans-serif font available if Helvetica is not on 
your system. You can use any font here you like. I just included Helvetica as 
an example. The default (‘San Francisco’ on a Mac) is pretty good, so you don’t 
need to even include this line if you like it as is, just use the font-size 
rule.

--

#account_tree, .GncAccountPage {
  background-color: lightgrey;
}


“#account_tree” targets the main part of the Account page window, 
“.GncAccountPage” targets the small background behind the Totals bar which 
appears to be part of the page. You can put them together as I have done here 
in a list to apply the same rule to both, or write separate declarations for 
each with their own rules if you want the colors to be different.

You can also set specified font-sizes and font-families here as well if you 
want them different than the rest of the window. Just add those rules into 
those declarations. I’ve included a background color rule here because that is 
what you asked for, with the ‘lightgrey’ example. Depending on what you are 
looking for, or what color you choose, you may need to also set a foreground 
(text) color to balance properly. See the next declaration for an example.

--

treeview button {
  background-color: lightgrey;
  color: black;
}


“treeview button” targets the header bar at the top of the Account table. 
Again, you might need to include a foreground color rule here as this 
particular background color makes the header labels harder to read. (simply 
“color”)

For colors you can specify a ‘named websafe color’ (do a search on that term 
for possible color names) or you can use RGB integer or hex values if you want 
to specify a non-named color. (you don’t have to use names either, you can use 
the actual color value for ‘lightgrey’ if you want)

For example, if you wanted to match the background color of the tabs area, 
you’d use:

background-color: rgb(207,207,205);

or

background-color: #cfcfcd;

If you wanted to match the background area of the icon toolbar, you’d use 
rgb(232,232,231) or #e8e8e7.

If you want to know the color of a particular screen element, use the “Digital Color 
Meter.app". It will give you the color value of the item you point to as three 
separate integers for Red, Green & Blue (RGB) in the interval 0-255. If you want the 
hex value instead, you can then use a site like rgbtohex.net to convert it. It is 
important to always enter the RGB values in that R,G,B order to get the correct color.

--
You can make changes to the CSS file while GnuCash is open, but you’ll have to 
restart (after saving the CSS file) to see them take effect.

Let me know if you have any questions.

Regards,
Adrien



On Oct 17, 2018, at 8:53 AM, Jill Terry  wrote:

Thanks folks.

The location of the css file given in the wiki is given for a mac, I cannot 
locate a folder for Gnucash under Application Support.  Besides which I have no 
idea how to find the correct .class to adjust.

I love GnuCash and so appreciate the program. But (yep always a but LOL!)  I 
hate with a vengeance the way there are no simple links to things.  I have no 
idea how to get to the online version of these emails to search older posts!

I am old and tired (and grumpy LOL!) and really struggle to learn new things. 
Why oh why did they remove the alternate line shading and change the font

Cheers
(a very tired) Jill



On 17/10/2018 12:45, Adrien Monteleone wrote:

Jill,

Look at the wiki FAQ, you’ll see links to pages about GTK3 styling. There are 
some basics there, otherwise, a few months back, myself and a few others spent