Re: [GNC] Backup files in another folder – solution for Windows
An alternative is to use the SQLite backend. There is no file cluttering, and the added bonus of instant saves rather than periodic. I'm not sure how easy that is to set up on Windows, however. Regards, Adrien On 8/4/22 5:47 PM, GNC mailinglist wrote: Hi,I'm new to GnuCash but, yep, I was disappointed by the multiple backup and log files cluttering the directory where the main budget file is stored. I've searched and found out nobody even made a workaround. So I wrote a Powershell (Windows) script watching folder for new files and moving them to another folder. Take a look at → github.com https://github.com/Kaligula0/FolderWatcher . The file has an explanation but feel free to comment here or file a bug there.Best regards, Char ___ 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] Backup files in another folder – solution for Windows
Even with the SQLite database you still need backups. One could use the built-in backup scheme to guard against user error or database corruption and then also a copy to other media (cloud, external drive, etc.) to guard against hardware failure. On Fri, Aug 5, 2022 at 9:37 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > An alternative is to use the SQLite backend. There is no file > cluttering, and the added bonus of instant saves rather than periodic. > I'm not sure how easy that is to set up on Windows, however. > > Regards, > Adrien > > On 8/4/22 5:47 PM, GNC mailinglist wrote: > > Hi,I'm new to GnuCash but, yep, I was disappointed by the > multiple backup and log files cluttering the directory where the main > budget file is stored. I've searched and found out nobody even made a > workaround. So I wrote a Powershell (Windows) script watching folder for > new files and moving them to another folder. Take a look at → github.com > https://github.com/Kaligula0/FolderWatcher . The file has an > explanation but feel free to comment here or file a bug there.Best > regards, Char > > > ___ > 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] Backup files in another folder – solution for Windows
Of course. Sorry if it seemed I implied otherwise. Regards, Adrien On 8/5/22 9:02 AM, Glenn Fowler wrote: Even with the SQLite database you still need backups. ___ 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] Backup files in another folder – solution for Windows
You can also use a batch file to accomplish the task of moving the backup and log files. I have a batch file named "Start GNUcash.bat" that contains the following: @ECHO OFF ECHO Starting GNUcash START "Starting GNUcash" /WAIT "C:\Program Files (x86)\gnucash\bin\gnucash.exe" ECHO GNUcash closed MOVE "C:\data file location\*.gnucash.*.gnucash" "C:\Backup file location" MOVE "C:\data file location\*.log" "C:\Backup file location" PAUSE @ECHO ON EXIT The START command starts GNUcash and waits for it to close. Once it closes, it moves the backup and log files to the backup folder. Obviously you would need to change the data file and backup file locations to suit your system. The file location spec does not need to be enclosed in quotes if there is no "White Space" in the file spec. Note that you cannot simply use "*.gnucash" for the backup file as that would move the main data file as well, so it must be "*.gnucash.*.gnucash". Jack -Original Message- From: gnucash-user On Behalf Of Glenn Fowler Sent: Thursday, August 4, 2022 7:12 PM To: GNC mailinglist Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Backup files in another folder – solution for Windows Thank you for sharing. I do my backups with PS as well but just do a once daily run and check the file hash for changes. If it's changed then copy. On Thu, Aug 4, 2022 at 6:47 PM GNC mailinglist wrote: > Hi,I'm new to GnuCash but, yep, I was disappointed by the multiple > backup and log files cluttering the directory where the main budget > file is stored. I've searched and found out nobody even made a > workaround. So I wrote a Powershell (Windows) script watching folder > for new files and moving them to another folder. Take a look at → > github.com > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FKaligula0%2FFolderWatcher&data=05%7C01%7C%7C10814a96c5234a88fdd908da766fffb6%7C84df9e7fe9f640afb435%7C1%7C0%7C637952520658959336%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1zcfSLQK%2FBI%2FJM%2FzuATFplweHxp73T0VzqPdDuaN%2FxI%3D&reserved=0 > . The file has an > explanation but feel free to comment here or file a bug there.Best > regards, Char > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist > s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C01%7C% > 7C10814a96c5234a88fdd908da766fffb6%7C84df9e7fe9f640afb435% > 7C1%7C0%7C637952520658959336%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwM > DAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C& > sdata=7kiTV0Ag43AFHk9sPXvDM8dxCH1yoFaO3okyHXzfDJg%3D&reserved=0 > - > 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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C01%7C%7C10814a96c5234a88fdd908da766fffb6%7C84df9e7fe9f640afb435%7C1%7C0%7C637952520658959336%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7kiTV0Ag43AFHk9sPXvDM8dxCH1yoFaO3okyHXzfDJg%3D&reserved=0 - 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] gnucash-user Digest, Vol 233, Issue 14 desk top icon
As I don’t know what you call it, by in windows this is a desk top icon that you click on to open the program. I am getting use to this. Still need to find some of my items I made up. But looking nice. Thanks James Baxter kangaro...@yahoo.com Sent from my iPad > On Aug 5, 2022, at 12:00 PM, "gnucash-user-requ...@gnucash.org" > wrote: > > Send gnucash-user mailing list submissions to >gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit >https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to >gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at >gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Stumped on Mortgage Assistant - COMPLETE > (steve.schwa...@fastmail.com) > 2. Backup files in another folder ? solution for Windows > (GNC mailinglist) > 3. Re: Backup files in another folder ? solution for Windows > (Glenn Fowler) > 4. Re: Backup files in another folder ? solution for Windows > (Adrien Monteleone) > 5. Re: Backup files in another folder ? solution for Windows > (Glenn Fowler) > 6. Re: Backup files in another folder ? solution for Windows > (Adrien Monteleone) > 7. Re: Backup files in another folder ? solution for Windows > (Jack Lockard) > > > -- > > Message: 1 > Date: Thu, 4 Aug 2022 14:19:02 -0500 > From: "" > To: gnucash-u...@lists.gnucash.org > Subject: [GNC] Stumped on Mortgage Assistant - COMPLETE > Message-ID: <0437eae6-d73f-1702-2f7e-9d3fbb745...@fastmail.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Thanks for everyone's help and ideas. I have taken the various advice > and now have my mortgages in GC. I won't claim to understand everything > I know, but after a couple months' iterations, I am expecting to be more > confident regardless my level of understanding. > > Now on to getting my retirement plans in GC. > > > Steve > > > -- > > Message: 2 > Date: Fri, 05 Aug 2022 00:47:05 +0200 > From: GNC mailinglist > To: gnucash-user@gnucash.org > Subject: [GNC] Backup files in another folder ? solution for Windows > Message-ID: <875471b7354140d490ddd6c5dd291...@grupawp.pl> > Content-Type: text/plain; charset=UTF-8 > > Hi,I'm new to GnuCash but, yep, I was disappointed by the multiple > backup and log files cluttering the directory where the main budget file is > stored. I've searched and found out nobody even made a workaround. So I > wrote a Powershell (Windows) script watching folder for new files and moving > them to another folder. Take a look at ? github.com > https://github.com/Kaligula0/FolderWatcher ?. The file has an explanation > but feel free to comment here or file a bug there.Best regards, Char > > > -- > > Message: 3 > Date: Thu, 4 Aug 2022 19:11:45 -0400 > From: Glenn Fowler > To: GNC mailinglist > Cc: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Backup files in another folder ? solution for >Windows > Message-ID: > > > > Content-Type: text/plain; charset="UTF-8" > > Thank you for sharing. > I do my backups with PS as well but just do a once daily run and check the > file hash for changes. If it's changed then copy. > >> On Thu, Aug 4, 2022 at 6:47 PM GNC mailinglist wrote: >> >> Hi,I'm new to GnuCash but, yep, I was disappointed by the multiple >> backup and log files cluttering the directory where the main budget file is >> stored. I've searched and found out nobody even made a workaround. So I >> wrote a Powershell (Windows) script watching folder for new files and >> moving them to another folder. Take a look at ? github.com >> https://github.com/Kaligula0/FolderWatcher . The file has an >> explanation but feel free to comment here or file a bug there.Best >> regards, Char >> ___ >> 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. >> > > > -- > > Message: 4 > Date: Fri, 5 Aug 2022 08:37:08 -0500 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Backup files in another folder ? solution for >Windows > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > An alternative is to use the SQLite backend. There is no file > cluttering, and the added bonus of instant saves rather than periodic. > I'm not sure how easy that is to set up on Windows, howe
Re: [GNC] Backup files in another folder – solution for Windows
Not at all! Just adding info for this great community and for the next person that searches On Fri, Aug 5, 2022 at 10:22 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Of course. Sorry if it seemed I implied otherwise. > > Regards, > Adrien > > On 8/5/22 9:02 AM, Glenn Fowler wrote: > > Even with the SQLite database you still need backups. > > > ___ > 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] Backup files in another folder ? solution for Windows
Message: 2 > Date: Fri, 05 Aug 2022 00:47:05 +0200 > From: GNC mailinglist > To: gnucash-user@gnucash.org > Subject: [GNC] Backup files in another folder ? solution for Windows > Message-ID: <875471b7354140d490ddd6c5dd291...@grupawp.pl> > Content-Type: text/plain; charset=UTF-8 > > Hi,I'm new to GnuCash but, yep, I was disappointed by the multiple > backup and log files cluttering the directory where the main budget file is > stored. I've searched and found out nobody even made a workaround. So I > wrote a Powershell (Windows) script watching folder for new files and moving > them to another folder. Take a look at ? github.com > https://github.com/Kaligula0/FolderWatcher ?. The file has an explanation > but feel free to comment here or file a bug there.Best regards, Char > Hi Char, In my humble opinion, If you put each GnuCash book in its own directory, and set the GnuCash preferences to automatically remove older backups and logs, there is no need to move them. BTW, you may be interested in my utility for encrypting and compressing most of the files you need to backup a GnuCash book to an off site cloud storage folder (I.e. Dropbox, OneDrive, Google drive or iCloud) called BackupGnuCash: See https://wiki.gnucash.org/wiki/Published_tools. You do have to be reasonably computer proficient to install my utility. Also there is a lot of backup info in https://wiki.gnucash.org/wiki/Backup Regards, Chris Good ___ 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] The server ... encountered bad or corrupt data
I recently transferred my GnuCash data from another computer to my new one. In the process, I switched from a MySQL instance in a WAMP installation on the old computer to a stand-alone MariaDB install on the new computer. On the old computer, I saved the data in xml format, then opened that file on the new computer, finally saving in sql format. I noticed that my dark theme and saved reports didn't follow during the move, but another helpful person here pointed me to the correct documentation which corrected both of those issues. Neither seem related to the accounting data itself. So, all was well and I had logged in and out several times making sure the password was recorded correctly in a keyboard macro for easier access. I have not done any data entry since the move. The old computer and the original transfer file is still available. Nevertheless, the impression I was given was that, going forward, MariaDB was the preferred sql back end because "we switched the connectors in the Gnucash-built bundles and in flatpak to MariaDB's because MySQL discontinued their C ones and the C++ one won't work with libdbi". Today I try to login to actually do work in GnuCash for the first time on the new computer and I get the following message: *The server at URL mysql://root@localhost/gnucash experienced an error or encountered bad or corrupt data.* I have verified the password is correct, restarted the PC, and looked at the data from HeidiSQL and can see no issue with anything. This freaks me out as NEVER did this EVER happen with MySQL on the old computer. Is there a resolution to this? Must I start the migration all over again? How do I regain confidence in the SQL back end when this happens so quickly after changing db engines? Thanks. Tom Middleton, WI USA ___ 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] Third party OFX/CVS providers
On Wed, Aug 3, 2022 at 17:39 Tom Browder wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthly PDF statements for > personal accounts. I know third-party programs, such as YNAB (ynab.com), > can get access my bank while I can't, but I don't want the baggage that > comes with it. > I changed my mind. I now have an YNAB account and found that is has a well-documented API. Not only that, I was able to link it successfully to my two banks and access my checking, savings, and credit card transactions! It might be possible to use the API to periodically download bank and credit card transactions into YNAB's standard JSON format, then convert that into the OFX format, and then upload the OFX into GnuCash. I'm proceeding on the project with the hope of success. If anyone is interested in following it, the Raku (formerly Perl 6, see https://raku.org) module skeleton is on my Github repo now at https://github.com/tbrowder/API-YNAB.git. (Note I may soon change the title to something like YNAB2OFX or YNAB-OFX--suggestions are very welcome.) The downside, assuming I have success, is that YNAB has a subscription fee of about $15 per month plus tax (cancel any time) or $100 plus tax a year, sums well worth it if I can get a periodic good OFX-to-GnuCash import. Best regards, -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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Next Job ID
In the Python bindings, I can see the methods that return the next available ID for most objects. But I am having trouble finding one for Jobs. I have read the help output from help(gnucash.gnucash_core_c). To create a new Customer, for example, I'm using the following: cust = gnucash.gnucash_business.Customer(book, book.CustomerNextID(), USD, 'Acme') I don't see an equivalent "book.JobNextID()". Is there a method or function that returns this? ___ 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] Next Job ID
Another Job related question: using the form in the following example on line 128: https://code.gnucash.org/docs/MAINT/simple__business__create_8py_source.html job = gnucash.gnucash_business.Job(book, '1', vendor, 'test') This returns a warning: WARN [GncSqlColumnTableEntryImpl::add_to_query()] Invalid owner type: 0 What would be causing this, and is there a way to fix it? On Fri, Aug 5, 2022 at 9:06 PM Robert Simmons wrote: > In the Python bindings, I can see the methods that return the next > available ID for most objects. But I am having trouble finding one for > Jobs. I have read the help output from help(gnucash.gnucash_core_c). To > create a new Customer, for example, I'm using the following: > > cust = gnucash.gnucash_business.Customer(book, book.CustomerNextID(), USD, > 'Acme') > > I don't see an equivalent "book.JobNextID()". > > Is there a method or function that returns this? > ___ 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] Next Job ID
Cut and paste error on my part. The line that causes the warning is the following (the vendor version of the line works without warning). job = gnucash.gnucash_business.Job(book, '1', customer, 'test') On Fri, Aug 5, 2022 at 11:59 PM Robert Simmons wrote: > Another Job related question: using the form in the following example on > line 128: > > > https://code.gnucash.org/docs/MAINT/simple__business__create_8py_source.html > > job = gnucash.gnucash_business.Job(book, '1', vendor, 'test') > > This returns a warning: > > WARN [GncSqlColumnTableEntryImpl::add_to_query()] > Invalid owner type: 0 > > What would be causing this, and is there a way to fix it? > > On Fri, Aug 5, 2022 at 9:06 PM Robert Simmons wrote: > >> In the Python bindings, I can see the methods that return the next >> available ID for most objects. But I am having trouble finding one for >> Jobs. I have read the help output from help(gnucash.gnucash_core_c). To >> create a new Customer, for example, I'm using the following: >> >> cust = gnucash.gnucash_business.Customer(book, book.CustomerNextID(), >> USD, 'Acme') >> >> I don't see an equivalent "book.JobNextID()". >> >> Is there a method or function that returns this? >> > ___ 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.
