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

[Jean Laroche]

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.