[GNC] aqbanking date offset in GnuCash

When I import from my Credit Union to GnuCash using AqBanking there seems to be a date offset. I suspect this may be due to UTC vs Local Time. When I import, I do not see the the current transactions unless I set the "To" date in the "Get Transaction Online" dialog to 'tomorrow'. So, I

Re: [GNC] Aqbanking

I urge you not to try. But if you log into your bank and look for information on Quicken compatibility and it specifically says “QFX DirectConnect”, you have a chance. It may still be a challenge to find the connection information because Quicken and the bank don’t tell their tech support

Re: [GNC] Aqbanking

> On Apr 20, 2024, at 09:18, Dennis Powless wrote: > > How do I determine if my bank participates or offers ofx direct connect, > aqbanking? You can see if they have an entry at https://ofxhome.com , but that's crowdsourced so it isn't authoritative. For that you

[GNC] Aqbanking

How do I determine if my bank participates or offers ofx direct connect, aqbanking? Dennis ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Aqbanking

I am using the new 5.6 Gnucash on Win11, and aqbanking does not show under the "Tools" menu. I see no way to set it up using Windows. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email ___

[GNC] Aqbanking not included with gnucash for windows??

Just downloaded gnucash for windows. Help says click Tools>Online Banking Setup... while in a register. That took doesn't appear. What do I do next? Barry Milliken ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

[GNC] AqBanking and Direct Connections

Hi Everyone, I want to explore an OFX Direct Connection to my bank(s). Currently I down load to OFX and then import. But I would prefer to have a real time update. Please can I get some feed back: 1. Have you successfully connected to a UK bank were there any issues? 2. Has anyone had any

Re: [GNC] AqBanking Online Set Up

YAS! General Journal Register ftw! woot! Even imported five bank accounts. Okay so now I manually click the amounts to correct account. Sweet! Wish I was using GNU Cash Years ago. On Tue, Jan 4, 2022 at 1:28 PM John Ralls wrote: > Yup, 10 months: > 2021030112[-8] >

Re: [GNC] AqBanking Online Set Up

Yup, 10 months: 2021030112[-8] 2021123112[-8] Are you sure that GnuCash imported only December's transactions? Did you change the filter on the General Journal register or look in the account's register? Regards, John Ralls > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall >

Re: [GNC] AqBanking Online Set Up

The import went smooth. Alot eaier then a .csv and other softwares I've used in my career. QFX is what I got but Royal Bank only included December transactions in the file when I chose the entire year. So this is great. Can download one file a month and post each transaction to proper account

Re: [GNC] AqBanking Online Set Up

You are right. I agree with you. I noticed this last night. On Tue, Jan 4, 2022 at 10:02 AM john wrote: > No, those are file download types, not connection options. Money means > OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably > means QBO but might also mean QFX or QIF.

Re: [GNC] AqBanking Online Set Up

https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx At the end of the QFX import you were presented with a window listing all of the imported new transactions. Since

Re: [GNC] AqBanking Online Set Up

No, those are file download types, not connection options. Money means OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor what file type Sage likes. GnuCash can handle the Money or Quicken

Re: [GNC] AqBanking Online Set Up

I was able to download in QFX format. I did the import. How do I assign the transactions to the accounts now? I see some of the transactions are posted in GL but I do not see the entire year of transactions. Just December. On Mon, Jan 3, 2022 at 9:28 PM john wrote: > Not necessarily. You

Re: [GNC] AqBanking Online Set Up

Not necessarily. You just need to see if Quicken knows how to connect to RBC and if so whether they authenticate with DirectConnect (which AQBanking can handle), Express WebConect, or WebConnect (both of which it can't). It just as possible that what that page is really talking about is

Re: [GNC] AqBanking Online Set Up

Merci, that eliminates two of the options. I see a forum to a missing institution and connections http://www.ofxhome.com/ofxforum//viewforum.php?id=3. I see someone two years ask about Canadian Banks. No response http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 Here someone says TD Bank

Re: [GNC] AqBanking Online Set Up

Am 04.01.22 um 05:22 schrieb john: > EBICS is also German only. No, European: AT, CH, DE, FR. But at least in DE only offered for the (more expensive) business accounts. Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] AqBanking Online Set Up

