[GNC] AQBanking OFX DirectConnect

[John Ralls]

Chris,

I guess in your case it was having OFXHEADER:100 and VERSION:102. I think that's all that changed between your last failed run and the successful one.

Regards,
John Ralls

> On Mar 18, 2020, at 5:21 PM, Chris Graves <mohavebaked at gmail.com> wrote:
> 
> 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"
> > 
>