[GNC] QFX file for Bank of American business account not

[David Carlson]

Perhaps there should be a GnuCash error message if libofx fails.

On Wed, May 4, 2022, 4:41 PM Jean Laroche <ripngo at 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.cn at hotmail.com <mailto:peter_cd.cn at hotmail.com>
> >
> >
> > To: "gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> "
> > <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> >
> > Subject: [GNC] QFX file for Bank of American business account not
> >
> >                  invoking Import Matcher
> >
> > Message-ID:
> >
> >
> >
> <DM8P221MB05727F95859D29B4D429F0A4C2C39 at DM8P221MB0572.NAMP221.PROD.OUTLOOK.C
> > OM
> > <mailto:
> DM8P221MB05727F95859D29B4D429F0A4C2C39 at 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 at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>