OFX Direct Connect problem

Sat Feb 13 14:17:30 EST 2016

Thanks, David. I had read that some banks need the Client UID so I
generated one online; no luck. I get the same results with both versions of
Quicken. Gnucash returns a valid certificate from netteller and I can see
it is connecting to the bank. There is a parsing error, both when trying to
retrieve accounts and after entering accounts manually. The ofxlog only
adds that there is a system related error. I updated in Quicken to make
sure there wasn't a problem at the bank and it updated just fine. I haven't
tried the bank for help yet because they they don't have customer service
on weekends or holidays. I really don't expect them to be of help though.
Thanks again.

On Sat, Feb 13, 2016 at 12:42 AM, David Reiser <dbreiser at icloud.com> wrote:

> One other thing that might be worth trying is adding a Client UID to the
> user settings in Edit User in Aqbanking setup. The header version of 103
> might effectively be telling the server that it should be expecting a
> Client UID.
>
> A possible test of the need for this effort would be to create a new data
> file in Quicken and try to connect to Advia. Quicken generates a ClientUID
> internally (and hides it from the user completely) and saves the generated
> value in the Quicken data file. If the ClientUID is really going to serve
> as a second authentication factor, the bank must have some way to validate
> the new value Quicken generates for your new file. I would expect that
> you’d get a message in Quicken telling you how to go about the validation.
> An additional possibility is that the bank only allows one ClientUID per
> customer — in which case you’d have to get them to reset your account to
> accept a new value.
>
> A ClientUID is just a standard UUID without any hyphens. The error code in
> your original log file is an example of a standard UUID. I find it really
> curious that your error code is a unique number. Very weird. Maybe that’s
> the way they run the validation attempt.
>
> Any unix system will generate a UUID with the command “uuidgen”. I don’t
> know if there is any easily accessible utilities for Windows. There are
> several UUID generators on the web, if it doesn’t freak you out to get such
> an item from a public place...
> --
> Dave Reiser
> dbreiser at icloud.com
>
>
>
>
>
> > On Feb 12, 2016, at 4:22 PM, Connie Reynolds <
> connie.aquarianessence at gmail.com> wrote:
> >
> > Thanks. I tried that already. Notice it hasn't passed validation since
> Dec.
> > 1, 2011. They have a new name and server now too, Advia and netteller.
> I'll
> > call to see if they'll help, but the address I used is the one in the
> > Quicken ofx log.
> >
> >
> > http://www.aquarianessence.com/ <http://aquarianessence.com/>
> >
> > On Fri, Feb 12, 2016 at 12:27 PM, jmk <jmk at cmail.nu> wrote:
> >
> >> I don't know the answer but I suspect maybe you have the wrong URL for
> OFX
> >> queries. See here:
> >>
> >> http://www.ofxhome.com/index.php/institution/view/515
> >>
> >> Usually the URL has 'ofx' in it somewhere. If those settings don't work
> >> you'll probably have to contact the bank tech support and see if they
> can
> >> help.
> >>
> >>
> >>
> >> On 02/10/2016 01:36 PM, Connie Reynolds wrote:
> >>
> >> I am attempting to replace Quicken 2013 while it is still not outdated.
> My
> >> first round of attempts failed so I tried again by setting the program
> to
> >> run in XP mode, thinking maybe it was a Vista problem. I am working with
> >> Windows Vista, Gnucash 2.6.11, attempting to connect with Advia Credit
> >> union, formerly First Community FCU. I used Quicken settings for the
> 2016
> >> version, as suggested in another thread (app version 2500, Header
> version
> >> 103). I wasn't able to retrieve accounts, receiving the message,
> "14:13:50
> >> Saving communication log to /tmp/ofx.log
> >> 14:13:50 Sending request...
> >> 14:13:59 Using old SSL preparation code.
> >> 14:13:59 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> >> 14:14:01 Waiting for response...
> >> 14:14:02 Parsing response...
> >> 14:14:02 Parsing response
> >> 14:14:02 Error parsing response
> >> 14:14:02 Operation finished, you can now close this window" so I entered
> >> one manually, a checking account. My User settings are:
> >> User name: my name as it appears on bank account
> >> User ID: The acct# used to log in to one of my accounts
> >> Bank Settings:
> >> Bank name: First Community Federal Credit Union (MI) (Now Advia Credit
> >> Union) (taken from the quicken ofx.log
> >> FID: 7120
> >> ORG: Advia Credit Union (as shown on quicken log)
> >> Server URL:
> https://cm.netteller.com/login2008/Authentication/Views/Login.aspx?fi=1stcomm&bn=fbecbddd369f3ea2&burlid=2c80ca5f14ba73cc
> >> (as shown on quicken log
> >>
> >> I set up account with same acct#/ID as user, settings are:
> >> Account number: same as above
> >> Account name: same as above
> >> Owner name: my name as appears on account
> >> Currency: set to usd but keeps changing to Euro
> >> Account type: Checking
> >> Country: United States of America (US)
> >> Bank code: 272483633 (this is routing number)
> >> Bank name: First Community FCU now Advia Credit Union (as shown on
> quicken
> >> log)
> >> Selected user: (the user created above)
> >>
> >> When I attempt to download transactions the message is,
> >> AqBanking v5.5.1.0stable
> >> Sending jobs to the bank(s)
> >> Locking user FC********
> >> Saving communication log to /tmp/ofx.log
> >> Sending request...
> >> Connecting to server...
> >> Resolving hostname "cm.netteller.com" ...
> >> IP address is "216.116.81.86"
> >> Connecting to "cm.netteller.com"
> >> Connected to "cm.netteller.com"
> >> Using old SSL preparation code.
> >> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> >> Connected.
> >> Sending message...
> >> Message sent.
> >> Waiting for response...
> >> Receiving response...
> >> HTTP-Status: 200 (OK)
> >> Response received.
> >> Disconnecting from server...
> >> Disconnected.
> >> Parsing response...
> >> Parsing response
> >> Error parsing response
> >> Unlocking user FC********
> >> Postprocessing jobs
> >> Job Get Transactions: finished
> >> Resetting provider queues
> >>
> >> The ofx log reads like an html document, title "error" and says "We're
> >> sorry. While processing your request, we encountered a system-related
> >> error. Your request was not processed. If this error persists, please
> >> contact support.  Error Code: d82aa81d-7c37-4551-9521-268d898fe1c1
> >>
> >> If I change the url to https://cm.netteller.com I get the same message
> and
> >> log says:
> >> Sending:
> >> -------------------------------------
> >> OFXHEADER:100
> >> DATA:OFXSGML
> >> VERSION:103
> >> SECURITY:NONE
> >> ENCODING:USASCII
> >> CHARSET:1252
> >> COMPRESSION:NONE
> >> OLDFILEUID:NONE
> >> NEWFILEUID:20160210142734.000
> >> <OFX><SIGNONMSGSRQV1><SONRQ><DTCLIENT>20160210142734.000<USERID>FC******
> >>
> >> <USERPASS>*********
> >>
> >> <LANGUAGE>ENG<FI><ORG>Advia Credit
> >>
> Union<FID>7120</FI><APPID>QWIN<APPVER>2500</SONRQ></SIGNONMSGSRQV1><BANKMSGSRQV1><STMTTRNRQ><TRNUID>20160210142734.000<CLTCOOKIE>1<STMTRQ><BANKACCTFROM><BANKID>272483633<ACCTID>FC********<ACCTTYPE>CHECKING</BANKACCTFROM><INCTRAN><DTSTART>20150101000000.000<DTEND>20160210142726.000<INCLUDE>Y</INCTRAN></STMTRQ></STMTTRNRQ></BANKMSGSRQV1></OFX>
> >>
> >> Received:
> >> ------------------------------
> >> -------
> >> Thank you in advance for any suggestions that might work.
> >>
> >> Connie
> >> _______________________________________________
> >> gnucash-user mailing listgnucash-user at gnucash.orghttps://
> lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> 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
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>