date:20200817

[GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-17 Thread Adrien Monteleone

That didn't get very far. Not sure if this is a GnuCash bug, or an
Inspector bug:

```
mint@mint:~$ GTK_DEBUG=interactive /usr/bin/gnucash
Found Finance::Quote version 1.49.
**
Gdk:ERROR:../../../../gdk/gdkwindow.c:6530:gdk_window_set_cursor_internal:
assertion failed: (!cursor || gdk_window_get_display (window) ==
gdk_cursor_get_display (cursor))
Bail out!
Gdk:ERROR:../../../../gdk/gdkwindow.c:6530:gdk_window_set_cursor_internal:
assertion failed: (!cursor || gdk_window_get_display (window) ==
gdk_cursor_get_display (cursor))

Aborted (core dumped)
```

GnuCash started as did the inspector, but as soon as GnuCash finished
loading, the Inspector blew up and spit out the above.

I suspect an Inspector error but it could be from being fed something
unexpected by GnuCash.

For full disclosure, I'm running this in a live environment, Mint is not
installed.

Regards,
Adrien

On 8/17/20 11:58 PM, Adrien Monteleone wrote:

I can confirm this.

I fired up Mint 20 Cinnamon in Vbox and installed GnuCash 3.8 from the
Mint repos.

Generally, GnuCash should use the default GTK theme, which on Mint 20 is
Mint-Y-Dark.

*note, the proper file name is `settings.ini` *not* `setup.ini`

Per the wiki I created:

~/.config/gtk-3.0/settings.ini

to contain:

[Settings]
gtk-theme-name=Mint-Y-Dark

ref: https://wiki.gnucash.org/wiki/GTK3#Themes
ref: https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME

Remembering that some 'Dark' themes aren't completely dark, with some
panels still light, I tried:

gtk-theme-name=Mint-Y-Darker

to no effect.

I also tried with setting this key instead:

gtk-application-prefer-dark-theme=true

ref:
https://developer.gnome.org/gtk3/stable/GtkSettings.html#GtkSettings--gtk-application-prefer-dark-theme

ref: https://wiki.gnucash.org/wiki/GTK3#Themes

also to no effect.

*note, the above referenced Wiki page on themes advises to set the theme
using Gnome Tweak. But Mint has its own Theme preference app. Presumably
GnuCash should use the default system theme. It also discusses
installing a custom theme, but that is not needed in this case at is a
system theme.

I suppose I should fire up the GTKInspector to see what theme is being
picked up. I shall report back what I find.

Regards,
Adrien

On 8/17/20 8:53 PM, Jimmy R via gnucash-user wrote:

If the setup.ini works on a mac should it work on Mint/ Ubuntu if yes
Then I have had no luck with the setup.ini doing anything for setting the
dark theme = true on Mint 20.04

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

2020-08-17 Thread Adrien Monteleone


You were using the 3.2 Flatpak and it worked?

I'd suspect something with the Flatpak sandbox would be interfering.

Note, if you had to seek help on the list in 2018, you could search the 
list archives for that time period via your favorite search engine.


prepend your search terms with:

  site:lists.gnucash.org

and you should be limited to results only from the mailing list server.

Certainly, include as one of your terms, your name or e-mail address 
with a "+" in front to only give you results involving you. Then you can 
spot the proper thread(s) and refresh your memory on the 2018 solution.


Regards,
Adrien

On 8/17/20 12:11 PM, andy ngo wrote:

Hi there:
Up to now, I've been used
Gnucash 3.2
in Ubuntu 18.04
with mysql 5.7.31

My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
  
Gnucash 4.1

Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04
with mysql 8.0.21

Now, I can't connect to mysql anymore.

I couldn't open the old file. Then I tried to create a new one, nothing
worked.

I did install
libdbi1 libdbi-dev
libdbd-mysql

I've used Gnucash since 2013.  Every time I changed a new computer (this is
the 4th time), I had this problem. The last time was in 2018. I'm getting
old now and I couldn't remember how I did fix it.

I did found some old topics in this forum about the same problems, but they
did not help.

What did I still miss?


___
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] help increasing size of font in GnuCash?

2020-08-17 Thread Adrien Monteleone

I can confirm this.

I fired up Mint 20 Cinnamon in Vbox and installed GnuCash 3.8 from the
Mint repos.

Generally, GnuCash should use the default GTK theme, which on Mint 20 is
Mint-Y-Dark.

