OFX import

Brad Haack bradhaack at yahoo.com
Sat Jul 11 22:51:27 EDT 2009


This could be part of my problem, altho I know it does import dividends 
from 1 external account (1 OFX account), with 2 fund dividends into 2 GC 
income accounts.

I tried your delete account trick,  I'm looking forward to next month to 
see what happens when I import the next OFX file.

Brad

David T. wrote:
> 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.
>> 
> 
> 
> 
> 


More information about the gnucash-user mailing list