Re: [GNC] Corrupt security information
Bruno, Ugh, the lot scrubber. Another variable in the problem. Now I'm confused about the two trading accounts because you say that you've got 5 trades in the asset account and each trading account. Do you have splits both INTC trading accounts for one transaction? What about Trading:CURRENCY:USD? Regards, John Ralls > On Jan 5, 2020, at 3:17 PM, Bruno Acklin wrote: > > I don’t think I have more than one asset account for INTC, and none of the > trading accounts shows any transactions outside of the one I am using. > I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash would > have let me), but I may have edited / moved it from NYSE to INTC in the > security editor (which answers my last question, I guess ;-). > No worries, only about 5 trades in the asset account (and each trading > account); I am mostly worried about loosing 20 years of pricing history, > which is why I was looking for a way to export. > > The issue came up when I started using Actions/View lots for calculating cap > gains (working, but would need some work, such as an indication of the > purchase date or lot in the automated entry, or way to define/edit a new lot, > I think..) > > Best regards, > Bruno > > > > >> On Jan 5, 2020, at 2:56 PM, John Ralls wrote: >> >> That's interesting. Do you have more than one INTC asset account, perhaps >> with different brokers (and perhaps hidden on your Accounts page either >> because you marked it hidden or have hide accounts with 0 balances turned >> on)? When you realized that INTC trades on NASDAQ and not NYSE did you edit >> the security or make a new one? >> >> How many transactions are in each account? >> >> Regards, >> John Ralls >> >>> On Jan 5, 2020, at 2:34 PM, Bruno Acklin wrote: >>> >>> Thanks John, >>> >>> I had a suspicion that this may be due to an ambiguous trading account: I >>> had noticed that originally some transactions appeared under NYSE/INTC >>> while my present security and prices are all under NASDAQ/INTC. There is no >>> security defined under NYSE/INTC, but there is a trading account with that >>> name (which has correct transactions and behaves normally), and one under >>> Trading/NASDAQ/INTC with phony transactions ($number in the increase column >>> instead of INTC shares), which is also caught in a rebalance loop. >>> >>> Should I just delete one of the two trading accounts, and which one? I lean >>> towards the NASDAQ one with the phony entries and then try to move INTC >>> from NYSE to NASDAQ - how? >>> >>> Best regards, >>> Bruno >>> >>> >>> >>> >>> >>>> On Jan 5, 2020, at 11:22 AM, John Ralls wrote: >>>> >>>> Bruno, >>>> >>>> Don't do anything drastic yet, but everything is pretty independent. You >>>> could change the name on the old INTC and create a new INTC security and >>>> GnuCash will happily use your INTC prices for pricing the new security. >>>> They're linked by the security name and namespace, not by GUID. >>>> Unfortunately GnuCash won't let you reassign the account but you can >>>> create a new one and transfer the balance with a transaction. >>>> >>>> Regards, >>>> John Ralls >>>> >>>>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin wrote: >>>>> >>>>> Hi John, >>>>> >>>>> Thanks for the impressively quick reply - and yes, I agree this looks >>>>> like the same problem! >>>>> Unfortunately there does not seem to be another fix than recreating the >>>>> stock, account and transactions.. >>>>> >>>>> Do you know of a way I might preserve the 20 years of price data I have >>>>> on that stock? I saw a suggestion to create a suitable report and >>>>> reimport the resulting file, but I dd not see any report that would allow >>>>> me to save price information. >>>>> >>>>> Best regards, >>>>> Bruno Acklin >>>>> (408) 425 4753 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> On Jan 4, 2020, at 7:43 PM, John Ralls wrote: >>>>>> >>>>>> >>>>>> >>>>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin wrote: >>>>>>> >>>>>>>
Re: [GNC] Corrupt security information
That's interesting. Do you have more than one INTC asset account, perhaps with different brokers (and perhaps hidden on your Accounts page either because you marked it hidden or have hide accounts with 0 balances turned on)? When you realized that INTC trades on NASDAQ and not NYSE did you edit the security or make a new one? How many transactions are in each account? Regards, John Ralls > On Jan 5, 2020, at 2:34 PM, Bruno Acklin wrote: > > Thanks John, > > I had a suspicion that this may be due to an ambiguous trading account: I had > noticed that originally some transactions appeared under NYSE/INTC while my > present security and prices are all under NASDAQ/INTC. There is no security > defined under NYSE/INTC, but there is a trading account with that name (which > has correct transactions and behaves normally), and one under > Trading/NASDAQ/INTC with phony transactions ($number in the increase column > instead of INTC shares), which is also caught in a rebalance loop. > > Should I just delete one of the two trading accounts, and which one? I lean > towards the NASDAQ one with the phony entries and then try to move INTC from > NYSE to NASDAQ - how? > > Best regards, > Bruno > > > > > >> On Jan 5, 2020, at 11:22 AM, John Ralls wrote: >> >> Bruno, >> >> Don't do anything drastic yet, but everything is pretty independent. You >> could change the name on the old INTC and create a new INTC security and >> GnuCash will happily use your INTC prices for pricing the new security. >> They're linked by the security name and namespace, not by GUID. >> Unfortunately GnuCash won't let you reassign the account but you can create >> a new one and transfer the balance with a transaction. >> >> Regards, >> John Ralls >> >>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin wrote: >>> >>> Hi John, >>> >>> Thanks for the impressively quick reply - and yes, I agree this looks like >>> the same problem! >>> Unfortunately there does not seem to be another fix than recreating the >>> stock, account and transactions.. >>> >>> Do you know of a way I might preserve the 20 years of price data I have on >>> that stock? I saw a suggestion to create a suitable report and reimport the >>> resulting file, but I dd not see any report that would allow me to save >>> price information. >>> >>> Best regards, >>> Bruno Acklin >>> (408) 425 4753 >>> >>> >>> >>> >>> >>>> On Jan 4, 2020, at 7:43 PM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin wrote: >>>>> >>>>> Best wishes for 2020! >>>>> >>>>> I am struggling with a stock account, where I am unable to enter any >>>>> valid transactions, and suspect the security information may be corrupted: >>>>> >>>>> Whenever I enter a trade from the account (declared as stock for an >>>>> existing security INTC) and press return, Gnucash completes a transaction >>>>> (cf attachment), which looks ok, except there is no shares traded and >>>>> there is no way to enter any quantity on the trading account. Gnucash >>>>> insists on balancing the transaction, after which there is a huge number >>>>> in the trading/share account, but still no quantity of shares traded, and >>>>> no way to complete the transaction, other than closing the account tab. >>>>> >>>>> I checked the security and my price information which looks ok and >>>>> updates w/ finance::quote. If I have to recreate the account and reenter >>>>> all transactions, I’d like to save the historic price information, but >>>>> don’t know of a way to export it. >>>>> >>>> >>>> That sounds like a variation on >>>> https://bugs.gnucash.org/show_bug.cgi?id=797512. >>>> >>>> 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] Corrupt security information
Bruno, Don't do anything drastic yet, but everything is pretty independent. You could change the name on the old INTC and create a new INTC security and GnuCash will happily use your INTC prices for pricing the new security. They're linked by the security name and namespace, not by GUID. Unfortunately GnuCash won't let you reassign the account but you can create a new one and transfer the balance with a transaction. Regards, John Ralls > On Jan 5, 2020, at 9:37 AM, Bruno Acklin wrote: > > Hi John, > > Thanks for the impressively quick reply - and yes, I agree this looks like > the same problem! > Unfortunately there does not seem to be another fix than recreating the > stock, account and transactions.. > > Do you know of a way I might preserve the 20 years of price data I have on > that stock? I saw a suggestion to create a suitable report and reimport the > resulting file, but I dd not see any report that would allow me to save price > information. > > Best regards, > Bruno Acklin > (408) 425 4753 > > > > > >> On Jan 4, 2020, at 7:43 PM, John Ralls wrote: >> >> >> >>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin wrote: >>> >>> Best wishes for 2020! >>> >>> I am struggling with a stock account, where I am unable to enter any valid >>> transactions, and suspect the security information may be corrupted: >>> >>> Whenever I enter a trade from the account (declared as stock for an >>> existing security INTC) and press return, Gnucash completes a transaction >>> (cf attachment), which looks ok, except there is no shares traded and there >>> is no way to enter any quantity on the trading account. Gnucash insists on >>> balancing the transaction, after which there is a huge number in the >>> trading/share account, but still no quantity of shares traded, and no way >>> to complete the transaction, other than closing the account tab. >>> >>> I checked the security and my price information which looks ok and updates >>> w/ finance::quote. If I have to recreate the account and reenter all >>> transactions, I’d like to save the historic price information, but don’t >>> know of a way to export it. >>> >> >> That sounds like a variation on >> https://bugs.gnucash.org/show_bug.cgi?id=797512. >> >> 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] Corrupt security information
> On Jan 4, 2020, at 6:39 PM, Bruno Acklin wrote: > > Best wishes for 2020! > > I am struggling with a stock account, where I am unable to enter any valid > transactions, and suspect the security information may be corrupted: > > Whenever I enter a trade from the account (declared as stock for an existing > security INTC) and press return, Gnucash completes a transaction (cf > attachment), which looks ok, except there is no shares traded and there is no > way to enter any quantity on the trading account. Gnucash insists on > balancing the transaction, after which there is a huge number in the > trading/share account, but still no quantity of shares traded, and no way to > complete the transaction, other than closing the account tab. > > I checked the security and my price information which looks ok and updates w/ > finance::quote. If I have to recreate the account and reenter all > transactions, I’d like to save the historic price information, but don’t know > of a way to export it. > That sounds like a variation on https://bugs.gnucash.org/show_bug.cgi?id=797512. 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/AqBanking headaches
> On Dec 18, 2019, at 8:15 AM, brakechute wrote: > > Hello all. Been searching the list but couldn't find this issue so I may > have broken things in a new way. :) > > I have been using GnuCash 3.7 on a Windows 7 system (yeah, Windows) and have > just been importing transactions from CSV up to now. This is a clunky > process as the files from my banks need to be edited in Calc before I can > successfully import them. I decided to try the online banking feature and > failed miserably. I have tried to follow the guidelines in the wiki but must > be missing something, hopefully someone familiar with this can point it out. > > So, I start the wizard and "create user", select the "OFX DirectConnect", > find the bank in the list. I put in my name, the user name at the bank, and > have tried both leaving the UUID blank and inserting a generic one. I have > tried multiple emulations and get the same result every time: > Retrieving SSL certificate > Connecting to server... > Using GnuTLS default ciphers. > And at this point GnuCash crashes out. > > I have tried running as a user and running privileged with the same result. > When I restart and go back to the wizard a new user is in the list, but > cannot be deleted (Error deleting user -109). I just can't get anything to > set up. Anyone have any thoughts? Thanks in advance. I doubt that running as an admin would make a difference. Make sure that you're really using 3.7 or earlier for OFX Direct Connect. Go to https://ofxhome.com and look up your bank. At the bottom of the record make sure that it has validated within the last week or two: If it hasn't the publicly available OFX setup information is at best stale, but more likely they no longer support OFX Direct Connect or have adopted new software that will only talk to Quicken. Some of the banks in that last category have adopted software that doesn't actually use OFX Direct Connect: One bank with which I do business has a note on their website saying that the file exchange format is the Intuit-proprietary QDF. It wouldn't surprise me at all to learn that a stream of that would crash AQBanking and take GnuCash out with it. Does your bank offer OFX, QFX, or QIF downloads? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8 AQBanking in the US
No. OFX Direct Connect is a way of connecting GnuCash directly to the bank and retrieving the account, balance, and transaction data directly into GnuCash. In addition to a working AQBanking it requires that your bank provide the service and that it reveals enough information that you can configure AQBanking to connect to it. Regards, John Ralls > On Jan 3, 2020, at 8:56 AM, David Carlson wrote: > > Is OFX Direct Connect linked to simple OFX or QFX downloads that are provided > by many US banks as one of the three ways that data can be funneled through > Intuit Software, hopefully to GnuCash instead of Quicken? > > In other words, has Intuit found a way to kill OFX as an open source tool? > > David Carlson > > On Fri, Jan 3, 2020 at 10:43 AM John Ralls wrote: > > > > On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: > > > > John Ralls writes: > > > >> I don't know how much of that's fixable from GnuCash. Martin said last > >> week that he's suspended development of OFX so anything that isn't is > >> presumably broken forever. > > > > Did he give a reason for suspending OFX development? > > Yes: > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html > > Regards, > John Ralls > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > -- > David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8: Budget "total" field
Switching users isn't onerous as long as you use simple passwords--you do have to type it every time you switch--and it's easy to create a folder in your main user's $HOME to collect stuff: https://support.apple.com/guide/mac-help/control-access-to-your-public-folder-on-mac-mchlp1775/mac. If that's still too much trouble you can set GNC_DATA_DIR and GNC_CONFIG_DIR in the non-production bundle's Contents/Resources/etc/gnucash/environment to point somewhere other than ~/Library/Application Support/Gnucash. Preferences go to ~/Library/Preferences/org.gnucash.Gnucash no matter what, but that's probably not a concern in most cases. Regards, John Ralls > On Jan 3, 2020, at 9:45 AM, Adrien Monteleone > wrote: > > I’m considering that approach, but that would mean switching users just for > testing. I suppose I could set up some sort of common folder to save screen > shots and crash reports as I don’t want to have activity in the test user not > be available to me in my main account. If Mac had some sort of container > system like linux or if I could easily run it in a VM (without a large GB > virtual disk) I’d prefer that route but that doesn’t seem possible right now. > > Regards, > Adrien > >> On Jan 3, 2020 w1d3, at 4:04 AM, Michael Hendry >> wrote: >> >>> On 3 Jan 2020, at 01:35, Adrien Monteleone via gnucash-user >>> wrote: >>> >>> I thought that was discussed, but delving into the bug threads and others >>> linked therein, I see the issue a bit more clearly. >>> >>> Certainly, I think the current underlying approach is the more sane one >>> long term with a few kinks to be worked out. >>> >>> I (sadly and apologetically) still haven’t worked out a way to test dev >>> versions on MacOS without disrupting my normal installation, but I can test >>> non-OS specific changes via VMs. (I can certainly build maint or other >>> branches in Ubuntu) If anyone has any suggestions or tips for testing maint >>> and other builds on the MacOS front *without disturbing my normal stable >>> installation* , they are certainly appreciated. >> >> I haven’t tried this, but why not create a new user (e.g. “GCTest”) and run >> any experimental versions as that user. This would protect your own .gnucash >> files and configuration settings, as these are per-user, not per-computer. >> >> Michael >> >>> >>> I’m getting ready next week to work on my 2020 budgets, so now would be a >>> good time to do some testing. >>> >>> Let me know what types of things you’d like to see answers to and I’ll do >>> what I can. (in a Linux version for now, as noted) >>> >>> Regards, >>> Adrien > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8 AQBanking in the US
> On Jan 3, 2020, at 7:09 AM, Derek Atkins wrote: > > John Ralls writes: > >> I don't know how much of that's fixable from GnuCash. Martin said last >> week that he's suspended development of OFX so anything that isn't is >> presumably broken forever. > > Did he give a reason for suspending OFX development? Yes: https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088350.html Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple GnuCash Rev Installations
> On Jan 3, 2020, at 5:25 AM, Greg Feneis wrote: > > Hi, > > Somebody replied to a comment I made about not being able to install an > updated GnuCash alongside an older GnuCash, but I lost track of the > response. It seemed to relay a variety of ways they were able to achieve > multiple installations, but I was unable to discern any information on how > that was done. > > My wish for the ability to have multiple installations was for the > installer dialog to allow this as an option, for anyone to use. I haven't > installed GnuCash in a while, but the last time I did, the installer > uninstalled the previous installation without an option to leave it there. > At the time, I enquired about this very thing and was told it's not an > option. > > What's the secret? You're probably not going to like this: The secret is to get a Mac. That's because on Macs most applications are self-contained bundles containing all of their non-system dependencies and there's no os-maintained list keeping track of them. To have multiple installs on Windows or Linux one must bypass the application/package management system by building and installing GnuCash oneself, a task that's beyond the skills of most users. 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 V3.x NSTextInputClient protocol non-compliance
> On Jan 2, 2020, at 8:43 PM, KUSUMOTO Norio wrote: > > Hi, > > >> Please remember to copy the list in all replies. > > I am sorry that my reply is to both an individual and this mailing list. This > happened > because I didn't realize that the mailing list was not included in the > original reply > you wrote. This can be confirmed by the fact that your first reply is not > included in > the mailing list archive. ;-) Indeed it doesn't. Sorry, I should pay closer attention to my own mail. > > >> A long keypress just types the letter when I use the US keyboard. > > I think this is because the reproduction method was not well conveyed to you > because my expression was inappropriate. In particular, my expression of > "KEYBOARD" > was bad. > > I prepared an image to show that. > > <https://twitter.com/kusumotoukulele/status/1212898597722718208> No, that wasn't the problem: Windows uses keyboard for that and I understood that you meant the US key layout. I use the option key to select keys and wasn't familiar with the held key method of character selection. I found https://support.apple.com/en-us/HT201586 that explains that it applies only to letters with variations. In western languages that's the vowels plus y, s, l, z, c, and m. My randomly-selected letters to test it weren't on the list so I didn't get it. > > >> The Gtk input module is >> https://gitlab.gnome.org/GNOME/gtk/blob/gtk-3-24/modules/input/imquartz.c >> and it mostly wraps NSTextInputClient. It hasn't been updated in a few years >> and so it has gotten a little out of sync with Apple's code, but the problem >> with tab, return, and arrow keys is GnuCash's fault: For the most part I >> think that the IM works correctly except in the register, but you're a far >> better judge of that than I am. Does it work the way you expect in dialog >> boxes? > > Oh! it's not so bad that the text input in the dialog box. > This is a bright spot for improving Gnucash 3.x. If we can mediate between IM > and > Gnucash for events, we can improve the situation. > > It was my misunderstanding that the item of the account does not accept the > conversion > separator by the cursor key. However, I can't do it in dialog boxes. > > The variation input by holding down the 'a' key is also accepted in the text > input > area of the dialog box, but there is a problem that the original 'a' is left > in addition > to the selected characters. It seems to me that 'replacementRange' does not > work well. > The problems with input everywhere but the register are Gtk imquartz.c problems. Let's work out the register problems first and then we can create an issue at gitlab.gnome.org and work on imquartz.c. ISTM that the biggest problem is GnuCash grabbing the tab, return, and arrow keys when you're trying to select a character. That strikes me as a keyboard focus problem: The IM's selection window should be getting those key events; the reason is probably that event response in Cocoa is bottom-up and in Gtk (Gdk really) it's top-down: The top-level window gets the event and decides to handle it or pick a child to pass it to. GnuCash's register is grabbing the tab, return, and cursor-key events instead of passing them through. It needs to not do that when the imcontext is active. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8 AQBanking in the US
OFX seems to be a broken in AQBanking 6, which as I explained earlier I provided in the Windows and Mac bundles to support the recent changes in Germany's FinTS system. Here's what my testing found: * OFX users and accounts aren't migrated to the new ~/.aqbanking/settings6 directory so the AQBanking Setup Wizard is initially unpopulated. * Trying to migrate the files oneself doesn't work very well, one must set them up by hand. ∑* One can create users but not edit them. * The Fetch Accounts button in the create user assistant works. The select user drop down in the edit account dialog does not, so if you don't fetch the accounts from the bank when you set up the user then you must edit the configuration files by hand. * The debug logging messages from Gwenhywfar aren't very helpful. * The associations made in the Online Banking Setup Assistant don't show in the assistant but they are made, so that the menu items in Actions>Online Actions are enabled for the account. However, the select account dialog still comes up the first time you try to get transactions anyway. * Once everything is set up, getting transactions seems to work but the end result is a matcher window with only a single 0-value and 0-date transaction. * Setting AQBANKING_LOGLEVEL=info or debug does nothing. * Setting AQOFXCONNECT_LOGLEVEL=info produces a single additional message: '* 13:20:06 WARN /Users/john/Development/Gnucash-Build/Gnucash-master-git/src/aqbanking-5.99.44beta/src/libs/plugins/backends/aqofxconnect/provider.c: 159: Overriding loglevel for AqOFXConnect with "info"'. Pretty useless. * GWEN_LOGLEVEL=debug produces a lot of output but little of it is of much help. FWIW https://github.com/Gnucash/gnucash/pull/623 made no difference. I don't know how much of that's fixable from GnuCash. Martin said last week that he's suspended development of OFX so anything that isn't is presumably broken forever. Regards, John Ralls > On Jan 2, 2020, at 9:08 AM, Derek Robinson via gnucash-user > wrote: > > I’ll check that piece of configuration over the weekend (and I never knew the > xml could be uncompressed ... thanks Frank Ellenberger!) > > Sent from my iPhone > >> On Jan 2, 2020, at 11:40 AM, chris graves wrote: >> >> Derek, >> >> Yes, the symptoms I'm experiencing seem to be the same. >> >> Chris >> >>> On Jan 1, 2020, at 8:21 PM, Derek Robinson via gnucash-user >>> wrote: >>> >>> We may be talking about the same issue - is the behavior what I described >>> in my post earlier today? >>> >>> John Ralls ( or anyone else who might know ) - any idea where the link >>> between an AqBanking account and the corresponding GC account is stored? >>> >>> Derek >>> >>> Sent from my iPhone >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GC CTD lost saved reports
Yes, if you don't need to use GC 2.x you can safely delete ~/.gnucash. Regards, John Ralls > On Jan 2, 2020, at 12:29 PM, Elmar wrote: > > Since I am running only version 3.7 in both linux and win7, I can safely > delete .gnucash entirely, right? > > And in other news - I got my reports back :) Thank the computer gods for > backups and redundancies. > > On 1/2/20 2:36 PM, John Ralls wrote: >> ~/.gnucash is left over from GC 2.6. The other two are for different >> purposes (and I forgot that when I wrote the earlier message), see >> https://wiki.gnucash.org/wiki/Configuration_Locations. >> >> ~/.gnucash should have saved-reports-2.4 only, ~/.local/share/gnucash >> should have both saved-reports-2.4 and saved-reports-2.8. >> >> Regards, >> John Ralls >> >>> On Jan 2, 2020, at 4:59 AM, Elmar wrote: >>> >>> This is what's confusing: GC seems to have several folders on the linux side >>> >>> /home//.config/gnucash >>> >>> /home//.gnucash >>> >>> /home//.local/share/gnucash >>> >>> Should all of them have the same contents? And if so, why the duplication? >>> Or is one or more of these left over from when I upgraded from version 2.6 >>> to 3.7? >>> >>> - Elmar >>> >>> On 1/1/20 6:57 PM, John Ralls wrote: >>>> That makes sense, the aqbanking stuff lives in its own folder, >>>> ~/.aqbanking. >>>> >>>> See if you have both ~/.gnucash and ~/.config/gnucash with only one of >>>> them having saved-reports-2.8. >>>> If neither, then that's the file you want from your Windows config. >>>> >>>> BTW, what does CTD expand to? >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Jan 1, 2020, at 3:27 PM, Elmar wrote: >>>>> >>>>> Update - aqbanking data is NOT lost, just all the reports. The program >>>>> says I have none saved, and need to create some. >>>>> >>>>> On 1/1/20 4:46 PM, Elmar wrote: >>>>>> Just had a CTD when trying to modify a save report while running in >>>>>> linux (my default OS), and now all my reports and all my aqbanking info >>>>>> is gone (Linux Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) >>>>>> Finance::Quote: 1.47GC ). However, since I dual boot, on the windows >>>>>> side, all the reports and aqbanking info is still there! The data file >>>>>> is fine, happily. What do I need to copy over from where in win7 to >>>>>> where in the linux file system to get my linux side working again? - >>>>>> Elmar >>>>>> >>>>>> >>>>> ___ >>>>> gnucash-user mailing list >>>>> gnucash-user@gnucash.org >>>>> To update your subscription preferences or to unsubscribe: >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>> If you are using Nabble or Gmane, please see >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC CTD lost saved reports
~/.gnucash is left over from GC 2.6. The other two are for different purposes (and I forgot that when I wrote the earlier message), see https://wiki.gnucash.org/wiki/Configuration_Locations. ~/.gnucash should have saved-reports-2.4 only, ~/.local/share/gnucash should have both saved-reports-2.4 and saved-reports-2.8. Regards, John Ralls > On Jan 2, 2020, at 4:59 AM, Elmar wrote: > > This is what's confusing: GC seems to have several folders on the linux side > > /home//.config/gnucash > > /home//.gnucash > > /home//.local/share/gnucash > > Should all of them have the same contents? And if so, why the duplication? > Or is one or more of these left over from when I upgraded from version 2.6 to > 3.7? > > - Elmar > > On 1/1/20 6:57 PM, John Ralls wrote: >> That makes sense, the aqbanking stuff lives in its own folder, ~/.aqbanking. >> >> See if you have both ~/.gnucash and ~/.config/gnucash with only one of them >> having saved-reports-2.8. >> If neither, then that's the file you want from your Windows config. >> >> BTW, what does CTD expand to? >> >> Regards, >> John Ralls >> >> >>> On Jan 1, 2020, at 3:27 PM, Elmar wrote: >>> >>> Update - aqbanking data is NOT lost, just all the reports. The program >>> says I have none saved, and need to create some. >>> >>> On 1/1/20 4:46 PM, Elmar wrote: >>>> Just had a CTD when trying to modify a save report while running in linux >>>> (my default OS), and now all my reports and all my aqbanking info is gone >>>> (Linux Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) >>>> Finance::Quote: 1.47GC ). However, since I dual boot, on the windows >>>> side, all the reports and aqbanking info is still there! The data file is >>>> fine, happily. What do I need to copy over from where in win7 to where in >>>> the linux file system to get my linux side working again? - Elmar >>>> >>>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 V3.x NSTextInputClient protocol non-compliance
Kusomoto-san, Please remember to copy the list in all replies. > On Jan 2, 2020, at 5:38 AM, KUSUMOTO Norio wrote: > > Thank you for your replay, John! > > > (It is very difficult to draw attention to the issue of internationalization > of text input. However, if you can imagine the practicality of accounting > software that can not input virtually non-numeric text without copying and > pasting from other applications, you will understand our disappointment.) > > > >> 2020/01/02 13:21、John Ralls のメール: >> >> The known problem with Japanese and Chinese IMs is documented at >> https://bugs.gnucash.org/show_bug.cgi?id=797264. there's a work-around, >> though with Japanese it's a bit cumbersome than with Chinese especially on a >> desktop where you have to move your hands to get to the mouse or trackpad: >> Finish typing your string with a space, which may bring up a final selection >> box. Double-click on the selection in the box if it does. Regardless then >> double click in the field that you're filling in before tabbing to or >> clicking in another field. In Chinese one need simply end the string with a >> space bar before tabbing to the next field. > > > When we use IM to input Japanese, we use the cursor keys to specify where to > separate > the translations. Mouse actions cannot substitute for these actions. Is that because the cursor-key gestures are an ingrained part of typing or is there something about the operation of the IM that I'm missing? Regardless, I understand that having to use the mouse when typing is undesirable, I offered it only as a workaround until I find time to work on this some more. > > >> I just tried press-and-hold in Apple Mail with the Hiragana IM to see what's >> supposed to happen. Holding a letter key down does raise a window, but only >> after the key starts repeating. The same effect is achieved by typing the >> letter twice, so I don't think that there's a feature there. > > You can select a variation of characters by long pressing only when you use > the 'U.S.' > keyboard, not when you select Hiragana IM. > I gave this example because I wanted to say that it is not a limited issue > when using > a language to input using IM, such as Japanese. A long keypress just types the letter when I use the US keyboard. > > > >> The underlying problem is due to difficulty integrating IMs with our >> specialized tab, return, and arrow key handling for deciding when to commit >> transactions, look for accounts, and process calculations. > > I worked on NSTextInputClient support for a programming language development > environment > last year. (It's not written in C.) It can do tab-driven completion, have the > same key > combinations as IM, or perform return based execution. I implemented it to > suppress > passing events to the IDE when I was interacting with IM. > > I'm not familiar with the internationalization of GTK, but I think there > should be a way > to deal with similar situations because they should be a variety of > applications. The Gtk input module is https://gitlab.gnome.org/GNOME/gtk/blob/gtk-3-24/modules/input/imquartz.c and it mostly wraps NSTextInputClient. It hasn't been updated in a few years and so it has gotten a little out of sync with Apple's code, but the problem with tab, return, and arrow keys is GnuCash's fault: For the most part I think that the IM works correctly except in the register, but you're a far better judge of that than I am. Does it work the way you expect in dialog boxes? 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] GC CTD lost saved reports
> On Jan 2, 2020, at 5:39 AM, Elmar wrote: > > Sorry - "crash to desktop" - the program simply vanishes from the screen. > > On 1/1/20 6:57 PM, John Ralls wrote: >> BTW, what does CTD expand to? >> Thanks, but please remember to copy the list on all replies. 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] GC CTD lost saved reports
That makes sense, the aqbanking stuff lives in its own folder, ~/.aqbanking. See if you have both ~/.gnucash and ~/.config/gnucash with only one of them having saved-reports-2.8. If neither, then that's the file you want from your Windows config. BTW, what does CTD expand to? Regards, John Ralls > On Jan 1, 2020, at 3:27 PM, Elmar wrote: > > Update - aqbanking data is NOT lost, just all the reports. The program says > I have none saved, and need to create some. > > On 1/1/20 4:46 PM, Elmar wrote: >> Just had a CTD when trying to modify a save report while running in linux >> (my default OS), and now all my reports and all my aqbanking info is gone >> (Linux Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) >> Finance::Quote: 1.47GC ). However, since I dual boot, on the windows side, >> all the reports and aqbanking info is still there! The data file is fine, >> happily. What do I need to copy over from where in win7 to where in the >> linux file system to get my linux side working again? - Elmar >> >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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 work with paypal transaction reports?
> On Jan 1, 2020, at 1:30 PM, friedem...@masur.de wrote: > > Hi, > > im manually importing all my paypal report into gnucash and technically > everything works. > > However paypal has a strange way of handling some transactions. > Sometimes transactions are "pending" e.g. when I have received money from an > ebay buyer but the money will only show up as "confirmed" when the package > has arrived at the buyer. > > What happens now it that in my csv file i have a some point a pending > transaction and at a later point a confirmed one, however these cancel each > other out or just show up as unrelated payments. > > I wonder if there is a best practice on how to deal with paypal? or is there > another way to import the transaction easier? I've never tried importing from PayPal as I use it only a few times a year and I don't sell stuff any more. You could model the escrow feature with a separate Assets:PayPal-Pending account, but I think you'll have to pre-process the csv to get it to do the income:sales->assets:paypal-pending->assets:paypal dance correctly. 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] Anyone using DKB (german bank) here?
> On Jan 1, 2020, at 1:21 PM, friedemann--- via gnucash-user > wrote: > > Hi, > > after the PSD2 transition, my online banking stopped working in GC3.7. I now > tried 3.8 and now I'm getting one step further to where I'm getting trough > most of the AQbanking setup until the last step where I have to register my > 2factor setup. > > Since so much has changed during this whole transition phase I wonder if the > bank is the problem or if its a general Gnucash problem and it doesn't work > for many people? > > So has anyone recently tried to make online import work with DKB? There's a lot more knowledge about this on gnucash-de, I suggest you subscribe there, read through the archives, and then ask there if you haven't found your questions answered. 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 Jan 1, 2020, at 12:35 PM, boldstripe wrote: > > I'm attempting to build v 3.8 on Debian (Linux) Buster, using the > instructions on 'Building on Linux' and--as far as I can understand--a side > page on installing dependencies. I've run into an error on execution of the > 'make' command that I do not understand. Can anyone please suggest a > remedy?: > > [ 76%] Built target scm-test-load-gnome-utils-module > [ 76%] Built target gncmod-generic-import > CMake Error: Cannot open file for write: > /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp > CMake Error: : System Error: Permission denied > Scanning dependencies of target gncmod-aqbanking > CMake Error: Directory Information file not found > CMake Error: Cannot open file for write: > /home/michael/Downloads/gnucash-3.8b/gnucash-3.8/build-gnucash-3.8/gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend.make.tmp > CMake Error: : System Error: Permission denied > make[2]: *** > [gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/build.make:307: > gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/depend] Error 2 > make[1]: *** [CMakeFiles/Makefile2:8630: > gnucash/import-export/aqb/CMakeFiles/gncmod-aqbanking.dir/all] Error 2 > make: *** [Makefile:163: all] Error 2 > And why can't it open that file? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
Stable releases are certainly intended to work for ordinary users, though it's always possible to have regressions. With AQBanking we have an unfortunate conundrum: The AQBanking developer wasn't paying attention to legal developments in Germany and the EU and was caught short by some substantial changes in the FinTS (formerly HBCI) system last September, to the point that the AQBanking completely stopped working there. He has since been playing catch-up with his development branch so that it mostly works again, but it's a development branch and isn't stable. Unfortunately that put us in the position of either bundling the last stable release of AQBanking that doesn't work at all in Germany or bundling the not-quite stable development beta release that mostly does work in Germany. I decided to go with the beta. If that turns out to be a problem for you you can review the changes in the release notes (see https://www.gnucash.org/news.phtml) and decide whether it's worth it to use 3.8 anyway or to stick with 3.7. Regards, John Ralls > On Jan 1, 2020, at 3:30 AM, Finbar Mahon wrote: > > I very much appreciate, and depend a lot on, Gnucash. But could I make a > small recommendation? > > When a new version is launched would it be possible to announce when It works > for 'ordinary' users? > > I have no trouble waiting until it is 'clean' > > HYN 2020 to all. > > Finbar > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: >> It should but you will have to install all the dependencies and their >> development headers to build successfully. There is a breakout page from the >> building instruction which gives you the dependencies to install. (There are >> occasionally some that are not covered as it depends on what the particular >> Linux distribution installs as standard and what libraries have been >> installed with other software but it is now pretty complete). >> >> When you run cmake, it will stop with an error if anything is missing. >> Identify the missing dependency or come back to the list, install it and >> rerun cmake until it completes with out error. Library names can sometimes >> vary slightly between distributions to complicate matters (usually addition >> of a version number or "lib" in front >> >> apt-cache search is a good way to find libraries with a slightly >> different package name. >> >> >> >> - >> David Cousens >> -- >> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash 3.8 Get Transactions not working
> On Dec 31, 2019, at 2:00 PM, chris graves wrote: > > Online Actions->Get Transactions not working > Gnucash 3.8 > MacOS Catalina > > The Get Online Transactions dialog does not pop up. Works fine in 3.7. > > Here is the trace file: > * 13:53:46 ERROR plugin.c: 401: Plugin "dir" not found. > * 13:53:46 ERROR ./banking_cfg.c: 78: Could not create > ConfigMgr[dir:///Users/chris/.aqbanking/settings6]. Maybe the gwenhywfar > plugins are not installed? > * 13:53:46 ERROR ./banking_init.c: 405: No config manager. Maybe > the gwenhywfar plugins are not installed correctly? > * 13:53:46 ERROR gnc_AB_BANKING_new: assertion > 'AB_Banking_Init(api) == 0' failed > * 13:53:46 WARN gnc_ab_gettrans: Couldn't get > AqBanking API Already fixed. There's a Gnucash-Intel-3.8-2.dmg at SourceForge and Github waiting for you. 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 - 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
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] 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 that when you select >> Open >>>
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: > >>> > >>>> If you’re getting the G
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: >>>
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 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 > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.or
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 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] 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. >>>> >>>> So how do I start GnuCash in Windows using the --nofile --debug &
