OFX import

[Derek Atkins]

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.
>



-- 
       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