[GNC] (no subject)

2022-04-26 Thread Fred Tydeman
I would like to produce reports that show:
  money spent on meals, hotels, ...
  money spend on various trips

In Quicken, the transactions were coded as:
  Expense:meals/home
  Expense:meals/20210112
  Expense:hotel/20210112
  Expense:meals/20210215
  Expense:hotel/20210215
using both Categories (what) and Classes (which trip, if any).
I understand the Classes are not currently supported in gnucash.

In gnucash, I can see two ways to do the setup:
  Expense:meals:home
  Expense:meals:20210112
  Expense:hotel:20210112
  Expense:meals:20210215
  Expense:hotel:20210215
Or
  Expense:home:meals
  Expense:20210112:meals
  Expense:20210112:hotel
  Expense:20210215:meals
  Expense:20210215:hotel
But, there might be a better way.  Suggestions?

If I do either of those two setups, will I be
able to produce all the reports I want?
___
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] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread Adrien Monteleone
See my previous reply to Chris Green, and also check the Wiki. Plenty of 
users are on various backends under various OS.


Regards,
Adrien

On 4/26/22 1:36 AM, grant wrote:

So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 
but I cannot connect to mysql databases. When I click file, open there is no 
option for mysql. This is under Fedora 35Sent from my Galaxy


___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread brad

I'm not clear on what the problem is (unless you're on a Mac).
On my system (linux), In the file manager, navigate to the folder, find 
the file you want to open, and double click it.  It only opens that 
database.  What's confusing?



On 4/26/22 09:25, Chris Green wrote:

I have several gnucash accounts files (sqlite databases in my case)
spread around my system.  When I go to a specific directory and run
GnuCash I just want it to see only the database[s] in that directory.

Is there a way I can tell gnucash to forget about all previous files
it has opened?  As it is I get presented with a 'memory' of other
accounts which can be very confusing unless I'm very careful with file
naming.

The --nofile option tells gnucash not to open the last accounts
database, it helps a little, but I really want it to forget more!



___
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] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread Adrien Monteleone

It offers 4 backends:

XML (default)
SQLite
MySQL/MariaDB
PostgreSQL

You have to install the desired backend libs in most cases to be offered 
the option of using it.


The default requires no special effort.

Many Linux distros also come with SQLite support by default, so mileage 
varies.


MySQL/Maria & Postgres almost always require intentional lib 
installation and if I'm not mistaken, specific build flags.


Check the wiki for more specific and up to date info.

Regards,
Adrien

On 4/26/22 3:28 AM, Chris Green wrote:

On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote:

So I have rebuilt my laptop, recovered my databases and installed Gnucash
4.1 but I cannot connect to mysql databases. When I click file, open there
is no option for mysql. This is under Fedora 35Sent from my Galaxy


I don't believe GnuCash works with mysql (or the equivalent mariadb),
the only database storage option that I'm aware of is sqlite.



___
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] Help with GnuCash's 'help'

2022-04-26 Thread flywire
A couple of years ago
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was tested (as
external help) but there was no interest.
___
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 with GnuCash's 'help'

2022-04-26 Thread Frank H. Ellenberger
Hi Chris,

The program displaying help depends on your OS.
https://www.gnucash.org/docs/v4/C/gnucash-help/Help-Window.html

Your used version can also be relevant.

Regards
Frank

Am 26.04.22 um 17:35 schrieb Chris Green:
> Maybe I'm missing something obvious but when I search for something in
> GnuCash's help I often can't see what I've searched for.
> 
> For example I just searched for 'open account' and it returns five
> headings - but when I open one of them (for example General
> Information Tab) I can't find the string 'open account' anwhere in
> there. 
> 
___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread David T. via gnucash-user
That was exactly what I meant. As I said, it wasn't clear what your issue was. 
It sounded like you were concerned that other files showed inside the app; my 
suggestion was based on that. 

Gnucash is hard coded to open the last file. You can rewrite the code if you 
like, or you could do as another person suggested, and create shortcuts that 
explicitly open specific data files. That's not particularly complicated. 


On April 26, 2022 1:36:13 PM EDT, Chris Green  wrote:
>On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote:
>>On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
>> > I have several gnucash accounts files (sqlite databases in my case)
>> > spread around my system.  When I go to a specific directory and run
>> > GnuCash I just want it to see only the database[s] in that directory.
>> > Is there a way I can tell gnucash to forget about all previous files
>> > it has opened?  As it is I get presented with a 'memory' of other
>> > accounts which can be very confusing unless I'm very careful with file
>> > naming.
>> > The --nofile option tells gnucash not to open the last accounts
>> > database, it helps a little, but I really want it to forget more!
>> 
>>I'm not certain what has you confused, but if you need each file to
>>have its own existence, you might have to create separate OS logins for
>>each.
>> 
>Seriously?!  Do you really mean that I should create a different user
>for each GnuCash account?  That seems a very clumsy way to handle more
>than one account.
>
>What 'has me confused' is the way that GnuCash by default opens the
>last account I was looking at.  In nine cases out of ten that's just
>what I don't want it to do, why else would I have exited GnuCash and
>moved to another directory?
>
>My ideal would be for GnuCash to look for account files in the current
>directory, if there is only one then open that one, if there are more
>then offer me a list to choose from. I can write myself a little
>wrapper script to do this but I don't find other programs need this.
>Many other programs do have a 'recently opened' option but they don't
>automatically open the last opened file.  ... and, as I pointed out,
>using the --nofile option prevents GnuCash from opening any file, you
>have to select the file after starting GnuCash.
>
>
>-- 
>Chris Green
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
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] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread Frank H. Ellenberger
Hi,

