[GNC] GnuCash/AqBanking headaches

[John Ralls]

> On Dec 18, 2019, at 8:15 AM, brakechute <brakechute at gmail.com> wrote:
> 
> Hello all.  Been searching the list but couldn't find this issue so I may
> have broken things in a new way. :)
> 
> I have been using GnuCash 3.7 on a Windows 7 system (yeah, Windows) and have
> just been importing transactions from CSV up to now.  This is a clunky
> process as the files from my banks need to be edited in Calc before I can
> successfully import them.  I decided to try the online banking feature and
> failed miserably. I have tried to follow the guidelines in the wiki but must
> be missing something, hopefully someone familiar with this can point it out.
> 
> So, I start the wizard and "create user", select the "OFX DirectConnect",
> find the bank in the list. I put in my name, the user name at the bank, and
> have tried both leaving the UUID blank and inserting a generic one.  I have
> tried multiple emulations and get the same result every time:
>   Retrieving SSL certificate
>   Connecting to server...
>   Using GnuTLS default ciphers.
> And at this point GnuCash crashes out.
> 
> I have tried running as a user and running privileged with the same result. 
> When I restart and go back to the wizard a new user is in the list, but
> cannot be deleted (Error deleting user -109).  I just can't get anything to
> set up.  Anyone have any thoughts?  Thanks in advance.

I doubt that running as an admin would make a difference.

Make sure that you're really using 3.7 or earlier for OFX Direct Connect.

Go to https://ofxhome.com and look up your bank. At the bottom of the record make sure that it has validated within the last week or two: If it hasn't the publicly available OFX setup information is at best stale, but more likely they no longer support OFX Direct Connect or have adopted new software that will only talk to Quicken. Some of the banks in that last category have adopted software that doesn't actually use OFX Direct Connect: One bank with which I do business has a note on their website saying that the file exchange format is the Intuit-proprietary QDF. It wouldn't surprise me at all to learn that a stream of that would crash AQBanking and take GnuCash out with it.

Does your bank offer OFX, QFX, or QIF downloads?

Regards,
John Ralls