New User Trouble With Transaction Downloading

Craig Huff huffcslists at gmail.com
Wed May 4 14:14:41 EDT 2016


Still spinning my wheels on this problem.  Looking at QFW's ofx log, I see
many instances of what I'd call a login test that all succeed, so I tried
to emulate it with a modified version of ofx-ba.py.  Here are (what I think
are) pertinent data from my latest test -- individual blocks of text are
prefaced with headings like "#### descriptive text:" which are not part of
the actual data, and I replaced my userid and password with placeholders
below:

#### request:
<urllib2.Request instance at 0xb7001a2c>

#### url:
https://ofx.edwardjones.com

#### query:
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20160504122203.224
<USERID>_username_
<USERPASS>_user_password_
<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>Edward Jones
<FID>823
</FI>
<APPID>QWIN
<APPVER>2500
</SONRQ>
</SIGNONMSGSRQV1>
<PROFMSGSRQV1>
<PROFTRNRQ>
<TRNUID>BCDD6C5D-D97F-4D0B-8C2B-0CA16BB6EE5E
<PROFRQ>
<CLIENTROUTING>MSGSET
<DTPROFUP>20151124
</PROFRQ>
</PROFTRNRQ>
</PROFMSGSRQV1>
</OFX>

#### reply:
<html><head><title>Request Rejected</title></head><body>The requested URL
was rejected. Please consult with your administrator.<br><br>Your support
ID is: 8078302266181671468</body></html>

#### example of expected reply:
<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Signon
operation
succeeded.</STATUS><DTSERVER>20160504122203.548[-5:CDT]<LANGUAGE>ENG<FI><ORG>Edward
Jones<FID>823</FI></SONRS></SIGNONMSGSRSV1><PROFMSGSRSV1><PROFTRNRS><TRNUID>BCDD6C5D-D97F-4D0B-8C2B-0CA16BB6EE5E<STATUS><CODE>1<SEVERITY>INFO</STATUS></PROFTRNRS></PROFMSGSRSV1></OFX>

I don't know how significant it is that the reply I received had html tags
and not ofx tags since it is a reject message, but...

I don't know what the point of the support ID is since Edward Jones doesn't
provide any support.

The only thing I diverged from with respect to the samples in the QFW log
file was that I didn't include the timezone suffix ([-5:EST]) on the
<DTCLIENT> value.  And it wasn't the right TZ anyway!

I note that the QFW log has test logins using USERID =
"anonymous00000000000000000000000" before logins with real values.  Not
sure if that is a requirement with Edward Jones, but QFW does it with the
Intuit site, too.

Anyone successfully accessing their investment data at Edward Jones that
can point me in the right direction?

--
Craig.


More information about the gnucash-user mailing list