manual load of yahoo quotes via spreadsheet

[santer]

Is there a way to manually update stock quotes via spreadsheet?  I can
download a spreadsheet of quotes from yahoo, which I'd like to load to
gnucash.



--
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: Getting started

[Adrien Monteleone]

I’ll also chime in with the following tips:

The TL;DR is that unlike most other software, you are likely to only use ONE 
file with GnuCash. And so, you don’t need to open the file directly as you 
would with other software. Instead, open GnuCash and it will load your data 
file wherever it may reside, and short of including that file location in a 
backup software preference for reliability’s sake, you probably don’t even need 
to care where it actually is.(as long as it is somewhere other than the desktop)

-

You can tweak how many log files are retained by checking in the preferences > 
general tab, option for Retain Log Files. You can choose ’never’, ‘forever’, or 
‘x # of days’, with the default being 30.

Certainly, you should NOT set your DESKTOP to be the default storage location 
of your GnuCash file (or likely any other file, but that’s another topic, 
wholly unrelated to GnuCash)

You CAN do so of course, but as you noticed, one should be prepared for a 
plethora of log files in the same place.

Probably, it would be nice if the software suggested some other alternative, or 
clearly discouraged the user from using the desktop as a default storage 
location with clear and understandable warnings. This has been a mailing list 
topic enough times that such an approach might be a time saver.

Most people in my experience choose the desktop to store things because they 
simply can’t, or are scare, to navigate a single layer of folders. (but somehow 
magically manage to do so FROM THE DESKTOP) But anyway, GnuCash is polite and 
thoughtful enough to not make you need to open the file directly. You don’t 
NEED to store it’s data file on the desktop. It lets you open the software 
first, and it will dutifully open the last used file by default, which for 
probably the super-majority of users, is a pretty sane choice. (the rest of us 
know how to open other files instead, or at the same time)

Regards,
Adrien

