There was indeed a bug so I opened https://bugs.gnucash.org/show_bug.cgi?id=798327 and created a PR with a simple fix. I verified that on the file that Robin provided the import continues as expected for all 11 securities.
On Sun, Oct 3, 2021 at 2:21 PM john <jra...@ceridwen.us> wrote: > That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798208 < > https://bugs.gnucash.org/show_bug.cgi?id=798208>, which is fixed in > GnuCash 4.8. > > Regards, > John Ralls > > > > On Oct 3, 2021, at 9:19 AM, Robin Chattopadhyay <robinra...@gmail.com> > wrote: > > > > Yes, I'm familiar with that issue as well as my spouse's 401K OFX has fee > > transactions where shares are sold to pay plan expenses, but those > > transactions appear only as cash withdrawals and the sale transactions do > > not get imported. > > > > That one doesn't bother me as much because it's one transaction per month > > vs 9 every two weeks. > > > > On Sun, Oct 3, 2021 at 11:04 AM Kalpesh Patel <kalpesh.pa...@usa.net> > wrote: > > > >> The issues that you are seeing I believe has to do with changes that OFX > >> introduced in libofx which has been included since 4.5 and above > version of > >> GnuCash. FWIW, I am running on Windows 10 Pro desktop but that likely > >> doesn't matter when it comes to core functionality. > >> > >> I also had problems where some of transactions would not get imported in > >> from an OFX file and these transactions I deduced from trial and error > are > >> specifically if they are related to deposit and withdrawal of cash in > Stock > >> or Mutual Fund account. I am not sure if this is the behavior on your > end > >> or > >> not but it sounds like it. This might be because libofx author may have > >> changed philosophy and its implementation where cash in and out are not > >> considered investment transactions such as buy and sell of a stock, > bond, > >> mutual fund, etc. > >> > >> Because of that I have stayed at GnuCash 4.4 (specifically Build ID: > >> 4.4+(2020-12-28) for Windows) which I have known to properly import > >> brokerage created OFX files for import. I've reached out to the author > of > >> libofx for understanding and I am still waiting to hear back from them. > >> > >> It may be worth a shot to install that version and see if it imports OFX > >> correctly. If you have a blank file then it should ask for appropriate > >> input > >> via dialogue box such as creation of "securities", corresponding > >> "brokerage" > >> account, etc. You can then go back and edit those "security" and enable > >> download of prices using Finance::Quote Perl module with yahoo_jason as > the > >> source for it if you want to automate it. > >> > >> For FWIW, GnuCash 4.5 on windows used to crash when 'Actions' --> > 'Check & > >> Repair' --> 'Check & Repair All' would be selected to run which I do now > >> and > >> then to make sure that my xml based file is in good shape (this is carry > >> over habit from Quicken as it was known to corrupt files). > >> > >> This may not be the answer you are looking for but hope this helps a > bit. > >> > >> Kalpesh... > >> > >> ------------------------------ > >> > >> Message: 2 > >> Date: Sat, 2 Oct 2021 10:58:44 -0500 > >> From: Robin Chattopadhyay <robinra...@gmail.com> > >> To: Gnucash Users <gnucash-user@gnucash.org> > >> Subject: [GNC] OFX Import with Investment Transactions > >> Message-ID: > >> <CACYeXFv+kFMZqDqB2czLz_tT9Z8= > >> 7jjed1oqxw_jpqssxjx...@mail.gmail.com> > >> Content-Type: text/plain; charset="UTF-8" > >> > >> Ubuntu 20.04 LTS (VMWare virtual machine in case that matters) Gnucash > 4.8 > >> libofx 0.9.15 > >> > >> I tried importing an OFX file from my 401K provider this morning and I > got > >> a > >> message box that said it had imported 2 transactions for a single > security > >> in the file and there were no additional transactions to process. > >> This was incorrect as there were 18 new transactions across nine > securities > >> (along with a number of other transactions that had already been > imported > >> previously). > >> > >> I tried a number of things to resolve (after taking a backup, of > course): > >> 1 - Tools > Import Map Editor and deleted all of the associations for > this > >> file. When I re-imported, I was prompted to map each security in the > file > >> to > >> the correct account. No issues there. But when importing the OFX file > >> again, > >> I had the same experience as described above > >> 2 - Created a blank file and attempted to import the file there. Through > >> the > >> import process, I created new securities and new accounts, nothing > >> unexpected there. Then the generic transaction importer dialog popped > up, > >> but with just the two transactions for the same security cited in the > >> original problem dialog. I imported those, clicked OK and then the > generic > >> transaction importer dialog came up *again* but only with transactions > for > >> a > >> single, different security. I imported those and repeated the process > for > >> each security with transactions in the file. Each time the generic > >> transaction importer dialog came up, it only had transactions for a > single > >> security. This is definitely new behavior that I didn't see in 4.6. > >> Previously the import dialog had all the new transactions in the file > >> 3 - Reverted to 4.7. Crashed when selecting Import from the File menu > >> (Trace/breakpoint trap (core dumped). Not unexpected, but thought I > would > >> try anyway. > >> 4 - Reverted to 4.6. This works as it used to with all the new > transactions > >> in a single dialog > >> > >> Finally, I don't know if this matters, but I scanned stdout from the > >> build/make/install process to see if anything looked obviously wrong > and I > >> found this (I don't know if it's relevant): > >> > >> -- Performing Test HAVE_OFX_BUG_39 > >> -- Performing Test HAVE_OFX_BUG_39 - Failed > >> > >> Thanks, > >> Robin > >> > >> > >> > >> > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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.
