Re: [GNC] Transaction Entry Confirmation
> On Aug 31, 2021, at 8:06 AM, Jack Frillman via gnucash-user > wrote: > > > Is there any way to have GNU Cash make an audio confirmation when a manual > transaction has been entered? > > When I manually enter a transaction by mashing ENTER there is no feedback > that the transaction was entered and I keep hitting ENTER to be sure I didn't > fat finger it. > Just a little beep would suffice. No, sorry. 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] Can GnuCash compute income from foreign exchange transactions using the first in first out method?
GnuCash does have that built in, see Actions>View Lots. It is however a bit cumbersome and isn't likely to scale well for your use case. You might try using trading accounts and creating a balancing G/L transaction at the end of each day, but I think that will come out closer to average cost than to fifo. Regards, John Ralls > On Aug 30, 2021, at 5:04 PM, Tim Hume via gnucash-user > wrote: > > Hi everyone, > > I'm using GnuCash for a small money transfer business. There are lots of > transactions from Australia to Tonga, and transactions going the other way > (Tonga to Australia) too. Transactions are of varying amounts and happen > frequently. > > From day to day GnuCash handles this fine (though the database is getting > rather large). In fact, one reason for using GnuCash is that it handles > foreign currencies (and it's free). For tax, it is necessary to compute > income using the first in first out method (FIFO). The way I've been doing > this to date is to dump the transactions going through the trading accounts > into CSV format, and then using a small program I wrote to compute the income > using the FIFO method (the program is written in awk for anyone curious). > > However, it would be really nice if GnuCash could do this computation itself. > Is this possible? > > Cheers, > > Tim. > > Sent with ProtonMail Secure Email. > ___ > 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] Alternate Language (Again)
> On Aug 27, 2021, at 2:59 PM, wrote: > > I should be following up an earlier thread of two weeks ago, but I find I've > deleted the messages from my Inbox and can't see any way to "Reply To" > something I only have in the archives. So I'm creating a new thread > (Apologies: I'm no longer used to using true mailing lists instead of > wrappers like nabble that make it all child's play). > > Here's that prior thread: > >> On Aug 20, 2021, at 10:29 AM, > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> wrote: >> >> Hello all. This may have already been covered, but after the death of > Nabble >> I can't see how to do searches throughout the archive. >> >> I need to produce accounting reports in a different language (French), but > I >> would prefer to use a single installation of Gnucash (all my other sets of >> books are English). >> >> 1. Can I switch languages just for printing the reports? If yes, how? I >> understand that the Account Names, Descriptions, and so on are all going > to >> need to be recorded in French in this set of books. >> >> 2. If that's not possible, how can I install two versions of GnuCash on >> Windows? Can I open the books in English Gnucash, work on them, then close >> and reopen the same books in the French GnuCash? > > Most search engines can search the list archives, just say > site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. > > There's no such thing as English or French versions of GnuCash, every > installation on Windows and macOS includes all of the translations. Some > Linux distros try to save a few kB of space by separating out the > translations, but that's not your concern. > > What you want to do is make a shortcut to GnuCash with the LANG environment > variable set to "fr_FR" as explained by this blog post: > https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows > -shortcut/ > > Regards, > John Ralls > > = > > That seemed to fully answer the basic question, but now that I try it out, I > find it doesn't work. I still get everything (except the creation of the > Chart of Accounts, for which the language selection is working) in English. > > Here is the shortcut target I'm using, as per the link suggested: > > C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && START /D ^"C:\Program > Files (x86)\gnucash\bin^" gnucash.exe" > > Compare with the webpage text, which is: > C:\Windows\System32\cmd.exe /c "SET LANG=en && START /D ^"C:\Program Files > (x86)\Inkscape^" inkscape.exe" > > As these are as close to identical as can be achieved, I am at a loss as to > why it doesn't work. GnuCash has another layer to it's localization. Try C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && SET LANGUAGE=fr_FR && START /D ^"C:\Program Files (x86)\gnucash\bin^" gnucash.exe" 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] windows 10 and v4.6 possible system language vs appliation language
> On Aug 27, 2021, at 12:37 PM, Karin Lagesen wrote: > > Hi! > > I just started using v4.6 on a new machine running windows 10. For > various reasons, despite being in Norway, I prefer having US language on my > main computer, including date formats. However, I prefer having numbers on > gnucash being in Norwegian format. > > Is there any way to run gnucash in Norwegian on a otherwise US region > computer? > https://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_a_different_language_than_my_monetary.2Fdecimal_separator 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] Paying expenses with cryptocurrency
> On Aug 27, 2021, at 10:25 AM, David G. Pickett via gnucash-user > wrote: > > I am sure the accountants would not like the idea, but it opens the subject > of having different accounts in different currencies. This seems less > revolutionary in an international commerce world, like having a London > account in Pounds Sterling. You could buy with any account in the currency > of that account, rather than a book/default currency. I wonder if that would > hide any capital appreciation in the currency, perhaps legally, somewhat like > barter? I guess it would be an enhancement suggestion. I guess you mean to allow Equity accounts in foreign--meaning not the book's--currencies. You can already have Asset and Liability accounts in any commodity you like. Legality aside, why would you want to hide trading G/L from yourself? Why go to the trouble of keeping your books in GnuCash if you don't want an accurate model of your financial condition? 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] Paying expenses with cryptocurrency
> On Aug 25, 2021, at 10:29 PM, Peter West wrote: > > The recommended mode of dealing with crypto seems to be to record your crypto > as a stock, and handle fluctuation in prices as you would for a stock. When > you are investing crypto that makes sense. But what if you are using crypto > for purchases? That is, if you are using cryptocurrency for the originally > intended purpose? > > Any ideas on how to record this? Aside from the way GnuCash presents assets in registers the only difference between currencies and non-currency commodities is that you can't have Equity or Payable/Receivable accounts denominated in non-currency commodities. We've been told by a licensed accountant that one shouldn't have those accounts in anything other than the book currency anyway. So the answer is that that's how you account for transactions in all currencies, crypto or national, other than the book currency: You price them back to the book currency on the day of the transaction and record any resulting trading gains or losses. Do it any other way and you'll make yourself crazy trying to get your book to balance. 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] Job Costing as now available
I'll respond now: No, nothing like that has been contributed nor is it being contemplated by any of the core devs AFAIK. Well designed and written pull requests welcome. Regards, John Ralls > On Aug 21, 2021, at 9:42 AM, Mike Butcher wrote: > > Don, have you seen any response to this message or find a solution > otherwise? I too need this function in a big way. Making a new account for > every order is horribly messy and cumbersome. It's been a year and a half > and I was hoping someone on the development team might have an answer. I > love GNUcash for my personal life but cannot use it for business without > some form of jobcosting. I have to reenter info into a database I > assembled for that. > > Take care, > ~Mike Butcher > > On Sat, May 23, 2020 at 4:04 PM doncram wrote: > >> Hi, I recently installed and am using GnuCash (Version: 3.10 / Build ID: >> 3.10+(2020-04-11), on Windows). I am happy to see some functionality for >> Job Costing has been added in recent years. This is very important to >> develop so that many more small businesses could possibly use GnuCash. But >> what is available vs. what is missing and critically needed? >> >> Job Costing allows for projects to be defined for, say, construction firms >> building individual houses, or catering firms doing catering jobs, or >> manufacturing firms building batches of product. Or it allows a nonprofit >> or business to define a job for a specific grant or other restricted >> funding source. And then to track and match the revenues and expenses >> specific to each project. >> >> This is terribly important so that management can attempt to figure out >> which jobs have been more profitable and why. And I have seen arriving >> users turned away from GnuCash (e.g. a catering firm a few years ago) >> because it has been so clear that GnuCash can't serve them. The catering >> firm needed to do separate accounting & reports for each job, but if i >> recall correctly was told that it should do it by creating new accounts >> specific to each job. So its Chart of Accounts would grow longer and >> longer as its Sales and various Expense types of accounts would have to be >> duplicated for each repetitive client/job. It would need to create a new >> account, e.g. Sales-Job#013 for the payments it received for job number 13, >> and a new Food purchases-Job#13 and a new Labor-Job#13 etc. for each of its >> standard type of expenses. This would rapidly become totally unworkable, >> and it does not allow for side-by-side comparison of >> revenues/expenses/profitability of jobs, so of course the catering person >> went away. And for existing firms that do use GnuCash but have not tracked >> separate projects/jobs to date, many of them could benefit if they could be >> allowed to start doing so. >> >> In the current stable version of GnuCash, it is now possible to create >> jobs. For example, I created a "test b company" with several expense >> transactions, and created a "job1" underneath "customer A". I can't see >> yet how to assign job codes to any specific revenue or expense item. In >> any account register, a new Customer:Job column needs to appear, where I >> would enter the relevant job for each line ("split"). I should not be >> _required_ to enter anything into the Customer:Job column, but for any >> split where I do want to assign the expense or revenue to a specific job, I >> should be able to do so. And, say if I pay $200 to one contractor for work >> done on two jobs, I would create two splits, one for each job, and record, >> say $120 of contractor expense for job#13 and $80 for job #14. >> >> Then I want/need an Income Statement By Job report, which would be a >> regular Income Statement in its first columns, and would report >> job-specific income statements for each job in following columns. So this >> would possibly become a very wide report, but that is okay by me, as long >> as I can scroll over to see any specific job. And like for other reports, >> I should be able to set Options / Display to show only the rows where there >> is any non-zero data, and also only the columns where there is any non-zero >> data (so in a report for Fiscal Year 2020, I don't have to see a column for >> a job completed in 2018). >> >> The only report I find, though, is the one at Reports/Business/Job, which >> turns out to be some kind of Aging of Receivables report for just one job. >> Instead of allowing me to run this report for all jobs (like should be >> available in a general Aging of Receivables r
Re: [GNC] Reports in Alternate Language
> On Aug 20, 2021, at 10:29 AM, wrote: > > Hello all. This may have already been covered, but after the death of Nabble > I can't see how to do searches throughout the archive. > > > > I need to produce accounting reports in a different language (French), but I > would prefer to use a single installation of Gnucash (all my other sets of > books are English). > > > > 1.Can I switch languages just for printing the reports? If yes, how? I > understand that the Account Names, Descriptions, and so on are all going to > need to be recorded in French in this set of books. > > > > 2.If that's not possible, how can I install two versions of GnuCash on > Windows? Can I open the books in English Gnucash, work on them, then close > and reopen the same books in the French GnuCash? > Most search engines can search the list archives, just say site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. There's no such thing as English or French versions of GnuCash, every installation on Windows and macOS includes all of the translations. Some Linux distros try to save a few kB of space by separating out the translations, but that's not your concern. What you want to do is make a shortcut to GnuCash with the LANG environment variable set to "fr_FR" as explained by this blog post: https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows-shortcut/ 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] Finance::Quote on Mac M1
That's what "Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own." is about. The issue is that when you launch from Finder there's no shell so GnuCash can't see your MacPorts environment changes. Try launching GnuCash from a shell window that does have the MacPorts environment. Regards, John Ralls > On Aug 20, 2021, at 3:55 AM, Peter West wrote: > > Doesn’t work for me. > > Note: I’m assuming that the message Finance::Quote not installed properly, > when Add is invoked in the security editor, means that it’s not installed > properly. > > I depend a lot on MacPorts. I’ve tried forcing the installation with MacPorts > perl 5.34 foremost in my path, and with it (and all other perl binaries) > relegated in my path. It makes no difference to the appearance of that > message. > > In each case I have checked the installation paths of perl. In the first the > installation paths are in /opt/local, in the latter they are in /usr, > /Library, /System, /Network and /usr/local. > > Peter > — > Peter West > p...@ehealth.id.au > “On these two commandments depend all the Law and the Prophets.” > >> On 20 Aug 2021, at 2:21 pm, Colin wrote: >> >> Thank you John! I ran the commands you provided and Finance::Quote works for >> the first time since I got my M1 MacBook Air! I’ve been watching the >> Finance::Quote threads on the list the last few months, always hoping for a >> solution I could manage to I implement to fix the issue. No doubt I could >> have missed this if it was posted before, regardless you just made my day. >> >> For what it’s worth, my install of GnuCash was done the standard way - >> downloading the DMG from the website. >> >> Also, to make the solution crystal clear to those who are not as good on the >> command line, there was a typo in John’s most recent advice of the commands >> to run. It is B::Keywords (capital K): >> >> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i Finance::Quote >> >> Very gratefully, >> Colin >> >>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote: >>> >>> Message: 5 >>> Date: Thu, 19 Aug 2021 20:36:28 -0700 >>> From: John Ralls mailto:jra...@ceridwen.us>> >>> To: davel...@mac.com <mailto:davel...@mac.com> >>> Cc: Mailing List Gnucash >> <mailto:gnucash-user@gnucash.org>> >>> Subject: Re: [GNC] Finance::Quote on Mac M1 >>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us >>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>> >>> Content-Type: text/plain; charset=utf-8 >>> >>> You didn't read my letter very carefully: You should be able to get quotes >>> now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan >>> -i Finance::Quote`. The system perl is a universal binary and works in both >>> native and Rosetta2 environments. Perl from other sources may or may not >>> work and will regardless require modifying >>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path >>> and @INC so that GnuCash can find the right F::Q. If you insist on that >>> you're on your own. >>> >>> As for a native M1 build, I haven't decided yet whether to do that before >>> the next major nettle release. I really don't like pushing development >>> software at ordinary users, it tends to make for unpleasant surprises. >>> Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong >>> argument for doing a native build until nettle's ARM64 implementation is in >>> a stable release. >>> >>> 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.o
Re: [GNC] Finance::Quote on Mac M1
You didn't read my letter very carefully: You should be able to get quotes now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan -i Finance::Quote`. The system perl is a universal binary and works in both native and Rosetta2 environments. Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own. As for a native M1 build, I haven't decided yet whether to do that before the next major nettle release. I really don't like pushing development software at ordinary users, it tends to make for unpleasant surprises. Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong argument for doing a native build until nettle's ARM64 implementation is in a stable release. Regards, John Ralls > On Aug 19, 2021, at 3:12 PM, davelist--- via gnucash-user > wrote: > > So does this mean a future official build of gnucash will have an ARM version > and we'll be able to get quotes again? That would be great! > > Thanks, > Dave > >> On Aug 19, 2021, at 5:43 PM, John Ralls wrote: >> >> You can't escape the problems. ;-) >> >> FWIW I just completed building on an M1 with Monterey. Amazingly, there were >> only a few minor problems, one of which has nothing to do with M1 or >> Monterey: Boost's download site changed. >> >> Libdbi and libdbi-drivers last release tarballs were made in 2013 and >> include linker arguments that aren't supported. I switched the build to git >> clones so that the build can be regenerated from scratch. Both that and the >> Boost change are committed to gnucash-on-osx. >> >> The other problem, and perhaps the one that stopped you on MacPorts, is that >> even the latest release of Nettle from last month doesn't support ARM64. It >> tries to compile ARM32 and fails noisily for hundreds of unrecognized >> assembler instructions. The solution is to clone the master branch from >> http://git.lysator.liu.se/nettle/nettle and build that instead. >> >> BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, >> after which everything else built correctly. Once F::Q was installed in >> /Library/Perl GnuCash was able to recognize it and enable the Get Quotes >> button. >> >> Regards, >> John Ralls >> >> >> >> >>> On Aug 19, 2021, at 1:40 AM, Peter West wrote: >>> >>> Hi John, >>> >>> I had already run into problems trying to build GnuCash on MacPorts. I was >>> encouraged to try to build by reading >>> <https://wiki.gnucash.org/wiki/MacOS/Quartz>. >>> >>> Peter >>> — >>> Peter West >>> p...@ehealth.id.au >>> “For behold, when the sound of your greeting came to my ears, the baby in >>> my womb leaped for joy.” >>> >>>> On 17 Aug 2021, at 1:02 am, John Ralls wrote: >>>> >>>> >>>> Support for gtk-osx is on its mailing list, >>>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you >>>> go there I'll remind you that one of gtk-osx's basic requirements is that >>>> you must not have Homebrew or MacPorts visible to it. >>>> >>>> Since you have MacPorts installed already the simplest way forward is to >>>> use that to build GnuCash. >>>> >>>> That said there's no shared code between anything to do with GnuCash and >>>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from >>>> source won't help you get Finance::Quote going. >>>> >>>> Regards, >>>> John Ralls >>>> >>>>> On Aug 16, 2021, at 7:18 AM, Peter West wrote: >>>>> >>>>> I removed the offending PREFIX line from jhbuildrc-custom, and >>>>> immediately ran into a similar problem. >>>>> >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>>>> execfile(filename, config) >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >>>>> execfile >>>>> exec(code, globals, locals) >>>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>>>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) >>>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in >>>>
[GNC] Creating Custom Reports
Good Day to you all! I have just set up my family finances with GnuCash (version 4.6) and am looking into the various reports. What I need, and have yet to find, is a simply report my wife and I can access to see how well me are doing with our budget each day. Specifically I am looking for the following: Checking Acct #1 Today's Balance + Checking Acct #2 Today's Balance = Daily Balance Subtotal - Budgeted Total amount budgeted for the current pay period. This would include All Budgeted Expenses & Amounts Transferred to holding accounts for later payments. This could also be expandable to the various sub accounts I have set up + Paid Amounts already paid out for all expenses and transfers to Holding Accounts. These cold also be expandable to include sub accounts. = Available Balance What is left for discretionary spending. This is the big one that I would like to see spelled out for us. Each of the reports I have seen and played with will do some of this but I haven't seen any that will give me all of the above. If there is something out there or if I am missing something, I would really like to know. Anyone who could help me out with this, I would really appreciate. Thank you very much. John ___ 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] Finance::Quote on Mac M1
You can't escape the problems. ;-) FWIW I just completed building on an M1 with Monterey. Amazingly, there were only a few minor problems, one of which has nothing to do with M1 or Monterey: Boost's download site changed. Libdbi and libdbi-drivers last release tarballs were made in 2013 and include linker arguments that aren't supported. I switched the build to git clones so that the build can be regenerated from scratch. Both that and the Boost change are committed to gnucash-on-osx. The other problem, and perhaps the one that stopped you on MacPorts, is that even the latest release of Nettle from last month doesn't support ARM64. It tries to compile ARM32 and fails noisily for hundreds of unrecognized assembler instructions. The solution is to clone the master branch from http://git.lysator.liu.se/nettle/nettle and build that instead. BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, after which everything else built correctly. Once F::Q was installed in /Library/Perl GnuCash was able to recognize it and enable the Get Quotes button. Regards, John Ralls > On Aug 19, 2021, at 1:40 AM, Peter West wrote: > > Hi John, > > I had already run into problems trying to build GnuCash on MacPorts. I was > encouraged to try to build by reading > <https://wiki.gnucash.org/wiki/MacOS/Quartz>. > > Peter > — > Peter West > p...@ehealth.id.au > “For behold, when the sound of your greeting came to my ears, the baby in my > womb leaped for joy.” > >> On 17 Aug 2021, at 1:02 am, John Ralls wrote: >> >> >> Support for gtk-osx is on its mailing list, >> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you >> go there I'll remind you that one of gtk-osx's basic requirements is that >> you must not have Homebrew or MacPorts visible to it. >> >> Since you have MacPorts installed already the simplest way forward is to use >> that to build GnuCash. >> >> That said there's no shared code between anything to do with GnuCash and >> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from source >> won't help you get Finance::Quote going. >> >> Regards, >> John Ralls >> >>> On Aug 16, 2021, at 7:18 AM, Peter West wrote: >>> >>> I removed the offending PREFIX line from jhbuildrc-custom, and immediately >>> ran into a similar problem. >>> >>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>> execfile(filename, config) >>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >>> execfile >>> exec(code, globals, locals) >>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) >>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in >>> module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + ' >>> -std=c++17'} >>> File >>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py", >>> line 675, in __getitem__ >>> raise KeyError(key) from None >>> KeyError: 'CXXFLAGS' >>> jhbuild: could not load config file >>> >>> In this one, there is obviously a default value, but the Error is >>> propagating all the way up. >>> >>> Peter >>> >>> >>> — >>> Peter West >>> p...@ehealth.id.au >>> “For behold, when the sound of your greeting came to my ears, the baby in >>> my womb leaped for joy.” >>> >>>> On 16 Aug 2021, at 8:21 pm, Peter West wrote: >>>> >>>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get >>>> M1-specific GNC and Finance::Quote working together without any mysterious >>>> issues. >>>> >>>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it >>>> fails immediately. >>>> >>>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx >>>> Loading .env environment variables... >>>> Traceback (most recent call last): >>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>>> execfile(filename, config) >>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >>>> execfile >>>> exec(code, globals, locals) >>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>>> exec(compile(open(_user_rc, "rb").re
Re: [GNC] Finance::Quote on Mac M1
Support for gtk-osx is on its mailing list, https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you go there I'll remind you that one of gtk-osx's basic requirements is that you must not have Homebrew or MacPorts visible to it. Since you have MacPorts installed already the simplest way forward is to use that to build GnuCash. That said there's no shared code between anything to do with GnuCash and perl or any CPAN modules beyond the macOS SDK. Building GnuCash from source won't help you get Finance::Quote going. Regards, John Ralls > On Aug 16, 2021, at 7:18 AM, Peter West wrote: > > I removed the offending PREFIX line from jhbuildrc-custom, and immediately > ran into a similar problem. > > File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >execfile(filename, config) > File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in > execfile >exec(code, globals, locals) > File "/Users/gtkdev/.config/jhbuildrc", line 470, in >exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) > File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in >module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + ' > -std=c++17'} > File > "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py", > line 675, in __getitem__ >raise KeyError(key) from None > KeyError: 'CXXFLAGS' > jhbuild: could not load config file > > In this one, there is obviously a default value, but the Error is propagating > all the way up. > > Peter > > > — > Peter West > p...@ehealth.id.au > “For behold, when the sound of your greeting came to my ears, the baby in my > womb leaped for joy.” > >> On 16 Aug 2021, at 8:21 pm, Peter West wrote: >> >> I’ve decided to go the whole hog and build GNC. Hopefully, I can get >> M1-specific GNC and Finance::Quote working together without any mysterious >> issues. >> >> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it fails >> immediately. >> >> ~ 20:14:24$ jhbuild bootstrap-gtk-osx >> Loading .env environment variables... >> Traceback (most recent call last): >> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>execfile(filename, config) >> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >> execfile >>exec(code, globals, locals) >> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) >> File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in >>prefix = os.environ['PREFIX'] >> File >> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py", >> line 675, in __getitem__ >>raise KeyError(key) from None >> KeyError: 'PREFIX' >> jhbuild: could not load config file >> >> >> I' >> >> The first thing in .config/jhbuildrc-custom is >> prefix = os.environ['PREFIX’] >> >> So there is no envar PREFIX defined in my environment. That’s easy enough to >> fix, but what is it supposed to be? Should this Error jusst be caught and >> defaulted? >> >> I don’t do python, so I don’t know how the error/exception process works. >> >> Peter >> >> — >> Peter West >> p...@ehealth.id.au <mailto:p...@ehealth.id.au> >> “For behold, when the sound of your greeting came to my ears, the baby in my >> womb leaped for joy.” >> >>> On 4 Aug 2021, at 7:39 pm, Geoff >> <mailto:cleanoutmys...@gmail.com>> wrote: >>> >>> Yes, I don't like doing forced installations either, but this particular >>> module isn't very important in the overall Finance::Quote scheme of events. >>> >>> Here are two suggestions. >>> >>> (1) Hack. I'm not familiar with MAC directory structures, but I had a look >>> at the particular test that is failing, and I reckon that if you create an >>> empty file here it might just trick it into passing: >>> >>> /System/Library/Perl/5.30/darwin-thread-multi-2level/CORE/keywords.h >>> >>> >>> (2) Manual install of B::Keywords without using CPAN: >>> (a) Download B-Keywords-1.22.tar.gz from here: >>> https://metacpan.org/pod/B::Keywords <https://metacpan.org/pod/B::Keywords> >>> >>> (b) Unzip and untar it to a temp directory. >>> >>> (c) From the command line in that dire
Re: [GNC] password when using mysql backend
I don't think that Libsecret is optional and AFAIK no user configuration is necessary. The file you'll need to rewrite to suit your purposes is gnucash/gnome-utils/gnc-keyring.c. Good Luck. Regards, John Ralls > On Aug 13, 2021, at 9:09 PM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > thank you, but I am not using gnome keyring, or any other key manager. > > I would like to simply store the password somewhere in a file in my > gnucash profile. > > how can I do this? > > > On 2021-08-13 17:59, John Ralls wrote: >>> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: >>> Is it possible to store the mysql password somewhere locally? >> >> It's supposed to be stored in libsecret. Check your trace file >> (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings >> gnc_keyring_set_password and gnc_keyring_get_password. >> >> 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] password when using mysql backend
> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > Hello, > > I am using gnucash 3.4-1 on Debian 10. And I am using mysql backend. > > Every time I start gnucash, I have to type my password manually. This is > very annoying, and as far as I can tell adds no real security. > > Is it possible to store the mysql password somewhere locally? > > If this is not possible, how could I hardcode the password into gnucash, > and recompile ? I am fine with recompiling, I had to do it for other > purpose anyway It's supposed to be stored in libsecret. Check your trace file (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings gnc_keyring_set_password and gnc_keyring_get_password. 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.
[GNC] Creating Reports
Good Day to yo all! I have just set up my family finances with GnuCash (version4.6) and am looking into the various reports. What I need, and have yet to find, is a simply report my wife and I can access to see how well me are doing with our budget each day. Specifically I am looking for the following: Checking Acct #1 Today's Balance + Checking Acct #2 Today's Balance = Daily Balance Subtotal - Budgeted Total amount budgeted for the current pay period. This would include All Budgeted Expenses & Amounts Transferred to holding accounts for later payments. This could also be expandable to the various sub accounts I have set up + Paid Amounts already paid out for all expenses and transfers to Holding Accounts. These cold also be expandable to include sub accounts. = Available Balance What is left for discretionary spending. This is the big one that I would like to see spelled out for us. Each of the reports I have seen and played with will do some of this but i haven't seen any that will give me all of it. If there is something out there or if I am missing something, I would really like to know. Anyone who could help me out with this, I would really appreciate. Thank you very much. John ___ 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] Mutual Fund - Price Import from csv, "Namespace could not be understood"
> On Aug 7, 2021, at 1:35 PM, Ashok Sinha wrote: > > Hello everyone, trying this list for the first time, I hope I am following > the instructions. > > I have downloaded and prepared an import.csv file with 2 lines as: > 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021 > 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064 > > Where the columns are Date, Namespace, From Symbol, To Currency, Amount > > The 'Namespace', & 'Currency To' dropdown comes up with an error > respectively as: > Error 1: Column 'From Namespace' could not be understood. Value can't be > parsed into a valid namespace. > Error 2: Column 'Currency To' could not be understood. Value can't be > parsed into a valide commodity. > > Could somebody please explain to me how to import the prices? I think I'm > doing it right - there's a screenshot below. > > The above example has 2 different mutual funds. Once the concept is proved, > I plan to update many (~20) mutual fund prices from a single import csv > file on a weekly basis. Try removing the leading spaces from the namespace and currency columns. 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] Gnucash on macOS Monterey beta
David, Please don't write me or other GnuCash developers directly unless explicitly asked to. Please use the lists, IRC, or the bug tracker. Yes, Gtk window scaling issues on Monterey have already been reported: https://bugs.gnucash.org/show_bug.cgi?id=798207 Regards, John Ralls > On Jul 27, 2021, at 3:57 PM, David Reed wrote: > > John, > > I'm have a couple hobby iOS/Mac apps so I've installed the macOS Monterey > beta in a separate APFS container. Just in case you're not aware, GnuCash > does not seem to work correctly on it. The window seems to not scale > correctly and I can't select the open/cancel button in the file dialog to > open a file. I may have missed someone asking on the GnuCash mailing list as > I haven't been good keeping up with it but wanted you to know if you weren't > aware so perhaps as Monterey gets closer to release, people are warned if it > doesn't work then yet. > > If it would be helpful to see screenshots (if you don't have access to > Monterey) or anything else, let me know. > > Thanks for all that you do in support GnuCash! > > Dave > ___ 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] Invoice font size has changed
> On Jul 27, 2021, at 10:01 AM, coolnodje wrote: > > Hi, > > the invoice I print from Gnucash have become printed smaller for some > reason. > I can't explain it, nor can I find any place to control this. (I > switched from Default to CSS experimental which makes it slightly larger > but still quite smaller than it used to be) > > I upgraded to 4.6 as soon as it was out (I'm using brew on MacOS ) and > believe my last invoice was made with this same latest version. > I rebooted my computer, which was on for a lot longer than when the new > release was installed. (it's not supposed to explain anything, but as I > keep Gnucash open all the time these days, switching book accounts, it > feels like it's the most meaningful change I've made to my Gnucash ... sic) Edit>Stylesheets. The CSS-based stylesheet uses CSS directly, so adjust the font-size attributes in the elements you want to change. If you don't know CSS works you might prefer to switch back to the stylesheet you were using before and edit it instead. Go to the fonts tab and use the font chooser to select the typeface and size you want for each element. 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] piecharts/linecharts turned blank in reports after upgrade
No, that switches only the libgnc*.so libs in lib/gnucash. There are others in lib/. You cannot build GnuCash with an installed GnuCash. You must `sudo apt-get remove gnucash` then `rm -rf *` your build directory and re-run cmake && ninja. Regards, John Ralls > On Jul 20, 2021, at 9:16 PM, Dong Lin wrote: > > > vm-ubuntu-1:~/src/build-gnucash$ mv lib lib-local-build > vm-ubuntu-1:~/src/build-gnucash$ ln -s /usr/lib/x86_64-linux-gnu/gnucash lib > > this only switches the libgnc-*.so libs only. all other libs continue to > point to /usr/lib. > > vm-ubuntu-1:~/src/build-gnucash$ ./bin/gnucash > ./bin/gnucash: symbol lookup error: ./bin/gnucash: undefined symbol: > gnc_run_report_with_error_handling > > >> Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was >> libgnc-html.so linked to if not the ones in /usr/lib? >> >> Regards, >> John Ralls >> >>> On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: >>> >>> >>> On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the >>> apt >>> installed GNC runs fine with charts visible. >>> >>> But locally built GNC (tip of the latest maint branch) has the same >>> issue. >>> I tried switching the libs in build_dir to point to >>> /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an >>> undefined symbol gnc_run_report_with_error_handling and couldn't start. >>> >>> apt removed the system gnucash, purged ~/.cache. reran the local gnc, >>> same >>> problem, blank charts. >>> only the table is visible. >>> >>> the build environment was prepared with apt-get build-dep gnucash as >>> instructed. >>> ___ 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] piecharts/linecharts turned blank in reports after upgrade
Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was libgnc-html.so linked to if not the ones in /usr/lib? Regards, John Ralls > On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: > > > On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the apt > installed GNC runs fine with charts visible. > > But locally built GNC (tip of the latest maint branch) has the same issue. > I tried switching the libs in build_dir to point to > /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an > undefined symbol gnc_run_report_with_error_handling and couldn't start. > > apt removed the system gnucash, purged ~/.cache. reran the local gnc, same > problem, blank charts. > only the table is visible. > > the build environment was prepared with apt-get build-dep gnucash as > instructed. > > >> >> Thank you John. I can confirm that 4.x works with Ubuntu 21.04. >> >> As for release 3.11, the problem exists with the unstable version of 3.11 >> (4064c58cd) only. The stable 3.11 (0fe8ba79e) release works just fine. >> >> | * | | 0fe9ba79e21d0545f4c1f9eb373a9450803a83c4 Release GnuCash 3.11 >> * | | | | | | 4064c58cd03b7f7fb613d593c93569048adb Release GnuCash >> 3.11 >> >> I guess issue lies in it's one of the 163 shared libs that GNC uses that >> came with Ubuntu 20.04. >> >> >>> Dong Lin, >>> >>> You've already demonstrated that the problem doesn't happen on 3.11 so >>> there's no point going backwards in 3.x. >>> According to https://repology.org/project/gnucash/versions Ubuntu 21.04 >>> provides GnuCash 4.5. I suggest that you clean up your system and >>> install >>> GnuCash 4.4 from apt. If it has trouble displaying charts then raise a >>> bug >>> on Ubuntu and let their packager figure out what's going on. >>> >>> Regards, >>> John Ralls >>> >>>> On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: >>>> >>>> >>>> Thanks for the instructions John. I tried it on a Ubuntu 20.04 system >>>> with >>>> no GNC installed. The problem still exists in 4.x. It seems the 3.x >>>> stable branch works. The issue happens in the unstable branch only. >>>> >>>> I also tried running 4.x on a Mac, I can see the plot. Not sure if the >>>> issue is Linux only or Ubuntu only. >>>> >>>> unstable 2455071 bad >>>> stable 3.6-d42695e75 good >>>> unstable 3.5-b7479e8fb bad >>>> >>>> I cannot build 3.4 or anything older. The fix for >>>> G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. >>>> Compile still fails after resolving all conflicts. >>>> >>>> So it seems a very old bug that hasn't been fixed in the unstable >>>> branch. >>>> I believe running 4.x or any 3.x unstable build on standard issue >>>> Ubuntu >>>> 20.04 should easily reproduce. >>>> >>>> >>>>> It turns out that bisecting between 63232f and 8024f4 flat won't work, >>>>> they're on different branches. 63232f is on the 3.x branch which is >>>>> why >>>>> it >>>>> works. 2c637a is from 2019 where the master branch splits off from the >>>>> maint branch (we had a pull request merge mishap at aa53c23 that >>>>> temporarily collapsed them together, but there hadn't been any >>>>> development >>>>> on master at that point anyway). 2c637a is actually the first commit >>>>> where >>>>> the two branches start to diverge. >>>>> >>>>> Since the failing 8024f4 is on master I looked at the changes leading >>>>> up >>>>> to that in a graphical history viewer. One particular change stands >>>>> out, >>>>> 2455071 where we start the conversion from jqplot to chartjs. That >>>>> would >>>>> be a good place to test. >>>>> >>>>> HOWEVER >>>>> The problem may well be that there are remnants of the Ubuntu-provided >>>>> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >>>>> rendering, so before you do any more bisecting I suggest that you >>>>> completely remove all GnuCash shared libraries, loadable modules, and >>>>> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. >>>>> The >>>>> s
Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open files with OneDrive
I don't have One Drive so I'm guessing, but macOS10.15 introduced some security restrictions on access to certain folders which macOS 11 tightened up even more. You might need to give GnuCash some extra privileges. Open System Preferences, go to the Security and Privacy pane, select the privacy tab, and scroll down the left list to Files and Folders. With that selected find Gnucash.app in the right list and see what folders are listed under it. If OneDrive appears there and isn't checked, click the padlock in the lower left corner, authenticate, and then check the box for the OneDrive folder. Start GnuCash and see if you can find your file. If that doesn't work or if there is no line for OneDrive, go to the Full Disk Access item, one up in the left list. Find Gnucash.app in the right list and check its box (you'll have to click the padlock and authenticate if you haven't already). Start GnuCash and try to open the file. Regards, John Ralls > On Jul 20, 2021, at 11:53 AM, Derek Atkins wrote: > > Sounds like a permission problem. > Not sure how to fix it, I'm afraid. > -d > > On Tue, July 20, 2021 2:33 pm, cbp...@gmail.com wrote: >> Hi Derek, Gyle - thanks for the responses. >> >> I'd like to add one other error message - perhaps it will be helpful. When >> I try to go the File -> Open route, I get a slightly different error >> message (though it still doesn't work). The error message I get here is >> below. >> >> --- >> Could not read the contents of >> Error opening directory '/Users//OneDrive/': >> Operation not permitted >> --- >> >> Not sure if that means anything to anyone - but I figured I'd add it >> anyway in case it helps! >> >> Cameron >> >> -Original Message- >> From: Derek Atkins >> Sent: Tuesday, July 20, 2021 11:14 AM >> To: Gyle McCollam >> Cc: Cameron Podd ; gnucash-user@gnucash.org >> Subject: Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >> files with OneDrive >> >> Gyle, >> >> Cameron is on a Mac, not a Windows box, so OneDrive may behave differently >> there. Right now it sounds like GnuCash cannot see the OneDrive >> directory. >> >> I am hoping JRalls can pipe up and provide some insights, as he is our >> resident Mac expert. >> >> -derek >> >> On Tue, July 20, 2021 2:07 pm, Gyle McCollam wrote: >>> I use one drive as well, but I have no problem with GNU Cash finding >>> the info. However, I have another directory between Documents and >>> GnuCashData.gnucash (although mine is named differently). >>> When you click on file/open you can navigate to the file on one drive >>> and it should work fine from that point. I had an old program called >>> Money Counts for Windows (MCW) and when I changed the name of that >>> subdirectory to GNUCash recently, I had a problem with GNC finding my >>> info, but using file/open and navigating to the new directory and then >>> ?.gnucash worked for me. Hopefully, this helps. >>> >>> Thank You, >>> Gyle McCollam >>> >>> Gyle McCollam >>> >>> 609.680.2326 Mobile >>> >>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email >>> >>> >>> From: gnucash-user >>> on behalf of Cameron Podd >>> Sent: Tuesday, July 20, 2021 11:33 AM >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >>> files with OneDrive >>> >>> I am wondering if anyone has encountered - or has a possible solution >>> to - this bug I have found. I usually store my GNUCash file in OneDrive. >>> However, with the new update of OneDrive, GNUCash cannot see the file. >>> See the error below. Has anyone also seen this error - or know how to >>> correct it? >>> >>> Can't parse the URL >>> /Users//OneDrive/Documents/GnuCashData.gnucash >>> >>> Thanks - Cameron >>> >>> ___ >>> 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-A
Re: [GNC] My screenshot FYI. - Re: Big problem GC 4.6 wiping history list? Mac OS Big Sur
Anita, Thanks for the followup, but please remember to copy the list on all replies. Regards, John Ralls > On Jul 20, 2021, at 8:54 AM, Anita Graves wrote: > > Dear John and others who helped me, I wish to inform you that I was able to > solve my problem by simply carefully following the file path and discovered > that I had re-named a folder and that caused my problem. It had nothing to > do with trying to update GC. > > Thanks so much for your help and your kind attention! > > Anita > >> On 2 Jul 2021, at 8:04 PM, John Ralls wrote: >> >> Yes, that's the dialog I expected. It's offering to remove the entry in the >> File menu, not to delete the actual file. After all, it can't find the >> actual file so how could it delete it? >> >> Regards, >> John Ralls >> >> >>> On Jul 2, 2021, at 9:30 AM, Anita Graves wrote: >>> >>> >>> >>>> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>>>> wrote: >>>>> >>>>> Please see the attached screenshot: >>>>> >>>>> I don’t know what to do but I refuse to delete the file I need to work >>>>> with, or any of the other files in the history list. This all happened >>>>> to me when I installed GC 4.6. Before I was using 4.1. Now, when I try >>>>> to import a log file it gives the same screen. Then GC crashes! >>>>> >>>>> I am afraid to wipe all my history and all my work! >>>>> >>>>> Thanks for your help and suggestions. >>>> >>>> Your screenshot didn't make it onto the list, but if GnuCash is asking if >>>> you want to delete a file from the history list that means that it can't >>>> find the file. You'll want to investigate why that is, but rest assured >>>> that GnuCash isn't offering to delete the file, just to remove it from the >>>> history list. >>>> >>>> For the crash, please open a bug and attach the crash report from Console. >>>> You can find instructions for finding the crash report at >>>> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >>>> leading up to the crash in the bug description. >>>> >>>> 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] piecharts/linecharts turned blank in reports after upgrade
Dong Lin, You've already demonstrated that the problem doesn't happen on 3.11 so there's no point going backwards in 3.x. According to https://repology.org/project/gnucash/versions Ubuntu 21.04 provides GnuCash 4.5. I suggest that you clean up your system and install GnuCash 4.4 from apt. If it has trouble displaying charts then raise a bug on Ubuntu and let their packager figure out what's going on. Regards, John Ralls > On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: > > > Thanks for the instructions John. I tried it on a Ubuntu 20.04 system with > no GNC installed. The problem still exists in 4.x. It seems the 3.x > stable branch works. The issue happens in the unstable branch only. > > I also tried running 4.x on a Mac, I can see the plot. Not sure if the > issue is Linux only or Ubuntu only. > > unstable 2455071 bad > stable 3.6-d42695e75 good > unstable 3.5-b7479e8fb bad > > I cannot build 3.4 or anything older. The fix for > G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. > Compile still fails after resolving all conflicts. > > So it seems a very old bug that hasn't been fixed in the unstable branch. > I believe running 4.x or any 3.x unstable build on standard issue Ubuntu > 20.04 should easily reproduce. > > >> It turns out that bisecting between 63232f and 8024f4 flat won't work, >> they're on different branches. 63232f is on the 3.x branch which is why it >> works. 2c637a is from 2019 where the master branch splits off from the >> maint branch (we had a pull request merge mishap at aa53c23 that >> temporarily collapsed them together, but there hadn't been any development >> on master at that point anyway). 2c637a is actually the first commit where >> the two branches start to diverge. >> >> Since the failing 8024f4 is on master I looked at the changes leading up >> to that in a graphical history viewer. One particular change stands out, >> 2455071 where we start the conversion from jqplot to chartjs. That would >> be a good place to test. >> >> HOWEVER >> The problem may well be that there are remnants of the Ubuntu-provided >> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >> rendering, so before you do any more bisecting I suggest that you >> completely remove all GnuCash shared libraries, loadable modules, and >> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The >> shared libraries will be /usr/lib/libgnc* and you can get rid of the >> shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. >> Remove ~/.cache/guile/ccache as well if it exists. That may fix the >> problem with no more troubleshooting required. If it doesn't `sudo apt-get >> remove gnucash` to have a clean system before doing any test builds. Guile >> is exceptionally stupid about what it loads and trying to build GnuCash >> when there's a package-manager version installed seldom comes out well. >> >> If more bisecting is in order, try 2455071. If it works, try 598c37; >> that's the end of the chartjs upgrades. If that works then check 8024f4 >> again to make sure that that still fails, then `git bisect --first-parent >> start 8024f4 598c37` to find the problem commit (which may well be a >> merge). >> >> Regards, >> John Ralls >> >> >>> On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: >>> >>> >>> I see two 3.11 release commits in maint. >>> >>> 3.11-4064c58cd bad >>> 3.11-0fe9ba79e good >>> >>> bisecting in this range pointed to 2c637a971. >>> >>> bisecting in 63232f388..8024f44bc also singled out 2c637a971. >>> >>> But it cannot be as it's just a version update. Reverting it did not >>> produce a good run. >>> >>> >>>> >>>> That the problem seems to have arisen during the transition between 3.x >>>> and 4.0 does make it a bit more complicated. There are 391 commits >>>> between >>>> 63232f and 8024f4 including 57 merges from maint and 8 feature >>>> branches. >>>> That makes knowing that the problem exists in the latter commit and not >>>> in >>>> the former less helpful than it might be. >>>> >>>> You can test your hypothesis that a merge caused the regression by >>>> testing >>>> 3.11, the last release on the 3.x maint branch. If that fails you can >>>> bisect between it and 63232f. Use `git bisect`, it's the quickest and >>>> easiest way to find the commit that caused the problem. >>>
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
It turns out that bisecting between 63232f and 8024f4 flat won't work, they're on different branches. 63232f is on the 3.x branch which is why it works. 2c637a is from 2019 where the master branch splits off from the maint branch (we had a pull request merge mishap at aa53c23 that temporarily collapsed them together, but there hadn't been any development on master at that point anyway). 2c637a is actually the first commit where the two branches start to diverge. Since the failing 8024f4 is on master I looked at the changes leading up to that in a graphical history viewer. One particular change stands out, 2455071 where we start the conversion from jqplot to chartjs. That would be a good place to test. HOWEVER The problem may well be that there are remnants of the Ubuntu-provided GnuCash 3.8 that are interfering with the 4.x chartjs-based chart rendering, so before you do any more bisecting I suggest that you completely remove all GnuCash shared libraries, loadable modules, and Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The shared libraries will be /usr/lib/libgnc* and you can get rid of the shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. Remove ~/.cache/guile/ccache as well if it exists. That may fix the problem with no more troubleshooting required. If it doesn't `sudo apt-get remove gnucash` to have a clean system before doing any test builds. Guile is exceptionally stupid about what it loads and trying to build GnuCash when there's a package-manager version installed seldom comes out well. If more bisecting is in order, try 2455071. If it works, try 598c37; that's the end of the chartjs upgrades. If that works then check 8024f4 again to make sure that that still fails, then `git bisect --first-parent start 8024f4 598c37` to find the problem commit (which may well be a merge). Regards, John Ralls > On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: > > > I see two 3.11 release commits in maint. > > 3.11-4064c58cd bad > 3.11-0fe9ba79e good > > bisecting in this range pointed to 2c637a971. > > bisecting in 63232f388..8024f44bc also singled out 2c637a971. > > But it cannot be as it's just a version update. Reverting it did not > produce a good run. > > >> >> That the problem seems to have arisen during the transition between 3.x >> and 4.0 does make it a bit more complicated. There are 391 commits between >> 63232f and 8024f4 including 57 merges from maint and 8 feature branches. >> That makes knowing that the problem exists in the latter commit and not in >> the former less helpful than it might be. >> >> You can test your hypothesis that a merge caused the regression by testing >> 3.11, the last release on the 3.x maint branch. If that fails you can >> bisect between it and 63232f. Use `git bisect`, it's the quickest and >> easiest way to find the commit that caused the problem. >> >> If 3.11 is good then you can run bisect so that it always tests merge >> commits and ignores the commits being merged with `git bisect >> --first-commit start 8024f4 63232f`. >> >> Regards, >> John Ralls >> >> >> >>> On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user >>> wrote: >>> >>> >>> Did more searches. the issue exists in 4.6, running gnc on Ubuntu >>> 20.04.1 >>> LTS with standard gnome. >>> >>> I've gone through the following commits in maint: >>> >>> 4.6 2021 228954c40 bad >>> 0425-2020 8024f44bc bad >>> 0425-2020 63232f388 good >>> 3.10 2020 7d39ccc9d good >>> 3.6 2019 d42695e75 good >>> 0615-2019 410ae9575 good >>> 0601-2019 170651602 good >>> 0601-2019 3a91eedb4 good >>> 0531-2019 69ea174cd bad >>> 0415-2019 0251d044b bad >>> 3.5 2019 b7479e8fb bad >>> >>> I couldn't go any older because ancient code cannot be compiled by my >>> environment. >>> >>> The merges really obscured the search. the order of the merged commits >>> are >>> not chronological. timestamps are time of commit, not time of merge. >>> >>> It looks as if the bug was fixed at one point, but it was lost in a >>> merge. >>> >>> >>> >>>> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the >>>> gnc >>>> trees based off of master at various commits for the bisect. >>>> ; lsb_release -a >>>> No LSB modules are available. >>>> Distributor ID: Ubuntu >>>> Description:   Ubuntu 20.04.1 LTS >>>> Release:       20.04 >>>>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Currency quotes work differently from stock quotes because forex markets operate differently from stock exchanges. A particular stock symbol on any one price source is unique and quoted in a single currency so only the symbol is needed to retrieve the quote. Forex markets quote exchange rates between pairs of currencies, e.g. GBP to USD or JPY to EUR. Simply asking for the current quote for EUR isn't meaningful. In F::Q to retrieve currency quotes you must use `currency` for the source and you need two symbols as shown in Geoff's examples. Enabling online quotes for a currency in the security editor won't work because that will try to retrieve a price for a stock with the currency symbol from the selected source and odds are there is no such stock. To easily test that F::Q is working for currencies find a two-currency transaction and right-click on it, then select "edit exchange rate" in the context menu. The transfer dialog will appear. Click the Fetch Rate button and if everything is behaving itself the current rate will fill in the exchange rate box. Regards, John Ralls > On Jul 18, 2021, at 7:30 AM, david.rom...@davidjromano.com > wrote: > > Thanks Geoff, yes I think I did though I will recheck this. > > I've also tried this with an alternative key in case the first was the > problem. > > David > Sent from my iPhone > >> On 18 Jul 2021, at 13:55, Geoff wrote: >> >> Hi David >> >> Did you remember to set your alphavantage key as an environment variable >> when testing with Perl from the command line? >> >> Can you try this: >> >> C:\Program Files (x86)\gnucash\bin>set >> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__ >> >> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY% >> __Your_Actual_Key__ >> >> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl >> gnc-fq-helper >> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") (last . >> #e0.72002) (currency . "GBP"))) >> >> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl >> gnc-fq-helper >> (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last . >> #e4.8841) (currency . "RON"))) >> >> >> Also, it is normal to get the blank command window when doing Get Quotes on >> Windows. >> >> Regards >> >> Geoff >> = >> >>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote: >>> I'm having a problem with GNC-FQ not being able to retrieve currency data >>> for the GBP / EUR currency pair. >>> I had previously used FQ back when the data source was Yahoo, but when the >>> Yahoo died I stopped using it. >>> I now need to pick up GBP and EUR rates so I've installed the components >>> required to get the Alphavantage feed to work - or so I hoped! >>> Here's where I've got to so far: >>> 1.I updated GNU Cash to current 4.6. >>> 2.I installed Strawberry Perl version 5.32.1.1 >>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110 >>> 4.I added my aphhavantage key in Preferences \ Online Quotes >>> 5.I ran perl gnc-fq-check and got the following result: >>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check >>> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" >>> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual" >>> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" >>> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds" >>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary" >>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies" >>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx" >>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx" >>> "tradeville" "troweprice" "troweprice_direct" "tsp
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
That the problem seems to have arisen during the transition between 3.x and 4.0 does make it a bit more complicated. There are 391 commits between 63232f and 8024f4 including 57 merges from maint and 8 feature branches. That makes knowing that the problem exists in the latter commit and not in the former less helpful than it might be. You can test your hypothesis that a merge caused the regression by testing 3.11, the last release on the 3.x maint branch. If that fails you can bisect between it and 63232f. Use `git bisect`, it's the quickest and easiest way to find the commit that caused the problem. If 3.11 is good then you can run bisect so that it always tests merge commits and ignores the commits being merged with `git bisect --first-commit start 8024f4 63232f`. Regards, John Ralls > On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user > wrote: > > > Did more searches. the issue exists in 4.6, running gnc on Ubuntu 20.04.1 > LTS with standard gnome. > > I've gone through the following commits in maint: > > 4.6 2021 228954c40 bad > 0425-2020 8024f44bc bad > 0425-2020 63232f388 good > 3.10 2020 7d39ccc9d good > 3.6 2019 d42695e75 good > 0615-2019 410ae9575 good > 0601-2019 170651602 good > 0601-2019 3a91eedb4 good > 0531-2019 69ea174cd bad > 0415-2019 0251d044b bad > 3.5 2019 b7479e8fb bad > > I couldn't go any older because ancient code cannot be compiled by my > environment. > > The merges really obscured the search. the order of the merged commits are > not chronological. timestamps are time of commit, not time of merge. > > It looks as if the bug was fixed at one point, but it was lost in a merge. > > > >> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the gnc >> trees based off of master at various commits for the bisect. >> ; lsb_release -a >> No LSB modules are available. >> Distributor ID: Ubuntu >> Description:   Ubuntu 20.04.1 LTS >> Release:       20.04 >> Codename:      focal >> >> >> ; grep WEBKIT ./common/config.h >> /* Definitions for what WEBKIT version we're compiling against: */ >> #define WEBKIT2_4 1 >> /* #undef WEBKIT2_3 */ >> /* #undef WEBKIT1 */ >> >> >> I compared the preprocessor output for html/gnc-html-webkit2.c, the >> affected code block between the working and non-working versions are >> identical. But some line numbers for other .h files are different. So I >> have assumed that it's not 8024f44bc, but other 100+ commits that came >> with the tree merge. >> >> the VNC server runs on Ubuntu (the same machine that the binary is built >> on). The VNC viewer is MacOS (TigherVNC). Tried another viewer running on >> Linux, same outcome. >> >> There are many commits affecting barcharts in that range. The most >> relevant one seems to be this: >> 6b74f80bc Wed Dec 18 21:55:51 2019 +0800 >> [html-pie/scatter/bar/linechart] defer to html-chart renderer >> >> But reverting it resulted in too many conflicts that I dont know how to >> resolve. >> Will try again later using the maint branch. >> >> Thanks! >> >>> >>> >>>> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user >>>> wrote: >>>> >>>> >>>> I am trying to upgrade from 3.8 to 4.6. But found that piecharts and >>>> linecharts in reports have turned blank. The associated tables are >>>> present >>>> though. >>>> >>>> Attempted to perform a binary search in master, and found the latest >>>> working commit is 63232f388. >>>> >>>> >>>> 8024f44bc Sat Apr 25 15:40:07 2020 >>>> -0700                Remove leftover >>>> webkit2 conditional. >>>> 63232f388 Sat Apr 25 14:40:57 2020 >>>> -0700                Merge Jean >>>> Laroche's 'Fix-3-SX-Problems' into maint >>>> >>>> >>>> Unfortunately 8024f44bc came from the maint branch and was merged with >>>> over a hundred other commits. I am not sure how to narrow it down. >>>> Reverting one of them resulted in lots of conflicts that I dont know >>>> how >>>> to resolve. >>>> >>>> I figured the problem has to be related to my environment as no one >>>> else >>>> has brought up the issue. My virtual desktop is >>>> driven by a VNC server (Ubuntu 20.04 LTS). It's not directly >>>> associated >>>> with a hardware graphics card with a ph
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user > wrote: > > > I am trying to upgrade from 3.8 to 4.6. But found that piecharts and > linecharts in reports have turned blank. The associated tables are present > though. > > Attempted to perform a binary search in master, and found the latest > working commit is 63232f388. > > > 8024f44bc Sat Apr 25 15:40:07 2020 -0700 Remove leftover > webkit2 conditional. > 63232f388 Sat Apr 25 14:40:57 2020 -0700 Merge Jean > Laroche's 'Fix-3-SX-Problems' into maint > > > Unfortunately 8024f44bc came from the maint branch and was merged with > over a hundred other commits. I am not sure how to narrow it down. > Reverting one of them resulted in lots of conflicts that I dont know how > to resolve. > > I figured the problem has to be related to my environment as no one else > has brought up the issue. My virtual desktop is > driven by a VNC server (Ubuntu 20.04 LTS). It's not directly associated > with a hardware graphics card with a physical cable to the monitor. We release off of the maint branch so you should do your bisect there. This isn't likely to have anything to do with your VNC server, nor with whatever you're connecting to it. In what environment are you actually running GnuCash and what version of WebKit is it using? 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] OFX Imports to new account reversed
> On Jul 5, 2021, at 8:56 PM, David Carlson wrote: > > I have been using GnuCash for years with OFX imports correctly populating > bank and credit card accounts with deposits and withdrawals. > > Today, using release 3.8 I set up a new credit card account, went online, > downloaded an OFX transaction file and proceeded to import it into > GnuCash. > > Surprise, purchases were entered as payments. I checked the raw OFX file > and it appears to be correct. The account type is Credit Card under a > Liability top account. > > What else can cause this? Were there any payments and were they recorded as purchases? In your OFX file what is the block after the tag? A normal CC one should look like USD In a purchase transaction what is the sign on the amount? It shouldn't matter, but what have you selected in Preferences>Accounts for Reverse Balance Accounts? 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] Finance Quote Not working on MacBook Air M1 chip
Super. I guess you needed to install JSON::Parse and maybe other dependencies in the Rosetta instance. No doubt it's lost now but I wonder if during the Rosetta install cpan saw that it was already installed and couldn't tell that it was for the wrong architecture. Regards, John Ralls > On Jul 3, 2021, at 11:35 PM, Deepti Randad wrote: > > Hey John - it worked after some trouble shooting - now Finance:Quote is > “recognised” by the GnuCash GUI - Again - Thanks for your help !! > > Regards, > Kamlesh > >> On 04-Jul-2021, at 11:52 AM, Deepti Randad wrote: >> >> I was able to create a “terminal instance” to run under Rosetta2 and also >> then was able to install Finance::Quote using gnc-fq-update. >> >> However, when I tried to run the command "echo '(yahoo_json "CSCO")' | >> ./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had >> chance to troubleshoot these yet, maybe next weekend) >> >> Thanks John for your guidance so far. >> >> >> Can't load >> '/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' >> for module JSON::Parse: >> dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle, >> 1): no suitable image found. Did find: >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line >> 96. >> at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23. >> Compilation failed in require at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> BEGIN failed--compilation aborted at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> Compilation failed in require at (eval 301) line 1. >> BEGIN failed--compilation aborted at (eval 301) line 1. >> at ./gnc-fq-helper line 325. >> Can't locate object method "methods" via package >> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line >> 120. >> >> >>> On 01-Jul-2021, at 10:09 PM, John Ralls wrote: >>> >>> OK. I suspect that it's because GnuCash is running under Rosetta2 and that >>> forces the Intel perl. Try following the instructions in >>> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ >>> to create a Terminal instance that runs under Rosetta2 and use that to run >>> gnc-fq-update. >>> >>> Regards, >>> John Ralls >>> >>> >>> >>>> On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: >>>> >>>> Hallo John - Many Thanks for your response. >>>> >>>> I ran the GUI from the terminal command prompt as you have suggested - >>>> however, the problem remains the same - the application does not “get” / >>>> “find” Finance::Quote. >>>> >>>> Regards, >>>> Kamlesh >>>> >>>> Regards, >>>> Kamlesh >>>> >>>>> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >>>>> >>>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash >>>> >>> >> > ___ 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] Tools, Price Database
> On Jul 3, 2021, at 2:24 PM, Tommy Trussell wrote: > > On Sat, Jul 3, 2021 at 3:44 PM Gyle McCollam wrote: > >> I upgraded from version 3.6 to version 4.6 and when I add a new price for >> a stock it only takes 2 digits, previously I had 5 digits. How do I change >> it to 5 digits. I can’t find the screen to have it keep 5 digits. I >> enter the price as 5 digits, but when I save it it coverts it to 2 digits. >> Any help would be GREATLY appreciated. >> > > I saw this issue come across this list just the other day. Seems to be a > new bug: > https://bugs.gnucash.org/show_bug.cgi?id=798219 > > If the bug is causing a hardship, you might try downgrading to GnuCash 4.5, > or consider generating a patched version to use. > There's a workaround: After you type the price hit instead of clicking OK. 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] Big problem GC 4.6 wiping history list? Mac OS Big Sur
Please remember to copy the list on all replies. Windows and Linux users wish they had Console. It's very much a Mac thing; it's in Applications:Utilities. There are more detailed instructions in the wiki link I gave you. Regards, John Ralls > On Jul 2, 2021, at 9:35 AM, Anita Graves wrote: > > John, > > What is ‘Console’? Is that a PC thing? I don’t think we have that on Mac. > > Anita > >> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >> >> >> >>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>> wrote: >>> >>> Please see the attached screenshot: >>> >>> I don’t know what to do but I refuse to delete the file I need to work >>> with, or any of the other files in the history list. This all happened to >>> me when I installed GC 4.6. Before I was using 4.1. Now, when I try to >>> import a log file it gives the same screen. Then GC crashes! >>> >>> I am afraid to wipe all my history and all my work! >>> >>> Thanks for your help and suggestions. >> >> Your screenshot didn't make it onto the list, but if GnuCash is asking if >> you want to delete a file from the history list that means that it can't >> find the file. You'll want to investigate why that is, but rest assured that >> GnuCash isn't offering to delete the file, just to remove it from the >> history list. >> >> For the crash, please open a bug and attach the crash report from Console. >> You can find instructions for finding the crash report at >> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >> leading up to the crash in the bug description. >> >> 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] GNUCash 4.6 for Ubuntu 20.04 LTS
> On Jul 1, 2021, at 6:05 AM, David G. Pickett via gnucash-user > wrote: > > Bug: Entering price on price database - add, prices auto round to to places ! > Securities - edit says it is trades in 1/1000. Cannot find a setting to > control this. https://bugs.gnucash.org/show_bug.cgi?id=798219 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] Finance Quote Not working on MacBook Air M1 chip
OK. I suspect that it's because GnuCash is running under Rosetta2 and that forces the Intel perl. Try following the instructions in https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ to create a Terminal instance that runs under Rosetta2 and use that to run gnc-fq-update. Regards, John Ralls > On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: > > Hallo John - Many Thanks for your response. > > I ran the GUI from the terminal command prompt as you have suggested - > however, the problem remains the same - the application does not “get” / > “find” Finance::Quote. > > Regards, > Kamlesh > > Regards, > Kamlesh > >> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash > ___ 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] Big problem GC 4.6 wiping history list? Mac OS Big Sur
> On Jun 28, 2021, at 11:52 PM, Anita Graves wrote: > > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I need to work with, > or any of the other files in the history list. This all happened to me when > I installed GC 4.6. Before I was using 4.1. Now, when I try to import a log > file it gives the same screen. Then GC crashes! > > I am afraid to wipe all my history and all my work! > > Thanks for your help and suggestions. Your screenshot didn't make it onto the list, but if GnuCash is asking if you want to delete a file from the history list that means that it can't find the file. You'll want to investigate why that is, but rest assured that GnuCash isn't offering to delete the file, just to remove it from the history list. For the crash, please open a bug and attach the crash report from Console. You can find instructions for finding the crash report at https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did leading up to the crash in the bug description. 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] Preferences reset problem?
> On Jun 30, 2021, at 2:52 AM, Geert Janssens > wrote: > > Op dinsdag 29 juni 2021 22:22:36 CEST schreef incoming-gnuc...@sabot.com: >> After gnucash 4.5 was announced, I tested upgrading to it on a >> standalone test machine (running flatpak on ubuntu 20.04), and >> I encountered the issue later described here: >> >> https://bugs.gnucash.org/show_bug.cgi?id=798194 >> >> where all my gnucash settings were lost. On that same test machine, I >> tried downgrading to 4.4, but my settings were still gone. This >> seemed kind of scary, so I put off upgrading my real machine pending a >> fix. >> >> I see that the bug report linked to above includes some manual >> migration steps to export/re-import settings as a workaround, so I >> plan to just go ahead and try that (and I will go direct from 4.4 to >> 4.6, skipping 4.5). But I thought I'd check in to make sure that >> there was no other pending/better way or automatic approach to this, >> or is the manual workaround the way to go? >> > So far there's no better workaround. You can either manually set your > preferences again or use the command provided in the bug report. > > The short version of the issue is that a flatpak install of gnucash is as if > you install gnucash on a different machine, completely isolated from your > normal environment. There used to be a convenience to share preferences > between your normal environment and that "virtual" flatpak machine. That > convenience was dropped recently by the flatpak developers (well, the gnome > runtime developers really). Instead they provide a means to automatically > import settings from your main environment to the flatpak "virtual" machine, > but for historical reasons this can't work with gnucash. So as for the > convenience of having your preferences magically available in the flatpak > environment we're stuck between a rock and a hard place unfortunately. > >> If this issue affects all flatpak users, perhaps the release notes >> should reference the preferences issue and describe or link to the >> appropriate workaround? > > That's a reasonable idea. I hope someone will do so. Geert, Can you elaborate on the historical reasons on https://github.com/flathub/org.gnucash.GnuCash/pull/43? 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] Finance Quote Not working on MacBook Air M1 chip
> On Jun 27, 2021, at 4:05 AM, Deepti Randad via gnucash-user > wrote: > > Hallo Folks - > > I recently installed GnuCash on MacBook Air with the Apple M1 chip - the > GnuCash GUI itself seems to be working great. Then I tried installing > finance::quote to get stock quotes automatically, however, this has not been > working even after a lot of trouble shooting I did. Please find below the > steps I have taken. Any help / direction will be appreciated. Thanks. > > Regards, > Kamlesh > > Finance Quote on MacOS with MacBook Air M1 chip > > In the GnuCash GUI, I get the following error message in the “Security > Editor” screen: >> Warning: Finance::Quote not installed properly < > and the rest of the fields below this are disabled. > I followed the installation instructions on > https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS > > <https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS> > > The about page of the GUI shows: > Version: 4.5 > Build ID: 4.5+(2021-03-27) > Finance::Quote: - > > I did the following for installation: > > First, run the gnc-fq-update - this I had to run a couple of times, but it > succeeded. > > Now if I run it, I get the following: > > Date::Manip is up to date (6.85). > Finance::Quote is up to date (1.49) > > Perldoc gives the following output: > > perldoc -lm Finance::Quote > /Library/Perl/5.30/Finance/Quote.pm > > Then, I run the following command, gnc-fq-helper > > echo '(yahoo_json "CSCO")' | ./gnc-fq-helper > > This returns the data fetched: > (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-06-19 12:00:00") (last . > #e52.07) (currency . "USD"))) > > Another command I tried: > > ./gnc-fq-dump currency USD EUR > 1 USD = 0.8428 EUR > > Therefore I am guessing Finance::Quote is working from command line. > > ./gnc-fq-check > > ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" > "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero" > "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" > "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" > "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" > "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" > "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual" > "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" > "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" > "platinum" "romania" "seb_funds" "sixfunds" "sixshares" > "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" > "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" > "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json" > "yahoo_yql" "za" "za_unittrusts" Try running /Applications/Gnucash.app/Contents/MacOS/Gnucash from Terminal. Does that get it working? 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.
[GNC] GnuCash 4.6 Flathub Build
We've resolved the issue with Flathub and GnuCash 4.6 is now published there. 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] GnuCash 4.6 Released
Thanks. The correct hashes are: 251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 gnucash-4.6.tar.bz2 ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d gnucash-4.6.tar.gz de0447be56f3c56194132a89766221dfac72742c04aa87a84716cdd1ff93cfa7 gnucash-4.6.setup.exe 1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 Gnucash-Intel-4.6-1.dmg 5c4f8957d4e4a27bd7be3bc42f6a0823c1bfa4da1efff3fc17d57db43899c58c gnucash-docs-4.6.tar.gz Regards, John Ralls > On Jun 27, 2021, at 4:21 PM, Glenn Fowler wrote: > > Hi, > > FYI the hashes for the last three are the same: > >251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 > gnucash-4.6.tar.bz2 >ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d > gnucash-4.6.tar.gz >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-4.6.setup.exe >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > Gnucash-Intel-4.6-1.dmg >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-docs-4.6.tar.gz > > On Sun, Jun 27, 2021 at 5:51 PM John Ralls wrote: > >> The GnuCash development team announces GnuCash 4.6, the sixth release in >> the stable 4.x series >> Between 4.5 and 4.6, the following bugfixes were accomplished: >> >>Bug 648335 - Display Created Transactions setting >> >>Add a preference for the 'Review Created Transactions' setting in the >> 'Since Last Run' dialog so that the default can be specified. >>Bug 743753 - Nearest in time security price selection is incorrect in >> reports >> >>Add new price source - 'nearest before report date' will ignore prices >> *after* report date. >>Bug 743999 - Deleting a digit from an existing number greater than >> four digits in length generates an error message. >> >>Because the grouping is off. Checking grouping on input is pointless >> so just ignore the grouping separator when parsing number input. >>Bug 753283 - Current Selection Highlight Lost After Transaction Edit >> in Scheduled Transaction Window >>Bug 787813 - Price change from editing a transaction not reflected in >> pricedb. >>Bug 794877 - Intro text of "Online Banking Setup" is outdated >>Bug 795804 - Extremely slow save >> >>Only update the status bar when the percentage changes by at least 1% >> because running the mainloop is expensive on macOS and Microsoft Windows. >> This speeds up all operations that run the progress bar with overly-fine >> resolution. >>Bug 796761 - Newline (char(10)) is inserted into the end of the string >> if copy & paste text from excel into the description field of transaction >>Bug 797787 - Feature request: preference setting to open new tabs >> adjacent to currently active tab >> >>tests preference; if enabled then new tab inserted after current. if >> disabled then new tab is at the end. >>Bug 797928 - Since last run asks for security price when no shares >> traded >>Bug 798093 - Changing the symbol/abbreviation of a security after the >> trading account was created breaks GnuCash.(Reopened) >>Bug 798133 - Gnucash crash when any custom action is entered >>Bug 798144 - Reconciliation uses different number than entered >> >>If a number was pasted into the balance end value with a currency >> symbol the number would silently fail on evaluate and cause the wrong value >> to be used. With previous changes to the GNCAmountEdit widget a warning >> symbol will indicate a validation error and prevents going forward. >>Bug 798148 - "Accounts" page Present (USD) column uses future prices >>Bug 798151 - Value entry box not tied to associated transaction in >> Since Last Run assistant >>Bug 798156 - glib 2.68.0 breaks gnucash >>Bug 798159 - Keyboard shortcut bug in 'manage document link' >>Bug 798162 - Type Ahead Initialization Problem >>Bug 798170 - Unbound variable: gnc-budget-lookup when running saved >> report Budget Report via gnucash-cli >>Bug 798177 - Price of new stock transactions not saved in price >> database >>Bug 798186 - Incorrect result editting account in register when >> overtyping a part selection. >>Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button >> crashes on Windows >>Bug 798196 - not building with Boost 1.76 >>Bug 798199 - Pasting invalid value in date column crashes GnuCash >>Bug 798202 - Register input ignores theme on KDE rendering black text >> on black backgroun
[GNC] GnuCash 4.6 Released
The GnuCash development team announces GnuCash 4.6, the sixth release in the stable 4.x series Between 4.5 and 4.6, the following bugfixes were accomplished: Bug 648335 - Display Created Transactions setting Add a preference for the 'Review Created Transactions' setting in the 'Since Last Run' dialog so that the default can be specified. Bug 743753 - Nearest in time security price selection is incorrect in reports Add new price source - 'nearest before report date' will ignore prices *after* report date. Bug 743999 - Deleting a digit from an existing number greater than four digits in length generates an error message. Because the grouping is off. Checking grouping on input is pointless so just ignore the grouping separator when parsing number input. Bug 753283 - Current Selection Highlight Lost After Transaction Edit in Scheduled Transaction Window Bug 787813 - Price change from editing a transaction not reflected in pricedb. Bug 794877 - Intro text of "Online Banking Setup" is outdated Bug 795804 - Extremely slow save Only update the status bar when the percentage changes by at least 1% because running the mainloop is expensive on macOS and Microsoft Windows. This speeds up all operations that run the progress bar with overly-fine resolution. Bug 796761 - Newline (char(10)) is inserted into the end of the string if copy & paste text from excel into the description field of transaction Bug 797787 - Feature request: preference setting to open new tabs adjacent to currently active tab tests preference; if enabled then new tab inserted after current. if disabled then new tab is at the end. Bug 797928 - Since last run asks for security price when no shares traded Bug 798093 - Changing the symbol/abbreviation of a security after the trading account was created breaks GnuCash.(Reopened) Bug 798133 - Gnucash crash when any custom action is entered Bug 798144 - Reconciliation uses different number than entered If a number was pasted into the balance end value with a currency symbol the number would silently fail on evaluate and cause the wrong value to be used. With previous changes to the GNCAmountEdit widget a warning symbol will indicate a validation error and prevents going forward. Bug 798148 - "Accounts" page Present (USD) column uses future prices Bug 798151 - Value entry box not tied to associated transaction in Since Last Run assistant Bug 798156 - glib 2.68.0 breaks gnucash Bug 798159 - Keyboard shortcut bug in 'manage document link' Bug 798162 - Type Ahead Initialization Problem Bug 798170 - Unbound variable: gnc-budget-lookup when running saved report Budget Report via gnucash-cli Bug 798177 - Price of new stock transactions not saved in price database Bug 798186 - Incorrect result editting account in register when overtyping a part selection. Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button crashes on Windows Bug 798196 - not building with Boost 1.76 Bug 798199 - Pasting invalid value in date column crashes GnuCash Bug 798202 - Register input ignores theme on KDE rendering black text on black background Bug 798203 - g_assert fault while reversing transaction Bug 798204 - Creation of Imbalance Accounts Bug 798212 - right-click the down-arrow in the date register changes focus to first split The following fixes and improvements were not associated with bug reports: Improve transaction sorting on effective num field so that alpha charachters and numbers larger than 1 billion will be ordered. Ordering is now numeric for leading numbers (so that 9 sorts before 10) and lexical beginning with the first non-numeric character. Note that if one of the values begins with an alpha character ordering will be entirely lexical. Lexical sorting is localized; as in the rest of GnuCash only standard ASCII numbers (codepoints U+0030 - U+0039) are treated as numbers. Add import preferences for the difference in time considered when matching an existing transaction to an imported one. A difference less than the matching-date-threshold raises the score of the match; a difference greater than match-date-not-threshold lowers the score. Add experimental report "IFRS weighted-average cost basis report". This is a work-in-progress to help calculate the cost basis of securities priced in a foreign currency. [income-gst-statement] amend headers post Brexit. UK left EU, therefore VAT headers have now changed. Plug a bunch of memory leaks. Change how the print_info is obtained for the register: Currently the register sets up some 'print_info' values using the default account but if the register is a stock register they should be obtained from a parent account with a currency. Change monetary value for gnc_default_share_print_info: Share values are not currencies so set the monetary value to 0 for the
Re: [GNC] Transaction report export file type
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote: > > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? It usually works to copy-and-paste the report into a spreadsheet. 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] Transactions imported from the file assigned to wrong account
Yes, that does sound like a bug. Please file a bug report at https://bugs.gnucash.org. You can easily cite this thread with https://code.gnucash.org/pipermail/gnucash-user/2021-June/096929.html Regards, John Ralls > On Jun 22, 2021, at 8:51 AM, Aleksandar Kocic wrote: > > While removing the account works, it seems like a bug. > > When I remove an account from Tools -> Import Map editor -> Online tab, I get > asked the next time which account I want to use when importing the file. > However, the Import Map Editor doesn't know how to process the file and > extract the account id (the "Match String"). Hence, the "Match String" is > left empty, and the next time I need to import a file, from the same bank but > a different account, the Import Map Editor picks up the existing account, no > question asked. > > As I pointed out before, it is a QFX file, and the line with the account id > looks like this: > USD1234567890CREDITLINE > > Regards, > Aleksandar > > > > On Mon, Jun 21, 2021 at 8:10 PM Aleksandar Kocic wrote: > Thanks John and David, > > The Import Map Editor helped. I removed the account in question, which btw > didn't have assigned the id, and it worked. I was asked to assign the account > when trying to import the file. > > On Mon, Jun 21, 2021 at 8:08 PM John Ralls wrote: > David Carlson pointed you halfway: Open Tools>Import Map Editor. > > The other half is to select the radio button "online" on the top of the > dialog. That should display the online-id to GnuCash account associations and > enable you to delete any that are incorrect. If there's only one then perhaps > GnuCash isn't picking up the right number; compare the online id with your > import file to see wha it's using. > > Regards, > John Ralls > > > > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic wrote: > > > > It is QFX. > > > > I understand the process; however, it doesn't work. All the files are > > assigned to the same account with no questions asked. > > > > Is there a way to remove this association and start fresh? > > > > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, > > wrote: > > > >> Aleksandar: > >> > >> Which file format are you importing? The UI and procedure are slightly > >> different for each one. I am most familiar with OFX file import, and > >> secondarily with CSV file import. > >> > >> At the beginning of the import process, there is a step when GnuCash has > >> you designate which GnuCash account should receive the transactions you > >> are importing. For OFX format files, GnuCash can then remember a > >> correspondence between the account number in the OFX file and the > >> GnuCash account which receives the transaction, and it doesn't need to > >> ask you the next time that you import. > >> > >> Have you read through the GnuCash Guide documentation about file import? > >> < > >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx > >>> > >> > >> Best regards, > >> > >> —Jim DeLaHunt > >> > >> On 2021-06-21 13:17, Aleksandar Kocic wrote: > >>> I download the file from the bank's site and manually import it. > >>> > >>> I can see the account number in the file. However, for whatever reason, > >> the > >>> application chooses another account and it seems that cannot be changed. > >>> > >>> > >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, > >> wrote: > >>> > >>>> > >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic > >>>> wrote: > >>>>> Hi there, > >>>>> > >>>>> I am trying to import transactions downloaded from the bank. However, > >>>> since > >>>>> I have multiple accounts with the same institution, the transactions > >> are > >>>>> assigned to an already existing account. > >>>>> > >>>>> How do I select the account I want to use for importing transactions? > >>>> How are you doing the import and doesn't the bank include the bank > >> account > >>>> number? > >>>> > >>>> Regards, > >>>> John Ralls > >>>> > >>>> > >>> ___ > >>> gnucash-user mailing list >
Re: [GNC] Transactions imported from the file assigned to wrong account
David Carlson pointed you halfway: Open Tools>Import Map Editor. The other half is to select the radio button "online" on the top of the dialog. That should display the online-id to GnuCash account associations and enable you to delete any that are incorrect. If there's only one then perhaps GnuCash isn't picking up the right number; compare the online id with your import file to see wha it's using. Regards, John Ralls > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic wrote: > > It is QFX. > > I understand the process; however, it doesn't work. All the files are > assigned to the same account with no questions asked. > > Is there a way to remove this association and start fresh? > > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, > wrote: > >> Aleksandar: >> >> Which file format are you importing? The UI and procedure are slightly >> different for each one. I am most familiar with OFX file import, and >> secondarily with CSV file import. >> >> At the beginning of the import process, there is a step when GnuCash has >> you designate which GnuCash account should receive the transactions you >> are importing. For OFX format files, GnuCash can then remember a >> correspondence between the account number in the OFX file and the >> GnuCash account which receives the transaction, and it doesn't need to >> ask you the next time that you import. >> >> Have you read through the GnuCash Guide documentation about file import? >> < >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx >>> >> >> Best regards, >> >> —Jim DeLaHunt >> >> On 2021-06-21 13:17, Aleksandar Kocic wrote: >>> I download the file from the bank's site and manually import it. >>> >>> I can see the account number in the file. However, for whatever reason, >> the >>> application chooses another account and it seems that cannot be changed. >>> >>> >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, >> wrote: >>> >>>> >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic >>>> wrote: >>>>> Hi there, >>>>> >>>>> I am trying to import transactions downloaded from the bank. However, >>>> since >>>>> I have multiple accounts with the same institution, the transactions >> are >>>>> assigned to an already existing account. >>>>> >>>>> How do I select the account I want to use for importing transactions? >>>> How are you doing the import and doesn't the bank include the bank >> account >>>> number? >>>> >>>> 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. >> > ___ > 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] Transactions imported from the file assigned to wrong account
> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic wrote: > > Hi there, > > I am trying to import transactions downloaded from the bank. However, since > I have multiple accounts with the same institution, the transactions are > assigned to an already existing account. > > How do I select the account I want to use for importing transactions? How are you doing the import and doesn't the bank include the bank account number? 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] Transaction ordering on num field
> On Jun 15, 2021, at 5:19 PM, flywire wrote: > > http://gnucash.1415818.n4.nabble.com/GNC-dev-Dev-s-features-of-choice-tp4726710p4726713.html > >> "you can use Microsoft Access or Open/LibreOffice Base with SQLite3 via an >> ODBC driver" My, you're insistent on taking things out of context. 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] Transaction ordering on num field
> On Jun 15, 2021, at 4:43 PM, flywire wrote: > >> What "standard" are you referring to? > >> GnuCash stores information at the highest level in files. A file can be >> stored on your computer either as a single XML file (in all versions of >> GnuCash), or in a SQL database (in GnuCash version 2.4 and higher). That's just storage. Regardless of backend all of the data are loaded into C structs at the start of a session and all processing is done in C/C++ or Scheme on those structs. No database queries involved after the data are loaded. That's also a strange usage of the word "standard". > > The sort order of the application a user chooses to use to access the data. > It's a database. Whatever is generally available to sort alphanumeric data > in databases. Sorry, that doesn't make sense. 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] Transaction ordering on num field
What "standard" are you referring to? If you're arguing for the simplest possible that would be strcmp() that numerically compares each corresponding byte in two arrays of bytes. That works only for English encoded in ASCII. Doesn't work at all well for German, never mind Chinese. Glib provides a localization-supporting UTF-8 function that does work for all languages, g_utf8_compare(). The C and C++ standard sort functions are designed so that programs can easily implement sorts that support the use-cases being addressed: They take a callback function that returns 0 if the two arguments are equal, an int < 0 if the first one goes first and an int > 0 if the second one does. strcmp() and g_utf8_compare do that because the standard sort functions were designed around strcmp() and g_utf8_compare was designed as a drop-in replacement for strcmp(). But string comparison on its own doesn't work for ordering transactions by the num field in GnuCash. GnuCash has an obvious use-case where the num field contains serial numbers. As noted earlier it has keybindings for retrieving the last-used serial number and incrementing or decrementing it. It follows that numeric sorting is appropriate when it can be established that the field contains numbers, and that's what the current ordering callback does as long as the numbers fit in an int (±2 billion or so). But not all users do that, and it's complicated by the ability to use the split's action field for the transaction number so that one can have different values in different registers. It's a free text field: The input isn't (and never has been) checked to make sure that it's all numeric. The current ordering function behaves oddly in that case and a user brought that to our attention in https://github.com/Gnucash/gnucash/pull/983. That means that a hybrid approach is called for. It's pretty easily implemented, too. This is the evolution of GnuCash in action. Regards, John Ralls > On Jun 11, 2021, at 10:09 PM, flywire wrote: > > The question is about custom changes to the sorting algorithm (with an > undocumented feature) and I'm questioning actually using a *non-standard* > sorting algorithm. Using the 80:20 rule most of the benefit of the system > comes from a small part of it. How can GnuCash evolve if custom code is > carried forward forever? That may well involve a major change and as Will > pointed out it is easy to add leading zeros. > > - > > "The Reserve Bank of Australia (RBA) is Australia's central bank... It does > this by conducting monetary policy" https://www.rba.gov.au/about-rba/ > >> https://www.rba.gov.au/speeches/2020/sp-ag-2020-06-03.html#there-are-a-number-of-policy-implications >> https://www.rba.gov.au/speeches/2020/images/sp-ag-2020-06-03-graph01.gif >> "Is this suggesting the end of the cheque system? I think it may well >> be..." > > > > -- > 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] Incorrect Trial Balance Amounts
David, That would suppose that there's more documentation for the Trial Balance Report than the single sentence in https://www.gnucash.org/docs/v4/C/gnucash-guide/rpt_standardrpts.html#rpt_grp_incexp. Perhaps you'd like to write some? Regards, John Ralls > On Jun 15, 2021, at 12:12 AM, David Carlson > wrote: > > It would be nice if that method were described accurately in the > documentation, because going by the name it sounds like something completely > different and wrong if it is using incorrectly estimated prices instead of > actual transaction prices. I would make the same mistake if I were doing > what volker was doing. > > On Tue, Jun 15, 2021 at 1:02 AM Volker Englisch wrote: > Thank you for the explanation, John! I did have the price source for > the report set to "Nearest in time". After setting the source to > "Average Cost" the numbers came out as expected. > > Regarding your question about the proper recording of the capital gains, > I'm still going through the documentation to set up the accounts as > listed. My initial problem was that the numbers didn't add up even > before I sold anything. > > -- > Volker Englisch > phone: (240) 343-5343 (mobil) > mailto:vol...@englisch.us > > On 6/14/21 12:06 PM, John Ralls wrote: > >> On Jun 13, 2021, at 5:39 PM, Volker Englisch wrote: > >> > >> Hi there, > >> > >> I would like to check if I'm doing something wrong or if I'm correct in my > >> assumption that the Trial Balance report isn't displaying correct amounts > >> in all cases. > >> > >> I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. > >> > >> I started keeping track of some stock and entered the number of shares on > >> Jan. 1, 2021, for example. Let's say I have 100 shares worth $2 each. > >> Asset:Investment:MyStock200 (for 100 shares at $2) > >> Equity:Opening Balance200 > >> > >> After a while (April 1st) I sell all shares and enter the corresponding > >> transaction. The price for the shares increased to $3 since I started > >> tracking (I wish!): > >> Asset:Current Asset:Checking Account300 > >> Asset:Investment:MyStock 300 (for 100 shares, $100 > >> realized gains) > >> > >> When I run the trial balance report for the day I first entered MyStock > >> everything looks good: $200 debit / $200 credit. The same is true for the > >> day I sold MyStock: $300 debit / $200 credit, the difference is my gain. > >> However, when I run the trial balance for 03/01 for instance, the trial > >> balance shows $300 debit / $300 credit with $100 listed as unrealized > >> gains. > >> > >> What seems to be happening is that the TB calculates the value of the > >> stock based on the last price entered in the price editor rather than > >> using the last price prior to the date for which the TB is run. With two > >> entries in the price editor DB, one for 01/01 and one for 04/01 I would > >> expect the price for 01/01 to be used until 03/31. > >> > >> Am I doing something wrong? It's possible I'm not understanding precisely > >> how the TB is coming up with the numbers. > >> > >> Thank you! > > Did you record an income split for the capital gain? You mention the gain > > but I don't see the split for it in your example transaction. See > > https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for > > details about how to record capital gains/losses and why you should do so. > > > > As for price, the default in the Trial Balance Report is Average Cost > > (which isn't really, but the algorithm behind it is tailored specifically > > for the Trial Balance Report). That looks at the actual amounts and values > > in the splits; the Nearest in Time and Latest Price price sources consult > > the pricedb and won't balance, so don't use them. > > > > 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] On a Mac, where are the database configuration details stored?
Generally speaking the passwords are stored in Keyring and the user is prompted if the password isn't found. I'm not sure what it does if the connection doesn't have a password. You can examine the keyring with /Applications/Utilities/Keyring Access. If it does have an entry for your database then you can either add the password there or delete the entry and GnuCash will prompt you for the password when you try to connect. If there's no entry then I think you need to use File>Open to make a fresh connection and provide all of the information in the connection dialog. On the off chance you want to look at the code start at https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/gnc-file.c#L748. Regards, John Ralls > On Jun 13, 2021, at 5:32 PM, Peter West wrote: > > Thanks John. > > I was looking for the way the connection is actually set up. At the moment, I > have no password requirement for local connections (and no external > connections.) If I want to add password validation to postgresql, what > happens to my GnuCash connection? > > > — > Peter West > p...@ehealth.id.au > “And if anyone forces you to go one mile, go with him two miles.” > >> On 14 Jun 2021, at 3:11 am, John Ralls wrote: >> >> >> >>> On Jun 13, 2021, at 4:09 AM, Peter West wrote: >>> >>> As it says, where can I find the details of the database connection? >> >> You mean for opening the most recently used book? In >> ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values >> with e.g. >> defaults read org.gnucash.Gnucash /org/gnucash/history/file0 >> or all of them >> defaults read org.gnucash.Gnucash | grep history >> >> 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
> On Jun 13, 2021, at 8:53 PM, Jim DeLaHunt wrote: > > Imagine if cars or medicines or food were produced with that as a guiding > principle. They are. The state requires extensive training and licensing before one is allowed to operate a car or to prescribe medicine. There's no such requirement for food (unless you're selling prepared meals to others) and as a result factory food has caused enormous damage to health; and the licensing requirements don't stop people from doing great harm with all three. Yet only prescription drugs have restrictions on distribution: I've bought a bunch of cars over the years and never once has the seller asked for my driver's license. There's exactly one non-prescription drug with a restriction, psuedoephedrine, and that's to make it hard to buy enough to cook meth--but the permitted amount is more than enough to poison someone. There are also lots of examples of things readily available for sale where the user is well advised to get some training before using them, but there's no actual requirement to do so. Power saws are an excellent example. "If not duffer won't cut thumb off", to paraphrase Ransome. Caveat emptor is the way of the world. 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] Incorrect Trial Balance Amounts
> On Jun 13, 2021, at 5:39 PM, Volker Englisch wrote: > > Hi there, > > I would like to check if I'm doing something wrong or if I'm correct in my > assumption that the Trial Balance report isn't displaying correct amounts in > all cases. > > I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. > > I started keeping track of some stock and entered the number of shares on > Jan. 1, 2021, for example. Let's say I have 100 shares worth $2 each. >Asset:Investment:MyStock200 (for 100 shares at $2) >Equity:Opening Balance200 > > After a while (April 1st) I sell all shares and enter the corresponding > transaction. The price for the shares increased to $3 since I started > tracking (I wish!): > Asset:Current Asset:Checking Account300 > Asset:Investment:MyStock 300 (for 100 shares, $100 realized > gains) > > When I run the trial balance report for the day I first entered MyStock > everything looks good: $200 debit / $200 credit. The same is true for the > day I sold MyStock: $300 debit / $200 credit, the difference is my gain. > However, when I run the trial balance for 03/01 for instance, the trial > balance shows $300 debit / $300 credit with $100 listed as unrealized gains. > > What seems to be happening is that the TB calculates the value of the stock > based on the last price entered in the price editor rather than using the > last price prior to the date for which the TB is run. With two entries in > the price editor DB, one for 01/01 and one for 04/01 I would expect the price > for 01/01 to be used until 03/31. > > Am I doing something wrong? It's possible I'm not understanding precisely > how the TB is coming up with the numbers. > > Thank you! Did you record an income split for the capital gain? You mention the gain but I don't see the split for it in your example transaction. See https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for details about how to record capital gains/losses and why you should do so. As for price, the default in the Trial Balance Report is Average Cost (which isn't really, but the algorithm behind it is tailored specifically for the Trial Balance Report). That looks at the actual amounts and values in the splits; the Nearest in Time and Latest Price price sources consult the pricedb and won't balance, so don't use them. 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] On a Mac, where are the database configuration details stored?
> On Jun 13, 2021, at 4:09 AM, Peter West wrote: > > As it says, where can I find the details of the database connection? You mean for opening the most recently used book? In ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values with e.g. defaults read org.gnucash.Gnucash /org/gnucash/history/file0 or all of them defaults read org.gnucash.Gnucash | grep history 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
> On Jun 13, 2021, at 12:39 AM, Jim DeLaHunt wrote: > > GnuCash ships with Helper Scripts which make it easier to work with > Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and > gnc-fq-update. Collectively, call them gc-fq-* . > > When running these Helper Scripts from a command prompt on MacOS and Linux, > should they invoked as commands: > > % gnc-fq-check > > Or should they be invoked as an argument to a perl command: > > % perl gnc-fq-check > > ? > > The wiki page https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts > says, pretty clearly, the former: > > "While unixoid operating systems use a shebang (#!) to associate perl scripts > with the Perl interpreter, others, e.g. Windows, will fail…. > C:\> gnc-fq-check [fails]… > so use the following: … Prefix any gnc-fq-xxx perl script command with perl > and a space: … > perl gnc-fq-check …" > > The perl invocation is described as a workaround needed on Windows because > the shebang doesn't work. All the other examples show invocation as a > command, e.g. > > $ gnc-fq-check > > This makes a difference on Unixoid systems when there are multiple Perl > installations. Presumably command invocation of the helper scripts will > always obey the shebang and thus always run the same Perl installation. But > invocation as an argument to "perl" will run whichever Perl installation the > environment dictates. > > Am I correct in guessing that GnuCash 4.5 internally invokes these scripts > (maybe just gnc-fq-helper) as an argument to a perl command? > > If so, should the wiki page https://wiki.gnucash.org/wiki/Online_Quotes use > the same invocation? The answer depends on what the user wants or in this case for which perl they want to or did install F::Q. People who have multiple perl installations shouldn't need to be told; people who need to be told then they shouldn't have multiple perl installations. Arthur Ransome opened 'Swallows and Amazons` with the doggerel "Better drowned than duffers. If not duffers won't drown." An excellent guiding principle to system administration. 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
https://apple.stackexchange.com/questions/51677/how-to-set-path-for-finder-launched-applications has some details about using launchctl. It seems to be a bit fiddly and with setenv you have to run the command *once* after every reboot, meaning that after you boot you login, open a Terminal session, run `launchctl setenv...`, and kill the Dock. After that you can run GnuCash from Finder and it will use the changed path, though the SO indicates that it works only on 10.7. On newer versions of macOS there's `config` command that you run just once then reboot, but it's not clear from the SO nor from launchctl(1) with what version that was introduced; 10.12 is the earliest mentioned in the SO. Since it's persistent make sure that you know how to undo it if you don't like the results... if you screw it up badly enough that might mean booting to single user. Definitely for experts only. Regards, John Ralls > On Jun 13, 2021, at 2:01 AM, Peter West wrote: > > I think it is still true for Big Sur that the launchctl environment for Mac > can be set with launchctl commands. > > To set the same env var in the launchctl environment as in your .profile > environment, you can include in your .profile a function like this: > > set_env_var () { >eval export $1=\""$2"\" >eval launchctl setenv "$1" \""$2"\" > } > > Instead of > export PATH=blah > use > set_env_var PATH “blah” > > I not sure about the timing of environment settings; that is, whether you can > start up a shell and then immediately invoke, say, GnuCash, or whether you > must log out and in to have the env vars in effect. > > > — > Peter West > p...@ehealth.id.au > “…whoever says, ‘You fool!’ will be liable to the hell of fire.” > > > >> On 13 Jun 2021, at 6:23 pm, Liz Dodd wrote: >> >> On Sun, 13 Jun 2021 00:39:39 -0700 >> Jim DeLaHunt mailto:list+gnuc...@jdlh.com>> wrote: >> >>> GnuCash ships with Helper Scripts which make it easier to work with >>> Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, >>> and gnc-fq-update. Collectively, call them gc-fq-* . >>> >>> When running these Helper Scripts from a command prompt on MacOS and >>> Linux, should they invoked as commands: >>> >>> % gnc-fq-check >>> >>> Or should they be invoked as an argument to a perl command: >>> >>> % perl gnc-fq-check >>> >>> ? >>> >>> The wiki page >>> https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts says, >>> pretty clearly, the former: >>> >>> "While unixoid operating systems use a shebang (#!) to associate perl >>> scripts with the Perl interpreter, others, e.g. Windows, will fail…. >>> C:\> gnc-fq-check [fails]… >>> so use the following: … Prefix any gnc-fq-xxx perl script command >>> with perl and a space: … >>> perl gnc-fq-check …" >>> >>> The perl invocation is described as a workaround needed on Windows >>> because the shebang doesn't work. All the other examples show >>> invocation as a command, e.g. >>> >>> $ gnc-fq-check >>> >>> This makes a difference on Unixoid systems when there are multiple >>> Perl installations. Presumably command invocation of the helper >>> scripts will always obey the shebang and thus always run the same >>> Perl installation. But invocation as an argument to "perl" will run >>> whichever Perl installation the environment dictates. >>> >>> Am I correct in guessing that GnuCash 4.5 internally invokes these >>> scripts (maybe just gnc-fq-helper) as an argument to a perl command? >>> >>> If so, should the wiki page >>> https://wiki.gnucash.org/wiki/Online_Quotes use the same invocation? >>> >>> Best regards, >>> —Jim DeLaHunt >>> >> >> I don't know the answer, but I think that if you could write it out for >> the wiki it would be good long term recording. >> >> Liz >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___
Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS
> On Jun 12, 2021, at 11:49 PM, Jim DeLaHunt wrote: > > On 2021-06-12 20:49, John Ralls wrote: >> >>> On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: >>> >>> On 2021-06-12 09:13, John Ralls wrote: >>> >>>>> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: >>>>> >>>>> OK, I can understand that the MacPorts installation of perl may be >>>>> configured to look for perl packages in MacPorts locations, and ignore >>>>> the system locations. But I don't understand wny the GUI app of GnuCash >>>>> apparently can find Finance::Quote when run from the GUI, but the >>>>> gnucash-cli app apparently cannot. What is different? >>>> Because applications started by LaunchServices don't get the environment >>>> from your shell's startup files. That means GnuCash is running >>>> /usr/bin/perl, not /opt/local/bin/perl but when you run a program from >>>> Terminal the environment is read so gnucash-cli runs /opt/local/bin/perl. >>> Thank you, John, this explanation is very helpful. I can understand that >>> the GnuCash GUI and the gnucash-cli experience different environments, >>> especially different $PATH values, because the OS invokes them in different >>> environments. >>> >>> But I find it very confusing to have gnucash-cli be presented as an >>> integral part of GnuCash, and all the references to a singular action of >>> "update Finance::Quote on the system", then have gnucash-cli behave >>> differently and require a different installation of Finance::Quote than the >>> GnuCash GUI. >>> >>> It seems to me that if both gnucash-cli and the GnuCash GUI would invoke >>> the perl executable at an absolute path, then they would have consistent >>> behaviour. Thus I wonder why GnuCash lets the environment find the perl >>> executable. >>> >>> I have filed Bug 798209, "gnucash-cli might not use the same perl and >>> Finance::Quote as GnuCash GUI", >>> <https://bugs.gnucash.org/show_bug.cgi?id=798209> , to track this. >>> >>> My workaround as a MacPorts user: install Finance::Quote into the MacPorts >>> perl environment: >>> >>> ``` >>> % port install p5-finance-quote >> Jim, >> >> I summarily dismissed your bug report. It's on users who modify their >> operating systems to know what they're doing. >> >> It's standard practice nowadays to use the environment to get the executable >> to make it easy for users to set the one they want. That does require that >> users have a clue, but users without one who mess up their OS with package >> managers they don't understand have only themselves to blame. > > As I said to David, I submit that installing packages with MacPorts or > Homebrew has aspects of installing application software, as well as aspects > of altering the OS. Installing application software is a reasonable thing for > people to do with their personal computers. I don't think its reasonable to > say that GnuCash should ignore the existence of MacPorts and Homebrew. > > It would help for the gnucash-cli documentation to mention that GnuCash lets > the environment pick which perl instance to run. > > It would help for the Finance::Quote troubleshooting documentation to mention > this problem, and the solution. > > It would help for the GnuCash error message to also say, "Use `perl -e 'print > join("\n", @INC), "\n";'` to see where perl is looking.". > >> There's a really simple solution for you: Just install F::Q in both perls: > Agreed, but… >> /opt/local/bin/perl >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > AFAIK it is bad practice to have anything but MacPorts install into the > MacPorts directory tree. Maybe there are circumstances in which it works for > perl modules in a MacPorts instance, but there are many stories of the > MacPorts and other package managers conflicting. Fortunately, Finance::Quote > is available via MacPorts. Thus I feel more confident with: > > % sudo port install p5-finance-quote > > I appreciate all the explanations. Thank you. IMO installing MacPorts or Homebrew as those package managers intend changes the operating system. It's no longer macOS, it's MacPorts or Homebrew. MacPorts correctly addresses the problem by supplying their own "port" for GnuCash. If you want to run MacPorts, use their GnuCash and if it doesn't work the way you expect, complain to th
Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS
> On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: > > On 2021-06-12 09:13, John Ralls wrote: > >>> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: >>> >>> OK, I can understand that the MacPorts installation of perl may be >>> configured to look for perl packages in MacPorts locations, and ignore the >>> system locations. But I don't understand wny the GUI app of GnuCash >>> apparently can find Finance::Quote when run from the GUI, but the >>> gnucash-cli app apparently cannot. What is different? >> Because applications started by LaunchServices don't get the environment >> from your shell's startup files. That means GnuCash is running >> /usr/bin/perl, not /opt/local/bin/perl but when you run a program from >> Terminal the environment is read so gnucash-cli runs /opt/local/bin/perl. > > Thank you, John, this explanation is very helpful. I can understand that the > GnuCash GUI and the gnucash-cli experience different environments, especially > different $PATH values, because the OS invokes them in different environments. > > But I find it very confusing to have gnucash-cli be presented as an integral > part of GnuCash, and all the references to a singular action of "update > Finance::Quote on the system", then have gnucash-cli behave differently and > require a different installation of Finance::Quote than the GnuCash GUI. > > It seems to me that if both gnucash-cli and the GnuCash GUI would invoke the > perl executable at an absolute path, then they would have consistent > behaviour. Thus I wonder why GnuCash lets the environment find the perl > executable. > > I have filed Bug 798209, "gnucash-cli might not use the same perl and > Finance::Quote as GnuCash GUI", > <https://bugs.gnucash.org/show_bug.cgi?id=798209> , to track this. > > My workaround as a MacPorts user: install Finance::Quote into the MacPorts > perl environment: > > ``` > % port install p5-finance-quote Jim, I summarily dismissed your bug report. It's on users who modify their operating systems to know what they're doing. It's standard practice nowadays to use the environment to get the executable to make it easy for users to set the one they want. That does require that users have a clue, but users without one who mess up their OS with package managers they don't understand have only themselves to blame. There's a really simple solution for you: Just install F::Q in both perls: sudo /usr/bin/perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update /opt/local/bin/perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update 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] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS
> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: > > OK, I can understand that the MacPorts installation of perl may be configured > to look for perl packages in MacPorts locations, and ignore the system > locations. But I don't understand wny the GUI app of GnuCash apparently can > find Finance::Quote when run from the GUI, but the gnucash-cli app apparently > cannot. What is different? Because applications started by LaunchServices don't get the environment from your shell's startup files. That means GnuCash is running /usr/bin/perl, not /opt/local/bin/perl but when you run a program from Terminal the environment is read so gnucash-cli runs /opt/local/bin/perl. 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.
[GNC] gnucash 4.5, head window height can't be decreased enough to fit my screen
I tried compiling gnucash to get some bug fixes and match versions between ubuntu and debian linux installations. The new compile has a main window height taller than my screen when started and won't reduce by mouse dragging. I get the same symptom when using a checkout of 4.5 tag or latest in branch maint. Anyone else seen this? -- John Griessen industromatic.com Albuquerque NM building lab gear for biologists ___ 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] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS
Jim, Start with perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check from Terminal to make sure that perl can find F::Q and which perl from Terminal to see what is the default perl. If gnc-fq-check fails then perl -e 'print join("\n", @INC), "\n";' will show you where perl-from-terminal is looking for modules. Regards, John Ralls > On Jun 11, 2021, at 6:58 PM, Jim DeLaHunt wrote: > > Hello, folks: > > I have been retrieving online quotes from GnuCash through AlphaVantage for a > long time. I would now like to start using gnucash-cli to get online quotes > via automation. So first I tried it from Terminal, interactively. > > It failed, with the error message, "No quotes retrieved. Finance::Quote isn't > installed properly." > > However, I think Finance::Quote ought to be installed properly. a) Retrieving > quotes from the Gnucash… Tools… Price Database… Get Quotes… works fine. b) > gnc-fq-dump returns prices with no problem. c) gnc-fq-update runs with > apparent success. > > Here's the diagnostics I get from running gnucash-cli: > > % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli --debug --quotes get > $PR/Bookkeeping/current\ ledger.gnucash > Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli > > (process:10336): gnc.gui-WARNING **: 18:45:02.787: [mac_set_languages()] > Language list: en:en_CA:C:en_US:C:de_CA:ja_CA:zh_CN:zh_TW:hr_CA > * 18:45:02 INFO [gnc_module_init_backend_dbi] 3 DBD > drivers found > * 18:45:02 INFO [gnc_module_init_backend_dbi] Driver: pgsql > * 18:45:02 INFO [gnc_module_init_backend_dbi] Driver: > sqlite3 > * 18:45:02 INFO [gnc_module_init_backend_dbi] Driver: mysql > * 18:45:02 INFO [Gnucash::CoreApp::start] System locale returned > (null) > * 18:45:02 INFO [Gnucash::CoreApp::start] Effective locale set to > en_CA.UTF-8. > * 18:45:02 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-days, settings_ptr: 0x7fc8ae00f830, handler_id: 1 > * 18:45:02 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-never, settings_ptr: 0x7fc8ae00f830, > handler_id: 2 > * 18:45:02 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-days, settings_ptr: 0x7fc8ae00f830, > handler_id: 3 > * 18:45:02 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-forever, settings_ptr: 0x7fc8ae00f830, > handler_id: 4 > * 18:45:02 INFO [gnc_gsettings_register_cb] > schema: general, key: file-compression, settings_ptr: 0x7fc8ae00f830, > handler_id: 5 > No quotes retrieved. Finance::Quote isn't installed properly. > * 18:45:02 INFO [gnc_hook_lookup] no hook lists > > The Gnucash.trace file looks empty, despite the --debug option: > > % ls -l $TMPDIR/gnucash.trace > -rw--- 1 myuser staff 0 11 Jun 18:10 > /var/folders/5p/zmlrjq6c8xj84s0059bnypz8gp/T//gnucash.trace > > This is my GnuCash version: > > % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -v > Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli > > (process:10400): gnc.gui-WARNING **: 18:49:02.239: [mac_set_languages()] > Language list: en:en_CA:C:en_US:C:de_CA:ja_CA:zh_CN:zh_TW:hr_CA > GnuCash 4.5 > Build ID: 4.5+(2021-03-27) > > I am on macOS 10.13.6 High Sierra. > > I don't use useful instructions in the wiki, or in a web search of the > gnucash-user archives (though the web search returns so little of relevance, > I think it must be missing some messages). > > Any suggestions for diagnosing and fixing this problem? > > My workaround is to continue running Get Quotes from with in the GUI until I > can make the gnucash-cli succeed. > > Thank you, > —Jim DeLaHunt > > > ___ > 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] Transaction ordering on num field
What about 999a and 999b? Those currently evaluate equal so that the sort routine will proceed to the next criterion, date_entered. ISTM this would be something of a special case where preserving numerical ordering makes sense only in the case of leading numbers followed by a very few alpha characters. The example of 999a vs. 1000a is simple, but what to do with 10xr79b2 vs 9z54rq8e? I think most people would agree that that should be sorted lexically so that 10xr79b2 comes before 9z54rq8e. Such a scheme would allow the possibility of abcd and 10xyz and it's not possible to tell which rule should govern when looking at that pair in isolation. Collating algorithms work pairwise. Worse, your comment about auto numbering suggests that you might want to mix the styles so even running through all of the transactions to determine a pattern would produce a result the user might not like. Good point about case sensitivity. I can't think of any good argument for sorting to be case sensitive. Can anyone else? The proposed change wouldn't affect auto-numbering, only sort. Regards, John Ralls > On Jun 8, 2021, at 2:20 PM, David Carlson wrote: > > I would prefer 999a to sort before 1000a and character sorts to be case > insensitive, but I do not depend on that for any purpose. > > I do, however, depend on the auto numbering function ignoring strings > containing non-numeric characters as it currently does, so it currently only > increments numbers and still numbers the next check correctly if I use > non-numeric characters in transactions that do not represent checks. > > Those are my preferences! > > On Tue, Jun 8, 2021 at 1:37 PM John Ralls wrote: > Really the effective num field because of the split-action option, but > anyway... > > The submitter of PR#963 complained that sorting on the num field doesn't work > right if the value is bigger than an int can hold; that's 9 digits. His > knowledge of C wasn't quite up to the task of fixing it, but I've fixed his > implementation and have it ready to push for GnuCash 4.6. > > So far so good, but it changes the order of transactions when the num field > isn't all numeric and I want to know if the change will cause trouble for > anyone. > > The current behavior is that a string beginning with a letter will have a > sort value of 0 and one starting with a number will have a value equal to the > numbers up to the first non-number character, so for example 12ab34 will have > a sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort equally so > the compare would fall through to the next criterion; "abc" would sort > between "-12ab34" and "12ab34". > > The new way is that if both strings are all numbers and there are fewer than > 19 characters in each then the sort values will be their numeric values and > the comparison will be numeric, so e.g. 2 sorts before 10. If those > conditions aren't true then the two values will be string-compared, meaning a > lexical sort: A very large number beginning with 2 will sort before a shorter > number beginning with 3; "abc" will sort before "def" but after both "123" > and "-123" because 1 and - sort before a. That's for an English locale; in > order to accommodate UTF-8 strings the collation of the current locale. > > Will that break anyone's carefully-crafted transaction ordering? > > 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] Transaction ordering on num field
> On Jun 9, 2021, at 11:40 PM, flywire wrote: > > How can special customisation to sort a GnuCash field be justified when it > makes future transitions even more difficult? This field should be sorted in > a standard way. It's clearly the old *numeric* field for sorting cheques, > and the banks tell us cheques are as good as dead. When it was changed to > alphanumeric the sort order should have changed too, ie 10 before 2. > > I note David's comment on current functionality. Significant changes should > occur at major versions. None of my banks have told me that checks are dead, though I certainly try to write as few as possible these days. Regardless, my books go back 25 years and have lots of check numbers in them. The num filed has always been a free string, you can put whatever you want in it, but the sort is a very simple comparison of calls to a C standard library function (atoi) that converts leading digits to numbers. The whole point of this thread is to find out if anyone thinks this is a significant change. I guess you do, so please explain in detail, including whether it actually affects your use of GnuCash and if so how. 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] Transaction ordering on num field
> On Jun 10, 2021, at 8:14 AM, > wrote: > > . put a 100 as prefix last you a few years ... looking at an old CQ > book and that is how mine are numbered. > > Haven't used one for quite a while now though All very well if one is starting a new book, but it's unreasonable to require a user with many years of data to renumber hundreds of checks. The proposed change doesn't affect users who have fully-numeric entries, those will continue to sort numerically. 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.
[GNC] Transaction ordering on num field
Really the effective num field because of the split-action option, but anyway... The submitter of PR#963 complained that sorting on the num field doesn't work right if the value is bigger than an int can hold; that's 9 digits. His knowledge of C wasn't quite up to the task of fixing it, but I've fixed his implementation and have it ready to push for GnuCash 4.6. So far so good, but it changes the order of transactions when the num field isn't all numeric and I want to know if the change will cause trouble for anyone. The current behavior is that a string beginning with a letter will have a sort value of 0 and one starting with a number will have a value equal to the numbers up to the first non-number character, so for example 12ab34 will have a sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort equally so the compare would fall through to the next criterion; "abc" would sort between "-12ab34" and "12ab34". The new way is that if both strings are all numbers and there are fewer than 19 characters in each then the sort values will be their numeric values and the comparison will be numeric, so e.g. 2 sorts before 10. If those conditions aren't true then the two values will be string-compared, meaning a lexical sort: A very large number beginning with 2 will sort before a shorter number beginning with 3; "abc" will sort before "def" but after both "123" and "-123" because 1 and - sort before a. That's for an English locale; in order to accommodate UTF-8 strings the collation of the current locale. Will that break anyone's carefully-crafted transaction ordering? 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] MRU in Windows (was Re: Frustration)
> On Jun 7, 2021, at 9:47 AM, Stan Brown wrote: > > > On 2021-06-07 09:30, John Ralls wrote: >> The MRU list size preference isn't exposed in the GnuCash UI. >> ...> Microsoft Windows users can get to it via regedit, it will be >> somewhere under IIRC HKCU\Software\GnuCash > > This may have changed in later versions, but in Windows 2.6.19 GnuCash > stores my preferences under > HKCU\Software\GSettings\org\gnucash > > I couldn't find any explicit setting for the size of the MRU list. Under > HKCU\Software\GSettings\org\gnucash\history are keys file0, file1, ..., > file9, and the first two of them are populated with the paths to my two > data files. Presumably that means the MRU list can have as many as ten > entries. Sorry, you're right about the key. I was going from memory. The maxfiles key isn't created by default, you have to add it. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Frustration
> On Jun 6, 2021, at 11:22 PM, Michael Hendry wrote: > >> On 7 Jun 2021, at 06:57, flywire wrote: >> >> What you want is very simple, just not in GnuCash which is possibly the only >> package without it. The workaround changing accounts is just not worth the >> grief. >> >> Other software allows a category or class[ification] field on each >> transaction. Normally the field is even auto-populated based on say a >> payment by a tenant. One field is still not ideal because you might want >> multiple classifications on one transaction like bigger accounting packages >> offer (location, manager, supplier, owner, enterprise etc). The feature's >> been requested fairly frequently for ages: >> https://bugs.gnucash.org/show_bug.cgi?id=113772 >> >> Best thing you can do is change to different software. I use an old >> quickbooks version for my business to get that feature but you miss out on >> the open access to the database and potential reporting that brings. Say >> rental statements, performance per unit or property manager. >> >> Maybe look at https://kmymoney.org/ > > > I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my > Most-Recently-Used (MRU) list. > > Some time ago I reported a bug in the updating of the MRU which was fixed in > the next release, and it was about this time that the 6-item MRU became > available on my system. > > I can’t find a Preferences setting for the number of files in the MRU, but > I’m sure John Ralls could point a finger in the right direction. Not sure what MRU has to do with categories. The MRU list size preference isn't exposed in the GnuCash UI. Linux users can get to it with dconf-editor and macOS users via defaults, e.g. defaults write -app Gnucash /org/gnucash/history/maxfiles '6' Microsoft Windows users can get to it via regedit, it will be somewhere under IIRC HKCU\Software\Gnucash. 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] Trial Balance with more "Display" option
Thanks for the hint but nobody but me will see it if you don't copy the list. You should make sure to do that for all replies to list emails. Regards, John Ralls > On Jun 1, 2021, at 10:43 PM, Andreas Vyrides wrote: > > Dear Mr Ralls, > > Thank you for your email. > > This is just for future reference to anyone with a similar question to mine. > > The best way to get a Trial balance like look would be to create a > Transaction report, and at the "Display" tab, select the subtotal table > option. Then at sorting, you can select "Show Subtotals only (Hide > transactional data), resulting in only table being show. > > I am sure you can then play around with different options to make the report > the way you want it. > > I hope this helps > > Thank you for your time > > > On 21/05/2021 17:49, John Ralls wrote: >> >>> On May 21, 2021, at 2:48 AM, Andreas Vyrides wrote: >>> >>> Dear Sir, >>> >>> I would like to know if there is a way to include "Account codes" into the >>> Trial Balance Report. Currently only account name is visible, and there are >>> no other options available. >>> >>> Thank you for your time >> Unfortunately the only way is for you to copy that report and base a new >> custom report on it. That's not easy unless you're a fairly proficient >> programmer. There are some instructions at >> https://wiki.gnucash.org/wiki/Custom_Reports to get you started. >> >> 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
Yes, David, That is why YOU would want the imbalance account functionality. However, other people work differently. Some people have no need for that functionality and don’t like the creation of extra unneeded accounts. It would be nice if GnuCash worked well for everyone instead of forcing everyone to work the way one person likes to work. John > On Jun 2, 2021, at 5:36 PM, David Carlson wrote: > > Stephen, > > There have been several posts explaining why it can be desirable to allow > postponement of the completion of a balanced transaction because not all > the details are known but the core of the transaction should not be > postponed into oblivion. ___ 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
Hi David, > I agree. There is a case for not displaying the Imbalance accounts in the CoA > tab if there are no entries to them, i.e. they are zero balance. This is an > option in reports but not in the account tab. They can of course be left in > the CoA and hidden in the Account tab by editing the account and setting the > hidden flag but they then remain hidden even when new entries to them are > created. Yes, that is a large part of my complaint. Certainly, hiding the empty accounts would be an improvement since there is currently no developer time available to implement the full solution (a preference to stop the user in their tracks before the imbalanced transaction is finalized). > I would go further and hide them totally if the balance in them was zero and > change either the background or the font color to a bright red or even > flashing red( that would clearly need to be optional) to highlight them when > they are present with a non-zero balance. Yes, anything to draw the user’s attention to their presence would be helpful. > Their usefulness to indicate incorrect entries would be enhanced if they are > hidden when the balance is zero as their presence whether highlighted or not > indicates an error. Similarly with the orphan transactions created when an > account with existing transactions to it has been deleted without moving the > transactions to another account. Yes. > I would take a look at it but I am currently heavily involved in a physics > project programming exercise at the moment. The change in behaviour from the > previous version probably needs to be tracked down and, where possible fixed > first, before adding any further enhancements to minimize conflicting changes. I understand being too busy to take on new projects. I also agree that fixing the more immediate and more significant problems in GnuCash is much more important the niceties of how the imbalanced transactions are handled. Best, John > On Jun 1, 2021, at 6:46 PM, David Cousens wrote: > > John, > > I agree. There is a case for not displaying the Imbalance accounts in the CoA > tab if there are no entries to them, i.e. they are zero balance. This is an > option in reports but not in the account tab. They can of course be left in > the > CoA and hidden in the Account tab by editing the account and setting the > hidden > flag but they then remain hidden even when new entries to them are created. > > I would go further and hide them totally if the balance in them was zero and > change either the background or the font color to a bright red or even > flashing > red( that would clearly need to be optional) to highlight them when they are > present with a non-zero balance. > > Their usefulness to indicate incorrect entries would be enhanced if they are > hidden when the balance is zero as their presence whether highlighted or not > indicates an error. Similarly with the orphan transactions created when an > account with existing transactions to it has been deleted without moving the > transactions to another account. > > I would take a look at it but I am currently heavily involved in a physics > project programming exercise at the moment. The change in behaviour from the > previous version probably needs to be tracked down and, where possible fixed > first, before adding any further enhancements to minimize conflicting changes. > > David Cousens ___ 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
> Actually you are given the opportunity to fix it during entry. When the > Imbalance account appears in a transaction in the account column, all you > have to do is click on it in the Account column and assign the correct > account from the drop down list, before closing (pressing Enter) the > transaction. Unfortunately, by then the damage is already done. The Imbalance account has been created and I must go and delete it yet again. I don’t like extra accounts cluttering up my carefully designed CoA. Best, John ___ 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
Given the extremely long history of this question with many good people expressing good reasons on both sides of the debate, I would have expected the developers to give the user the choice. There should be a switch in the preferences that allows the user to decide if the necessary extra accounts will be created as needed to address an imbalance or the user will be forced to correct the imbalance before completing the transaction. Personally, I would choose the latter, but I am not allowed that freedom with GnuCash. John > The question about imbalance entries goes back a long ways in GnuCash, and > you can find discussions about it in the lists over the years. > > Essentially, the debate boils down to this: is it better to allow a user to > enter an imbalanced transaction and automatically create the balancing entry > in a dummy account (Imbalance-XXX generically speaking), or should the > program nag the user to balance the transaction every time? Gnucash choose > the former many years ago, and has stuck with that model since. > > David ___ 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] Getting Gnucash to recognize Finance::Quote is installed correctly on Mac OS 11.4
Hmm. Your original question was about how GnuCash determines whether F::Q is installed. The answer is that it calls gnc-fq-check. So if works from the command line and fails when GnuCash calls it then something is different between the two perl environments. Running GnuCash from Finder won't read your shell environment, but running it from Terminal does. The gnc-fq-foo programs are all perl so you can edit them. It's helpful that running GnuCash from Terminal doesn't work because there's a place for the output to go. Try adding print STDERR join "\n", @INC; to gnc-fq-check right after the line # Runtime. Run `gnc-fq-check` and `gnucash-cli --logto=stderr --log gnc.scm=debug --quotes get ` from Terminal and compare the output. Regards, John Ralls > On May 28, 2021, at 10:57 AM, James Mauro wrote: > > Not that I remember. It's a clean MacOS install when I got this computer in > November and it worked fine until the MacOS update last month which is why > the behavior is confounding. > > The system perl in /usr/bin/perl is the only one on the system that I could > see with a quick sweep with the terminal find for any others and nothing > popped out as a different one I can see. > > Also the "/Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get" > throws "No quotes retrieved. Finance::Quote isn't installed properly." even > though I confirmed with the 'which' command that it's pointing to the > /usr/bin/perl like the gnc-fq commands do. > > James > > -- > James Mauro Phone: 785-979-1041 > "Had I foreseen this, I would have gone into botany" -- Wolfgang Pauli > >> On May 28, 2021, at 5:51 AM, John Ralls wrote: >> >> >> >>> On May 27, 2021, at 11:18 AM, James Mauro wrote: >>> >>> How does Gnucash verify that Finance::Quote is installed correctly on MacOS >>> 11? I followed the instructions in the list archives archives to fix Test2 >>> in CPAN, rebuild Quote::Finance via gnc-fq-update and now both gnc-fq-check >>> and gnc-fq-dump work as expected, but Gnucash still grays out the "Get >>> Quotes" on the Price Database screen and editing a security indicates that >>> Finance::Quote isn't properly installed. I've been using Gnucash for a >>> while and normally once gnc-fq-check and gnc-fq-dump start working there it >>> magically works, but this time no such luck. >>> >>> Any thoughts? >>> >> >> Might you have installed another instance of perl, perhaps with Homebrew or >> MacPorts? >> >> 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] Getting Gnucash to recognize Finance::Quote is installed correctly on Mac OS 11.4
> On May 27, 2021, at 11:18 AM, James Mauro wrote: > > How does Gnucash verify that Finance::Quote is installed correctly on MacOS > 11? I followed the instructions in the list archives archives to fix Test2 > in CPAN, rebuild Quote::Finance via gnc-fq-update and now both gnc-fq-check > and gnc-fq-dump work as expected, but Gnucash still grays out the "Get > Quotes" on the Price Database screen and editing a security indicates that > Finance::Quote isn't properly installed. I've been using Gnucash for a > while and normally once gnc-fq-check and gnc-fq-dump start working there it > magically works, but this time no such luck. > > Any thoughts? > Might you have installed another instance of perl, perhaps with Homebrew or MacPorts? 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] gnucash-cli --quotes get
> On May 27, 2021, at 10:35 AM, Cam Ellison wrote: > > On 2021-05-27 10:08 a.m., mike823 wrote: >> Hi Robin, >> >> I used your code to load quotes and I've noticed that when runs multiple >> times, it will create multiple quote records for the same day. Any way to >> avoid this behavior? I mean, if you re-run it, it should just update the >> quote for the day, not create a new one. >> >> Thanks. >> > And for those who do day trading, for example, and want to track prices at > different times of day? > > It does what it should, which is to create a record each time it is run. But that's not what GnuCash is designed for and if you try to use it that way you'll pretty quickly run into performance problems. You're much better off getting a portfolio management tool for that kind of thing. 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] export to PDF
Thank you. But I know that procedure already. It's just that the export to PDF button was quicker. I am disappointed the developers took that away. John -- ___ 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] export to PDF
I have been using Ubuntu 18.04 for the last couple of years. The gnucash that came with the software center was version 2.6. When I would invoice my customers, then select 'print invoice', the invoice would appear on the screen in a printable format. There was a button to select that would export the invoice in PDF format. I would then save the invoice in my customers file. Email the invoice as an attachment to my customer. I have upgraded ubuntu and the gnucash version is 3.8. This button to export the invoice in PDF format is no longer available. Why was this feature removed from gnucash and can we get it back??? Thanks -- ___ 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] Font size in reports
Jill, Stylesheets *are* global in that any one of them can be applied to any report. There's one stylesheet named Default that all standard reports use unless told otherwise in report options, so if you want a change to apply to all reports--and you probably do in this case--then you edit the Default style sheet. Report options aren't sticky, meaning that the next time you run that report you'll have to open report options and set the stylesheet again. Once you've configured a report to your liking you can save those option settings with the Save Config button in the tool bar. To run a saved configuration use Reports>Saved Configurations to get a dialog box listing your saved reports from which you can select and run one of them. Regards, John Ralls > On May 23, 2021, at 11:35 PM, Jill Terry wrote: > > >> Did you change the style sheet in report options to point to your new > >> style sheet? << > > argh! gotcha! Sorry, only just started using latest version of Gnu after > installing a new hard-drive. Thought style sheets would simply be global! > > Working now - thanks so much John > > Cheers > Jill > > > On 23/05/2021 16:20, John Ralls wrote: >> Please remember to copy the list on all replies. >> >> Did you change the style sheet in report options to point to your new style >> sheet? There's no need to restart GnuCash. If you change the report option >> it will reload the report for you, but if you only edit the selected >> stylesheet you'll need to reload the report manually using the reload button >> on the toolbar. >> >> Are you using GnuCash 4.2 or earlier on a Mac? If so, there's a bug that was >> fixed in GnuCash 4.3, please upgrade to the current release. >> >> Regards, >> John Ralls >> >> >> >>> On May 22, 2021, at 11:43 PM, Jill Terry wrote: >>> >>> Thanks John. Sorry, I missed this reply somehow! >>> >>> I have tried using the style sheets and nothing happens, simply no changes >>> at all are made. >>> >>> I tried again and created a new style sheet as per your link. Nothing >>> changed. I closed Gnu and reopened; going back into stylesheets it had >>> reverted to the CSS-based stylesheet. On a previous time I had edited >>> that css, but again, nothing changed. >>> >>> It simply doesn't work. >>> >>> As per my original post, changes work if I add a new css file to the >>> folder, except for the reports, which remain very small font size. >>> >>> Cheers >>> Jill >>> >>> On 21/05/2021 17:45, John Ralls wrote: >>>>> On May 21, 2021, at 12:14 AM, Jill Terry wrote: >>>>> >>>>> I have a problem in that the font size in reports is tiny! >>>>> >>>>> Searching for the answer, I created a gtk-3.0.css file with the >>>>> following, and placed it in appdata > roaming > gnucash >>>>> >>>>> * { >>>>> font-size: 22px; >>>>> } >>>>> >>>>> I tried various sizes and fonts and it worked - except on the reports, >>>>> which remained small! >>>>> >>>>> Can somebody please advise me how I increase the font-size in reports >>>> https://code.gnucash.org/docs/C/gnucash-help/change-style.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] Font size in reports
Please remember to copy the list on all replies. Did you change the style sheet in report options to point to your new style sheet? There's no need to restart GnuCash. If you change the report option it will reload the report for you, but if you only edit the selected stylesheet you'll need to reload the report manually using the reload button on the toolbar. Are you using GnuCash 4.2 or earlier on a Mac? If so, there's a bug that was fixed in GnuCash 4.3, please upgrade to the current release. Regards, John Ralls > On May 22, 2021, at 11:43 PM, Jill Terry wrote: > > Thanks John. Sorry, I missed this reply somehow! > > I have tried using the style sheets and nothing happens, simply no changes at > all are made. > > I tried again and created a new style sheet as per your link. Nothing > changed. I closed Gnu and reopened; going back into stylesheets it had > reverted to the CSS-based stylesheet. On a previous time I had edited that > css, but again, nothing changed. > > It simply doesn't work. > > As per my original post, changes work if I add a new css file to the folder, > except for the reports, which remain very small font size. > > Cheers > Jill > > On 21/05/2021 17:45, John Ralls wrote: >> >>> On May 21, 2021, at 12:14 AM, Jill Terry wrote: >>> >>> I have a problem in that the font size in reports is tiny! >>> >>> Searching for the answer, I created a gtk-3.0.css file with the following, >>> and placed it in appdata > roaming > gnucash >>> >>> * { >>> font-size: 22px; >>> } >>> >>> I tried various sizes and fonts and it worked - except on the reports, >>> which remained small! >>> >>> Can somebody please advise me how I increase the font-size in reports >> https://code.gnucash.org/docs/C/gnucash-help/change-style.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] Preferences reset
> On May 22, 2021, at 11:44 AM, Geert Janssens > wrote: > > Op zaterdag 22 mei 2021 19:34:44 CEST schreef John Ralls: > > > On May 22, 2021, at 4:00 AM, Geert Janssens > > > wrote: > > > > > > I have looked into this some more and filed bug > > > https://bugs.gnucash.org/show_bug.cgi?id=798194 with more details. > > > > > > The proper fix would require changes affecting all users, not only flatpak > > > users (changes to how we store our preferences in GSettings). That's > > > probably out of proportion with the benefit we'd have from this. > > Well, all Linux users. The domain is already correct on macOS, > > org.gnucash.Gnucash.plist. Would it change the HKLM\Software registry keys > > on Windows? > > > > Regards, > > John Ralls > > Interesting. What makes this different on MacOS vs Linux ? Where is this > defined ? https://github.com/Gnucash/gnucash-on-osx/blob/c79543057f2a0efa21169ab6fccb31bebb731cd5/gnucash-bundler/Info.plist#L13 > > And more interestingly perhaps what are the key paths used inside of that > plist file ? Looks like the paths inside the file *would* be affected, e.g. /org/gnucash/window/pages/account-tree/summary/start-choice-absolute 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] Preferences reset
> On May 22, 2021, at 4:00 AM, Geert Janssens > wrote: > > I have looked into this some more and filed bug > https://bugs.gnucash.org/show_bug.cgi?id=798194 with more details. > > The proper fix would require changes affecting all users, not only flatpak > users (changes to how we store our preferences in GSettings). That's probably > out of proportion with the benefit we'd have from this. > Well, all Linux users. The domain is already correct on macOS, org.gnucash.Gnucash.plist. Would it change the HKLM\Software registry keys on Windows? 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] Trial Balance with more "Display" option
> On May 21, 2021, at 2:48 AM, Andreas Vyrides wrote: > > Dear Sir, > > I would like to know if there is a way to include "Account codes" into the > Trial Balance Report. Currently only account name is visible, and there are > no other options available. > > Thank you for your time Unfortunately the only way is for you to copy that report and base a new custom report on it. That's not easy unless you're a fairly proficient programmer. There are some instructions at https://wiki.gnucash.org/wiki/Custom_Reports to get you started. 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] Font size in reports
> On May 21, 2021, at 12:14 AM, Jill Terry wrote: > > I have a problem in that the font size in reports is tiny! > > Searching for the answer, I created a gtk-3.0.css file with the following, > and placed it in appdata > roaming > gnucash > > * { > font-size: 22px; > } > > I tried various sizes and fonts and it worked - except on the reports, which > remained small! > > Can somebody please advise me how I increase the font-size in reports https://code.gnucash.org/docs/C/gnucash-help/change-style.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] A Linux utility/program to print ABA and account
> On May 20, 2021, at 7:32 AM, David G. Pickett via gnucash-user > wrote: > > Check numbers are in magnetic ink for reading by MICR scanners, but . . . > > I deposit many checks by photo, so any print would probably work for the > digits, but . . . > > You need the symbols that divide the fields: transit mark, slash, dash, > paragraph or on-us marks. I would be amazed if Unicode did not have all > this. Having the ABA style numbers would not hurt, and they are probably in > there, too. Let me ask my friend Google. > > https://en.wikipedia.org/wiki/Magnetic_ink_character_recognition > > https://en.wikipedia.org/wiki/ISO_2033#Character_set_for_E-13B Notice that the code points for the numbers are the plain ASCII ones. You need a typeface with the MICR glyphs. 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] A Linux utility/program to print ABA and account numbers on stock/blank checks
> On May 19, 2021, at 6:34 PM, local10 via gnucash-user > wrote: > > Hi, > > Is there a Linux utility/program to print ABA and account numbers on > stock/blank checks? Or perhaps it's somehow possible to do from Gnucash? > It doesn't require special software, it requires a special MICR font and technically special magnetic ink, though 15 years ago when I was using those checks I mostly got away with plain laser printer toner. I don't think GnuCash's check-printing code knows how to switch fonts and I'm not sure that it's able to place the RID/Account line precisely enough. I always used a Microsoft Windows program (sorry, I don't remember the name) from a company that also sold the blank checks. 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] Building GnuCash from src distributions
> On May 19, 2021, at 3:30 PM, mike823 wrote: > > Hi John, > > As recommended, I have tried Fedora's regular GnuCash RPM. Just by launching > it, I don't have a way to validate that includes or not python bindings. > > The issue is that the gnucash python module cannot be installed. > > [@fedora ~]$ pip install gnucash > Defaulting to user installation because normal site-packages is not > writeable > ERROR: Could not find a version that satisfies the requirement gnucash > ERROR: No matching distribution found for gnucash > [@fedora ~]$ That's because there's no such thing as a GnuCash PyPi package. The Fedora GnuCash RPM installs the Gnucash bindings into /usr/lib64/python3.9/site-packages/gnucash, as anyone who understands Python well enough to use the bindings would expect. See https://koji.fedoraproject.org/koji/rpminfo?fileStart=400=25841895=name=-id=0#filelist. 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] Building GnuCash from src distributions
> On May 19, 2021, at 1:52 PM, mike823 wrote: > > Thank you John, > > How do I get support for build? I've sent two days ago a message to "GnuCash > - Dev" but no answer. > > Here is the error I am getting: > > > [**@CentOS-8dot1 gnucash-build]$ cat > /home/**/gnucash-build/CMakeFiles/CMakeError.log > Determining if the pthread_create exist failed with the following output: > Change Dir: /home/**/gnucash-build/CMakeFiles/CMakeTmp > > Run Build Command:"/usr/bin/gmake" "cmTC_8837a/fast" > /usr/bin/gmake -f CMakeFiles/cmTC_8837a.dir/build.make > CMakeFiles/cmTC_8837a.dir/build > gmake[1]: Entering directory > '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > Building C object CMakeFiles/cmTC_8837a.dir/CheckSymbolExists.c.o > /usr/bin/cc-o CMakeFiles/cmTC_8837a.dir/CheckSymbolExists.c.o -c > /home/**/gnucash-build/CMakeFiles/CMakeTmp/CheckSymbolExists.c > Linking C executable cmTC_8837a > /usr/bin/cmake -E cmake_link_script CMakeFiles/cmTC_8837a.dir/link.txt > --verbose=1 > /usr/bin/cc CMakeFiles/cmTC_8837a.dir/CheckSymbolExists.c.o -o > cmTC_8837a > CMakeFiles/cmTC_8837a.dir/CheckSymbolExists.c.o: In function `main': > CheckSymbolExists.c:(.text+0x16): undefined reference to `pthread_create' > collect2: error: ld returned 1 exit status > gmake[1]: *** [CMakeFiles/cmTC_8837a.dir/build.make:87: cmTC_8837a] Error 1 > gmake[1]: Leaving directory '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > gmake: *** [Makefile:126: cmTC_8837a/fast] Error 2 > > File /home/**/gnucash-build/CMakeFiles/CMakeTmp/CheckSymbolExists.c: > /* */ > #include > > int main(int argc, char** argv) > { > (void)argv; > #ifndef pthread_create > return ((int*)(_create))[argc]; > #else > (void)argc; > return 0; > #endif > } > > Determining if the function pthread_create exists in the pthreads failed > with the following output: > Change Dir: /home/**/gnucash-build/CMakeFiles/CMakeTmp > > Run Build Command:"/usr/bin/gmake" "cmTC_fead3/fast" > /usr/bin/gmake -f CMakeFiles/cmTC_fead3.dir/build.make > CMakeFiles/cmTC_fead3.dir/build > gmake[1]: Entering directory > '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > Building C object CMakeFiles/cmTC_fead3.dir/CheckFunctionExists.c.o > /usr/bin/cc -DCHECK_FUNCTION_EXISTS=pthread_create -o > CMakeFiles/cmTC_fead3.dir/CheckFunctionExists.c.o -c > /usr/share/cmake/Modules/CheckFunctionExists.c > Linking C executable cmTC_fead3 > /usr/bin/cmake -E cmake_link_script CMakeFiles/cmTC_fead3.dir/link.txt > --verbose=1 > /usr/bin/cc -DCHECK_FUNCTION_EXISTS=pthread_create > CMakeFiles/cmTC_fead3.dir/CheckFunctionExists.c.o -o cmTC_fead3 -lpthreads > /usr/bin/ld: cannot find -lpthreads > collect2: error: ld returned 1 exit status > gmake[1]: *** [CMakeFiles/cmTC_fead3.dir/build.make:87: cmTC_fead3] Error 1 > gmake[1]: Leaving directory '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > gmake: *** [Makefile:126: cmTC_fead3/fast] Error 2 > > > Determining if the AB_Banking_RuntimeConfig_SetCharValue exist failed with > the following output: > Change Dir: /home/**/gnucash-build/CMakeFiles/CMakeTmp > > Run Build Command:"/usr/bin/gmake" "cmTC_0b53b/fast" > /usr/bin/gmake -f CMakeFiles/cmTC_0b53b.dir/build.make > CMakeFiles/cmTC_0b53b.dir/build > gmake[1]: Entering directory > '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > Building C object CMakeFiles/cmTC_0b53b.dir/CheckSymbolExists.c.o > /usr/bin/cc -I/usr/include/aqbanking6 -I/usr/include/gwenhywfar5 -o > CMakeFiles/cmTC_0b53b.dir/CheckSymbolExists.c.o -c > /home/**/gnucash-build/CMakeFiles/CMakeTmp/CheckSymbolExists.c > Linking C executable cmTC_0b53b > /usr/bin/cmake -E cmake_link_script CMakeFiles/cmTC_0b53b.dir/link.txt > --verbose=1 > /usr/bin/cc CMakeFiles/cmTC_0b53b.dir/CheckSymbolExists.c.o -o > cmTC_0b53b > CMakeFiles/cmTC_0b53b.dir/CheckSymbolExists.c.o: In function `main': > CheckSymbolExists.c:(.text+0x16): undefined reference to > `AB_Banking_RuntimeConfig_SetCharValue' > collect2: error: ld returned 1 exit status > gmake[1]: *** [CMakeFiles/cmTC_0b53b.dir/build.make:87: cmTC_0b53b] Error 1 > gmake[1]: Leaving directory '/home/**/gnucash-build/CMakeFiles/CMakeTmp' > gmake: *** [Makefile:126: cmTC_0b53b/fast] Error 2 > > File /home/**/gnucash-build/CMakeFiles/CMakeTmp/CheckSymbolExists.c: > /* */ > #include > > int main(int argc, char** argv) > { > (void)argv; > #ifndef AB_Banking_RuntimeConfig_SetCharValue > return ((int*)(_Banking_RuntimeConfig_SetCharValue))[argc]; > #else > (void)argc; > return 0; > #endif > } > > Determining
Re: [GNC] Building GnuCash from src distributions
> On May 19, 2021, at 10:34 AM, mike823 wrote: > > Since no GnuCash build with python bindings was ever provided, I have > attempted to build one myself. I would be interested to hear why the dev > team chose not to distribute binaries for GnuCash with python bindings. > > I spent couple of days working on this: > - 3 different linux distributions > - sources from git and tar files > - last release and 2 pervious > > I am an IT professional with many years of UNIX / LINUX experience and I am > embarrassed to say that all my attempts failed. > > Is there anyway you guys can help? TIA. Mike, We don't create the binaries on Linux, that's up to the distribution packagers. Debian has https://packages.debian.org/buster/python3-gnucash and Fedora's regular GnuCash RPM is built with the python bindings enabled. Most other distributions (notable exceptions include Slackware, OpenSuSE, and Gentoo) are derived from one or the other and very few of the derivatives build their own GnuCash package so you're most likely relying on one or the other. We don't include the python bindings in the Mac and Windows bundles because they have to link against libpython and it has to be the same libpython that the interpreter uses. There's no way to ensure a particular version is installed on a user's computer so we'd have to include an entire python setup inside the bundle. That would add a lot of bulk that would benefit only a few users. Have you looked at the extensive resources on the wiki, starting with, https://wiki.gnucash.org/wiki/Building, for instructions on building it yourself? 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] gnucash-cli --quotes get
> On May 17, 2021, at 4:58 AM, mike823 wrote: > > I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code > bellow in Gnucash::GnucashCli::start . Is another developer already working > on the same functionality? > > > >if (m_quotes_cmd) >{ >if (*m_quotes_cmd != "get") >{ >std::cerr << bl::format (bl::translate("Unknown quotes command > '{1}'")) % *m_quotes_cmd << "\n\n" ><< *m_opt_desc_display.get(); >return 1; >} > >if (!m_file_to_load || m_file_to_load->empty()) >{ >std::cerr << bl::translate("Missing data file parameter") << > "\n\n" > << *m_opt_desc_display.get(); >return 1; >} >else >return Gnucash::add_quotes (m_file_to_load); >} > Not that I know of, but don't overload --get-quotes, write a new command named something like --import-quotes and have it call the same function that File>Import>Import Prices from a CSV File does. 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] gnucash-cli --quotes get
No, --quotes-get runs finance quote. Importing via the command line is not yet implemented and AFAIK isn't on any core developer's todo list, so you're welcome to jump in and provide a pull request. Regards, John Ralls > On May 16, 2021, at 4:10 PM, mike823 wrote: > > Can "gnucash-cli --quotes get" load quotes from a file, like the import > prices from CSV does? Thanks. > > > > -- > 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] Cut/paste between databases
> On May 10, 2021, at 7:35 AM, Tommy Trussell wrote: > > On Sun, May 9, 2021 at 11:06 AM Paul Kinzelman wrote: > >> In that case, it'd be good to clear the transaction paste buffer >> when reading in a new file so that people won't make the >> mistake of thinking they can cut/paste between databases. >> > > It's a little more complicated than that -- even though GnuCash doesn't > EXPLICITLY support having more than one book open at the same time, many of > us have done it for years, so I think the protocol ought to be to check the > paste buffer to make sure the transaction to be pasted is from the same > book, and if not, disallow the paste. Ideally there'd also be some > indication about why the paste failed, but that's probably optional as long > as the behavior is explained somewhere. It's not that complicated, because GnuCash doesn't put the cut/copied transaction and splits on a clipboard notwithstanding the function names xaccTransCopyToClipBoard and xaccTransCopyFromClipboard. The clipboard in this case is a variable in gnc-tree-control-split-register.c, completely inaccessible to anywhere else in the running GnuCash instance never mind another process. It also shouldn't survive changing books, though I haven't tested to see what happens: A crash is entirely possible. 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] More USAA online setup problems
> On May 8, 2021, at 12:16 PM, smad...@hotmail.com wrote: > > Finally decided to set up USAA direct connect with the new procedures. > Followed John’s WIKI procedures exactly and double checked my entries. > Clicked on the Retrieve Account List button and got the following results: > > "12:02:46 Sending request... > 12:02:49 Using GnuTLS default ciphers. > 12:02:49 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD > 12:02:49 Certificate is not trusted > 12:02:49 Waiting for response... > 12:02:51 Parsing response... > 12:02:51 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 12:02:51 Status for account info request: Success (Code 0, severity "INFO") > The server successfully processed the request. > My five correct accounts were listed here > 12:02:51 Operation finished, you can now close this window." > > Since it listed my five accounts, it looked like it was successful. I then > closed the window by hitting the close button and then hit the Bank Setting > OK button which returned me to AQBanking Setup dialog where I selected the > Accounts tab, but no accounts were listed. > > I found a similar problem in a Feb 15 exchange between John R and Richard > where John suggested "creating a dummy account on the AQBanking Setup > Dialog's Accounts tab then go back to Users and retrieve your USAA accounts > again.” > I am in no way a computer guy and do not understand how to create a dummy > account. Would I set it up just like the original and then go back to the > first setup and try to download? Also, is there something else I can look > at. Thanks That's a bug in AQBanking. Start the AQBanking Setup Assistant, open Banks, and create a fake account, then go back to Users, edit your USAA setup, and retrieve the accounts again. They'll populate on the Banks tab and you can delete the fake account. 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] Cut/paste between databases
It can't work, the account GUIDs from the one book won't be valid in the other book. Regards, John Ralls > On May 6, 2021, at 3:31 AM, Liz wrote: > > On Wed, 5 May 2021 13:40:13 -0600 > Paul Kinzelman wrote: > >> I'm running gnucash 4.5 >> >> I've got two gnucash databases (personal and business) and I >> accidentally entered a charge into one instead of the other. So I >> tried cut from one and paste into the other and it didn't work. >> >> When I pasted, I got only the Description got pasted, and I filled in >> the rest >> of the transaction manually, but I couldn't get it to enter. The >> 'Enter' key did nothing and the transaction still stayed open. >> >> I had to cancel the transaction and enter the whole thing by hand and >> it worked. >> >> It'd not a big deal to get it fixed, or maybe copy/paste isn't >> supposed to work between >> databases? >> > I agree, it doesn't work, and I haven't tried to do it for a long time. > > Liz > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] My bank revised previous FITID numbers
Hello; Recently my bank completely revised all of the FITID numbers on every transaction for my QFX downloads. The new format is a guid, which is nicer than the previous format, but the problem is the QFX importer now wants to import all of the old transactions as new ones instead of recognizing they're already imported. Is there any way to get gnucash to recognize the transaction and update the FTID on the previously imported transactions? I suspect I'll just have to refrain from downloading a QFX file with older transactions in it. Thanks -- John Weldon ___ 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] Add a donate button in GnuCash (Glenn Fowler)
We don't need money, we need volunteers to help maintain and improve the program and especially the documentation. Regards, John Ralls > On May 1, 2021, at 8:24 AM, Colin Arndt wrote: > > Hi Glenn, > > Thank you for mentioning this. I'm embarassed to admit I've been a heavy user > since setting up GnuCash almost a year ago - but didn't realize the website > had a donate button until you mentioned it! > Therefore I agree about adding tastefully to the program. In my case, I can > only imagine I saw the donate option on the website when I first learned of > GnuCash, but didn't consider donating as someone who hadn't tried it yet. > Since then, I've spent my time in the program itself or on the mailing list > rather than the website, so had completely forgotten about that option. > Headed to the website now to donate, > Colin > > On May 1 2021, at 9:58 am, 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: Finance Quote after a MacOS update (David Reiser) >> 2. Re: Cut & Paste transaction problem (John Ralls) >> 3. Re: Separate file for each financial year vs single file (Uttam) >> 4. [MAINT] Unplanned network outage (Derek Atkins) >> 5. Re: Finance Quote after a MacOS update (Outlook) >> 6. Permission to use GNUCash (Andrew O'Neill) >> 7. Add a donate button in GnuCash (Glenn Fowler) >> >> >> -- >> Message: 1 >> Date: Fri, 30 Apr 2021 12:23:51 -0400 >> From: David Reiser >> To: Outlook >> Cc: John Ralls , Gnucash Users >> >> Subject: Re: [GNC] Finance Quote after a MacOS update >> Message-ID: <6165ee62-5598-444c-82f9-c38785d06...@icloud.com> >> Content-Type: text/plain; charset=utf-8 >> >> Apple is not including the Perl headers location in CPATH these days. I?ve >> never figured out authoritatively how to avoid installing two versions of >> the Command Line Tools, so if you follow the following recipe, you?ll likely >> have one set inside XCode and one in /Library/Developer >> xcode-select ?install >> export >> CPATH=/Library/Developer/CommandLineTools/SDKs/MacOSX11.3.sdk/System/Library/Perl/5.30/darwin-thread-multi-2level/CORE:$CPATH >> >> then run the cpan commands >> -- >> Dave Reiser >> dbrei...@icloud.com >> >> >> >> >> >>> On Apr 30, 2021, at 11:27 AM, Outlook wrote: >>> >>> sudo /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check >>> >>> Reported >>> >>> Can't locate JSON/Parse.pm in @INC (you may need to install the JSON::Parse >>> module) (@INC contains: /Library/Perl/5.30/darwin-thread-multi-2level >>> /Library/Perl/5.30 /Network/Library/Perl/5.30/darwin-thread-multi-2level >>> /Network/Library/Perl/5.30 >>> /Library/Perl/Updates/5.30.2/darwin-thread-multi-2level >>> /Library/Perl/Updates/5.30.2 >>> /System/Library/Perl/5.30/darwin-thread-multi-2level >>> /System/Library/Perl/5.30 >>> /System/Library/Perl/Extras/5.30/darwin-thread-multi-2level >>> /System/Library/Perl/Extras/5.30) at >>> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >>> BEGIN failed--compilation aborted at >>> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >>> Compilation failed in require at (eval 293) line 1. >>> BEGIN failed--compilation aborted at (eval 293) line 1. >>> at /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check line 91. >>> Can't locate object method "methods" via package >>> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line >>> 120. >>> >>> >>> sudo cpan -f -i JSON::Parse >>> >>> Reported errors as below >>> >>> Parse.xs:1:10: fatal error: 'EXTERN.h' file not found >>> #include "EXTERN.h" >>> ^~ >>> 1 error generated. >>> make: *** [Parse.o]
Re: [GNC] Add a donate button in GnuCash
I disagree. I think that a donate button on the program would be coercive and obnoxious as well as pointless. Regards, John Ralls > On May 1, 2021, at 8:36 AM, Glenn Fowler wrote: > > Ok it's just a thought. > "It's better to have it and not need it, than to need it and not have it" > as the saying goes. > Hardware, storage, internet, bug bounties, services, electricity, etc all > cost real money > > On Sat, May 1, 2021, 11:28 AM Derek Atkins wrote: > >> HI, >> >> On Sat, May 1, 2021 10:58 am, Glenn Fowler wrote: >>> Hello, >>> I think it would be an enhancement if there was a "Donate" button in >>> the GnuCash program. This could simply link to the website donate >>> page. >>> It's unobtrusive, gives users a quick way to donate, and hopefully >>> will increase donation awareness and bring in additional funding to >>> the project. >>> >>> This is customary and in many open source software apps & programs. >>> Thoughts? >>> >>> (I also posted this on BugZilla as an enhancement) >> >> Thank you. We appreciate the sentiment. >> However, right now, we really don't *use* the funding we have, so it's >> just sitting there for a "rainy day". >> We have tried "bug bounties" before, without great success. >> I believe we would be open to alternative uses of the "tip jar" funds. >> I'm not sure we really need to increase the influx of donations. >> >> Thanks, >> >>> 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. ___ 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] Permission to use GNUCash
> On Apr 29, 2021, at 5:53 PM, Andrew O'Neill wrote: > > Hi, > > My name is Andrew and I just started working for an online teaching company > called Outschool. I am a passionate user of GNUCash for the past two years > and I am planning to teach the students the basics of tracking their finances > using GNUCash. I wanted to reach out to you all and ask for permission to use > GNUCash as a teaching tool. If you can get back to me when you get the chance > that would be great! > Andrew, You don't need permission to use GnuCash for teaching or for anything else. GnuCash is Free Software: https://www.gnu.org/philosophy/free-sw.en.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] Cut & Paste transaction problem
> On Apr 30, 2021, at 5:25 AM, Robert Stocker wrote: > > I'm running GnuCash version 4.5 (build ID: Flathub 4.5) on Ubuntu 20.10. > > I experienced this problem: After entering a transaction in the wrong > register, I used the Transaction > Cut transaction command, went to the > correct register, and used Transaction > Paste transaction. There was an > immediately visible problem. While some fields came across intact, several > of them were clearly out of order or seemingly random data. As it happens, > the first time I noticed this was on a split transaction with 4 or 5 > splits, and the data was well and truly mangled beyond recognition. Since, > I have verified this with both split and single-line (non-split) > transactions in credit card registers, but have not tried every type of > account register. > > For the time being, I recommend using Transaction > Copy transaction > followed by Transaction > Paste transaction (a combination which seems to > work correctly) and then delete the unwanted original. Because Copy then > Paste seems to work, my suspicion is that the bug is in the "Cut" portion > of the code. > > I have not experienced this problem before, and have cut & pasted > transactions in this manner plenty of times. First guess is that cut is destroying the transaction so that the pointer on the clipboard isn't valid any more. Some of it has been reallocated to something else so it's garbage when paste goes to use it. 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] Unable to connect to BECU via OFX Direct
> On Apr 29, 2021, at 4:00 PM, Marc Champagne via gnucash-user > wrote: > > I’ve been trying to setup Online Banking so I can connect to BECU via > OFX-DirectConnect but the server keeps disconnecting immediately when I try > to retrieve my account list. > > This is all I see in the dialog: > 15:56:57 Sending request...15:56:57 Using GnuTLS default ciphers.15:56:57 > TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD15:56:57 > Waiting for response...15:56:58 Operation finished, you can now close this > window. > Has anyone been able to connect to BECU online backing using > OFX-DirectConnect? http://www.ofxhome.com/index.php/institution/view/825 says "Fail: Did not return valid OFX! Last validated on September 16th, 2020" https://www.becu.org/support/online-banking explains only their mobile phone app and website, no mention of Quicken. My guess is that they don't support OFX DirectConnect any more, but call them and ask about using Quicken. 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] "No suitable backend" message trying to open an alias to a gnucash file
> On Apr 26, 2021, at 11:41 PM, Michael Hendry wrote: > >> On 27 Apr 2021, at 00:57, John Ralls wrote: >> >> >> >>> On Apr 26, 2021, at 2:00 PM, Michael Hendry >>> wrote: >>> >>> I’m using GC 4.4 on iMac, running OS X Catalina. >>> >>> I want to place a book (say “BookA.gnucash”) in a Dropbox folder so that a >>> deputy can take over in the event of my not being available at short notice. >>> >>> Dropbox now requires original files, not aliases, in the Dropbox directory, >>> so I can’t keep my books in ~/Documents/Accounts and provide links. >>> >>> In any case, Apple seems to have broken the command-line tool “ln”, so I >>> can’t use that mechanism. >>> >>> Finder offers a means of creating an alias via right-clicking on a >>> filename, so I tried putting BookA.gnucash in ~/Dropbox, and placing an >>> alias called BookA.gnucash in ~/Documents/Accounts, but when I try to open >>> BookA via the alias I get the “No suitable backend” message. >>> >>> I’ve found this technique works OK for a simple text file, edited with >>> MacVim. >>> >>> A cron job that copied the current version of BookA.gnucash to Dropbox on a >>> regular basis and as part of the shutdown sequence should work, but I >>> haven’t tried it yet. >>> >>> Any other suggestions? >> >> Michael, >> >> Both `ln` to make a hard link and `ln -s` to make a symlink work for me >> (macOS 11.3 Beta (20E5217a)) and GnuCash 4.5 is able to open either of them. > > On my late-2012 iMac 27 inch, “ln” appears to work at first, making an > up-to-date copy of the source file in the destination directory, but > subsequent changes in the source file aren’t reflected in the destination. > Can you confirm that this has been fixed in 11.3? > Michael, That's the expected behavior because with the XML backend when GnuCash saves it first renames the original file--the one you hard-linked--to become the backup file. If you switch to the SQLite3 backend it will work the way you want. 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] Thinking about Moving to MacOS from Win 10
> On Apr 27, 2021, at 6:49 AM, Michael or Penny Novack > wrote: > > On 4/26/2021 12:44 PM, Jack Frillman via gnucash-user wrote: >> Just copy the main data file. >> I copy it from my iMac to my Linux laptop for a backup and to a Windows 10 >> laptop for a backup to my Linux laptop. >> Any reports you create will require copying a different file though. > > > Just a suggestion from somebody who went through recovery after a house fire > << we did have data recovery coverage and ONE of the drives of ONE of the > computers was not too smoke damaged for the recovery lab to get the data from > that one; the rest, no dice. And if we had not had that rider on our policy, > the cost would have been prohibitive >> > > Maybe not every time, but once in a while, maybe monthly, make a copy of the > data on your machines to either ROM medium or an external drive that will > reside elsewhere (not in the same building). Ours (now) goes onto a drive > that lives in a fire safe in the barn, only at risk of "same building" when > brought into the house to make the backup. Of course you COULD use a "cloud > server" but I do not care to allow third party access to my data. > > If you are a business, your accountant SHOULD be telling you to do this as > "standard procedure" for a business. I guess the barn would be OK if you don't live in California where whole towns go up in smoke. Cloud storage is IMO an ideal backup medium because not only is it far away it's likely replicated to multiple data centers. If you're concerned that the cloud provider's encryption isn't sufficient you can layer your own on top of it. macOS provides an encrypted disk image that I've used for several years with Google Drive, but there are a couple of Windows solutions that have caused trouble in the past so test thoroughly before committing to any utility. 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] Finance Quote after a MacOS update
Having seen David's earlier post I did sudo cpan install Test2 sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update which ran successfully, after which /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check reported the usual list of sources. Anyone care to open an issue at https://github.com/finance-quote/finance-quote about them needing to add the dependency on Test2 to the CPAN metadata? Regards, John Ralls > On Apr 26, 2021, at 7:34 PM, David Reiser via gnucash-user > wrote: > > You will have to reinstall Date::Manip again too, but I think all the error > problems in reinstalling Finance::Quote are taken care of by > > upgrade Test 2 > > before > > install Finance::Quote > > inside CPAN (launched with “sudo CPAN”) > -- > Dave Reiser > dbrei...@icloud.com > > > > > >> On Apr 26, 2021, at 10:30 PM, Outlook wrote: >> >> Just had the same issue after upgrading to MacOS 11.3. (with GNC V4.4) >> >> Message as below: >> >> Test Summary Report >> --- >> t/00-use.t (Wstat: 512 Tests: 1 Failed: 0) >> Non-zero exit status: 2 >> Parse errors: Bad plan. You planned 19 tests but ran 1. >> t/currency_lookup.t (Wstat: 512 Tests: 0 Failed: 0) >> Non-zero exit status: 2 >> Parse errors: Bad plan. You planned 12 tests but ran 0. >> t/quote.t(Wstat: 512 Tests: 0 Failed: 0) >> Non-zero exit status: 2 >> Parse errors: Bad plan. You planned 28 tests but ran 0. >> Files=66, Tests=1, 6 wallclock secs ( 0.11 usr 0.08 sys + 5.09 cusr 0.98 >> csys = 6.26 CPU) >> Result: FAIL >> Failed 3/66 test programs. 0/1 subtests failed. >> make: *** [test_dynamic] Error 255 >> ECOCODE/Finance-Quote-1.49.tar.gz >> 2 dependencies missing (DateTime::Format::Strptime,JSON::Parse); >> additionally test harness failed >> /usr/bin/make test -- NOT OK >> //hint// to see the cpan-testers results for installing this module, try: >> reports ECOCODE/Finance-Quote-1.49.tar.gz >> >>> David Reiser via gnucash-user >> <mailto:gnucash-user@gnucash.org>> 於 2021年4月27日 上午9:04 寫道: >>> >>> Found it. Had to >>> upgrade Test2 >>> >>> Perl is so much fun >>> >>> Dave >>> -- >>> Dave Reiser >>> dbrei...@icloud.com <mailto:dbrei...@icloud.com> >>> >>> >>> >>> >>> >>>> On Apr 26, 2021, at 8:45 PM, David Reiser via gnucash-user >>>> mailto:gnucash-user@gnucash.org>> wrote: >>>> >>>> Installing MacOS 11.3 seems to have blown away Finance-Quote. >>>> My efforts to get it installed via CPAN end with a bunch of errors >>>> /usr/bin/make test -- NOT OK >>>> >>>> It seems to keep thrashing along until it quits with >>>> >>>> ECOCODE/Finance-Quote-1.49.tar.gz: make_test NO one dependency >>>> not OK (DateTime::Format::Strptime); additionally test harness failed >>>> >>>> The DateTime::Format::Strptime installed already is too old (v 1.25), but >>>> it doesn’t upgrade either. >>>> >>>> Suggestions? >>>> >>>> Dave >>>> -- >>>> Dave Reiser >>>> dbrei...@icloud.com <mailto:dbrei...@icloud.com> >>>> >>>> >>>> >>>> >>>> >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> To update your subscription preferences or to unsubscribe: >>>> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823488996353%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=37UErf7ScpWLpL1pVONLr%2FV4YHnSPKkAuq6qDp6MUg4%3Dreserved=0 >>>> >>>> <https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823488996353%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=37UErf7ScpWLpL1pVONLr%2FV4YHnSPKkAuq6qDp6MUg4%3Dreserved=0> >>>> If you are using Nabble or Gmane, please see >>>> https://apac01.safelinks.protection.outlook.com/?url=htt