Am 26.04.22 um 14:13 schrieb parag puranik:
> There is no output of both the commands, The screen of terminal looks like 
> ::~$ flatpak remotes -d >fp-state
> :~$ flatpak search gnucash >>fp-state
> :~$

Right, it is in the file fp-state in your working directory. I had
expected you would attach that file to your email.
As John found the reason of your problem, you can now remove that file.

Regards
Frank
___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Michael or Penny Novack

On 4/26/2022 11:25 AM, Chris Green wrote:

I have several gnucash accounts files (sqlite databases in my case)
spread around my system.  When I go to a specific directory and run
GnuCash I just want it to see only the database[s] in that directory.

Is there a way I can tell gnucash to forget about all previous files
it has opened?  As it is I get presented with a 'memory' of other
accounts which can be very confusing unless I'm very careful with file
naming.

The --nofile option tells gnucash not to open the last accounts
database, it helps a little, but I really want it to forget more!

It may be confusing things slightly when you shorten "book of accounts" 
to "accounts" instead of "books" << we usually refer to the financial 
records of an entity as "its books" --- in days of yore when the records 
were kept pen and ink on paper the "journal" and "ledgers" WERE books 
(bound volumes of accounting paper) >>


Why is remembering in what directory the records for an entity are kept 
easier than remembering the name of the entity? I would find it much 
more difficult to keep track if the books for each of the entities were 
named just "books" and what made the difference was WHERE they were. 
Thus when I was using gnucash to handle :the books" for several entities 
besides myself I named each of the files for the entity. So the books 
for MA Chapter of TACF might have been called MATACF.gnucash, those of 
the local chapter of CoG Weavers.gnucash, etc. They were in fact living 
in different directories, but that was beside the point. The little MRU 
(most recently used) list in gnucash made it easier to select any of the 
ones "most popular"  but I could file=>open whichever I wanted to work on.


Michael D Novack


___
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 with GnuCash's 'help'

2022-04-26 Thread davidcousens49
Chris 

The online version of Help and the Tutorial and Concepts Guide are not really
searchable in any meaningful sense from within the HTML page. Other versions may
be I have more luck using Google directly to find specific topics and info.

The section you are likely looking for comes under "Setting Up, Editing and 
Working with Accounts" in the Help Manual. 
Basic procedure is to locate an account in the chart of accounts in the Account
Tab in the main window and then double click on the line for the account to open
the account register in a new tab.

It could be better but is likely limited by technological limitations and/or the
availability of documenters to improve it further. 

David Cousens




On Tue, 2022-04-26 at 16:35 +0100, Chris Green wrote:
> Maybe I'm missing something obvious but when I search for something in
> GnuCash's help I often can't see what I've searched for.
> 
> For example I just searched for 'open account' and it returns five
> headings - but when I open one of them (for example General
> Information Tab) I can't find the string 'open account' anwhere in
> there. 
> 

___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Bruce Irving
I have 3 separate gnucash data files.  I never open gnucash rather I click
on (or have link/shortcut to the data file.  That way, I can have the data
file links where they are easy to get to.

Bruce

On Tue, Apr 26, 2022 at 11:37 AM Chris Green  wrote:

> On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote:
> >On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
> > > I have several gnucash accounts files (sqlite databases in my case)
> > > spread around my system.  When I go to a specific directory and run
> > > GnuCash I just want it to see only the database[s] in that directory.
> > > Is there a way I can tell gnucash to forget about all previous files
> > > it has opened?  As it is I get presented with a 'memory' of other
> > > accounts which can be very confusing unless I'm very careful with file
> > > naming.
> > > The --nofile option tells gnucash not to open the last accounts
> > > database, it helps a little, but I really want it to forget more!
> >
> >I'm not certain what has you confused, but if you need each file to
> >have its own existence, you might have to create separate OS logins
> for
> >each.
> >
> Seriously?!  Do you really mean that I should create a different user
> for each GnuCash account?  That seems a very clumsy way to handle more
> than one account.
>
> What 'has me confused' is the way that GnuCash by default opens the
> last account I was looking at.  In nine cases out of ten that's just
> what I don't want it to do, why else would I have exited GnuCash and
> moved to another directory?
>
> My ideal would be for GnuCash to look for account files in the current
> directory, if there is only one then open that one, if there are more
> then offer me a list to choose from. I can write myself a little
> wrapper script to do this but I don't find other programs need this.
> Many other programs do have a 'recently opened' option but they don't
> automatically open the last opened file.  ... and, as I pointed out,
> using the --nofile option prevents GnuCash from opening any file, you
> have to select the file after starting GnuCash.
>
>
> --
> Chris Green
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Stan Brown


On 2022-04-26 13:49, davidcousen...@gmail.com wrote:
> Unfortunately GnuCash doesn't work that way AFAIK. Depending on your OS you 
> may
> be able to create separate launchers in the Desktop menufor each specific file
> and name them accordingly. I know this will work on Linux Mint and likely 
> Ubuntu
> variants but not sure on other OS.  

That's a yes for Windows 7, 8.1, and 1 with GC 2.6.x. I've seen other
people post here that it also works in Windows with later GC versions.

> The command issued by the launcher is
> "gnucash %f". If you change the "%f" to a specific path/filename it will open
> that specific file or at least it did several years ago when I used to work on
> multiple files.
> Then you just choose the launcher for the file you want to work on. If you 
> are a
> terminal user you could create separate  aliases for the commands with 
> different
> filenames.

Or ... set up a menu in a script or batch file (whatever your OS calls
it). Then instead of having one shortcut for each set of books, you'll
have one that you can launch to be presented with all choices.

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


Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread davidcousens49
Unfortunately GnuCash doesn't work that way AFAIK. Depending on your OS you may
be able to create separate launchers in the Desktop menufor each specific file
and name them accordingly. I know this will work on Linux Mint and likely Ubuntu
variants but not sure on other OS.  The command issued by the launcher is
"gnucash %f". If you change the "%f" to a specific path/filename it will open
that specific file or at least it did several years ago when I used to work on
multiple files.
Then you just choose the launcher for the file you want to work on. If you are a
terminal user you could create separate  aliases for the commands with different
filenames.

David Cousens






On Tue, 2022-04-26 at 16:25 +0100, Chris Green wrote:
> I have several gnucash accounts files (sqlite databases in my case)
> spread around my system.  When I go to a specific directory and run
> GnuCash I just want it to see only the database[s] in that directory.
> 
> Is there a way I can tell gnucash to forget about all previous files
> it has opened?  As it is I get presented with a 'memory' of other
> accounts which can be very confusing unless I'm very careful with file
> naming.
> 
> The --nofile option tells gnucash not to open the last accounts
> database, it helps a little, but I really want it to forget more!
> 

___
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] How to manage multiple accounts (as in separate gnucash??? databases)?

