Capital One and DirectConnect - any advice appreciated

John Ralls jralls at
Sat Mar 16 11:43:57 EDT 2013

On Mar 16, 2013, at 8:29 AM, Emmet Devine <emmetdevine at> wrote:

> Hi John,
> I just wanted to send you a follow-up note about the issue that I reported to the gnucash-user list regarding GnuCash/AqBanking, OFX and Capital One.  I thought I'd share the information with you directly, rather than the entire list, because no one else on the list seems to have the same issue and because you might find it useful to share with the other developers.
> The connection errors described in my original email were resolved by setting the OFX version to 1.0.3 and the ClientUID to 6c88247e-ab53-46f4-b9c0-ecaee283570f, which was a default string for ClientUID that I found in the configuration file of the PocketSense scripts (found under 
> According to this blog post for PocketSense ( the ClientUID should be set automatically by the client software.  I downloaded the PocketSense scripts with the intention of generating a ClientUID for my connection to Capital One, but when I saw a default value for the element in the scripts' configuration file ("sites.dat") I used the default value in GnuCash and my transactions downloaded successfully.  I did not read the code to learn how the ClientUID is generated; at this point, I don't really have the time to investigate how the client operates.  
> If Capital One break things again, I might take a deeper dive at that time; if the GnuCash/Aqbanking developers would like me to test something for them, I'd be willing to help out.
> But, again, I want to thank you for your original response to my first question and I hope that this information may be of some use to you.  


Good detective work!

 That string is called a GUID and they're widely used, making one at account creation is no problem. I'll leave it to Martin and Christian (who know the online banking code much better than I do) to look at your references and see what needs to be done and where.

John Ralls

More information about the gnucash-devel mailing list