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

David Carlson david.carlson.417 at gmail.com
Wed May 4 22:47:33 EDT 2022 

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

More information about the gnucash-user mailing list