*note, the proper file name is `settings.ini` *not* `setup.ini`

Per the wiki I created:

~/.config/gtk-3.0/settings.ini

to contain:

[Settings]
gtk-theme-name=Mint-Y-Dark

ref: https://wiki.gnucash.org/wiki/GTK3#Themes
ref: https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME

Remembering that some 'Dark' themes aren't completely dark, with some
panels still light, I tried:

gtk-theme-name=Mint-Y-Darker

to no effect.

I also tried with setting this key instead:

gtk-application-prefer-dark-theme=true

ref:
https://developer.gnome.org/gtk3/stable/GtkSettings.html#GtkSettings--gtk-application-prefer-dark-theme

ref: https://wiki.gnucash.org/wiki/GTK3#Themes

also to no effect.

I suppose I should fire up the GTKInspector to see what theme is being
picked up. I shall report back what I find.

Regards,
Adrien

On 8/17/20 8:53 PM, Jimmy R via gnucash-user wrote:

If the setup.ini works on a mac should it work on Mint/ Ubuntu if yes
Then I have had no luck with the setup.ini doing anything for setting the
dark theme = true on Mint 20.04

[GNC] mysql gnucash

2020-08-17 Thread andy ngo

Hi there:
Up to now, I've been used 
Gnucash 3.2 
in Ubuntu 18.04
with mysql 5.7.31

My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
 
Gnucash 4.1
Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04 
with mysql 8.0.21

Now, I can't connect to mysql anymore. 

I couldn't open the old file. Then I tried to create a new one, nothing
worked.

I did install 
libdbi1 libdbi-dev
libdbd-mysql

I've used Gnucash since 2013.  Every time I changed a new computer (this is
the 4th time), I had this problem. The last time was in 2018. I'm getting
old now and I couldn't remember how I did fix it.

I did found some old topics in this forum about the same problems, but they
did not help.

What did I still miss? 

Thank you very much
Andy



 




--
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] help increasing size of font in GnuCash?

2020-08-17 Thread Jimmy R via gnucash-user

If the setup.ini works on a mac should it work on Mint/ Ubuntu if yes
Then I have had no luck with the setup.ini doing anything for setting the
dark theme = true on Mint 20.04

Jimmy



--
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] help increasing size of font in GnuCash?

2020-08-17 Thread John Ralls

If you read the wiki carefully you'll realize that configuration files are 
looked for in USER_CONFIG_HOME, not USER_DATA_HOME. On Linux and macOS Gtk (and 
most other modern Linux desktop programs) use the XDG spec 
(https://specifications.freedesktop.org/basedir-spec/basedir-spec-latest.html) 
and the default for XDG_CONFIG_HOME is $HOME/.config. 

For macOS Gnucash.app/Contents/Resources/etc/gnucash/environment set 
XDG_CONFIG_HOME to $HOME/Library/Application Support/Gnucash/config, so you can 
put a gtk.css or setup.ini there. 

Gtk looks through a set of hardwired locations as well as XDG_CONFIG_HOME, most 
of which are for backward compatibility: ~/.gtk-3.0.css, ~/.gtk-3.0/gtk.css, 
and ~/.config/gtk-3.0/gtk.css, ~/.gtk-3.0/setting.ini, 
~/.config/gtk-3.0/settings.ini.

Regards,
John Ralls

> On Aug 17, 2020, at 11:56 AM, Adrien Monteleone 
>  wrote:
> 
> Peter,
> 
> If you read the Wiki carefully, you'll see that the `~/.local/share/gtk-3.0` 
> location is for all GTK apps, not just GnuCash. The GTK theme may conflict 
> and your customization may not override the theme in some cases. (note, the 
> Wiki also notes that `gtk-3.0.css` will override `gtk.css`)
> 
> The proper location to customize the GnuCash UI via CSS is:
>  ~/Library/Application Support/GnuCash
> 
> Regards,
> Adrien
> 
> On 8/16/20 1:47 AM, Peter West wrote:
>>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>>  wrote:
>> …
>>> The file should be named:
>>> 
>>>  gtk-3.0.css
>> That’s why I couldn’t get mine to work in either location. I was using 
>> gtk.css.
>> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT 
>> work, in spite of the wiki.
>>> 
>>> The location should be:
>>> 
>>>  ~/Library/Application Support/GnuCash
> 
> ___
> 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] help increasing size of font in GnuCash?

