Re: [GNC] Bar chart reports

2019-07-27 Thread D via gnucash-user
John,

The chart reports include an option on the Display tab, Show table, which will 
include the data table. Checking that option displays the data upon which the 
chart is built. Then you can copy and paste those data directly into your 
spreadsheet.

David

On July 27, 2019, at 2:15 AM, John Griessen  wrote:

On 7/26/19 10:42 AM, Adrien Monteleone wrote:
> The quickest path to a custom chart is to run the report to get the data you 
> want, and then copy/paste to a spreadsheet and use the charting features 
> there. I think most if not all charts in GnuCash have an option to include a 
> data table that you can use as well.

OK.  How about scripting this?  Has anyone made a bash script to generate a 
data report, then
process it into a chart, and save to a file?

When you say "include a data table" I'm lost.  It would not be part of a chart, 
so included in what?
Generating a data table, (which to me means name:value pairs from an expense 
report would be great.  I could bar chart it with any 
tool.   I don't need the structure of the account levels in gnucash, just 
choosing which accounts, (or placeholdler aggregating 
accounts) to bar-chart, then being able to set the appearance details in an 
outside program is all I am wanting.
___
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] Concern with the lengthy list of "Known Issues"

2019-07-27 Thread John Ralls
The distros didn't kill off Gtk2, that's still there. They stopped supporting 
WebKit1Gtk, and WebKit2Gtk supports only Gtk3 so we had to migrate to Gtk3 or 
get booted from distros.

Regards,
John Ralls


> On Jul 27, 2019, at 3:18 AM, Christopher Lam  
> wrote:
> 
> I think the UI upgrades have been an unfortunate but necessary consequence
> of many Linux distributions deciding to kill GTK2 and all GTK2- based apps.
> If jralls or gjanssens haven't spent countless hours upgrading components
> then GnuCash would have been dropped from all major distributions.
> 
> Most UI issues *can* be tweaked via CSS -- as everything here is
> opensource, users are encouraged to dive in and amend to their liking.
> 
> Finally the list of issues bein long; apart from the GTK3 preferences  I
> believe most of the "new" known issues in 3.x were also present, but
> undocumented in 2.x.
> 
> On Mon, 22 Jul 2019 at 20:10, Christoph R 
> wrote:
> 
>> Hi,
>> 
>> I am using gnucash since 2004 for multiple accounts and have my whole
>> personal history since then in one file. I am running gnucash on MacOs in
>> German which is somewhat special and the only dev for MacOs is John. Thanks
>> to him for all the work putting he is putting in! I was a pretty happy user
>> up until 3.0.
>> 
>> But with the 3.x series there are more problems than I am used to and
>> progress is very slow. The only version working for me so far is 3.5, which
>> is my production version for now. Versions before crashed or failed on
>> important operations (like the csv importer, which is the main reason I am
>> using 3.x). 3.6 apparently has a stray ifdef on MacOs which makes the
>> program always fall back to English. So I am back to 3.5.
>> 
>> And the release cycle is pretty long. So even when bugs are fixed it takes
>> a lot of time to get them in a stable build.
>> 
>> As much as I am proponent of using the latest software versions: with
>> gnucash 3.x I cannot wholeheartedly
>> recommend it. The good thing though is that you can try and go back. The
>> latest 2.x version reads 3.x files. And switching between 3.x versions back
>> and forth works too.
>> 
>> Cheers,
>> Christoph
>> 
>>> Am 21.07.2019 um 19:31 schrieb scotts :
>>> 
>>> I have been using Gnucash for about 3 years now, and for the most part
>>> enjoying the experience! I use it for my personal finances (bank
>> accounts,
>>> credit cards, investments, etc). I am also the treasurer of a golf club
>>> association and am considering moving their accounting over to Gnucash.
>>> 
>>> I am currently using Windows version 2.6.21. Of course at the moment, the
>>> most current stable release is version 3.6. My only hesitation in
>> upgrading
>>> is what seems to me to be a very long list of "known issues" with the
>>> release.
>>> 
>>> I'm looking for other opinions. In my experience, version 2.6.21 seems to
>>> pretty much work as advertised. No crashes, runs quickly enough on my
>>> computer, all the functions I've tried seem to work fine. Normally I
>> would
>>> upgrade any software to the latest release, hopefully taking advantage of
>>> bug fixes and new features. But when I see the long list of issues, I
>>> hesitate.
>>> 
>>> Would appreciate any comments from others. Am I being overly paranoid?
>>> Thanks a lot!
>>> 
>>> 
>>> 
>>> --
>>> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] Report - How to track savings?

2019-07-27 Thread Michael Hendry
> On 27 Jul 2019, at 10:49, Christopher Lam  wrote:
> 
> Try the Cash-Flow report, select your savings as the source account.


This will pick up all transactions between your savings account and any other 
account, in either direction.

