OFX Import Account Association

brad bradhaack at yahoo.com
Thu Mar 18 20:22:44 EDT 2010


I have similar experiences.  aqbanking doesn't work and import OFX is
very fragile.   
If you make a mistake somewhere along the line with the OFX import
you're damned forever.   When you import the OFX there is very little
visibility into what it's doing and often the transaction goes to the
wrong account(s) and it's hard to track down.  You're further along than
I am since you've found out how to mess w/ the xml to fix it.  

How should this be done?  I think if there were a file which contained
the relationship of the OFX file account and the GC account which the
user could edit would be a huge step.  I don't care if there's a GUI,
just some way to connect the accounts.  Also everything imported should
be in a tab (like the scheduled transactions tab when there are new
transactions), so the user can check it and fix it.

I'd like to start contributing this year, but haven't even gotten to the
point of downloading source code, & this would be tops on my list.
Maybe someone will get there before I do :)


On Wed, 2010-03-17 at 22:03 -0500, Bill Burke wrote:
> I have been having problems getting the aqbanking to work correctly.
> However, I have used the python scripts ofx-ba.py with great success.  I
> am able to connect to all of my various bank accounts and download
> transactions.  I have figured out how to import them using the generic
> ofx importer.  
> 
> The only problem is when I set up which account corresponds to which
> security as well as income accounts.  If I make any mistakes in this
> process, I can't fix them using the gui.  At least I haven't been able
> to find a place to do this.  The only remedy that I've found is to
> gunzip the file and manually delete the "online_id" "slot" from the xml
> for the account that is in error.  Then, when I import the ofx file, I
> am prompted again to choose the correct account.  
> 
> In my opinion, this is a pretty big shortcoming in the ofx import
> functionality.  I love the fact that you can import ofx files, since it
> makes up for the buggy aqbanking online plugin, which often crashes when
> I try to use it.  The ofx import is a good workaround aside from this
> account management problem.  I am also concerned that i might not be
> able to hold the same security in multiple accounts.  It may be that
> only one account at a time can be assigned to a security.  Have I missed
> anything on these two issues?  
> 
> Thanks,
> Bill
> 
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel




More information about the gnucash-devel mailing list