[GNC] AQBanking OFX DirectConnect

[Chris Graves]

John,

You are probably right, but here is an excerpt from the working ofx.log
file, so I guess I'm not sure what enabled this progress:
Sending:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318152018.000

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20200318152011.000
<USERID>xxxxxxx
<USERPASS>xxxxxxxxxx
<LANG>ENG
<FI>
<ORG>KINECTA
<FID>322278073
</FI>

On Wed, Mar 18, 2020 at 5:10 PM John Ralls <jralls at ceridwen.us> wrote:

> Chris,
>
> You have it backwards: Martin changed LANG -> LANGUAGE because that's what
> AQB5 used.
>
> However, I just tested on a bank account at USAA and that worked, except
> that it crashed GnuCash when trying to process the new transactions. That's
> probably not AQBanking's doing and I'll look into that separately.
>
> Next I'll try Martin's command-line test.
>
> Regards,
> John Ralls
>
>
> > On Mar 18, 2020, at 4:57 PM, Chris Graves <mohavebaked at gmail.com> wrote:
> >
> > John,
> >
> > In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says
> LANG, which is what Martin just fixed.
> >
> > On Wed, Mar 18, 2020 at 4:54 PM John Ralls <jralls at ceridwen.us> wrote:
> > Progress indeed, though still not enough for USAA. :-(
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 18, 2020, at 4:48 PM, Chris Graves <mohavebaked at gmail.com>
> wrote:
> > >
> > > Wow! making serious progress now.  I was requesting transactions from
> my checking account.  Looking at the ofx.log file, they were returned!!!
> > >
> > > However the import process indicated that there were no transactions
> to be imported.
> > >
> > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss <martin at aqbanking.de>
> wrote:
> > > Hi,
> > >
> > > I just checked in another change... While comparing your logs I found
> > > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> > >
> > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> > >
> > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > > didn't contain that line...
> > >
> > > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > > was what made the server reject the request due to syntax error...
> > >
> > > Fixed in git.
> > >
> > >
> > > Regards
> > > Martin
> > >
> > >
> > > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > > That's what mine says:
> > > >     char flags="forceSsl3", "sendShortDate"
> > > >     char bankName="USAA Federal Savings Bank"
> > > >     char org="USAA"
> > > >     char fid="24591"
> > > >     char serverAddr="https%3A%2F%2Fservice2.usaa.com
> %2Fofx%2FOFXServlet"
> > > >     char appId="QWIN"
> > > >     char appVer="2300"
> > > >     char headerVer="102"
> > > >     int  httpVMajor="0"
> > > >     int  httpVMinor="0"
> > > >   }
> > > >
> > > > Regards,
> > > > John Ralls
> > > >
> > > >
> > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss <martin at aqbanking.de>
> wrote:
> > > >>
> > > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > > >> are... That can currently only be changed directly in the
> configuration
> > > >> file:
> > > >>
> > > >> $HOME/.aqbanking/settings6/users/*.conf
> > > >>
> > > >> Some servers only accept httpVMinor="0"...
> > > >>
> > > >>
> > > >> Regards
> > > >> Martin
> > > >>
> > > >>
> > > >>
> > > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > > >>> Sigh, that's not it either:
> > > >>> Sending:
> > > >>> -------------------------------------
> > > >>> OFXHEADER:100
> > > >>> DATA:OFXSGML
> > > >>> VERSION:102
> > > >>> SECURITY:NONE
> > > >>> ENCODING:USASCII
> > > >>> CHARSET:1252
> > > >>> COMPRESSION:NONE
> > > >>> OLDFILEUID:NONE
> > > >>> NEWFILEUID:20200318151247.000
> > > >> [...]
> > > >>
> > > >> --
> > > >> "Things are only impossible until they're not"
> > > >
> > >
> > >
> > > --
> > > "Things are only impossible until they're not"
> >
>
>