2020-08-17 Thread Peter West

Yes, I have discovered that. I’m very pleased that D. found the reference 
before I had to go hunting for it again.

The wiki is clearly wrong (and it is the Gnucash wiki). If that location 
applies to all GTK apps, I would assume that, in the absence of 
Gnucash-specific override, it will work for GC. Similarly, in the absence of 
gtk-3.0.css, gtk.css will work. It doesn’t.

I take it that either GTK configuration is buggy, or is being overridden in an 
unusual way within the code; unusual in that some configuration escapes and is 
available to users.

Should I set up a bugzilla account, or will someone else report this 
documentation inconsistency?

Peter
--
Peter West
p...@pbw.id.au
“O woman, great is your faith! Be it done for you as you desire.” And her 
daughter was healed instantly.

> On 18 Aug 2020, at 4:56 am, Adrien Monteleone 
>  wrote:
> 
> Peter,
> 
> If you read the Wiki carefully, you'll see that the `~/.local/share/gtk-3.0` 
> location is for all GTK apps, not just GnuCash. The GTK theme may conflict 
> and your customization may not override the theme in some cases. (note, the 
> Wiki also notes that `gtk-3.0.css` will override `gtk.css`)
> 
> The proper location to customize the GnuCash UI via CSS is:
>  ~/Library/Application Support/GnuCash
> 
> Regards,
> Adrien
> 
> On 8/16/20 1:47 AM, Peter West wrote:
>>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>>  wrote:
>> …
>>> The file should be named:
>>> 
>>>  gtk-3.0.css
>> That’s why I couldn’t get mine to work in either location. I was using 
>> gtk.css.
>> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT 
>> work, in spite of the wiki.
>>> 
>>> The location should be:
>>> 
>>>  ~/Library/Application Support/GnuCash
> 
> ___
> 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-user Digest, Vol 209, Issue 49

2020-08-17 Thread A Harvey

Could be confusion between Windows 10 behavior and common browsers.  In
Firefox and Chrome, CTL + and CTL - increase and decrease size of
everything displayed within a browser tab. This is independent of the
magnifier function and of what other applications may provide.

-Arthur

On Mon, Aug 17, 2020 at 5:15 PM David H  wrote:

> It also works fine on my Win 10 Pro laptop.
>
> Not sure why you keep talking about CTRL + & -  as my version of Windows 10
> says to use the Windows logo key as per attached.  You can also change the
> increment steps and press and hold Ctrly + Alt and use the mouse wheel to
> zoom in or out ...
>
> Regards David H.
>
>
>
> On Tue, 18 Aug 2020 at 02:39, Fred Bone  wrote:
>
> > On 17 August 2020 at 10:25, nor said:
> >
> > > Hello,With "Magnifier" I failed to magnify the screen precisely.
> Normally
> > > I use CTRL + & - to magnify view  in steps of 10% for all apps. in case
> > > the fonts are small.  But with app GNU it seems not possible. I am on
> WIN
> > > 10.However, A fonts customization in preferences will be the suggestion
> > > for the developers .nor
> >
> > Magnifier works fine on my Win10 machine.
> > ___
> > 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] help increasing size of font in GnuCash?

2020-08-17 Thread Adrien Monteleone


Peter,

If you read the Wiki carefully, you'll see that the 
`~/.local/share/gtk-3.0` location is for all GTK apps, not just GnuCash. 
The GTK theme may conflict and your customization may not override the 
theme in some cases. (note, the Wiki also notes that `gtk-3.0.css` will 
override `gtk.css`)


The proper location to customize the GnuCash UI via CSS is:
  ~/Library/Application Support/GnuCash

Regards,
Adrien

On 8/16/20 1:47 AM, Peter West wrote:

On 16 Aug 2020, at 1:29 pm, Adrien Monteleone  
wrote:

…

The file should be named:

  gtk-3.0.css


That’s why I couldn’t get mine to work in either location. I was using gtk.css.

I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
in spite of the wiki.


The location should be:

  ~/Library/Application Support/GnuCash


___
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] help increasing size of font in GnuCash?

2020-08-17 Thread D. via gnucash-user

John, 

I wondered about that as well; a check of the wiki turns that location up in 
this section: 
https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_DATA_HOME

 Original Message 
