Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-22 Thread brad
On ubuntu linux the X shuts it down cleanly. On 4/21/22 06:36, Derek Atkins wrote: On Thu, April 21, 2022 8:11 am, Chris Green wrote: On Thu, Apr 21, 2022 at 08:07:03AM -0400, Derek Atkins wrote: GnuCash deletes the LNK files when it shuts down cleanly. If they still exist, that means either

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-22 Thread Frank H. Ellenberger
Hi, just forcompleteness Am 21.04.22 um 22:31 schrieb John Ralls: > Linux has had extended attributes since 2002, but they never really caught on > and the XDG MIME database relies on file globs--which for practical purposes > means file extensions--to determine what program to launch when a

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread John Ralls
Before Macintosh programs worked by passing a data file name as a parameter to the program you wanted to start or by using an "open" command once you'd started the program. The Macintosh introduced Graphical User Interfaces to the general public and included the ability to click on a file in

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Geert Janssens
Op donderdag 21 april 2022 19:08:14 CEST schreef William Prescott: > In my experience, on MacOS, double-clicking on a Gnucash file opens Gnucash > but not necessarily with the file that was double-clicked. Gnucash will > open with whatever was the last file used. > > So, on MacOS, the suffix is

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Chris Green
On Thu, Apr 21, 2022 at 12:08:14PM -0500, William Prescott wrote: > In my experience, on MacOS, double-clicking on a Gnucash file opens Gnucash > but not necessarily with the file that was double-clicked. Gnucash will > open with whatever was the last file used. > > So, on MacOS, the suffix is

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread William Prescott
In my experience, on MacOS, double-clicking on a Gnucash file opens Gnucash but not necessarily with the file that was double-clicked. Gnucash will open with whatever was the last file used. So, on MacOS, the suffix is useful, sort of. But it is not handled the way most applications handle

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread David Carlson
Somewhere I lost track of the reasoning to save a file under a filename without an extension. Since there has never been a standard method to assign an extended attribute for filetype that, unlike file extensions, is consistent over all common file storage formats, in my opinion it would still be

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Bert Riding
On Thu, 21 Apr 2022 18:08:47 +0100 Chris Green wrote: > On Thu, Apr 21, 2022 at 06:54:11PM +0200, Geert Janssens wrote: > > Op donderdag 21 april 2022 16:36:36 CEST schreef Bert Riding: > > > On Thu, 21 Apr 2022 08:45:20 +0100 > > > > > > Chris Green wrote: > > > > On Wed, Apr 20, 2022 at

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Derek Atkins
On Thu, April 21, 2022 1:08 pm, Chris Green wrote: > > However this all begs the question. *How* do I get GnuCash to save a > file without a file extension? As I said back up this thread > somewhere it insists on adding ".gnucash" whatever I do to try and > discourage it. > > Are people who

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Chris Green
On Thu, Apr 21, 2022 at 06:54:11PM +0200, Geert Janssens wrote: > Op donderdag 21 april 2022 16:36:36 CEST schreef Bert Riding: > > On Thu, 21 Apr 2022 08:45:20 +0100 > > > > Chris Green wrote: > > > On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote: > > > > > On Apr 20, 2022, at 1:58 AM, Liz

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Geert Janssens
Op donderdag 21 april 2022 16:36:36 CEST schreef Bert Riding: > On Thu, 21 Apr 2022 08:45:20 +0100 > > Chris Green wrote: > > On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote: > > > > On Apr 20, 2022, at 1:58 AM, Liz wrote: > > > > > > > > On Wed, 20 Apr 2022 09:02:16 +0100 > > > > > > >

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Bert Riding
On Thu, 21 Apr 2022 08:45:20 +0100 Chris Green wrote: > On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote: > > > > > > > On Apr 20, 2022, at 1:58 AM, Liz wrote: > > > > > > On Wed, 20 Apr 2022 09:02:16 +0100 > > > Chris Green wrote: > > > > > >> On Tue, Apr 19, 2022 at 09:20:56PM

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread David T. via gnucash-user
On 4/21/2022 8:07 AM, Derek Atkins wrote: HI, On Thu, April 21, 2022 7:57 am, Chris Green wrote: On Thu, Apr 21, 2022 at 07:20:51PM +1000,davidcousen...@gmail.com wrote: Chris, [snip] If I look in (one of) my Gnucash directories I see:- chris@esprimo$ ls building2022.gnucash

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Derek Atkins
On Thu, April 21, 2022 8:11 am, Chris Green wrote: > On Thu, Apr 21, 2022 at 08:07:03AM -0400, Derek Atkins wrote: >> GnuCash deletes the LNK files when it shuts down cleanly. If they still >> exist, that means either GnuCash is running with those files open, or >> GnuCash was NOT shut down

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Chris Green
On Thu, Apr 21, 2022 at 08:07:03AM -0400, Derek Atkins wrote: > GnuCash deletes the LNK files when it shuts down cleanly. If they still > exist, that means either GnuCash is running with those files open, or > GnuCash was NOT shut down cleanly when they had those files open. In the > latter

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Derek Atkins
HI, On Thu, April 21, 2022 7:57 am, Chris Green wrote: > On Thu, Apr 21, 2022 at 07:20:51PM +1000, davidcousen...@gmail.com wrote: >> Chris, >> [snip] > If I look in (one of) my Gnucash directories I see:- > > chris@esprimo$ ls > building2022.gnucash >

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Chris Green
On Thu, Apr 21, 2022 at 07:20:51PM +1000, davidcousen...@gmail.com wrote: > Chris, > > In around 12 years of using GnuCash on Linux, I could probably count on one > hand > the number of times I have had to type in the full filename and extension or > even search for the location of GnuCash data

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread davidcousens49
Chris, In around 12 years of using GnuCash on Linux, I could probably count on one hand the number of times I have had to type in the full filename and extension or even search for the location of GnuCash data files. At least with the ".gnucash" extension there is little chance of a clash with

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-21 Thread Chris Green
On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote: > > > > On Apr 20, 2022, at 1:58 AM, Liz wrote: > > > > On Wed, 20 Apr 2022 09:02:16 +0100 > > Chris Green wrote: > > > >> On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: > > 1. Is there any way to get GnuCash to

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread john
> On Apr 20, 2022, at 1:58 AM, Liz wrote: > > On Wed, 20 Apr 2022 09:02:16 +0100 > Chris Green wrote: > >> On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: 1. Is there any way to get GnuCash to save its file, by default, with an appropriate suffix other than

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread Chris Green
On Wed, Apr 20, 2022 at 06:58:30PM +1000, Liz wrote: > On Wed, 20 Apr 2022 09:02:16 +0100 > Chris Green wrote: > > > On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: > > > > > > > > 1. Is there any way to get GnuCash to save its file, by default, > > > > with an appropriate suffix

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread Tom Browder
On Tue, Apr 19, 2022 at 20:20 Derek Atkins wrote: > Hi, > ... Thanks much, Derek. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread Liz
On Wed, 20 Apr 2022 09:02:16 +0100 Chris Green wrote: > On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: > > > > > > 1. Is there any way to get GnuCash to save its file, by default, > > > with an appropriate suffix other than "gnucash?" > > > > Sure, tell it to do that. It only

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread Chris Green
On Tue, Apr 19, 2022 at 10:59:04PM -0500, David Carlson wrote: > I would like to add a question to Tom's list. Is there any way to easily > make periodic backups of SQLite data files? > The same as you back up any files! :-) I just run incremental backups of all important/significant files in

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-20 Thread Chris Green
On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: > > > > 1. Is there any way to get GnuCash to save its file, by default, with an > > appropriate suffix other than "gnucash?" > > Sure, tell it to do that. It only adds ".gnucash" by default, but it > won't override what you tell it.

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-19 Thread William Prescott
Unlike —real— databases, SQLite files are just ordinary files. You can copy and move them like any other file. So they can be backed up with a simple copy. Will On 2022 Apr 19, at 04-19 22:59:04, David Carlson wrote: I would like to add a question to Tom's list. Is there any way to easily

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-19 Thread David Carlson
I would like to add a question to Tom's list. Is there any way to easily make periodic backups of SQLite data files? On Tue, Apr 19, 2022 at 8:21 PM Derek Atkins wrote: > Hi, > > On Tue, April 19, 2022 7:55 pm, Tom Browder wrote: > > I just updated my MS Windows GnuCash version to 4.10 and see

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-19 Thread Derek Atkins
Hi, On Tue, April 19, 2022 7:55 pm, Tom Browder wrote: > I just updated my MS Windows GnuCash version to 4.10 and see the new > option > to save my GnuCash xml file in SQLite format. In general, I like it! > > However, I had a few moments of panic when Windows wanted to save the file > without a

[GNC] New to GnuCash SQLite on Windows: I have questions

2022-04-19 Thread Tom Browder
I just updated my MS Windows GnuCash version to 4.10 and see the new option to save my GnuCash xml file in SQLite format. In general, I like it! However, I had a few moments of panic when Windows wanted to save the file without a name change. I also forgot the changes in the SQLite file are done