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

Thu May 5 09:21:14 EDT 2022

Thanks Jean.

If you are using BofA business credit card, there are few keys and rows you need to delete.  There maybe more, but here is what we know so far:

MERCHCAT

EXPCAT

CARDNUM

CARDNAME

MCC

Protip, use visual studio code to edit qfx.  Find the word, highlight the selection ctl+shift+L, ctl+I to edit multiple lines and delete all occurrences with few strokes.
(Search how to delete multiple lines VScode.)

I filed a bug with libOfx to handle this better.

For Gnucash communities, do you think we could use above fields to better match transactions?  Content for above fields are like:
                        <MERCHCAT>COMM. SPORTS, PROF. SPORTS CLUBS, ATHLETIC FI
                        <EXPCAT>Amusement and Entertainment
                         <CARDNUM>9767
                         <CARDNAME>ELExxx xxx LLC
<MCC>0000
I am not sure what MCC is, but other fields are self explanatory.

Best,
Peter

From: Jean L <ripngo at gmail.com>
Date: Wednesday, May 4, 2022 at 22:09
To: Peter Wu <peter_cd.cn at hotmail.com>, 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

You launch GC with the --debug flag. If you're on MacOS, you have to go to a console, find the path to your Gnucash, then do GnucashApp/contents/MacOs/Gnucash/Gnucash --debug (from memory, so I'm sure some of this is wrong)

Same idea on windows and linux, launch from the command line with the --debug flag.

J

On 5/4/2022 8:23 PM, Peter Wu wrote:
@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><mailto:gnucash-user-bounces+peter_cd.cn=hotmail.com at gnucash.org> on behalf of Jean Laroche <ripngo at gmail.com><mailto:ripngo at gmail.com>
Date: Wednesday, May 4, 2022 at 09:52
To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <gnucash-user at gnucash.org><mailto: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><mailto:david.carlson.417 at gmail.com>
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu <peter_cd.cn at hotmail.com><mailto:peter_cd.cn at hotmail.com>
> Cc: stepbystepfarm at comcast.net<mailto:stepbystepfarm at comcast.net> <stepbystepfarm at comcast.net><mailto:stepbystepfarm at comcast.net>, Gnucash Users <gnucash-user at gnucash.org><mailto: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><mailto: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><mailto: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><mailto: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><mailto: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<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.
_______________________________________________
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.