From: John Ralls 
Sent: Mon Aug 17 12:13:08 EDT 2020
To: Peter West 
Cc: gnucash-u...@lists.gnucash.org, adrien.montele...@lusfiber.net
Subject: Re: [GNC] help increasing size of font in GnuCash?

> On Aug 15, 2020, at 11:47 PM, Peter West  wrote:
> 
>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>  wrote:
> …
>> The file should be named:
>> 
>> gtk-3.0.css
> 
> That’s why I couldn’t get mine to work in either location. I was using 
> gtk.css.
> 
> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
> in spite of the wiki.
>> 
>> The location should be:
>> 
>> ~/Library/Application Support/GnuCash
> 

Where does the wiki say that one can use ~/.local/share for anything?

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.

___
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-user Digest, Vol 209, Issue 49

2020-08-17 Thread Fred Bone

On 17 August 2020 at 10:25, nor said:

> Hello,With "Magnifier" I failed to magnify the screen precisely. Normally
> I use CTRL + & - to magnify view  in steps of 10% for all apps. in case
> the fonts are small.  But with app GNU it seems not possible. I am on WIN
> 10.However, A fonts customization in preferences will be the suggestion
> for the developers .nor

Magnifier works fine on my Win10 machine.
___
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] help increasing size of font in GnuCash?

2020-08-17 Thread John Ralls

> On Aug 15, 2020, at 11:47 PM, Peter West  wrote:
> 
>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>  wrote:
> …
>> The file should be named:
>> 
>> gtk-3.0.css
> 
> That’s why I couldn’t get mine to work in either location. I was using 
> gtk.css.
> 
> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
> in spite of the wiki.
>> 
>> The location should be:
>> 
>> ~/Library/Application Support/GnuCash
> 

Where does the wiki say that one can use ~/.local/share for anything?

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] help increasing size of font in GnuCash?

2020-08-17 Thread nor via gnucash-user

Hello,With "Magnifier" I failed to magnify the screen precisely. Normally I
use CTRL + & - to magnify view  in steps of 10% for all apps. in case the
fonts are small.  But with app GNU it seems not possible. I am on WIN
10.However, A fonts customization in preferences will be the suggestion for
the developers .nor



-
nor
--
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] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user

Ah, yes. ISTR that AlphaVantage is used for all currency conversions. 

That would suggest that users should be told that outright somewhere.


 Original Message 
From: Geoff 
Sent: Mon Aug 17 08:32:10 EDT 2020
To: "D." 
Cc: David Reiser via gnucash-user , 
gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

One would think so David, but my experience was otherwise.

When running Get Quotes on a brand new default database with no 
securities defined, and then after adding just one security for this 
mutual fund, in both cases I was prompted to enter an AlphaVantage API 
key - see attached screenshots.

I believe this behaviour is because I set up the database with a 
currency code of INR, as when I do the same with USD the error message 
doesn't manifest.

Anyway, for this particular issue, the root cause was the failed 
installation of the supporting perl modules.

Have a good day.

Regards

Geoff
=

