Hi Folks,
Thank you very much for GnuCash. I am making use of it in my business.
We have an account with The Mechanics Bank. GnuCash 2.2.7, coupled with
AQBanking 3.7.2, is unable to perform an OFX transaction because the
server requires CLIENTUID. Would you be able to use the information in
this message to implement CLIENTUID? I would then test it.
The basic OFX information for the bank is public knowledge. If header
version 102 is used, the server claims that it doesn't support the
client program name and version, for any program name and version
provided. If header version 103 is used, that message goes away and the
server rejects the connection with a complaint that CLIENTUID is required.
I brought up Quicken for Windows, which was able to connect properly.
The attached sanitized transaction log shows the initial registration of
the new CLIENTUID, and the succeeding transaction. The obscured data
includes my login, account number, and the value of the CLIENTUID. The
length and description of the CLIENTUID are provided. Quicken obscures
the password in writing the log file.
Many Thanks
Bruce
<!-- ***** SEND to https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:17
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
-->
<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20081031165717.123[-7:MST]
<USERID>*** OBSCURED ***
<USERPASS>X<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>TMB
<FID>121102036
</FI>
<APPID>QWIN
<APPVER>1700
<CLIENTUID>*lowercase hex number this long*
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>1B9368D0-7A39-1000-9799-CDD3A6DB0026
<ACCTINFORQ>
<DTACCTUP>19900101
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>
<!-- ***** RECV from https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:19
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
-->
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20081031235744
<LANGUAGE>ENG
<DTACCTUP>20081031235052
<FI>
<ORG>TMB
<FID>121102036
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<SIGNUPMSGSRSV1>
<ACCTINFOTRNRS>
<TRNUID>1B9368D0-7A39-1000-9799-CDD3A6DB0026
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<ACCTINFORS>
<DTACCTUP>20081031235052
<ACCTINFO>
<DESC>*** OBSCURED ***
<BANKACCTINFO>
<BANKACCTFROM>
<BANKID>121102036
<ACCTID>*** OBSCURED ***
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<SUPTXDL>Y
<XFERSRC>Y
<XFERDEST>Y
<SVCSTATUS>ACTIVE
</BANKACCTINFO>
</ACCTINFO>
</ACCTINFORS>
</ACCTINFOTRNRS>
</SIGNUPMSGSRSV1>
</OFX>
<!-- ***** SEND to https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:33
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:1B95D9D0-7A39-1000-9799-CDD3A6DB0026
-->
<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20081031165733.123[-7:MST]
<USERID>*** OBSCURED ***
<USERPASS>X<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>TMB
<FID>121102036
</FI>
<APPID>QWIN
<APPVER>1700
<CLIENTUID>*lowercase hex number this long*
</SONRQ>
</SIGNONMSGSRQV1>
<BANKMSGSRQV1>
<INTRASYNCRQ>
<REFRESH>Y
<REJECTIFMISSING>N
<BANKACCTFROM>
<BANKID>121102036
<ACCTID>*** OBSCURED ***
<ACCTTYPE>CHECKING
</BANKACCTFROM>
</INTRASYNCRQ>
</BANKMSGSRQV1>
</OFX>
<!-- ***** RECV from https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:35
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:1B95D9D0-7A39-1000-9799-CDD3A6DB0026
-->
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20081031235800
<LANGUAGE>ENG
<DTACCTUP>20081031235052
<FI>
<ORG>TMB
<FID>121102036
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<INTRASYNCRS>
<TOKEN>0
<BANKACCTFROM>
<BANKID>121102036
<ACCTID>*** OBSCURED ***
<ACCTTYPE>CHECKING
</BANKACCTFROM>
</INTRASYNCRS>
</BANKMSGSRSV1>
</OFX>
<!-- ***** SEND to https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:36
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:1B95D9D0-7A39-1000-9799-CDD3A6DB0026
NEWFILEUID:1B964F00-7A39-1000-9799-CDD3A6DB0026
-->
<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20081031165736.123[-7:MST]
<USERID>*** OBSCURED ***
<USERPASS>X<GENUSERKEY>N
<LANGUAGE>ENG
<FI>
<ORG>TMB
<FID>121102036
</FI>
<APPID>QWIN
<APPVER>1700
<CLIENTUID>*lowercase hex number this long*
</SONRQ>
</SIGNONMSGSRQV1>
<BANKMSGSRQV1>
<STMTTRNRQ>
<TRNUID>1B964F01-7A39-1000-9799-CDD3A6DB0026
<STMTRQ>
<BANKACCTFROM>
<BANKID>121102036
<ACCTID>*** OBSCURED ***
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<INCTRAN>
<INCLUDE>Y
</INCTRAN>
</STMTRQ>
</STMTTRNRQ>
</BANKMSGSRQV1>
</OFX>
<!-- ***** RECV from https://ofx.mechbank.com/OFXServer/ofxsrvr.dll at 16:57:39
on 20081031 ***** -->
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:1B95D9D0-7A39-1000-9799-CDD3A6DB0026
NEWFILEUID:1B964F00-7A39-1000-9799-CDD3A6DB0026
-->
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20081031235804
<LANGUAGE>ENG
<DTACCTUP>20081031235052
<FI>
<ORG>TMB
<FID>121102036
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>1B964F01-7A39-1000-9799-CDD3A6DB0026
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<STMTRS>
<CURDEF>USD
<BANKACCTFROM>
<BANKID>121102036
*** OBSCURED ***
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
