Perhaps there should be a GnuCash error message if libofx fails. On Wed, May 4, 2022, 4:41 PM Jean Laroche <rip...@gmail.com> wrote:
> Don't know if my last messages went through. Here they are again: > > Running gnucash with --debug shows what the issue is. > > Removing the lines that contain the CARDNUM, CARDNAME and MCC elements > makes the file import correctly. > I'm not sure why ofxlib does not just ignore the unrecognized elements, > but that's the way it is. > Perhaps file a bug with libofx? > > In the meantime, if you're on a linux box or a mac and you're familiar > with linux commands, you can use the command line to strip the ofx file > from the offending lines using sed, for example on the mac: > > cat stmt.qfx | sed -E "/<CARDNAME|MCC|<CARDNUM/d" > stmt_fixed.qfx > > I'm not a sed guru, so maybe there's a better/more robust way to do it. > But this should give you a temporary solution? > > Jean > > LibOFX ERROR: OpenSP parser: otherError (misc parse error): > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: > element "CARDNUM" undefined > > (Above message occurred on Line 39, Column 14) > X ERROR: startElement: incoming_data should be empty! You are > probably using OpenSP <= 1.3.4. The following data was lost: -50.00 > (Above message occurred on Line 39, Column 6) > LibOFX ERROR: OpenSP parser: otherError (misc parse error): > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: > element "CARDNAME" undefined > > (Above message occurred on Line 40, Column 15) > X ERROR: startElement: incoming_data should be empty! You are > probably using OpenSP <= 1.3.4. The following data was lost: 9767 > (Above message occurred on Line 40, Column 6) > LibOFX ERROR: OpenSP parser: otherError (misc parse error): > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: > element "MCC" undefined > > > > > On 5/4/22 2:24 PM, Kalpesh Patel wrote: > > I did experimented with the file he has attached and I can concur that > OFX > > matcher is bailing out, or more likely silently exiting as if it was NOP. > > This is most likely an OFX import bug. > > > > > > > > If you start a fresh new file with just the 'Common Accounts' and then > > import the ofx file that was originally attached to the e-mail, GNC 4.10 > on > > Windows 10 prompts to create a new account which it does with 'Unknown > OFX > > credit card account "Credit card 4003901016729673"' account name and then > > there is no subsequent dialogue box to import the single transaction > that is > > in that file. It exit with the effect that you cancelled the import after > > creating the account. If I reimport the file again then there is nothing > > displayed, -- nothing; nada --, such as error messages or the > notification > > windows that one transaction was found and that it was a duplicate. It > once > > again simply silently exits and goes back if like no "import" was > performed > > at all or cancelled. I don't see the transaction getting added to the > > register either. > > > > > > > > > > > > > > > > ------------------------------ > > > > > > > > Message: 12 > > > > Date: Wed, 4 May 2022 03:25:25 +0000 > > > > From: Peter Wu <peter_cd...@hotmail.com <mailto:peter_cd...@hotmail.com> > > > > > > To: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> " > > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > > > Subject: [GNC] QFX file for Bank of American business account not > > > > invoking Import Matcher > > > > Message-ID: > > > > > > > <dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.OUTLOOK.C > > OM > > <mailto: > dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou > > TLOOK.COM> > > > > > > > > > Content-Type: text/plain; charset="windows-1252" > > > > > > > > Hello, > > > > Gnucash community. Hope everyone is doing well and having a good time. > Two > > questions: > > > > > > > > > > > > 1. Beside the mailing-list. Does anyone know a forum where we can > ask > > and discuss issues? I feel it may be easier to search/discuss/answer > > questions than a mailing list. > > > > 2. As the email subject says. Attached qfx file does not work. I > have > > personal Bank of American checking and credit card. They all work. I > > downloaded the file by using the ?Web Connect for Quicken 2018 and > above?. > > > > > > > > I have a suspicion why it is not working. Maybe it is because a combined > > qfx file. BofA organized their business account in a group fashion. > They > > made a parent account and each credit card holder as a child account. > Their > > personal account doesn?t follow this parent-child account structure. > > > > > > > > Does anyone has a solution for this kind of qfx file? > > > > > > > > Best, > > > > Peter > > > > > > > > > > > > > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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.
