[GNC] Get no suitable back end found
Hi Fully updated Windows 10. GnuCash 4 3. Rebooting doesn't help. Reinstalling doesn't help. Regards, Nigel ___ 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] Filtering reports on contents of Memo field
> On 7 Feb 2021, at 18:22, Stephen M. Butler > wrote: > > On 2/7/21 10:10 AM, Adrien Monteleone wrote: >> If you are treating members as 'customers' then you may have other options. >> Otherwise, you'd have to go through the equally tedious task of setting up >> sub-accounts for each member, or creating a saved report configuration for >> each member. >> >> The Transaction Report does offer filtering capabilities that you can use on >> a Memo field for that last option. >> >> Another alternative for a consolidated report might work: >> >> The Transaction Report also lets you sort by the Memo field, so if you >> choose only the Gift Aid account, and the Memo starts with/contains only the >> Member names, you might be able to get subtotals for each member. (if that >> is what you are looking for) >> >> In either case, no need to filter date range for the account view first, >> you'll do that in the report options. >> >> If you want individualized reports per member, then you can still use that >> last option, but you'll need to save each as a Report Configuration and just >> name it for each Member. Then run them one at a time as needed. > > What if the Memo field contains "Member: member last, first name" so that > the filter was on the leading "Member: " portion but you still sorted by the > Memo field. Wouldn't each break based on the remainder of that field trigger > a total line? In that way this would be just one report without having to > know if new members were added or removed. > > --Steve Thanks, Steve. I’ve tried just putting “M: “ in front of a few of the names in the memo filed, sorting by memo field and then using Cmd-F to search for “M: “ contained in the memo field, and that looks promising. The transaction report derived from this won’t produce sub-totals by member, but the Gift Aid claim has to be itemised by date so that’s not a huge problem. I’ll polish it and report back. 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] 4.4 slow
When I came in check & repair was in an infinite loop in accounts receivable. The progress log shows it counting up to about 1000 out 6614 and then restarting at 0. Not clear whether a profile of check and repair is useful. System is relatively unresponsive while I try to interrupt it Sent from my iPhone > On Feb 5, 2021, at 3:30 PM, John Ralls wrote: > > 7 minutes is a lot. If it's still doing that after the C&R finishes then > please open a bug and attach a profile. > > Regards, > John Ralls > > >> On Feb 5, 2021, at 12:21 PM, R. Victor Klassen wrote: >> >> It definitely does beachball long enough. >> >> Might be able to get a profile. >> >> It’s been in check and repair for a bit over 2 hrs now so I am guessing any >> further probing will be Monday. For what It’s worth it was in excess of 7 >> minutes of CPU time last time I started (from a crash). Minimal disk >> activity. Reasonable memory pressure >> >> Sent from my iPhone >> On Feb 5, 2021, at 1:57 PM, John Ralls wrote: >>> >>> Does it beachball long enough to get a process sample out of Activity >>> Monitor? Better yet, do you know your way around Xcode well enough to get a >>> time profile? >>> >>> Regards, >>> John Ralls >>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen wrote: I should also say I’m using the SQLite back end. 90% or more of what I do passes though the business features. When I say entering an invoice line is slow I mean that when I hit tab to get past the last entry and start a new one I sometimes see the spinning lollipop. Trying check and repair to see if it makes a difference Sent from my iPhone >> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone >> wrote: > > And on that note, it is always recommended when stepping between major > versions to run Actions > Check & Repair > Check & Repair All. (which > should accomplish such data translations all in one go) > > I forgot to add that I'm using the SQLite backend. Not sure if that makes > a difference. > > Regards, > Adrien > >> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote: >> My memory is a bit fuzzy, but version 4 made some significant changes to >> (I think) a number of key-value structures in the database. The first >> time you open version 4, it has to convert all the old values (if you >> have done lots of transaction importing, that’s a big contributor). If >> you quit gnucash before it’s done with the conversion, it has to start >> over the next time. I think it took something like 45 minutes before my >> Mac was done updating everything internally in the database. >> After that it has been fine. > > ___ > 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. >>> > ___ 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] Frustration
> On 8 Feb 2021, at 04:56, Andrew Ralph via gnucash-user > wrote: > > Hi team > I am trying to achieve what I think should be a simple process, to complete > yearly accounts for tax purposes for 4 seperate rental properties > All I want to do is be able to save the previous years accounts and reproduce > a blank account hierarchy for the next financial year. > > With going trough the intro doc and on line forums haven’t come up with a > workable solution. > > I have tried all the export options to reproduce a new blank or otherwise > account hierarchy but am unable > > Not sure if the close book option would be appropriate > > I also can only see the last 4 accounts from the file drop down can I access > a more detailed record of previous accounts and historical interactions > > > > Any suggestions would be appreciated > > Andrew To keep it simple, let’s say you only have one rental property, and receive rent for it at intervals throughout the year, recording this income in Income:Rent. Open the Income:Rent account, and right-click on any of the transactions in that account. Choose the “Filter By…” option. Select an appropriate date range. Job done! If you set a future date range, no transactions will be visible - as if you’d set up a completely new set of books. If you choose the start and end dates of a previous financial year, you’ll see the transactions for that year. There is no need to Close Books in GnuCash when moving into a new financial year, and there is no need to set up a new GnuCash file for each financial year, the way you would have done when keeping pen-and-ink records. If you feel you need to start a new year but carry forward the chart of accounts without the old year’s transactions, I think you can do this with File => New File - I’m not sure of the details, and have never tried this. 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] Get no suitable back end found
Nigel, Not sure with Windows 10 but on Linux this would likely be not having one of either libdbd-mysql, libdbd-pgsql or libdbd-sqlite3 runtime libraries installed. AFAIK GnuCash on Windows 10 uses the Cygwin Linux emulator so the cygwin version of these should work if they are not already installed. They should be located under the /usr/local directory for the cygwin package on Windows. If you are running a flatpak version it may be a problem wit the flatpak permissions setup. You will find a lot of posts in the mailing list archive around this. The Nabble web interface http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html is not a bad method of searching the archives although not officially part of the GnuCash team supported environment See https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html and http://libdbi.sourceforge.net/download.html for more info. 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.
[GNC] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
I'm using GnuCash v. 4.2 on Linux Mint and have a strange problem: on some of my credit card accounts, after I complete the reconcile process, I get the pop-up window that lets me go ahead and enter the payment information for that bill. That is my desired state. But on some of them, I do NOT get that pop-up, and that sometimes causes me to miss recording the payment in my register until later, which is frustrating. Did I perhaps click a "do not show this" box at some point? And if so, how do I reset that? Thanks for your help! ___ 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] Get no suitable back end found
> On Feb 8, 2021, at 12:34 PM, David Cousens wrote: > > AFAIK GnuCash on Windows 10 uses the Cygwin Linux emulator so > the cygwin version of these should work if they are not already installed. If you mean GnuCash installed by gnucash-4.4-setup.exe from our download sites, it doesn't and they won't, but they're already included along with the necessary MySQL, Postgresql, and SQLite3 libraries in c:\Program Files (x86)\gnucash\bin. 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] Frustration
Andrew, As Michael pointed out, there is no real need in GnuCash to start a new file each year. The report structure is designed to produce appropriate reports as required. You just need to setup the options for the report after opening a copy of the report.in the window (menu is context sensitive). If you do need to create a new file for some reason, use the File->Export->Export Account Tree to CSV to export your account structure, the Fuile->NewFile to open a new file.In the setup wizard you cannot proceed if you Clear All but if you select the Simple Check Book only two accounts are setup and these are easily deleted. Finish the Wizard. You can then delete the Checking account and Opening balances and then import your account structure from the CSV file you previously exported with File->Import->Import Accounts from CSV. You will need to setup the preferences for the new book/file to match your previous settings and the accounting period for your jurisdiction. 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] Get no suitable back end found
Thanks John, Haven't used Windoze for over 12 years so I'm more than a little bit rusty on how GnuCash worked on it. Andrew you may need to let us know where you installed GNuCash from and whether it is a flatpak or other similar sandbox system David - 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.
[GNC] migrating reports from 2.6.19 to 4.4
Good evening - I have installed 4.4 on both my partitions (win 10 via the exe, and linux mint via the flatpak). I was running much earlier versions (3.8 on win10, and 2.6.18 on Linux). My reports show up if I put the contents of the old gnucash (or .gnucash) folders into the appropriate folders on each partition, and they run. BUT, they disappear as soon as I close the program. And on the windows side, it CTD as soon as I try to delete an old report - why I don't know. Is there a log file I can upload to diagnose 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 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] migrating reports from 2.6.19 to 4.4
Good evening - I have installed 4.4 on both my partitions (win 10 via the exe, and linux mint via the flatpak). I was running much earlier versions (3.8 on win10, and 2.6.18 on Linux). My reports show up if I put the contents of the old gnucash (or .gnucash) folders into the appropriate folders on each partition, and they run. BUT, they disappear as soon as I close the program. And on the windows side, it CTD as soon as I try to delete an old report - why I don't know. Is there a log file I can upload to diagnose 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 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
They also have to be of 'type' Credit Card, not just basic liability accounts. Regards, Adrien ___ 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
But David, how would this setting affect some credit card accounts, but not others? Original Message From: David H Sent: Mon Feb 08 16:34:17 EST 2021 To: Robert Stocker Cc: Gnucash Users Subject: Re: [GNC] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile Hi Robert, I guess you had no replies to your earlier request. Check your preferences under Register >> Reconciling and see if "Automatic credit card payment" is checked on or off (see attached). Cheers David H. On Tue, 9 Feb 2021 at 06:54, Robert Stocker wrote: > I'm using GnuCash v. 4.2 on Linux Mint and have a strange problem: on some > of my credit card accounts, after I complete the reconcile process, I get > the pop-up window that lets me go ahead and enter the payment information > for that bill. That is my desired state. > > But on some of them, I do NOT get that pop-up, and that sometimes causes me > to miss recording the payment in my register until later, which is > frustrating. > > Did I perhaps click a "do not show this" box at some point? And if so, how > do I reset that? > > Thanks for your help! > ___ > 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. ___ 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
Try toggling it off and on to see if it resets all cards ? I normally don't use this at all so I have it unchecked as I rely on scheduled txn's to enter my monthly cc payment. I just went into preferences and checked it on then did a dummy reconciliation of one of my cards. At the end of the process I got the popup to enter the payment details so obviously turning it on resets something somewhere :-) Sometimes you just have to play around with these things Cheers David H. On Tue, 9 Feb 2021 at 13:32, D. wrote: > But David, how would this setting affect some credit card accounts, but > not others? > > > Original Message > From: David H > Sent: Mon Feb 08 16:34:17 EST 2021 > To: Robert Stocker > Cc: Gnucash Users > Subject: Re: [GNC] Credit Card payment pop-up doesn't appear on *some* > credit card accounts after reconcile > > Hi Robert, > > I guess you had no replies to your earlier request. Check your preferences > under Register >> Reconciling and see if "Automatic credit card payment" is > checked on or off (see attached). > > Cheers David H. > > > On Tue, 9 Feb 2021 at 06:54, Robert Stocker wrote: > > > I'm using GnuCash v. 4.2 on Linux Mint and have a strange problem: on > some > > of my credit card accounts, after I complete the reconcile process, I get > > the pop-up window that lets me go ahead and enter the payment information > > for that bill. That is my desired state. > > > > But on some of them, I do NOT get that pop-up, and that sometimes causes > me > > to miss recording the payment in my register until later, which is > > frustrating. > > > > Did I perhaps click a "do not show this" box at some point? And if so, > how > > do I reset that? > > > > Thanks for your help! > > ___ > > 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. > > ___ 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] migrating reports from 2.6.19 to 4.4
The information on file locations for GnuCash is https://wiki.gnucash.org/wiki/Configuration_Locations. Note there is a location change for the user preference files and saved reports between 2.6.x and 3.x which may be the cause of your difficulties. There will be further information in the archives of the mailing list around the time 3.1 was released if the above is not clear.. You may need to copy any saved reports from th old 2.6 location to the new location for 3.x on. 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
On Mon, 08 Feb 2021 22:32:17 -0500 "D. via gnucash-user" wrote: > But David, how would this setting affect some credit card accounts, > but not others? I'm sure its an individual account setting. However, if one made an error and made a credit card a regular Liability, it wouldn't be set at all (See Adrien's post) 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
Yes I know it's an individual account setting that can be turned off individually for some cc's, by cancelling at the right point in time (is it on the "Transfer Funds" dialog?), it's not very intuitive whatever it is. Turning it on seems to make it active for ALL of my cc's which I turned it off for years ago and that is the result that the OP wants, so all I'm suggesting is that they try that and see if it resolves the problem. This assumes that they have setup their cc's as credit card accounts but no doubt we will find out in time as they will read Adrien's email also and check that before reporting back. Cheers David H. On Tue, 9 Feb 2021 at 14:30, Liz wrote: > On Mon, 08 Feb 2021 22:32:17 -0500 > "D. via gnucash-user" wrote: > > > But David, how would this setting affect some credit card accounts, > > but not others? > > I'm sure its an individual account setting. > However, if one made an error and made a credit card a regular > Liability, it wouldn't be set at all (See Adrien's post) > > 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. > ___ 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.
