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...@hotmail.com <mailto:peter_cd...@hotmail.com> >
To: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> "
<gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
Subject: [GNC] QFX file for Bank of American business account not
invoking Import Matcher
Message-ID:
<dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.OUTLOOK.C
OM
<mailto:dm8p221mb05727f95859d29b4d429f0a4c2...@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@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.