If you want to see only transactions between CHECKING and SAVING you can try:

1. Open the SAVINGS account.
2. Press cmd-F (on Mac) or ctrl-F otherwise to bring up the “Find Transaction” 
Window.
3. Click and hold the Description button, and run the mouse down to select “All 
Accounts’.
4. Click the "Choose Accounts” button
5. Select your Checking Account.
6. Click “Find”.

This will bring up a new tab entitled “Search Results”, which contains all 
transactions between your Savings and Checking Accounts.

But I haven’t been able to work out a way of presenting this in a bar chart - 
it’s a wet Saturday morning here, so maybe later...

You can get a report on the transactions identified by your search by using the 
Reports Menu:

Reports—>Accounts Report

…but this is in text, not graphical form.

Michael

> 

> On Sat, 27 Jul 2019 at 08:43, Michael Scholz Photography <
> mich...@scholzphotography.com> wrote:
> 
>> I'm new to GNC and try to understand how the reports work.
>> 
>> Is there a way to set up a report to see how much money I saved into an
>> account?
>> 
>> 
>> Let’s say I want to track the money which was going from my CHECKING into
>> my SAVINGS account. Is there a way to track this on a monthly basis with
>> some bar charts?
>> 
>> 
>> 
>> THX
>> Michael
>> ___
>> 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.



___
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] Concern with the lengthy list of "Known Issues"

2019-07-27 Thread Christopher Lam
I think the UI upgrades have been an unfortunate but necessary consequence
of many Linux distributions deciding to kill GTK2 and all GTK2- based apps.
If jralls or gjanssens haven't spent countless hours upgrading components
then GnuCash would have been dropped from all major distributions.

Most UI issues *can* be tweaked via CSS -- as everything here is
opensource, users are encouraged to dive in and amend to their liking.

Finally the list of issues bein long; apart from the GTK3 preferences  I
believe most of the "new" known issues in 3.x were also present, but
undocumented in 2.x.

On Mon, 22 Jul 2019 at 20:10, Christoph R 
wrote:

> Hi,
>
> I am using gnucash since 2004 for multiple accounts and have my whole
> personal history since then in one file. I am running gnucash on MacOs in
> German which is somewhat special and the only dev for MacOs is John. Thanks
> to him for all the work putting he is putting in! I was a pretty happy user
> up until 3.0.
>
> But with the 3.x series there are more problems than I am used to and
> progress is very slow. The only version working for me so far is 3.5, which
> is my production version for now. Versions before crashed or failed on
> important operations (like the csv importer, which is the main reason I am
> using 3.x). 3.6 apparently has a stray ifdef on MacOs which makes the
> program always fall back to English. So I am back to 3.5.
>
> And the release cycle is pretty long. So even when bugs are fixed it takes
> a lot of time to get them in a stable build.
>
> As much as I am proponent of using the latest software versions: with
> gnucash 3.x I cannot wholeheartedly
> recommend it. The good thing though is that you can try and go back. The
> latest 2.x version reads 3.x files. And switching between 3.x versions back
> and forth works too.
>
> Cheers,
> Christoph
>
> > Am 21.07.2019 um 19:31 schrieb scotts :
> >
> > I have been using Gnucash for about 3 years now, and for the most part
> > enjoying the experience! I use it for my personal finances (bank
> accounts,
> > credit cards, investments, etc). I am also the treasurer of a golf club
> > association and am considering moving their accounting over to Gnucash.
> >
> > I am currently using Windows version 2.6.21. Of course at the moment, the
> > most current stable release is version 3.6. My only hesitation in
> upgrading
> > is what seems to me to be a very long list of "known issues" with the
> > release.
> >
> > I'm looking for other opinions. In my experience, version 2.6.21 seems to
> > pretty much work as advertised. No crashes, runs quickly enough on my
> > computer, all the functions I've tried seem to work fine. Normally I
> would
> > upgrade any software to the latest release, hopefully taking advantage of
> > bug fixes and new features. But when I see the long list of issues, I
> > hesitate.
> >
> > Would appreciate any comments from others. Am I being overly paranoid?
> > Thanks a lot!
> >
> >
> >
> > --
> > 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.


Re: [GNC] Report - How to track savings?

2019-07-27 Thread Christopher Lam
Try the Cash-Flow report, select your savings as the source account.

On Sat, 27 Jul 2019 at 08:43, Michael Scholz Photography <
mich...@scholzphotography.com> wrote:

> I'm new to GNC and try to understand how the reports work.
>
> Is there a way to set up a report to see how much money I saved into an
> account?
>
>
> Let’s say I want to track the money which was going from my CHECKING into
> my SAVINGS account. Is there a way to track this on a monthly basis with
> some bar charts?
>
>
>
> THX
> Michael
> ___
> 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] Report - How to track savings?

