On 2019-03-31 18:23, Stuart McGraw wrote:
On 3/30/19 1:40 PM, taf wrote:
Hello,
I've just started using Gnucash. In the past I've used a basic
bookkeeping package, but it's no longer available. I'm trying to keep
two sets of books... one for personal accounting and one for a
corporation. I'm running Version 3.4 Build ID: 3.4+ (2018-12-30) on
Windows 7; I've set up the books, saving the books into two different
MySql data bases with separate users and passwords. So far so good.
I can switch between sets of books by selecting
File->Open...->
and then in the Open dialog, selecting MySql data format and
specifying database, userid, and password. This seems to be a bit
klunky... am I missing something fundamental?
Ideally I'd like to have two desktop shortcuts, one to use each set
of books, specifying at least format, database and user within the
shortcut.
So... any help?
Running 'gnucash --help' as a command (and likely the same info is in
the help somewhere) show that the gnucash command takes an argument
that is the the datafile to open. It seems 'datafile' can also be a
url for a database connection. Thus I have two desktop shortcuts that
run respectively the commands:
gnucash postgres://stuart:xxxxx@localhost/gc-home
gnucash postgres://stuart:xxxxx@localhost/gc-business
where "stuart" is the *database* (not OS) user account, "xxxxx" the
database password "gc-home" and "gc-business" the names of the
databases for each set of books. I presume something similar will
work for mysql.
Thanks! This gave me what I needed. 'gnucash --help' from the command
line gave me nothing (I'd seen in the archives that I should try that) .
I do have a long persisting problem where I am asked every time for a
password for my keyring (something I've never used, set up, or want)
but since clicking "Cancel" results in gnucash opening fine I've never
bothered to try to fix it. (I'm running gnucash on Ubuntu linux.)
It is a big plus for me to have both sets of books available from the
same OS user account. As others point out, settings etc will be the
same for both sets of books. For me, that is an advantage.
_______________________________________________
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.