On 2022-01-03 8:22 p.m., john wrote: Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank of *Canada* is absolutely not a German bank and isn't likely to support HBCI. EBICS is also German only.

Re: [GNC] AqBanking Online Set Up

Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank of *Canada* is absolutely not a German bank and isn't likely to support HBCI. EBICS is also German only. https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html

Re: [GNC] AqBanking Online Set Up

On 2022-01-03 5:39 p.m., Jesse MacDougall wrote: Guy's, I'm stumped here. My Bank is Royal Bank in Canada. I have no idea where to get this information from. When I call the bank they talk to me like I am a terrorist due to Iddiocracy. Never seen this side of technology before. I read the

[GNC] AqBanking Online Set Up

Guy's, I'm stumped here. My Bank is Royal Bank in Canada. I have no idea where to get this information from. When I call the bank they talk to me like I am a terrorist due to Iddiocracy. Never seen this side of technology before. I read the AqBanking wiki but didn't advance. -- * Please

Re: [GNC] AqBanking Wizard won't start

Am 25.11.20 um 19:56 schrieb Peter Dutton: > Not sure how to use flatpak. The command to start the flatpak version of GnuCash is: flatpak run org.gnucash.GnuCash from https://wiki.gnucash.org/wiki/Flatpak#Regular_releases_from_flathub.org ___

[GNC] AqBanking Wizard won't start

I'm trying to get the Aqbanking wizard to run. While in GC v 3.11 I clicking on Start AqBanking Wizard (button) does nothing. I installed Flatpak which had no effect so far. Not sure how to use flatpak. I'm running- Ubuntu 18.04 Mate Thanks, Peter

Re: [GNC] AQbanking ofx.log

John/Frank - Thanks for your comments. The URL is correct and I see them in OFX-Direct Connect database. But I don’t see any successful attempts. BTW the institution is Merrill Lynch. I managed to get the list of accounts based on my username and PWD. But when I try to download transactions

Re: [GNC] AQbanking ofx.log

Shyam, The http 400 status *is* the bank's response and it means that either that you're not connecting to an OFX-Direct Connect server or that the server thinks that the HTTP request is malformed. Have you confirmed at http://ofxhome.com that your bank supports OFX-Direct Connect and has

Re: [GNC] AQbanking ofx.log

If the transfer occurs, you will see the receive data stream in the log file. The 400 error suggests the site on the other end is not responding (or locking you out). Make sure the bank hasn’t changed it’s ofx access address, or shut it off. -- Dave Reiser dbrei...@icloud.com > On Nov 14,

Re: [GNC] AQbanking ofx.log

Frank/John - Thanks for the assist. I was able to generate a logfile by setting environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, when I look at the log, I see what was sent. But don’t see the bank's response. Perhaps my expectation that the response is captured is

Re: [GNC] AQbanking ofx.log

Hi, Am 14.11.20 um 04:43 schrieb John Ralls: > > >> On Nov 13, 2020, at 4:28 PM, Shyam Acharya wrote: >> >> Hi – >> >> I am a new user and trying to debug an online banking setup. How (and where) >> can I can turn on enhanced logging “AQOFX_LOG_COMM=1” so I can decipher the >> problem? >>

Re: [GNC] AQbanking ofx.log

> On Nov 13, 2020, at 4:28 PM, Shyam Acharya wrote: > > Hi – > > I am a new user and trying to debug an online banking setup. How (and where) > can I can turn on enhanced logging “AQOFX_LOG_COMM=1” so I can decipher the > problem? > > I use a PC WIN10 GNUCASH ver 4.2. I do have access to

[GNC] AQbanking ofx.log

Hi – I am a new user and trying to debug an online banking setup. How (and where) can I can turn on enhanced logging “AQOFX_LOG_COMM=1” so I can decipher the problem? I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well. Thanks ___

Re: [GNC] AqBanking OFX DirectConnect issues