2022-04-26 Thread Robert Heller
At Tue, 26 Apr 2022 11:44:57 -0700 stephen.m.butle...@gmail.com wrote:

> 
> On 4/26/22 11:33, Robert Heller wrote:
> > At Tue, 26 Apr 2022 19:21:46 +0100 Chris Green  wrote:
> >
> > On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote:
> >>> Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. 
> >>> Maybe if
> >>> that directory is removed or made to be an empty "read-only" directory, 
> >>> you
> >>> might be able to "enforce" gnucash to have a memory loss...
> >>>
> >>> rm ~/.gnucash/books/*
> >>> chmod -w ~/.gnucash/books
> >>>
> >> Yes, it seems a bit drastic though! :-)
> >>
> >> It's actually /home/chris/.local/share/gnucash/books (or, strictly,
> >> some system variable specifies the directory I believe).
> > Probably depends on the version.  I'm still using 2.6.19-1 on my Ubuntu 
> > 18.04
> > system.
> >
> > Even opening GnuCash from a menu or icon (rather than the command
> > line) I'd really prefer that it didn't default to the last set of
> > accounts opened.
> > Yeah, that is unfortunate.  And really unfriendly.
> >
> 
> I happen to really like that it opens the last set of books.  Yes, I 
> have three (3) separate sets of books with each in a different folder 
> (directory).
> 
> And having the list of recent opened files makes it really handy to 
> switch between the three sets as desired.

I have no objection to the recent opened files. But applications that
automagically opening the last opened can be obnoxious and awkward for some 
workflows.  There should be preferences settings for that -- eg what is in the 
recent opened files list and what to do when opened without a filename on the 
command line (open nothing, open last, something else, etc.).

> 
> --Steve
> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

   
___
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] How to manage multiple accounts (as in separate gnucash?? databases)?

2022-04-26 Thread Stephen M. Butler

On 4/26/22 11:33, Robert Heller wrote:

At Tue, 26 Apr 2022 19:21:46 +0100 Chris Green  wrote:

On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote:

Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if
that directory is removed or made to be an empty "read-only" directory, you
might be able to "enforce" gnucash to have a memory loss...

rm ~/.gnucash/books/*
chmod -w ~/.gnucash/books


Yes, it seems a bit drastic though! :-)

It's actually /home/chris/.local/share/gnucash/books (or, strictly,
some system variable specifies the directory I believe).

Probably depends on the version.  I'm still using 2.6.19-1 on my Ubuntu 18.04
system.

Even opening GnuCash from a menu or icon (rather than the command
line) I'd really prefer that it didn't default to the last set of
accounts opened.
Yeah, that is unfortunate.  And really unfriendly.



I happen to really like that it opens the last set of books.  Yes, I 
have three (3) separate sets of books with each in a different folder 
(directory).


And having the list of recent opened files makes it really handy to 
switch between the three sets as desired.


--Steve

--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] How to manage multiple accounts (as in separate gnucash?? databases)?

2022-04-26 Thread Robert Heller
At Tue, 26 Apr 2022 19:21:46 +0100 Chris Green  wrote:

> 
> On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote:
> > 
> > Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe 
> > if
> > that directory is removed or made to be an empty "read-only" directory, you
> > might be able to "enforce" gnucash to have a memory loss...
> > 
> > rm ~/.gnucash/books/*
> > chmod -w ~/.gnucash/books
> > 
> Yes, it seems a bit drastic though! :-)
> 
> It's actually /home/chris/.local/share/gnucash/books (or, strictly,
> some system variable specifies the directory I believe).

Probably depends on the version.  I'm still using 2.6.19-1 on my Ubuntu 18.04 
system.

> 
> Even opening GnuCash from a menu or icon (rather than the command
> line) I'd really prefer that it didn't default to the last set of
> accounts opened.

Yeah, that is unfortunate.  And really unfriendly.  

> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
 
___
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] How to manage multiple accounts (as in separate gnucash? databases)?

2022-04-26 Thread Chris Green
On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote:
> 
> Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if
> that directory is removed or made to be an empty "read-only" directory, you
> might be able to "enforce" gnucash to have a memory loss...
> 
> rm ~/.gnucash/books/*
> chmod -w ~/.gnucash/books
> 
Yes, it seems a bit drastic though! :-)

It's actually /home/chris/.local/share/gnucash/books (or, strictly,
some system variable specifies the directory I believe).

Even opening GnuCash from a menu or icon (rather than the command
line) I'd really prefer that it didn't default to the last set of
accounts opened.

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


Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread Colin Arndt
Mystery solved - FlatHub dropped support for 32-bit ARM OS’s, which is what I’m 
on. 

This means my issue is separate from Pagar’s. Sorry for muddying the thread.

> On Apr 26, 2022, at 1:28 PM, Colin Arndt  wrote:
> 
> One more note: 
> 4.4 was the current version when I installed GnuCash last year. My issue 
> might be different from Parag’s then.
> 
> - My install was current at the time of install, but has been frozen since. 
> 
> - Parag’s install seems to be offering him an ancient version from the start.
> 
>> On Apr 26, 2022, at 1:25 PM, Colin Arndt > > wrote:
>> 
>> Hi Frank,
>> 
>> I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let 
>> me update beyond 4.4 in Flathub, because it doesn’t detect any newer 
>> versions.
>> 
>> I’ve run the commands you sent, with the output redirected to files, but the 
>> files don't show any fields beyond what Parag posted. 
>> 
>> They’re attached. In essence they show my architecture is arm and that the 
>> latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).
>> 
>> Thanks,
>> Colin
>> 
>> 
>> 
>> 
>> 
>>> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org 
>>>  wrote:
>>> 
>>> Message: 6
>>> Date: Tue, 26 Apr 2022 13:41:26 +0200
>>> From: "Frank H. Ellenberger" >> >
>>> To: parag puranik mailto:parag_pura...@yahoo.com>>
>>> Cc: "gnucash-user@gnucash.org " 
>>> mailto:gnucash-user@gnucash.org>>
>>> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>>> but only installs lower ver. 3.7
>>> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
>>> >
>>> Content-Type: text/plain; charset=UTF-8
>>> 
>>> Hi,
>>> 
>>> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
>>> shortened away. Can you redo them in a full screen window or by
>>> redirecting into a file like:
>>> 
>>> flatpak remotes -d >fp-state
>>> flatpak search gnucash >>fp-state
>>> 
>>> Regards
>>> Frank
>> 
> 

___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Chris Green
On Tue, Apr 26, 2022 at 01:43:00PM -0400, Dan Black wrote:
>Using the nofile option means to open Gnucash without any file. If you
>specify a filename on the command line without the nofile, it should
>open the file specified.

Well that isn't what the man page says, it says " Do not load the last
file opened".  To me that says don't open the last file GnuCash had
opened when I exited.  

As I said I can, of course, write wrapper scripts (or desktop files)
to make GnuCash open specific files.  However I wish it *didn't* open
the last file I was editing by default.

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


Re: [GNC] How to manage multiple accounts (as in separate gnucash? databases)?

2022-04-26 Thread Robert Heller
At Tue, 26 Apr 2022 18:36:13 +0100 Chris Green  wrote:

> 
> On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote:
> >On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
> > > I have several gnucash accounts files (sqlite databases in my case)
> > > spread around my system.  When I go to a specific directory and run
> > > GnuCash I just want it to see only the database[s] in that directory.
> > > Is there a way I can tell gnucash to forget about all previous files
> > > it has opened?  As it is I get presented with a 'memory' of other
> > > accounts which can be very confusing unless I'm very careful with file
> > > naming.
> > > The --nofile option tells gnucash not to open the last accounts
> > > database, it helps a little, but I really want it to forget more!
> > 
> >I'm not certain what has you confused, but if you need each file to
> >have its own existence, you might have to create separate OS logins for
> >each.
> > 
> Seriously?!  Do you really mean that I should create a different user
> for each GnuCash account?  That seems a very clumsy way to handle more
> than one account.
> 
> What 'has me confused' is the way that GnuCash by default opens the
> last account I was looking at.  In nine cases out of ten that's just
> what I don't want it to do, why else would I have exited GnuCash and
> moved to another directory?
> 
> My ideal would be for GnuCash to look for account files in the current
> directory, if there is only one then open that one, if there are more
> then offer me a list to choose from. I can write myself a little
> wrapper script to do this but I don't find other programs need this.
> Many other programs do have a 'recently opened' option but they don't
> automatically open the last opened file.  ... and, as I pointed out,
> using the --nofile option prevents GnuCash from opening any file, you
> have to select the file after starting GnuCash.

In the GUI world there really isn't anything like a "current directory". GUI
apps don't know anything about the current directory, *esp* if they are fired
up from a launcher menu or desktop icon. I understand that under MS-Windows
(and maybe Linux) you can bind desktop *file* icons to fire up gnucash with
the specified file. I have heard that this does not work under MacOSX --
something is "broken" there. From the (evil?) command line, gnucash will take
a filename on the command line (at least for XML/Compressed XML files -- I
have not used a version of gnucash that supports SQL).

Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if
that directory is removed or made to be an empty "read-only" directory, you
might be able to "enforce" gnucash to have a memory loss...

rm ~/.gnucash/books/*
chmod -w ~/.gnucash/books

> 
> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
   
___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Dan Black
Using the nofile option means to open Gnucash without any file. If you 
specify a filename on the command line without the nofile, it should open 
the file specified.


Setup a shortcut for each of your files.



On April 26, 2022 1:36:42 PM Chris Green  wrote:


On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote:

   On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
> I have several gnucash accounts files (sqlite databases in my case)
> spread around my system.  When I go to a specific directory and run
> GnuCash I just want it to see only the database[s] in that directory.
> Is there a way I can tell gnucash to forget about all previous files
> it has opened?  As it is I get presented with a 'memory' of other
> accounts which can be very confusing unless I'm very careful with file
> naming.
> The --nofile option tells gnucash not to open the last accounts
> database, it helps a little, but I really want it to forget more!

   I'm not certain what has you confused, but if you need each file to
   have its own existence, you might have to create separate OS logins for
   each.


Seriously?!  Do you really mean that I should create a different user
for each GnuCash account?  That seems a very clumsy way to handle more
than one account.

What 'has me confused' is the way that GnuCash by default opens the
last account I was looking at.  In nine cases out of ten that's just
what I don't want it to do, why else would I have exited GnuCash and
moved to another directory?

My ideal would be for GnuCash to look for account files in the current
directory, if there is only one then open that one, if there are more
then offer me a list to choose from. I can write myself a little
wrapper script to do this but I don't find other programs need this.
Many other programs do have a 'recently opened' option but they don't
automatically open the last opened file.  ... and, as I pointed out,
using the --nofile option prevents GnuCash from opening any file, you
have to select the file after starting GnuCash.


--
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
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] Question about transfers

2022-04-26 Thread Brad
It looks like using sub-accounts to track amounts designated for a
specific purpose going into and out of accounts will work great.
Thanks everyone.
Brad

On Sat, Apr 23, 2022 at 11:14 AM Brad  wrote:
>
> I like the idea of using sub-accounts.  I will test it out and report back.
> Thanks.
>
> On Fri, Apr 22, 2022 at 7:37 PM David H  wrote:
> >
> > Brad,
> >
> > If I were to do this I think I'd look at creating sub-accounts under the 
> > Transfer To account - i.e.
> >
> > Assets >> Current Assets >> Transfer To Account  >> Groceries
> > Assets >> Current Assets >> Transfer To Account  >> Utilities
> > Assets >> Current Assets >> Transfer To Account  >> etc
> >
> > This tells you how much you transferred to each and also includes the 
> > balance of the sub accounts in the Transfer To account.
> >
> > cheers David H.
> >
> >
> >
> > On Sat, 23 Apr 2022 at 07:39, Brad  wrote:
> >>
> >> Hello,
> >> I am new to GnuCash and to this list.  I am a long, long time Quicken
> >> user who has finally gotten fed up with Quicken and I am in the midst
> >> of converting to GnuCash.
> >>
> >> My question is regarding transfer of funds from one account to
> >> another.  I want to transfer funds from one account to another, but I
> >> also want to track the transfer amount against an expense account so I
> >> can keep track separately of how much I have transferred for different
> >> reasons.
> >>
> >> Anyone have any ideas?  I'm guessing it involves a split transaction
> >> of some sort, but I can't figure out what the pieces of the split look
> >> like.
> >> Thanks in advance for your help.
> >> Brad
> >> ___
> >> 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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Chris Green
On Tue, Apr 26, 2022 at 12:24:32PM -0400, David T. wrote:
>On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
> > I have several gnucash accounts files (sqlite databases in my case)
> > spread around my system.  When I go to a specific directory and run
> > GnuCash I just want it to see only the database[s] in that directory.
> > Is there a way I can tell gnucash to forget about all previous files
> > it has opened?  As it is I get presented with a 'memory' of other
> > accounts which can be very confusing unless I'm very careful with file
> > naming.
> > The --nofile option tells gnucash not to open the last accounts
> > database, it helps a little, but I really want it to forget more!
> 
>I'm not certain what has you confused, but if you need each file to
>have its own existence, you might have to create separate OS logins for
>each.
> 
Seriously?!  Do you really mean that I should create a different user
for each GnuCash account?  That seems a very clumsy way to handle more
than one account.

What 'has me confused' is the way that GnuCash by default opens the
last account I was looking at.  In nine cases out of ten that's just
what I don't want it to do, why else would I have exited GnuCash and
moved to another directory?

My ideal would be for GnuCash to look for account files in the current
directory, if there is only one then open that one, if there are more
then offer me a list to choose from. I can write myself a little
wrapper script to do this but I don't find other programs need this.
Many other programs do have a 'recently opened' option but they don't
automatically open the last opened file.  ... and, as I pointed out,
using the --nofile option prevents GnuCash from opening any file, you
have to select the file after starting GnuCash.


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


Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread Colin Arndt
One more note: 
4.4 was the current version when I installed GnuCash last year. My issue might 
be different from Parag’s then.

- My install was current at the time of install, but has been frozen since. 

- Parag’s install seems to be offering him an ancient version from the start.

> On Apr 26, 2022, at 1:25 PM, Colin Arndt  wrote:
> 
> Hi Frank,
> 
> I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let me 
> update beyond 4.4 in Flathub, because it doesn’t detect any newer versions.
> 
> I’ve run the commands you sent, with the output redirected to files, but the 
> files don't show any fields beyond what Parag posted. 
> 
> They’re attached. In essence they show my architecture is arm and that the 
> latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).
> 
> Thanks,
> Colin
> 
> 
> 
> 
> 
>> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org 
>>  wrote:
>> 
>> Message: 6
>> Date: Tue, 26 Apr 2022 13:41:26 +0200
>> From: "Frank H. Ellenberger" > >
>> To: parag puranik mailto:parag_pura...@yahoo.com>>
>> Cc: "gnucash-user@gnucash.org " 
>> mailto:gnucash-user@gnucash.org>>
>> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>>  but only installs lower ver. 3.7
>> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
>> >
>> Content-Type: text/plain; charset=UTF-8
>> 
>> Hi,
>> 
>> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
>> shortened away. Can you redo them in a full screen window or by
>> redirecting into a file like:
>> 
>> flatpak remotes -d >fp-state
>> flatpak search gnucash >>fp-state
>> 
>> Regards
>> Frank
> 

___
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] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread Colin Arndt
Hi Frank,

I’ll jump in because I have the same issue on a Raspberry Pi. It won’t let me 
update beyond 4.4 in Flathub, because it doesn’t detect any newer versions.

I’ve run the commands you sent, with the output redirected to files, but the 
files don't show any fields beyond what Parag posted. 

They’re attached. In essence they show my architecture is arm and that the 
latest Gnucash stable in Flathub is 4.4 (the same as what my Pi is running).

Thanks,
Colin



> On Apr 26, 2022, at 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 6
> Date: Tue, 26 Apr 2022 13:41:26 +0200
> From: "Frank H. Ellenberger"  >
> To: parag puranik mailto:parag_pura...@yahoo.com>>
> Cc: "gnucash-user@gnucash.org " 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak,
>   but only installs lower ver. 3.7
> Message-ID: <5d424871-9c3c-9667-8197-95a14f9f9...@gmail.com 
> >
> Content-Type: text/plain; charset=UTF-8
> 
> Hi,
> 
> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
> shortened away. Can you redo them in a full screen window or by
> redirecting into a file like:
> 
> flatpak remotes -d >fp-state
> flatpak search gnucash >>fp-state
> 
> Regards
> Frank

___
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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread David T. via gnucash-user
I'm not certain what has you confused, but if you need each file to have its 
own existence, you might have to create separate OS logins for each. 

On April 26, 2022 11:25:02 AM EDT, Chris Green  wrote:
>I have several gnucash accounts files (sqlite databases in my case)
>spread around my system.  When I go to a specific directory and run
>GnuCash I just want it to see only the database[s] in that directory.
>
>Is there a way I can tell gnucash to forget about all previous files
>it has opened?  As it is I get presented with a 'memory' of other
>accounts which can be very confusing unless I'm very careful with file
>naming.
>
>The --nofile option tells gnucash not to open the last accounts
>database, it helps a little, but I really want it to forget more!
>
>-- 
>Chris Green
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
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] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread john


> On Apr 25, 2022, at 11:36 PM, grant  wrote:
> 
> So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 
> but I cannot connect to mysql databases. When I click file, open there is no 
> option for mysql. This is under Fedora 

You probably need to install the libdbd-mysql package.

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] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread john
I see I was mistaken about the earliest GnuCash in flathub. It's in fact 
2.6.16, in commit 
https://github.com/flathub/org.gnucash.GnuCash/commit/d00d11bd14b3c9a1fce8a18f560163aca1742297
 
.
It appears that flathub dropped support for new i386 packages sometime between 
September and December 2019, the release dates for GnuCash 3.7 and 3.8 
respectively. That explains why you're unable to get a more recent GnuCash. The 
nightly builds on code.gnucash.org  are also x86_64 
so that won't help you.

While Ubuntu no longer supports 32-bit computers Debian still does (but not 
all, see https://wiki.debian.org/ArchitectureSpecificsMemo#i386-1 
) and their current 
stable release includes GnuCash 4.4. You still won't be able to use flatpaks. 
Note that Debian stable does not provide GnuCash upgrades between releases so 
if you want to keep current you should go with Debian testing. While it might 
be tempting to try to just change the sources file and run apt update && apt 
system-upgrade, I found several discussions like this one 
https://unix.stackexchange.com/questions/616907/how-to-upgrade-lubuntu-to-debian
 

 saying not to do that.

Regards,
John Ralls


> On Apr 26, 2022, at 5:13 AM, parag puranik via gnucash-user 
>  wrote:
> 
> There is no output of both the commands, The screen of terminal looks like 
> ::~$ flatpak remotes -d >fp-state
> :~$ flatpak search gnucash >>fp-state
> :~$
> I am getting increasingly sure that i386 versions of flatpaks, which I have- 
> i.e.  "1.0.9-0ubuntu0.4" is limited to pulling Gnucash ver 3.7 at the maximum 
> from Flathub, not beyond that. Like last supported vercion of Gnucash on Win 
> 7 is 3.11, last 32 bit version supported on Linux 32 bit is Ver. 3.7
> Flatpak itself cannot be be upgaded to a newer version. Hence for Flatpak 
> ver. 1.0.9 the last supported version of Gnucash could be  ver. 3.7.
> 
>On Tuesday, 26 April, 2022, 05:11:30 pm IST, Frank H. Ellenberger 
>  wrote:  
> 
> Hi,
> 
> Flatpak tries to be smart. So the interesting parts of 2 and 3 were
> shortened away. Can you redo them in a full screen window or by
> redirecting into a file like:
> 
> flatpak remotes -d >fp-state
> flatpak search gnucash >>fp-state
> 
> Regards
> Frank
> 
> Am 26.04.22 um 13:27 schrieb parag puranik:
>>   Outputs of commands:
>> 
>> (1) $ flatpak --supported-arches
>> i386
>> 
>> (2) $ flatpak remotes -d
>> NameTitle   URL  Collection ID Priority Options
>> flathub Flathub https://dl.flathub.org/repo/ - 1system 
>> 
>> (3) $ flatpak search gnucash
>> Application ID  Version Branch Remotes Description   
>>  
>> org.gnucash.GnuCash 3.7+stable flathub Manage your finances, accounts, 
>> and investments
>> org.kde.skrooge stable flathub Personal Finances
> 
> ___
> 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] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Chris Green
On Tue, Apr 26, 2022 at 04:25:02PM +0100, Chris Green wrote:
> I have several gnucash accounts files (sqlite databases in my case)
> spread around my system.  When I go to a specific directory and run
> GnuCash I just want it to see only the database[s] in that directory.
> 
> Is there a way I can tell gnucash to forget about all previous files
> it has opened?  As it is I get presented with a 'memory' of other
> accounts which can be very confusing unless I'm very careful with file
> naming.
> 
> The --nofile option tells gnucash not to open the last accounts
> database, it helps a little, but I really want it to forget more!
> 
... and the --nofile option doesn't appear to do what it says it does.
The man page says:-

--nofile
  Do not load the last file opened


However with the --nofile option gnucash doesn't even open a file
whose name you give it on the command line!


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


[GNC] Help with GnuCash's 'help'

2022-04-26 Thread Chris Green
Maybe I'm missing something obvious but when I search for something in
GnuCash's help I often can't see what I've searched for.

For example I just searched for 'open account' and it returns five
headings - but when I open one of them (for example General
Information Tab) I can't find the string 'open account' anwhere in
there. 

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


[GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-26 Thread Chris Green
I have several gnucash accounts files (sqlite databases in my case)
spread around my system.  When I go to a specific directory and run
GnuCash I just want it to see only the database[s] in that directory.

Is there a way I can tell gnucash to forget about all previous files
it has opened?  As it is I get presented with a 'memory' of other
accounts which can be very confusing unless I'm very careful with file
naming.

The --nofile option tells gnucash not to open the last accounts
database, it helps a little, but I really want it to forget more!

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


Re: [GNC] Why does an Equity account have to be of Currency type?

2022-04-26 Thread km22

Hi Michael,

I agree - I could change the definition of $ for the purposes of the Robinson 
Crusoe case.  But let me ask the question a different way:

It seems that when trying to create an account of type Asset, Bank, Cash, Credit Card, 
Liability, A/Receivable, A/Payable, Equity selecting the denominated 
"Security/currency" only allows the user to select a Currency Type.
For account types Stock and Mutual Fund the "Security/currency" is only allowed 
to be of a Non-Currency Type.

Why is that restriction necessary?  Why can't you have a Bank account that is denominated 
in silver taels*?  Or a cash account denominated in "Disney Dollars"?  Or 
contribute Equity to a business in the form of yards of lumber?

Perhaps the answer is to simply use a "Stock" account type for my asset 
examples?  But there is no workaround for the equity example.  And it seems like an 
artificial limitation within the software - unless I am missing the reason this should 
not be permitted (either from an software implementation or accounting perspective).

Thanks,
Ken



* Yes, I could use this ISO currency XAG but that price typically refers to 
troy ounces and it might be that I want to mark the bid price of a silver 
savings account at a premium or discount to the XAG price.


P.S. For some reason I am not receiving replies direct to my email so I am 
copying and pasting from the GnuCash archive below.



Date: Mon, 25 Apr 2022 13:17:08 -0400
From: Michael or Penny Novack
To:gnucash-user@gnucash.org
Subject: Re: [GNC] Why does an Equity account have to be of Currency
type?
Message-ID:<521f2821-4532-0ac2-81a2-4a4f9400c...@comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed



But question is more general.? Let's say I join Robinson Crusoe on a
remote island and we decide our economy will be denominated in silver
coins (of which I had 12 in my pocket when I washed ashore on his
island).? If I were to do my accounting in GnuCash I would need to start
with an Opening Balance of 12 coins (my first transaction would need to
be Assets:Coins 12, Equity:Opening Balance 12), Gnucash does not let me
do this.? The software will only allow the Equity accounts to be of ISO
currency type.? Why not let the user denominate an Equity account in any
asset they like - silver coins if that is what they want?


It DOES allow this if you refuse to accept the magical meaning of "$"
(or any other symbol).

Declare a law on the island, "$ is the symbol for a silver coin".? The
fact that other people in other lands understand $ to stand for USD is
irrelevant to island life. You are acting as if it made a difference in
algebra whether you used "X"or "Y" to stand for an unknown variable.

But you are actually wanting something else. You are wanting in one set
of books more than one type of currency? at the same time. That gnucash
does not support, but that is more a limitation of accounting than of
gnucash. You CAN be accounting for more than one sort of :currency" at
the same time, but if not exchangeable, not in the same set of books <<
guncash will let you have any number of books >>

Michael D Novack



On 25/4/2022 22:24, km22 wrote:


Hi Jim,

In the end, I have decided to simply treat my mock trust or mock
company with a cash equity injection.

But question is more general.  Let's say I join Robinson Crusoe on a
remote island and we decide our economy will be denominated in silver
coins (of which I had 12 in my pocket when I washed ashore on his
island).  If I were to do my accounting in GnuCash I would need to
start with an Opening Balance of 12 coins (my first transaction would
need to be Assets:Coins 12, Equity:Opening Balance 12), Gnucash does
not let me do this. The software will only allow the Equity accounts
to be of ISO currency type.  Why not let the user denominate an Equity
account in any asset they like - silver coins if that is what they want?

Thanks,

Ken

P.S. Please excuse this badly formatted email - I had to copy and
paste your text from the Archive as I seem to have deleted the
original reply.


--

Message: 8
Date: Sat, 23 Apr 2022 13:05:04 -0700
From: Jim DeLaHunt
To:gnucash-user@gnucash.org
Subject: Re: [GNC] Why does an Equity account have to be of Currency
type?
Message-ID:<29e7cc91-fdb1-ccb9-daf2-f5e177392...@jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 2022-04-23 02:46, km22 wrote:


?I am starting a new Gnucash file for a simple "mock" trust.? The trust
holds physical assets (like stamps and coins and other collectibles).? I
want to represent the contributions to this trust in the form of these
assets.? However, when I try to create new Equity accounts for the
contributions it only allows me to use "Currency" type assets.?

Your Gnucash usage question leads me to an accounting question. And I am
not an accountant, so my ignorance is likely vast. However?

Why should the accounts which track the physical assets be Equity
accounts?? 

Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread parag puranik via gnucash-user
 There is no output of both the commands, The screen of terminal looks like 
::~$ flatpak remotes -d >fp-state
:~$ flatpak search gnucash >>fp-state
:~$
I am getting increasingly sure that i386 versions of flatpaks, which I have- 
i.e.  "1.0.9-0ubuntu0.4" is limited to pulling Gnucash ver 3.7 at the maximum 
from Flathub, not beyond that. Like last supported vercion of Gnucash on Win 7 
is 3.11, last 32 bit version supported on Linux 32 bit is Ver. 3.7
Flatpak itself cannot be be upgaded to a newer version. Hence for Flatpak ver. 
1.0.9 the last supported version of Gnucash could be  ver. 3.7.

On Tuesday, 26 April, 2022, 05:11:30 pm IST, Frank H. Ellenberger 
 wrote:  
 
 Hi,

Flatpak tries to be smart. So the interesting parts of 2 and 3 were
shortened away. Can you redo them in a full screen window or by
redirecting into a file like:

flatpak remotes -d >fp-state
flatpak search gnucash >>fp-state

Regards
Frank

Am 26.04.22 um 13:27 schrieb parag puranik:
>  Outputs of commands:
> 
> (1) $ flatpak --supported-arches
> i386
> 
> (2) $ flatpak remotes -d
> Name    Title   URL  Collection ID Priority Options
> flathub Flathub https://dl.flathub.org/repo/ - 1    system 
> 
> (3) $ flatpak search gnucash
> Application ID  Version Branch Remotes Description
>     
> org.gnucash.GnuCash 3.7+    stable flathub Manage your finances, accounts, 
> and investments
> org.kde.skrooge stable flathub Personal Finances
  
___
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] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread Frank H. Ellenberger
Hi,

Flatpak tries to be smart. So the interesting parts of 2 and 3 were
shortened away. Can you redo them in a full screen window or by
redirecting into a file like:

flatpak remotes -d >fp-state
flatpak search gnucash >>fp-state

Regards
Frank

Am 26.04.22 um 13:27 schrieb parag puranik:
>  Outputs of commands:
> 
> (1) $ flatpak --supported-arches
> i386
> 
> (2) $ flatpak remotes -d
> Name    Title   URL  Collection ID Priority Options
> flathub Flathub https://dl.flathub.org/repo/ - 1    system 
> 
> (3) $ flatpak search gnucash
> Application ID  Version Branch Remotes Description
>     
> org.gnucash.GnuCash 3.7+    stable flathub Manage your finances, accounts, 
> and investments
> org.kde.skrooge stable flathub Personal Finances
___
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] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-26 Thread parag puranik via gnucash-user
 Outputs of commands:

(1) $ flatpak --supported-arches
i386

(2) $ flatpak remotes -d
Name    Title   URL  Collection ID Priority Options
flathub Flathub https://dl.flathub.org/repo/ - 1    system 

(3) $ flatpak search gnucash
Application ID  Version Branch Remotes Description  
  
org.gnucash.GnuCash 3.7+    stable flathub Manage your finances, accounts, and 
investments
org.kde.skrooge stable flathub Personal Finances

On Tuesday, 26 April, 2022, 06:38:31 am IST, Frank H. Ellenberger 
 wrote:  
 
 Hi,

please send the output of the following commands:
flatpak --supported-arches
flatpak remotes -d
flatpak search gnucash

Perhaps we can so get a clue of your problem.

Regards
Frank

Am 25.04.22 um 15:23 schrieb parag puranik via gnucash-user:
> The first Flathub release (for 32 bit OS) was not ver 3.11 ( it could be 
> earlier version), since I have installed ver. 3.7 on my 32 bit OS.
> That said, my conclusion is : Flathub installs ver. 3.7 on 32 bit systems 
> (that could be last ver. offerred by Flathub for i386).
> To get higher versions than 3.7, you have to look out providers other than 
> Flathub.
> Can someone help me identify providers other than Flathub for a higher 
> version flatpak for i386 systems ?
> 
> Sent from Yahoo Mail on Android 
  
___
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] Why does an Equity account have to be of Currency type?

2022-04-26 Thread Frank H. Ellenberger
Hi,

just for completeness …

Am 25.04.22 um 19:17 schrieb Michael or Penny Novack:
> The fact that other people in other lands understand $ to stand for USD
> is irrelevant to island life.

The origin of the word is
https://en.wikipedia.org/wiki/Tolar
and the symbol
https://en.wikipedia.org/wiki/Dollar_sign#History

Regards
Frank
___
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] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread grant
I worked it out in the end. Had to install the perl-DBI library etc and I am 
away. Gnucash also works with postgres. Sent from my Galaxy
 Original message From: Chris Green  Date: 
26/04/22  20:29  (GMT+12:00) To: gnucash-user@gnucash.org Subject: Re: [GNC] 
Linux. Mysql and Gnucash 4.1 On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant 
wrote:> So I have rebuilt my laptop, recovered my databases and installed 
Gnucash > 4.1 but I cannot connect to mysql databases. When I click file, open 
there > is no option for mysql. This is under Fedora 35Sent from my Galaxy I 
don't believe GnuCash works with mysql (or the equivalent mariadb),the only 
database storage option that I'm aware of is sqlite.-- Chris 
Green___gnucash-user mailing 
listgnucash-user@gnucash.orgTo update your subscription preferences or to 
unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-userIf 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] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread Chris Green
On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote:
> So I have rebuilt my laptop, recovered my databases and installed Gnucash 
> 4.1 but I cannot connect to mysql databases. When I click file, open there 
> is no option for mysql. This is under Fedora 35Sent from my Galaxy 

I don't believe GnuCash works with mysql (or the equivalent mariadb),
the only database storage option that I'm aware of is sqlite.

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


[GNC] Linux. Mysql and Gnucash 4.1

2022-04-26 Thread grant
So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 
but I cannot connect to mysql databases. When I click file, open there is no 
option for mysql. This is under Fedora 35Sent from my Galaxy
___
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.