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

Wed May 4 21:49:12 EDT 2022

The other possibility if libofx supports the credit card tags  would be to give
users the option of having the different card numbers recognized as subaccounts
of the main credit card account .  If libofx doesn't support it it is unlikely
much can be done other than raising it as an issue with the libofx developer(s).
Once it is in libofx then GnuCash can be modified to recognize the situation.

David Cousens

On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
> 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.
> > 
> _______________________________________________
> 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.