OFX import

Sat Jul 11 09:41:07 EDT 2009

David's option doesn't sound too bad.  I'll give it a try.   I'm not 
sure how smoothly the fake OFX would work, since there is 1 outside 
account, 1 OFX file, which imports into several GC accounts (different 
mutual funds, or stocks).

Derek Atkins wrote:
> Another option is to create a fake OFX file with a bogus account ID,
> assign that to the account you want to change from, then load the
> real OFX and then select thecorrect account..  However you will have
> old transactions in the wrong place.
> 
> -derek
> 
> Quoting "David T." <sunfish62 at yahoo.com>:
> 
>>
>> Brad--
>>
>> The steps I described are not that cumbersome. Create a new account 
>> and call it 'Foo'. Select your original account and delete it. When it 
>> asks what to do with the transactions there, tell it to place them in 
>> Foo. Once this is done, rename Foo to the original account name, and 
>> you should be good to go.
>>
>> You will probably need to do this with the account that you are 
>> erroneously directing your OFX data (since that's what is linked to 
>> the import). Besides that, though, I don't think it's terrible.
>>
>> If your bad-mapped account has *other* transactions in it as well, 
>> then you'll have some trouble untangling the transactions. In that 
>> case, I'd direct them all to another account (I enjoy using 
>> Imbalance-USD for this), open it up in Transaction Journal mode, and 
>> change each Imbalance-USD line to the appropriate account. You are 
>> done when the register is empty.
>>
>> The fact that this stuff isn't documented (or that there isn't a 
>> 'Reset my OFX mapping' button) is of course unfortunate.
>>
>> David
>>
>> --- On Thu, 7/9/09, Brad Haack <bradhaack at yahoo.com> wrote:
>>
>>> From: Brad Haack <bradhaack at yahoo.com>
>>> Subject: Re: OFX import
>>> To: gnucash-user at gnucash.org, gnucash-devel at gnucash.org
>>> Date: Thursday, July 9, 2009, 8:37 PM
>>> 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
>>> >>
>>> >
>>> >
>>> >
>>> >
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
> 
> 
> 