How to reset OFX/QFX import account assignment?

Derek Atkins warlord at MIT.EDU
Fri Aug 9 14:39:03 EDT 2013


rsbrux <rsbrux at yahoo.com> writes:

> Derek Atkins wrote
>> A saw no "excerpted" data in your email.  Perhaps you failed to attach
>> it, or it got stripped out along the way?
>
> I pasted it in Nabble (where it is still visible) with "raw" format tags.
> Maybe the "raw" stuff gets filtered out in the mailing list.

Maybe, I don't know.  I don't use Nabble, and I would encourage you not
to, too ;)

> Derek Atkins wrote
>> Alas, the only way to do it is to overwrite it.  GnuCash stores the OFX
>> Account info attached in the GNC Account Metadata.  It can only store
>> one OFX ID, so to reset an account you need to import an OFX file with a
>> "bogus" ID and attach it to the GNC Account you want to reset.  Then
>> when you re-import your real OFX it wont find the binding and you can
>> reassign it.
>
> This worked OK, but the results are still unsatisfactory. Several dividend
> transactions were imported without amounts.
> Where GnuCash recognized the transaction amounts, it assumed that they were
> CHF (my default currency) even after associating the import with a USD
> account.  Correcting all of the entries (made worse by the fact that I am
> using trading accounts) is worse than putting in all of the transactions
> (most of which can be copied with minor changes) by hand.  If I can master
> scheduled transactions, I can probably make it even easier.

This does not surprise me..  I suspect the importer doesn't handle
multi-currency very well.

> Derek Atkins wrote
>> No, the FITID is an opaque field (to us, the OFX client).  The only
>> requirement of the field is that it be guaranteed unique (per account)
>> by the issuing authority for duplicate detection.  But there is no
>> guarantee for the contents.
>
> Maybe just as well, since the effort to implement maybe disproportionate to
> the benefits.
>
> Many thanks for your prompt and helpful response!

My pleasure.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list