OFX import

[David T.]

As I understand it, GC will not import one OFX into multiple accounts, so you may need to figure out a different approach.

David

--- On Sat, 7/11/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
> Date: Saturday, July 11, 2009, 6:41 AM
> 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.
> >> 
> > 
> > 
> > 
> _______________________________________________
> 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.
>