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 <[email protected]>
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu <[email protected]>
Cc: [email protected] <[email protected]>, Gnucash
Users <[email protected]>
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
<[email protected]<mailto:[email protected]>> 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
<[email protected]<mailto:[email protected]>> 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
<[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
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
[email protected]
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
[email protected]
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.
