OFX import
Brad Haack
bradhaack at yahoo.com
Thu Jul 9 23:37:32 EDT 2009
Thanks for the suggestions. I probably picked the wrong account the 1st
time, so now I'm stuck w/ some cumbersome recovery steps.
At the risk of insulting someone who donated their spare time on this,
this is really poor. I hope there is a bug report or product
improvement suggestion filed for this. I'll have a look & file one if
there isn't. One thing that would help is if there was an option to
view the transaction in a created transactions tab like there is for the
scheduled transactions.
Brad
David T. wrote:
> I'll reply back to both lists just for completeness sake...
>
> I seem to recall a discussion about ways to reset the OFX some time
> back. The solution was to delete the existing account and move the
> transactions into a new account. This new account will have a
> different GUID, and the importer will re-query you. You don't have to
> manually change each transaction from old to new; the delete dialog
> includes the option to change the transactions into a new account.
>
> David
>
> --- On Mon, 7/6/09, David Reiser <dbreiser at earthlink.net> wrote:
>
>> From: David Reiser <dbreiser at earthlink.net> Subject: Re: OFX import
>> To: bradhaack at yahoo.com Cc: gnucash-devel at gnucash.org Date:
>> Monday, July 6, 2009, 8:47 PM
>>
>> On Jul 6, 2009, at 11:22 PM, Brad Haack wrote:
>>
>>> I didn't get any response on the user list, so I'm
>> posting it here also
>>> I turned off bayesian matching & it doesn't seem
>> to make any difference
>>> GC 2.2.6
>>>
>>>
>>> I'm trying to import investment dividends and
>> transactions with the OFX
>>> import feature. The Generic Import
>> Transaction Matcher doesn't give me
>>> any option to pick what accounts to use, doesn't show
>> me what accounts
>>> it's going to use, and often uses the wrong
>> accounts. What am I doing
>>> wrong?
>>>
>>>
>> An OFX file is defined by specification to contain transactions
>> from only one account. The ofx tag <ACCTID> (or very similar)
>> identifies the account for one side of every transaction in the
>> file. If you have ever imported an ofx file containing the same
>> <ACCTID>, then you have already told gnucash what account is
>> associated with the split common to all transactions in the file.
>> Gnucash will not ask a second time if it already has an internal
>> account match for a given <ACCTID> from an ofx file.
>>
>> Also, the first time you import a dividend transaction for a
>> security, gnucash asks you to identify an income account associated
>> with a given stock/mutual fund. You have to be attentive, because
>> the dialog details look a lot like other similar dialogs, and I
>> find it too easy to pick the wrong account instead of an income
>> account. Once you have specified an income account associated with
>> a stock, gnucash won't ask you again (you already told it where the
>> dividend income belongs...).
>>
>> I suspect that part of the reason it isn't asking you for accounts
>> is that you told it something in previous imports. If you told it
>> something that is incorrect, fixing it is a challenge since there
>> isn't a user interface for those 'settings'. I think you're looking
>> at having to edit the raw xml data, but work with a copy and be
>> very careful.
>>
>> Dave -- David Reiser dbreiser at earthlink.net
>>
>>
>>
>>
>> _______________________________________________ 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