Example of OFX transaction using CLIENTUID - Need some support to communicate with my bank.

[Bruce Perens]

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>