Re: [GNC] v3.8 AQBanking in the US
> On Jan 8, 2020, at 8:41 AM, Derek Atkins wrote: > > John Ralls writes: > >> No. OFX Direct Connect is a way of connecting GnuCash directly to the >> bank and retrieving the account, balance, and transaction data >> directly into GnuCash. >> >> In addition to a working AQBanking it requires that your bank provide >> the service and that it reveals enough information that you can >> configure AQBanking to connect to it. > > There used to be an OFXHome website that had a database of all that > information. > > It's really too bad that we can't help support this work. But I don't > have/use OFX-DC myself. https://ofxhome.com is alive and well. 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] v3.8 AQBanking in the US
John Ralls writes: > No. OFX Direct Connect is a way of connecting GnuCash directly to the > bank and retrieving the account, balance, and transaction data > directly into GnuCash. > > In addition to a working AQBanking it requires that your bank provide > the service and that it reveals enough information that you can > configure AQBanking to connect to it. There used to be an OFXHome website that had a database of all that information. It's really too bad that we can't help support this work. But I don't have/use OFX-DC myself. > Regards, > John Ralls -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] v3.8 AQBanking in the US
All - the development you're talking about is beyond me, but I'm happy to help with testing or anything else that needs an extra set of hands. A couple of things. - I assume you're in touch with Martin Preuss already, but if not, the README for aqbanking 6 points out a list of changes that consuming applications must consider. It's at https://github.com/aqbanking/aqbanking/blob/master/README. See section 11. - The non-editable user problem that John Ralls noted seems to be because the backend type gets set to HBCI even when you set it to ofxconnect. This can be fixed by modifying aqbanking\settings6\users\.conf (change backendName to aqofxconnect). - At least for my bank (USAA) account retrieval only works if there is at least one "dummy" account in the list of online accounts. - I have user setup, account retrieval, and balance retrieval working. Transactions are retrieved and visible in the OFX log but don't show up in the GC transaction matcher. If there is a piece of GC code that returns a single transaction with date=0, amount=0 and description="Unspecified" when a crawl through the retrieved transactions returns nothing, that's a good place to start. All best and let me know how I can help! DerekOn Saturday, January 4, 2020, 05:37:38 AM EST, 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. Re: v3.8 AQBanking in the US (John Ralls) 2. Re: v3.8 AQBanking in the US (Kenneth Schneider) 3. Re: GnuCash/AqBanking headaches (chris graves) 4. Re: v3.8: Budget "total" field (chris graves) 5. Re: GnuCash/AqBanking headaches (John Ralls) 6. Re: Default Invoice Config (Axel Essbaum) 7. Import failing - cannot get debug file (Bennie Gibson) 8. Re: Chaning left sidebar spacing (William Marshall) 9. Re: Chaning left sidebar spacing (William Marshall) 10. Re: Chaning left sidebar spacing (William Marshall) No. OFX Direct Connect is a way of connecting GnuCash directly to the bank and retrieving the account, balance, and transaction data directly into GnuCash. In addition to a working AQBanking it requires that your bank provide the service and that it reveals enough information that you can configure AQBanking to connect to it. Regards, John Ralls > On Jan 3, 2020, at 8:56 AM, David Carlson wrote: > > Is OFX Direct Connect linked to simple OFX or QFX downloads that are provided > by many US banks as one of the three ways that data can be funneled through > Intuit Software, hopefully to GnuCash instead of Quicken? > > In other words, has Intuit found a way to kill OFX as an open source tool? > > David Carlson > > On Fri, Jan 3, 2020 at 10:43 AM John Ralls wrote: > > > > On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: > > > > John Ralls writes: > > > >> I don't know how much of that's fixable from GnuCash. Martin said last > >> week that he's suspended development of OFX so anything that isn't is > >> presumably broken forever. > > > > Did he give a reason for suspending OFX development? > > Yes: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html > > 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. > > > -- > David Carlson I have volunteered to help Martin as best I can. I’m retired, getting old and not in the best of health but hopefully can be of some assistance. I’ve been working with Linux in one flavor or another for over 25 years and would like to give back to the community in some way. If anyone else can also help I’m sure it would be appreciated. Ken Schneider > On Jan 3, 2020, at 11:36 AM, John Ralls wrote: > > > >> On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: >> >> John Ralls writes: >> >>> I don't know how much of that's fixable from GnuCash. Martin said last >>> week that he's suspended development of OFX so anything that isn't is >>> presumably broken forever. >> >> Did he give a reason for suspending OFX development? > > Yes: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html > > Regards, > John Ralls > >
Re: [GNC] v3.8: Budget "total" field
I'd opt for the switch user method, with sharing files to the main users public folder as John mentioned, as there is very little if any chance of messing up the production GC file/settings/AqBanking. > On Jan 3, 2020, at 2:30 PM, John Ralls wrote: > > Switching users isn't onerous as long as you use simple passwords--you do > have to type it every time you switch--and it's easy to create a folder in > your main user's $HOME to collect stuff: > https://support.apple.com/guide/mac-help/control-access-to-your-public-folder-on-mac-mchlp1775/mac. > > If that's still too much trouble you can set GNC_DATA_DIR and GNC_CONFIG_DIR > in the non-production bundle's Contents/Resources/etc/gnucash/environment to > point somewhere other than ~/Library/Application Support/Gnucash. Preferences > go to ~/Library/Preferences/org.gnucash.Gnucash no matter what, but that's > probably not a concern in most cases. > > Regards, > John Ralls >> On Jan 3, 2020, at 9:45 AM, Adrien Monteleone >> wrote: >> >> I’m considering that approach, but that would mean switching users just for >> testing. I suppose I could set up some sort of common folder to save screen >> shots and crash reports as I don’t want to have activity in the test user >> not be available to me in my main account. If Mac had some sort of container >> system like linux or if I could easily run it in a VM (without a large GB >> virtual disk) I’d prefer that route but that doesn’t seem possible right now. >> >> Regards, >> Adrien >> >>> On Jan 3, 2020 w1d3, at 4:04 AM, Michael Hendry >>> wrote: >>> On 3 Jan 2020, at 01:35, Adrien Monteleone via gnucash-user wrote: I thought that was discussed, but delving into the bug threads and others linked therein, I see the issue a bit more clearly. Certainly, I think the current underlying approach is the more sane one long term with a few kinks to be worked out. I (sadly and apologetically) still haven’t worked out a way to test dev versions on MacOS without disrupting my normal installation, but I can test non-OS specific changes via VMs. (I can certainly build maint or other branches in Ubuntu) If anyone has any suggestions or tips for testing maint and other builds on the MacOS front *without disturbing my normal stable installation* , they are certainly appreciated. >>> >>> I haven’t tried this, but why not create a new user (e.g. “GCTest”) and run >>> any experimental versions as that user. This would protect your own >>> .gnucash files and configuration settings, as these are per-user, not >>> per-computer. >>> >>> Michael >>> I’m getting ready next week to work on my 2020 budgets, so now would be a good time to do some testing. Let me know what types of things you’d like to see answers to and I’ll do what I can. (in a Linux version for now, as noted) 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. > > ___ > 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] v3.8 AQBanking in the US
I have volunteered to help Martin as best I can. I’m retired, getting old and not in the best of health but hopefully can be of some assistance. I’ve been working with Linux in one flavor or another for over 25 years and would like to give back to the community in some way. If anyone else can also help I’m sure it would be appreciated. Ken Schneider > On Jan 3, 2020, at 11:36 AM, John Ralls wrote: > > > >> On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: >> >> John Ralls writes: >> >>> I don't know how much of that's fixable from GnuCash. Martin said last >>> week that he's suspended development of OFX so anything that isn't is >>> presumably broken forever. >> >> Did he give a reason for suspending OFX development? > > Yes: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html > > 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. > ___ 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] v3.8 AQBanking in the US
No. OFX Direct Connect is a way of connecting GnuCash directly to the bank and retrieving the account, balance, and transaction data directly into GnuCash. In addition to a working AQBanking it requires that your bank provide the service and that it reveals enough information that you can configure AQBanking to connect to it. Regards, John Ralls > On Jan 3, 2020, at 8:56 AM, David Carlson wrote: > > Is OFX Direct Connect linked to simple OFX or QFX downloads that are provided > by many US banks as one of the three ways that data can be funneled through > Intuit Software, hopefully to GnuCash instead of Quicken? > > In other words, has Intuit found a way to kill OFX as an open source tool? > > David Carlson > > On Fri, Jan 3, 2020 at 10:43 AM John Ralls wrote: > > > > On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: > > > > John Ralls writes: > > > >> I don't know how much of that's fixable from GnuCash. Martin said last > >> week that he's suspended development of OFX so anything that isn't is > >> presumably broken forever. > > > > Did he give a reason for suspending OFX development? > > Yes: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html > > 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. > > > -- > 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] v3.8: Budget "total" field
Thanks John, I think I’ll go the public folder route. Regards, Adrien > On Jan 3, 2020 w1d3, at 4:30 PM, John Ralls wrote: > > Switching users isn't onerous as long as you use simple passwords--you do > have to type it every time you switch--and it's easy to create a folder in > your main user's $HOME to collect stuff: > https://support.apple.com/guide/mac-help/control-access-to-your-public-folder-on-mac-mchlp1775/mac. > > If that's still too much trouble you can set GNC_DATA_DIR and GNC_CONFIG_DIR > in the non-production bundle's Contents/Resources/etc/gnucash/environment to > point somewhere other than ~/Library/Application Support/Gnucash. Preferences > go to ~/Library/Preferences/org.gnucash.Gnucash no matter what, but that's > probably not a concern in most cases. > > 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] v3.8: Budget "total" field
Switching users isn't onerous as long as you use simple passwords--you do have to type it every time you switch--and it's easy to create a folder in your main user's $HOME to collect stuff: https://support.apple.com/guide/mac-help/control-access-to-your-public-folder-on-mac-mchlp1775/mac. If that's still too much trouble you can set GNC_DATA_DIR and GNC_CONFIG_DIR in the non-production bundle's Contents/Resources/etc/gnucash/environment to point somewhere other than ~/Library/Application Support/Gnucash. Preferences go to ~/Library/Preferences/org.gnucash.Gnucash no matter what, but that's probably not a concern in most cases. Regards, John Ralls > On Jan 3, 2020, at 9:45 AM, Adrien Monteleone > wrote: > > I’m considering that approach, but that would mean switching users just for > testing. I suppose I could set up some sort of common folder to save screen > shots and crash reports as I don’t want to have activity in the test user not > be available to me in my main account. If Mac had some sort of container > system like linux or if I could easily run it in a VM (without a large GB > virtual disk) I’d prefer that route but that doesn’t seem possible right now. > > Regards, > Adrien > >> On Jan 3, 2020 w1d3, at 4:04 AM, Michael Hendry >> wrote: >> >>> On 3 Jan 2020, at 01:35, Adrien Monteleone via gnucash-user >>> wrote: >>> >>> I thought that was discussed, but delving into the bug threads and others >>> linked therein, I see the issue a bit more clearly. >>> >>> Certainly, I think the current underlying approach is the more sane one >>> long term with a few kinks to be worked out. >>> >>> I (sadly and apologetically) still haven’t worked out a way to test dev >>> versions on MacOS without disrupting my normal installation, but I can test >>> non-OS specific changes via VMs. (I can certainly build maint or other >>> branches in Ubuntu) If anyone has any suggestions or tips for testing maint >>> and other builds on the MacOS front *without disturbing my normal stable >>> installation* , they are certainly appreciated. >> >> I haven’t tried this, but why not create a new user (e.g. “GCTest”) and run >> any experimental versions as that user. This would protect your own .gnucash >> files and configuration settings, as these are per-user, not per-computer. >> >> Michael >> >>> >>> I’m getting ready next week to work on my 2020 budgets, so now would be a >>> good time to do some testing. >>> >>> Let me know what types of things you’d like to see answers to and I’ll do >>> what I can. (in a Linux version for now, as noted) >>> >>> 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. ___ 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] v3.8: Budget "total" field
I’m considering that approach, but that would mean switching users just for testing. I suppose I could set up some sort of common folder to save screen shots and crash reports as I don’t want to have activity in the test user not be available to me in my main account. If Mac had some sort of container system like linux or if I could easily run it in a VM (without a large GB virtual disk) I’d prefer that route but that doesn’t seem possible right now. Regards, Adrien > On Jan 3, 2020 w1d3, at 4:04 AM, Michael Hendry > wrote: > >> On 3 Jan 2020, at 01:35, Adrien Monteleone via gnucash-user >> wrote: >> >> I thought that was discussed, but delving into the bug threads and others >> linked therein, I see the issue a bit more clearly. >> >> Certainly, I think the current underlying approach is the more sane one long >> term with a few kinks to be worked out. >> >> I (sadly and apologetically) still haven’t worked out a way to test dev >> versions on MacOS without disrupting my normal installation, but I can test >> non-OS specific changes via VMs. (I can certainly build maint or other >> branches in Ubuntu) If anyone has any suggestions or tips for testing maint >> and other builds on the MacOS front *without disturbing my normal stable >> installation* , they are certainly appreciated. > > I haven’t tried this, but why not create a new user (e.g. “GCTest”) and run > any experimental versions as that user. This would protect your own .gnucash > files and configuration settings, as these are per-user, not per-computer. > > Michael > >> >> I’m getting ready next week to work on my 2020 budgets, so now would be a >> good time to do some testing. >> >> Let me know what types of things you’d like to see answers to and I’ll do >> what I can. (in a Linux version for now, as noted) >> >> 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] v3.8 AQBanking in the US
> On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: > > John Ralls writes: > >> I don't know how much of that's fixable from GnuCash. Martin said last >> week that he's suspended development of OFX so anything that isn't is >> presumably broken forever. > > Did he give a reason for suspending OFX development? Yes: https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html 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] v3.8 AQBanking in the US
John Ralls writes: > I don't know how much of that's fixable from GnuCash. Martin said last > week that he's suspended development of OFX so anything that isn't is > presumably broken forever. Did he give a reason for suspending OFX development? > 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] v3.8: Budget "total" field
> On 3 Jan 2020, at 01:35, Adrien Monteleone via gnucash-user > wrote: > > I thought that was discussed, but delving into the bug threads and others > linked therein, I see the issue a bit more clearly. > > Certainly, I think the current underlying approach is the more sane one long > term with a few kinks to be worked out. > > I (sadly and apologetically) still haven’t worked out a way to test dev > versions on MacOS without disrupting my normal installation, but I can test > non-OS specific changes via VMs. (I can certainly build maint or other > branches in Ubuntu) If anyone has any suggestions or tips for testing maint > and other builds on the MacOS front *without disturbing my normal stable > installation* , they are certainly appreciated. I haven’t tried this, but why not create a new user (e.g. “GCTest”) and run any experimental versions as that user. This would protect your own .gnucash files and configuration settings, as these are per-user, not per-computer. Michael > > I’m getting ready next week to work on my 2020 budgets, so now would be a > good time to do some testing. > > Let me know what types of things you’d like to see answers to and I’ll do > what I can. (in a Linux version for now, as noted) > > 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] v3.8
On Tue, Dec 31, 2019 at 12:09 PM boldstripe wrote: > Someone helpfully placed .deb packages for Gnucash 3.8 here (today): > http://ftp.us.debian.org/debian/pool/main/g/gnucash/ > > There are old postings on the mail list that explain how to use these. > Just after I saw this message the other day I successfully downloaded and built the Debian version 3.8b package on Ubuntu Bionic 18.04. I haven't tested it a lot, but after adjusting for some libraries, it does build, install, and run without errors. I presume it should build for Ubuntu derivative distributions, too. I got the following error on the first try: dpkg-checkbuilddeps: error: Unmet build dependencies: libaqbanking-dev (>= 5.99.43) libgwengui-gtk3-dev (>= 4.99.24) SO all I had to do to get the package to build was 1) Created source directory & downloaded packages $ mkdir ~/src/gnucash $ cd ~/src/gnucash $ dget http://ftp.us.debian.org/debian/pool/main/g/gnucash/gnucash_3.8b-1.dsc 2) Made the usual changes to debian/changelog to indicate a non-maintainer version for Ubuntu $ cd gnucash-3.8b/ $ dch --nmu [Modified the version number to 1:3.8b-1~ubuntu18.04.1 then wrote out the bullet points for my changes] 3) Changed the compiler flags in debian/rules (because of the older compiler in Bionic) $ sed -i 's/export DEB_CXXFLAGS/#export DEB_CXXFLAGS/' debian/rules 4) Changed debian/control lines for the package versions available in Bionic. ,libaqbanking-dev (>= 5.7.8-1) ,libgwengui-gtk3-dev (>= 4.20.0-1) 5) Built it $ dpkg-buildpackage 6) Installed it $ cd .. $ dpkg -i *.deb *.ddeb (I presume the Debian package maintainer specified the more recent package versions to fix particular bugs so I would expect there might be some subtle issues I haven't encountered yet.) P.S.: I know the procedure above is too terse for beginners. I hope to put a more explicit procedure in the wiki soon. - > 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] v3.8: Budget "total" field
https://lists.gnucash.org/pipermail/gnucash-user/2019-October/087700.html Yes an unfortunate minor regression while fixing a severe bug, because until now I could not understand why the totals section included budget equity values. On Fri, 3 Jan 2020 at 01:15, Adrien Monteleone via gnucash-user < gnucash-user@gnucash.org> wrote: > I haven’t yet delved into my 2020 budget, but certainly, the lack of an > overall total should be restored as it is critical to the budgeting process. > > I consider this a regression of sorts. (in terms of reduced functionality, > not necessarily, the return of a previously solved bug) > > Was this an accident? Oversight? Intentional design? > > Regards, > Adrien > > > On Jan 2, 2020 w1d2, at 3:43 PM, Greg W wrote: > > > > In the most recent release this change was made: > > > > [gnc-budget-view.c] totals - 5 fundamental types > > previous showed income/expense/transfers/totals budget totals, of > uncertain > > meaning. now shows income/expense/asset/liability/equity budget totals. > The > > 5 lines also become sensitive to the global sign-reverse property. > > > > That change removed the "total" row from budgets making it very hard to > > ensure that budgets are balanced or that there are no unallocated funds. > > Example of the old behavior: > > > > Income: 100 > > Expenses: 30 > > Liabilities: 20 > > Assets: 10 > > Total: 40 > > > > Using that total row I could tell there were 40 units that needed > allocated > > somewhere. How can I accomplish this given the recent changes? If I make > a > > change and accidentally allocate 1000 to Assets in the new version it > just > > updates the assets total row and doesn't otherwise indicate the budget is > > out of balance. > > > > Thanks, > > Greg > > ___ > 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] v3.8: Budget "total" field
I haven’t yet delved into my 2020 budget, but certainly, the lack of an overall total should be restored as it is critical to the budgeting process. I consider this a regression of sorts. (in terms of reduced functionality, not necessarily, the return of a previously solved bug) Was this an accident? Oversight? Intentional design? Regards, Adrien > On Jan 2, 2020 w1d2, at 3:43 PM, Greg W wrote: > > In the most recent release this change was made: > > [gnc-budget-view.c] totals - 5 fundamental types > previous showed income/expense/transfers/totals budget totals, of uncertain > meaning. now shows income/expense/asset/liability/equity budget totals. The > 5 lines also become sensitive to the global sign-reverse property. > > That change removed the "total" row from budgets making it very hard to > ensure that budgets are balanced or that there are no unallocated funds. > Example of the old behavior: > > Income: 100 > Expenses: 30 > Liabilities: 20 > Assets: 10 > Total: 40 > > Using that total row I could tell there were 40 units that needed allocated > somewhere. How can I accomplish this given the recent changes? If I make a > change and accidentally allocate 1000 to Assets in the new version it just > updates the assets total row and doesn't otherwise indicate the budget is > out of balance. > > Thanks, > Greg ___ 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] v3.8: Budget "total" field
https://bugs.gnucash.org/show_bug.cgi?id=797551 On Thu, 2 Jan 2020 at 21:45, Greg W wrote: > In the most recent release this change was made: > > [gnc-budget-view.c] totals - 5 fundamental types > previous showed income/expense/transfers/totals budget totals, of uncertain > meaning. now shows income/expense/asset/liability/equity budget totals. The > 5 lines also become sensitive to the global sign-reverse property. > > That change removed the "total" row from budgets making it very hard to > ensure that budgets are balanced or that there are no unallocated funds. > Example of the old behavior: > > Income: 100 > Expenses: 30 > Liabilities: 20 > Assets: 10 > Total: 40 > > Using that total row I could tell there were 40 units that needed allocated > somewhere. How can I accomplish this given the recent changes? If I make a > change and accidentally allocate 1000 to Assets in the new version it just > updates the assets total row and doesn't otherwise indicate the budget is > out of balance. > > Thanks, > Greg > ___ > 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.
[GNC] v3.8: Budget "total" field
In the most recent release this change was made: [gnc-budget-view.c] totals - 5 fundamental types previous showed income/expense/transfers/totals budget totals, of uncertain meaning. now shows income/expense/asset/liability/equity budget totals. The 5 lines also become sensitive to the global sign-reverse property. That change removed the "total" row from budgets making it very hard to ensure that budgets are balanced or that there are no unallocated funds. Example of the old behavior: Income: 100 Expenses: 30 Liabilities: 20 Assets: 10 Total: 40 Using that total row I could tell there were 40 units that needed allocated somewhere. How can I accomplish this given the recent changes? If I make a change and accidentally allocate 1000 to Assets in the new version it just updates the assets total row and doesn't otherwise indicate the budget is out of balance. Thanks, Greg ___ 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] v3.8 AQBanking in the US
OFX seems to be a broken in AQBanking 6, which as I explained earlier I provided in the Windows and Mac bundles to support the recent changes in Germany's FinTS system. Here's what my testing found: * OFX users and accounts aren't migrated to the new ~/.aqbanking/settings6 directory so the AQBanking Setup Wizard is initially unpopulated. * Trying to migrate the files oneself doesn't work very well, one must set them up by hand. ∑* One can create users but not edit them. * The Fetch Accounts button in the create user assistant works. The select user drop down in the edit account dialog does not, so if you don't fetch the accounts from the bank when you set up the user then you must edit the configuration files by hand. * The debug logging messages from Gwenhywfar aren't very helpful. * The associations made in the Online Banking Setup Assistant don't show in the assistant but they are made, so that the menu items in Actions>Online Actions are enabled for the account. However, the select account dialog still comes up the first time you try to get transactions anyway. * Once everything is set up, getting transactions seems to work but the end result is a matcher window with only a single 0-value and 0-date transaction. * Setting AQBANKING_LOGLEVEL=info or debug does nothing. * Setting AQOFXCONNECT_LOGLEVEL=info produces a single additional message: '* 13:20:06 WARN /Users/john/Development/Gnucash-Build/Gnucash-master-git/src/aqbanking-5.99.44beta/src/libs/plugins/backends/aqofxconnect/provider.c: 159: Overriding loglevel for AqOFXConnect with "info"'. Pretty useless. * GWEN_LOGLEVEL=debug produces a lot of output but little of it is of much help. FWIW https://github.com/Gnucash/gnucash/pull/623 made no difference. I don't know how much of that's fixable from GnuCash. Martin said last week that he's suspended development of OFX so anything that isn't is presumably broken forever. Regards, John Ralls > On Jan 2, 2020, at 9:08 AM, Derek Robinson via gnucash-user > wrote: > > I’ll check that piece of configuration over the weekend (and I never knew the > xml could be uncompressed ... thanks Frank Ellenberger!) > > Sent from my iPhone > >> On Jan 2, 2020, at 11:40 AM, chris graves wrote: >> >> Derek, >> >> Yes, the symptoms I'm experiencing seem to be the same. >> >> Chris >> >>> On Jan 1, 2020, at 8:21 PM, Derek Robinson via gnucash-user >>> wrote: >>> >>> We may be talking about the same issue - is the behavior what I described >>> in my post earlier today? >>> >>> John Ralls ( or anyone else who might know ) - any idea where the link >>> between an AqBanking account and the corresponding GC account is stored? >>> >>> Derek >>> >>> Sent from my iPhone >>> ___ >>> 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] v3.8
Postscript: I was missing the Help and Concepts Guide, which I solved as follows: It took me several attempts, following instructions I found in INSTALL, READ ME and elsewhere. In the end, I believe this is the part of what I did which actually worked: 1. Download gnucash-docs from https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/3.8/ 2. Extract 3. Open extracted directory in terminal 4. Install build dependencies: `sudo apt-get build-dep gnucash-docs` 5. `make` 6. `sudo make install` -- 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] v3.8
On Thu, Jan 02, 2020 at 01:54:30PM -0600, boldstripe wrote: > Thanks for the explanation, David. I think I may have been a bit over-zealous > in my sudo use at the first stages of the procedure; that is perhaps what > caused the permissions issue when I did not 'sudo' later on. > > I also run Gnucash inside Debian Buster virtual machines on both my Mac and > Windows machines (as well as the native apps), so at some stage I will have > to repeat this build operation there. When I do, I will try and be more > careful about my sudo use and see if I can build without problems; I'll > report back in due course. Now I know a bit more about how it should go, I > would also like to see how much can be done without resort to > buster-backports. Because these are virtual machines, which I can clone > (backup) before I start, it will be a bit easier to experiment with. > > Buster has been out more than six months now and I may be ready soon for an > upgrade to Bullseye ('testing' in Debian) soon. By then v3.8 may have > reached the repository with a bit of luck. > > A big thank you to whoever updated the 'Building on Linux' wiki > documentation, which was much improved over the last time I tried to build > Gnucash myself. Amen! I'm helping my wifeto move off Win7 (she won't use Win10) to ubuntu, and I set her up with 18.04 Mate. I did a build of 3.8 on her new installation t'other day and it went with no trouble at all, except I had to tell cmake not to try to build the sql parts. And that was no biggie. She doesn't use many of the advanced features, so I don't expect her to have big problems...I built her a 3.1 (on Centos) back when it was new and she had no issues with it either so I don't expect any on 3.8 either. Thanks to the hard-working Gnucash team! Fred -- Fred Smith -- fre...@fcshome.stoneham.ma.us - "Not everyone who says to me, 'Lord, Lord,' will enter the kingdom of heaven, but only he who does the will of my Father who is in heaven." -- Matthew 7:21 (niv) - ___ 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] v3.8
Thanks for the explanation, David. I think I may have been a bit over-zealous in my sudo use at the first stages of the procedure; that is perhaps what caused the permissions issue when I did not 'sudo' later on. I also run Gnucash inside Debian Buster virtual machines on both my Mac and Windows machines (as well as the native apps), so at some stage I will have to repeat this build operation there. When I do, I will try and be more careful about my sudo use and see if I can build without problems; I'll report back in due course. Now I know a bit more about how it should go, I would also like to see how much can be done without resort to buster-backports. Because these are virtual machines, which I can clone (backup) before I start, it will be a bit easier to experiment with. Buster has been out more than six months now and I may be ready soon for an upgrade to Bullseye ('testing' in Debian) soon. By then v3.8 may have reached the repository with a bit of luck. A big thank you to whoever updated the 'Building on Linux' wiki documentation, which was much improved over the last time I tried to build Gnucash myself. -- 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] v3.8 AQBanking in the US
I’ll check that piece of configuration over the weekend (and I never knew the xml could be uncompressed ... thanks Frank Ellenberger!) Sent from my iPhone > On Jan 2, 2020, at 11:40 AM, chris graves wrote: > > Derek, > > Yes, the symptoms I'm experiencing seem to be the same. > > Chris > >> On Jan 1, 2020, at 8:21 PM, Derek Robinson via gnucash-user >> wrote: >> >> We may be talking about the same issue - is the behavior what I described in >> my post earlier today? >> >> John Ralls ( or anyone else who might know ) - any idea where the link >> between an AqBanking account and the corresponding GC account is stored? >> >> Derek >> >> Sent from my iPhone >> ___ >> 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] v3.8 AQBanking in the US
Derek, Yes, the symptoms I'm experiencing seem to be the same. Chris > On Jan 1, 2020, at 8:21 PM, Derek Robinson via gnucash-user > wrote: > > We may be talking about the same issue - is the behavior what I described in > my post earlier today? > > John Ralls ( or anyone else who might know ) - any idea where the link > between an AqBanking account and the corresponding GC account is stored? > > Derek > > Sent from my iPhone > ___ > 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] v3.8
I fully appreciate everything you say. My suggestion was only posted to see if there was any way that 'amateurs' like myself who use it under Windows 10 on a PC, can feel happy. Of course there are no guarantees, even with expensive bought software, that is why I left more than one other accounting product. I normally wait to see if there is an 'uproar' even with MS so-called upgrades. David's explanation and sequencing information in the post above is invaluable, than you so much. Finbar On 01/01/2020 17:37, Greg Feneis wrote: Happy New Year, All Perhaps a better strategy is for the ordinary user to do the waiting. As is the case with a variety of software, both FOSS and commercial, you take some risk when immediately installing and running newly released software. It's just too complicated to test for all possible contingencies. Seems like the developers have to make the best compromise between development efforts and checking for every possible issue. Don't forget, everyone working on this project is doing it to benefit everyone for free. They somewhat rely on users to test and report back about their issues. ___ 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] v3.8 AQBanking in the US
HI, Am Do., 2. Jan. 2020 um 05:27 Uhr schrieb Derek Robinson via gnucash-user : > > We may be talking about the same issue - is the behavior what I described in > my post earlier today? > > John Ralls ( or anyone else who might know ) - any idea where the link > between an AqBanking account and the corresponding GC account is stored? https://wiki.gnucash.org/wiki/AqBanking#Config_Location > Derek HTH Frank ___ 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] v3.8 AQBanking in the US
We may be talking about the same issue - is the behavior what I described in my post earlier today? John Ralls ( or anyone else who might know ) - any idea where the link between an AqBanking account and the corresponding GC account is stored? Derek Sent from my iPhone ___ 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] v3.8
This definitely looks like a permissions issue. One possibility is if you downloaded the source file with root permissions or copied it to another location using sudo privileges it may have saved the file with ownership by the root user so when you try to build it as your normal user it does not have the permissions required to access the directory. Cmake does not have to be run as a super user (sudo) and after you have extracted the source directories from the downloaded file they should be owned by your login user as should all subdirectories including the build directories. If you used sudo privileges to create the build directory a similar problem may have occurred. Check the file ownership of the source directory and its subdirectories and of the build directory ("ls -al" if using a terminal). sudo only has to be used with the "make install" command (and not with the "make " command to build the libraries) when you are installing to a system location (/usr/local or /opt) so that the install procedure can copy the required files to a system owned location. 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] v3.8
Greg It is certainly possible to run a number of versions in parallel. I usually install my production version in /usr/local and I often initially install a new version under my home directory and work initially on a copy of the data file in a new location until I am happy to make it the production version usualy only a couple of days. It is also possible to install a separate version under /opt for use by all users. The catch is that the same user specific configuartion files are used by each version (and there sometimes can be conflicts). I also do a little minor deelopment and documentation work so I usually have the maint or master branches of the program and documentation installed at a separate location under my home directory. If you need to separate the user config files, you can always use a separate login to run each version but then you may need to copy data files to the new user. You can also put files in a dropbox location and the allow each user to signin and open them. 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] v3.8
Finbar, Each release announcement is accompanied by a list of fixes and a list of remaining bugs that the developers believe may be important to some users. Those lists are best estimates and more issues may appear when the release reaches a wider audience. It is then up to the user to estimate and compare the risk of adopting that release or waiting for the next release, not knowing whether his or her 'showstopper' bug will be fixed by then. Most 'bugs' can be worked around somehow, but is that ok for you? The developers also try to keep a path open for users to revert to an older release if they have a problem with the current release. This last release illustrates how difficult that can be when circumstances outside of their control get in the way, as the situation with AQBanking in Germany made both the new and the old releases fail in one way or another. David Carlson On Wed, Jan 1, 2020 at 3:46 PM David Cousens wrote: > Finbar, > > GnuCash is not generally altered between the stable releases unless you > are using the "master" or "maint" branches from > the Github repository to build GnuCash. > > If you are using the release tarball or a release version from the website > or made available via a Linux distribution it > will not change until the next release. The minor release e.g. > 3.0->3.1->3.2->3.3->3.4->... are usually bug fixes. The > major bugs which are show stoppers if any are likely to be fixed in the > first minor release after the major,i.e. 3.0 > release but they are hopefully found in prerelease testing. The bug fixes > are unlikely to affect the core functionality > and are mainly convenience features. The major release e.g 2.x.y->3.0 are > often where major changes have been made in > the code and unforseen bugs might be introduced. This is perhaps where a > less confident user should delay going to the > new version. With the 2.x.y->3.0 transition by the release of v3.2 Gnucash > was pretty well usable by the majority of > users. GnuCash is generally sufficiently flexible in its approach that a > workaround any problem is likely to be > available. > > I have used each version in the V3.x series within a day or two of its > release and have never encountered any major > functionality problems in the accounting core of GnuCash. I have an > accounting background and some programming > experience which gives me the confidence I can survive any problems. I > also backup my data files before installing a new > release and mark them with the release they pertain to so I can go back if > necessary but I have never had to do so. > Occasionally there are problems you have to work around with display and > reports etc and occasionally problems where > changes in the user file locations occurred but these are generally > resolved within a few days with either a workaround > or a patched release. GnuCash has a unit testing program in place which > is designed to detect any major bugs affecting > the core accounting functionality which helps to minimize major bugs even > on a 2->3 transition. > > I think it is hard to define at which point a minor release version is > stable enough for all users and there is no way > the developers can absolutely guarantee that that is the case. If you are > a business user and your livelihood depends on > your bookkeeping you are going to be less tolerant of minor bugs which > interfere with your workflow but not the core > accounting. I'm retired so my accounting is optional in many ways so if > it stuffs up I can afford the time to go back > and sort it out. The nature of the queries and the replies in the User > mailing list is often the best indicator. When > they drop off in frequency and users problems are being resolved quickly > and most relate to cosmetic features is usually > the point where a new release is usable by a majority of the user base. > > > > On Wed, 2020-01-01 at 12:30 +0100, Finbar Mahon wrote: > > I very much appreciate, and depend a lot on, Gnucash. But could I make a > > small recommendation? > > > > When a new version is launched would it be possible to announce when It > > works for 'ordinary' users? > > > > I have no trouble waiting until it is 'clean' > > > > HYN 2020 to all. > > > > Finbar > > > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: > > > It should but you will have to install all the dependencies and their > > > development headers to build successfully. There is a breakout page > from the > > > building instruction which gives you the dependencies to install. > (There are > > > occasionally some that are not covered as it depends on what the > particular > > > Linux distribution installs as standard and what libraries have been > > > installed with other software but it is now pretty complete). > > > > > > When you run cmake, it will stop with an error if anything is missing. > > > Identify the missing dependency or come back to the list, install it > and > > > rerun cmake until it completes
[GNC] v3.8 AQBanking in the US
Has anyone in the US been able to get Gnucash 3.8 AQBanking working? Specifically, Actions -> Online Actions -> Get Transactions ___ 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] v3.8
Finbar, GnuCash is not generally altered between the stable releases unless you are using the "master" or "maint" branches from the Github repository to build GnuCash. If you are using the release tarball or a release version from the website or made available via a Linux distribution it will not change until the next release. The minor release e.g. 3.0->3.1->3.2->3.3->3.4->... are usually bug fixes. The major bugs which are show stoppers if any are likely to be fixed in the first minor release after the major,i.e. 3.0 release but they are hopefully found in prerelease testing. The bug fixes are unlikely to affect the core functionality and are mainly convenience features. The major release e.g 2.x.y->3.0 are often where major changes have been made in the code and unforseen bugs might be introduced. This is perhaps where a less confident user should delay going to the new version. With the 2.x.y->3.0 transition by the release of v3.2 Gnucash was pretty well usable by the majority of users. GnuCash is generally sufficiently flexible in its approach that a workaround any problem is likely to be available. I have used each version in the V3.x series within a day or two of its release and have never encountered any major functionality problems in the accounting core of GnuCash. I have an accounting background and some programming experience which gives me the confidence I can survive any problems. I also backup my data files before installing a new release and mark them with the release they pertain to so I can go back if necessary but I have never had to do so. Occasionally there are problems you have to work around with display and reports etc and occasionally problems where changes in the user file locations occurred but these are generally resolved within a few days with either a workaround or a patched release. GnuCash has a unit testing program in place which is designed to detect any major bugs affecting the core accounting functionality which helps to minimize major bugs even on a 2->3 transition. I think it is hard to define at which point a minor release version is stable enough for all users and there is no way the developers can absolutely guarantee that that is the case. If you are a business user and your livelihood depends on your bookkeeping you are going to be less tolerant of minor bugs which interfere with your workflow but not the core accounting. I'm retired so my accounting is optional in many ways so if it stuffs up I can afford the time to go back and sort it out. The nature of the queries and the replies in the User mailing list is often the best indicator. When they drop off in frequency and users problems are being resolved quickly and most relate to cosmetic features is usually the point where a new release is usable by a majority of the user base. On Wed, 2020-01-01 at 12:30 +0100, Finbar Mahon wrote: > I very much appreciate, and depend a lot on, Gnucash. But could I make a > small recommendation? > > When a new version is launched would it be possible to announce when It > works for 'ordinary' users? > > I have no trouble waiting until it is 'clean' > > HYN 2020 to all. > > Finbar > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: > > It should but you will have to install all the dependencies and their > > development headers to build successfully. There is a breakout page from the > > building instruction which gives you the dependencies to install. (There are > > occasionally some that are not covered as it depends on what the particular > > Linux distribution installs as standard and what libraries have been > > installed with other software but it is now pretty complete). > > > > When you run cmake, it will stop with an error if anything is missing. > > Identify the missing dependency or come back to the list, install it and > > rerun cmake until it completes with out error. Library names can sometimes > > vary slightly between distributions to complicate matters (usually addition > > of a version number or "lib" in front > > > > apt-cache search is a good way to find libraries with a slightly > > different package name. > > > > > > > > - > > 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. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: >
Re: [GNC] v3.8
I eventually succeeded in building and installing Gnucash v3.8 on Debian Buster I installed to /usr/local because David had success with that. Not sure what I did to make it work, but it could have been any of the following: - used 'sudo' before cmake, make and make install commands; otherwise had permissions errors - I used: sudo cmake -DCMAKE_INSTALL_PREFIX=/usr/local ~/Downloads/gnucash-3.8b/gnucash-3.8 - after unsuccessful attempts, I deleted the build-gnucash-3.8 directory before every new attempt; when I did not, the make command seemed to think things were OK when they weren't and didn't, perhaps, instigate some of my fixes - I generally installed packages with dependency errors (if I saw them) with buster-backports (this was new for me, but see this URL: https://backports.debian.org/Instructions/ - because I had had an error on 'make' concerning aqbanking, I did a search in buster-backports for every package containing 'aqbanking' and installed them one by one with apt or apt-get before attempting another build -- 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] v3.8
On 01 January 2020 at 8:37, Greg Feneis said: [...] > My wish is that there was an easy way to install a newer GnuCash release > without giving up the previous, that they could run alongside each other > for a while. The PortableApps version usually seems too be one or two editions behind (hardly surprising!). Currently it's 3.7. ___ 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] v3.8
> On Jan 1, 2020, at 12:35 PM, boldstripe wrote: > > I'm attempting to build v 3.8 on Debian (Linux) Buster, using the > instructions on 'Building on Linux' and--as far as I can understand--a side > page on installing dependencies. I've run into an error on execution of the > 'make' command that I do not understand. Can anyone please suggest a > remedy?: > > [ 76%] Built target scm-test-load-gnome-utils-module > [ 76%] Built target gncmod-generic-import > CMake Error: Cannot open file for write: > /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp > CMake Error: : System Error: Permission denied > Scanning dependencies of target gncmod-aqbanking > CMake Error: Directory Information file not found > CMake Error: Cannot open file for write: > /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp > CMake Error: : System Error: Permission denied > make[2]: *** > [gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/build.make:307: > gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend] Error 2 > make[1]: *** [CMakeFiles/Makefile2:8630: > gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/all] Error 2 > make: *** [Makefile:163: all] Error 2 > And why can't it open that 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] v3.8
Stable releases are certainly intended to work for ordinary users, though it's always possible to have regressions. With AQBanking we have an unfortunate conundrum: The AQBanking developer wasn't paying attention to legal developments in Germany and the EU and was caught short by some substantial changes in the FinTS (formerly HBCI) system last September, to the point that the AQBanking completely stopped working there. He has since been playing catch-up with his development branch so that it mostly works again, but it's a development branch and isn't stable. Unfortunately that put us in the position of either bundling the last stable release of AQBanking that doesn't work at all in Germany or bundling the not-quite stable development beta release that mostly does work in Germany. I decided to go with the beta. If that turns out to be a problem for you you can review the changes in the release notes (see https://www.gnucash.org/news.phtml) and decide whether it's worth it to use 3.8 anyway or to stick with 3.7. Regards, John Ralls > On Jan 1, 2020, at 3:30 AM, Finbar Mahon wrote: > > I very much appreciate, and depend a lot on, Gnucash. But could I make a > small recommendation? > > When a new version is launched would it be possible to announce when It works > for 'ordinary' users? > > I have no trouble waiting until it is 'clean' > > HYN 2020 to all. > > Finbar > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: >> It should but you will have to install all the dependencies and their >> development headers to build successfully. There is a breakout page from the >> building instruction which gives you the dependencies to install. (There are >> occasionally some that are not covered as it depends on what the particular >> Linux distribution installs as standard and what libraries have been >> installed with other software but it is now pretty complete). >> >> When you run cmake, it will stop with an error if anything is missing. >> Identify the missing dependency or come back to the list, install it and >> rerun cmake until it completes with out error. Library names can sometimes >> vary slightly between distributions to complicate matters (usually addition >> of a version number or "lib" in front >> >> apt-cache search is a good way to find libraries with a slightly >> different package name. >> >> >> >> - >> 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. > ___ > 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] v3.8
I'm attempting to build v 3.8 on Debian (Linux) Buster, using the instructions on 'Building on Linux' and--as far as I can understand--a side page on installing dependencies. I've run into an error on execution of the 'make' command that I do not understand. Can anyone please suggest a remedy?: [ 76%] Built target scm-test-load-gnome-utils-module [ 76%] Built target gncmod-generic-import CMake Error: Cannot open file for write: /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp CMake Error: : System Error: Permission denied Scanning dependencies of target gncmod-aqbanking CMake Error: Directory Information file not found CMake Error: Cannot open file for write: /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp CMake Error: : System Error: Permission denied make[2]: *** [gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/build.make:307: gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend] Error 2 make[1]: *** [CMakeFiles/Makefile2:8630: gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/all] Error 2 make: *** [Makefile:163: all] Error 2 -- 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] v3.8
Finbar, I think the Gnucash developers do their due diligence in testing but some things don't appear until a wider group start to use the new version. If you depend on Gnucash, and you are using MacOS, I suggest you clone your drive with SuperDuper! or similar software before installing a new Gnucash and then test it for yourself. My MacOS Gnucash v3.8 works without problem. My issues installing Gnucash 3.8 on Debian Linux Buster are only of my own making: if I were more patient, the Debian system itself would automatically upgrade Gnucash for me after other Debian users had done a bit more testing. In a sense, I am trying to do something prematurely and only have myself to blame if it goes wrong. -- 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] v3.8
Happy New Year, All Perhaps a better strategy is for the ordinary user to do the waiting. As is the case with a variety of software, both FOSS and commercial, you take some risk when immediately installing and running newly released software. It's just too complicated to test for all possible contingencies. Seems like the developers have to make the best compromise between development efforts and checking for every possible issue. Don't forget, everyone working on this project is doing it to benefit everyone for free. They somewhat rely on users to test and report back about their issues. If anyone has resources to donate, please inquire where you may help. Anyone who has time may can get involved with helping to test before release, for example. I imagine there's a way to get access to a regular (perhaps daily?) build. This could be compiled and installed on a spare computer and tested with a copy of your normal working data. Report back what happens. I don't mean to direct this effort, but if anyone wants this process to improve, they should consider donating resources toward that improvement. I wish I had time to help more, but in my case, I'm still on 2.6.21. It serves me well, so I have no need to upgrade other than for a circumstance where I need to ask how to do something, it's better to have a recent version running. My wish is that there was an easy way to install a newer GnuCash release without giving up the previous, that they could run alongside each other for a while. Kind regards, Greg Feneis On Wed, Jan 1, 2020 at 4:15 AM Finbar Mahon wrote: > I very much appreciate, and depend a lot on, Gnucash. But could I make a > small recommendation? > > When a new version is launched would it be possible to announce when It > works for 'ordinary' users? > > I have no trouble waiting until it is 'clean' > > HYN 2020 to all. > > Finbar > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: > > It should but you will have to install all the dependencies and their > > development headers to build successfully. There is a breakout page from > the > > building instruction which gives you the dependencies to install. (There > are > > occasionally some that are not covered as it depends on what the > particular > > Linux distribution installs as standard and what libraries have been > > installed with other software but it is now pretty complete). > > > > When you run cmake, it will stop with an error if anything is missing. > > Identify the missing dependency or come back to the list, install it and > > rerun cmake until it completes with out error. Library names can > sometimes > > vary slightly between distributions to complicate matters (usually > addition > > of a version number or "lib" in front > > > > apt-cache search is a good way to find libraries with a slightly > > different package name. > > > > > > > > - > > 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. > ___ > 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] v3.8
I very much appreciate, and depend a lot on, Gnucash. But could I make a small recommendation? When a new version is launched would it be possible to announce when It works for 'ordinary' users? I have no trouble waiting until it is 'clean' HYN 2020 to all. Finbar On 01/01/2020 00:34, David Cousens via gnucash-user wrote: It should but you will have to install all the dependencies and their development headers to build successfully. There is a breakout page from the building instruction which gives you the dependencies to install. (There are occasionally some that are not covered as it depends on what the particular Linux distribution installs as standard and what libraries have been installed with other software but it is now pretty complete). When you run cmake, it will stop with an error if anything is missing. Identify the missing dependency or come back to the list, install it and rerun cmake until it completes with out error. Library names can sometimes vary slightly between distributions to complicate matters (usually addition of a version number or "lib" in front apt-cache search is a good way to find libraries with a slightly different package name. - 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. ___ 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] v3.8 - Unable to save to database message - all accounts zero
> On Dec 30, 2019, at 11:39 AM, brob2684 wrote: > > Hi, > > I just installed v3.8 on my Windows 10 machine (not sure exactly which > version I had previously, but it was at least v3.6). I save in the sqlite > format. > > When I open my file, all the account have zero balances. Double-clicking on > an account brings up an empty register (i.e. no transactions). Closing the > account generates the message 'unable to save to database'. > > Here's what I've done so far: > > 1. A google search got me to this post experiencing a similar error message: > http://gnucash.1415818.n4.nabble.com/GNC-Unable-to-save-to-database-Build-ID-3-2-2018-06-24-td4702739.html. > > 2. I took a look at https://wiki.gnucash.org/wiki/Tracefile to find the > trace file on my system. > > 3. Took a look at the trace file. It had lots of errors like this > > /* 06:14:22 ERROR > [GncDbiSqlConnection::execute_select_statement()] Error executing SQL SELECT > * FROM transactions WHERE guid IN (SELECT DISTINCT tx_guid FROM splits WHERE > account_guid = 'fd3362e93c5d4c55977254dfd1ee61a9') > * 06:14:22 ERROR [error_handler()] DBI *error: 1: no such > table: splits*/ > > 4. Opened up my sqlite gnucash file in a viewer and noted that the *splits* > table no longer exists, but there is a *splits_new* table. > > My question is, is there any harm in just dropping the *_new* suffix to > rename the table back to *splits*? Probably not, but make a copy of the file first. You might also find your latest backup before the upgrade, make a copy of that, and try opening it with 3.8, ideally by running GnuCash with --log gnc.backend.dbi=debug and then saving the tracefile aside so that it doesn't get overwritten. If the table upgrade fails again that might be helpful in diagnosing why. 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] v3.8
Well, that was the clue that fixed things for me. I was able to do a wee bit of cpan updating and it apparently fixed the conflict that was causing me all the failures. Everything works nicely. Also, if i might add, the latest 3.8 version seems to start up a bit quicker than its elder predecessor. Now, time to delve into how to apply GTK3 themes - if that's possible on MacOS. Thanks, John. - Ken Farley -- 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] v3.8 - Unable to save to database message - all accounts zero
Hi, I just installed v3.8 on my Windows 10 machine (not sure exactly which version I had previously, but it was at least v3.6). I save in the sqlite format. When I open my file, all the account have zero balances. Double-clicking on an account brings up an empty register (i.e. no transactions). Closing the account generates the message 'unable to save to database'. Here's what I've done so far: 1. A google search got me to this post experiencing a similar error message: http://gnucash.1415818.n4.nabble.com/GNC-Unable-to-save-to-database-Build-ID-3-2-2018-06-24-td4702739.html. 2. I took a look at https://wiki.gnucash.org/wiki/Tracefile to find the trace file on my system. 3. Took a look at the trace file. It had lots of errors like this /* 06:14:22 ERROR [GncDbiSqlConnection::execute_select_statement()] Error executing SQL SELECT * FROM transactions WHERE guid IN (SELECT DISTINCT tx_guid FROM splits WHERE account_guid = 'fd3362e93c5d4c55977254dfd1ee61a9') * 06:14:22 ERROR [error_handler()] DBI *error: 1: no such table: splits*/ 4. Opened up my sqlite gnucash file in a viewer and noted that the *splits* table no longer exists, but there is a *splits_new* table. My question is, is there any harm in just dropping the *_new* suffix to rename the table back to *splits*? brob2684 -- 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] v3.8
It should but you will have to install all the dependencies and their development headers to build successfully. There is a breakout page from the building instruction which gives you the dependencies to install. (There are occasionally some that are not covered as it depends on what the particular Linux distribution installs as standard and what libraries have been installed with other software but it is now pretty complete). When you run cmake, it will stop with an error if anything is missing. Identify the missing dependency or come back to the list, install it and rerun cmake until it completes with out error. Library names can sometimes vary slightly between distributions to complicate matters (usually addition of a version number or "lib" in front apt-cache search is a good way to find libraries with a slightly different package name. - 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] v3.8
If I build it myself on Debian Buster--using instructions in the Gnucash Wiki, 'Build for Linux'--will it solve the dependency issues for me? -- 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] v3.8
> On Dec 31, 2019, at 10:34 AM, farleykj wrote: > > Hi John, > Seems like I'm always dealing with Perl troubles on here. > I found the utility script you described, and the results I get with it are > as expected: > > < --- Begin Test --- > > $VAR1 = { > 'AMZNerrormsg' => 'Error retrieving quote for AMZN. Attempt to > fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=AMZN > resulted in HTTP response 500 (Internal Server Error)', > 'AMZNsymbol' => 'AMZN', > 'AMZNsuccess' => 0 >}; > < --- End Test --- > > > Perl: V5.18.2 > Finance::Quote V1.49 > MacOS Sierra V10.12.6 > > I'm kind of at a loss as to how to debug this given the above info. Could it > be that the URL in the YahooJSON.pm I have is no longer valid? > Nope. If I paste that into my browser I get a nice JSON quote. Maybe you have other perl modules, LWP comes to mind, that are borked. Try `sudo cpan -i Finance::Quote` which should get F::Q and all of its dependencies up to date. 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] v3.8
Hi John, Seems like I'm always dealing with Perl troubles on here. I found the utility script you described, and the results I get with it are as expected: < --- Begin Test --- > $VAR1 = { 'AMZNerrormsg' => 'Error retrieving quote for AMZN. Attempt to fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=AMZN resulted in HTTP response 500 (Internal Server Error)', 'AMZNsymbol' => 'AMZN', 'AMZNsuccess' => 0 }; < --- End Test --- > Perl: V5.18.2 Finance::Quote V1.49 MacOS Sierra V10.12.6 I'm kind of at a loss as to how to debug this given the above info. Could it be that the URL in the YahooJSON.pm I have is no longer valid? - Ken Farley -- 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] v3.8
> On Dec 31, 2019, at 9:57 AM, boldstripe wrote: > > I may have posted too soon without testing the debian packages for v3.8. > Installation from the v3.8 .deb files I gave the URL for failed for me on > Debian Buster when installing using apt (and individually using gdebi, with > similar dependency issues). I uninstalled v3.7 first. > > Here is a transcript from my Terminal session: > > michael@thinkpad-debian:~/Downloads$ cd gnucash_3.8_deb/ > michael@thinkpad-debian:~/Downloads/gnucash_3.8_deb$ sudo apt install > ./*3.8*.deb > Reading package lists... Done > Building dependency tree > Reading state information... Done > Note, selecting 'gnucash' instead of './gnucash_3.8b-1_amd64.deb' > Note, selecting 'gnucash-common' instead of > './gnucash-common_3.8b-1_all.deb' > Note, selecting 'python3-gnucash' instead of > './python3-gnucash_3.8b-1_amd64.deb' > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > gnucash : Depends: libaqbanking43 (>= 5.99.43) but it is not installable > Depends: libboost-regex1.67.0-icu63 but it is not installable > Depends: libgwengui-gtk3-0 (>= 4.99.24) but 4.20.0-9 is to be > installed > Depends: libgwenhywfar78 (>= 4.99.10beta) but it is not > installable > Depends: libstdc++6 (>= 9) but 8.3.0-6 is to be installed > Recommends: gnucash-docs but it is not going to be installed > E: Unable to correct problems, you have held broken packages. > As a guess, Dmitry built it for testing or unstable rather than stable. 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] v3.8
I may have posted too soon without testing the debian packages for v3.8. Installation from the v3.8 .deb files I gave the URL for failed for me on Debian Buster when installing using apt (and individually using gdebi, with similar dependency issues). I uninstalled v3.7 first. Here is a transcript from my Terminal session: michael@thinkpad-debian:~/Downloads$ cd gnucash_3.8_deb/ michael@thinkpad-debian:~/Downloads/gnucash_3.8_deb$ sudo apt install ./*3.8*.deb Reading package lists... Done Building dependency tree Reading state information... Done Note, selecting 'gnucash' instead of './gnucash_3.8b-1_amd64.deb' Note, selecting 'gnucash-common' instead of './gnucash-common_3.8b-1_all.deb' Note, selecting 'python3-gnucash' instead of './python3-gnucash_3.8b-1_amd64.deb' Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: gnucash : Depends: libaqbanking43 (>= 5.99.43) but it is not installable Depends: libboost-regex1.67.0-icu63 but it is not installable Depends: libgwengui-gtk3-0 (>= 4.99.24) but 4.20.0-9 is to be installed Depends: libgwenhywfar78 (>= 4.99.10beta) but it is not installable Depends: libstdc++6 (>= 9) but 8.3.0-6 is to be installed Recommends: gnucash-docs but it is not going to be installed E: Unable to correct problems, you have held broken packages. -- 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] v3.8
Someone helpfully placed .deb packages for Gnucash 3.8 here (today): http://ftp.us.debian.org/debian/pool/main/g/gnucash/ There are old postings on the mail list that explain how to use these. -- 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] v3.8
On MacOS 10.15 with GnuCash 3.8: /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump yahoo_json AMZN Finance::Quote fields Gnucash uses: symbol: AMZN <=== required date: 12/30/2019 <=== recommended currency: USD <=== required last: 1846.89 <=\ nav: <=== one of these price: <=/ timezone: <=== optional I don't remember offhand what perl shipped on Sierra, but Catalina has only 5.18 and the latest is 5.30. That's clearly not required. There's a test program, stockdump.pl in the cpan build directory (~/.cpan/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl on my system): ~/.cpan/build/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl yahoo_json AMZN $VAR1 = { 'AMZNvolume' => 3591419, 'AMZNlast' => '1846.89', 'AMZNmethod' => 'yahoo_json', 'AMZNdate' => '12/30/2019', 'AMZNcurrency' => 'USD', 'AMZNname' => 'AMZN (Amazon.com, Inc.)', 'AMZNsymbol' => 'AMZN', 'AMZNsuccess' => 1, 'AMZNisodate' => '2019-12-30', 'AMZNexchange' => 'Sourced from Yahoo Finance (as JSON)', 'AMZNtype' => 'EQUITY' }; That might be helpful for troubleshooting. Regards, John Ralls > On Dec 30, 2019, at 8:01 PM, farleykj via gnucash-user > wrote: > > Thanks, David. > I just used the quote downloading in the 2.6 version I was running > previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no > longer works. > Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I > ran the gnc-fq-update module to try and get things working, but to no avail. > That makes me think it's my Perl installation or something of the sort, > since I don't hear any others screaming about it. > I looked back through the old posts about this, but it always seemed to be > an alphavantage difficulty, or some such. I have been using "Yahoo as JSON" > for as long as that has been around, with no problems. > Maybe I'll need to install the latest Perl or something like that. How > tedious. > > > > - > Ken Farley > -- > 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. ___ 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] v3.8
Thanks, David. I just used the quote downloading in the 2.6 version I was running previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no longer works. Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I ran the gnc-fq-update module to try and get things working, but to no avail. That makes me think it's my Perl installation or something of the sort, since I don't hear any others screaming about it. I looked back through the old posts about this, but it always seemed to be an alphavantage difficulty, or some such. I have been using "Yahoo as JSON" for as long as that has been around, with no problems. Maybe I'll need to install the latest Perl or something like that. How tedious. - Ken Farley -- 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] v3.8
GunCash 3.8 Builds from the tarball successfully on Linux Mint 19.3 Tina and installs without any problems (/usr/local) Thanks John and the team. 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] v3.8
Ken, I think you will find a number of posts in the last 6 months about updating the finace quotes which may help you with this. Search for finance quotes on the user forum should return them. If notit will be a new bug 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] v3.8
I just updated from my previous 2.6 variant (can't recall the actual version, but it was near the end of the series). I cannot get any Finance::Quote data. Was using yahoo_json, but it doesn't work any more, not able to even get a quote for AMZN from gnc-fq-dump. Doesn't even return the date. Working on OS X (10.12.6, Sierra), by the way. - Ken Farley -- 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] v3.8
Saw that a new version got released. It... Version: 3.8 Build ID: 3.8b+(2019-12-29) Finance::Quote: 1.49 installed with no issues on my Windows 10 laptop. Still can't get aqbanking to work but will fiddle with it later. -- 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.