On 17/08/2020 9:00 pm, D. wrote:
> Of course, if you're using amfiindia as your price source, it's not 
> technically necessary to add an AlphaVantage key, since you're not using 
> AlphaVantage as a source.
> 
> 
>  Original Message 
> From: Geoff 
> Sent: Mon Aug 17 01:41:22 EDT 2020
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Get quote - online price retrieval
> 
> Ashok, I have tried to replicate your issue on a new Windows 10 installation.
> 
> You said:-
> "Did the cpan Date::Manip, but that freezes at the point of the below stage.
> Have to "Ctrl"+C, ugly exit."
> 
> You need to be more patient, it wasn't frozen, just having a rest!  The
> complete installation process of all the necessary perl modules for price
> quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
> about 30 minutes on my machine, and there were a couple of significant
> pauses along the way.
> 
> Once you have successfully installed Finance::Quotes and all of its
> dependencies, you will be able to get a quote for your fund:
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
> Finance::Quote fields Gnucash uses:
>  symbol: 106876   <=== required
>date: 08/14/2020   <=== recommended
>currency: INR  <=== required
>last:  <=\
> nav: 17.6037  <=== one of these
>   price:  <=/
>timezone:  <=== optional
> 
> All fields returned by Finance::Quote for stock 106876
> 
> stock   field  value
> -   -  -
> 106876   currency: INR
> 106876   date: 08/14/2020
> 106876isodate: 2020-08-14
> 106876   link: https://www.amfiindia.com/spages/NAVAll.txt
> 106876 method: amfitable
> 106876   name: Aditya Birla Sun Life International Equity Fund -
> Plan B - Growth - Regular Plan
> 106876nav: 17.6037
> 106876 source: http://www.amfiindia.com/
> 106876success: 1
> 106876 symbol: 106876
> 
> 
> I have also attached a screenshot of getting a quote from within gnucash -
> don't forget to add your AlphaVantage API key first as explained here:
> https://wiki.gnucash.org/wiki/Online_Quotes
> 
> 
> DETAILED INSTRUCTIONS
> =
> Windows 10 Version 1903
> 
> Download gnucash 4.1 for Windows 10 from:
> https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe
> 
> Verify the checksum from https://www.gnucash.org/news.phtml
> We are expecting:
> "836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
> gnucash-4.1.setup.exe
> 
> 08/17/2020  12:56 PM  ..
> 08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe
> 
> C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
> SHA256 hash of gnucash-4.1.setup.exe:
> 836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
> CertUtil: -hashfile command completed successfully.
> 
> 
> Download strawberry perl from http://strawberryperl.com/
> http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi
> 
> 08/17/2020  01:04 PM  .
> 08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi
> 
> C:>perl -v
> This is perl 5, version 30, subversion 2 (v5.30.2) built for
> MSWin32-x64-multi-thread
> 
> C:>cd "C:\Program Files (x86)\gnucash\bin"
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
> 
> You need to install the following Perl modules:
>Finance::Quote
> 
> Use your system's package manager to install them,
> or run 'gnc-fq-update' as root.
> missing-lib
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
> Fetching with LWP:
> http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/03modlist.data.gz
> Creating database file ... Done!
> Running install

Re: [GNC] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user

Of course, if you're using amfiindia as your price source, it's not technically 
necessary to add an AlphaVantage key, since you're not using AlphaVantage as a 
source. 

 Original Message 
From: Geoff 
Sent: Mon Aug 17 01:41:22 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

Ashok, I have tried to replicate your issue on a new Windows 10 installation.

You said:-
"Did the cpan Date::Manip, but that freezes at the point of the below stage.
Have to "Ctrl"+C, ugly exit."

You need to be more patient, it wasn't frozen, just having a rest!  The
complete installation process of all the necessary perl modules for price
quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
about 30 minutes on my machine, and there were a couple of significant
pauses along the way.

Once you have successfully installed Finance::Quotes and all of its
dependencies, you will be able to get a quote for your fund:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
Finance::Quote fields Gnucash uses:
symbol: 106876   <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last:  <=\
   nav: 17.6037  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 106876

stock   field  value
-   -  -
106876   currency: INR
106876   date: 08/14/2020
106876isodate: 2020-08-14
106876   link: https://www.amfiindia.com/spages/NAVAll.txt
106876 method: amfitable
106876   name: Aditya Birla Sun Life International Equity Fund -
Plan B - Growth - Regular Plan
106876nav: 17.6037
106876 source: http://www.amfiindia.com/
106876success: 1
106876 symbol: 106876

I have also attached a screenshot of getting a quote from within gnucash -
don't forget to add your AlphaVantage API key first as explained here:
https://wiki.gnucash.org/wiki/Online_Quotes

DETAILED INSTRUCTIONS
=
Windows 10 Version 1903

Download gnucash 4.1 for Windows 10 from:
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe

Verify the checksum from https://www.gnucash.org/news.phtml
We are expecting:
"836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
gnucash-4.1.setup.exe

08/17/2020  12:56 PM  ..
08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe

C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
SHA256 hash of gnucash-4.1.setup.exe:
836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
CertUtil: -hashfile command completed successfully.

Download strawberry perl from http://strawberryperl.com/
http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi

08/17/2020  01:04 PM  .
08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi

C:>perl -v
This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread

C:>cd "C:\Program Files (x86)\gnucash\bin"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Creating database file ... Done!
Running install for module 'Date::Manip'
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS
Checksum for
C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok
Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good

~~~ snip ~~~

2900 lines later it should complete successfully with:

Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm
Appending installation info to C:\Strawberry\perl\lib/perllocal.pod
  ECOCODE/Finance-Quote-1.49.tar.gz
  C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK

C:\Program Files (x86)\gnucash\bin>

Hope this helps.

Geoff
=

--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___

Re: [GNC] help increasing size of font in GnuCash?

