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

Peter Wu peter_cd.cn at hotmail.com
Wed May 4 23:23:35 EDT 2022


@Jean Laroche<mailto:ripngo at gmail.com>, can you send some instructions on how to run the debug mode?

I have another QFX file from BofA too.  It failed even after I remove CARDNUM, CARDNAME and MCC elements.

I suspect there are more invalid tags in this file.

Btw, the sample file I give you worked after removing above three tags.

Best,
Peter

From: gnucash-user <gnucash-user-bounces+peter_cd.cn=hotmail.com at gnucash.org> on behalf of Jean Laroche <ripngo at gmail.com>
Date: Wednesday, May 4, 2022 at 09:52
To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher
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?

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 8:38 AM, Peter Wu wrote:
> Hi David C,
>
> It is all new transactions.  If it is previously imported transaction, it would give a error dialog saying no new transaction.
>
> But for the given QFX, it just does nothing after you click okay to import the file.
>
> By the way, I am using the latest Mac OS on latest Gnucash version.
>
> Should I reply all with email or just reply to the mailing list?
>
> Best,
> Peter
>
> From: David Carlson <david.carlson.417 at gmail.com>
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu <peter_cd.cn at hotmail.com>
> Cc: stepbystepfarm at comcast.net <stepbystepfarm at comcast.net>, Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher
> If your file already contains a transaction that was previously imported with the same reference number,  Gnucash does not import it again.
>
> On Wed, May 4, 2022, 9:11 AM David Carlson <david.carlson.417 at gmail.com<mailto:david.carlson.417 at gmail.com>> wrote:
> Probably, but you do not explain what happens or doesn't happen when you click on "Import OFX/QFX"?  Are you able to see the filename and select it?  Is there an error message?
>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu <peter_cd.cn at hotmail.com<mailto:peter_cd.cn at hotmail.com>> wrote:
> Quote:
> What is your reasoning to expect THAT (data intended for some sort of bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash
>
> For personal account checking or credit card. It is the same user flow, use the web connect for quicken 2018 or above download a qfx file and everything works fine.
>
> I would expect this biz credit to work too. They are from the same institution and UI flow is the same.
>
> Somehow the downloaded qfx won’t work. I attached the file in the first email.
>
> I used a diff checker to check personal qfx and biz credit card qfx. Inside the file, keys are different.
>
> Is it because how gnucash is parsing the file?
>
> Thanks,
> Peter
>
> Sent from my iPhone
>
>> On May 4, 2022, at 6:47 AM, Michael or Penny Novack <stepbystepfarm at comcast.net<mailto:stepbystepfarm at comcast.net>> wrote:
>>
>> What is your reasoning to expect THAT (data intended for some sort of bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org<mailto: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.
_______________________________________________
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.


More information about the gnucash-user mailing list