2019-07-27 Thread Michael Scholz Photography
I'm new to GNC and try to understand how the reports work. 

Is there a way to set up a report to see how much money I saved into an account?


Let’s say I want to track the money which was going from my CHECKING into my 
SAVINGS account. Is there a way to track this on a monthly basis with some bar 
charts?



THX
Michael
___
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] Concern with the lengthy list of "Known Issues"

2019-07-27 Thread Adrien Monteleone
Alan,

#1 Is a known issue for Windows. Note that on all platforms, the more tabs, 
especially reports, you have open when you last closed, the slower the app will 
be to re-launch. Also, unless you really have a need to close GnuCash, it isn’t 
strictly necessary. (Mine stays open 24/7 in its own workspace)

#2 is from the defaults picked up by the move to the updated graphics 
libraries. You can adjust the tab sizes and padding with a custom CSS file. 
Take a look at the GTK pages on the wiki for more info. Unfortunately, not 
everything is well documented for this. Some people have researched certain 
parts of the UI on this list, so you might find the tab info there. Otherwise, 
you’d need to run the GTKINSPECTOR tool, which I don’t think is available for 
Windows. (Linux and Mac only, as far as I’m aware)

I don’t think those defaults are ever going to be changed. Your only option 
would be a custom CSS file.

Regards,
Adrien

> On Jul 27, 2019, at 1:58 AM, AEG via gnucash-user  
> wrote:
> 
> Scotts,
> 
> If you still haven't updated to the latest version, I would recommend
> delaying further. My upgrade from 2.6.16 to 2.6.21 was without problems, but
> the "upgrade" from 2.6.21 to 3.5 was more like a downgrade and I'm still
> regretting it. (Windows 10)
> 
> The csv importer is better in 3.5 and allows configurations to be saved, but
> whilst there may well be other enhancements that I haven't discovered yet,
> there are a number of disappointments that affect my regular use of the
> software...
> 
> 1  The program takes a long time to load.
> 2  Tabs are much bigger. I like to have 16 of my regularly used accounts
> open at the same time and have their tabs arranged down the right hand side
> of the screen for quick access. In version 2.6 there was room for about 20
> tabs on my laptop screen but with 3.5, there is only room for 12 and
> scrolling to access the hidden tabs is not easy. Not only are the tabs
> bigger than they need to be, but there is a 2mm padding between tabs.
> 3   Scroll bars are very narrow and there are no fine adjustment arrows so I
> have to rely on dragging the bars or using the scroll wheel (when I have
> one).
> 
> I don't know whether these are known issues or deliberate changes as I
> haven't seen a list but, currently, I wish I had stayed with version 2.6.21
> 
> Alan

___
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] Concern with the lengthy list of "Known Issues"

2019-07-27 Thread AEG via gnucash-user
Scotts,

If you still haven't updated to the latest version, I would recommend
delaying further. My upgrade from 2.6.16 to 2.6.21 was without problems, but
the "upgrade" from 2.6.21 to 3.5 was more like a downgrade and I'm still
regretting it. (Windows 10)

The csv importer is better in 3.5 and allows configurations to be saved, but
whilst there may well be other enhancements that I haven't discovered yet,
there are a number of disappointments that affect my regular use of the
software...

1  The program takes a long time to load.
2  Tabs are much bigger. I like to have 16 of my regularly used accounts
open at the same time and have their tabs arranged down the right hand side
of the screen for quick access. In version 2.6 there was room for about 20
tabs on my laptop screen but with 3.5, there is only room for 12 and
scrolling to access the hidden tabs is not easy. Not only are the tabs
bigger than they need to be, but there is a 2mm padding between tabs.
3   Scroll bars are very narrow and there are no fine adjustment arrows so I
have to rely on dragging the bars or using the scroll wheel (when I have
one).

I don't know whether these are known issues or deliberate changes as I
haven't seen a list but, currently, I wish I had stayed with version 2.6.21

Alan



scotts wrote
> I have been using Gnucash for about 3 years now, and for the most part
> enjoying the experience! I use it for my personal finances (bank accounts,
> credit cards, investments, etc). I am also the treasurer of a golf club
> association and am considering moving their accounting over to Gnucash.
> 
> I am currently using Windows version 2.6.21. Of course at the moment, the
> most current stable release is version 3.6. My only hesitation in
> upgrading
> is what seems to me to be a very long list of "known issues" with the
> release.
> 
> I'm looking for other opinions. In my experience, version 2.6.21 seems to
> pretty much work as advertised. No crashes, runs quickly enough on my
> computer, all the functions I've tried seem to work fine. Normally I would
> upgrade any software to the latest release, hopefully taking advantage of
> bug fixes and new features. But when I see the long list of issues, I
> hesitate.
> 
> Would appreciate any comments from others. Am I being overly paranoid?
> Thanks a lot!





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