[GNC] VISA Transactions downloads issue

[John Ralls]

OK, there's no separate config file for libofx. The association between the account number in the OFX file (the <ACCTID> element; my Capital One account uses the last 4 digits of the CC number) and the GnuCash account is established by a data element attached to the account named online_id. That should be the id shown in the Import Map Editor.

If you've successfully deleted the online_id with the import match editor then at the next import GnuCash should ask you into what account to import the data. If that doesn't happen then the GnuCash is finding that account id associated with account v1 somewhere. First make sure that it doesn't show up anywhere else in the import map editor, and make sure that account v2 isn't a placeholder. The simplest way to find that is to use a text search: Make sure that Comporess Files in Preferences>General under Files is unchecked, then save the file and open it with your favorite text editor. Search for the account id and see if it turns up anywhere.

Regards,
John Ralls


> On May 14, 2023, at 18:24, Ze'ev Ionis <z.ionis at mendz.com> wrote:
> 
> I use the menu options 'File/Import/Import OFX/QFX’.  I don’t use AQBanking.  I first download the file from the bank, and then import it using the option above.
>  
> Ze’ev
>  
> -----Original Message-----
> From: John Ralls <jralls at ceridwen.us> 
> Sent: Sunday, May 14, 2023 6:16 PM
> To: Ze'ev Ionis <z.ionis at mendz.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] VISA Transactions downloads issue
>  
> Do you mean that you're downloading via OFX DirectConnect using AQBanking? In that case there's a config directory named .aqbanking in your home directory. If you've been using aqbanking for a long time there will be three subdirectories, backends, settings, and settings6. The last is the one of interest. You're probably better off manipulating its contents via the AQBanking setup program run via Tools>Online Banking Setup than trying to figure out what to edit by hand.
>  
> If you're doing something else, please provide the details.
>  
> Regards,
> John Ralls
>  
>  
> > On May 14, 2023, at 10:08, Ze'ev Ionis <z.ionis at mendz.com <mailto:z.ionis at mendz.com>> wrote:
> > 
> > I download transactions from the CIBC bank here in Canada.  Mostly, it works great.  However, two of my Visa transactions seem to have gotten "entangled".  That is, when I download either Visa, the transactions always go to one account - call it V1.  When I look in the Import Map Editor, Online Tab, I see that for V2 the correct match string is there, but none of the transactions go there!  When I look at V1 there is no Match String, and all the transactions for V2 and V1 invariably go there to V1.  I have deleted The V1 and V2 entries a number of times but cannot seem to get the match string to show up for V1 - it always "sucks" the transactions for both V1 and V2 into itself!  I figure there must be a config file somewhere that I could edit directly but have no idea where that might be.  Any help would be appreciated!
> > 
> > Ze'ev Ionis
> > 
> > _______________________________________________
> > 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
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.