Re: [GNC] Import bug? no account matching options
On Thu, 26 Sep 2019 19:20:17 -0400 David Reiser via gnucash-user wrote: > Another workaround would be to download QFX files instead. That has > the added advantage that if you do it more than once per billing > period, the presence of the unique transaction ID makes it trivially > easy for the import matcher to throw out duplicates without even > having to ask you about them. > > Dave I have no experience with Chase, but my bank does not use unique transaction ID codes in their OFX files. Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can not insert text on transaction after import QIF
As for further punishment, I unloaded via synaptic the old 2.16.19 version and gave it a go with Ronal's idea of using the sickylife.ppa load out. After cleaning, I loaded the ppa and installed - no problems - no errors. 3.7 still force closes on touching the files. Unload it, remove PPA, attempt to restore my Synaptic - its buggered up. May have to time shift this whole thing back to yesterday. Need to get my linux machine restored and move on. I'll watch this thread and see if anyone has ideas as a complete tax season. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can not insert text on transaction after import QIF
Hi, Thanks for the suggestions and some more definitions about QIF and CSV importers. Bottom line for me on my LM 19.2, other than the QIF importer none of the other techniques work on my Win or Linux machines. On my linux box, the program itself did not work although I did get a clean cmake install this last time. As this is tax season, I don't have a lot of time to program this stuff - I need to work on my books. My history with Gnucash started long ago in the early 2.* series. I suppose I was on LM13 or less at that time. Gnucash worked in Linux just fine and was a great help. At that time even the auto downloads aqbank was working for me. As time went by and especially after we jumped to the 3.* series, the importing, automation, aqbank, etc stopped working. I was still able to create a working program via the tar ball method until we got to the mandatory cmake procedure. At that time I was not able to make an install from any kind of cmake instructions. As I had hopes to restore some of the functions I had lost, I updated gnucash. For a time I was able to get 3.2 from flatpac to work and lately a 3.5 deb package from Stephen Butler to work. As mentioned I was able to get a cmake install for 3.7 using a different procedure to install to $HOME/.local. Previously all attempts to install to any /usr or /opt directory failed. Today I tested old and new .gncash files and all of them failed would not work in the 3.7 (did the autoclose bit). I did the "make uninstall" the 3.7 - it came out clean. I checked the synaptic - clean. Did the terminal autoclean/autoremove bit - clean. Checked dependencies again - attempted to reinstall the 3.5 deb package. Now this 3.5 deb package did install cleanly, but again the files are untouchable - the magic program autoclose. Is this a new feature? I unloaded the 3.5, clean it up and then went to the Synaptic and loaded the old 2.16.19 - the last gnucash Ubuntu/LM put in their repositories. This apparently is working. What the heck! So this is apparently pointing to issues with the newer Ubuntu/LM programming/kernels or something. No clues beyond this - have to get something to work on my books either on the Win machine or old linux installs. David -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble with import and splits
It's unfortunate but successfully importing a lot of data often requires a fairly detailed knowledge of how GnuCash functions and how that differs from the program being imported from and when we need to do this is usually when our experience is minimal. I did it over 10 years ago now with several years of data coming from MYOB. I did it in 6 month blocks working backwards reconciling forward while using GnuCash for my day to day accounting. There was quite a bit of manual fixing of the imports involved. I did use some macros in Excel at the time to massage the data and then re-export it in CSV before importing into GnuCash. Hopefully this might get easier when the documentation is updated. Cherrs David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble with import and splits
"AFAIK the import process for securites and transactions with currency changesis problematical even when importing data re-exported from GnuCash." ... "One thing you could try is to create a correct dummy transaction of thetype(s) you need to import, export them to CSV using the multi-splitmulti-line ( default GnuCash Export Format) and then try reimporting theminto GnuCash using the same format. If that works you can examine the CSVexport format and put your import data in the same format before trying toimport it.David Cousens" Thanks, David. I've spent a lot of time trying to automate my migration and so far I haven't been able to do it well, but I keep trying, finally giving up and doing it manually. I took your suggestion and exported an account with transactions similar to the ones I mentioned in my original post - without the ability to write good script, it appears I'd spend a lot more time massaging .csv data into usable form that might not be quite good enough. I think I'll do it manually. Thanks, anyway. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble with import and splits
AFAIK the import process for securites and transactions with currency changes is problematical even when importing data re-exported from GnuCash. It is on my list of things to test out systematically and document. I imported some dual- currency transactions after a trip to Singpore earlier this year. I had to do quite a bit of fiddling with the price before I managed to get it to make sense and work. part of that was my own inexperience in doing it and that capability was new in v3 and has yet to be documented fully. I had one attempt at creating a dummy security export and re-importing when Geert first rewrote the importer for V3, which didn't work. It found the available documentation on the importer not too helpful and decided I needed to understand the operation of the importer with simpler cases first and document that before getting back to securities. One thing you could try is to create a correct dummy transaction of the type(s) you need to import, export them to CSV using the multi-split multi-line ( default GnuCash Export Format) and then try reimporting them into GnuCash using the same format. If that works you can examine the CSV export format and put your import data in the same format before trying to import it. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Import bug? no account matching options
> On Sep 26, 2019, at 4:41 PM, Grant wrote: > I'm trying to import transactions I've downloaded from Chase in a QIF file but when I'm importing Gnucash doesn't give me any options to match them to an account (zero accounts in the list) and the button to change the matched account is grayed out. This is happening with 2 separate Chase accounts and I am able to import transactions from another bank just fine. What could be causing this? >>> >>> Lack of L lines in the transactions? >> >> >> I just figured it out. Chase uses a blank line instead of a line >> containing only the "^" character to separate transactions. I'm using >> this to strip the top blank line: >> >> sed -i '/./,$!d' file.qif >> >> and then this to replace all blank lines with the "^" character: >> >> sed -i 's/^[[:blank:]]*$/^/' file.qif >> >> That seems to work. Surely the Chase files are out of spec but is >> this something Gnucash could work around? If so I'll file a bug. > > > Here's what the problem/bug looks like: > > https://imgur.com/a/vPZOdD2 > > The import dialog skips the "Set a date format for this QIF file" and > the "Set the default QIF account name" sections. > Another workaround would be to download QFX files instead. That has the added advantage that if you do it more than once per billing period, the presence of the unique transaction ID makes it trivially easy for the import matcher to throw out duplicates without even having to ask you about them. Dave -- Dave Reiser dbrei...@icloud.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble with import and splits
This is with GnuCash 3.7 and the import file is .csv. Thanks, David. Sep 26, 2019, 20:10 by orn...@tutanota.com: > > I can't get the split to calculate a price properly after an import. > > The account block in the Import Preview is right and the debit amount is > right and in the proper account after import, the split accounts are right > (after the import matcher), and the deposit amount is right and it goes to > into debit. (Assume small dividends being re-invested.) The share amount is > wrong - it's the same number as the dollar amount because the default price > is $1.00, but I expect that because I don't know of a "number of shares" > column in the import screen. > > Here's an example of one Dividend Re-Investment line after import: Tot Shares > - 102.5, Share Price 1.00, Total Debit 102.5.(This latter is accurate.) > It provides me with three splits the base account and two for the > Transfer/Destination account, one for 3.107, and the other 99.393, both of > the latter two are the Transfer/Destination account, but I don't know what > the separate amounts signify. > > My actions: Change Number of Shares to 3.136 in order to allow GC to > calculate the price at approximately $32.68. I click down into the first > split line and the Recalculate Transaction box pops up allowing me to choose > "Recalculate Price," which I do. It then recalculates the price back to $1.00 > and changes the number of shares back to the 102.5, the correct number if > share price were $1.00. > > This seems to take place only after I've imported transactions, not when I > create them all from scratch. > > I haven't been able to locate this as a known bug, but it's possible I'm > searching for the wrong terms. > > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble with import and splits
First, you do not specify the type of file that you are importing from. Since CSV, QIF and OFX imports each use different code, that is important to know. Second, you must be using version 3.something because release 2.6.x was unable to import stock transactions, but it would help to know your operating system and the exact release you are using. This may be an unreported bug or one that is described differently than your description. The developers and other users may be able to help if you provide the above information. I have not taken the plunge to the 3.x release series yet, so that is all I can suggest. David Carlson On Thu, Sep 26, 2019 at 3:12 PM wrote: > > I can't get the split to calculate a price properly after an import. > > The account block in the Import Preview is right and the debit amount is > right and in the proper account after import, the split accounts are right > (after the import matcher), and the deposit amount is right and it goes to > into debit. (Assume small dividends being re-invested.) The share amount is > wrong - it's the same number as the dollar amount because the default price > is $1.00, but I expect that because I don't know of a "number of shares" > column in the import screen. > > Here's an example of one Dividend Re-Investment line after import: Tot > Shares - 102.5, Share Price 1.00, Total Debit 102.5.(This latter is > accurate.) > It provides me with three splits the base account and two for the > Transfer/Destination account, one for 3.107, and the other 99.393, both of > the latter two are the Transfer/Destination account, but I don't know what > the separate amounts signify. > > My actions: Change Number of Shares to 3.136 in order to allow GC to > calculate the price at approximately $32.68. I click down into the first > split line and the Recalculate Transaction box pops up allowing me to > choose "Recalculate Price," which I do. It then recalculates the price back > to $1.00 and changes the number of shares back to the 102.5, the correct > number if share price were $1.00. > > This seems to take place only after I've imported transactions, not when I > create them all from scratch. > > I haven't been able to locate this as a known bug, but it's possible I'm > searching for the wrong terms. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Import bug? no account matching options
> > > I'm trying to import transactions I've downloaded from Chase in a QIF > > > file but when I'm importing Gnucash doesn't give me any options to > > > match them to an account (zero accounts in the list) and the button to > > > change the matched account is grayed out. This is happening with 2 > > > separate Chase accounts and I am able to import transactions from > > > another bank just fine. What could be causing this? > > > > Lack of L lines in the transactions? > > > I just figured it out. Chase uses a blank line instead of a line > containing only the "^" character to separate transactions. I'm using > this to strip the top blank line: > > sed -i '/./,$!d' file.qif > > and then this to replace all blank lines with the "^" character: > > sed -i 's/^[[:blank:]]*$/^/' file.qif > > That seems to work. Surely the Chase files are out of spec but is > this something Gnucash could work around? If so I'll file a bug. Here's what the problem/bug looks like: https://imgur.com/a/vPZOdD2 The import dialog skips the "Set a date format for this QIF file" and the "Set the default QIF account name" sections. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Trouble with import and splits
I can't get the split to calculate a price properly after an import. The account block in the Import Preview is right and the debit amount is right and in the proper account after import, the split accounts are right (after the import matcher), and the deposit amount is right and it goes to into debit. (Assume small dividends being re-invested.) The share amount is wrong - it's the same number as the dollar amount because the default price is $1.00, but I expect that because I don't know of a "number of shares" column in the import screen. Here's an example of one Dividend Re-Investment line after import: Tot Shares - 102.5, Share Price 1.00, Total Debit 102.5.(This latter is accurate.) It provides me with three splits the base account and two for the Transfer/Destination account, one for 3.107, and the other 99.393, both of the latter two are the Transfer/Destination account, but I don't know what the separate amounts signify. My actions: Change Number of Shares to 3.136 in order to allow GC to calculate the price at approximately $32.68. I click down into the first split line and the Recalculate Transaction box pops up allowing me to choose "Recalculate Price," which I do. It then recalculates the price back to $1.00 and changes the number of shares back to the 102.5, the correct number if share price were $1.00. This seems to take place only after I've imported transactions, not when I create them all from scratch. I haven't been able to locate this as a known bug, but it's possible I'm searching for the wrong terms. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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] gnucash-user Digest, Vol 198, Issue 52
Thanks for the followup Bob. Glad you got it working. Agreed, MS should have offered a dialog that it was going to block certain apps and offer to whitelist them for you. Regards, Adrien > On Sep 25, 2019 w39d268, at 10:05 PM, Bob Hammons wrote: > > - > I am the person that had the problem. Windows defender blocked gnucash, > quicken and open office. I posted a fix but I did not save it. > On my wife's computer quicken listed the programs that were blocked and was > an easy fix. > My computer I went into settings and found windows defender settings and > unchecked. If you can't find it I will look tomorrow. > Was not very nice of MS to do this. Someone had to do this on purpose ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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
In order to minimize errors during import I first exported the account (categories) tree and imported that into GC. We’re there still errors?, yes but it was manageable. I then exported the data by year into qif files for import into GC. It made my life easier and reduced the number of errors I had to fix. Ken Schneider > On Sep 26, 2019, at 9:59 AM, randix wrote: > > In all seriousness, I recall that when I tried to import my data from > Quicken, I ran into so many problems and inaccuracies of the transactions > going into the wrong GnuCash account, etc., that I concluded it was just > easier and I'd have more confidence in entering the transactions manually > from the accounts that were important to me for X period of time, then have > to spend hours and hours reviewing "imported" entries and trying to chase > down inaccuracies. It took me some time, obviously, but in retrospect, I > have no regrets over that approach, and the beer made it somewhat > enjoyable... > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Import bug? no account matching options
> > I'm trying to import transactions I've downloaded from Chase in a QIF > > file but when I'm importing Gnucash doesn't give me any options to > > match them to an account (zero accounts in the list) and the button to > > change the matched account is grayed out. This is happening with 2 > > separate Chase accounts and I am able to import transactions from > > another bank just fine. What could be causing this? > > Lack of L lines in the transactions? I just figured it out. Chase uses a blank line instead of a line containing only the "^" character to separate transactions. I'm using this to strip the top blank line: sed -i '/./,$!d' file.qif and then this to replace all blank lines with the "^" character: sed -i 's/^[[:blank:]]*$/^/' file.qif That seems to work. Surely the Chase files are out of spec but is this something Gnucash could work around? If so I'll file a bug. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Import bug? no account matching options
Hi, Grant writes: > I'm trying to import transactions I've downloaded from Chase in a QIF > file but when I'm importing Gnucash doesn't give me any options to > match them to an account (zero accounts in the list) and the button to > change the matched account is grayed out. This is happening with 2 > separate Chase accounts and I am able to import transactions from > another bank just fine. What could be causing this? Lack of L lines in the transactions? If there are only P and M lines, but no L lines, the importer will only ask you to map Payees/Memos to accounts, but not Qif Accounts. Of course, without seeing an example of the QIF I can't be sure. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transfer dialog shortcut
Dear Tim, Tim Meyer writes: > Dear Derek, thank you, this is a different command. > My focus was on the pull-down-menu to choose the right transfer account >From both the subject and original query, the question read as "what is the shortcut to open the transfer dialog?" Clearlt that's not what you are asking. Even with this current clarification, asking about a "pull-down to choose the right transfer account", I am STILL unclear on what exactly you're asking. The reason for my confusion is that there are multiple places where a transfer account is chosen. So, to clarify your question and ensure you get the best answer possible, could you please clarify what it is you are trying to do, where in the program you are trying to do it, and any other information that might be useful? For example: I've opened my Foo Account register and I'm trying to enter a new transaction; I get to the transfer column and ... Or, I've opened the Transfer Dialog (e.g. Ctrl-T) and want to Thanks, > Am 25.09.19 um 16:42 schrieb Derek Atkins: >> It's always been Ctrl-T for me? >> >> -derek >> >> Tim Meyer writes: >> >>> Dear group, is the shortcut ctrl + arrow up for the transfer dialog >>> deactivated? In my version it is not working any more. >>> Version: 3.7 >>> Build ID: 3.7+(2019-09-07) >>> Finance::Quote: 1.47 >>> ___ > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can not insert text on transaction after import QIF
I've experienced 3.7 crashing to the desktop when attempting to insert text into a journal transaction, no .csv imports involved. But, I'm running Ubuntu 19.10 (pre-beta) and got 3.7 from the sicklylife.ppa. Too many variables there to draw meaningful conclusions. The crashes weren't consistent, but more importantly, haven't happened for a couple of Eoan update cycles so I wrote them off as development issues and quit worrying about it. In light of David's report I'll keep a closer eye on it and if it happens again try to harvest some useful troubleshooting data. RBM On Thu, 2019-09-26 at 10:34 +, Christopher Lam wrote: > Also there seems to be confusion.CSV files and QIF files are quite > different, and both have dedicatedimporters.Both may slow with large > numbers of transactions to import, hence it'salways safer to import > in chunks. Which ones are not functioning? > On Thu, 26 Sep 2019 at 09:06, dmeece wrote: > > After a huge effort to install Gnucash 3.7 on a Win 10 machine and > > then onaproduction build (no errors- all dependencies met) of > > Gnucash 3.7 fromtarball on a Linux box, I failed to get a working > > program. I was able toload GnuCash3.7 in the Win 10 box with Qif > > files that numbered over athousand transactions after failing with > > the "new" csv importer - the csvcould not handle liabilities/credit > > cards and, it seems that anything overten (US) bank transactions, > > it blows up. Anyway, after getting the filesinto the Win 10 > > adaption and seemingly working, now, by moving the .gnucashfile > > over to the Linux build I find myself not being able to work with > > thetransactions at all. I click on a line to insert text, say a > > note line oraction or even the description line, the program just > > closes, bye bye,lights out. There seems to be some type of text box > > that highlights whenclicked, but any further touches - bye! > > Restart, same situation, can'ttouchit - 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 thefile import and QIF from there. This is a long convoluted > > route I've beenusing 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. Proofingthisaccounting > > on the Win 10 machine is a real pain. > > David > > > > > > --Sent from: > > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > ___gnucash-user mailing > > listgnucash-u...@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for 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 > listgnucash-u...@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Suggestion to ease newbies import problems
In all seriousness, I recall that when I tried to import my data from Quicken, I ran into so many problems and inaccuracies of the transactions going into the wrong GnuCash account, etc., that I concluded it was just easier and I'd have more confidence in entering the transactions manually from the accounts that were important to me for X period of time, then have to spend hours and hours reviewing "imported" entries and trying to chase down inaccuracies. It took me some time, obviously, but in retrospect, I have no regrets over that approach, and the beer made it somewhat enjoyable... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can not insert text on transaction after import QIF
Also there seems to be confusion. CSV files and QIF files are quite different, and both have dedicated importers. Both may slow with large numbers of transactions to import, hence it's always safer to import in chunks. Which ones are not functioning? On Thu, 26 Sep 2019 at 09:06, 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. > > David > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can not insert text on transaction after import QIF
What is the source of your import files? Once the data in in a data file it stays there and can be read by the next GnuCash release similar to a document that can be read by a document editor. The import process would only be a one-time thing. David Carlson On Thu, Sep 26, 2019 at 4:58 AM Christopher Lam wrote: > This is unfortunate. Perhaps you could anonymize a sample qif file which > fails and attach into a bug report ? It's plain text, so easy to modify. > > On Thu, 26 Sep 2019, 17:06 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. > > > > David > > > > > > > > -- > > 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. > -- 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] Can not insert text on transaction after import QIF
This is unfortunate. Perhaps you could anonymize a sample qif file which fails and attach into a bug report ? It's plain text, so easy to modify. On Thu, 26 Sep 2019, 17:06 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. > > David > > > > -- > 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] Can not insert text on transaction after import QIF
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. David -- 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.