[GNC] OFX setup

Tue Jul 7 09:04:21 EDT 2020

The one I have been using to test GnuCash is Chase.

I may not have mentioned before: I am using a script I wrote using the ofxtools library to download from a few different financial institutions.  I am aware of Chase's clientuid connection requirement and have a valid clientuid.  Also, I successfully connect to Chase and see my account numbers in the log window when setting up a aqbanking user in GnuCash.

If you mean clientuid when you say customer id, I have the right one.  I also specifically picked the appid and appver to be the same as my script.

I haven't tried debugging again yet.  Hopefully the query being sent will show up on the /tmp/ofx.log file.

thanks,
fleur
--
Fleur Dragan / fleur at obscure.org

> On Jul 7, 2020, at 3:56 AM, John Ralls <jralls at ceridwen.us> wrote:
> 
> That is progress. 104 is an internal server error, meaning that the bank's server didn't like what you sent it. It may need a different QWIN, a customer ID, or you might have to set up online banking at their end first. Tell us the bank name, maybe someone else here has experience with them.
> 
> Regards,
> John Ralls
> 
> 
>> On Jul 6, 2020, at 9:41 AM, Fleur Dragan <fleur at obscure.org> wrote:
>> 
>> 
>> It didn't even occur to me I couldn't send an attachment to the list.  I facepalm.  I'll go through it again with debugging and send you the output directly tomorrow.  Thanks.
>> 
>> And of course, before I wrote this, I was so excited I forgot to set up debugging and I went and tried setting up an account with just the routing and account numbers.  When I clicked ok, it threw up an error dialog saying "unable to update account spec."  When I clicked dismiss, the account was actually there.
>> 
>> I was able to advance to the window to associate the account with a GnuCash account, and did so.  Then I went to the register, selected Actions > Online Actions > Get Transactions..., chose to download from yesterday, and got this:
>> 
>> AqBanking v6.2.1.0stable
>> Sending jobs to the bank(s)
>> Sorting commands by account
>> Sorting commands by account
>> Sorting commands by provider
>> Send commands to providers
>> Send commands to provider "aqofxconnect"
>> Error Sending commands to provider "aqofxconnect":-104
>> 
>> So...progress?
>> 
>> (Also, the "Select Backend" window just sticks around no matter what I do, until quit.)
>> 
>> 
>> fleur
>> --
>> Fleur Dragan / fleur at obscure.org
>> 
>> 
>> 
>> 
>>> On Jul 6, 2020, at 5:09 PM, John Ralls <jralls at ceridwen.us> wrote:
>>> 
>>> Unfortunately the stderr/stdout capture didn't make it through the list. You may send them directly to me if you like, but please first go through them and remove any identifying information, especially the bank routing id, account numbers, and any PINs or passwords.   
>>> 
>>> All that you need for an OFX account setup is the Routing ID and Account number. The former goes in the Bank Code field, the latter in the Account Number field. Both should have been in the log window output; you can edit the user and retrieve accounts again if you need to. The Bank and Account names are used to identify the account in the UI so you can enter whatever you like. The other fields are for HBCI/FinTS and can safely be left blank.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Jul 6, 2020, at 4:33 AM, Fleur Dragan <fleur at obscure.org> wrote:
>>>> 
>>>> 
>>>> First I set:
>>>> 
>>>> export GWEN_LOGLEVEL=debug
>>>> export AQBANKING_LOGLEVEL=debug
>>>> export AQOFX_LOG_COMM=1
>>>> export AQOFXCONNECT_LOGLEVEL=debug
>>>> 
>>>> 
>>>> Then I ran, just to be safe:
>>>> 
>>>> rm -rf ~/.aqbanking/
>>>> 
>>>> 
>>>> Then I ran:
>>>> 
>>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug 2>&1 | tee gnc.out
>>>> 
>>>> 
>>>> Once GnuCash started up, I tried to set up a user, which was successful.  Then I tried to retrieve accounts, which was also successful, but no accounts were created in the aqbanking window.  I tried to create an account, but it's not clear what information each field wants, especially since it's designed to be country agnostic.  Is BIC SWIFT the routing number for my US account?  Is country "US" or "United States" or something else?  Bank Name?  The one in www.ofxhome.com?  The one on their website?  Can't get much more ambiguous than bank name.  The look up bank code doesn't appear to do anything, so I have no idea if the bank code is the OFX FI, the routing number, or something else.  There are enough ambiguous fields, trying various combinations is prohibitive.  If there is documentation, in English (google translate will not understand subtleties of BIC/IBAN/SWIFT/routing number), for setting up OFX accounts, I will happily try again.
>>>> 
>>>> There were no errors in /tmp/ofx.log.
>>>> 
>>>> There don't seem to be any errors in the output, and nothing was in the trace file, so I guess I read how to turn that on wrong.  I've attached the stdout/stderr output.  Will the trace be helpful?  If so, I'll go back and to that.  What else have I missed?
>>>> 
>>>> 
>>>> 
>>>> thanks,
>>>> fleur
>>>> --
>>>> Fleur Dragan / fleur at obscure.org
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Jul 5, 2020, at 1:14 AM, Frank H. Ellenberger <frank.h.ellenberger at gmail.com> wrote:
>>>>> 
>>>>> Hi,
>>>>> 
>>>>> Am 05.07.20 um 00:51 schrieb peterb:
>>>>>> Fleur Dragan said:
>>>>>> 
>>>>>>> So when I try to set up OFX connectivity, the user is created
>>>>>>> successfully.  Then I try to retrieve accounts, which do show up in the log
>>>>>>> window, and the log window says I may now close, but when I do, nothing
>>>>>>> happens.  This was the same behavior I saw with aqbanking 6.1.4.
>>>>>>> 
>>>>>> 
>>>>>> This was the exact same behavior I saw in 3.10.  I haven't tried it with
>>>>>> 4.0 yet.  The overall user impression was "Your login has succeeded!
>>>>>> Nothing happens."
>>>>>> 
>>>>>> -P
>>>>> 
>>>>> just in case the one or other wants to dig deeper:
>>>>> * https://wiki.gnucash.org/wiki/AqBanking#Debugging
>>>>> * https://wiki.gnucash.org/wiki/Tracefile
>>>>> Flatpak users only:
>>>>> https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output
>>>>> 
>>>>> HTH
>>>>> Frank
>>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> 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 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 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.
> 
> 