> On Mar 31, 2018, at 6:27 PM, Kevin Reid  wrote:
> 
> On Sat, Mar 31, 2018 at 1:40 PM, Jonathan Ames  wrote:
> 
>> I have asked these questions previously, but haven’t understood the
>> answers. I have basically no experience with non-commercial software,
>> and/or may be otherwise unworthy to use Gnucash.
>> 
>> - I want to use Gnucash for both personal and business purposes. I am
>> typing now on Mac/Sierra; I am wondering if I can access the same Gnucash
>> accounts from my Windows 10 computer at my office, assuming program is
>> placed in cloud (e.g., iCloud, Google Drive). Not simultaneously, though
>> perhaps several times/day from each. To date, the windows computer comes
>> back with 'file not found’, though I’ve installed on both.
>> 
> 
> It doesn't matter where the program is installed. GnuCash's data is treated
> as a document — you get to choose where to save it. Save it to a folder
> that's synced with your cloud storage, then on the other computer open it
> from that location.
> 
> 
> - I started setting up on the Mac — and generated a huge number of log
>> files; … They are covering my (Mac) desktop, and/or spreading like wildfire
>> in ‘All My Files’. Is this the price one pays for free software — i.e.,
>> having to constantly clean up?
> 
> 
> The log files are there as part of GnuCash's backups in case the main file
> is damaged or the program crashes. GnuCash will automatically delete old
> ones so they won't accumulate forever. But you should, when you save your
> file, *save it in a folder you create just for GnuCash*, so that you don't
> have to look at them on your desktop or anywhere.
> 
> (To get them out of All My Files, you'll have to go to your *System
> Preferences → Spotlight → Privacy* and add that folder to the list of
> exclusions. I think that should work, anyway — I haven't tried that.)
> 
> What you should do to clean up now is: quit GnuCash, find the main file
> (the one with the shortest name) on your desktop (or just select all of
> them), move it into a *new empty folder for the purpose* in your
> cloud-synced folder, then launch GnuCash (it will not find the file because
> you moved it), and select *File → Open* and open the file from the new
> location you moved it to.
> 
> 
> 
>> Also, are these files important to save, or can they be deleted?
> 
> 
> They can be deleted, but if something else goes wrong at the same time you
> have fewer options for recovery. GnuCash will delete older files
> automatically.
> 
> 
> Samples below.
>> 
> 
> Be warned that by sending these files you have shared some of your
> financial information — the log files contain transactions you have entered.
> ___
> 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 C

Re: Getting started

[DaveC49]

Johnathon,

Just to amplify a little bit on Kevin's answers. If you are opening a file
generated at home using Gnucash on your home computer, the copy of Gnucash
running on your work computer cannot know where your files are located until
it is has opened a file for the first time. You have to use file open to
connect to the copy of the file in yourGoogleDrive/Dropbox/iCloud etc. Once
you have opened the file and saved to that location or even just closed it
again, Gnucash should remember that location in future. 

A lot of commercial software takes decisions away from you by default to
simplify use for new users. Those decisions can usually be overridden by
changing the options or Preferences and Gnucash is no exception. Gnucash by
default creates a new file in either the folder/directory which was last
opened in Gnucash or in the case of an initial startup usually in the user's
home directory or whatever it is called by the various operating systems
(Linux/OSX-MacOS/Windows etc).  

The FAQs on the wiki ( https://wiki.gnucash.org/wiki/GnuCash
  ) and the documentation (Help
manual  https://www.gnucash.org/docs/v2.6/C/gnucash-help/help.html
   and the
Tutorial and Concpts guide (
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/
   are the best places
to start but for very specific questions searching the archives can also
help but older information in the archives can sometimes be out of date.

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: Getting started

[Kevin Reid]

On Sat, Mar 31, 2018 at 1:40 PM, Jonathan Ames  wrote:

> I have asked these questions previously, but haven’t understood the
> answers. I have basically no experience with non-commercial software,
> and/or may be otherwise unworthy to use Gnucash.
>
> - I want to use Gnucash for both personal and business purposes. I am
> typing now on Mac/Sierra; I am wondering if I can access the same Gnucash
> accounts from my Windows 10 computer at my office, assuming program is
> placed in cloud (e.g., iCloud, Google Drive). Not simultaneously, though
> perhaps several times/day from each. To date, the windows computer comes
> back with 'file not found’, though I’ve installed on both.
>

It doesn't matter where the program is installed. GnuCash's data is treated
as a document — you get to choose where to save it. Save it to a folder
that's synced with your cloud storage, then on the other computer open it
from that location.


- I started setting up on the Mac — and generated a huge number of log
> files; … They are covering my (Mac) desktop, and/or spreading like wildfire
> in ‘All My Files’. Is this the price one pays for free software — i.e.,
> having to constantly clean up?


The log files are there as part of GnuCash's backups in case the main file
is damaged or the program crashes. GnuCash will automatically delete old
ones so they won't accumulate forever. But you should, when you save your
file, *save it in a folder you create just for GnuCash*, so that you don't
have to look at them on your desktop or anywhere.

(To get them out of All My Files, you'll have to go to your *System
Preferences → Spotlight → Privacy* and add that folder to the list of
exclusions. I think that should work, anyway — I haven't tried that.)

What you should do to clean up now is: quit GnuCash, find the main file
(the one with the shortest name) on your desktop (or just select all of
them), move it into a *new empty folder for the purpose* in your
cloud-synced folder, then launch GnuCash (it will not find the file because
you moved it), and select *File → Open* and open the file from the new
location you moved it to.



> Also, are these files important to save, or can they be deleted?


They can be deleted, but if something else goes wrong at the same time you
have fewer options for recovery. GnuCash will delete older files
automatically.


Samples below.
>

Be warned that by sending these files you have shared some of your
financial information — the log files contain transactions you have entered.
___
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: Transferring data from Quicken Home and Business 2007

[Kenneth Schneider]

You’ll need to tell us a little of what you have tried so we can help further. 
Exporting Quicken data to QIF format will work the best. One difference between 
Quicken and GNU-cash is the categories in Quicken are accounts GC. When you 
export your data make sure you also export all of the categories that you use.

Ken Schneider 

> On Mar 31, 2018, at 7:10 AM, Paul Flanagan  wrote:
> 
> I have installed GnuCash and have attempted to transfer data from Quicken
> and I am unable to carry this out.
> Thank you,
> Paul Flanagan.
> ___
> 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: Price Editor/Database lag

[farleykj]

You don't necessarily have to update manually. The original Yahoo source has
been ruined, but you can (and I do) use "yahoo_json" as a source. It's
worked fine for me.
As for your actual question, I'm sorry but I've no idea. I'm running on Mac
OSX. People might have some inquiries about the particulars of your setup,
like are you using the XML interface, or SQL? If the latter, maybe there's
something odd going on with the database server? Is your database
particularly large?



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

Getting started

[Jonathan Ames]

I have asked these questions previously, but haven’t understood the answers. I 
have basically no experience with non-commercial software,
and/or may be otherwise unworthy to use Gnucash.

- I want to use Gnucash for both personal and business purposes. I am typing 
now on Mac/Sierra; I am wondering if I can access the same Gnucash accounts 
from my Windows 10 computer at my office, assuming program is placed in cloud 
(e.g., iCloud, Google Drive). Not simultaneously, though perhaps several 
times/day from each. To date, the windows computer comes back with 'file not 
found’, though I’ve installed on both.

- I started setting up on the Mac — and generated a huge number of log files; 
disposal of which seems to require IT savvy beyond what is needed for Quicken, 
YNAB, et al. (despite the ease of use assurances). It appears the commercial 
programs either don’t generate them, or hide them in a log folder. They are 
covering my (Mac) desktop, and/or spreading like wildfire in ‘All My Files’. Is 
this the price one pays for free software — i.e., having to constantly clean 
up? Also, are these files important to save, or can they be deleted? Samples 
below.




Gnucash 170715.gnucash.20180310190300.log
Description: Binary data


Whatnow Connect 180207.gnucash.20180211145646.log
Description: Binary data


Gnucash 170715.gnucash.20180318114241.log
Description: Binary data


Gnucash 170715.gnucash.20180318113929.log
Description: Binary data


Gnucash 170715.gnucash.20180318113818.log
Description: Binary data


Gnucash 170715.gnucash.20180317232102.log
Description: Binary data


These were generated by repeated attempts to work with Gnucash. The learning 
curve seems to be:

1. Data is organized information.
2. Data can be letters or numbers.
3. To propagate the bilateral asymmetry along the sequence, one simply 
factor-analyzes the cosign of the tertiary
 radicals appearing within the Fibonacci Sequence generated by the Grunt 
Imperative Command (GIC) 

- get my point?

Any help appreciated — again. Again, 1. Non-simultaneous access by several 
computers/OS with the application placed in cloud’ 2. Understanding & Dealing 
with excess files generated by simple operations.

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

Transferring data from Quicken Home and Business 2007

[Paul Flanagan]

I have installed GnuCash and have attempted to transfer data from Quicken
and I am unable to carry this out.
Thank you,
Paul Flanagan.
___
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.

Price Editor/Database lag

[David G. Pickett]

Now that I am manually updating my stocks monthly, thanks, Yahoo, I find 
that as I pull up the price history to clone a new month end entry for 
the symbol, I get a _*long (30 second) gray out delay*_ (on Linux, and 
not the newest PC) at some point in the cycle, like a premature auto 
save or something.  This makes the process detestibly slow, 40 seconds a 
symbol!  Any suggestions?


___
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: Reports are displayed as HTML text rather than being rendered

[John Ralls]

> On Mar 31, 2018, at 11:18 AM, Thomas Levine <_...@thomaslevine.com> wrote:
> 
> We have managed to package GNUCash in Nix such that reports are rendered
> as text rather than HTML. That is, the HTML source code is displayed as
> text rather than as rendered tables and lines and styled text.
> https://github.com/NixOS/nixpkgs/issues/14105
> 
> Does anyone have ideas of what we have done wrong?

I'd have to guess that you're not getting webkit properly integrated or that 
there's something wrong with the webkit build. Start by looking closely at the 
build output for libgncmodule-html.

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.

Reports are displayed as HTML text rather than being rendered

[Thomas Levine]

We have managed to package GNUCash in Nix such that reports are rendered
as text rather than HTML. That is, the HTML source code is displayed as
text rather than as rendered tables and lines and styled text.
https://github.com/NixOS/nixpkgs/issues/14105

Does anyone have ideas of what we have done wrong?

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

Issue after beta testing in Windows?

[David Carlson]

Some time ago I installed and tested release 2.7.3 on my Windows 7 machine,
then I re-installed release 2.6.18 which I had previously been using.

Later on I started experiencing a crash every few days.  After further
attempts to establish what was triggering the crashes, I was not seeing any
pattern other than only GnuCash crashed and none of my other programs did.

Then I noticed that none of the Help buttons distributed around the program
could find and open the Tutorial or the Contents files.  F1 did not work
either.

I am now fairly certain that there was some sort of GTK something left
laying around after reverting back to 2.6.18.  Upgrading to release 2.6.19
did not stop the crashing.

I temporarily created a new user in this machine and found that the new
user could run Gnucash and read the help files.

1. Is anyone else seeing similar strange behavior?

2. If this is the issue, it must be somewhere other than in the GnuCash
program folder or my User Gnucash settings folder does anyone have a
suggestion where to look next?

3.  Is it possible that the best option would be to simply wait for release
3.0 oon this machine?

4.  I have various instances of releases 2.6.something on other machines,
but it seems each one has one issue or another such as not being able to
access the network file server or network printer or whatever.  When I do
switch to release 3.0 they will all need to be abandoned or upgraded, so I
will need to go slowly to avoid shooting myself in the foot again.

Thanks for reading this.

David C
___
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: Fast reactions to 2.7.8

[Adrien Monteleone]

That’s certainly a thorough run-down on changing themes.

But is there a way to edit a theme to make the button label visible? I see one 
could download a theme and go through all that trouble, only to find out the 
theme is hiding the labels. That could turn into quite a trial and error 
process and certainly result in having to choose a less desirable theme, just 
to have a label on a button.

On that note, is having a label on a button not done in the UI code? Looking at 
the button reference I see each one would need both an icon and a label or 
mnemonic label. I suppose the theme could choose or not to show the label, but 
it would have to be programmed in first. If all of those toolbar buttons are 
icons only...

(sorry, I haven’t taken a look at the code yet)

I would then suspect that in order for GnuCash to offer a toggle, it would have 
to at the least, branch the code on that preference to display buttons with or 
without labels, and then the question, “Are the labels are visible?” would 
depend on the user’s GTK theme. It appears the GTK devs either didn’t think 
this one through, or they are trying to enforce a certain look. Or maybe they 
can’t be made invisible by the theme at all, and this is entirely decided in UI 
code.

Regards,
Adrien

> On Mar 31, 2018, at 7:37 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
>> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
>> interface where you have to hover over every single icon until you can find
>> the one you want.
>> 
>> Many programs offer "words only", "icons only", and "icons and words" as
>> choices. I couldn't find anything like that. Please add it.
>> 
>> (2) At first I thought performance was horrendously slow, when I was
>> entering transactions in the general ledger. Turns out the actual issue was
>> that the Tab key, instead of advancing to the next field, just gave focus
>> to the "Save" button at upper left. This was on windows 8, with Build ID:
>> git 2.7.8+ (2018-03-25).
> 
> A more general note. I have done some experimentation about what can be done 
> to tweak the gnucash user interface in the absence of the Theme selector we 
> used to have for gnucash 2.x (that was removed from gtk for gtk3, not 
> something gnucash had any say in).
> 
> It turns out that apart from really starting to customize css settings one 
> can 
> also install custom themes. It's still a bit of manual work but it's much 
> less 
> complicated than looking for individual settings. What follows can be used as 
> a basis to document this on the gui tweak wiki page.
> 
> Note this custom theme will affect all gtk3 based applications on your system!
> 
> Short summary:
> 1. Download an appropriate gtk3 theme from www.gnome-look.org
> 2. Install the theme in a directory where gtk3 looks for themes
> 3. create or adjust a settings.ini file to tell gtk3 to use this theme
> 
> Slightly longer with platform dependent remarks:
> 
> 
> 1. Go to the gnome-look.org website
> 2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
> 3. Select a theme you like
> Alternatively you can search for keywords (like "dark") in the top right 
> corner and then filter on "Gtk3 Theme category"
> 4. If you have found a theme you like, download the proper file (in the files 
> section of the theme page).
> 
> Note depending on your operating system you may not be able to open all theme 
> files. I have seen for example .deb archives which are specifically targeted 
> at the Debian linux distribution and derivates such as Ubuntu. While Ubuntu 
> and Debian users can install those themes via their package manager these 
> themes are not useful for other platforms.
> Theme files ending with .zip, .tar.gz or tar.xz are likely installable on all 
> platforms, although you may have to find a proper application to extract 
> them. 
> On Windows 7-Zip is a good candiate,  linux users can probably extract the 
> files directly from their file manager.
> 
> So...
> Let's take the theme "Eye-friendly Dark RBC" as an example (it's not the best 
> theme but it can serve as an example). The file to download is "Eye-friendly-
> Dark-RBC.tar.gz"
> 
> 5. Extract this file using an appropriate tool. This  should give you a 
> directory named "Eye-friendly-Dark-RBC"
> 
> 6. Move this directory to a location on your system that's parsed by gtk. 
> This 
> is platform dependent:
> - Linux: $HOME/.local/share/themes/
> - OS X: Here I'm not sure. Possibly
>$HOME/.local/share/themes/ (like on linux)
>  or  $HOME/Library/Application Support/themes/
>  I suspect the first unless one overrides the XDG_DATA_HOME environment
>  variable
> - Windows: %LOCALAPPDATA%\themes\
> 
> 7. Next tell gtk to load this theme.
> Linux users can probably most easily do this by install the "Gnome Tweak 
> Tool" 
> on their platform and select the new theme there.
> 
> The manual method is this:
> Create a file named "settings.ini" in the appro

Re: Reconciliation problems

[EngineInstitute]

Colin,
Thanks for the quick response. 
I guess I wasn't careful enough because in checking the saved reconciliation
I noticed that it was out of balance even though I thought I put in the
right ending balance.
I just started the reconciliation again clearing everything. Now it works
fine. 
Lesson is don't try to do bookkeeping fast...
Thanks a ton.  



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

User interface tweaks (was Fast reactions to 2.7.8)

[Stan Brown]

Thank you, Geert.

Should this invitation maybe go in the Wiki, or the help file?

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com


On 2018-03-31 08:37, Geert Janssens wrote:
> 
> A more general note. I have done some experimentation about what can be done 
> to tweak the gnucash user interface in the absence of the Theme selector we 
> used to have for gnucash 2.x (that was removed from gtk for gtk3, not 
> something gnucash had any say in).
> 
> It turns out that apart from really starting to customize css settings one 
> can 
> also install custom themes. It's still a bit of manual work but it's much 
> less 
> complicated than looking for individual settings. What follows can be used as 
> a basis to document this on the gui tweak wiki page.
> 
> Note this custom theme will affect all gtk3 based applications on your system!
> 
> Short summary:
> 1. Download an appropriate gtk3 theme from www.gnome-look.org
> 2. Install the theme in a directory where gtk3 looks for themes
> 3. create or adjust a settings.ini file to tell gtk3 to use this theme
> 
> Slightly longer with platform dependent remarks:
> 
> 
> 1. Go to the gnome-look.org website
> 2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
> 3. Select a theme you like
> Alternatively you can search for keywords (like "dark") in the top right 
> corner and then filter on "Gtk3 Theme category"
> 4. If you have found a theme you like, download the proper file (in the files 
> section of the theme page).
> 
> Note depending on your operating system you may not be able to open all theme 
> files. I have seen for example .deb archives which are specifically targeted 
> at the Debian linux distribution and derivates such as Ubuntu. While Ubuntu 
> and Debian users can install those themes via their package manager these 
> themes are not useful for other platforms.
> Theme files ending with .zip, .tar.gz or tar.xz are likely installable on all 
> platforms, although you may have to find a proper application to extract 
> them. 
> On Windows 7-Zip is a good candiate,  linux users can probably extract the 
> files directly from their file manager.
> 
> So...
> Let's take the theme "Eye-friendly Dark RBC" as an example (it's not the best 
> theme but it can serve as an example). The file to download is "Eye-friendly-
> Dark-RBC.tar.gz"
> 
> 5. Extract this file using an appropriate tool. This  should give you a 
> directory named "Eye-friendly-Dark-RBC"
> 
> 6. Move this directory to a location on your system that's parsed by gtk. 
> This 
> is platform dependent:
> - Linux: $HOME/.local/share/themes/
> - OS X: Here I'm not sure. Possibly
> $HOME/.local/share/themes/ (like on linux)
>   or  $HOME/Library/Application Support/themes/
>   I suspect the first unless one overrides the XDG_DATA_HOME environment
>   variable
> - Windows: %LOCALAPPDATA%\themes\
> 
> 7. Next tell gtk to load this theme.
> Linux users can probably most easily do this by install the "Gnome Tweak 
> Tool" 
> on their platform and select the new theme there.
> 
> The manual method is this:
> Create a file named "settings.ini" in the appropriate location. Again this 
> depends on your platform:
> - Linux: $HOME/.config/gtk-3.0/
> - OS X: Again I'm not sure. Possibly
> $HOME/.config/gtk-3.0/ (like on linux)
>   or  $HOME/Library/Application Support/Gnucash/config/gtk-3.0
>   I suspect the latter in this case because gnucash overrides the
>   XDG_CONFIG_HOME environment variable on OS X
> - Windows: %LOCALAPPDATA%\gtk-3.0\
> 
> The contents of this file should be
> 
> [Settings]
> gtk-theme-name=Eye-friendly-Dark-RBC
> 
> And that's it. Note the name is the name of the directory as you put in the 
> themes directory.
> 
> The next time you start gnucash it should pick up this theme.
> 
> A few extra notes:
> * The default gtk3 theme is called "Adwaita"
> * On linux there's a second default theme called "Adwaita-dark" which should 
> also give you a dark themed gnucash. Unfortunately this doesn't work on 
> Windows. I suppose it's not included or improperly configured there ? On OS X 
> I haven't tried this.
> * If you're adventurous you can probably also play with customized icon 
> themes 
> which you find on the gnome-look.org website. These themes should be 
> installed 
> in the icons directory next ot the themese directory. And to activate them 
> you 
> can add gtk-icon-theme-name= in settings.ini.
> * Another setting some of you will be interested in is
> gtk-font-name=
> for example
> gtk-font-name=Abyssinica SIL Regular 10
> * More gtk settings one can override can be found here:
> https://developer.gnome.org/gtk3/stable/GtkSettings.html
> 
> Regards,
> 
> Geert
> 
> 
___
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 N

Re: Reconciliation problems

[Colin Law]

On 31 March 2018 at 13:53, EngineInstitute  wrote:

> I am often in the position where I have fallen behind on posting credit
> cards
> to the bank account although the bank account is reconciled. I am trying to
> catch up on this now. The problem is as I am trying to reconcile per month
> I
> am not able to finish that month for the credit card in hand because there
> are payments credited the account for later periods.
>

Can you explain in more detail why you cannot reconcile it?  Payments
credited after the date you are reconciling to should not be a problem.
Just don't tick them off in the reconcile window. Can I just check that
when you start the reconcile you check that the starting balance in the
initial reconcile window matches the opening balance on the statement (if
it doesn't then the previous reconcile has  a problem) and that you enter
the ending balance as it is on the statement?

Colin


>
> I have been able to reconcile in the past in this scenario but not this
> time. Does anyone have a recommendation on how to progress?
>
> Thanks.
>
>
>
> -
> China Blue
> --
> 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.

Reconciliation problems

[EngineInstitute]

I am often in the position where I have fallen behind on posting credit cards
to the bank account although the bank account is reconciled. I am trying to
catch up on this now. The problem is as I am trying to reconcile per month I
am not able to finish that month for the credit card in hand because there
are payments credited the account for later periods. 

I have been able to reconcile in the past in this scenario but not this
time. Does anyone have a recommendation on how to progress?

Thanks.



-
China Blue
--
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: Fast reactions to 2.7.8

[Geert Janssens]

Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
> interface where you have to hover over every single icon until you can find
> the one you want.
> 
> Many programs offer "words only", "icons only", and "icons and words" as
> choices. I couldn't find anything like that. Please add it.
> 
> (2) At first I thought performance was horrendously slow, when I was
> entering transactions in the general ledger. Turns out the actual issue was
> that the Tab key, instead of advancing to the next field, just gave focus
> to the "Save" button at upper left. This was on windows 8, with Build ID:
> git 2.7.8+ (2018-03-25).

A more general note. I have done some experimentation about what can be done 
to tweak the gnucash user interface in the absence of the Theme selector we 
used to have for gnucash 2.x (that was removed from gtk for gtk3, not 
something gnucash had any say in).

It turns out that apart from really starting to customize css settings one can 
also install custom themes. It's still a bit of manual work but it's much less 
complicated than looking for individual settings. What follows can be used as 
a basis to document this on the gui tweak wiki page.

Note this custom theme will affect all gtk3 based applications on your system!

Short summary:
1. Download an appropriate gtk3 theme from www.gnome-look.org
2. Install the theme in a directory where gtk3 looks for themes
3. create or adjust a settings.ini file to tell gtk3 to use this theme

Slightly longer with platform dependent remarks:


1. Go to the gnome-look.org website
2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
3. Select a theme you like
Alternatively you can search for keywords (like "dark") in the top right 
corner and then filter on "Gtk3 Theme category"
4. If you have found a theme you like, download the proper file (in the files 
section of the theme page).

Note depending on your operating system you may not be able to open all theme 
files. I have seen for example .deb archives which are specifically targeted 
at the Debian linux distribution and derivates such as Ubuntu. While Ubuntu 
and Debian users can install those themes via their package manager these 
themes are not useful for other platforms.
Theme files ending with .zip, .tar.gz or tar.xz are likely installable on all 
platforms, although you may have to find a proper application to extract them. 
On Windows 7-Zip is a good candiate,  linux users can probably extract the 
files directly from their file manager.

So...
Let's take the theme "Eye-friendly Dark RBC" as an example (it's not the best 
theme but it can serve as an example). The file to download is "Eye-friendly-
Dark-RBC.tar.gz"

5. Extract this file using an appropriate tool. This  should give you a 
directory named "Eye-friendly-Dark-RBC"

6. Move this directory to a location on your system that's parsed by gtk. This 
is platform dependent:
- Linux: $HOME/.local/share/themes/
- OS X: Here I'm not sure. Possibly
$HOME/.local/share/themes/ (like on linux)
  or  $HOME/Library/Application Support/themes/
  I suspect the first unless one overrides the XDG_DATA_HOME environment
  variable
- Windows: %LOCALAPPDATA%\themes\

7. Next tell gtk to load this theme.
Linux users can probably most easily do this by install the "Gnome Tweak Tool" 
on their platform and select the new theme there.

The manual method is this:
Create a file named "settings.ini" in the appropriate location. Again this 
depends on your platform:
- Linux: $HOME/.config/gtk-3.0/
- OS X: Again I'm not sure. Possibly
$HOME/.config/gtk-3.0/ (like on linux)
  or  $HOME/Library/Application Support/Gnucash/config/gtk-3.0
  I suspect the latter in this case because gnucash overrides the
  XDG_CONFIG_HOME environment variable on OS X
- Windows: %LOCALAPPDATA%\gtk-3.0\

The contents of this file should be

[Settings]
gtk-theme-name=Eye-friendly-Dark-RBC

And that's it. Note the name is the name of the directory as you put in the 
themes directory.

The next time you start gnucash it should pick up this theme.

A few extra notes:
* The default gtk3 theme is called "Adwaita"
* On linux there's a second default theme called "Adwaita-dark" which should 
also give you a dark themed gnucash. Unfortunately this doesn't work on 
Windows. I suppose it's not included or improperly configured there ? On OS X 
I haven't tried this.
* If you're adventurous you can probably also play with customized icon themes 
which you find on the gnome-look.org website. These themes should be installed 
in the icons directory next ot the themese directory. And to activate them you 
can add gtk-icon-theme-name= in settings.ini.
* Another setting some of you will be interested in is
gtk-font-name=
for example
gtk-font-name=Abyssinica SIL Regular 10
* More gtk settings one can override can be found here:
https://developer.gnome.org/gtk3/stable/GtkSettings.html

Regards,

Gee

Re: Fast reactions to 2.7.8

[Geert Janssens]

Op dinsdag 27 maart 2018 21:53:57 CEST schreef AC:
> On 2018-03-27 11:15, Geert Janssens wrote:
> > Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
> >> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
> >> interface where you have to hover over every single icon until you can
> >> find
> >> the one you want.
> > 
> > Not a fan of _hate_ (stress markers included) statements...
> > 
> >> Many programs offer "words only", "icons only", and "icons and words" as
> >> choices. I couldn't find anything like that. Please add it.
> > 
> > It used to be there in the 2.4 series. I have removed it for 2.6 and up
> > because I don't think this should be an application level setting. It
> > should be a system level preference and in addition is strongly
> > influenced by the human interface guidelines on that platform.
> 
> This isn't always an OS level item.  It really depends on the complexity
> of the software.  For example, the mainstream browsers are capable of
> switching modes for the buttons/text for themselves.  LibreOffice is
> similar, you can customize the toolbars with icon, text or both.
> 
> For some OSes, the window manager does not have this kind of control at
> all (e.g.  Windows) so it makes no sense to query the OS for a
> preference that doesn't exist.

Some further investigation shows gtk has dropped support for tweaking this on 
the user level :(
So this will need some design from the gnucash developers to come up with an 
acceptable solution. Until someone picks this up the buttons are as you see 
them now unfortunately.

Geert


___
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: Running Reports over a Windows 10 Network

[Maf. King]

On Friday, 30 March 2018 11:45:45 BST Alan Culpitt via gnucash-user wrote:
> I am using GNUCash 2.6.19 on 2x Windows 10 PCs networked together to access
> our joint financial information stored on my wife's computer.  We have a
> number of saved reports.   If I try to run one of the saved reports it
> takes a very long time to run, 10-15 minutes, the first time but then
> subsequently if I run another report, it works fine. Any suggestions?
> 


Hi Alan,

There have been previous posts about the first report taking ages to render on 
Windows.  I don't use that OS and can't remember if there is a solution yet, 
but I don't think it is related to your file being on a network share.

Just thought I'd chime in to let you know that you are not alone!

Maf.

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