Re: [GNC] v3.8 - Unable to save to database message - all accounts zero
> On Dec 30, 2019, at 11:39 AM, brob2684 wrote: > > Hi, > > I just installed v3.8 on my Windows 10 machine (not sure exactly which > version I had previously, but it was at least v3.6). I save in the sqlite > format. > > When I open my file, all the account have zero balances. Double-clicking on > an account brings up an empty register (i.e. no transactions). Closing the > account generates the message 'unable to save to database'. > > Here's what I've done so far: > > 1. A google search got me to this post experiencing a similar error message: > http://gnucash.1415818.n4.nabble.com/GNC-Unable-to-save-to-database-Build-ID-3-2-2018-06-24-td4702739.html. > > 2. I took a look at https://wiki.gnucash.org/wiki/Tracefile to find the > trace file on my system. > > 3. Took a look at the trace file. It had lots of errors like this > > /* 06:14:22 ERROR > [GncDbiSqlConnection::execute_select_statement()] Error executing SQL SELECT > * FROM transactions WHERE guid IN (SELECT DISTINCT tx_guid FROM splits WHERE > account_guid = 'fd3362e93c5d4c55977254dfd1ee61a9') > * 06:14:22 ERROR [error_handler()] DBI *error: 1: no such > table: splits*/ > > 4. Opened up my sqlite gnucash file in a viewer and noted that the *splits* > table no longer exists, but there is a *splits_new* table. > > My question is, is there any harm in just dropping the *_new* suffix to > rename the table back to *splits*? Probably not, but make a copy of the file first. You might also find your latest backup before the upgrade, make a copy of that, and try opening it with 3.8, ideally by running GnuCash with --log gnc.backend.dbi=debug and then saving the tracefile aside so that it doesn't get overwritten. If the table upgrade fails again that might be helpful in diagnosing why. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "Update finance quote' query
> On Dec 29, 2019, at 1:54 AM, Varun Francis wrote: > > Hi, > > I have just downloaded Gnucash. Unfortunately, I am unable to figure out > how to install Finance:quote. I'm a complete novice with no programming > knowledge. When I checked on the website, it mentioned that I should run > "update finance quote" app from the dmg file, however, my dmg file had no > such file. > > Please let me know how to proceed. Unfortunately the Update Finance Quote script works in a way that violates security in MacOS 10.15 and I had to remove it in order to for Apple to notarize the dmg. You can do what it did pretty easily, though. Open /Applications/Utilities/Terminal and at the prompt type sudo cpan -i Finance::Quote it will ask for your password, type that in. It may put up a dialog box asking if you want to install command line tools; tell it that you do. After that it will print a lot of stuff to the terminal window that you can ignore. Once it finishes you need to run another command, sudo cpan -i Date::Manip When that finishes, test that it works by running /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump yahoo_json AAPL You should get output something like Finance::Quote fields Gnucash uses: symbol: AAPL <=== required date: 12/31/2019 <=== recommended currency: USD <=== required last: 293.65 <=\ nav: <=== one of these price: <=/ timezone: <=== optional 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 3.7 Won’t Set Up Online Banking
> On Dec 28, 2019, at 3:07 PM, Traveler12 wrote: > > Is anyone actually fixing all these things that don't work in this program? > All of them? No, we don't have enough people with enough time. We did manage to clear 43 bugs in last Sunday's release. On the other hand your problem is more likely with AQBanking's OFX Direct support and the AQBanking developer reported that since he's unable to test OFX Direct because he's in Germany and since nobody has come forward to help him with that in several years he's suspended work on it. So in your case, no, nobody is going to work on your problem. 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] v3.8
> On Dec 31, 2019, at 10:34 AM, farleykj wrote:
>
> Hi John,
> Seems like I'm always dealing with Perl troubles on here.
> I found the utility script you described, and the results I get with it are
> as expected:
>
> < --- Begin Test --- >
> $VAR1 = {
> 'AMZNerrormsg' => 'Error retrieving quote for AMZN. Attempt to
> fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=AMZN
> resulted in HTTP response 500 (Internal Server Error)',
> 'AMZNsymbol' => 'AMZN',
> 'AMZNsuccess' => 0
>};
> < --- End Test --- >
>
> Perl: V5.18.2
> Finance::Quote V1.49
> MacOS Sierra V10.12.6
>
> I'm kind of at a loss as to how to debug this given the above info. Could it
> be that the URL in the YahooJSON.pm I have is no longer valid?
>
Nope. If I paste that into my browser I get a nice JSON quote. Maybe you have
other perl modules, LWP comes to mind, that are borked. Try `sudo cpan -i
Finance::Quote` which should get F::Q and all of its dependencies up to date.
Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
> On Dec 31, 2019, at 9:57 AM, boldstripe wrote: > > I may have posted too soon without testing the debian packages for v3.8. > Installation from the v3.8 .deb files I gave the URL for failed for me on > Debian Buster when installing using apt (and individually using gdebi, with > similar dependency issues). I uninstalled v3.7 first. > > Here is a transcript from my Terminal session: > > michael@thinkpad-debian:~/Downloads$ cd gnucash_3.8_deb/ > michael@thinkpad-debian:~/Downloads/gnucash_3.8_deb$ sudo apt install > ./*3.8*.deb > Reading package lists... Done > Building dependency tree > Reading state information... Done > Note, selecting 'gnucash' instead of './gnucash_3.8b-1_amd64.deb' > Note, selecting 'gnucash-common' instead of > './gnucash-common_3.8b-1_all.deb' > Note, selecting 'python3-gnucash' instead of > './python3-gnucash_3.8b-1_amd64.deb' > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > gnucash : Depends: libaqbanking43 (>= 5.99.43) but it is not installable > Depends: libboost-regex1.67.0-icu63 but it is not installable > Depends: libgwengui-gtk3-0 (>= 4.99.24) but 4.20.0-9 is to be > installed > Depends: libgwenhywfar78 (>= 4.99.10beta) but it is not > installable > Depends: libstdc++6 (>= 9) but 8.3.0-6 is to be installed > Recommends: gnucash-docs but it is not going to be installed > E: Unable to correct problems, you have held broken packages. > As a guess, Dmitry built it for testing or unstable rather than stable. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
On MacOS 10.15 with GnuCash 3.8:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump yahoo_json AMZN
Finance::Quote fields Gnucash uses:
symbol: AMZN <=== required
date: 12/30/2019 <=== recommended
currency: USD <=== required
last: 1846.89 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
I don't remember offhand what perl shipped on Sierra, but Catalina has only
5.18 and the latest is 5.30. That's clearly not required.
There's a test program, stockdump.pl in the cpan build directory
(~/.cpan/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl on my system):
~/.cpan/build/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl yahoo_json AMZN
$VAR1 = {
'AMZNvolume' => 3591419,
'AMZNlast' => '1846.89',
'AMZNmethod' => 'yahoo_json',
'AMZNdate' => '12/30/2019',
'AMZNcurrency' => 'USD',
'AMZNname' => 'AMZN (Amazon.com, Inc.)',
'AMZNsymbol' => 'AMZN',
'AMZNsuccess' => 1,
'AMZNisodate' => '2019-12-30',
'AMZNexchange' => 'Sourced from Yahoo Finance (as JSON)',
'AMZNtype' => 'EQUITY'
};
That might be helpful for troubleshooting.
Regards,
John Ralls
> On Dec 30, 2019, at 8:01 PM, farleykj via gnucash-user
> wrote:
>
> Thanks, David.
> I just used the quote downloading in the 2.6 version I was running
> previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no
> longer works.
> Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I
> ran the gnc-fq-update module to try and get things working, but to no avail.
> That makes me think it's my Perl installation or something of the sort,
> since I don't hear any others screaming about it.
> I looked back through the old posts about this, but it always seemed to be
> an alphavantage difficulty, or some such. I have been using "Yahoo as JSON"
> for as long as that has been around, with no problems.
> Maybe I'll need to install the latest Perl or something like that. How
> tedious.
>
>
>
> -
> Ken Farley
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 3.8 Released
The GnuCash development team announces GnuCash 3.8, the eighth release of the 3.x stable release series. Changes Between 3.7 and 3.8, the following bugfixes were accomplished: • Bug 412151 - Not handling exception when guile is compiled w/o regexp support disable qif-import and make-regexp if guile is compiled without regex • Bug 724219 - Customer Summary includes Closing Entries when reporting across the end of year • Bug 743943 - "Edit->Post Invoice" is ambiguous Read invoice type and set label and tooltip texts to the translations of static definitions. Remove unnecessary list counts. • Bug 759005 - Print negatives in red • Bug 787295 - Allow UI jump from Business accounts to their relevant invoice/bill/voucher • Bug 796530 - [txn csv importer] usability suggestions • Bug 796736 - Register cell pop up columns width to narrow • Bug 796945 - Search dialog update • Bug 797078 - "Automatic decimal point" Should Not Cause 2 Different Behaviors • Bug 797086 - Import customer dialog – headers not translated • Bug 797279 - Reports RTL do not support RTL • Bug 797326 - Enhancement: budget's Estimate tool should ignore Closing Entries • Bug 797356 - ninja check fails with GCC-9 • Bug 797390 - xaccAccountRecomputeBalance also tallies no-closing balances • Bug 797397 - Import Map Editor, Ctrl-A with filter • Bug 797401 - Invoice Reports need an overall page width set Use html5 @media to set main-table to page width. • Bug 797405 - : Fix hiding PIN entry window behind online banking log window If there is a log window, make the PIN entry transient_for that one instead of its parent. • Bug 797408 - Find Transaction Window -> Search Criteria Section -> Add Search Criteria -> Section does not expand to new size to include a newly added Search Criteria • Bug 797416 - Enter key does not move to blank tx or next line • Bug 797418 - In budget report, column with Actual Totals for Liabilities and Income are reversed • Bug 797453 - Chart of Accounts is slow to update / redraw • Bug 797459 - Installation (for 3.7) Readme Version number shows 2.2.x • Bug 797462 - gnc:strify reports the amount and value incorrectly • Bug 797468 - Receivable Aging report - phantom company with negative total • Bug 797473 - UTF8 characters not processed correctly with aqbanking6 • Bug 797481 - crash on close of unsaved tabs by pressing [X] • Bug 797482 - Can't edit date when using Edit Payment function • Bug 797492 - Lock up on 'Find Account' • Bug 797500 - valgrind errors - new/delete vs malloc/free • Bug 797506 - New Aging errors out with guile backtrace in case of a few uncommon transactions • Bug 797519 - Budget Viewer Totals do not redraw upon to Sign-Reversal changes • Bug 797520 - ] Balance Sheet (Multicolumn) the retained earnings amount in the equity section has its sign reversed • Bug 797521 - Receivable Aging (beta): prepayments logic doesn't work, appears to use incorrect absolute value logic • Bug 797532 - Crash/Coredump Lots The following fixes and improvements were not associated with bug reports: • The Customer/Employee/Vendor reports have been rewritten. The new versions may be found in Reports>Experimental. • [stylesheet-css] a user-customisable CSS based stylesheet New stylesheet. Exposes a single text box for full CSS customisability. • Allow account selection by typing into the post-to field of the payment window • When sizing some register columns take account of 'Tot' being added. • Take account for the pop up button border in the register. • Change the date sample so it has the maximum text width possible • [new-owner-report] bugfix: balance row needs variable linked cols • Improve translations by scriptedly removing the removed colon suffix. • [report-utilities] bugfix: aging-list was incorrect. off-by-1 error. • [report-utilities] bugfix: overpayment works for AP accounts. • Swap the buttons around on the Budget Open dialogue Swap the OK and Cancel buttons so they conform to the normal layout. • [report-utilities] bugfix: fix overpayment detection For 1 payment to >1 invoices, previously would miscalculate overpayment. • [budgets.scm] Budget reports handle both natural & reversed budgets. This change is protected by a Feature: Using it will prevent the file from being opened by earlier versions of GnuCash. • [gnc-budget-view.c] totals - 5 fundamental types previous showed income/expense/transfers/totals budget totals, of uncertain meaning. now shows income/expense/asset/liability/equity budget totals. The 5 lines also become sensitive to the global sign-reverse property. • bindings-python - drop references t
Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers
> On Dec 29, 2019, at 6:56 AM, boldstripe wrote: > > HTML exports of charts (reports) can open and display satisfactorily in any > browser on Linux, but they are blank on MacOS or Windows. > > On a MacOS or Windows browser, the chart area is blank (white). Any > accompanying text table underneath the chart displays as expected, below the > blank area. > > Text-only HTML reports are visible on MacOS and Windows. > > Is there fix for this? Should I report it as a bug? On MacOS it works for me with Chrome (my usual browser) and Firefox. Safari fails to display anything and examining the page in the console shows that it's failing to open the Javascript files in GnuCash.app. I don't see how that's GnuCash's problem. Several Windows users have reported that they can view graphical reports in the browser in the course of investigating https://bugs.gnucash.org/show_bug.cgi?id=797283. 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] Edit Cut and Copy greyed out
> On Dec 13, 2019, at 8:16 AM, Tony Vanson wrote: > > Hi All, > A problem that's just occurred in the last couple of days is that I can no > longer *Copy* or *Cut* a full line account item as both the *Cut* and > *Paste* in the *Edit* tab are greyed out and therefore unusable, however > *Duplicate* works OK. > I am using Windows 10 and GNUcash V 3.7. > I can select part of the line item at which time Cut and Copy become > available. > Is this a deliberate change or am I missing something? It's not intentional. Did you install 3.7 in the last couple of days and see the change once you did? If so, do you know what version did you have installed before? If not, what else might have changed recently on your system? 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] Invoice date field starts too narrow
Axel, Also make sure they're on the end of the email after all text including signatures. The list server eats inline attachments. GnuCash is supposed to remember things like column widths so that you need set them only once. Is that not working for the Invoice date column--or perhaps any invoice columns? Regards, John Ralls > On Dec 11, 2019, at 3:52 PM, Frank H. Ellenberger > wrote: > > Hi Axel > > Am Mi., 11. Dez. 2019 um 08:53 Uhr schrieb Axel Essbaum : >> >> >> Hi All, >> >> MacOS Mojave, GnuCash 3.6. Pictures say it all (hope this list allows >> attachments!) > : > There was no attachment, neither in the mail nor on the server: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088216.html > > That might be caused by sending mails in HTML format. In text format, > attachments should go through. > > Regards > Frank > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ 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] automatic reconnaissance of a transaction
> On Dec 3, 2019, at 4:16 PM, Joffrey Bienvenue > wrote: > > Hello > > When I import transactions from my bank accounts, some transactions, very > few in fact, are recognized by GnuCash. It used to be better at recognizing > but I find it's less and less. > > Is there a way to help that "reconnaissance" ? > > Some transactions I am registering are *always* posted in the same category > (eg. Expenses->Groceries) but it keeps on not being recognized. The matcher works mostly from descriptions. Have those changed significantly? There are two things you can do: Always update the matches and from time to time use Tools>Import Match Editor to remove obsolete matches that might lead the match algorithm astray. If nearly all of your transactions will match descriptions exactly with their predecessors then the non-Bayesian matcher may work better, but in all other cases the Bayesian one will be better in the long run, though it requires more training at the outset to start getting good matches and needs to be maintained by reviewing matches and correcting mismatches *in the matcher* to keep on track. 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] "?" symbol pre fixed with all balances in my account balances
> On Dec 1, 2019, at 12:49 AM, Keshava M P wrote: > > Hello! > > My installation of Gnucash works perfectly. Accounts are reconciled. But > all balances shown in accounts page( also at the bottom of each account > when I open them to post transactions) are prefixed with "?" symbol. > > Any idea what is the meaning of this? It means that the default typeface that GnuCash uses doesn't include the glyph for your national currency symbol. See https://wiki.gnucash.org/wiki/GTK3#Typefaces for how to configure a different one. 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 morningstar uk (and europe?) have changed stuff
> On Nov 30, 2019, at 12:58 PM, Wm via gnucash-user > wrote: > > On 24/11/2019 23:07, Richard Ullger wrote: >> On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: >>> >>> Which OS and perl version are you on? At the moment it is looking like >>> gnc might need a more recent version of strawberry perl on Win but I >>> can't quite work out why. If you (or anyone else) let me know your >>> version stuff I'll try and work it out and take it up in the dev list or >>> with the FQ people as appropriate. >> I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/ > > Getting a more up to date perl on Win sorted it out. I'll put this on the > bug-list as it seems gnc on Win has no way of working out when it needs a new > perl. Perl 5 is very stable in terms of language features and mstaruk.pm has had only a couple of string changes--no code--since it was first contributed 6 years ago. The problem was more likely that something was wrong with the perl instance: Either it got corrupted or Microsoft pushed a subtly incompatible change to one of its dependencies. Did you try reinstalling the same version of perl that you had? 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] Locked out of gnucash
> On Nov 25, 2019, at 9:44 AM, Derek Atkins wrote: > > Adrien Monteleone writes: > >>> Again, if user A has a data file open, user B shouldn't also open >>> the file. I don't see how a check for Gnucash instances could work >>> to prevent precisely this problem, since my machine won't have any >>> Gnucash instances running--but the file IS being used. >> >> I agree, using the PID won’t work, because although GnuCash is not >> (yet) a multi-user app, some people do use it from various machines >> with the file stored on a network. A PID check won’t mean anything to >> one machine when that PID belongs to a different machine. > > Using a "machine-name + PID" will absolutely work, because: > 1) If the machine-name is the local machine, you can check the PID and > if the PID is not gnucash, you know it was an unclean exist. > > 2) If the machine-name is the local machine, you can check the PID and > if the PID IS gnucash, you know there is another running instance. > > 3) If the machine-name is NOT the local machine, then you cannot > differentiate what's going on and should ask. Most likely it IS open, > but there's no good way to tell. > > The good news is that #1 and #2 ARE the most common use-cases today, so > we should implement that. Oh, goody! ;-) "Patches Welcome!" 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
> On Nov 25, 2019, at 11:21 AM, Stephen M. Butler wrote: > > On 11/25/19 7:16 AM, Derek Atkins wrote: >> Hi David, >> >> David Carlson writes: >> >>> Derek, >>> >>> If what you call a rolling balance is what I call a running balance, then I >>> think that the account register view will show that when it is sorted in >>> chronological order. In fact, as others have already noted, you can see >>> that >>> in your top level accounts. Where you won't see it is in mixed commodity/ >>> mixed currency cases such as stock brokerage accounts or other mixed >>> currency >>> accounts. For those cases it is necessary to use a report that can evaluate >>> appropriate exchange rates. >> Yes, rolling/running balance. However, while there is a balance column >> being displayed, it might not show the *correct* balance because each >> split shown has a precomputed balance for the actual account it is tied >> to. This balance is recomputed whenever a split in the account is >> modified. However, it is NOT computed in real-time for display. >> >> So when you do a "Open Subaccounts" view, it is not recomputing the >> balance including everything, but rather it is still showing the >> pre-computed balance of the split's account balance for that split. >> >> It *MAY* look correct at some points in time, but in general, no, it is >> not. >> >>> David Carlson >> -derek >> > > I understand the legacy reasons for doing this, but as a corporate DBA > (Oracle), I find this troubling. Running balances should never be > stored! Again, I understand why legacy systems do this but we now have > enough horsepower in the CPU and back-end database systems to alleviate > the need. Hopefully as GnC is migrated to a multi-user database > back-end system, this will be redesigned. > Yes it will. In the meantime there is no backend system and computing balances requires traversing a linked list of all splits in the account, a fairly expensive operation even with fast hardware--and the code isn't smart enough to do it for sub-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] Voucher checks?
> On Nov 23, 2019, at 10:35 AM, Roderick Anderson wrote: > > Good Day. > > The organization I am treasurer for currently has three-up checks that I fill > out by hand. > > We typically only use 10 or less a year and I have plenty on hand but I would > prefer not hand writing them out. I don't need GnuCash to print the checks > but do need something that is usable from LibreOffice - ready made template? > > My research (Google) turns some up but everyone mentions being compatible > with commercial accounting software. Probably so they can be printed from > the software. Since I do not need that I would still like any thoughts or > suggestions for a good brand. GnuCash can print 3-up voucher checks, see https://www.gnucash.org/docs/v3/C/gnucash-help/print-check.html. The only reason not to use it would be if you get checks that don't have the MICR routing id and account number pre-printed on them, but if you're currently filling them out by hand you must already have those. 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] [Q]W2 Form
> On Nov 21, 2019, at 2:40 PM, ceandyek laedon via gnucash-user > wrote: > > Can we use gnucash to generate W2 Form? > No. 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] Locked out of gnucash
Except that the file was closed immediately after completing the session load. GnuCash will rename it and write a new one if you have made changes to the book in memory and tell it to save those changes or let it auto-save, but you can certainly close the session and so delete the lock file without saving. It really is about the lock file, not the data file. Regards, John Ralls > On Nov 17, 2019, at 4:24 PM, David Carlson > wrote: > > A comment about Stan Brown's suggestion. > > I think a better and more accurate wording would be "The data file has not > been cleanly closed since it was last opened. If you are sure that it was > not opened by another user, click 'Open Anyway'. Otherwise click one of > the other options." > > To me the important part is that the data file has not been cleanly closed, > which is the real reason that the lock file exists. There may be better > words to use as long as this idea is incorporated. > > David Carlson > > On Sun, Nov 17, 2019 at 4:35 PM Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> Hello Stan et al. >> >> I like the idea. A short grep delivers 5 occurrences of likewise texts: 4 >> at >> >> https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 >> and one further below: >> >> https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 >> I am not totally sure if the change can be applied on aloof them. >> >> BTW. Splitting the first 4 strings like the last would reduce the >> burden for our translators. >> >> Regards >> Frank >> >> Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown >> : >>> >>> In the two years I've been reading this list, I think the single most >>> common question has been about this "could not obtain the lock" message. >>> Seems like someone asks about it at least once a week. >>> >>> The text "that database may be in use by another user," while literally >>> true, isn't helpful because it points to a less common case and gives no >>> guidance for the more common case. It's like hearing hoofbeats and >>> hypothesizing "zebra" instead of "horse". >>> >>> I suggest that improving the message would be a huge boon to less >>> experienced GC users, and very little effort for the developers. >>> >>> Why not replace the present text >>> >>>That database may be in use by another user, in which case you >>>should not open the database. What would you like to do? >>> >>> with this: >>> >>>If your previous session crashed, select Open Anyway. If this is >>>a shared database, wait for other users to finish using it or >>>select Open Read-Only. For more information, see (link to sec >>>2.5.3 of Tutorial). >>> >>> "What would you like to do?" can be omitted, in my opinion. Seeing >>> buttons, users will know that they need to pick one. What they _do_ need >>> is text that is relevant to their situation. >>> >>> (I question the tutorial's advice to delete the lock files manually. >>> David Cousens reports: >>>> My experience on Linux is that when you select Open >>>> Anyway, the previous .LNK and .LCK files will be deleted and new ones >>>> created which should then be deleted when GNucash is closed properly. >>> The same happens for me in Windows. Is there any OS where this desirable >>> behavior doesn't happen? If there is, the tutorial's advice should >>> mention those specific systems, or at least it should say that in >>> Windows and Linux GC will do this automatically when you reopen a data >>> file after the "could not obtain the lock" message.) >>> >>> -- >>> Regards, >>> Stan Brown >>> Tompkins County, New York, USA >>> https://BrownMath.com >>> http://OakRoadSystems.com >>> >>> >>> On 2019-11-16 20:27, David Cousens wrote: >>>> Kay >>>> >>>> If GnuCash is not closed properly,e.g. a crash the .LNK and .LCK files >>>> created in your data directory prevent you from opening GnuCash. >> Section >>>> 2.5.3 of the Tutorial guide covers them. >>>> >>>> .LCK file extensions. My experience on Linux is t
Re: [GNC] gnucash 3.7.1 does not start on Macos 10.13.6
That's not GnuCash 3.7, it's a Gtk2 version. Not only that but it seems to have Guile 1.7, which would put it into the 2.4 series -- except that I never used Guile 1.7: https://github.com/Gnucash/gnucash-on-osx/commit/1e63de2b73189b38060068f030ca7977c9967394 shows upgrading from Guile-1.6 to Guile 1.8.8. The crash is due to a libpng mismatch in MacOS 10.13 and later, and was fixed somewhere in the middle of the 2.6 series. If you don't want to upgrade to 3.x 2.6.21 should work. Regards, John Ralls > On Nov 16, 2019, at 3:27 PM, George Michalopoulos wrote: > > first part of the log file in console: > > Process: Gnucash-bin [22377] > Path: /Applications/Gnucash.app/Contents/MacOS/Gnucash > Identifier:org.gnucash.Gnucash > Version: ??? > Code Type: X86 (Native) > Parent Process:??? [1] > Responsible: Gnucash-bin [22377] > User ID: 502 > > Date/Time: 2019-11-07 17:35:57.554 +0200 > OS Version:Mac OS X 10.13.6 (17G7024) > Report Version:12 > Anonymous UUID:0362B72E-BF2A-9A23-9582-53F3EF0AAEA5 > > > Time Awake Since Boot: 48 seconds > > System Integrity Protection: enabled > > Crashed Thread:0 > > Exception Type:EXC_CRASH (SIGABRT) > Exception Codes: 0x, 0x > Exception Note:EXC_CORPSE_NOTIFY > > Termination Reason:DYLD, [0x4] Symbol missing > > Application Specific Information: > dyld: launch, loading dependent libraries > DYLD_FRAMEWORK_PATH=/Applications/Gnucash.app/Contents/Frameworks > DYLD_LIBRARY_PATH=/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash::/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/:/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash > > Dyld Error Message: > Symbol not found: _inflateValidate > Referenced from: > /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib > Expected in: /Applications/Gnucash.app/Contents/Resources/lib/libz.1.dylib > in > /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib > > On Sat, Nov 16, 2019 at 5:09 PM John Ralls wrote: > "Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind > handler." Indicates that Guile's stack has run out of space. That might be a > locale problem, what happens if you set the computer language to Greek so > that it matches your region settings? > > Are there any crash reports (open /Applications/Utilities/Console and select > User Reports in the sidebar and look in the list for reports beginning with > Gnucash)? > > Is anything written to the trace file > (https://wiki.gnucash.org/wiki/Tracefile)? > > > > > On Nov 16, 2019, at 6:40 AM, George Michalopoulos wrote: > > > > i had to run it 1,5-2 years.. > > > > should i try an older version ? > > > > > > On Sat, Nov 16, 2019 at 4:23 PM David Carlson > > wrote: > > > >> Release 3.7.1 has only been around for several. Weeks. Is this the first > >> time for you to start Gnucash after updating? > >> > >> If so, which version did you have before? > >> > >> David Carlson > >> > >> On Sat, Nov 16, 2019, 6:58 AM George Michalopoulos > >> wrote: > >> > >>> i made all the things you say, no good.. > >>> > >>> This is what i see on terminal.. > >>> > >>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.538: > >>> [mac_find_close_country()] Apple Locale is set to a value en_GR not > >>> supported by the C runtime > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.539: > >>> [mac_find_close_country()] Using el_GR instead. > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.540: [mac_set_languages()] > >>> Language list: en:el:en:C > >>> (process:1839): Gtk-WARNING **: 14:52:58.541: Locale not supported by C > >>> library. > >>> Using the fallback 'C' locale. > >>> Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind > >>> handler. > >>> > >>> > >>> On Sat, Nov 16, 2019 at 2:49 PM Adrien Monteleone < > >>> adrien.montele...@lusfiber.net> wrote: > >>> >
Re: [GNC] gnucash 3.7.1 does not start on Macos 10.13.6
"Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind handler." Indicates that Guile's stack has run out of space. That might be a locale problem, what happens if you set the computer language to Greek so that it matches your region settings? Are there any crash reports (open /Applications/Utilities/Console and select User Reports in the sidebar and look in the list for reports beginning with Gnucash)? Is anything written to the trace file (https://wiki.gnucash.org/wiki/Tracefile)? > On Nov 16, 2019, at 6:40 AM, George Michalopoulos wrote: > > i had to run it 1,5-2 years.. > > should i try an older version ? > > > On Sat, Nov 16, 2019 at 4:23 PM David Carlson > wrote: > >> Release 3.7.1 has only been around for several. Weeks. Is this the first >> time for you to start Gnucash after updating? >> >> If so, which version did you have before? >> >> David Carlson >> >> On Sat, Nov 16, 2019, 6:58 AM George Michalopoulos >> wrote: >> >>> i made all the things you say, no good.. >>> >>> This is what i see on terminal.. >>> >>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash >>> (process:1839): gnc.gui-WARNING **: 14:52:58.538: >>> [mac_find_close_country()] Apple Locale is set to a value en_GR not >>> supported by the C runtime >>> (process:1839): gnc.gui-WARNING **: 14:52:58.539: >>> [mac_find_close_country()] Using el_GR instead. >>> (process:1839): gnc.gui-WARNING **: 14:52:58.540: [mac_set_languages()] >>> Language list: en:el:en:C >>> (process:1839): Gtk-WARNING **: 14:52:58.541: Locale not supported by C >>> library. >>> Using the fallback 'C' locale. >>> Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind >>> handler. >>> >>> >>> On Sat, Nov 16, 2019 at 2:49 PM Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> If you’re getting the GnuCash splash screen then it is starting, but >>> then either being hidden, or crashing. I’ll presume: That you’ve checked *all* workspaces for the window? That you’ve right-clicked the icon in the dock and tried the ’Show all Windows’ entry? (as well as maybe assigned it to ’this’ desktop or ‘all desktops’) That the right-click menu of the GnuCash icon in your dock does *not* >>> have a ’show’ entry near the bottom, but instead says ‘hide’ (meaning the >>> window is *not* hidden in this case, it is a toggle) That a command-tab does not show an icon for GnuCash? That GnuCash.app is not listed in ActivityMonitor.app after the splash screen goes away? That a MacOS crash report is also not appearing on the screen after the splash screen disappears? You’ve tried running with just a single display plugged in? If all of the above is true, then try running from a terminal.app >>> window: /Applications/Gnucash.app/Contents/MacOS/Gnucash Which might output some helpful stuff to the terminal window. Also, check the wiki about how to find the TraceFile on Mac and report both back here. If however, GnuCash.app is not properly installed in /Applications or ~/Applications as it always has been or that you haven't verified with Gatekeeper that you want to open the app by *first* right-clicking it >>> and confirming this (only needed after each fresh install of GnuCash) then >>> you shouldn’t even be seeing the splash screen. Regards, Adrien > On Nov 16, 2019 w46d320, at 6:32 AM, George Michalopoulos < metr...@gmail.com> wrote: > > hello all, > > the subject is self-explanatory... > gnucash 3.7.1 does not start on Macos 10.13.6 > I was using it for 2-3 years, i tried to open it today, but it does >>> not > start. > updated gnucash, nothing. > installed latest python, nothing. > added the app to the dock, nothing.. > i can see the splash screen, but up to there. > i have 2 displays, tried to mirror them, nothing.. > > anyone with a new idea ? :) ___ 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. >>> >>> >>> -- >>> >>> regards, >>> George Michalopoulos >>> >>> born & raise @ Metron 6 (six) >>> >>> metr...@gmail.com >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/ma
Re: [GNC] Schedule Transaction Shows Entered but is not?
You may need to close and reopen the register in question if it was open when you ran the SLR. There was a bug about that recently, (supposedly) fixed for 3.7 IIRC. Regards, John Ralls > On Nov 15, 2019, at 3:45 PM, Jack Slater wrote: > > I only have 1 monitor. > > On Fri, Nov 15, 2019 at 5:44 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Jack, >> >> Check out the other list thread titled: Problem with reconciling >> >> A user there offered that a multi-monitor setup might be at play with a >> suggestion on how to fix it. >> >> Regards, >> Adrien >> >> >>> On Nov 15, 2019 w46d319, at 4:48 PM, Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >>> >>> I would also check that the accounts for each split in the template are >> current actual accounts and that none of them have been renamed, >> refactored(moved in the account tree) or deleted. In such cases, GnuCash >> *might* silently fail to execute it rather than provide an error message. >> (which I would consider a bug) >>> >>> You could also try editing the template and reassigning the accounts on >> each split just for safe measure. >>> >>> Another thing to consider is if your splits in the template contain >> variables or formulas and there is a problem there, it also might fail to >> trigger. >>> >>> Regards, >>> Adrien >>> >>>> On Nov 15, 2019 w46d319, at 4:37 PM, Colin Law >> wrote: >>>> >>>> On Fri, 15 Nov 2019 at 22:35, Jack Slater >> wrote: >>>>> >>>>> That is correct. Shows Last occurrence 11/08/2019 but does not exist >> in ledger. >>>> >>>> Have you checked in the expense accounts too, or whatever is on the >>>> other side of the transaction? >>>> >>>> I presume there is not a confusion about whether 11/8 is 11th August >>>> or 8th November. >>>> >>>> Colin >>>> >>> >> >> >> ___ >> 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] Error noted
Probably not, because it's more than likely a field that isn't required to be filled, like reconcile date. You could search for "trn:date-posted" (if you use grep to do so you'll want to use `-A 1` to also get the following line) and see that all of those dates are sane... but if you have more than a few transactions that will be at best tedious. Regards, John Ralls > On Nov 15, 2019, at 9:03 AM, Rick Mobley wrote: > > Can I tell what is missing by viewing the XML data file? > > Is this anything of concern? > > Rick > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: Friday, November 15, 2019 10:31 AM > To: Rick Mobley > Cc: gnucash-user > Subject: Re: [GNC] Error noted > > > >> On Nov 15, 2019, at 8:10 AM, Rick Mobley wrote: >> >> I'm not seeing an on-screen error, but today I found these "Trace" log >> files in my temp directory today. Gnucash.trace.RNFVA0.log, etc. >> >> >> >> Is this a concern? Should I post as a bug report? >> >> >> >> Running GNuCash v3.6 on a Windows 10 PC. >> >> >> >> >> >> * 13:50:52 WARN Could not spawn perl: Failed to >> execute child process (Bad file descriptor) >> >> * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:51:17 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed >> >> * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const >> char*, >> time64): assertion 'time != INT64_MAX' failed > > The first one is routine and just means that you're not using Finance::Quote > to retrieve stock prices or currency exchange rates. > > The others indicate an attempt to write an invalid time stamp into the data > file--we use INT64_MAX as the not a time/unknown time value--and that's > probably just an indication that some date field is empty. > > 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] Error noted
> On Nov 15, 2019, at 8:10 AM, Rick Mobley wrote: > > I'm not seeing an on-screen error, but today I found these "Trace" log files > in my temp directory today. Gnucash.trace.RNFVA0.log, etc. > > > > Is this a concern? Should I post as a bug report? > > > > Running GNuCash v3.6 on a Windows 10 PC. > > > > > > * 13:50:52 WARN Could not spawn perl: Failed to execute > child process (Bad file descriptor) > > * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:51:16 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:51:17 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed > > * 13:53:35 ERROR xmlNode* time64_to_dom_tree(const char*, > time64): assertion 'time != INT64_MAX' failed The first one is routine and just means that you're not using Finance::Quote to retrieve stock prices or currency exchange rates. The others indicate an attempt to write an invalid time stamp into the data file--we use INT64_MAX as the not a time/unknown time value--and that's probably just an indication that some date field is empty. 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 Associations
Adrien, No, it's about associating external files, perhaps images of receipts or of cleared checks, with transactions. I don't know that code well. Bob Fewell wrote it, perhaps he can answer. Regards, John Ralls > On Nov 15, 2019, at 6:45 AM, Adrien Monteleone > wrote: > > My understanding of this function is for use with the importer. If you > haven’t imported anything, it will be blank as there are no assigned > associations yet. > > Regards, > Adrien > >> On Nov 9, 2019 w45d313, at 9:56 PM, Joseph G Keithley III via gnucash-user >> wrote: >> >> Hi, >> >>I want to edit my existing transaction associations but when I select it >> from the tools menu I get essentially a blank page. How do I get it to >> populate with my transaction associations? >> >> iii > > ___ > 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] Will the reports file "saved-reports-2.8" recreate itself if deleted or moved?
Right. > On Nov 12, 2019, at 2:38 AM, Fran_3 wrote: > > To be clear on your answer to question 1... > > If I delete or move the file "saved-reports-2.8" gnuCash will recreate it > WHEN I create a new report and save the report configuration... right? > > Thanks for the help John. > > Fran3 > > > > On Monday, November 11, 2019, 10:58:29 PM EST, John Ralls > wrote: > > > > > > On Nov 11, 2019, at 1:11 PM, Fran_3 via gnucash-user > > wrote: > > > > I have about 40 reports I created for this project and I would like to > > keep them for future reference. > > BUT that many reports clutter up the view when retrieving saved report > > configurations... > > I may not reference these particular reports for a year so I would like to > > stash them... that is stash their definitions/configuration file > > "saved-report-2.8" in another folder until I need those particular reports > > again. > > > > > > Question 1: If I move the reports config file saved-report-2.8 to a backup > > folder for future use and then delete it from its normal folder at > > C:\Users\User-X\AppData\Roaming\GnuCash > > Will gnuCash recreate a new "saved-report-2.8" file when I re-launch the > > gnuCash App? > > > > Question 2: If months down the road I need to recover the saved-report-2.8 > > file that I stashed elsewhere... > > Can I swap the current saved-report-2.8 file with the one I stashed... and > > visa-versa as needed? > > > > Question 3: I made a simple Transaction Report named Test that only looked > > at the checking account. Then I made a copy of saved-report-2.8 and looked > > at it with NotePad++. > > > > The text in the file, I assume, consist of instructions used by gnuCash to > > create the report... > > > > meaning the contents of saved-report-2.8 is not a language to query the > > gnuCash data... right? > > Thanks for any help. Fran3 > > > > > 1. No, unless you create new saved report configs. > 2. Yes. Just make sure to shut down GnuCash while you're switching the files. > 3. The current version of the file contains the report names and a Scheme > (that's a computer programming language) representation of the options you > changed from the default values to create the custom report. You are correct > that it does not contain queries. Most GnuCash reports work by iterating over > the accounting objects in memory rather than using the query framework. > > 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] Will the reports file "saved-reports-2.8" recreate itself if deleted or moved?
> On Nov 11, 2019, at 1:11 PM, Fran_3 via gnucash-user > wrote: > > I have about 40 reports I created for this project and I would like to keep > them for future reference. > BUT that many reports clutter up the view when retrieving saved report > configurations... > I may not reference these particular reports for a year so I would like to > stash them... that is stash their definitions/configuration file > "saved-report-2.8" in another folder until I need those particular reports > again. > > > Question 1: If I move the reports config file saved-report-2.8 to a backup > folder for future use and then delete it from its normal folder at > C:\Users\User-X\AppData\Roaming\GnuCash > Will gnuCash recreate a new "saved-report-2.8" file when I re-launch the > gnuCash App? > > Question 2: If months down the road I need to recover the saved-report-2.8 > file that I stashed elsewhere... > Can I swap the current saved-report-2.8 file with the one I stashed... and > visa-versa as needed? > > Question 3: I made a simple Transaction Report named Test that only looked at > the checking account. Then I made a copy of saved-report-2.8 and looked at it > with NotePad++. > > The text in the file, I assume, consist of instructions used by gnuCash to > create the report... > > meaning the contents of saved-report-2.8 is not a language to query the > gnuCash data... right? > Thanks for any help. Fran3 > 1. No, unless you create new saved report configs. 2. Yes. Just make sure to shut down GnuCash while you're switching the files. 3. The current version of the file contains the report names and a Scheme (that's a computer programming language) representation of the options you changed from the default values to create the custom report. You are correct that it does not contain queries. Most GnuCash reports work by iterating over the accounting objects in memory rather than using the query framework. 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] How to create Report on Checking & Exclude one Entity ?
Adrien, Ah, negative lookahead. Nice trick, but GnuCash's Find dialog rejects it with a bogus error about an invalid repetition symbol, even when there isn't one: ^(?!Open). raises the error. The PCRE docs say it's supported: http://www.pcre.org/current/doc/html/pcre2syntax.html#SEC19. Lookahead/lookbehind aren't supported in libc's regex. Regards, John Ralls > On Nov 11, 2019, at 6:40 AM, Adrien Monteleone > wrote: > > John, > > I don’t know of any in particular, and I couldn’t seem to find such info. I > found some examples online of doing such a search with the following basic > form: > > ^((?!badword).)*$ > > It is a negative look-around, not an actual negative search. > > I tried it in GnuCash to no avail. I haven’t tested it otherwise to know if > it works at all, but I’d think something implements it somewhere since there > were several hits offering similar advice to such questions. > > Regards, > Adrien > > >> On Nov 10, 2019 w46d314, at 6:06 PM, John Ralls wrote: >> >> Adrien, >> >> What regex implementation do you know of that has negating patterns? None of >> the ones I know do. >> >> The Transaction report uses Guile regex which just wraps whatever >> libc/msvcrt was used to compile it, generally POSIX Enhanced. It doesn't >> support negating patterns and doesn't have an option to find transactions >> that don't match the provided pattern. IIRC libc regexes also don't support >> UTF8 character classes though they'll match explicit UTF8 characters of the >> same normalization just because the bytes are the same. >> >> The find dialog uses glib pcre (perl-compatible regular expressions) which >> are considerably more powerful than POSIX ones but also don't have negating >> patterns. However the Find dialog has a "doesn't match" setting. Other bits >> of GnuCash use boost::regexes, which understands perl regex syntax. We don't >> use the C++ standard library because it doesn't support UTF8. >> >> 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] How to create Report on Checking & Exclude one Entity ?
Adrien, What regex implementation do you know of that has negating patterns? None of the ones I know do. The Transaction report uses Guile regex which just wraps whatever libc/msvcrt was used to compile it, generally POSIX Enhanced. It doesn't support negating patterns and doesn't have an option to find transactions that don't match the provided pattern. IIRC libc regexes also don't support UTF8 character classes though they'll match explicit UTF8 characters of the same normalization just because the bytes are the same. The find dialog uses glib pcre (perl-compatible regular expressions) which are considerably more powerful than POSIX ones but also don't have negating patterns. However the Find dialog has a "doesn't match" setting. Other bits of GnuCash use boost::regexes, which understands perl regex syntax. We don't use the C++ standard library because it doesn't support UTF8. Regards, John Ralls > On Nov 10, 2019, at 3:36 PM, Adrien Monteleone > wrote: > > You have two options, but both require a negative regex, which while > possible, might not be part of the regex library used by GnuCash. (I don’t > know, you’d have to try it out) > > #1 - Transaction Report (as requested) with regex *not matching* a string in > the Filter field. (it will return transactions that do not match that string > in the Description, but also the Notes & Memo, which may or may not, be okay.) > > #2 - Find, followed by Account Report - same regex expression, but with the > ability to *only* filter on the Description and not also the Notes and Memo > fields. > > Which you use is up to you, or which one actually works at all. (if either) > > Please do let us know if you manage this as I’m sure others would be > interested. > > Regards, > Adrien > >> On Nov 10, 2019 w46d314, at 9:21 AM, Fran_3 via gnucash-user >> wrote: >> >> I guess I suffering from project fatigue on this exercise as, all of a >> sudden, I cant run a Transaction Report on Checking and then exclude all >> transactions to a particular entity... Vendor X >> I thought I had done this before but... maybe not. >> >> Without grinding through all the attempts I've made this morning would some >> kind soul just tell me how to do this... >> And note... the entity name has two words in it... "Vendor X" in this >> example... both of which are necessary for unique identification. >> Thanks for any help. Fran3 > > ___ > 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] Program Crash using Schedule Transaction Editor
> On Nov 10, 2019, at 3:05 AM, Nigel Stapley wrote: > > Hi > > I am using Build ID: 3.7+(2019-09-07) on Linux Mint 19.2. > > When I use the schedule transaction editor on an existing transaction > template and hit the "Do you want to change this transaction?" the program > crashes. Having used GC for many years without any problem I'm not sure > where to look for info on what happened. > > Any help appreciated. Please open a bug (https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones) and attach a stack trace (https://wiki.gnucash.org/wiki/Stack_Trace). 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] Website Down
Fran, Our Beloved Founder, Linas Vepstas, hosts the website server. IIUC it's a dedicated box, more for his convenience than because of the website's traffic load. Regards, John Ralls > On Nov 9, 2019, at 10:54 AM, Fran_3 wrote: > > John, > Just wondering who host the website? > Also, is it a shared server or is the traffic so intense that it takes a > dedicated server? > Thanks, Fran3 > > > > On Saturday, November 9, 2019, 1:34:02 PM EST, John Ralls > wrote: > > > > > > On Nov 9, 2019, at 9:52 AM, Derek Atkins wrote: > > > > > > On Sat, November 9, 2019 12:45 pm, John Ralls wrote: > >> > >> Liz, > >> > >> Because there are two separate hosts involved. The website lives at > >> https://www.gnucash.org, 67.198.37.17. It's currently down with a failed > >> power supply. Everything else (including the mailing lists) is on > >> https://code.gnucash.org, 204.107.200.6, and its various aliases > > > > It is actually .65, not .6. :) > > > >> (lists.gnucash.org, wiki.gnucash.org, etc.). If the mailing lists are > >> working so is the wiki. > > > > We've been trying to figure out a way to get HA for www.gnucash.org. We > > just haven't quite figured out the right technology. Maybe this is the > > time to think about it? > > If we want to go HA I'd think code would be a better candidate, it's far more > important to day-to-day operation than www, but we might as well do both if > we're going to the effort. > > > 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] Website Down
> On Nov 9, 2019, at 9:52 AM, Derek Atkins wrote: > > > On Sat, November 9, 2019 12:45 pm, John Ralls wrote: >> >> Liz, >> >> Because there are two separate hosts involved. The website lives at >> https://www.gnucash.org, 67.198.37.17. It's currently down with a failed >> power supply. Everything else (including the mailing lists) is on >> https://code.gnucash.org, 204.107.200.6, and its various aliases > > It is actually .65, not .6. :) > >> (lists.gnucash.org, wiki.gnucash.org, etc.). If the mailing lists are >> working so is the wiki. > > We've been trying to figure out a way to get HA for www.gnucash.org. We > just haven't quite figured out the right technology. Maybe this is the > time to think about it? If we want to go HA I'd think code would be a better candidate, it's far more important to day-to-day operation than www, but we might as well do both if we're going to the effort. 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] Any information as to when the gnucash.org will be back up?
> On Nov 8, 2019, at 9:04 AM, Richard Danielson wrote: > > Gnucash.org is down. Is there any information as to when it will be back up. > Thanks. https://www.gnucash.org is down with a failed power supply. The replacement is expected on Tuesday (but that's already a slip from last Friday). The rest of gnucash.org is on a different server and is up. What are you looking for on www.gnucash.org? Most everything there has an alternative location. 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] Website Down
> On Nov 8, 2019, at 9:16 PM, Liz wrote: > > On Sat, 9 Nov 2019 04:24:53 +0100 > "Frank H. Ellenberger" wrote: > >> Hello Dean, >> >> Am Sa., 9. Nov. 2019 um 04:07 Uhr schrieb Dean Bradley >> : >>> >>> OK, thanks. Unfortunately, this multi-day outage does not give a >>> warm and fuzzy to the new potential convert from Quicken to GnuCash >>> (me). >>> >>> Regards, >>> ~dean~ >> >> you could start reading the wiki: >> https://wiki.gnucash.org/wiki/GnuCash >> While it does not cover all aspects, the infos there are often more >> recent than the content of the website. >> >> Regard >> Frank > > I'm not sure how Dean could read the wiki on gnucash.org with > gnucash.org down. > However > https://web.archive.org/web/*/https://wiki.gnucash.org/wiki/GnuCash > last did a snapshot on 22nd September and the information may be there. Liz, Because there are two separate hosts involved. The website lives at https://www.gnucash.org, 67.198.37.17. It's currently down with a failed power supply. Everything else (including the mailing lists) is on https://code.gnucash.org, 204.107.200.6, and its various aliases (lists.gnucash.org, wiki.gnucash.org, etc.). If the mailing lists are working so is the wiki. 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] Website Down
You're mistaken. The Tutorial and Concepts Guide is available via the Help menu. Linux users may need to install a gnucash-docs package to install it; the Mac and Windows bundles have it built in. You can also access the nightly documentation builds at https://code.gnucash.org/docs/C/gnucash-guide/. Regards, John Ralls > On Nov 8, 2019, at 7:45 PM, Dean Bradley wrote: > > Frank, > Thanks for that link. However, I am at the point of setting up my > investments, and had created the brokerage account and was just getting > started on setting up the security accounts. For this purpose I was using > chapter 9 in the online documentation on this subject. From what I can tell, > the documentation bundled with the software does not cover this subject to > the level of detail found at > https://www.gnucash.org/docs/v3/C/gnucash-guide/. But I will be patient. > > Regards, > ~dean~ > > >> On November 8, 2019 at 10:24 PM "Frank H. Ellenberger" >> wrote: >> >> >> Hello Dean, >> >> Am Sa., 9. Nov. 2019 um 04:07 Uhr schrieb Dean Bradley >> : >>> >>> OK, thanks. Unfortunately, this multi-day outage does not give a warm and >>> fuzzy to the new potential convert from Quicken to GnuCash (me). >>> >>> Regards, >>> ~dean~ >> >> you could start reading the wiki: >> https://wiki.gnucash.org/wiki/GnuCash >> While it does not cover all aspects, the infos there are often more >> recent than the content of the website. >> >> Regard >> Frank > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ 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] Website Down
Yeah, the replacement power supply that was supposed to show up today didn't. Linas said on IRC today that it will likely be 3 more days. Regards, John Ralls > On Nov 8, 2019, at 4:50 PM, Dean Bradley wrote: > > Is the site still down? I cannot access it, so I'm guessing it is. Is there > an updated ETA? > > Regards, > ~dean~ > >> On November 5, 2019 at 11:53 AM John Ralls wrote: >> >> >> Linas reports that https://www.gnucash.org is down with a hardware failure. >> He'll try to get it working on a secondary server today; failing that the >> replacement hardware is due in a day or three. >> >> 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] Find dialog not working
That's https://bugs.gnucash.org/show_bug.cgi?id=797460 Regards, John Ralls > On Nov 6, 2019, at 7:05 AM, mcmurchy1917techy via gnucash-user > wrote: > > If it helps > >> git bisect log >> git bisect start >> # good: [d42695e75a5b8865331694c9490c7446af7ebcc3] Release GnuCash 3.6 >> git bisect good d42695e75a5b8865331694c9490c7446af7ebcc3 >> # bad: [84cfc5743bc31160e338e6cb7c734548d9ef92a4] Release GnuCash 3.7 >> git bisect bad 84cfc5743bc31160e338e6cb7c734548d9ef92a4 >> # good: [112cf99d2d0c7a68c71d9085ad911eba93337d9a] [test-report-html] add >> coverage and function test >> git bisect good 112cf99d2d0c7a68c71d9085ad911eba93337d9a >> # good: [112cf99d2d0c7a68c71d9085ad911eba93337d9a] [test-report-html] add >> coverage and function test >> git bisect good 112cf99d2d0c7a68c71d9085ad911eba93337d9a >> # good: [6b0bfa075ca5c964e4b2df775b228271b2ecf378] [register] fix Transfer >> acc for single-account splits >> git bisect good 6b0bfa075ca5c964e4b2df775b228271b2ecf378 >> # good: [6b0bfa075ca5c964e4b2df775b228271b2ecf378] [register] fix Transfer >> acc for single-account splits >> git bisect good 6b0bfa075ca5c964e4b2df775b228271b2ecf378 >> # bad: [16a69e2a63f462346f498918eee738e5443bea58] I18n fix: Trim >> user-visible strings from unneeded whitespace. >> git bisect bad 16a69e2a63f462346f498918eee738e5443bea58 >> # good: [f00777ca07f5ca6f7e2bc5443823e02c8fa8c7c2] Add scm-srfi64-extras and >> scm-qif-import as check dependencies >> git bisect good f00777ca07f5ca6f7e2bc5443823e02c8fa8c7c2 >> # good: [bb4348fce97668af5de08e0a38867437d7e7f81f] Bug 797378 - QIF file >> import fails: Loading gives wrong type argument in position 2 >> git bisect good bb4348fce97668af5de08e0a38867437d7e7f81f >> # bad: [ef3157db19e5ebee4c669da03757ed5ec8fe8321] [budget] rename envelope >> option to 'Use accumulated amounts' >> git bisect bad ef3157db19e5ebee4c669da03757ed5ec8fe8321 >> # bad: [fa6948a2bee6ba8e59ba487097590ff2ce782588] [dialog-search] >> expand&fill search results >> git bisect bad fa6948a2bee6ba8e59ba487097590ff2ce782588 >> # bad: [e3ba73683e3c6ccfa84a63c6d0a5e648856412dc] Fix file copy destination >> for accounts/he >> git bisect bad e3ba73683e3c6ccfa84a63c6d0a5e648856412dc >> # first bad commit: [e3ba73683e3c6ccfa84a63c6d0a5e648856412dc] Fix file copy >> destination for accounts/he > > > > On 06/11/2019 14:50, mcmurchy1917techy via gnucash-user wrote: >> I've got a problem with the Edit -> Find dialog in 3.7. >> >> I can't see the drop down menus for the search criteria namely Description, >> Contains or the search text box. It looks like the they'll all been squashed >> vertically within their group box. >> >> I'm using Slackware 14.2 with KDE4. >> >> I've backed out 3.7 and reinstalled 3.6 and the Find dialog works as >> expected. >> >> Alex >> >> >> >> ___ >> 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] memory issue on a custom report.
> On Nov 5, 2019, at 2:21 PM, Steven Bruniges wrote: > > GNUCASH is crashing - leaving the following error in the trace file, without > any backtrace information. > > > > OTHER ../lib-2.60.6/glib/gmem.c: failed to allocate 65536 bytes. > > > > googling this suggests its caused by a routine that extends arrays hitting a > 32bit limit. > > > > Any thoughts? That you're running out of memory? You won't get a backtrace in the trace file, and only MacOS makes them automatically. Do a build with -DCMAKE_BUILD_TYPE=Debug so that you get symbols and then run under gdb to get a stack trace. Detailed instructions are at https://wiki.gnucash.org/wiki/Stack_Trace. 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] MAC Catalina Issue-Will Not Launch
> On Nov 5, 2019, at 1:59 PM, John Donnee wrote: > > Hi I just installed the newest iMac OS Catalina and my GNU will not launch. > > I deleted icon from desktop and relaunched from Applications and it still > will not launch. > > There was a message that it needed a link to a binary and asked for my Mac > ID. I typed it in and it still did not work. > > Any suggestions as how to repair, etc. > > Love the program. Been using for eight years. If you don't have 3.7 start with that. It's signed the "new" way for Catalina; older releases aren't. If you already have 3.7 or you get it and it still won't launch, try launching from Terminal to see if it reports any errors 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.
[GNC] Website Down
Linas reports that https://www.gnucash.org is down with a hardware failure. He'll try to get it working on a secondary server today; failing that the replacement hardware is due in a day or three. 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 3.7 via homebrew not launching on macOS 10.14.6
> On Nov 5, 2019, at 4:34 AM, SeanDeNigris wrote: > > Gnucash 3.7 on macOS 10.14.6 via homebrew wouldn’t launch via double clicking > on the app. I would get the dialog that I was downloading an app from the > internet, click okay, but the GUI wouldn't appear and Gnucash did not appear > in the activity monitor. Running the executable directly via Terminal seemed > to work fine. The trace file was blank. > > Here's the weird part, downloading directly from GH works normally. That's > odd because the cask seems to just download from GH. > > My problem is solved but just posting here in case it helps anyone else... > It's actually pretty common that GnuCash fails to launch after Gatekeeper verification. Just double-click the icon again and it starts right up. BTW, Homebrew is a bit deceptive about their GnuCash "recipe": It doesn't install GnuCash in the Homebrew environment or even use any other part of Homebrew, it just downloads one of our DMGs. 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] Account for contracted grain sales?
> On Nov 4, 2019, at 4:22 AM, Nate Bargmann wrote: > > I am just getting started with GnuCash (should have done so long ago...) > and my main occupation these days is farming. I've been using a simple > cash accounting system all of these years and I am able to configure my > accounting in GnuCash to get an even more realistic view of my finances > as time goes on. Thank you! In the future, i.e. next year, I will be > taking on the role of treasurer for our church which is the principal > reason I started with my personal finances so as to gain familiarity > with GnuCash. > > One thing I have done for years is enter into a deferred payment > contract with the cooperative that buys my grain. In general the grain > is sold as of a given date with payment at some future specified date. > In my case I generally defer payment until the beginning of the coming > calendar year. What this represents, at least to me, is a transfer of > the title of my asset (grain) to the cooperative immediately and then > sometime in the future a payment from the cooperative for my asset. > > Other than my copies of the contract(s), I've not tracked this in any > way, which I would now like to do. At first I thought of structuring > this as an Account Receivable but skimming through that section of the > manual, it doesn't look like quite the right fit. As I see it, I have a > sort of promissory note that doesn't pay interest, if that makes any > sense, that in early January will be paid by the cooperative. It is > future income but I don't want it listed as such until next year. > > Of course, I could always let it ride until the funds are deposited in a > couple of months. How you handle this depends on two things: The tax consequences and whether anyone else looks at your books. If you're not taxed on the sale of the grain until the following year and your books are likely to be audited or used in a friendly discussion with the tax man--a situation consistent with "cash accounting"--then you don't want to recognize the transfer until you actually get paid. In that case just credit income:sales and debit your bank account. If you owe the tax when the grain is transferred or you have other ways of presenting your records in a tax audit then you can just create two accounts: Assets:Sold Grain and Income:Grain Sales. When you deliver the grain to the coop you debit Assets:Sold Grain and credit Income:Grain Sales. When you get paid the following January you credit Assets:Sold Grain and debit your bank 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] Scheduled Transaction Calculations
> On Nov 2, 2019, at 7:08 AM, Fred Bone wrote: > > On 01 November 2019 at 12:34, John Ralls said: > > [...] >> You could try adding this to fin.scm: >> >> (load-from-path "gnucash/app-utils") >> (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month) >> (gnc:get-start-prev-month 86400)) > > This will produce a non-integer result if > (a) prev month includes daylight-saving-time shift > or > (b) prev month includes a leap second. > > (While I'm not familiar with Scheme, if the potential non-integer result > isn't an issue -- i.e. if it gets auto-rounded to nearest integer -- then > there was no point in adding the odd second). > Time in GnuCash is UTC internally so there are no daylight-time changes. A leap second might be an issue, though a rather rare one. See https://www.gnu.org/software/guile/manual/html_node/Exactness.html. Without adding the second back in the result of the division for October was 2678399/86400. One could instead use (round (/ (- (gnc:get-end-prev-month) (gnc:get-start-prev-month 86400)) which would resolve the leap-second problem. 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] Scheduled Transaction Calculations
Glad (and a little surprised) that it worked. The naming problem makes sense in retrospect. It's standard for scheme but the expression parser has to deal with normal arithmetic notation so it would see the hyphens as minus signs and each fragment (days, in, prev, and month) as separate tokens. I'm at a loss about the load-from-path issue, though I know that it's fiddly. Regards, John Ralls > On Nov 1, 2019, at 4:35 PM, Fross, Michael wrote: > > Hi John, > > I got it to work, but one challenge remains. The load-from-path seems to > crash Gnucash. But copying the app-utils.scm to the fin.scm folder solves > the problem, but it's sloppy. > > I'll need to play around with it. > > Secondly, I it didn't like the name "days-in-prev-mon" But I shortened it > and took out the dashes and that seems ok. Here is what I inserted in > fin.scm: > > ;; Return number of days in the previous month > (load-from-path "C:\Program Files > (x86)\gnucash\share\gnucash\scm\gnucash\app-utils") > (define (gnc:numdayslastmon) >(/ > (+ 1 > (- (gnc:get-end-prev-month) (gnc:get-start-prev-month))) 86400) > ) > > > Thanks again for your help! > > Michael > > On Fri, Nov 1, 2019 at 3:25 PM Fross, Michael wrote: > Thanks John. I'll give is a shot and report back. > > Michael > > On Fri, Nov 1, 2019 at 2:34 PM John Ralls wrote: > > > > On Nov 1, 2019, at 9:36 AM, Fross, Michael wrote: > > > > Hello all, > > > > I have a scheduled transaction that I pay monthly which is a fixed amount > > per day. I'd love to be able to have is automatically entrer based on the > > number of days per month. I pay on the 1st (or the first business day > > after that) so basically I'd like to use the following formula: > > > > Amount = NumDaysInPreviousMonth * AmountPerDay > > > > I looked through the guide > > <https://wiki.gnucash.org/wiki/Scheduled_Transactions> and didn't see > > anything. It references fin.scm (link throws a 404 by the way) but I > > didn't see anything here that calculated the number of days in the previous > > month (but perhaps I missed it in the SCM code.) > > > > This seems like a simple use case, am I missing something? Perhaps I'll > > need to write a function in fin.scm that can return the number of days in a > > provided month. No idea how to use scheme, but I'm sure I can figure it > > out. > > > > Thoughts? > > I fixed the link. > > The closest functions in GnuCash would be gnc:get-start-prev-month and > gnc:get-end-prev-month. They return time64 so you'd divide the difference by > 86400 (the number of seconds in a day) after adding in 1 second to compensate > for gnc:get-start-prev-month's returning the first second of the month rather > than the last second of the month before. > > You could try adding this to fin.scm: > > (load-from-path "gnucash/app-utils") > (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month) > (gnc:get-start-prev-month 86400)) > > Then use > days-in-prev-month() * AmountPerDay > in your scheduled transaction. Replace "AmountPerDay" with the actual numeric > amount or the Since Last Run dialog will ask for the amount every month. > > I've never actually tried doing anything like that, but it might work. > > 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] Scheduled Transaction Calculations
> On Nov 1, 2019, at 9:36 AM, Fross, Michael wrote: > > Hello all, > > I have a scheduled transaction that I pay monthly which is a fixed amount > per day. I'd love to be able to have is automatically entrer based on the > number of days per month. I pay on the 1st (or the first business day > after that) so basically I'd like to use the following formula: > > Amount = NumDaysInPreviousMonth * AmountPerDay > > I looked through the guide > <https://wiki.gnucash.org/wiki/Scheduled_Transactions> and didn't see > anything. It references fin.scm (link throws a 404 by the way) but I > didn't see anything here that calculated the number of days in the previous > month (but perhaps I missed it in the SCM code.) > > This seems like a simple use case, am I missing something? Perhaps I'll > need to write a function in fin.scm that can return the number of days in a > provided month. No idea how to use scheme, but I'm sure I can figure it > out. > > Thoughts? I fixed the link. The closest functions in GnuCash would be gnc:get-start-prev-month and gnc:get-end-prev-month. They return time64 so you'd divide the difference by 86400 (the number of seconds in a day) after adding in 1 second to compensate for gnc:get-start-prev-month's returning the first second of the month rather than the last second of the month before. You could try adding this to fin.scm: (load-from-path "gnucash/app-utils") (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month) (gnc:get-start-prev-month 86400)) Then use days-in-prev-month() * AmountPerDay in your scheduled transaction. Replace "AmountPerDay" with the actual numeric amount or the Since Last Run dialog will ask for the amount every month. I've never actually tried doing anything like that, but it might work. 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] Recording invoice payment issue
> On Oct 28, 2019, at 5:10 PM, Tommy Trussell wrote:
>
> On Mon, Oct 28, 2019 at 7:01 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>>
>>
>>> On Oct 28, 2019 w44d301, at 5:39 PM, Rich Shepard <
>> rshep...@appl-ecosys.com> wrote:
>>>
>>> On Mon, 28 Oct 2019, Adrien Monteleone wrote:
>>>
>>>> With that find dialog up, can you position the mouse in the upper
>> portion
>>>> of the window (with the criteria) and scroll? I and others have noticed
>>>> this issue with the find dialog recently. I can scroll in mine.
>>>
>>> Adrien,
>>>
>>> If you're referring to the drop-down box there are only two choices ('all
>>> criterial are met' or 'any criteria are met') and I can scroll or click
>> on
>>> the arror to switch between the two. Neither allows me to enter
>> 'criteria'
>>> which would be the client's name.
>>
>> No, I’m referring to the ‘area’ of the window where the criteria are
>> supposed to be listed.
>>
>> In your screenshot you can only see the line with the ‘Add’ and ‘all
>> criteria are met’ buttons, but it appears there are a few pixels of the
>> line visible below that, which is where you enter the criteria. The other
>> recent thread shows that entire line with only multiple criteria becoming
>> an issue. But in your case, it looks like even the first set of criteria is
>> not visible.
>>
>> Perhaps try enlarging the entire dialog to see if more shows up. Or,
>> position the mouse cursor inside that general box and try to scroll. You
>> can also try selecting one of the buttons to give it focus, then using the
>> tab key one or more times to advance the focus and see if then the criteria
>> are visible.
>>>
>>> So we can't search for an outstanding A/R invoice now using that menu
>>> option, eh?
>>
>> It is a bug, already filed I believe. This looks like a regression where
>> someone was trying to fix another bug where the sizing of the two parts of
>> that window were not working correctly. It seems that fix either didn’t
>> work, or made more a mess.
>>
>> Regards,
>> Adrien
>>
>
> Same bug, different window? (Or maybe same window, called from a different
> place.)
> https://bugs.gnucash.org/show_bug.cgi?id=797460
Same window, called from a different place.
There's a fix already committed and it's on a glade file so Rich can try to fix
it himself:
Edit /usr/share/gnucash/gtkbuilder/dialog-search.glade and change the value in
line 305 (the expand property) to True. When you're done it will look like:
True
True
1
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] MacOS Catalina Gnucash 3.7 won't start
No AppleScript will affect a Gtk application's coordinates, Gtk manages the screen itself and gets each monitor's coordinates from Quartz Display Services. No matter, that's not the problem: The spindump says that GnuCash hasn't even started. It's hung in AppleSystemPolicy::waitForEvaluation. Unfortunately neither Google nor developer.apple.com have any information about what that means. Has the Gatekeeper dialog displayed on any of your attempts to start GnuCash? That's the one saying "Verifying Gnucash.app" with a progress bar. One thing to check is that you have "App Store and identified developers" selection on the General tab of System Preferences>Security & Privacy. I'd expect that you'd get a dialog box saying that GnuCash isn't from the App Store if you don't, but that's the area where it's having trouble. Another thing to try is on the Privacy tab: At the bottom of the list is "Developer Tools". I don't know if that't there because I have Xcode installed, but if you have it it offers the option to run software from Terminal that doesn't meet the system's security policy. I don't have it set on my system and don't have any trouble running GnuCash, but setting it on yours might produce some more information. Regards, John Ralls > On Oct 28, 2019, at 7:07 AM, Chris Martin wrote: > > Dear David and John, > Thanks for the suggestion. I do in fact regularly use multiple external > monitors. On the off chance that matters, I unplugged them all and went to > just my main laptop screen only. Repeated all my tests and gnucash is still > sleeping and unresponsive (with no windows). In case there were windows that > were hidden, I asked the finder to show all windows (reponse: no available > windows). On the off-chance that they just had coordinates that took them > offscreen I found an applescript that changes the coordinates of all windows > to put them within the main screen, still no joy. > Separately, I sent a message to John with the output of the spindump but > I won't flood the whole group by attaching that here. > > Thanks again, > Chris > > On Mon, Oct 28, 2019 at 5:18 AM David T. wrote: > > Chris, > > Any chance you have or had a second monitor on your system? > > On Mon, Oct 28, 2019 at 8:42, John Ralls > wrote: > Chris, > > Weird. With GnuCash (sort of) running, open /Applications/Utilities/Activity > Monitor. Find gnucash in the process list and select it. Click the gear icon > at the left end of the toolbar and pick "spindump" from the menu. It will > collect for a few seconds and then present a window with a bunch of stack > traces that may show what GnuCash is waiting for. > > Regards, > John Ralls > > > > On Oct 27, 2019, at 4:53 PM, Chris Martin wrote: > > > > Thanks Chris and John, > >I can confirm that in System Preferences->Security & > > Privacy->Privacy->Files and Folders Gnucash is shown as "Full Disk Access" > > as a result of me adding it to the Full Disk Access list earlier in my > > debugging. Out of curiosity, I removed it from the Full Disk Access list > > and it made no difference. > >After returning it to "Full Disk Access," I then added the "--nofile" > > option to ./Gnucash (and then again in addition to --debug and --extra) and > > Gnucash still just hangs with no stdout or stderr output and *without* > > generating a trace file. Running a ps seems to show that the process is > > just sleeping. > > > > 25294 s000 S+0:00.00 ./Gnucash --nofile > > > > I tried a kill -9 in addition to a kill -2 to get it to write a trace > > file, but no joy. > > > > > > -Chris > > > > On Sun, Oct 27, 2019 at 12:37 PM chris graves wrote: > > > >> Chris, > >> > >> Under System Preferences->Security & Privacy->Privacy->Files and Folders, > >> does Gnucash.app have access to the Documents Folder (or the folder where > >> your Gnucash data file lives? > >> > >> Also, try again running from the terminal and add the --nofile option > >> > >> Chris > >> > >> On Oct 27, 2019, at 12:17 PM, Chris Martin wrote: > >> > >> ./Gnucash --debug --extra > >> > >> > >> > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
Re: [GNC] MacOS Catalina Gnucash 3.7 won't start
Chris, Weird. With GnuCash (sort of) running, open /Applications/Utilities/Activity Monitor. Find gnucash in the process list and select it. Click the gear icon at the left end of the toolbar and pick "spindump" from the menu. It will collect for a few seconds and then present a window with a bunch of stack traces that may show what GnuCash is waiting for. Regards, John Ralls > On Oct 27, 2019, at 4:53 PM, Chris Martin wrote: > > Thanks Chris and John, > I can confirm that in System Preferences->Security & > Privacy->Privacy->Files and Folders Gnucash is shown as "Full Disk Access" > as a result of me adding it to the Full Disk Access list earlier in my > debugging. Out of curiosity, I removed it from the Full Disk Access list > and it made no difference. > After returning it to "Full Disk Access," I then added the "--nofile" > option to ./Gnucash (and then again in addition to --debug and --extra) and > Gnucash still just hangs with no stdout or stderr output and *without* > generating a trace file. Running a ps seems to show that the process is > just sleeping. > > 25294 s000 S+ 0:00.00 ./Gnucash --nofile > > I tried a kill -9 in addition to a kill -2 to get it to write a trace > file, but no joy. > > > -Chris > > On Sun, Oct 27, 2019 at 12:37 PM chris graves wrote: > >> Chris, >> >> Under System Preferences->Security & Privacy->Privacy->Files and Folders, >> does Gnucash.app have access to the Documents Folder (or the folder where >> your Gnucash data file lives? >> >> Also, try again running from the terminal and add the --nofile option >> >> Chris >> >> On Oct 27, 2019, at 12:17 PM, Chris Martin wrote: >> >> ./Gnucash --debug --extra >> >> >> > ___ > 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] MacOS Catalina Gnucash 3.7 won't start
> On Oct 27, 2019, at 12:17 PM, Chris Martin wrote: > > Dear all, > I've researched the mailing list and the bug lists and seem to have > run into a problem that is not described there. After updating MacOS to > Catalina, my existing gnucash application would just hang when started > without opening any windows or returning any error messages. Thinking that > this was just because I was using an older version of gnucash I downloaded > gnucash 3.7 and copied it from the dmg into my Applications folder. When I > tried to start it now, still the icon would just bounce and bounce with no > windows or error message. Eventually, after a few minutes, it stopped > bouncing and the os labeled the process as "not responding". Further > puzzled, I force-quit and tried running it from the command line. > ./Gnucash didn't return any error messages, so in the interest of trying to > get a trace file I started adding command-line options. Even when I run > ./Gnucash --debug --extra I still get no output on stdout, stderr, nor a > trace file and the process just hangs and never terminates on its own. > Eventually, I have to kill it with cntrl-c. I've tried downgrading to > gnucash 3.5 and 3.6 but I get exactly the same result. In Systems > Preferences, I've given gnucash "Full Disk Access" just in case Catalina's > new disk security scheme was blocking it ... alas no change. As a > last-ditch effort I tried running it with sudo, but no luck there either. > I'm confused and puzzled and would welcome any suggestions that any of > you might have. Is anything written to the trace file (https://wiki.gnucash.org/wiki/Tracefile)? 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] Just updated to MacOSX Catalina and GnuCash will not open.
Dave, Showing the extensions (e.g. the .txt in foo.txt) is a preference in Finder's preferences on the Advanced tab. You don't need to double click a text file to read it, you can just select it and tap the space bar. That actually works for a surprising variety of file types, not just text. Regards, John Ralls > On Oct 21, 2019, at 5:53 PM, David H wrote: > > Thanks John so they are but I think I'll just keep copying them over with the > app as it's a lot easier than digging down about 5 sub directories :-) The > dmg I have doesn't show them with .txt on the end of the file name or if they > are I've turned it off somehow but they open up when you double click on them > ok. > > Cheers Dave H. > > > On Tue, 22 Oct 2019 at 10:30, John Ralls wrote: > You only need to copy Gnucash.app. The other files, README.txt, NEWS.txt, > etc. are in the dmg and renamed with the .txt so you can easily read them > with QuickLook. They're also inside Gnucash.app (control-click on Gnucash.app > in Finder and select "Show package contents" from the context menu) at > Contents/Resources/share/doc/gnucash, though those aren't renamed for > QuickLook. > > Regards, > John Ralls > > > > On Oct 21, 2019, at 3:17 PM, David H wrote: > > > > I copy everything to Applications/GnuCash and run it from there, you can't > > run it from the dmg. > > > > Cheers Dave H. > > > > On Mon, 21 Oct 2019 at 20:28, GJS wrote: > > > >> Hi, > >> I've run 2.6 on previous version of MacOSX but couldn't install 3.6. > >> Having updated to Catalina none of my 32 bit software works! Thanks Apple. > >> Downloaded 3.7-1. Clicking the file opens a folder containing six files > >> but not the usual File -> Applications facility. Clicking the Gnucash > >> icon starts the verification process that loads the disc image on the > >> desktop, puts an icon in the taskbar and leads to the "do you really > >> want to open it?" dialogue. Choosing "Open" closes the window and > >> removes the icon from the taskbar. Only the disc icon is left which > >> invites one to do it all again ad nauseam. > >> > >> Checking Help files, tutorials and various mailing lists has produced > >> nothing useful. > >> > >> I've used Gnucash for years on Windows and Mac with no problems. This is > >> so frustrating and time consuming that I'm thinking of going back to > >> spreadsheets. > >> > >> Thanks for your time > >> Gra Smith > >> ___ > >> 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] Just updated to MacOSX Catalina and GnuCash will not open.
You only need to copy Gnucash.app. The other files, README.txt, NEWS.txt, etc. are in the dmg and renamed with the .txt so you can easily read them with QuickLook. They're also inside Gnucash.app (control-click on Gnucash.app in Finder and select "Show package contents" from the context menu) at Contents/Resources/share/doc/gnucash, though those aren't renamed for QuickLook. Regards, John Ralls > On Oct 21, 2019, at 3:17 PM, David H wrote: > > I copy everything to Applications/GnuCash and run it from there, you can't > run it from the dmg. > > Cheers Dave H. > > On Mon, 21 Oct 2019 at 20:28, GJS wrote: > >> Hi, >> I've run 2.6 on previous version of MacOSX but couldn't install 3.6. >> Having updated to Catalina none of my 32 bit software works! Thanks Apple. >> Downloaded 3.7-1. Clicking the file opens a folder containing six files >> but not the usual File -> Applications facility. Clicking the Gnucash >> icon starts the verification process that loads the disc image on the >> desktop, puts an icon in the taskbar and leads to the "do you really >> want to open it?" dialogue. Choosing "Open" closes the window and >> removes the icon from the taskbar. Only the disc icon is left which >> invites one to do it all again ad nauseam. >> >> Checking Help files, tutorials and various mailing lists has produced >> nothing useful. >> >> I've used Gnucash for years on Windows and Mac with no problems. This is >> so frustrating and time consuming that I'm thinking of going back to >> spreadsheets. >> >> Thanks for your time >> Gra Smith >> ___ >> 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] AqBanking help for Citi CC (cont'd again)
> On Oct 20, 2019, at 7:46 PM, Jonathan Stickel wrote:
>
> As with messages in January and August, I too would like AqBanking to work
> with a Citi credit card account. I've followed the recommend settings
> described here:
>
> https://lists.gnucash.org/pipermail/gnucash-user/2018-October/080548.html
>
> but still no luck.
>
> I did find a feature when logged in to my citi.com account to "manage access"
> for third party software applications ("like Quicken® or Quickbooks®"). This
> is through Profile->More Settings. Clicking on Add Access then gives 10
> minutes to make a connection. I've tried running AqBanking during this 10
> minute window, but it still does not retrieve an account list or download
> transactions. So I am at a loss. If anyone is currently being successful
> using a Citi cards connection, please post!
That 10-minute window makes it seem like it's OFX Web Connect, where you
authenticate via the web and then connect with your financial software.
AQBanking and therefor GnuCash doesn't support that. It supports only OFX
Direct Connect where the financial software handles the authentication.
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 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 12:32 PM, andrewTE wrote: > > Okay thanks. Reading on it, seems like it's caused by library and compiler > compatibility issues with no current way forward. Worse yet it may be caused > by threading issues. And it's intermittent to reproduce for some people to > boot. Being a SW developer myself, this does not look promising for a fix > any time soon. I guess my best bet is to use 3.5 or stick to 2.6 then? Unfortunately that seems like a correct assessment. Unless you need FinTS I think 3.5 is your best bet. Unless, of course, you have some skill in working with pthreads on Windows and can figure out what's going astray... 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 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 12:08 PM, andrewTE wrote: > > I am able to run Income Statement, Balance Sheet and Cash Flow. > OK, that plus the tracefile output indicating that javascript has left the building means that it's bug 797293. 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] Tracefile on Windows (was Gnucash 3.7 freezes on any report after update from 2.6)
> On Oct 20, 2019, at 11:38 AM, Adrien Monteleone > wrote: > > See the wiki about obtaining a tracefile on Windows. Make sure to check the > tracefile before re-starting GnuCash after a freeze. (it gets overwritten on > subsequent runs) Not on Windows. On Windows each tracefile has a 6-character random string attached so they're all there until the user cleans them out. 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 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 10:51 AM, andrewTE wrote: > > I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash > would freeze immediately if I click on any report (there were 2 opened tabs > by default as carried over from how I had it on 2.6). Thinking this was > caused by incompatible reports, I managed to close them with "X" while they > were not yet active, saved, reopened gnucash. Then I created brand new > report. First time it worked but then as soon as I changed report to show 15 > items versus default, was it 8?, it froze. Second and subsequent time, > trying to create ANY report immediately freezes the gnucash. Basically it is > impossible to create any reports, at least not expense reports. I did wait a > number of minutes (10+) but it just doesn't come back from complete freeze. > > Is there a way around this? Or are my only options to either stick to 2.6 > forever or start a completely new file at the beginning of next year for new > data and keep 2.6 installed on another PC (as they cannot coexist on > windows?)? Keep in my that my existing file has more than 10 years of > history of daily transactions so it's pretty large. > > Thanks for any suggestions. This might be be https://bugs.gnucash.org/show_bug.cgi?id=797283. Does it really freeze on any report at all or just on graphical reports? Is GnuCash completely hung so that if you click one of the other tabs it doesn't switch after a few minutes? Are there any unusual messages in the trace file (https://wiki.gnucash.org/wiki/Tracefile)? Try starting GnuCash from a CMD prompt with the debug option: "c:\Program Files (x86)\gnucash\bin\gnucash" --debug Then look at the end of the new tracefile to see what was the last message GnuCash printed before it hung. Please start Task Manager, switch to the Details tab, and find the gnucash entry. Does it show 0 CPU? 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] Dot Directories in Win10
> On Oct 19, 2019, at 11:32 PM, David T. via gnucash-user > wrote: > > Hello, > > I am using Gnucash 3.5 on Windows 10 (installed on a new Windows machine June > 2019), and I notice a couple of dot directories placed in my user folder > (C:\Users\sunfish): .cache and .dbus-keyrings > > The cache folder has a fontconfig folder with a couple of subfolders in it; > the dbus folder has one text file in it org_gtk_gdbus_general > > My Windows machine is quite new--meaning that I haven't installed much on it > beyond some image apps--and I suspect that GnuCash or one of its dependencies > has created these two folders. My first question is: is this assumption > correct? Next, what are these folders? Next, are they necessary, or can I > delete them? Finally, I was under the?? impression that work has been done to > sequester these entries in a Windows way (either in a registry entry, or > under AppData or some other Windows nook); is this a glitch on my machine, or > is it an area that needs further refinement? David, If you delete them they'll probably come back. I think they're both webkit artifacts, one for caching the font file locations that fontconfig found when it searched your system and the other the dbus control file that older versions of webkit used for inter-process communication with its javascript engine. The sequestration was intended mostly for GnuCash's own state and configuration files. We don't have much control over what the dependencies do about their state and config files. 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 3.7-1
Under System Preferences>Security and Privacy, General Tab, do you have "App store and identified developers" selected under "Allow apps downloaded from:"? Did you get the dialog saying that you'd downloaded GnuCash from the web and asking if you were sure you wanted to open it? Regards, John Ralls > On Oct 15, 2019, at 10:09 AM, Chris Tsuji wrote: > > Adrien > After I downloaded > I opened the dmg and drag to the application folder. > I have a mac so I control click and clicked on the open button. > Did not open, > I then double clicked and the open button was clicked. > Still no open. > What else can i do? > Thanks in Advance. > Chris > > Sent: Tuesday, October 15, 2019 at 8:57 AM > From: "Adrien Monteleone" > To: "Gnucash User" > Subject: Re: [GNC] Gnucash 3.7-1 > Make sure you’ve copied the GnuCash.app from the dmg to either > /Applications or ~/Applications first. > Then you’ll need to open that folder and right-click GnuCash.app and > choose ‘Open’. > MacOS will ask you if you’re sure you want to open it since it was > downloaded from the net. Confirm you want to open it. > It may or may not open. > If not, simply left-click to open it this time. Now you can update your > Dock icon if needed and it should open on first click each time. > Regards, > Adrien >> On Oct 15, 2019 w42d288, at 10:54 AM, Chris Tsuji >wrote: >> >> Hi >> Hope that someone can help me. >> I was using 3.3. >> I downloaded 3.7.1 and can not get the software to open. >> Mac OS 10.14.6 >> Hope that someone can help. >> Chris Tsuji > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > [1]https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > [2]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. > > References > > 1. https://lists.gnucash.org/mailman/listinfo/gnucash-user > 2. https://wiki.gnucash.org/wiki/Mailing_Lists > ___ > 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] Gnucash on MacOs Catalina
> On Oct 14, 2019, at 4:11 PM, Kees Blom via gnucash-user > wrote: > > Hi, > > I am having a problem running GNUcash 3.7 on Catalina as well. I downloaded > that version today and get the error below in the Console. I tried under a > different user but same issue. > > Any ideas? > > Oct 14 16:03:51 KobePro com.apple.xpc.launchd[1] > (com.apple.xpc.launchd.oneshot.0x1018.Gnucash[7193]): Service exited > with abnormal code: 1 Is there a crash report in Console? Anything useful in the trace file? (see https://wiki.gnucash.org/wiki/Tracefile). If not, try opening Applications:Utilities:Terminal and running it from the command line: /Applications/Gnucash.app/Contents/MacOS/Gnucash adjusting the path if you put it somewhere else. Is there any output 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 on MacOs Catalina
Cool it with the wild speculation. FYI I've been running GnuCash 3.5, 3.6, and 3.7 on Catalina since the first developer beta in early June with no issues at all. I suspect from the error messages that the OP is trying to run GnuCash 2.6.x. Those were built as 32-bit apps to support MacOS 10.5 and 10.6. Catalina won't run 32-bit apps. That's why I asked the OP what version of GnuCash they're trying to run. Regards, John Ralls > On Oct 10, 2019, at 7:48 PM, GWB wrote: > > Chronosync is another app that needed some work to integrate smoothly > with Catalina. This excerpt from their email to users explains: > > << > The Catalina Split > Catalina introduces a new APFS feature called ‘Volume Groups’. Under > Catalina, Apple takes advantage of this ability and splits the boot > volume into two components: System and Data. The System volume is > read-only and contains all the operating system files that should > never change during use of the computer. The Data volume contains > everything else, including the user’s home folders. Through a new > Apple feature known as firmlinks, the two volumes are linked together > to appear as one volume to the user, so you will only see one drive on > your Mac. However, there really are two distinct boot volumes mounted. > You can see the two volumes using Disk Utility or by mounting the > drive on an older macOS. If running a bootable backup, we strongly > recommend starting fresh with a new backup volume and not to copy over > your old bootable backup volume. Read the ChronoSync Catalina Tech > Note for all the details. >>> > > This may have no relevance at all, but if your version of GnuCash > "needs" to alter a specific file in the System folder (which is > doubtful, but possible) Catalina may be using a "hard link" instead of > the underlying file. The devs would know. > > I'm not sure, but it looks like Apple is re-inventing the old LVM and > calling it something different. It's usually good to separate boot OS > from data (Unix welcomes Apple to 1998!), but this might not be the > way to do it. Better to just mount them in separate LVM > containers/volumes, and snapshot them. > > What type of CPU does system information report on your mac? The > error message "Bad CPU type in executable" might be Catalina seeing a > CPU call from GnuCash (amd64 bit i7, usually) as something else. > > Gordon > > On Wed, Oct 9, 2019 at 10:19 PM John Ralls wrote: >> >> >> >>> On Oct 9, 2019, at 1:09 PM, gnuc...@pelchar.no-ip.org wrote: >>> >>> Hi, >>> >>> I'm having trouble starting gnucash on Catalina. Here's the message I get >>> from the command line: >>> >>> /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line >>> 95: /Volumes/Macintosh >>> HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Bad CPU type in >>> executable >>> /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line >>> 95: /Volumes/Macintosh >>> HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Undefined error: 0 >>> >>> Anybody has a clue? >> >> What version of 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. ___ 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 Catalina
> On Oct 9, 2019, at 1:09 PM, gnuc...@pelchar.no-ip.org wrote: > > Hi, > > I'm having trouble starting gnucash on Catalina. Here's the message I get > from the command line: > > /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line > 95: /Volumes/Macintosh > HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Bad CPU type in > executable > /Volumes/Macintosh HD/Applications/Gnucash.app/Contents/MacOS/Gnucash: line > 95: /Volumes/Macintosh > HD/Applications/Gnucash.app/Contents/MacOS/Gnucash-bin: Undefined error: 0 > > Anybody has a clue? What version of 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] Migrate MySQL back-end from 5.7 to 8.0
> On Oct 9, 2019, at 1:28 AM, Neko Chang wrote: > > Hi, gnucash-user > > I've been using GNU cash for several years, thanks all very much. > Using latest version in Windows, MacOS and FreeBSD :D > > I recently evaluating migrate MySQL back-end from 5.7 to 8.0. > But I don't know GnuCash compatible with MySQL 8.0. > I didn't find clear answer @ google. > > Can help my evaluation? > Thanks all very much. We don't know either, but the only place that has caused trouble in the past is the TIMESTAMP type, where MySQL changed the beginning value from 0 to 1, i.e. from 1970-01-01 00:00:00 to 1970-01-01 00:00:01, both UTC. We've since changed all of the fields with a TIMESTAMP type to the DATETIME type that has a much wider range of valid dates, more in line with GnuCash's internals. Another possibility, though very unlikely, would be if MySQL has changed their client API so that the libdbi-driver would fail or do something strange. Why don't you have a go at it and report back? 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] MacOS Catalina upgrade question
> On Oct 7, 2019, at 12:27 PM, Adrien Monteleone > wrote: > > Since Catalina was released today, I figured I start this thread because > questions will arise. > > I’m not one to early adopt an OS upgrade. I usually wait a spell for the > particular vendor to work out the initial kinks. But I’m curious if GnuCash > 3.7 is ready to run on Catalina. I know there is a new Notarization > requirement. Is 3.7 notarized? Or should Mac users wait for 3.8 to upgrade > their OS? > > Also, I saw this today: https://developer.apple.com/news/?id=09032019a > > Does point #2 cover the issue with FinanceQuote.app not being signed with > GnuCash’s developer ID? Adrien, It's FinanceQuote Update.app, and I didn't include it in the 3.7 dmg because it's not sign-able and so can't be notarized and so Catalina would reject the dmg. That said, I just figured out how to make it signable... but it doesn't quite work because it won't build XS modules--in particular, JSON::Parse. It may come back in the future if I can work out the problems. OTOH there's a warning in the Catalina release notes that all of the scripting languages--perl, python, and ruby are mentioned--are provided for "legacy" reasons and that they may be an extra download or something in a future release. On the other hand, python3 is back. The news item you cited is incorrect, as is the Apple Developer page about notarizing legacy apps: I tried notarizing without hardened runtime, and separately with unsigned binaries. Both failed. Fortunately the 10.9 SDK is acceptable so GnuCash 3.7 bundle is notarized and should work fine on Catalina. There's also a notarized Gnucash-Intel-3.6-2.dmg on Sourceforge. 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] How can I add statement balances to my accounts as checks?
> On Oct 6, 2019, at 5:48 AM, armanschwarz wrote: > > Adrien Monteleone-2 wrote >> Software can’t fix you. Only you can fix you. You shouldn’t do the >> reconciliation till you have time not to rush it. The software won’t >> explode if you don’t reconcile by a certain date. > > Yeah I fundamentally disagree with this, almost at a philosophical level. If > we take the view that mistakes are symptomatic of broken users we'll never > make software that's actually useful to anyone. > > I also think there's a bit of irony as you seem to be suggesting that in > order to use a feature designed to correct for human errors, we should just > not make human errors. I don't get it. > Reconciliation is a manual process because GnuCash has no way to parse your bank statement into a form that it can compare with your book, and even were the bank statement presented to GnuCash there's no code in GnuCash to make the comparison and flag any issues. Adding those capabilities isn't one of the core team's current priorities and isn't likely to be any time soon, but if you'd like to make it your priority and can write clear, maintainable modern C++ we'd be happy to consider a pull request. If you want to take that on please start a new thread in gnucash-devel to discuss your proposed design before you start coding. In the meantime, Adrien is quite right: If you want to ensure that both your book and your bank's records of your account are correct then you need to do a proper job of comparing them. The reconcile window is an aid, not an AI. If you don't care about ensuring that both are correct and agree, don't bother reconciling. The choice is yours. To answer your earlier question, "if I'm reconciling a July 2019 statement against my accounts, why should I be given the option of using a July 1010 transaction to reconcile against? ": Because it's in the account and hasn't yet been marked reconciled. That's the sole criterion for what you get presented for reconciliation. Setting aside that a 1010 transaction is outside of the date range that GnuCash can handle (that currently starts in 1400), a 1009 year old unreconciled transaction is an obvious error. I'd think most users would like to have it flagged. Note as well that you can set a limit to how old a transaction you can enter or edit in File>Properties on the Accounts tab. 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] [GNC-dev] custom report freezing - work done gets lost.
You mean why does it hang instead of crashing? Possibly because the memory was reallocated back to the program for something else and the attempt to free the splits is freeing whatever that is and that's resulting in a hang. But why would a report create or delete splits or transactions? A report should be describing the book as it is, not changing it. Regards, John Ralls > On Oct 6, 2019, at 2:36 AM, Christopher Lam wrote: > > Ok forwarding to people who have better idea. > > -- Forwarded message - > From: Steven Bruniges > Date: Sun, 6 Oct 2019 at 09:34 > Subject: Re: [GNC] custom report freezing - work done gets lost. > To: Christopher Lam > > > Have identifies my issue. Was calling xaccTransDestroy with pointers to > splits that had been destroyed in an earlier loop. Not sure why this locks > up gnucash. > > Steve > > On Sun, 6 Oct 2019, 22:20 Christopher Lam, > wrote: > >> Sorry without specific detail what you're trying to do, we can't help. >> Moreover this is open-source, including open-source help requests. >> cc: devel >> >> On Sun, 6 Oct 2019 at 05:58, Steven Bruniges >> wrote: >> >>> Not even sure it’s the session I want to save (hoping for the function >>> underlying the save option in the file menu). >>> >>> >>> >>> Working through a process of elimination. I’d love to find the >>> transaction that’s triggering this behaviour. If I can reduce the 3000 >>> splits to something more manageable I may find the issue? >>> >>> >>> >>> The report typically hangs and Task manager shows the system is at rest. >>> If I modify the code to open warning dialogs it crashes after a number of >>> loops. No output in the trace file. Either way, I get no diagnostic >>> feedback. >>> >>> >>> >>> Its possible I am retaining pointers to a deleted split, or running >>> across a temporary split that was never finished, etc, (or both). >>> >>> >>> >>> On that point, is there any test if a split is deleted? >>> >>> >>> >>> Steve >>> >>> >>> >>> *From:* Christopher Lam [mailto:christopher@gmail.com] >>> *Sent:* Sunday, 6 October 2019 6:17 PM >>> *To:* Steven Bruniges >>> *Cc:* GnuCash users group >>> *Subject:* Re: [GNC] custom report freezing - work done gets lost. >>> >>> >>> >>> qof-session isn't currently accessible to scheme. Why do you think you'll >>> need to save session? >>> >>> >>> >>> It may help to publish your report on Bugzilla or devel mailing list. >>> >>> >>> >>> On Sun, 6 Oct 2019, 12:53 Steven Bruniges, >>> wrote: >>> >>> Hi. >>> >>> >>> >>> Have a custom report that appears to be freezing, so I have to halt it. >>> It >>> in a 3000 item loop, and I suspect the overheads are growing as it >>> progresses. >>> >>> >>> >>> I want to save the book periodically, which if nothing else will simplify >>> the work in a future run. >>> >>> >>> >>> Is there a function I can call that is like "gnc-book-session-save"? >>> >>> >>> >>> Steve >>> >>> ___ >>> 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-devel mailing list > gnucash-de...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ 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 update currency CHF & EUR impossible
Thanks for following up, but please remember to copy the list on all replies. Regards, John Ralls > On Oct 3, 2019, at 9:27 AM, Michael Strehle > wrote: > > Hello John, > > No more error > > Thank you > > mike > > De : John Ralls > Envoyé : jeudi, 3 octobre 2019 18:03 > À : Michael Strehle > Cc : gnucash-user@gnucash.org > Objet : Re: [GNC] GnuCash update currency CHF & EUR impossible > > > > > On Oct 2, 2019, at 11:25 AM, Michael Strehle > wrote: > > Dear Mister, > > Thank you for your nice software. > I decided to add all my accounts on GnuCahs but somme currency can't be > updated > > My currency are : > USD (update work) > CHF (didn't work) > EUR (didn't work) > > I have installed and my stores market > update well. > > What is the problem ? > > > Sorry I speak french or german. > > > What is your book currency? > > 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 update currency CHF & EUR impossible
> On Oct 2, 2019, at 11:25 AM, Michael Strehle > wrote: > > Dear Mister, > > Thank you for your nice software. > I decided to add all my accounts on GnuCahs but somme currency can't be > updated > > My currency are : > USD (update work) > CHF (didn't work) > EUR (didn't work) > > I have installed and my stores market > update well. > > What is the problem ? > > > Sorry I speak french or german. > What is your book currency? 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 3.7 and Portfolio Report
> On Oct 2, 2019, at 10:54 AM, Ed Boivin wrote: > > I'm another Ed and am experiencing the same issue with the Investment > Portfolio report. Was working fine until the upgrade to V3.7. > > Here is what is in my trace file after trying to run the report: > In procedure module-lookup: Unbound variable: report-currency > * 13:35:47 WARN [gnc_numeric_to_decimal()] Rounding required when > 'never round' specified. > * 13:44:52 WARN Could not locate file AUTHORS > * 13:44:52 WARN Could not locate file DOCUMENTERS > * 13:44:52 WARN Could not locate file LICENSE > * 13:51:28 WARN14 (apply-smob/1 # e3cd160>) > In c-interface.scm: > 22:4 13 (gnc:call-with-error-handling _ _) > In ice-9/boot-9.scm: > 829:9 12 (catch #t # …) > In c-interface.scm: > 27:37 11 (_) > In unknown file: > 10 (eval-string "(gnc:report-run 10)" #) > In ice-9/boot-9.scm: >2312:4 9 (save-module-excursion #) > In ice-9/eval-string.scm: > 38:6 8 (read-and-eval # #:lang _) > In report.scm: > 776:4 7 (gnc:report-run _) > In c-interface.scm: > 64:23 6 (gnc:backtrace-if-exception _ . _) > 22:4 5 (gnc:call-with-error-handling _ _) > In ice-9/boot-9.scm: > 829:9 4 (catch #t # …) > In c-interface.scm: > 26:40 3 (_) > In report.scm: >780:24 2 (_) >756:25 1 (gnc:report-render-html #< type: 4a6b82e8678c4…> …) > In portfolio.scm: >198:32 0 (portfolio-renderer #< type: 4a6b82e8678c4f3d9e…>) > > In procedure module-lookup: Unbound variable: report-currency > > Any help is appreciated! > > Thanks, > Ed (the other one) Chris Lam explained that and offered a fix a week ago: > On Sep 24, 2019, at 8:03 AM, Christopher Lam > wrote: > > There's an error in portfolio.scm -- modify the 'report-currency' to > 'currency' and it should be fine > > modified gnucash/report/standard-reports/portfolio.scm > @@ -196,7 +196,7 @@ > (if (not (null? accounts)) > (let* ((commodity-list (gnc:accounts-get-commodities > (gnc:accounts-and-all-descendants accounts) > -report-currency)) > +currency)) >(pricedb (gnc-pricedb-get-db (gnc-get-current-book))) >(exchange-fn (gnc:case-exchange-fn price-source currency to-date)) > That part of GnuCash is interpreted so you can apply the fix (which is to replace "report-currency" with "currency" on line 199 of XXX/share/gnucash/scm/gnucash/reports/standard-reports/portfolio.scm. The XXX at the front is the install prefix for GnuCash: On Linux it's either /usr or /opt, on Windows by default it's C:/Program Files (x86)/gnucash/, and on MacOS the default is /Applications/Gnucash.app/Contents/Resources. 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 3.7 and Portfolio Report
You don't need perl unless you want to retrieve stock prices or currency exchange rates. It doesn't have anything to do with anything else. The next two errors are unusual, but they also relate to setting up online quote retrieval and don't have anything to do with the report failing. Was there anything more in the log after the gnc:call-with-error-handling line? Regards, John Ralls > On Oct 1, 2019, at 2:50 PM, Ed Fields wrote: > > checked the trace file, > > * 17:12:27 WARN Could not spawn perl: Failed to execute > child process (Bad file descriptor) > * 17:12:27 ERROR gnc_process_get_fd: assertion 'proc' failed > * 17:12:27 ERROR gnc_detach_process: assertion 'proc && > proc->pid' failed > * 17:13:14 WARN14 (apply-smob/1 # df2e170>) > In c-interface.scm: > 22:4 13 (gnc:call-with-error-handling _ _) > > do I need to reinstall perl? > if so which version is needed for Windows 10? > > thanks for your patience > ed > > > On Tue, Oct 1, 2019 at 5:31 PM Ed Fields wrote: > >> Creating a portfolio report seems doesn't seem to work >> >> after selecting Reports / Assets and Liabilities / Investment Portfolio I >> am presented with >> >> Report error >> >> An error occurred while running the report. >> >> ordinarily I would expect to asked to set up the report >> - >> >> I pressed on via selection of Edit / Report Options and selected an >> investment account. Then performed a reload. Same error is displayed. >> >> This feature is sorely missed with v3.7, worked fine before upgrade. >> Please help >> >> thanks >> ed >> >> > ___ > 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] How to list/view a chronological journal of all transactions? (general journal)
> On Oct 1, 2019, at 6:16 AM, Fran_3 via gnucash-user > wrote: > > Is there anyway in gnuCash to create a report that list all transactions in > chronological order... aka "general journal" or "book of original entry" > Thanks for any help. How about Reports>Assets & Liabilities>General Journal? 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] CSV stock price import
> On Sep 28, 2019, at 9:38 PM, Joseph G Keithley III via gnucash-user > wrote: > > Hello, > > ?? I've been importing daily stock prices from a csv file.?? It worked > fine in Gnucash 3.5, but doesn't work in 3.6-3.8.?? I keeps nagging me for a > "namespace". What is a "namespace".?? There is no option on the csv > import setup page for a "namespace".?? The data is in three comma delimited > columns, stock symbol, stock price, date.?? What do I have to do to import > the data in later versions of Gnucash? > > Thanks for any help in advance, The Namespace, called the Type on the Edit Security dialog, is one of the categories on the left side of the Price Database and Security Database dialogs. GnuCash has a special one, CURRENCY, and provides several default ones named after US Stock exchanges. It's a free-text field so that you can create your own namespaces. The change was made necessary by the discovery that some stock symbols collide with currency codes. 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 not insert text on transaction after import QIF
> On Sep 25, 2019, at 3:19 PM, dmeece wrote: > > After a huge effort to install Gnucash 3.7 on a Win 10 machine and then on a > production build (no errors- all dependencies met) of Gnucash 3.7 from > tarball on a Linux box, I failed to get a working program. I was able to > load GnuCash3.7 in the Win 10 box with Qif files that numbered over a > thousand transactions after failing with the "new" csv importer - the csv > could not handle liabilities/credit cards and, it seems that anything over > ten (US) bank transactions, it blows up. Anyway, after getting the files > into the Win 10 adaption and seemingly working, now, by moving the .gnucash > file over to the Linux build I find myself not being able to work with the > transactions at all. I click on a line to insert text, say a note line or > action or even the description line, the program just closes, bye bye, > lights out. There seems to be some type of text box that highlights when > clicked, but any further touches - bye! Restart, same situation, can't touch > it - yet in the Win 10 I seem to be OK. Any ideas here?? > > I only use the Win 10 machine to handle the Excel/CSV Construction for the > file import and QIF from there. This is a long convoluted route I've been > using over the years - I've only been able to work with QIF, not QFX, > aqbanking,etc, none of it. > The Linux box is my production machine set on Linuxmint 19.2. Proofing this > accounting on the Win 10 machine is a real pain. Since you can build GnuCash on your Linux box you can run it in the debugger. Please get a stack trace (see https://wiki.gnucash.org/wiki/Stack_Trace for instructions if you're not familiar with debugging) and attach it to a new bug report. Depending on the source of the crash it might be helpful to install the debug symbols packages for gtk3 and glib2 (the Ubuntu package manager doesn't report -dbg packages for either so see https://wiki.ubuntu.com/Debug%20Symbol%20Packages) to get the actual locations in those libraries to help analyze the problem. 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] Suggestion to ease newbies import problems
> On Sep 25, 2019, at 5:15 PM, David Cousens wrote: > > That seems like an admirable and at least enjoyable solution. I'd be worried about data entry errors, especially after the second 6-pack. 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] update quotes hanging
Have you updated Finance::Quote to 1.49? It throttles the Alphavantage requests
to comply with their 5 quotes/minute restriction.
You might also consider using yahoo_json for as many non-currency commodities
as you can. Yahoo! still supports the json API and doesn't require throttling.
Regards,
John Ralls
> On Sep 23, 2019, at 6:59 PM, Jon Schewe wrote:
>
> I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't
> changed.
>
> On 9/23/19 2:25 PM, Adrien Monteleone wrote:
>> There are no updates to the 2.6 series any longer. 2.6.21 is the last one
>> and nearly 18 months old. There have been eight 3.x releases so far.
>>
>> You can build from source, or there are debs floating around on the list for
>> 3.7 that you should be able to install on 18.04.
>>
>>
>> Regards,
>> Adrien
>>
>>> On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe wrote:
>>>
>>> I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the
>>> update price quotes process is hanging, both from within GnuCash and from
>>> the command line.
>>>
>>> I've created a CSV file of all of my commodities and tested them individual
>>> using gnc-fq-dump and they all return fairly quickly. Not all of them have
>>> valid prices, but none hang. Below is the script that I have used with cron
>>> in the past to update my quotes at regular intervals.
>>>
>>> When the process is running I can strace it and I find that the perl
>>> process is usually in a write call writing "use of uninitialized value".
>>>
>>> Does anyone have suggestions to determine why updating the quotes is
>>> hanging?
>>>
>>> Is this a problem with this version of gnucash? I would prefer to stick
>>> with the version of gnucash that comes with my distribution so that I get
>>> automatic updates, however I can build a custom version if that is what is
>>> needed.
>>>
>>>
>>> #!/bin/sh
>>>
>>> ALPHAVANTAGE_API_KEY=XXX
>>> export ALPHAVANTAGE_API_KEY
>>> env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT;
>>> /usr/bin/gnucash --add-price-quotes
>>> ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found
>>> Finance::Quote"
>>>
>>> --
>>> http://mtu.net/~jpschewe
>> ___
>> 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.
>
> --
> http://mtu.net/~jpschewe
>
> ___
> 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] How to enter the gain on sale of shares
> On Sep 21, 2019, at 5:22 PM, TAKASHI KANAMORI > wrote: > > Hello. > In addition to entering the number of shares, the stock price, and the > total amount when posting the gain on sale of shares in GNUCaSH, the gain > on the sale is entered in the stock item, but it is inevitably required to > enter the number of shares and the stock price, so it really matches the > actual situation It will disappear. What should I do? This is covered in great detail in https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_capgain.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] Search and Replace
On Sep 21, 2019, at 9:20 AM, Jamestk wrote: > > Hello folks, just a quick check to see if this feature has been added, been a > while with quite a few updates in between. If you mean bulk editing, no it hasn't and it isn't likely to be until we've converted GnuCash to a full database application. That will take many more years. 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] update aqbanking
> On Sep 18, 2019, at 10:20 AM, Tim Meyer wrote: > > Dear all, > I am using GnuCash on Ubuntu Linux. > Version: 3.7 > Build ID: 3.7+(2019-09-07) > Finance::Quote: 1.47 > How can I update aqbanking within in GnuCash? > > the version 5.99.30beta is not available in repositories. And GnuCash 3.7 isn't compatible with AQBanking 6.0 because there are other API changes that AQBanking has made since GnuCash 3.7 was released. There's a third library, Gwenhywfar, that underpins AQBanking and which similarly has new API, so you will have to build all three from source... and probably need to do so frequently as AQBanking progresses towards releasing 6.0. 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 contains errors
Tim, This is being actively discussed on the gnucash-de list. I suggest that you subscribe there. I can try to summarize my understanding of the problem: There was a mandatory change to FinTS involving product registration that is handled with a small change to AQBanking and GnuCash. For that you need GnuCash 3.7 and AQBanking 5.8.x. If you're a Windows or Mac user the GnuCash 3.7 all-in-one bundles have AQBanking 5.8.2. However several German banks decided to implement other FinTS authentication features associated with PSD2 and those provisions caught the AQBanking developer by surprise. He's working hard to get those working but he won't be able to to that in the 5.8 stable series, so he's making the mods for the yet to be released AQBanking 6.0. Regards, John Ralls > On Sep 18, 2019, at 9:44 AM, Tim Meyer wrote: > > Dear Adrien, > > thank you for your reply. > Do get a better view on this issue: there is no one else having this problem > with EU bank accounts? > I might have be wrong with my impression that this must be an issue for much > more users than one person. > > Kind regards > Tim > > Am 18.09.19 um 18:37 schrieb Adrien Monteleone: >> Aqbanking is a separate project that GnuCash uses. >> >> I see on their main site (which you linked) they have their own mailing >> list. Perhaps check there for more specific help. >> >> Regards, >> Adrien >> >>> On Sep 18, 2019 w38d261, at 11:21 AM, Tim Meyer wrote: >>> >>> Dear all, >>> >>> I guess it might be this problem which belongs to EU users: >>> >>> https://ec.europa.eu/info/publications/190913-safer-payment-services_en >>> ... >>> As from 14 September 2019 the strong customer authentication (SCA) >>> requirement of the revised Directive on payment services (PSD2) comes into >>> force. >>> >>> >>> As far as I would see it, aqbanking might must be updated: >>> https://www.aquamaniac.de/rdm/projects/aqbanking/repository/revisions/d3a0ca20182ef62a3bfc08b76c46891bfb3c >>> >>> https://www.aquamaniac.de/rdm/projects/aqbanking/wiki/PSD2 >>> >>> I am not a developer. I am just searching for reasons why all my accounts >>> do not connect any more. >>> >>> Kind regards >>> TIm >> ___ >> 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] Opening account with CR no longer works, also BS does not work
The bundles have gtk+-3.24.8 effectively since 3.5 (that has a git build from a couple of days before the 3.24.8 release, 3.6 and 3.7 have 3.24.8 from the tarball). The Gtk+ that I tested against was in a different build environment and was 3.24.10. Issues with search in GtkTreeViews have in the past been related to imquartz.c, the Gtk input module that interfaces with the Apple IMs. That's known to have some other problems as well so I guess I need to take some time to work on it. Adrien, Homebrew's GnuCash "recipe" just downloads the GnuCash dmg from Github and that uses the libraries in the GnuCash.app bundle, not the ones that Homebrew installs. Also, the OP is talking about during a search on the Accounts page. It's getting passed to the search box as space and and the arrow keys are getting eaten completely. Regards, John Ralls > On Sep 17, 2019, at 9:21 AM, Adrien Monteleone > wrote: > > I recently (until I updated just now) was running 3.22.20 on MacOS 10.14.6, > but that was installed via Homebrew, so not very helpful. > > But I can say that CR was working to open an account from the Account tab > just fine. > > Apologies if that is noise. > > Regards, > Adrien > >> On Sep 17, 2019 w38d260, at 10:41 AM, Geert Janssens >> wrote: >> >> It still works on Fedora with gtk 3.24.10 >> What version of gtk did you ship in the MacOS bundle ? >> >> Geert >> >> Op dinsdag 17 september 2019 17:31:18 CEST schreef John Ralls: >>>> On Sep 17, 2019, at 6:12 AM, Ira Fuchs wrote: >>>> >>>> Yes, on the Accounts page. I am running MacOS 10.13. >>>> >>>> On Mon, Sep 16, 2019 at 10:41 PM John Ralls wrote: >>>>> On Sep 16, 2019, at 3:51 PM, ihf wrote: >>>>> >>>>> As of v 3.7, if you find an account by beginning to type its name and >>>>> then >>>>> hit Enter, the account used to open but no longer does. Also, if you >>>>> begin >>>>> typing a name and use backspace to correct your entry, it no longer >>>>> works >>>>> (nothing happens). >>>> >>>> I suppose that's on the Accounts page. >>>> >>>> What OS/Distro and (if Linux/BSD/MacPorts) Gtk3 version? >>> >>> Please remember to copy the list on all replies. >>> >>> I can reproduce it in gtk3-demo, so it's a Gtk3 problem. >>> >>> 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] Opening account with CR no longer works, also BS does not work
> On Sep 17, 2019, at 6:12 AM, Ira Fuchs wrote: > > Yes, on the Accounts page. I am running MacOS 10.13. > > On Mon, Sep 16, 2019 at 10:41 PM John Ralls wrote: > > > > On Sep 16, 2019, at 3:51 PM, ihf wrote: > > > > As of v 3.7, if you find an account by beginning to type its name and then > > hit Enter, the account used to open but no longer does. Also, if you begin > > typing a name and use backspace to correct your entry, it no longer works > > (nothing happens). > > I suppose that's on the Accounts page. > > What OS/Distro and (if Linux/BSD/MacPorts) Gtk3 version? Please remember to copy the list on all replies. I can reproduce it in gtk3-demo, so it's a Gtk3 problem. 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] Opening account with CR no longer works, also BS does not work
> On Sep 16, 2019, at 3:51 PM, ihf wrote: > > As of v 3.7, if you find an account by beginning to type its name and then > hit Enter, the account used to open but no longer does. Also, if you begin > typing a name and use backspace to correct your entry, it no longer works > (nothing happens). I suppose that's on the Accounts page. What OS/Distro and (if Linux/BSD/MacPorts) Gtk3 version? 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] Badly formed URL unknown-type
> On Sep 16, 2019, at 2:31 AM, Liz wrote: > > On Mon, 16 Sep 2019 10:25:14 +0100 > Uttam Chakravorty wrote: > >> Bump? > > Have you considered answering Geert's question? > > I'm the moderator, and I dislike "bump" as a tactic, less so if you > haven't answered questions directed to you. > Liz, He did answer, at 2019-09-14 15:06:54Z. Uttam, Geert's away until tomorrow. Please be patient. 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 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"
Gordon, GnuCash files are completely portable between operating systems. See https://wiki.gnucash.org/wiki/Backup for the details of which files need to be copied. The code to upgrade the saved reports and similar stuff kicks is driven by the location of the files, so copy your 2.6 config files to the 2.6 locations (generally $HOME/.gnucash). Make sure the new locations ($HOME/.config/gnucash on Linux, $HOME/AppData/Roaming/GnuCash on Windows) don't exist; if they do GnuCash will decide that the config is already migrated. Start up GnuCash and everything should properly migrate. That said, flatpak installs are a bit problematic for migration. They're seriously sandboxed and I'm not sure that we've figured out everything needed to work around the sandboxing. Regards, John Ralls > On Sep 15, 2019, at 6:45 PM, GWB wrote: > > Hello, John, > > I'm up and running on Windows 7 in a VirtualBox host, which should > work because that's the same machine which runs the tax and compliance > software (CCH). I'm turning compression off for now, and saving it as > an xml file without the gzip. I'll try to transfer over my reports > from the Ubuntu machine to the Windows, for which I'm hoping there is > a tutorial. Apparently scm is causing some difficulty? I was able to > get the flatpak for 3.7 running on Ubuntu 16, but it reported many > errors when translating scm. That must be from very old report > configurations, I'm hoping. I only need the saved report > configurations in GnuCash itself, which I'm guessing must be in > USER/.gnucash/saved-reports. Unfortunately the window configurations > for gnucash within the app launched from flatpak don't seem to work. > The "find" window cuts off the top search field. > > If I can't find out how to migrate from linux to Windows 7, I'll send > another email to the list. > > Thanks, > > Gordon > > On Sat, Sep 14, 2019 at 6:46 PM GWB wrote: >> >> Great, thank you, that helps. This is probably also a problem with >> gnucash 2.6.12 on ubuntu 16. When I now launch gnucash --nofile >> --debug it appears to hang on the opening screen and does not complete >> launch, so there is no menu to open files. My guess is that something >> went wrong in upgrading a dependency, perhaps sqlite3, and 2.16.12 is >> not going to respond now (i.e,. the sqlite3 upgrade is a "feature" to >> all the other dependencies, and a "bug" only to gnucash). The Windows >> version of 2.16.12 probably did what you are describing. It opened >> the sqlite3 files, did the database changes, and then allowed me to >> save it as xml. I'm not going to try to debug gnucash 2.6.12 and >> sqlite3 on Ubuntu 16 if I can avoid it. An upgrade to Ubuntu 18 is >> probably inevitable sooner rather than later, given the life cycle of >> the OS, and guncash 3 also looks necessary at this point. >> >> So will my reports on Ubuntu from gnucash 2.6 be automatically >> available in gnucash 3? Any particular type of voodoo needed to make >> that happen? >> >> Again, you guys rock. >> >> Gordon Bynum >> >> On Sat, Sep 14, 2019 at 4:59 PM John Ralls wrote: >>> >>> The XML file is (optionally, see Preferences>General) compressed with gzip. >>> >>> You might try reopening the database and see if it still takes 20 minutes. >>> ISTR that there was a database upgrade somewhere around 2.6.12 and if so it >>> would take a while to create the new tables, copy all of the records over, >>> and clean up. >>> >>> On Windows you can either run GnuCash from a shell window (CMD or >>> Powershell both work) with the path and any options, e.g. >>> "C:\Program Files (x86)\gnucash\bin\gnucash.exe" --debug --nofile >>> or if you want those options more permanently you can edit the command in >>> the shortcut. >>> >>> Regards, >>> John Ralls >>> >>> >>>> On Sep 13, 2019, at 8:11 PM, GWB wrote: >>>> >>>> OK, will do. This is interesting. I moved the file to a Windows 7 >>>> machine, and opened it with GnuCash 2.6.21. It did read the sqlite3 >>>> file, but it took a long time, probably 20 minutes or so. After it >>>> opened, I saved it as an xml file. GnuCash does open the .xml file >>>> more quickly, so perhaps I should stick with that format. My >>>> assumption is that Windows GnuCash reads and writes to sql formats >>>> without installing those dependencies directly. >>>> >>
Re: [GNC] Gnucash doesn't load American Express QFX files
> On Sep 14, 2019, at 9:50 PM, Jim Leek wrote: > > > An update on this. The development branch, at least, on the libofx github > https://github.com/libofx/libofx can parse the American Express OFX files. > I'm not sure when that ability was added, I didn't try any releases, just the > latest commit on the github. So I was able to get them working with GnuCash > 3.6. I assume this version of libofx will make it into the repositories > eventually, but for now users will have to build their own libofx I guess. I looked to see what was new and found https://github.com/libofx/libofx/commit/9c8acb69771dfe0f893bdb887027567e80e6f518 which points to https://bugs.gnucash.org/show_bug.cgi?id=797125. Although the commit comment says that it won't fix the Amex imports, two users reported on the bug that it actually does. Naturally it's right after the last release. We just need to get Benoit to do a new one. 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 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"
The XML file is (optionally, see Preferences>General) compressed with gzip. You might try reopening the database and see if it still takes 20 minutes. ISTR that there was a database upgrade somewhere around 2.6.12 and if so it would take a while to create the new tables, copy all of the records over, and clean up. On Windows you can either run GnuCash from a shell window (CMD or Powershell both work) with the path and any options, e.g. "C:\Program Files (x86)\gnucash\bin\gnucash.exe" --debug --nofile or if you want those options more permanently you can edit the command in the shortcut. Regards, John Ralls > On Sep 13, 2019, at 8:11 PM, GWB wrote: > > OK, will do. This is interesting. I moved the file to a Windows 7 > machine, and opened it with GnuCash 2.6.21. It did read the sqlite3 > file, but it took a long time, probably 20 minutes or so. After it > opened, I saved it as an xml file. GnuCash does open the .xml file > more quickly, so perhaps I should stick with that format. My > assumption is that Windows GnuCash reads and writes to sql formats > without installing those dependencies directly. > > So how do I start GnuCash in Windows using the --nofile --debug > options? It appears to always try to open the last opened file. > > I also notice the xml file is much, much smaller than the sqlite3 > file. The xml is 4.6 Megs, and the sqlite3 file is 65 megs. This is > a file with many years, going back to 2009, but the data all appears > to be there. That's not a bad feature, if it still has all the data. > And if xml it allows transaction "replays" or rollbacks, then great. > I'll stick with it. I'm a fan of data in db formats, but not when the > older xml format functions without errors. > > GnuCash 3 it is. I'll install the latest on Ubuntu and Windows and > see how it does with this xml file. > > Is there a file parser or checker that can correct errors in an > account file? I should give that a whirl and see what it finds. > > Thanks again, you guys rock, > > Gordon > > On Fri, Sep 13, 2019 at 9:59 PM John Ralls wrote: >> >> >> >>> On Sep 13, 2019, at 11:53 AM, GWB wrote: >>> >>> Hello, GnuCash Users, >>> >>> Gnucash will begin to start, then abort (crash) when launched, using >>> normal startup or gnucash --nofile --debug. Output from terminal is: >>> >>> $ gnucash --nofile --debug >>> Found Finance::Quote version 1.38 >>> ** >>> GLib:ERROR:/build/glib2.0-pjKWYQ/glib2.0-2.48.2/./glib/ghash.c:373:g_hash_table_lookup_node: >>> assertion failed: (hash_table->ref_count > 0) >>> Aborted (core dumped) >>> >>> So this is some kind of hash table assertion failure? I have the >>> gnucash.trace and apport bug reports as well, but before I send them I >>> thought I would ask if someone else has seen this. I can rollback to >>> an earlier version of the file, but I would like to get this >>> particular version working now. >>> >>> I might also copy the file to a Windows machine, and install GnuCash >>> there. Or, possible, copy and upgrade to GnuCash 3, and then try to >>> figure out how to move my reports. >>> >>> Any help is greatly appreciated! >>> >> >> It's basically a use-after-free situation. >> >> We're not maintaining the 2.6 branch anymore, so your best bet is to upgrade >> to GnuCash 3.7, the latest release. It's certainly buildable on Ubuntu >> 16.04, our 3.x CI uses Ubuntu 14.04, but the user-prepared .deb will >> probably not find the right dependencies. >> >> 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] (not) AQbanking setup crash
Please remember to copy the list on all replies. That's the one. Apple changes the name and layout periodically. The person I replied to is using Sierra and you're on Mojave. Also he was using 2.6.21 and your crash report says you've got 3.6. That backtrace looks familiar, too... Oh, yeah, here we are: https://bugs.gnucash.org/show_bug.cgi?id=797375 submitted 23 August by one "Dizzy" Deane Yamane. Maybe you know him? ;-) That bug is waiting for you to attach a trace file from a crash. Looks like you have a lot of crashes in your Console. Are they all the same? Regards, John Ralls > On Sep 11, 2019, at 3:31 PM, Deane Yamane wrote: > > Huh? … All I see on MacOS Mojave is this. I don’t see User Diagnostics. > > >> On Sep 10, 2019, at 5:52 AM, John Ralls wrote: >> >> >> >>> On Sep 9, 2019, at 7:33 PM, aegross wrote: >>> >>> I used to use aqbanking to download credit card transactions but stopped a >>> couple of years ago; it used to work but I don't recall what version of >>> GnuCash I was using then. >>> >>> Today, I tried using the aqbanking wizard and GnuCash crashed. I also tried >>> Actions\Online Actions\Show log window and that crashed GnuCash also. >>> >>> GnuCash version: 2.6.21 >>> MacOs version: Sierra (10.12.6). Owing to the age of the Mac, this is the >>> last recent version that Apple will support. >>> >>> I did some looking around for relevant documentation on how to debug but am >>> not having success. If anyone has any ideas, would be appreciated. >> >> The first step in debugging a crash on a Mac is to open >> /Applications/Utilities/Console, select User Diagnostics in the sidebar and >> find the Gnucash crash reports and examine them. >> >> GnuCash 2.6 is no longer supported and 2.6.21 has an old version of >> AQBanking as well. Please upgrade to 3.7, released last Sunday. If it still >> crashes file a bug report at https://bugs.gnucash.org and attach the crash >> report. >> >> 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] cryptocurrency with many decimals
Yes, you'll have to move XLM to the CURRENCY namespace. GnuCash *should* allow that since the symbol starts with X. Regards, John Ralls > On Sep 13, 2019, at 1:57 PM, Christian Pinedo Zamalloa > wrote: > > Yes, perhaps using XLM as the security/currency of Expenses:XLM is the > best approach. I tried it. However I can't set XLM as currency of the > Expenses:XLM account. I defined the XLM under "CCC" (cryptocurrency) > namespace and it seems that in a Expense account I can only select a > national currency under "Currencies" namespace. > > Do yo know, what I should have to do? to define XLM under "Currencies" > namespace, or a configuration change. > > Thanks! > > El vie., 13 sept. 2019 a las 20:02, John Ralls () > escribió: >> >> >> >>> On Sep 13, 2019, at 10:40 AM, Christian Pinedo Zamalloa >>> wrote: >>> >>> Hello, >>> >>> I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase >>> application so I received some free XLM cryptocoins that I would like >>> to account with gnucash. >>> >>> The problem I have is the number of decimals. Cryptocurrency uses up >>> to 7 decimals (11,1234567) and the price of the currency is often >>> available with 6 decimals, for example, yesterday's XLM/EUR price was >>> 0.052929 >>> (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) >>> >>> I configured an stock account in gnucash to track XLM coins: I set the >>> numbers I received with 7 decimals, I enter the price (this is round >>> to 4 decimals) and finally I get the value rounded to only 2 decimals >>> (this is the main problem). >>> >>> The problem I have is that I need to enter very low fees of 0,2 >>> XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So >>> these commissions are rounded to 0 € of value by gnucash and my >>> balance fails because I reduce the number of XML coins for 0 euros. >>> >>> What could I do to face it? Thanks! >> >> You need to change the commodity in your Expense:XML account to XML. >> Fractions of Euros (and any other real-world currency) smaller than 1/100 >> simply don't exist. >> >> Regards, >> John Ralls >> > > > -- > Christian Pinedo Zamalloa (zako) > PGP keyID: 0xdb577d4ee6ffbd55 > PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"
> On Sep 13, 2019, at 11:53 AM, GWB wrote: > > Hello, GnuCash Users, > > Gnucash will begin to start, then abort (crash) when launched, using > normal startup or gnucash --nofile --debug. Output from terminal is: > > $ gnucash --nofile --debug > Found Finance::Quote version 1.38 > ** > GLib:ERROR:/build/glib2.0-pjKWYQ/glib2.0-2.48.2/./glib/ghash.c:373:g_hash_table_lookup_node: > assertion failed: (hash_table->ref_count > 0) > Aborted (core dumped) > > So this is some kind of hash table assertion failure? I have the > gnucash.trace and apport bug reports as well, but before I send them I > thought I would ask if someone else has seen this. I can rollback to > an earlier version of the file, but I would like to get this > particular version working now. > > I might also copy the file to a Windows machine, and install GnuCash > there. Or, possible, copy and upgrade to GnuCash 3, and then try to > figure out how to move my reports. > > Any help is greatly appreciated! > It's basically a use-after-free situation. We're not maintaining the 2.6 branch anymore, so your best bet is to upgrade to GnuCash 3.7, the latest release. It's certainly buildable on Ubuntu 16.04, our 3.x CI uses Ubuntu 14.04, but the user-prepared .deb will probably not find the right dependencies. 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 slow response and logged faults in 2.6.21 to 3.7-1 conversion
Please remember to copy the list on all replies. Reply-all--the double-left-arrow icon--works well for this. I'm glad that you got GnuCash working to your satisfaction. Regards, John Ralls > On Sep 13, 2019, at 2:46 PM, Alton Brantley wrote: > > Thanks for the input, John > > I had moved my 2.6.21 to another folder, named Gnucash 2.6.21 and had run it > from there. Then I installed 3.7-1 into a new folder named Gnucash, and ran > it from there. That’s when it was sluggish and seemed not to be reading the > stored options incorrectly. > > I bit the bullet and deleted the Gnucash 2.6.21 folder and the older working > version and its subsidiary files stored in the “.app” bundle, rebooted my > machine, and ran the 3.7 version. It ran slow the first time I ran it loading > the data file. I then immediately exited the program back to Finder, and then > re-ran it. It came up much faster and the beachballs are gone. > > I suspect (but cannot verify or prove) that in some way the execution of the > program was being cross-linked with some components of the older version, > perhaps even symbolically or by a text parameter, and then having problems > running correctly. > > I do know for a fact that a lot of the software status is stored in the > “Defaults” space, the preference database. Deleting the older app may well > have made those text references fail, and therefore made the Defaults space > delete them, so that the second execution used either no info, and so found > them in its “.app” tree, and then loaded them into Defaults. > > Thanks again for taking a look at this. > > Alton > >> On Sep 12, 2019, at 2:16 PM, John Ralls wrote: >> >> >> >>> On Sep 12, 2019, at 5:42 AM, Alton Brantley >>> wrote: >>> >>> On Mac OS X 10.14.6, I’ve moved from Gnucash 2.6.21 to 3.7. All the data >>> look fine, BUT >>> >>> I get lots of beachballs as I move from one screen to the next, or even >>> scroll within a register. Looking at the logs, >>> I get lots of Gnucash process messages along the lines of >>> "found no value for key NSPersistentUIShowQuietSafeQuitStatus in >>> CFPrefsSearchListSource<0x630bed80> >>> (Domain: org.gnucash.Gnucash, Container: (null))” >>> >>> So it seems that the program is not finding something it expects and is >>> spending a lot of time in error or fault management. Any suggestions about >>> how to give the program what it needs for the keys for which it’s finding >>> no values? >> >> That's a new one. >> Google finds only one useful page about that, >> https://github.com/docker/for-mac/issues/1835 and after two years the Docker >> folks still haven't figured it out. >> >> Neither string is present in MacOS.10.14.sdk nor turns up anything for me >> when I search Console. >> >> Try using the spindump tool in /Applications/Utilities/ActivityMonitor (the >> gear icon) when GnuCash is beach-balling to get a snapshot of what's going >> on. >> >> 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] cryptocurrency with many decimals
> On Sep 13, 2019, at 10:40 AM, Christian Pinedo Zamalloa > wrote: > > Hello, > > I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase > application so I received some free XLM cryptocoins that I would like > to account with gnucash. > > The problem I have is the number of decimals. Cryptocurrency uses up > to 7 decimals (11,1234567) and the price of the currency is often > available with 6 decimals, for example, yesterday's XLM/EUR price was > 0.052929 > (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) > > I configured an stock account in gnucash to track XLM coins: I set the > numbers I received with 7 decimals, I enter the price (this is round > to 4 decimals) and finally I get the value rounded to only 2 decimals > (this is the main problem). > > The problem I have is that I need to enter very low fees of 0,2 > XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So > these commissions are rounded to 0 € of value by gnucash and my > balance fails because I reduce the number of XML coins for 0 euros. > > What could I do to face it? Thanks! You need to change the commodity in your Expense:XML account to XML. Fractions of Euros (and any other real-world currency) smaller than 1/100 simply don't exist. 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 slow response and logged faults in 2.6.21 to 3.7-1 conversion
> On Sep 12, 2019, at 5:42 AM, Alton Brantley wrote: > > On Mac OS X 10.14.6, I’ve moved from Gnucash 2.6.21 to 3.7. All the data look > fine, BUT > > I get lots of beachballs as I move from one screen to the next, or even > scroll within a register. Looking at the logs, > I get lots of Gnucash process messages along the lines of > "found no value for key NSPersistentUIShowQuietSafeQuitStatus in > CFPrefsSearchListSource<0x630bed80> > (Domain: org.gnucash.Gnucash, Container: (null))” > > So it seems that the program is not finding something it expects and is > spending a lot of time in error or fault management. Any suggestions about > how to give the program what it needs for the keys for which it’s finding no > values? That's a new one. Google finds only one useful page about that, https://github.com/docker/for-mac/issues/1835 and after two years the Docker folks still haven't figured it out. Neither string is present in MacOS.10.14.sdk nor turns up anything for me when I search Console. Try using the spindump tool in /Applications/Utilities/ActivityMonitor (the gear icon) when GnuCash is beach-balling to get a snapshot of what's going on. 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] Multi-select on import - OSX
> On Sep 11, 2019, at 2:55 AM, Ron Stone wrote: > > Thank you for all the hard work maintaining and developing Gnucash. I expect > running an open source project can feel thankless at times. The effort is > greatly appreciated. > > I have a quick question about the new multi-select on import feature. On OSX, > the default right-click is CTRL-tap, which is also one of the multi-select > options in the import dialog, When I make a multi selection (say, SHIFT-tap) > and then CTRL-tap it does not bring up the account select dialog. Instead, it > just unselects the entries in the multi-select except the one under the > pointer and brings up the account select dialog for the single entry. > > Am I missing something obvious here? If you have Secondary Click checked in System Preferences>Trackpad on the Point & Click tab then a two-finger tap should work to bring up the context menu. That won't help anyone using a one-button mouse. The problem is that GdkQuartz sends a GDK_BUTTON_PRIMARY with GDK_CONTROL_MASK instead of GDK_BUTTON_SECONDARY and GtkTreeView doesn't check GDK_CONTROL_MASK when handling the GDK_BUTTON_PRIMARY event. I've opened https://gitlab.gnome.org/GNOME/gtk/issues/2145 to document this. 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] AQbanking setup crash
> On Sep 9, 2019, at 7:33 PM, aegross wrote: > > I used to use aqbanking to download credit card transactions but stopped a > couple of years ago; it used to work but I don't recall what version of > GnuCash I was using then. > > Today, I tried using the aqbanking wizard and GnuCash crashed. I also tried > Actions\Online Actions\Show log window and that crashed GnuCash also. > > GnuCash version: 2.6.21 > MacOs version: Sierra (10.12.6). Owing to the age of the Mac, this is the > last recent version that Apple will support. > > I did some looking around for relevant documentation on how to debug but am > not having success. If anyone has any ideas, would be appreciated. The first step in debugging a crash on a Mac is to open /Applications/Utilities/Console, select User Diagnostics in the sidebar and find the Gnucash crash reports and examine them. GnuCash 2.6 is no longer supported and 2.6.21 has an old version of AQBanking as well. Please upgrade to 3.7, released last Sunday. If it still crashes file a bug report at https://bugs.gnucash.org and attach the crash report. 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 3.7 and Reports
> On Sep 9, 2019, at 11:03 AM, Adrien Monteleone
> wrote:
>
>> On Sep 9, 2019 w37d252, at 12:41 PM, John Morris wrote:
>>
>> Hi Adrien,
>> Thanks for looking into this issue as well. I will study the new procedure
>> for loading reports as soon as I am able.
>>
>>> 1. My invoices (editing/viewing) all pad to the width of the window no
>>> matter how I size it, so I’m not sure what you have going on. Maybe try
>>> double-clicking the description header and see if they don’t snap back to
>>> normal from then on. (I’m also on Mojave)
>>
>> I’m not sure, but I think we may be comparing apples and oranges. Yes, when
>> editing an invoice, the columns pad out to fill the window. The issue I was
>> reporting is about the printable invoice report. There are several options
>> to choose from (easy, fancy, technicolor and others I don’t recall). None of
>> them seem to pad out the _printable_ invoice to fill the page. Because these
>> are static reports, double clicking has no effect.
>
> Sorry, I misunderstood. But my Invoice Report also pads correctly. The entire
> item detail table just takes up more horizontal space when the descriptions
> get longer and the shorter description items all fall in line. (the entire
> table is sized the same and all columns line up) So I *really* am not sure
> where the problem lies. The report is just an HTML table. The widths are not
> fixed. (I don’t have a description that would line-wrap, but I’ll make
> something up to test.)
>
>>
>>> 2. I don’t have a copy of 2.6.x handy to see what it was doing, but indeed,
>>> the invoice # prints on the top left. This is because it is the ’title’ of
>>> the document.
>>>
>>> You can fix that in Options > Layout > CSS
>>>
>>> add this line:
>>>
>>> .invoice-title { float: right; }
>>>
>>> and Apply.
>>
>> I will try this fix as soon as I can. Is there any way to change it so the
>> invoice number is not the title of the document? I would rather be able to
>> put it down in the invoice details where I want it.
>
> Not without editing the Scheme report code, saving it as a custom report, and
> then loading it like Doug’s reports.
>
> For my own invoices, it appeared to look as if it were part of the invoice
> details. (above the invoice date and due date) Font selection and size should
> be able to make it appear that way. If you run into trouble attempting that
> with the built-in stylesheet editor, or aren’t familiar with CSS, shout back
> and I’ll see what I can come up with.
Note that the Invoice reports include a field in Options>Layout to add custom
CSS so you can style it however you like.
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] ISO 31-0 number writing
It should, provided that the Unix locale settings provided by the OS are correct. For example Apple has a long-standing error in their Swiss currency file that provides '.' and ',' for the thousands separator and decimal point respectively (the Swiss use ' ' and '.'). The ICU-based locale data are correct, which confuses users. Regards, John Ralls > On Sep 9, 2019, at 10:23 AM, Adrien Monteleone > wrote: > > David, > > I would second that notion against making it default. > > I see this as an issue of locale though, and it is only for display. (the > grouping space, like the grouping comma is not part of the data, or should > not be.) Also, Fiable notes the desire to copy/paste or import, so typing the > thin/narrow space wouldn’t be an issue, and that can be solved anyway with a > keyboard map and a higher level modifier key. > > Fiable, > > What is your locale setting in your OS? Do you have ‘grouping’ set to > ’space’? Is your default currency in GnuCash also one normally used in that > locale? I should think GnuCash would use that OS setting. (or should) > > Regards, > Adrien > > >> On Sep 9, 2019 w37d252, at 8:24 AM, David Carlson >> wrote: >> >> First, ISO 31-0 was withdrawn on 17 November 2009. It is superseded by ISO >> 8-1 <https://en.wikipedia.org/wiki/ISO_8-1>. Other parts of ISO 31 >> have also been withdrawn and replaced by parts of ISO 8 >> <https://en.wikipedia.org/wiki/ISO/IEC_8>. >> >> That standard suggests that large numbers with many digits be displayed as >> groups of three separated by a small space instead of dots or commas. We >> do not have small space characters on our keyboards, so that will be >> difficult to implement. >> >> I would also argue that in the U.S. average persons will adopt small spaces >> with the same fervor that they have adopted metric measures in general. >> >> While it would be ok to adopt this convention as an alternate in GnuCash, I >> am strongly against forcing the display to omit dots or commas as >> thousands separators. >> >> From Wikipedia " In Unicode <https://en.wikipedia.org/wiki/Unicode>, thin >> space is encoded at U+ >> <https://en.wikibooks.org/wiki/Unicode/Character_reference/2000-2FFF#ref_THSP> >> 2009 thin space (HTML *·* ). Unicode's U+ >> <https://en.wikibooks.org/wiki/Unicode/Character_reference/2000-2FFF#ref_NNBSP> >> 202F narrow no-break space >> <https://en.wikipedia.org/wiki/Narrow_no-break_space> (HTML ) >> is a non-breaking >> space <https://en.wikipedia.org/wiki/Non-breaking_space> with a width >> similar to that of the thin space." >> >> That's my 2 ¢. >> >> On Mon, Sep 9, 2019 at 6:40 AM Fiable.biz via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >>> Hello. >>> I suggest an option for the acceptance by GnuCash of the international >>> notation of numbers, as defined by ISO 31-0 standard and the 22nd General >>> Conference on Weights and Measures, which declared in 2003 that "the symbol >>> for the decimal marker shall be either the point on the line or the comma >>> on the line" and further reaffirmed that "numbers may be divided in groups >>> of three in order to facilitate reading; neither dots nor commas are ever >>> inserted in the spaces between groups".81 235,67 and 81 235.67 have the >>> same meaning and would both be accepted, but 81,235.67 would be refused. >>> Presently space is neither accepted in importing nor in pasting into >>> GnuCash. Moreover, if one has chosen the dot as decimal separator then the >>> coma is refused and vice versa... So I very often have to modify files in >>> LibreOffice before importing them into GnuCash, and to type figures I could >>> just copy and paste. > > ___ > 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] [GNC-dev] Announcement: GnuCash 3.7 Released
Snicker. Have you ever looked at https://github.com/Homebrew/homebrew-cask/blob/master/Casks/gnucash.rb? It just downloads Gnucash-Intel-X.Y.dmg from our Github project page. As for updating it, you'll have to ask https://github.com/pkryger. Looking at it did remind me that I should have included in the release notes that the dmg no longer has the FinanceQuote Update app because Apple won't notarize it. Notarizing is a requirement for installing on Catalina. Regards, John Ralls > On Sep 9, 2019, at 7:57 AM, Larry Beck via gnucash-user > wrote: > > Any ETA for Mac brew files to be updated to 3.7? > > > On 9/9/19 10:48 AM, boldstripe wrote: >> I successfully used these Disco .deb files to install Gnucash 3.7 into Debian >> Stable (Buster), after first uninstalling previous versions of the three >> files. >> >> I followed Stephen's original instructions. Thank you! >> >> >> >> -- >> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Announcement: GnuCash 3.7 Released
The GnuCash development team announces GnuCash 3.7, the eighth release of the 3.x stable release series. Changes Between 3.6 and 3.7, the following bugfixes were accomplished: • Bug 605602 - precision of Financial Calculator seems to depend on locale • Bug 746937 - Template transaction splits are loaded in reverse order and then not sorted before saving. Actually not sorted after loading because the template accounts weren't being committed. • Bug 752395 - Start Day of weekly report doesn't respond to change in locale Redefines some functions to ensure weekly grouping in transaction report obeys locale's start-of-week. • Bug 784623 - GNUCash does not work with sql backend, I can open in read only mode Upgrade the splits table as well, an oversight from the original fix. • Bug 793018 - Balance (with >>eguile<<) - Report Title can't be changed • Bug 795251 - googletest detection cannot be overridden • Bug 796819 - bad icon with Spanish localization Temporary fix for Farsi, which was afffected, too. As it is maintained by TP, the final fix has to come from them. • Bug 796952 - Report formatting (justify) is broken Preveious patch reverted and replaced with a more correct one. • Bug 797085 - Import Bills & Invoices – headers not translated. Make strings translatable. Translators: This adds 22 new translatable strings. • Bug 797158 - gnc:make-account-sel-limited-option is not working Option was being deliberately reset to default_value every time. • Bug 797279 - Reports RTL do not support RTL Fix guile-2.0 string handling to prevent munging unicode in report-titles etc. while loading/saving reports. • Bug 797295 - problems with entering swedish åäö in company address • Bug 797297 - GNUCash is in English even though MacOS is set-up to French. • Bug 797301 - Register Menu View > Refresh doesn't work in 'with subaccounts' window. • Bug 797306 - "URL cannot be shown" when one clicks an account line link in report. • Bug 797316 - New Mauritanian ouguiya MRU not supported • Bug 797319 - Mauritanian ouguiya MRO shows too few decimals • Bug 797339 - Online banking frame to small • Bug 797349 - "A"ssociate header badly translated. • Bug 797353 - Add copyright and release info in appdata file • Bug 797355 - General Journal report seems to be off balance Previously, for general-journal, each split was being analyzed, and only the source split was counted for totals. This change will means the source split *and* its peers were accounted for. • Bug 797377 - cmake fails on debian-8 and ubuntu-14.04 with gnucash.appdata.xml.in does not exist • Bug 797378 - QIF file import fails: Loading gives wrong type argument in position 2 • Bug 797389 - Random Crashes while attaching a document. The following fixes and improvements were not associated with bug reports: • New feature: Multiselection in the import transaction matcher. Use control-left-click, shift-left-click, or click-and-drag to select multiple unmatched transactions to match them with a single account, then right-click to bring up a single-item context menu sith "Assign Transfer Account". • Set a FinTS product version key when the installed AQBanking supports it. • Change translatable strings with context to use the modern gettext three-parameter function instead of the ':' hack. • Stop duplicate entries for the invoice taxtable cell. • Do not log an error when no default tax tables are set. • Fix cmake dependency tree so that make/ninja check works without having to first run make/ninja. • Remove the accelerator for the Clear buttons on the Loan Calculator because they were all the same and also the same as the Close button's accelerator. • Change the transfer account notation for single-split transactions in basic view from "--Split Transaction--" (they're obviously not) to "None". • Correctly parse decimal values between 0 and -1 (e.g. -0.5) in register caclulations: The negative sign was being stripped. • Require CMake 3.5 or later for all platforms. • Rework the building of libgtest.a from source when the builder sets GTEST_ROOT or the distro doesn't provide a pre-build one. • Fix crash when trying to display a tooltip in the register split view when a split has focus. • Fix repeated requests to create a new account when you click No. • Suppress bogus error when creating a new account from register split view. • Fix price conversion report crashes in Balance Sheet PNL and all average balance calculations. • Upgrade the Budget reports to support accumulated accounts. • Redefine gnc:debug to use QofLog instead of writing to stdout. • Change the Balance Sheet PNL account depth to mean the deepest *selected
Re: [GNC] Gnucash doesn't load American Express QFX files
IIRC libofx doesn't support OFX2000+, which is XML instead of SGML. Regards, John Ralls > On Sep 7, 2019, at 4:39 PM, Ronal B Morse wrote: > > Maybe what I do is a little different. > > After logging in to Amex and navigating to the Statements and Activity Page, > I click on the green download icon from the pages toolbar and select card > activity from that drop down. > > A new paged opens automatically and on that page I select "Quicken" from the > options in the left pane then scroll down the page to find the date range > selection section in the right pane. Today I clicked on the "Individual > statements available to download" radio button then selected checked "Aug 15 > to Present" since I downloaded about a week ago. > > Clicking on the blue "download" button results in a file named ofx.qfx in my > downloads folder and that is the file I inport into Gnucash. > > Hope this helps > > RBM > > On 9/7/19 4:43 PM, Jim Leek wrote: >> I just tried to download from AmericanExpress again. I still have the same >> problem. I'm just clicking the little download icon next to my activity on >> the "Statements and Activity" page. Maybe there's another method? >> >> With GnuCash 3.6 I was able to import from CSV. That's a hassle, but the >> import page is much better than was on Gnucash 2.6, so kudos to whoever made >> that. >> >> Jim >> >> On Sat, Sep 7, 2019 at 3:26 PM Ronal B Morse > <mailto:r...@morsehouse.com>> wrote: >> >>FWIW, I just downloaded my AMEX card activity with no problems or >>unusual results, beyond that it always takes me awhile to find the >>correct download portal. Maybe just a transient problem on the >>server end? >> >>RBM >> >>On 9/7/19 2:46 PM, Jim Leek wrote: >>> I got this error using both Gnucash 2.6.19 and 3.6 on Linux Mint >>19 with >>> libofx7 from the Ubuntu repositories. >>> >>> I have been using Gnucash for many years, and this is the first >>time I've >>> ever had trouble with American Express. >>> >>> Actually aqbanking couldn't communicate with american express >>for the first >>> time, I got the error: >>> Status for transaction statement request: Account not found >>(Code 2003, >>> severity "ERROR") >>> But that's not what I'm writing about. >>> >>> I logged into the website and downloaded the QFX file, but could >>not import >>> it. I get the following error. >>> >>> LibOFX INFO: libofx_proc_file(): File format not specified, >>autodetecting... >>> (Above message occurred on Line 2815, Column 1) >>> LibOFX ERROR: libofx_detect_file_type(): Failed to identify >>input file >>> format >>> (Above message occurred on Line 2815, Column 1) >>> LibOFX INFO: libofx_proc_file(): Detected file format: UNKNOWN >>(File format >>> couldn't be successfully identified) >>> (Above message occurred on Line 2815, Column 1) >>> LibOFX ERROR: libofx_proc_file(): Detected file format not yet >>supported ou >>> couldn't detect file format; aborting. >>> (Above message occurred on Line 2815, Column 1) >>> >>> >>> Here is a sanitized version of the troublesome QFX file: >>> >>> >VERSION="202" >>> SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>>xmlns:ns2=" >>> >> >> http://ofx.net/types/2003/04";>0INFOLogin >>> >> >> Successful!2019090700.000[-7:MST]ENGAMEX3101310100INFOUSD52019081900.000[-7:MST]2019091700.000[-7:MST]DEBIT2019090300.000[-7:MST]-5.963201924704200838863886GODEBIT2019082800.000[-7:MST]-5.713201924002972419971997ABEDEBIT2019082400.000[-7:MST]-18.753201923602295056635663>> >> >> E>SPDEBIT2019082200.000[-7:MST]-44.093201923401947735603560CARDEBIT2019082200.000[-7:MST]-72.303201923502195209780978KODEBIT2019082200.000[-7:MST]-34.683201923502162871327132SA-2715.882019090700.000[-7:MST] >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >>> To update your subscription preferences o
Re: [GNC] USAA accounts no longer receive balance or transactions
Works fine on a Mac, GnuCash 3.6, aqbanking 5.7.8: Just tested on both the aforementioned credit card and on a bank account. Might be a Fedora problem: The -2 and -3 on the aqbanking versions means that the Fedora Packager has patched AQBanking. Regards, John Ralls > On Sep 7, 2019, at 10:45 AM, D Ducky wrote: > > Ok, > > I just confirmed that it's something with gnucash or aqbanking: > > On another machine, with duplicate books and configurations, with gnucash: > > gnucash-3.4-1.fc29.x86_64 > > aqbanking-5.7.8-2.fc29.x86_64 > > it works fine, for balance and transactions > > however on > > gnucash-3.6-1.fc30.x86_64 > > aqbanking-5.7.8-3.fc30.x86_64 > > --- > > No balance, no transactions for USAA accounts. > > On 9/7/19 7:43 PM, D Ducky wrote: >> I just tried another USAA checking account, specified 7/7/2019 to 9/7/2019 >> >> and it says >> >> "the online banking import returned no transactions for the time period." >> >> Not sure what is going on. >> >> On 9/7/19 6:57 PM, John Ralls wrote: >>> Yes. >>> >>> Regards, >>> John Ralls >>> >>> >>>> On Sep 7, 2019, at 7:13 AM, D Ducky wrote: >>>> >>>> Thanks for the response. I tried adjusting the dates, to no avail. >>>> >>>> Do you have the certificate prompt each time? >>>> >>>> Thank you, >>>> >>>> On 9/7/19 5:08 PM, John Ralls wrote: >>>>>> On Sep 7, 2019, at 5:00 AM, DaCappie wrote: >>>>>> >>>>>> Hello, >>>>>> >>>>>> Starting about a week or so ago, after around 8 or so years using USAA >>>>>> accounts with Gnucash, I cannot get transactions or balance. It says no >>>>>> transactions available, and it does nothing when I ask for balance. It >>>>>> does >>>>>> this for ALL USAA accounts(checking, savings, credit, etc). >>>>>> >>>>>> It still works fine for Chase credit card, etc. >>>>>> >>>>>> I've always gotten the certificate prompt, but even when I click yes to >>>>>> accept, it shows nothing. >>>>>> >>>>>> Here's the output from transaction request: >>>>>> >>>>>> AqBanking v5.7.8.0stable >>>>>> Sending jobs to the bank(s) >>>>>> Locking user >>>>>> Sending request... >>>>>> Connecting to server... >>>>>> Resolving hostname "service2.usaa.com" ... >>>>>> IP address is "184.28.3.56" >>>>>> Connecting to "service2.usaa.com" >>>>>> Connected to "service2.usaa.com" >>>>>> Using GnuTLS default ciphers. >>>>>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD >>>>>> Signer not found >>>>>> Certificate is not trusted >>>>>> Connected. >>>>>> Sending message... >>>>>> Message sent. >>>>>> Waiting for response... >>>>>> Receiving response... >>>>>> HTTP-Status: 200 (OK) >>>>>> Response received. >>>>>> Disconnecting from server... >>>>>> Disconnected. >>>>>> Parsing response... >>>>>> Parsing response >>>>>> Unlocking user >>>>>> Postprocessing jobs >>>>>> Job Get Transactions: finished >>>>>> Resetting provider queues >>>>>> --- >>>>>> >>>>>> It says no transactions during that time. >>>>>> >>>>>> For balance: >>>>>> >>>>>> AqBanking v5.7.8.0stable >>>>>> Sending jobs to the bank(s) >>>>>> Locking user >>>>>> Sending request... >>>>>> Connecting to server... >>>>>> Resolving hostname "service2.usaa.com" ... >>>>>> IP address is "184.28.3.56" >>>>>> Connecting to "service2.usaa.com" >>>>>> Connected to "service2.usaa.com" >>>>>> Using GnuTLS default ciphers. >>>>>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD >>>>>> Signer not found >>>>>> Certificate is not trusted >>>>>> Connected. >>>>>> Sending message... >>>>>> Message sent. >>>>>> Waiting for response... >>>>>> Receiving response... >>>>>> HTTP-Status: 200 (OK) >>>>>> Response received. >>>>>> Disconnecting from server... >>>>>> Disconnected. >>>>>> Parsing response... >>>>>> Parsing response >>>>>> Unlocking user >>>>>> Postprocessing jobs >>>>>> Job Get Balance: finished >>>>>> Resetting provider queues >>>>> Maybe a glitch at usaa.com? I had no trouble getting my credit card >>>>> transactions from there on Tuesday. >>>>> >>>>> Do note that you need to adjust the dates when you retry a download. >>>>> AQBanking defaults to starting at the time of the last download attempt, >>>>> successful or not. >>>>> >>>>> 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] USAA accounts no longer receive balance or transactions
Yes. Regards, John Ralls > On Sep 7, 2019, at 7:13 AM, D Ducky wrote: > > Thanks for the response. I tried adjusting the dates, to no avail. > > Do you have the certificate prompt each time? > > Thank you, > > On 9/7/19 5:08 PM, John Ralls wrote: >>> On Sep 7, 2019, at 5:00 AM, DaCappie wrote: >>> >>> Hello, >>> >>> Starting about a week or so ago, after around 8 or so years using USAA >>> accounts with Gnucash, I cannot get transactions or balance. It says no >>> transactions available, and it does nothing when I ask for balance. It does >>> this for ALL USAA accounts(checking, savings, credit, etc). >>> >>> It still works fine for Chase credit card, etc. >>> >>> I've always gotten the certificate prompt, but even when I click yes to >>> accept, it shows nothing. >>> >>> Here's the output from transaction request: >>> >>> AqBanking v5.7.8.0stable >>> Sending jobs to the bank(s) >>> Locking user >>> Sending request... >>> Connecting to server... >>> Resolving hostname "service2.usaa.com" ... >>> IP address is "184.28.3.56" >>> Connecting to "service2.usaa.com" >>> Connected to "service2.usaa.com" >>> Using GnuTLS default ciphers. >>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD >>> Signer not found >>> Certificate is not trusted >>> Connected. >>> Sending message... >>> Message sent. >>> Waiting for response... >>> Receiving response... >>> HTTP-Status: 200 (OK) >>> Response received. >>> Disconnecting from server... >>> Disconnected. >>> Parsing response... >>> Parsing response >>> Unlocking user >>> Postprocessing jobs >>> Job Get Transactions: finished >>> Resetting provider queues >>> --- >>> >>> It says no transactions during that time. >>> >>> For balance: >>> >>> AqBanking v5.7.8.0stable >>> Sending jobs to the bank(s) >>> Locking user >>> Sending request... >>> Connecting to server... >>> Resolving hostname "service2.usaa.com" ... >>> IP address is "184.28.3.56" >>> Connecting to "service2.usaa.com" >>> Connected to "service2.usaa.com" >>> Using GnuTLS default ciphers. >>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD >>> Signer not found >>> Certificate is not trusted >>> Connected. >>> Sending message... >>> Message sent. >>> Waiting for response... >>> Receiving response... >>> HTTP-Status: 200 (OK) >>> Response received. >>> Disconnecting from server... >>> Disconnected. >>> Parsing response... >>> Parsing response >>> Unlocking user >>> Postprocessing jobs >>> Job Get Balance: finished >>> Resetting provider queues >> Maybe a glitch at usaa.com? I had no trouble getting my credit card >> transactions from there on Tuesday. >> >> Do note that you need to adjust the dates when you retry a download. >> AQBanking defaults to starting at the time of the last download attempt, >> successful or not. >> >> 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] USAA accounts no longer receive balance or transactions
> On Sep 7, 2019, at 5:00 AM, DaCappie wrote: > > Hello, > > Starting about a week or so ago, after around 8 or so years using USAA > accounts with Gnucash, I cannot get transactions or balance. It says no > transactions available, and it does nothing when I ask for balance. It does > this for ALL USAA accounts(checking, savings, credit, etc). > > It still works fine for Chase credit card, etc. > > I've always gotten the certificate prompt, but even when I click yes to > accept, it shows nothing. > > Here's the output from transaction request: > > AqBanking v5.7.8.0stable > Sending jobs to the bank(s) > Locking user > Sending request... > Connecting to server... > Resolving hostname "service2.usaa.com" ... > IP address is "184.28.3.56" > Connecting to "service2.usaa.com" > Connected to "service2.usaa.com" > Using GnuTLS default ciphers. > TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD > Signer not found > Certificate is not trusted > Connected. > Sending message... > Message sent. > Waiting for response... > Receiving response... > HTTP-Status: 200 (OK) > Response received. > Disconnecting from server... > Disconnected. > Parsing response... > Parsing response > Unlocking user > Postprocessing jobs > Job Get Transactions: finished > Resetting provider queues > --- > > It says no transactions during that time. > > For balance: > > AqBanking v5.7.8.0stable > Sending jobs to the bank(s) > Locking user > Sending request... > Connecting to server... > Resolving hostname "service2.usaa.com" ... > IP address is "184.28.3.56" > Connecting to "service2.usaa.com" > Connected to "service2.usaa.com" > Using GnuTLS default ciphers. > TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD > Signer not found > Certificate is not trusted > Connected. > Sending message... > Message sent. > Waiting for response... > Receiving response... > HTTP-Status: 200 (OK) > Response received. > Disconnecting from server... > Disconnected. > Parsing response... > Parsing response > Unlocking user > Postprocessing jobs > Job Get Balance: finished > Resetting provider queues Maybe a glitch at usaa.com? I had no trouble getting my credit card transactions from there on Tuesday. Do note that you need to adjust the dates when you retry a download. AQBanking defaults to starting at the time of the last download attempt, successful or not. 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.