2020-08-17 Thread Marilyn Graves Kimple via gnucash-user

 I found it! But I swear to you it did not show up in my Users file until I 
went back and searched for it. 
Best regards,mgk
On Sunday, August 16, 2020, 06:53:51 PM EDT, David Reiser 
 wrote:  

 That’s the wrong library folder. There’s another one in /Users/[your user 
name]/Library.

Dave
--
Dave Reiser
dbrei...@icloud.com

> On Aug 16, 2020, at 5:56 PM, Marilyn Graves Kimple via gnucash-user 
>  wrote:
> 
> No problem-- there were actually two of us with the same problem, and I do 
> have a Mac but the other was Windows. But I know about Application Support 
> and I do not have a GnuCash folder. No idea why not.

___
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] help increasing size of font in GnuCash?

2020-08-17 Thread Peter West

> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>  wrote:
…
> The file should be named:
> 
>  gtk-3.0.css

That’s why I couldn’t get mine to work in either location. I was using gtk.css.

I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
in spite of the wiki.
> 
> The location should be:
> 
>  ~/Library/Application Support/GnuCash

--
Peter West
p...@pbw.id.au
“O woman, great is your faith! Be it done for you as you desire.” And her 
daughter was healed instantly.

___
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] Difficulty with online price retrieval

2020-08-17 Thread Samantha Payn

   John, thank you for your continued patience!

   This is what I got:

   * 10:13:32 DEBUG  rpt-subdir=gnucash/reports/standard
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
   * 10:13:32 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)
   * 10:13:32 DEBUG  rpt-subdir=gnucash/reports/example
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
   * 10:13:32 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)
   * 10:13:32 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
   * 10:13:32 DEBUG  dir-files=(taxtxf)
   * 10:13:32 DEBUG  rpt-subdir=gnucash/report/stylesheets
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
   * 10:13:32 DEBUG  dir-files=(plain head-or-tail footer css)
   * 10:13:33 DEBUG  gnc:fq-check-sources results: (1.49 adig aex
   aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet
   bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest
   cse deka dutch dwsfunds europe fetch_live_currencies fidelity
   fidelity_direct fidelityfixed financecanada finanzpartner finland fool
   france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney
   greece hex hu hufund hungary hustock iexcloud indiamutual
   known_currencies lerevenu maninv morningstar morningstarau
   morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania
   seb_funds sixfunds sixshares stockhousecanada_fund tdefunds
   tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp
   tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd
   yahoo_json yahoo_yql za za_unittrusts)
   * 10:13:33 MESSG  Found Finance::Quote version 1.49
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:31 DEBUG  ALPHAVANTAGE_API_KEY=7HZ0P6PV6VC2GODA
   * 10:15:31 DEBUG  handling-request: (currency USD GBP)
   * 10:15:31 DEBUG  results: #
   * 10:15:31 DEBUG  handling-request: (currency EUR GBP)
   * 10:15:31 ERROR  There was a system error while retrieving
   the price quotes.
   * 10:15:37 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:37 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   On 15 August 2020 19:20 John Ralls < [1]jra...@ceridwen.us> wrote:

   Samantha,

   Run GnuCash from Powershell as you did before:

   & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug

   (The last time the command was & 'C:\Program Files
   (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that
   last command, --nofile, tells GnuCash to not open the previous data
   file. Last time I didn't need to see anything from a data file and
   starting GnuCash without one is faster. This time I do want you to have
   access to your data file.)

   This time edit an exchange rate on an existing multi-currency
   transaction and use the Fetch Rate button to attempt to get an online
   quote. Dismiss the error dialog, cancel the edit, and quit GnuCash.

   Then list the log files

   Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter
   gnucash.trace.* | Sort-Object -Property Date

   figure out which is the latest one (the guidance about that is still at
   the bottom of the quoted text in this message if you've forgotten)

   Display the contents

   Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   (That's the file

[GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

Re: [GNC] mysql gnucash

Re: [GNC] help increasing size of font in GnuCash?

[GNC] mysql gnucash

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] gnucash-user Digest, Vol 209, Issue 49

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] gnucash-user Digest, Vol 209, Issue 49

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] Get quote - online price retrieval

Re: [GNC] Get quote - online price retrieval

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] help increasing size of font in GnuCash?

Re: [GNC] Difficulty with online price retrieval

18 matches

Site Navigation

Mail list logo

Footer information