Thanks for mentioning that. I have completely given up on aqbanking within GC, I struggled mightily to make it work and failed, and decided to go the ofx way. I personally use ofxclient, there's also ofxget. But sadly recently my bank (Patelco) stopped their ofx server, there was a long

Re: [GNC] AqBanking OFX DirectConnect issues

Thanks for the info. FYI If you know python, and are so inclined, there are OFX libraries you can use to generate those requests. ofxtools is one. fleur -- Fleur Dragan / fl...@obscure.org > On Jul 12, 2020, at 11:11 AM, Dan Howell wrote: > > On Fri, Jul 10, 2020 at 09:21 AM EDT fleur

Re: [GNC] AqBanking OFX DirectConnect issues

On Fri, Jul 10, 2020 at 09:21 AM EDT fleur wrote: > I can't help unfortunately, but I'm having my own OFX setup issues and I'm > curious: What platform do you run GnuCash on? Also, were you successful in > re-setting up your Chase account(s)? > As I said in my original message, I'm using

Re: [GNC] AqBanking OFX DirectConnect issues

Hi, Am 10.07.20 um 05:54 schrieb Dan Howell: [...] > By sending the same request through cURL, but moving the parameter > to right after (where it was with AqBanking 5), the query succeeds: [...] > So if this could be routed to the proper person who could fix this, I would > be grateful for

Re: [GNC] AqBanking OFX DirectConnect issues

On 2020-07-09 20:54, Dan Howell wrote: …when importing OFX files manually (i.e. through File > Import), where the string is put in the Description field, and the is put in the Notes field, although with added cruft like, "OFX ext. info: |Trans type:Generic debit|Memo:" which is a bit annoying

Re: [GNC] AqBanking OFX DirectConnect issues

Hi Dan, I can't help unfortunately, but I'm having my own OFX setup issues and I'm curious: What platform do you run GnuCash on? Also, were you successful in re-setting up your Chase account(s)? (Also, I'll +1 on the cruft in the notes field on manual import.) thanks, fleur -- Fleur Dragan

[GNC] AqBanking OFX DirectConnect issues

Hi, After upgrading from GnuCash 3.7 to 4.0 on Windows 10, I realize that comes with an AqBanking upgrade as well, requiring me to re-setup all of my account connections. One issue I'm having is with a Charles Schwab investment account. With AqBanking 5 I was able to import successfully, but

Re: [GNC] AQbanking Amex OFX Download Badly Broken

Message: 5 Date: Sun, 24 May 2020 00:19:33 -0400 From: "Alan" To: "'Gnucash Users'" Subject: [GNC] AQbanking Amex OFX Download Badly Broken Message-ID: <0fbc01d63182$87ba6ea0$972f4be0$@bigtowers.net> Content-Type: text/plain; charset="us-ascii" Tried t

[GNC] AQbanking Amex OFX Download Badly Broken

Tried the Aqbanking section on GnuCash 3.10 with my Amex account. It was encouraging to see the latest version of Aqbanking now recognizes the content in the OFX download (last broken version could only read the headers). Was about to congratulate the development team, but then I noticed something

Re: [GNC] AqBanking for Canadian banks

Nelson wrote > Just wondering if anyone was successful in setting up any Canadian banks > for > online banking in GnuCash. Thanks for sharing. I download transactions from several Canadian banks (BMO, TD, CIBC) in three different GnuCash files on a regular basis. Works just fine. I simply

Re: [GNC] AqBanking for Canadian banks

Nelson writes: > Hello everyone. > > Just wondering if anyone was successful in setting up any Canadian banks for > online banking in GnuCash. Thanks for sharing. Do they support OFX-DC? You can check OFXHome for your bank info? Good Luck, > Please remember to CC this list on all your

[GNC] AqBanking for Canadian banks

Hello everyone. Just wondering if anyone was successful in setting up any Canadian banks for online banking in GnuCash. Thanks for sharing. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] aqbanking not working for me in 3.9 on mac

Ups... that was a stupid bug I introduced some time ago... Fixed in GIT. So, regarding the case at hand: "AQOFX_LOG_COMM=1" will with the current release (up to 6.1.4) create the log file "1" in the current folder. Any other value will use the known path "/tmp/ofx.log" regardless of the value

