Re: [GNC] Log file preferences (using sqlite)
Ah. That isn't fully wrong, but it is somewhat misleading. I think it's meant to imply that the log files aren't useful with the sql back ends (because the changes are committed to the db immediately), but I couldn't tell you for sure, as I didn't write that section. It looks as if the note might only apply to some of the bullets-- but which ones? I don't know... (BTW, a chapter number would have helped locate the passage). David Original Message From: Chris Green Sent: Wed Feb 03 08:52:36 EST 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] Log file preferences (using sqlite) On Wed, Feb 03, 2021 at 07:17:12AM -0500, D. wrote: > > > Although I don't use the sqlite back end, I can answer that: > > > > > > 1) yes log files happen with the db back ends > > > > So the documentation is simply wrong, does this mean the documentation > > needs fixing or the code needs fixing? :-) > > > What documentation were you consulting that is "completely wrong"? > See above, I didn't say "completely wrong", I was much more polite! :-) It's in the Help section about "Setting Preferences", in the "General" section at "Files" it says:- Files The following options are only relevant for files saved in XML format. I suppose you could argue that being able to turn logging on and off applies only to "files saved in XML format" and that thus you can't turn logging on and off or set the age when using sqlite, but I don't think that's really the intention of what it says. -- 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] Log file preferences (using sqlite)
On Wed, Feb 03, 2021 at 10:46:35AM -0600, Adrien Monteleone wrote: > On 2/3/21 3:47 AM, Chris Green wrote: > > I can't really work that way as I have two independent sets of > > accounts to manage. If you just swapped from one to the other within > > Gnucash I hate to think how you'd unscramble the log file(s). > > I use several books too, and switch from within GnuCash without issue, but > each one is stored in a different folder, so the logs stay separated as > well. (they are also named to match the data file. I suppose my names are > sufficiently different, that even if they were in the same folder, I could > still tell them apart easily.) > > Maybe create sub-folders for each book and swap books from within GnuCash > rather than double-clicking them to open. > They are in separate sub-directories. However, being a command line junkie, I very, very rarely click on icons to start programs. For gnucash I have written myself a trivial script 'gc' to run gnucash. I do have a (very) few programs I can pull down from the panel at the top of my screen - Firefox, terminal window and a calendar - that's it, everything else is command line. I find it much easier and faster to simply type 'gc' or 'abook' or whatever on a command line (I always have several open) than to find and click on an icon or search through menus for a program. -- 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] Log file preferences (using sqlite)
I use several books too, and switch from within GnuCash without issue, but each one is stored in a different folder, so the logs stay separated as well. (they are also named to match the data file. I suppose my names are sufficiently different, that even if they were in the same folder, I could still tell them apart easily.) Maybe create sub-folders for each book and swap books from within GnuCash rather than double-clicking them to open. Regards, Adrien On 2/3/21 3:47 AM, Chris Green wrote: I can't really work that way as I have two independent sets of accounts to manage. If you just swapped from one to the other within Gnucash I hate to think how you'd unscramble the log file(s). ___ 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] Log file preferences (using sqlite)
On Wed, Feb 03, 2021 at 07:17:12AM -0500, D. wrote: > > > Although I don't use the sqlite back end, I can answer that: > > > > > > 1) yes log files happen with the db back ends > > > > So the documentation is simply wrong, does this mean the documentation > > needs fixing or the code needs fixing? :-) > > > What documentation were you consulting that is "completely wrong"? > See above, I didn't say "completely wrong", I was much more polite! :-) It's in the Help section about "Setting Preferences", in the "General" section at "Files" it says:- Files The following options are only relevant for files saved in XML format. I suppose you could argue that being able to turn logging on and off applies only to "files saved in XML format" and that thus you can't turn logging on and off or set the age when using sqlite, but I don't think that's really the intention of what it says. -- 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] Log file preferences (using sqlite)
Chris, What documentation were you consulting that is "completely wrong"? David Original Message From: Chris Green Sent: Wed Feb 03 04:40:45 EST 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] Log file preferences (using sqlite) On Tue, Feb 02, 2021 at 06:33:19PM -0500, D. wrote: > Although I don't use the sqlite back end, I can answer that: > > 1) yes log files happen with the db back ends So the documentation is simply wrong, does this mean the documentation needs fixing or the code needs fixing? :-) > 2) no you can't change the log file directory (this is a long long long > standing request) I am not alone! :-) > 3) not sure, but probably you could > I thought I had turned logging off but I'm still getting logs, I'll have to check that I really did turn them off. Thank you for the comprehensive answer. -- 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] Log file preferences (using sqlite)
On Tue, Feb 02, 2021 at 09:52:00PM -0500, Joseph Vernice wrote: > You can try creating a link pointing to where you want to save the logs. > Unfortunately, if you use this method, everything in the folder will be > saved to the linked folder, including mom GC files. > No, the idea would be to separate the logs (i.e. temporary files that you hope you never need to access) from the actual data that is your accounts. I keep everything to do with the organisation that I run the accounts for in a single directory (with sub-directories if that makes sense), so in my home directory there's pcc/2020 which has in it:- 08 - sub-directory with some correspndence etc. from August 2020 2020balancesheet.html - what it says building.gnucash - building fund accounts general.gnucash - general fund accounts giftaid - sub-directory containing scans of GiftAid envelopes, to submit to HMRC ... and GnuCash clutters the place up with:- building.gnucash.20210202152822.log building.gnucash.20210202153313.log building.gnucash.20210202153340.log building.gnucash.20210202153716.log general.gnucash.20210202152810.log general.gnucash.20210202152933.log general.gnucash.20210202153145.log general.gnucash.20210202154835.log general.gnucash.20210202155038.log Which really is rather a pain! :-) -- 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] Log file preferences (using sqlite)
On Tue, Feb 02, 2021 at 07:27:05PM -0600, Adrien Monteleone wrote: > > I rarely shut down GnuCash and usually leave it open 24/7 save for updates > to either it, or MacOS. Other than shutdowns, perhaps eventually it writes a > log after so many transactions. I use it daily, and see 19 log files of > varying sizes between 10/6/20 and 1/15/21. (with nothing since then) > I can't really work that way as I have two independent sets of accounts to manage. If you just swapped from one to the other within Gnucash I hate to think how you'd unscramble the log file(s). About the only (GUI) program that stays open long term on my system is my web browser, everything else is run as needed and then I exit. The system (a desktop PC) is on all the time though as it runs as my mailserver among other things. -- 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] Log file preferences (using sqlite)
On Tue, Feb 02, 2021 at 06:33:19PM -0500, D. wrote: > Although I don't use the sqlite back end, I can answer that: > > 1) yes log files happen with the db back ends So the documentation is simply wrong, does this mean the documentation needs fixing or the code needs fixing? :-) > 2) no you can't change the log file directory (this is a long long long > standing request) I am not alone! :-) > 3) not sure, but probably you could > I thought I had turned logging off but I'm still getting logs, I'll have to check that I really did turn them off. Thank you for the comprehensive answer. -- 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] Log file preferences (using sqlite)
You can try creating a link pointing to where you want to save the logs. Unfortunately, if you use this method, everything in the folder will be saved to the linked folder, including mom GC files. On Tue, Feb 2, 2021 at 9:57 AM Chris Green wrote: > I run gnucash on Linux with a sqlite3 database. > > Although the Help says the log file preferences only apply when using > XML I still get log files saved every time I quit gnucash. So, a > couple of questions:- > > Should this happen (log files with sqlite)? > > Can I get the log files stored somewhere else to avoid cluttering > the directory where I keep my accounts? > > Are the log files any use with sqlite or should I simply turn them > off completely in preferences? > > -- > 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] Log file preferences (using sqlite)
Not sure if this helps, but I'm also using the SQLite backend and while I do have some log files, they are few in number. I don't usually pay much attention to that directory as it is somewhat buried in my tree and don't otherwise need it. (GnuCash opens the last used file, and I can't even double-click to open since I'm on MacOS) I rarely shut down GnuCash and usually leave it open 24/7 save for updates to either it, or MacOS. Other than shutdowns, perhaps eventually it writes a log after so many transactions. I use it daily, and see 19 log files of varying sizes between 10/6/20 and 1/15/21. (with nothing since then) Regards, Adrien On 2/2/21 5:33 PM, D. via gnucash-user wrote: Although I don't use the sqlite back end, I can answer that: 1) yes log files happen with the db back ends 2) no you can't change the log file directory (this is a long long long standing request) 3) not sure, but probably you could Original Message From: Chris Green Sent: Tue Feb 02 09:56:15 EST 2021 To: gnucash-user@gnucash.org Subject: [GNC] Log file preferences (using sqlite) I run gnucash on Linux with a sqlite3 database. Although the Help says the log file preferences only apply when using XML I still get log files saved every time I quit gnucash. So, a couple of questions:- Should this happen (log files with sqlite)? Can I get the log files stored somewhere else to avoid cluttering the directory where I keep my accounts? Are the log files any use with sqlite or should I simply turn them off completely in preferences? ___ 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] Log file preferences (using sqlite)
Although I don't use the sqlite back end, I can answer that: 1) yes log files happen with the db back ends 2) no you can't change the log file directory (this is a long long long standing request) 3) not sure, but probably you could Original Message From: Chris Green Sent: Tue Feb 02 09:56:15 EST 2021 To: gnucash-user@gnucash.org Subject: [GNC] Log file preferences (using sqlite) I run gnucash on Linux with a sqlite3 database. Although the Help says the log file preferences only apply when using XML I still get log files saved every time I quit gnucash. So, a couple of questions:- Should this happen (log files with sqlite)? Can I get the log files stored somewhere else to avoid cluttering the directory where I keep my accounts? Are the log files any use with sqlite or should I simply turn them off completely in preferences? -- 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.
