Re: [GNC] new to Gnucash - help with general information
Donna, Others have sufficiently answered, but I'll add some points about backups: There is the maxim, for least risk, that if your data does not exist in three places, on three different types of media, you can consider it 'not existing at all.' That might be extreme for some folks. As noted, your appetite for risk will determine your backup strategy and methods. If you have your data on your computer, that's one location and one type of media. (the internal drive most likely) If you make a copy on removable media like a USB drive, (larger drive, or thumb/key) that's another, but for better protection this should be stored at a different physical location. (or easily taken with you if you must leave the main location of your computer for some emergency) On this point, do not confound a laptop as a main computer with this second location because it is portable. You should have at least one other copy. If you then also utilize a cloud (just someone else's computer) backup service, this gives you a third location. Cloud Backup services, due to the nature of their product, *also* backup their/your data, and use methods to avoid data loss due to failed drives. (data centers employ arrays of drives, they constantly test their drives, and the replace them regularly - far more than 99.% of regular users do) As for *types* of media, consider that your computer and any external/removable drives will employ magnetic storage and contain electronics. These are susceptible to of course, strong magnets, electrical surges, water, & fire damage. While not as common these days, optical media, such as CD, DVD, & BlueRay, while of course still susceptible to fire damage, have no issues with water or magnets. (or other electronic failure) Though the drive needed to read them will be vulnerable, it is of course more replaceable than your data. There are 'archival' quality discs available for long term storage. I probably wouldn't go to that expense for 'current' financial data, but I certainly would consider it for things like photos and scanned legal documents. More transient backups, like my GnuCash data file, are fine on cheap CDs or DVDs. (the choice there is just a matter of storage capacity versus cost) Regards, Adrien On 9/10/22 1:37 PM, gra...@shaw.ca wrote: I am new to Gnucash and have a few questions regarding saving data. I use Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25) 1. I would like to save everything in one folder named Gnucash. I think I will use the xml format. Currently it seems there are files in three different folders. How do I make sure to save everything to one folder? 2. Can I move everything I have (which is in 3 different folders) to a folder named Gnucash without harm to the data I have entered. (I previously had entered data for 2021, then deleted a bunch of files and most of the data disappeared. The file types were text and gnucash financial data) 3. How long do you need to keep the different files? Are there certain files needed to keep the data in the Gnucash system? I have looked at the FAQ but still not clear. 4. When you click the save button when entering transactions, how do you know where it is being saved to? I'd like it to be saved in Gnucash folder, as indicated above. 5. Back ups - I have read a lot about the back ups but still unsure what to do. Any suggestions would be appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to Gnucash - help with general information
You make a good point Fred, and I have seen people on this list who keep their GnuCash data in the cloud too. Although this changes the risk profile, it does not eliminate the need for a backup system. Regards Geoff = On 12/09/2022 5:07 am, Fred Bone wrote: On 11 September 2022 at 9:59, Michael or Penny Novack said: 5. Geoff is also correct here that gnucash saves backup so you don't lose data, but backuping up to another media is always a good idea. And asking this question "how do I back-up my gnucash data?" implies a more serious misunderstanding about using your computer. It isn't just just gnucash data that needs to be backed up but ALL your user data. And if you have adopted a plan to back up ALL your user data, gnucash data would be included in that, so no need to have a back-up plan specific to gnucash. You do realise that these days many people do all their email via webmail, and all their word processing, spreadsheets and so on on Google Docs or suchlike "in the cloud", and may find that Gnucash is the only application that keeps their data locally? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to Gnucash - help with general information
On 11 September 2022 at 9:59, Michael or Penny Novack said: > > >5. Geoff is also correct here that gnucash saves backup so you don't > >lose data, but backuping up to another media is always a good idea. > > > And asking this question "how do I back-up my gnucash data?" implies a > more serious misunderstanding about using your computer. It isn't just > just gnucash data that needs to be backed up but ALL your user data. And > if you have adopted a plan to back up ALL your user data, gnucash data > would be included in that, so no need to have a back-up plan specific to > gnucash. You do realise that these days many people do all their email via webmail, and all their word processing, spreadsheets and so on on Google Docs or suchlike "in the cloud", and may find that Gnucash is the only application that keeps their data locally? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to Gnucash - help with general information
5. Geoff is also correct here that gnucash saves backup so you don't lose data, but backuping up to another media is always a good idea. And asking this question "how do I back-up my gnucash data?" implies a more serious misunderstanding about using your computer. It isn't just just gnucash data that needs to be backed up but ALL your user data. And if you have adopted a plan to back up ALL your user data, gnucash data would be included in that, so no need to have a back-up plan specific to gnucash. It is not a matter of IF your hard drive or entire computer will fail but WHEN that will happen. And even if a failure hasn't happened yet, sooner or later you will be replacing your computer with a newer one. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to Gnucash - help with general information
There has been discussion here in the past about how to save backups of the information that GnuCash saves in other folders. I do not recall there being a nice answer for users that wish it was all in one folder. That information does not change much after the first year or two so eventually a quarterly manual copy to some backup folder suffices for most users. On Sat, Sep 10, 2022, 9:44 PM Gyle McCollam wrote: > Donna, > I use the same Gnucash, but Windows 11. 1st, let me say that Geoff info > was helpful. There are several folders on my system for gnucash, but all > the data and backups reside in gnucash in my documents folder. There are > other files associated with gnucash that it puts in other places that I > would not put in my main data files location. When you say you have files > in 3 locations, which files are you referring to? > > your questions: > > 1. gnucash saves all data files in one location by default. This > includes your main data file, as .gnucash. The log files that Goeff > mentioned .gnucash.datetime.log and the lock file he mentioned > .gnucash.LCK. > 2. As long as you didn't delete the .gnucash or any newer log files > you should have been OK, but you probably deleted your current file and > that is why you lost data. > 3. In the "Edit/Preferences/General", there is an Auto Save time > Interval that you can set for it to create backups and a "Retain > log/backups" for the number of days to save these backups. This way it can > do the deletions for you automatically and you don't have to worry about > what files you are deleting. > 4. As Geoff said it will save the file to the same place it was > retrieved from, unless you use "save as" and specify a different location. > 5. Geoff is also correct here that gnucash saves backup so you don't > lose data, but backuping up to another media is always a good idea. > > Another helpful place to look is in "Help/Tutorial and Concepts Guide". > In the search box type "backing up and recovering data" enter and it will > take you to the page explaining how to restore and helpful information > about how every thing works. > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > ____ > From: gnucash-user on > behalf of gra...@shaw.ca > Sent: Saturday, September 10, 2022 2:37 PM > To: gnucash-user@gnucash.org > Subject: [GNC] new to Gnucash - help with general information > > I am new to Gnucash and have a few questions regarding saving data. I use > Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25) > > 1. I would like to save everything in one folder named Gnucash. I > think I will use the xml format. Currently it seems there are files in > three different folders. > How do I make sure to save everything to one folder? > > 2. Can I move everything I have (which is in 3 different folders) to a > folder named Gnucash without harm to the data I have entered. (I > previously > had entered data for 2021, then deleted a bunch of files and most of the > data disappeared. The file types were text and gnucash financial data) > > 3. How long do you need to keep the different files? > Are there certain files needed to keep the data in the Gnucash system? I > have looked at the FAQ but still not clear. > > 4. When you click the save button when entering transactions, how do > you know where it is being saved to? I'd like it to be saved in Gnucash > folder, as indicated above. > > 5. Back ups - I have read a lot about the back ups but still unsure > what to do. Any suggestions would be appreciated. > > Thanks all > Donna > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to Gnucash - help with general information
Donna, I use the same Gnucash, but Windows 11. 1st, let me say that Geoff info was helpful. There are several folders on my system for gnucash, but all the data and backups reside in gnucash in my documents folder. There are other files associated with gnucash that it puts in other places that I would not put in my main data files location. When you say you have files in 3 locations, which files are you referring to? your questions: 1. gnucash saves all data files in one location by default. This includes your main data file, as .gnucash. The log files that Goeff mentioned .gnucash.datetime.log and the lock file he mentioned .gnucash.LCK. 2. As long as you didn't delete the .gnucash or any newer log files you should have been OK, but you probably deleted your current file and that is why you lost data. 3. In the "Edit/Preferences/General", there is an Auto Save time Interval that you can set for it to create backups and a "Retain log/backups" for the number of days to save these backups. This way it can do the deletions for you automatically and you don't have to worry about what files you are deleting. 4. As Geoff said it will save the file to the same place it was retrieved from, unless you use "save as" and specify a different location. 5. Geoff is also correct here that gnucash saves backup so you don't lose data, but backuping up to another media is always a good idea. Another helpful place to look is in "Help/Tutorial and Concepts Guide". In the search box type "backing up and recovering data" enter and it will take you to the page explaining how to restore and helpful information about how every thing works. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of gra...@shaw.ca Sent: Saturday, September 10, 2022 2:37 PM To: gnucash-user@gnucash.org Subject: [GNC] new to Gnucash - help with general information I am new to Gnucash and have a few questions regarding saving data. I use Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25) 1. I would like to save everything in one folder named Gnucash. I think I will use the xml format. Currently it seems there are files in three different folders. How do I make sure to save everything to one folder? 2. Can I move everything I have (which is in 3 different folders) to a folder named Gnucash without harm to the data I have entered. (I previously had entered data for 2021, then deleted a bunch of files and most of the data disappeared. The file types were text and gnucash financial data) 3. How long do you need to keep the different files? Are there certain files needed to keep the data in the Gnucash system? I have looked at the FAQ but still not clear. 4. When you click the save button when entering transactions, how do you know where it is being saved to? I'd like it to be saved in Gnucash folder, as indicated above. 5. Back ups - I have read a lot about the back ups but still unsure what to do. Any suggestions would be appreciated. Thanks all Donna ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] new to Gnucash - help with general information
I am new to Gnucash and have a few questions regarding saving data. I use Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25) 1. I would like to save everything in one folder named Gnucash. I think I will use the xml format. Currently it seems there are files in three different folders. How do I make sure to save everything to one folder? 2. Can I move everything I have (which is in 3 different folders) to a folder named Gnucash without harm to the data I have entered. (I previously had entered data for 2021, then deleted a bunch of files and most of the data disappeared. The file types were text and gnucash financial data) 3. How long do you need to keep the different files? Are there certain files needed to keep the data in the Gnucash system? I have looked at the FAQ but still not clear. 4. When you click the save button when entering transactions, how do you know where it is being saved to? I'd like it to be saved in Gnucash folder, as indicated above. 5. Back ups - I have read a lot about the back ups but still unsure what to do. Any suggestions would be appreciated. Thanks all Donna ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New to GnuCash SQLite on Windows: I have questions
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 GnuCash is running with those files open, or GnuCash was NOT shut down cleanly when they had those files open. In the latter case, either you used the [x] to close it, or shut down the You mean I'm not supposed to use th X (top right in window) when I close down GnuCash! Every other program I have ever used shuts down cleanly when one does this! That very much depends on the OS and Window Manager. Sometimes it does, but sometimes it forcibly quits the application and doesn't allow it to shut down cleanly. Is it really that hard to File -> Quit (or Cntl-Q) instead of using the [x]? Have you never noticed the "File is already in use" messages? Chris Green Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek ___ 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] New to GnuCash SQLite on Windows: I have questions
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 user tries > to open a data file. In theory there is a "file magic". For uncompressed XML file you can check for the begin: 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] New to GnuCash SQLite on Windows: I have questions
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 the file system browser (it introduced the file system browser too) and have that file's associated program launch. It used a filesystem attribute called a resource fork that contained information about the program that created it. Microsoft Windows before WindowsNT was a graphical shell on their rather minimal MSDOS operating system whose very simple filesystem couldn't handle extended attributes so they based their similar capability on file extensions. 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 user tries to open a data file. Apple started moving away from resource forks around 2010 and removed Launch Services ability to use them to determine the program around 2012. GnuCash itself doesn't care a bit about what you name your file, but launching GnuCash by double-clicking on a book filename/icon on the desktop or file system browser depends on using the .gnucash extension on all current OSes. To facilitate that working in GnuCash Geert wrote https://bugs.gnucash.org/show_bug.cgi?id=615347 and fixed it with https://github.com/Gnucash/gnucash/commit/06489439f64b6cf0510828c2907e658ab900c5f7 12 years ago. Regards, John Ralls > On Apr 21, 2022, at 10:56 AM, David Carlson > wrote: > > 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 very confusing if there were no extensions. As for depending on > the name of the folder for that type of information, I just discovered that > a month ago I misfiled a few PDF's in a folder that is not intended to > contain any such files. I only found them by accident when I was looking > for something else. Oh, remember OS/2 Warp? > > On Thu, Apr 21, 2022 at 12:26 PM Bert Riding wrote: > >> 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 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 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. > > Where do you tell it that? "Save As" in the menu should do it. >>> >>> Be careful to switch back to the "primary" file after doing >>> that, otherwise the primary will become the snapshot and new >>> work will go into the new file. >> >> But that's the ultimate aim! :- >> >> Instead of having the long, clumsy, "gnucash" suffix one wants >> something tidier like "gc". >> >> Remember on Linux the whole filename is always displayed so all >> those "gnucash" suffixes get a bit wearing after a while. > > In my experience gnucash doesn't care what your data file is > called, with or without any suffix you care to use. Personally I > use none. Once you have opened the file and gnucash knows of it, > it will show up in the recents list automatically. True. GnuCash doesn't care. However operating system file managers in general do care. They use the extension to figure out which application to launch when you double-click a file. But if you don't use that feature (and many don't with GnuCash as it remembers which file you last opened) you're ok without file extension. >>> 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 say they save without an extension just seeing the >>> Windows default of not showing extensions maybe? >>> >> >> If I need to make a new file, I save it in gnucash and it gets the >> .gnucash extension. I close the file, rename it without an extension, >> then
Re: [GNC] New to GnuCash SQLite on Windows: I have questions
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 useful, sort of. But it is not handled the way > most applications handle double-clicked files. > > Will Yes that's true. It is due to how Macos handles passing files to open to the launched application. This is completely different from how it works on linux and nobody so far has found the time or energy to fix the gnucash code to make it work as expected on Macos as well. That aside your comment still shows on Macos the file extension is used to determine gnucash needs to be launched. Without the file extension, Macos would not do that. Regards, Geert ___ 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] New to GnuCash SQLite on Windows: I have questions
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 useful, sort of. But it is not handled the > way most applications handle double-clicked files. > I have several GnuCash databases for different accounts. E.g. I have 2022General, 2022Buildings, 2021General and so on. Thus I just about always want to specify the database filename when I run GnuCash. I also just about always start GnuCash from the command line in a terminal window, I don't like screens cluttered with icons. So my ideal is files simple called 2022General, 2022Buildings or whatever with no, or at least a minimal suffix. -- 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] New to GnuCash SQLite on Windows: I have questions
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 double-clicked files. Will On 2022 Apr 21, at 04-21 11:54:11, 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 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 "gnucash?" >> >> Sure, tell it to do that. It only adds ".gnucash" by default, >> but it won't override what you tell it. > > Where do you tell it that? "Save As" in the menu should do it. >>> >>> Be careful to switch back to the "primary" file after doing that, >>> otherwise the primary will become the snapshot and new work will go >>> into the new file. >> >> But that's the ultimate aim! :- >> >> Instead of having the long, clumsy, "gnucash" suffix one wants >> something tidier like "gc". >> >> Remember on Linux the whole filename is always displayed so all those >> "gnucash" suffixes get a bit wearing after a while. > > In my experience gnucash doesn't care what your data file is called, > with or without any suffix you care to use. Personally I use none. > Once you have opened the file and gnucash knows of it, it will show up > in the recents list automatically. True. GnuCash doesn't care. However operating system file managers in general do care. They use the extension to figure out which application to launch when you double-click a file. But if you don't use that feature (and many don't with GnuCash as it remembers which file you last opened) you're ok without file extension. Regards, Geert ___ 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] New to GnuCash SQLite on Windows: I have questions
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 very confusing if there were no extensions. As for depending on the name of the folder for that type of information, I just discovered that a month ago I misfiled a few PDF's in a folder that is not intended to contain any such files. I only found them by accident when I was looking for something else. Oh, remember OS/2 Warp? On Thu, Apr 21, 2022 at 12:26 PM Bert Riding wrote: > 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 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 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. > > > > > > >> > > > > > > >> Where do you tell it that? > > > > > > > > > > > > > > "Save As" in the menu should do it. > > > > > > > > > > > > Be careful to switch back to the "primary" file after doing > > > > > > that, otherwise the primary will become the snapshot and new > > > > > > work will go into the new file. > > > > > > > > > > But that's the ultimate aim! :- > > > > > > > > > > Instead of having the long, clumsy, "gnucash" suffix one wants > > > > > something tidier like "gc". > > > > > > > > > > Remember on Linux the whole filename is always displayed so all > > > > > those "gnucash" suffixes get a bit wearing after a while. > > > > > > > > In my experience gnucash doesn't care what your data file is > > > > called, with or without any suffix you care to use. Personally I > > > > use none. Once you have opened the file and gnucash knows of it, > > > > it will show up in the recents list automatically. > > > > > > True. GnuCash doesn't care. However operating system file managers > > > in general do care. They use the extension to figure out which > > > application to launch when you double-click a file. But if you > > > don't use that feature (and many don't with GnuCash as it remembers > > > which file you last opened) you're ok without file extension. > > 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 say they save without an extension just seeing the > > Windows default of not showing extensions maybe? > > > > If I need to make a new file, I save it in gnucash and it gets the > .gnucash extension. I close the file, rename it without an extension, > then open it by using the Open dialog under File or by directly calling > gnucash from the command line with the new filename as a parameter. > > I use linux/X, YMMV. > > -- > Bert Riding > rerid...@xmission.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. > -- David Carlson ___ 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] New to GnuCash SQLite on Windows: I have questions
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 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 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. > > > > > >> > > > > > >> Where do you tell it that? > > > > > > > > > > > > "Save As" in the menu should do it. > > > > > > > > > > Be careful to switch back to the "primary" file after doing > > > > > that, otherwise the primary will become the snapshot and new > > > > > work will go into the new file. > > > > > > > > But that's the ultimate aim! :- > > > > > > > > Instead of having the long, clumsy, "gnucash" suffix one wants > > > > something tidier like "gc". > > > > > > > > Remember on Linux the whole filename is always displayed so all > > > > those "gnucash" suffixes get a bit wearing after a while. > > > > > > In my experience gnucash doesn't care what your data file is > > > called, with or without any suffix you care to use. Personally I > > > use none. Once you have opened the file and gnucash knows of it, > > > it will show up in the recents list automatically. > > > > True. GnuCash doesn't care. However operating system file managers > > in general do care. They use the extension to figure out which > > application to launch when you double-click a file. But if you > > don't use that feature (and many don't with GnuCash as it remembers > > which file you last opened) you're ok without file extension. > 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 say they save without an extension just seeing the > Windows default of not showing extensions maybe? > If I need to make a new file, I save it in gnucash and it gets the .gnucash extension. I close the file, rename it without an extension, then open it by using the Open dialog under File or by directly calling gnucash from the command line with the new filename as a parameter. I use linux/X, YMMV. -- Bert Riding rerid...@xmission.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] New to GnuCash SQLite on Windows: I have questions
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 say they save without an extension just seeing the > Windows default of not showing extensions maybe? I honestly have not saved a new data file in over a decade. So my data files exist without an extension, and current GnuCash is happy with that. If I really cared (which I don't), what I would do now is save the file the first time, then rename it in the file system, and then open it under the new name without the extension. I'll note that I am FAIRLY sure that, e.g. Word does not allow you to save without an extension. > Chris Green > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] New to GnuCash SQLite on Windows: I have questions
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 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 "gnucash?" > > > > >>> > > > > >>> Sure, tell it to do that. It only adds ".gnucash" by default, > > > > >>> but it won't override what you tell it. > > > > >> > > > > >> Where do you tell it that? > > > > > > > > > > "Save As" in the menu should do it. > > > > > > > > Be careful to switch back to the "primary" file after doing that, > > > > otherwise the primary will become the snapshot and new work will go > > > > into the new file. > > > > > > But that's the ultimate aim! :- > > > > > > Instead of having the long, clumsy, "gnucash" suffix one wants > > > something tidier like "gc". > > > > > > Remember on Linux the whole filename is always displayed so all those > > > "gnucash" suffixes get a bit wearing after a while. > > > > In my experience gnucash doesn't care what your data file is called, > > with or without any suffix you care to use. Personally I use none. > > Once you have opened the file and gnucash knows of it, it will show up > > in the recents list automatically. > > True. GnuCash doesn't care. However operating system file managers in general > do care. > They use the extension to figure out which application to launch when you > double-click a file. > But if you don't use that feature (and many don't with GnuCash as it > remembers which file > you last opened) you're ok without file extension. > 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 say they save without an extension just seeing the Windows default of not showing extensions maybe? -- 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] New to GnuCash SQLite on Windows: I have questions
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 > > > > > > > > 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 adds ".gnucash" by default, > > > >>> but it won't override what you tell it. > > > >> > > > >> Where do you tell it that? > > > > > > > > "Save As" in the menu should do it. > > > > > > Be careful to switch back to the "primary" file after doing that, > > > otherwise the primary will become the snapshot and new work will go > > > into the new file. > > > > But that's the ultimate aim! :- > > > > Instead of having the long, clumsy, "gnucash" suffix one wants > > something tidier like "gc". > > > > Remember on Linux the whole filename is always displayed so all those > > "gnucash" suffixes get a bit wearing after a while. > > In my experience gnucash doesn't care what your data file is called, > with or without any suffix you care to use. Personally I use none. > Once you have opened the file and gnucash knows of it, it will show up > in the recents list automatically. True. GnuCash doesn't care. However operating system file managers in general do care. They use the extension to figure out which application to launch when you double-click a file. But if you don't use that feature (and many don't with GnuCash as it remembers which file you last opened) you're ok without file extension. Regards, Geert ___ 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] New to GnuCash SQLite on Windows: I have questions
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 -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. > > >>> > > >> Where do you tell it that? > > >> > > > > > > "Save As" in the menu should do it. > > > > Be careful to switch back to the "primary" file after doing that, > > otherwise the primary will become the snapshot and new work will go > > into the new file. > > > But that's the ultimate aim! :- > > Instead of having the long, clumsy, "gnucash" suffix one wants > something tidier like "gc". > > Remember on Linux the whole filename is always displayed so all those > "gnucash" suffixes get a bit wearing after a while. > In my experience gnucash doesn't care what your data file is called, with or without any suffix you care to use. Personally I use none. Once you have opened the file and gnucash knows of it, it will show up in the recents list automatically. -- Bert Riding rerid...@xmission.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] New to GnuCash SQLite on Windows: I have questions
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 general2022.gnucash.-452605816.1384867.LNK building2022.gnucash.-452605816.1385351.LNK general2022.gnucash.-452605816.4124828.LNK cheques giftaid [snip] As an example of the sort of thing I would expect look at this:- chris@esprimo$ ls pcc Pass_Certificate.pdf 'TR takeaway Jeremiah.pdf' auditedAc2019.pdf SpiritualityOfFundraising.pdf Whoswho.docx parishReturn2019.pdf No long suffixes, obvious names and no backup/log files in the same directory. So you're complaining about 4 vs 7 characters in the suffix?? Seriously? As for the logs/backups, I certainly see the point of storing those in a "different" location, but ... where? Keep in mind, this is financial data, not some love-letter, so having an archive can be important. So we try very hard to ensure that we *CAN* make a backup, and the safest place to ensure that is in the same place the data file is written. But you're right, we *could* make a subdir, like "gnucash-backups" and store the files there. This is an outstanding feature request:https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1470507-configuration-option-for-backup-location ___ 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] New to GnuCash SQLite on Windows: I have questions
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 cleanly when they had those files open. In >> the >> latter case, either you used the [x] to close it, or shut down the > > You mean I'm not supposed to use th X (top right in window) when I > close down GnuCash! Every other program I have ever used shuts down > cleanly when one does this! That very much depends on the OS and Window Manager. Sometimes it does, but sometimes it forcibly quits the application and doesn't allow it to shut down cleanly. Is it really that hard to File -> Quit (or Cntl-Q) instead of using the [x]? Have you never noticed the "File is already in use" messages? > Chris Green > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] New to GnuCash SQLite on Windows: I have questions
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 case, either you used the [x] to close it, or shut down the You mean I'm not supposed to use th X (top right in window) when I close down GnuCash! Every other program I have ever used shuts down cleanly when one does this! -- 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] New to GnuCash SQLite on Windows: I have questions
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 > general2022.gnucash.-452605816.1384867.LNK > building2022.gnucash.-452605816.1385351.LNK > general2022.gnucash.-452605816.4124828.LNK > cheques giftaid > > (cheques and giftaid are my own directories) > > It really would be much tidier and nicer if those gnucash files had no > suffix at > all, it's not necessary, especially in Linux. Secondly it would be much > nicer > if the place wasn't littered wiht those .LNK files. 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 case, either you used the [x] to close it, or shut down the computer.. Regardless, you will find when you try to re-open those files that GnuCash will tell you that those files are "already open by another user". > As an example of the sort of thing I would expect look at this:- > > chris@esprimo$ ls pcc > Pass_Certificate.pdf 'TR takeaway Jeremiah.pdf' > auditedAc2019.pdf > SpiritualityOfFundraising.pdf Whoswho.docx > parishReturn2019.pdf > > No long suffixes, obvious names and no backup/log files in the same > directory. So you're complaining about 4 vs 7 characters in the suffix?? Seriously? As for the logs/backups, I certainly see the point of storing those in a "different" location, but ... where? Keep in mind, this is financial data, not some love-letter, so having an archive can be important. So we try very hard to ensure that we *CAN* make a backup, and the safest place to ensure that is in the same place the data file is written. But you're right, we *could* make a subdir, like "gnucash-backups" and store the files there. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] New to GnuCash SQLite on Windows: I have questions
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 files. At least with the > ".gnucash" > extension there is little chance of a clash with another developers use of the > same 2-3 letter extension. Compared with the datetime stamp on the log and > backup files its not too much of a problem, just stretch the terminal or file > manager window out to the right. I am spoiled for screen real estate with > 2x27" > screen side by side which might be a mitigating factor for me. > Quite! But the suffix still makes filenames much longer than necessary. I don't "even search for the location of GnuCash data files", but I do occasionally look at the contents of directories and want to tidy them up. If I look in (one of) my Gnucash directories I see:- chris@esprimo$ ls building2022.gnucash general2022.gnucash.-452605816.1384867.LNK building2022.gnucash.-452605816.1385351.LNK general2022.gnucash.-452605816.4124828.LNK cheques giftaid (cheques and giftaid are my own directories) It really would be much tidier and nicer if those gnucash files had no suffix at all, it's not necessary, especially in Linux. Secondly it would be much nicer if the place wasn't littered wiht those .LNK files. As an example of the sort of thing I would expect look at this:- chris@esprimo$ ls pcc Pass_Certificate.pdf 'TR takeaway Jeremiah.pdf' auditedAc2019.pdf SpiritualityOfFundraising.pdf Whoswho.docx parishReturn2019.pdf No long suffixes, obvious names and no backup/log files in the same directory. -- 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] New to GnuCash SQLite on Windows: I have questions
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 another developers use of the same 2-3 letter extension. Compared with the datetime stamp on the log and backup files its not too much of a problem, just stretch the terminal or file manager window out to the right. I am spoiled for screen real estate with 2x27" screen side by side which might be a mitigating factor for me. David Cousens On Thu, 2022-04-21 at 08:45 +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 -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. > > > > > > > > > Where do you tell it that? > > > > > > > > > > "Save As" in the menu should do it. > > > > Be careful to switch back to the "primary" file after doing that, otherwise > > the primary will become the snapshot and new work will go into the new > > file. > > > But that's the ultimate aim! :- > > Instead of having the long, clumsy, "gnucash" suffix one wants > something tidier like "gc". > > Remember on Linux the whole filename is always displayed so all those > "gnucash" suffixes get a bit wearing after a while. > ___ 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] New to GnuCash SQLite on Windows: I have questions
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 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. > >>> > >> Where do you tell it that? > >> > > > > "Save As" in the menu should do it. > > Be careful to switch back to the "primary" file after doing that, otherwise > the primary will become the snapshot and new work will go into the new > file. > But that's the ultimate aim! :- Instead of having the long, clumsy, "gnucash" suffix one wants something tidier like "gc". Remember on Linux the whole filename is always displayed so all those "gnucash" suffixes get a bit wearing after a while. -- 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] New to GnuCash SQLite on Windows: I have questions
> 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 "gnucash?" >>> >>> Sure, tell it to do that. It only adds ".gnucash" by default, but >>> it won't override what you tell it. >>> >> Where do you tell it that? >> > > "Save As" in the menu should do it. Be careful to switch back to the "primary" file after doing that, otherwise the primary will become the snapshot and new work will go into the new file. 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] New to GnuCash SQLite on Windows: I have questions
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 other than "gnucash?" > > > > > > Sure, tell it to do that. It only adds ".gnucash" by default, but > > > it won't override what you tell it. > > > > > Where do you tell it that? > > > > "Save As" in the menu should do it. > No it doesn't, I didn't think it did. If you "Save As", for example, 'fred.gc' what you get is a file called 'fred.gc.gnucash'. (This is on Linux by the way where filenames can have as many dots as you want in them) -- 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] New to GnuCash SQLite on Windows: I have questions
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: 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] New to GnuCash SQLite on Windows: I have questions
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 adds ".gnucash" by default, but > > it won't override what you tell it. > > > Where do you tell it that? > "Save As" in the menu should do it. Liz ___ 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] New to GnuCash SQLite on Windows: I have questions
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 my home directory and that includes GnuuCash's data files. -- 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] New to GnuCash SQLite on Windows: I have questions
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. > Where do you tell it that? -- 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] New to GnuCash SQLite on Windows: I have questions
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 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 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 without notice. >> (When I first started withGnuCash on Windows, I was able to unzip the xml >> file and save it unzipped as "myGnuCash.gnucash" successfully so I get >> version control over a text file for readable diffs.) >> >> 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. > >> 2. Is there any hope of some kind of "commit" button to use with the >> SQLite >> version? > > The benefit of the SQL backend is that it writes all changes when you > commit (enter) a transaction. So no, there will not be a "Save" button. > The "commit" button is the "Enter" key (or exiting out of a transaction > edit). > >> 3. I assume the binary SQLite file is usable with a binary copy from >> Windows, is that true? > > I'm not sure I understand this question, but the SQLite data file is > usable from any platform. > >> 4. Is there any Perl program on Windows to convert the xml file to > SQLite? >> Is there one on Linux? > > No. Open the XML in GnuCash and then File -> Save As to save it as SQLite. > >> My immediate goal is to continue using my xml fille on Windows as the >> master data source until I'm comfortable with the SQLite version. During >> that time, I will periodically produce an SQLite version as a read-only >> one >> to experiment with on Linux. >> >> I would love to do that automatically. > > You mean without using File -> Save As? > >> I have briefly looked at the (ugh) Python support and may go down that >> route, but not until I've looked at compiling from github on Linux and >> looked at what's available. > > Yes, you may be able to use the Python bindings to open the XML file and > SaveAs SQL. I've never tried it. > >> Thanks for any help or suggestions. >> >> -Tom > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > > ___ > 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. > -- David Carlson ___ 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] New to GnuCash SQLite on Windows: I have questions
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 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 without notice. > > (When I first started withGnuCash on Windows, I was able to unzip the xml > > file and save it unzipped as "myGnuCash.gnucash" successfully so I get > > version control over a text file for readable diffs.) > > > > 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. > > > 2. Is there any hope of some kind of "commit" button to use with the > > SQLite > > version? > > The benefit of the SQL backend is that it writes all changes when you > commit (enter) a transaction. So no, there will not be a "Save" button. > The "commit" button is the "Enter" key (or exiting out of a transaction > edit). > > > 3. I assume the binary SQLite file is usable with a binary copy from > > Windows, is that true? > > I'm not sure I understand this question, but the SQLite data file is > usable from any platform. > > > 4. Is there any Perl program on Windows to convert the xml file to > SQLite? > > Is there one on Linux? > > No. Open the XML in GnuCash and then File -> Save As to save it as SQLite. > > > My immediate goal is to continue using my xml fille on Windows as the > > master data source until I'm comfortable with the SQLite version. During > > that time, I will periodically produce an SQLite version as a read-only > > one > > to experiment with on Linux. > > > > I would love to do that automatically. > > You mean without using File -> Save As? > > > I have briefly looked at the (ugh) Python support and may go down that > > route, but not until I've looked at compiling from github on Linux and > > looked at what's available. > > Yes, you may be able to use the Python bindings to open the XML file and > SaveAs SQL. I've never tried it. > > > Thanks for any help or suggestions. > > > > -Tom > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ > 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. > -- David Carlson ___ 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] New to GnuCash SQLite on Windows: I have questions
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 name change. I also forgot the changes in the SQLite file are > done without notice. > (When I first started withGnuCash on Windows, I was able to unzip the xml > file and save it unzipped as "myGnuCash.gnucash" successfully so I get > version control over a text file for readable diffs.) > > 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. > 2. Is there any hope of some kind of "commit" button to use with the > SQLite > version? The benefit of the SQL backend is that it writes all changes when you commit (enter) a transaction. So no, there will not be a "Save" button. The "commit" button is the "Enter" key (or exiting out of a transaction edit). > 3. I assume the binary SQLite file is usable with a binary copy from > Windows, is that true? I'm not sure I understand this question, but the SQLite data file is usable from any platform. > 4. Is there any Perl program on Windows to convert the xml file to SQLite? > Is there one on Linux? No. Open the XML in GnuCash and then File -> Save As to save it as SQLite. > My immediate goal is to continue using my xml fille on Windows as the > master data source until I'm comfortable with the SQLite version. During > that time, I will periodically produce an SQLite version as a read-only > one > to experiment with on Linux. > > I would love to do that automatically. You mean without using File -> Save As? > I have briefly looked at the (ugh) Python support and may go down that > route, but not until I've looked at compiling from github on Linux and > looked at what's available. Yes, you may be able to use the Python bindings to open the XML file and SaveAs SQL. I've never tried it. > Thanks for any help or suggestions. > > -Tom > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] New to GnuCash SQLite on Windows: I have questions
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 without notice. (When I first started withGnuCash on Windows, I was able to unzip the xml file and save it unzipped as "myGnuCash.gnucash" successfully so I get version control over a text file for readable diffs.) 1. Is there any way to get GnuCash to save its file, by default, with an appropriate suffix other than "gnucash?" 2. Is there any hope of some kind of "commit" button to use with the SQLite version? 3. I assume the binary SQLite file is usable with a binary copy from Windows, is that true? 4. Is there any Perl program on Windows to convert the xml file to SQLite? Is there one on Linux? My immediate goal is to continue using my xml fille on Windows as the master data source until I'm comfortable with the SQLite version. During that time, I will periodically produce an SQLite version as a read-only one to experiment with on Linux. I would love to do that automatically. I have briefly looked at the (ugh) Python support and may go down that route, but not until I've looked at compiling from github on Linux and looked at what's available. Thanks for any help or suggestions. -Tom ___ 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] new to gnucash
On 1/5/19 1:53 PM, Adrien Monteleone wrote: > Nothing counter-intuitive about it. It’s a matter of perspective. And remembering. I have to ask my wife each and every time -- even when I wrote my earlier reply! I'm thinking I need to hang a sign on the wall: DEBITS: Assets, Expenses CREDITS: Liabilities, Capital/Equity, Revenue Debits on the left side. Credits on the right side. Right side is toward the Kitchen! That last piece is just for me. Your kitchen might be someplace else. That just keeps me from picking the other right side. --Steve > > People are used to hearing the bank telling them that putting money in their > account is a ‘credit’ to their account. That’s correct for the bank, because > your account is their liability. Increasing a liability is done with a credit. > > But in your books, that account is an asset, which is increased by a debit. > > Regards, > Adrien > >> On Jan 5, 2019, at 10:57 AM, Michael Hendry wrote: >> >>> On 5 Jan 2019, at 16:41, Mike Kerstetter wrote: >>> >>> Hello all. I'm brand new to gnucash. I want it to do just the basics of >>> keeping a register and reconciliation of a couple bank and credit card >>> accounts. I had Money Sunset Deluxe and currently have Quicken (which is >>> now charging a yearly subscription). I'm muddling through setting up my >>> accounts and I am baffled at the seemingly backward credit and debit >>> columns in the register. A deposit to my Checking (or payment to my credit >>> card account) shows up under "DEBIT" and a charge to my accounts shows up >>> under "CREDIT". The balance is correct. Am I doing something wrong in my >>> set-up? >>> >>> Thanks, >>> >>> Mike Kerstetter >> Hi, Mike. >> >> Welcome to gnucash, and to the mysterious world of double-entry bookkeeping! >> >> No, you haven’t made a mistake, cash received by an account is regarded as a >> debit and cash paid as a credit. >> >> I’m not an accountant and I frequently have to chant “Debit the Receiver” to >> remind myself how it goes. >> >> No doubt one of the experts in the forum can point you in the direction of >> an explanation of this counter-intuitive situation, or you could try >> Googling. >> >> Michael >> >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- 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] new to gnucash
> From: Mike Kerstetter > To: gnucash-user@gnucash.org > > ... I am baffled at the seemingly backward credit and debit > columns in the register. A deposit to my Checking (or payment to my > credit card account) shows up under "DEBIT" and a charge to my accounts > shows up under "CREDIT".? The balance is correct. Am I doing something > wrong in my set-up? Hi, Mike. Welcome to GnuCash. You'll find it's quirky, and there are a significant number of bugs, but the developers are very responsive and the user community is super-helpful. Regarding debit and credit -- Americans especially are used to thinking of "credit good, debit bad", because when you get a credit on your Visa account that is favorable to you. But GnuCash treats debits and credits as accountants do, and IMHO that's a good thing -- it's one of the major factors in why I switched to GnuCash a year ago. Cash and bank accounts are among your assets, right? Well, to accountants an asset is a debit. A liability (such as your Visa account) is a credit, and your net worth (same as equity) is also a credit. Debits must always equal credits, and therefore Assets (Debits) = Liabilities + Equity (Credits) Income increases your net worth, which is a credit, and therefore income is also a credit. Expenses reduce your net worth, and therefore expenses are the opposite of credits, i.e. debits. That equation can be expanded a bit, to Assets (Debits) = Liability + Equity + (Income-Expenses) (credits) Let's say you owe $1800 on your Visa account. That's an $1800 credit balance on your books. If you pay $1100, you reduce your Visa balance (a credit) to $700, and therefore you are debiting your Visa balance by $1100. You are reducing your bank account (an asset, and therefore a debit) by $1100, and therefore you are crediting your bank account by $1100. When you return a $50 purchase, you're reducing (debiting) your Visa balance $50 and also reducing (crediting) an asset account or an expense account by $50. Why, then, do we think of "getting a credit" on our Visa account in that situation? Because, unknowingly, we're using the language from the viewpoint of the bank, not our own viewpoint. To the bank, your Visa balance is an asset, and therefore a debit. That $50 return reduces the amount you owe them, and therefore reduces their debit account, which makes it a credit on _their_ books. Their point of view is exactly opposite to yours, because transactions that increase their net worth reduce yours, and vice versa. Now, all of that said, though you haven't done anything wrong in your settings, you can set a preference to change "debits" and "credits" to "deposits" and "withdrawals" for your bank accounts, and make corresponding change for the other accounts. Under Edit » Preferences » Accounts, remove the tick mark for "use formal accounting labels". But now that you know how things work, you may not feel the need to change them. -- Regards, Stan Brown Tompkins County, New York, USA http://BrownMath.com http://OakRoadSystems.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] new to gnucash
Nothing counter-intuitive about it. It’s a matter of perspective. People are used to hearing the bank telling them that putting money in their account is a ‘credit’ to their account. That’s correct for the bank, because your account is their liability. Increasing a liability is done with a credit. But in your books, that account is an asset, which is increased by a debit. Regards, Adrien > On Jan 5, 2019, at 10:57 AM, Michael Hendry wrote: > >> On 5 Jan 2019, at 16:41, Mike Kerstetter wrote: >> >> Hello all. I'm brand new to gnucash. I want it to do just the basics of >> keeping a register and reconciliation of a couple bank and credit card >> accounts. I had Money Sunset Deluxe and currently have Quicken (which is now >> charging a yearly subscription). I'm muddling through setting up my accounts >> and I am baffled at the seemingly backward credit and debit columns in the >> register. A deposit to my Checking (or payment to my credit card account) >> shows up under "DEBIT" and a charge to my accounts shows up under "CREDIT". >> The balance is correct. Am I doing something wrong in my set-up? >> >> Thanks, >> >> Mike Kerstetter > > Hi, Mike. > > Welcome to gnucash, and to the mysterious world of double-entry bookkeeping! > > No, you haven’t made a mistake, cash received by an account is regarded as a > debit and cash paid as a credit. > > I’m not an accountant and I frequently have to chant “Debit the Receiver” to > remind myself how it goes. > > No doubt one of the experts in the forum can point you in the direction of an > explanation of this counter-intuitive situation, or you could try Googling. > > Michael > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to gnucash
Mike, The first chapter or two of the Tutorial and Concepts guide https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html may help with getting this straight. Wikipedia also has quite good articles on double entry accounting, the accounting equation and debits and credits. https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system https://en.wikipedia.org/wiki/Debits_and_credits https://en.wikipedia.org/wiki/Accounting_equation David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to gnucash
On Sat, 2019-01-05 at 11:41 -0500, Mike Kerstetter wrote: > Hello all. I'm brand new to gnucash. I want it to do just the basics > of > keeping a register and reconciliation of a couple bank and credit > card > accounts. I had Money Sunset Deluxe and currently have Quicken (which > is > now charging a yearly subscription). I'm muddling through setting up > my > accounts and I am baffled at the seemingly backward credit and debit > columns in the register. A deposit to my Checking (or payment to my > credit card account) shows up under "DEBIT" and a charge to my > accounts > shows up under "CREDIT". The balance is correct. Am I doing > something > wrong in my set-up? > > Thanks, > > Mike Kerstetter What others have said. In the meantime Uncheck the "Use formal accounting labels" box under Edit -> Preferences -> Accounts. -- N. B. Day 39.4042 North, 119.7377 West and 1387 meters up, Temp: -3.9 C (KRNO) Sat, 2019-01-05 at 09:34 PST (UTC -0800) Epicurus up 21:15, 1 user, load average: 1.27, 0.66, 0.35 Linux 4.18.0-13-generic Ubuntu Disco Dingo (development branch), GNOME Shell 3.30.1 This computer in service for 2900 days. ___ 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] new to gnucash
> On 5 Jan 2019, at 16:41, Mike Kerstetter wrote: > > Hello all. I'm brand new to gnucash. I want it to do just the basics of > keeping a register and reconciliation of a couple bank and credit card > accounts. I had Money Sunset Deluxe and currently have Quicken (which is now > charging a yearly subscription). I'm muddling through setting up my accounts > and I am baffled at the seemingly backward credit and debit columns in the > register. A deposit to my Checking (or payment to my credit card account) > shows up under "DEBIT" and a charge to my accounts shows up under "CREDIT". > The balance is correct. Am I doing something wrong in my set-up? > > Thanks, > > Mike Kerstetter Hi, Mike. Welcome to gnucash, and to the mysterious world of double-entry bookkeeping! No, you haven’t made a mistake, cash received by an account is regarded as a debit and cash paid as a credit. I’m not an accountant and I frequently have to chant “Debit the Receiver” to remind myself how it goes. No doubt one of the experts in the forum can point you in the direction of an explanation of this counter-intuitive situation, or you could try Googling. Michael ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] new to gnucash
Sounds right to me. Remember that Asset and Expense accounts are Debit accounts. So Debit increases and Credit decreases the balances in the accounts. Liability, Income, and Equity/Capital accounts are Credit accounts. So Debit decreases and Credit increases the balance. On Sat, Jan 5, 2019, 08:44 Mike Kerstetter Hello all. I'm brand new to gnucash. I want it to do just the basics of > keeping a register and reconciliation of a couple bank and credit card > accounts. I had Money Sunset Deluxe and currently have Quicken (which is > now charging a yearly subscription). I'm muddling through setting up my > accounts and I am baffled at the seemingly backward credit and debit > columns in the register. A deposit to my Checking (or payment to my > credit card account) shows up under "DEBIT" and a charge to my accounts > shows up under "CREDIT". The balance is correct. Am I doing something > wrong in my set-up? > > Thanks, > > Mike Kerstetter > ___ > 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] new to gnucash
In accounting, a debit is a movement of funds towards something, a credit away from. So you debit a bank account when you move money into it, credit it when you move money out. The confusion arises from popular usage: for example, when your bank sends you a statement, they are showing the credit and debit columns from /their/ perspective. To the bank, your account is a liability (payable to you). The debits are movements of funds that reduce that liability, the credits are movements of funds that increase the liability. It eventually feels natural, but it's also natural to find this quite weird when you first start using proper accounting language. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 05/01/19 17:41, Mike Kerstetter wrote: > Hello all. I'm brand new to gnucash. I want it to do just the basics > of keeping a register and reconciliation of a couple bank and credit > card accounts. I had Money Sunset Deluxe and currently have Quicken > (which is now charging a yearly subscription). I'm muddling through > setting up my accounts and I am baffled at the seemingly backward > credit and debit columns in the register. A deposit to my Checking (or > payment to my credit card account) shows up under "DEBIT" and a charge > to my accounts shows up under "CREDIT". The balance is correct. Am I > doing something wrong in my set-up? > > Thanks, > > Mike Kerstetter > ___ > 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. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.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.
[GNC] new to gnucash
Hello all. I'm brand new to gnucash. I want it to do just the basics of keeping a register and reconciliation of a couple bank and credit card accounts. I had Money Sunset Deluxe and currently have Quicken (which is now charging a yearly subscription). I'm muddling through setting up my accounts and I am baffled at the seemingly backward credit and debit columns in the register. A deposit to my Checking (or payment to my credit card account) shows up under "DEBIT" and a charge to my accounts shows up under "CREDIT". The balance is correct. Am I doing something wrong in my set-up? Thanks, Mike Kerstetter ___ 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.