Re: [GNC] aqbanking not working for me in 3.9 on mac

My experience is that setting AQOFX_LOG_COMM=1 Creates the ofx log file in the current directory, however the name of the file is “1”. > On Mar 30, 2020, at 11:51 AM, Martin Preuss wrote: > > Dave, > > you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create > the default log

Re: [GNC] aqbanking not working for me in 3.9 on mac

I found that not to work when I was working on AQBanking a couple of weeks ago. It wrote the log file to /tmp/ofx.log no matter what I set AQOFX_LOG_COMM to. I also found it necessary to set AQOFXCONNECT_LOGLEVEL=info (or debug) to get AQB to write ofx.log. Regards, John Ralls > On Mar 30,

Re: [GNC] aqbanking not working for me in 3.9 on mac

Dave, you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create the default log file, but in newer versions of AqBanking you can also set the path and name of the log file to use). Martin Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user: > Giving Gnucash 3.9 full disk

Re: [GNC] aqbanking not working for me in 3.9 on mac

Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to work correctly, but does not reenable ofx.log creation. Dave -- Dave Reiser dbrei...@icloud.com > On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user > wrote: > > Gnucash 3.9 on MacOS 10.15.4 is not

[GNC] aqbanking not working for me in 3.9 on mac

Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving transactions for me. I ran a Get Transactions in 3.9 from one of my Chase credit card accounts and got a blank matcher window. Quit 3.9 Launch 3.7, and run the Get Transaction process. One new and one to-be-added transactions are

Re: [GNC] AQBanking OFX DirectConnect

Yeah, and perhaps I wasn't following your advice of: It actually requires make uninstall && make clean && make && make install to ensure that the changed code is used. > On Mar 18, 2020, at 5:32 PM, John Ralls wrote: > > Chris, > > I guess in your case it was having OFXHEADER:100 and

Re: [GNC] AQBanking OFX DirectConnect

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 wrote: > > John, > > You are probably right, but here is an excerpt

Re: [GNC] AQBanking OFX DirectConnect

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

Re: [GNC] AQBanking OFX DirectConnect

That did it! Now to that crash. Regards, John Ralls > On Mar 18, 2020, at 5:06 PM, Martin Preuss wrote: > > So the only remaining difference is the line "bankid" which wasn't in > the aqb5 log. > > Just applied a change to the git repository to change that... > > > Regards > Martin > > >

Re: [GNC] AQBanking OFX DirectConnect

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

Re: [GNC] AQBanking OFX DirectConnect

So the only remaining difference is the line "bankid" which wasn't in the aqb5 log. Just applied a change to the git repository to change that... Regards Martin Am 19.03.20 um 00:53 schrieb John Ralls: > Nope: > Connected. > Sending message... > Message sent. > Waiting for response... >

Re: [GNC] AQBanking OFX DirectConnect

