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 <rip...@gmail.com>
Date: Wednesday, May 4, 2022 at 22:09
To: Peter Wu <peter_cd...@hotmail.com>, gnucash-user@gnucash.org 
<gnucash-user@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:rip...@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....@gnucash.org><mailto:gnucash-user-bounces+peter_cd.cn=hotmail....@gnucash.org>
 on behalf of Jean Laroche <rip...@gmail.com><mailto:rip...@gmail.com>
Date: Wednesday, May 4, 2022 at 09:52
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> 
<gnucash-user@gnucash.org><mailto:gnucash-user@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....@gmail.com><mailto:david.carlson....@gmail.com>
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu <peter_cd...@hotmail.com><mailto:peter_cd...@hotmail.com>
> Cc: stepbystepf...@comcast.net<mailto:stepbystepf...@comcast.net> 
> <stepbystepf...@comcast.net><mailto:stepbystepf...@comcast.net>, Gnucash 
> Users <gnucash-user@gnucash.org><mailto:gnucash-user@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....@gmail.com<mailto:david.carlson....@gmail.com><mailto:david.carlson....@gmail.com><mailto:david.carlson....@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...@hotmail.com<mailto:peter_cd...@hotmail.com><mailto:peter_cd...@hotmail.com><mailto:peter_cd...@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 
>> <stepbystepf...@comcast.net<mailto:stepbystepf...@comcast.net><mailto:stepbystepf...@comcast.net><mailto:stepbystepf...@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@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org><mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@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@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.

Reply via email to