No response from OFX server

[David Reiser]

It could be the date, but 1969-12-31 is Unix day 0, I think, so that shouldn't be a problem. Quicken does use 19900101 as their as-far-back-as-we-go date. But I ran a gnucash transaction retrieval request that only went back a couple years. I saw the same no response in ofx.log that you are seeing.

The only other difference I see is the <TRNUID>. The ofx spec says that the field is A-36 (36 unicode characters). In the description of TRNUID, though, the spec says TRNUID is a 36 character hexadecimal encoding of a 128-bit number. Maybe someone changed the server code and it's choking on the aqbanking-generated TRNUID, which looks like a datetime. That would be bad programming on Intuit's part, but it wouldn't be the first time.

For TRNUID
  Quicken uses full guids like: ADA4C400-7B95-1000-8F6D-D8FFF4B80026
  aqbanking uses datetimes (they are globally unique for aqbanking): 20130730131426.000
  your Moneydance example used: 1374688739780-4

I'm only using Aqbanking 5.0.23, so I'm several versions old. I'll have to see if any changes have been made since then to the ofx direct connect routines.

Keep in mind the TDBank went _months_ recently with their ofx server being incompatible with Quicken 2007 for Mac (the most recent version available for the mac, btw). And this year several other financial institutions had troubles providing transaction downloads to Quicken customers in general. One of the comments by an Intuit employee mentioned that Intuit is being much stricter in matching bank names with source connections, so that could be an issue.

I had a TDBanknorth checking account for a while. Before the Commerce Bank acquisition, I believe TDB's ofx server was written in-house. After the Commerce Bank acquisition they seemed to switch to Commerce's ofx infrastructure (hence the <ORG>CommerceBank tag). I'm pretty sure the current server is running Intuit software.

I'm pretty much out of ideas, since I can't test anything without a valid TDBank account.

Dave
--
Dave Reiser
dbreiser at icloud.com




On Jul 30, 2013, at 1:00 PM, njtechteenager at gmail.com wrote:

> Hi Dave,
> 
> I did set that, but all I see in the log is what I originally posted. I do not see a response from the server. From the MoneyDance log I see that the request date is from 1990 on, while GNUcash is 1969, could the server be failing because of such an old date?
> 
> Thank you, Chris
> 
> On Jul 30, 2013 11:44 AM, "David Reiser" <dbreiser at icloud.com> wrote:
> On Jul 30, 2013, at 9:45 AM, njtechteenager <njtechteenager at gmail.com> wrote:
> 
> > Hi David,
> >
> > I've looked at many of the TD Bank posts, but none of them are recent, and I
> > haven't been able to pull any useful information from any of the posts.
> >
> > Is there a way to see if the server is sending *any* kind of response, even
> > if it isn't in OFX format?
> >
> > Chris
> 
> If you set AQOFX_LOG_COMM=1 in your environment, then both what gnucash sends and what the bank sends back appears in ofx.log, usually in /tmp.
> 
> Don't leave the variable set, though, because the log file will contain your login credentials in plain text.
> 
> --
> Dave Reiser
> dbreiser at icloud.com
> 
> 
> 
>