I changed aqb6 to use "LANGUAGE" like aqb5 did, because that is the correct name (don't know where I read "LANG", I guess that was in another protocol...) According to the specs (1.6) "LANGUAGE" should be used. Regards Martin Am 19.03.20 um 00:57 schrieb Chris Graves: > John, > > In your

Re: [GNC] AQBanking OFX DirectConnect

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 wrote: > Progress indeed, though still not enough for USAA. :-( > > Regards, > John Ralls > > > > On Mar 18, 2020, at 4:48 PM, Chris

Re: [GNC] AQBanking OFX DirectConnect

Okay, we should now look for console logs. I'm not sure how Gnucash handles log files, but you could try the process of requesting statements using console-only: 1. get list of accounts: # aqbanking-cli listaccounts Column 6 contains the unique account id to be used in the next step. 2. get

Re: [GNC] AQBanking OFX DirectConnect

Interesting, there were 8 Sending requests and 3 Received responses. Looks like transactions were returned duplicated 3 times. On Wed, Mar 18, 2020 at 4:46 PM Martin Preuss wrote: > > the OFX specs show this example: > > -X8 > POST

Re: [GNC] AQBanking OFX DirectConnect

Progress indeed, though still not enough for USAA. :-( Regards, John Ralls > On Mar 18, 2020, at 4:48 PM, Chris Graves 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

Re: [GNC] AQBanking OFX DirectConnect

Nope: Connected. Sending message... Message sent. Waiting for response... Receiving response... HTTP-Status: 400 (Bad Request) Unlocking customer "8" Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE

Re: [GNC] AQBanking OFX DirectConnect

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 wrote: > Hi, > > I

Re: [GNC] AQBanking OFX DirectConnect

the OFX specs show this example: -X8 POST http://www.fi.com/ofx.cgi HTTP/1.0 User-Agent:MyApp 5.0 Content-Type: application/x-ofx Content-Length: 1032 OFXHEADER:100 DATA:OFXSGML VERSION:160 SECURITY:TYPE1 ENCODING:USASCII CHARSET:NONE

Re: [GNC] AQBanking OFX DirectConnect

I did --- a/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c +++ b/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c @@ -77,7 +77,7 @@ int AO_V1_RequestStatements(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *a, AB_TRAN } GWEN_XMLNode_free(xmlRoot); -#if 0 +#if 1

Re: [GNC] AQBanking OFX DirectConnect

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

Re: [GNC] AQBanking OFX DirectConnect

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"

Re: [GNC] AQBanking OFX DirectConnect

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

Re: [GNC] AQBanking OFX DirectConnect

Hi, hmm, so no linebreaks... Could either of you please try with the following lines commented out in v1/n_toofx.c: - 105: if (hasSubTags) - 106: GWEN_Buffer_AppendString(buf, "\r\n"); - 128: GWEN_Buffer_AppendString(buf, "\r\n"); Will be back in a few mins, have to watch an episode of

Re: [GNC] AQBanking OFX DirectConnect

Is there any easy way to capture the dialog between the client and server? > On Mar 18, 2020, at 3:04 PM, John Ralls wrote: > > The only difference I see now in the ofx.logs is the newlines, and I still > haven't figured out if they're correctly escaped in the http request. > > Regards, >

Re: [GNC] AQBanking OFX DirectConnect

The only difference I see now in the ofx.logs is the newlines, and I still haven't figured out if they're correctly escaped in the http request. Regards, John Ralls > On Mar 18, 2020, at 2:59 PM, Martin Preuss wrote: > > Hi again, > > with the latest changes: Are there any probably

Re: [GNC] AQBanking OFX DirectConnect

Remember, the working ofx from AQB5 is Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200315112517.000 20200315112517

Re: [GNC] AQBanking OFX DirectConnect

It actually requires make uninstall && make clean && make && make install to ensure that the changed code is used. Regards, John Ralls > On Mar 18, 2020, at 2:52 PM, Martin Preuss wrote: > > Hi, > > okay now, the latest GIT version always sets "OFXHEADER:100" and uses > the given header

Re: [GNC] AQBanking OFX DirectConnect

Not sure if it matters, but the OFX clause/aggregate? in AQB5 is on three lines with a line break after the USERID and again after USERPASS. In git, there is a linebreak after each element/aggregate. > On Mar 18, 2020, at 2:51 PM, John Ralls wrote: > > I changed the line just below OFXHEADER

Re: [GNC] AQBanking OFX DirectConnect

Hi again, with the latest changes: Are there any probably important differences in the generated OFX request compared to Aqb5's output (except dates etc.)? Regards Martin Am 18.03.20 um 22:50 schrieb Chris Graves: > Hi Martin, > > The GUI wouldn't let me leave that field blank, so I manually

Re: [GNC] AQBanking OFX DirectConnect

Hi, please see my other mail (latest GIT). Maybe "103" then (I heard of some cases where "103" was necessary)? Or perhaps "160"? Will fix the gui btw... Regards Martin Am 18.03.20 um 22:50 schrieb Chris Graves: > Hi Martin, > > The GUI wouldn't let me leave that field blank, so I manually

Re: [GNC] AQBanking OFX DirectConnect

Hi, okay now, the latest GIT version always sets "OFXHEADER:100" and uses the given header version only for the "VERSION:" header. In that case you can specify "102" and it should create the correct headers... Please note: For reasons not yet understood it might be necessary when updating from

Re: [GNC] AQBanking OFX DirectConnect

I changed the line just below OFXHEADER to GWEN_Buffer_AppendString(buf, "100"); producing the following. No luck, it still returns a 400 error. Regards, John Ralls Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII

Re: [GNC] AQBanking OFX DirectConnect

Hi Martin, The GUI wouldn't let me leave that field blank, so I manually deleted the entry from the .conf file. Running again, it did use the defaults that you specified. However, still the http 400 error and no response. Sending: - OFXHEADER:100 DATA:OFXSGML

Re: [GNC] AQBanking OFX DirectConnect

It won't let you leave that blank, and even if it did it would put '100' in both fields: if (!(s && *s)) s="100"; GWEN_Buffer_AppendString(buf, "OFXHEADER:"); GWEN_Buffer_AppendString(buf, s); GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n"); GWEN_Buffer_AppendString(buf,

Re: [GNC] AQBanking OFX DirectConnect

Hi, not ATM, but that can be arranged. However, how about leaving that field empty in the settings dialog? That should default to 100 for OFXHEADER and 102 for VERSION (for - ahem - historic reasons, I'm sure I had good^H^H^H reasons for those mixed defaults... :-}) Regards Martin Am 18.03.20

Re: [GNC] AQBanking OFX DirectConnect

Nice! I see that the change has been made, but still receive the HTTP 400 error. In the AQB5 ofx.log file for a successful case, I see OFXHEADER:100 VERSION:102 In the AQB6 file, I see OFXHEADER:102 VERSION:102 Not sure if this could be the problem. Is there a way to set OFXHEADER and VERSION

Re: [GNC] AQBanking OFX DirectConnect

Hi, you can change the header manually to 102/103 in the homebanking setup dialog (select user, edit user, switch to app settings and type-in header version 102). Regards Martin Am 18.03.20 um 21:57 schrieb Chris Graves: > Hi Martin, > > Looking better!  However, to my knowledge, my bank only

Re: [GNC] AQBanking OFX DirectConnect

I think that would have been a mistake, git defaults to OFXv1. > On Mar 18, 2020, at 1:38 PM, Christopher Singley wrote: > > See the top post on this thread - John Ralls reporting that git only speaks > OFXv2. However many banks only speak OFXv1. > > I can confirm that I can download from

Re: [GNC] AQBanking OFX DirectConnect

Hi Martin, Looking better! However, to my knowledge, my bank only supports OFX version 102 or 103. I had been using 102. ofx.log: Sending: - OFXHEADER:220 DATA:OFXSGML VERSION:220 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE

Re: [GNC] AQBanking OFX DirectConnect

See the top post on this thread - John Ralls reporting that git only speaks OFXv2.  However many banks only speak OFXv1. I can confirm that I can download from USAA by speaking OFXv1.0.2. I can no longer speak OFXv2 to USAA; something has changed on their side. Sorry John, no workaround yet.

Re: [GNC] AQBanking OFX DirectConnect

Hi Chris, could you please test the latest GIT version? It should create valid OFXv1 requests now, however, I can't test it completely since I only have access to an OFXv2 server... Regards Martin Am 18.03.20 um 16:31 schrieb chris graves: > An additional bit of information from /tmp/ofx.log:

Re: [GNC] AQBanking OFX DirectConnect

Here is what I was thinking were significant differences found in ofx.log. AQB5 vs git, which should be defaulting to OFX 1. AQB5: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE

Re: [GNC] AQBanking OFX DirectConnect

But I'm using (or trying to use) OFX V1. > On Mar 18, 2020, at 1:23 PM, John Ralls wrote: > > That would be because they are XML syntax. OFX V2 is XML. > > Regards, > John Ralls > > >> On Mar 18, 2020, at 1:15 PM, chris graves wrote: >> >> Because I don't see them in the AQB5 ofx.log file

Re: [GNC] AQBanking OFX DirectConnect

That would be because they are XML syntax. OFX V2 is XML. Regards, John Ralls > On Mar 18, 2020, at 1:15 PM, chris graves wrote: > > Because I don't see them in the AQB5 ofx.log file and to me they look like > XML syntax. Not being knowledgeable on the subject I can't say for sure. I >

Re: [GNC] AQBanking OFX DirectConnect

Because I don't see them in the AQB5 ofx.log file and to me they look like XML syntax. Not being knowledgeable on the subject I can't say for sure. I thought at v1.6, the syntax was pure SMGL. But again, I don't know what I don't know. > On Mar 18, 2020, at 1:12 PM, John Ralls wrote: > >

Re: [GNC] AQBanking OFX DirectConnect

Don't worry about that.  That's a standard OFXv2 header (i.e. compliant XML).  The other headers you were noting earlier are OFXv1 headers (i.e. the weird INI-formatted key: value pairs prepended to the SGML soup). The problem I have is that USAA bank tells me it will speak OFXv2, and then

Re: [GNC] AQBanking OFX DirectConnect

And why were you thinking that? Regards, John Ralls > On Mar 18, 2020, at 1:05 PM, chris graves wrote: > > I was thinking that it could be the first two lines of your file below. > >> On Mar 18, 2020, at 12:40 PM, John Ralls wrote: >> >> >> >>> On Mar 18, 2020, at 9:33 AM, Christopher

Re: [GNC] AQBanking OFX DirectConnect

Are you able to make OFX connection with USAA's server in any manner whatsoever? I have a dormant USAA bank account that I used to be able to download, that now is returning HTTP 400 for the same OFX configs that used to work.  They haven't moved the server, have they? (ofxtools) 11:39:27

Re: [GNC] AQBanking OFX DirectConnect

I was thinking that it could be the first two lines of your file below. > On Mar 18, 2020, at 12:40 PM, John Ralls wrote: > > > >> On Mar 18, 2020, at 9:33 AM, Christopher Singley wrote: >> >> You're sending VERSION="220", which USAA doesn't accept. You need to send >> VERSION="200" or

Re: [GNC] AQBanking OFX DirectConnect

> On Mar 18, 2020, at 9:33 AM, Christopher Singley wrote: > > You're sending VERSION="220", which USAA doesn't accept. You need to send > VERSION="200" or VERSION="202". Try that. No joy, I still get a 400 response, but it does occur to me that it isn't necessarily an OFX issue, it could

Re: [GNC] AQBanking OFX DirectConnect

You're sending VERSION="220", which USAA doesn't accept.  You need to send VERSION="200" or VERSION="202".  Try that. On 3/18/20 11:31 AM, John Ralls wrote: Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits. Unfortunately it just returns an HTTP 400 response, no details.

Re: [GNC] AQBanking OFX DirectConnect

Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits. Unfortunately it just returns an HTTP 400 response, no details. Perhaps like v1 there are Intuit-induced quirks in the v2 parser as well and we'd need to capture a v2 interaction with Quicken to figure them out. Regards, John

Re: [GNC] AQBanking OFX DirectConnect

Thanks.  Just, y'know, keep it cool on the profile scanning... each one spams a lot of requests. Your bank's server has an OK parser... standards-compliant OFXv1.0.3 (what Quicken sends).  Sadly no OFXv2 support. On 3/18/20 10:50 AM, Chris Graves wrote: ofxtools -- nice toolset! Here are

Re: [GNC] AQBanking OFX DirectConnect

ofxtools -- nice toolset! Here are the results from my bank: ofxget scan kinecta [{"versions": [102, 103], "formats": [{"pretty": false, "unclosedelements": false}, {"pretty": false, "unclosedelements": true}, {"pretty": true, "unclosedelements": false}, {"pretty": true, "unclosedelements":

Re: [GNC] AQBanking OFX DirectConnect

An additional bit of information from /tmp/ofx.log: AQB5: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200318081757.000 ... git: Sending:

Re: [GNC] AQBanking OFX DirectConnect

> Aside from the extra whitespace, which shouldn't matter, the git code has closing tags on every element while the AQB5 code has closing tags only on grouping elements. > > USERID is specified in the OFX 1.6 DTD as > > and according to >

  1   2   >