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

[Jean Laroche]

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

On 5/4/22 9:51 AM, Jean Laroche wrote:
> 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.