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

Jean L ripngo at gmail.com
Thu May 5 01:09:34 EDT 2022 

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:ripngo at 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.com at gnucash.org> on behalf 
> of Jean Laroche <ripngo at gmail.com>
> *Date: *Wednesday, May 4, 2022 at 09:52
> *To: *gnucash-user at gnucash.org <gnucash-user at 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.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 
> <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 
> <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 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 
> <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.
>

More information about the gnucash-user mailing list