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

Wed May 4 23:03:25 EDT 2022

Or I think like Jen was saying, ignore custom tags and don’t import the value.  Only import stander values, and do not raise exception.

It is raising exception and cause the consumer(gnucash) to fail.

Best,
peter

From: gnucash-user <gnucash-user-bounces+peter_cd.cn=hotmail.com at gnucash.org> on behalf of David Carlson <david.carlson.417 at gmail.com>
Date: Wednesday, May 4, 2022 at 19:48
To: David Reiser <dbreiser at icloud.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] QFX file for Bank of American business account not
I agree, Libofx doesn't need to go down that rabbit hole, but it could
throw an error message if it finds that rabbit hole.

On Wed, May 4, 2022 at 9:12 PM David Reiser via gnucash-user <
gnucash-user at gnucash.org> wrote:

> The three tags in question are not valid OFX tags, which means they are
> custom to either QFX  or BofA. I’d seriously doubt libofx would be willing
> to get into trying to maintain custom tags.
> --
> Dave Reiser
> dbreiser at icloud.com
>
>
>
>
>
> > On May 4, 2022, at 9:49 PM, davidcousens49 at gmail.com wrote:
> >
> >
> >
> > 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.
> >
> > _______________________________________________
> > 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.
>

--
David Carlson
_______________________________________________
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.