After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 98963 - OFX Importer: matching account cannot be changed later
OFX Importer: matching account cannot be changed later
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Import - OFX
unspecified
Other other
: Normal enhancement
: ---
Assigned To: Benoit Grégoire
Benoit Grégoire
Depends on:
Blocks:
 
 
Reported: 2002-11-19 04:04 UTC by Chris Lyttle
Modified: 2018-06-29 20:21 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Chris Lyttle 2002-11-19 04:07:54 UTC
Package: GnuCash
Severity: normal
Version: 1.7.3
Synopsis: RFE: Add clear flag for OFX account transaction matcher
Bugzilla-Product: GnuCash
Bugzilla-Component: Import

Description:
When you first import OFX data into GnuCash is asks you which account the import is for. This is saved to the account's kvp. There should be a checkbox or something in the Edit account dialog to clear this in case someone chooses the wrong account when they do an import.




------- Bug moved to this database by unknown@bugzilla.gnome.org 2002-11-18 23:07 -------

Reassigning to the default owner of the component, chris@wilddev.net.

Comment 1 Christian Stimming 2002-11-25 12:36:16 UTC
Changed title to state the problem clearer. Raised severity since this
is quite a bummer for users.
Comment 2 Benoit Grégoire 2002-12-17 02:17:36 UTC
OFX account mappings are unique and should not change over time, your
checking account at bank X will stay your checking account at bank X.
 If your transit number changes, the ofx module won't find the
matching account and will give you the chance to reassign.  Puting a
global option in the account editor for editing online id's is
premature.  (That may no longuer be the case once we use the generic
import infrastructure for QIF).  At most, I would currently see a
button "Remove all online_id associations", but I wonder where to plug
it in the interface.
Comment 3 Benoit Grégoire 2003-05-02 16:11:05 UTC
Here are the two workaround until this is fixed...

> I must have messed up my accounts!
> When I import a ofx-file the account from which the transaction
comes from
> is automaticaly selected, right? The very first time a new account
appears
> in an ofx-file a window pops up and asks for selecting an existing
account.
> But how can I change this reference later on? It looks like I've made a
> mistake at that time. Now it put the transactions on the wrong account!

You can't (currently).  The simplest way to fix it involves editing
your data file directly:

With a text editor, open your data file, and search for the string 
"online_id".  You will find constructs like this one:    
    <slot>
      <slot:key>online_id</slot:key>
      <slot:value type="string">7000001000023421 0023421 
815-30480-00XXXXX-EOP</slot:value>
    </slot>
One of them is the account you are trying to import.  Remove these4
lines once you find it.  Next time you import, you will get asked
which gnucash account you want to use fot that ofx account.

If you don't want to edit your datafile, you can import some other ofx
file (like one of the sample files distributed with libofx).  Each
time you are asked which gnucash account to use for account number
whatever, select the account that you mistakenly selected before. 
Once you see the list of transactions, hit cancel.  Then try to
reimport your original ofx file, you should be able to select the
right account.

Off course, backup your file before you proceed...
Comment 4 Bruno Cossermelli Vellutini 2009-05-15 05:12:16 UTC
sorry, but is this bug still open? I'm experiencing the same problem on version 2.2.6...

Any different workaround for it?
Comment 5 Boyd Kelly 2010-09-08 19:16:08 UTC
I also have a similar problem, but it relates to this comment:

(https://lists.gnucash.org/pipermail/gnucash-devel/2009-July/025753.html) about importing investment accounts.  

I have a multicurrency investment account.  When importing the OFX with a dividend transaction and I make a mistake and select an income account with the wrong currency, then the transaction values will come up blank in the register.  (See also bug https://bugzilla.gnome.org/show_bug.cgi?id=577032)  This error is then 'remembered' for future transactions.

It would be very practical to be able to edit this account 'association' within the user interface to correct such errors.
Comment 6 Ed 2011-02-08 23:58:44 UTC
The second method worked for me.  Thanks!  I went to libofx.sourceforge.net and downloaded a sample OFX file (.xml) and it worked perfectly.

I never could find the "online_id" in, what I presume was, my data file.  It was a binary file.  I'm running Windows 7 and GC 2.2.9

(In reply to comment #3)
> Here are the two workaround until this is fixed...
> 
> > I must have messed up my accounts!
> > When I import a ofx-file the account from which the transaction
> comes from
> > is automaticaly selected, right? The very first time a new account
> appears
> > in an ofx-file a window pops up and asks for selecting an existing
> account.
> > But how can I change this reference later on? It looks like I've made a
> > mistake at that time. Now it put the transactions on the wrong account!
> 
> You can't (currently).  The simplest way to fix it involves editing
> your data file directly:
> 
> With a text editor, open your data file, and search for the string 
> "online_id".  You will find constructs like this one:    
>     <slot>
>       <slot:key>online_id</slot:key>
>       <slot:value type="string">7000001000023421 0023421 
> 815-30480-00XXXXX-EOP</slot:value>
>     </slot>
> One of them is the account you are trying to import.  Remove these4
> lines once you find it.  Next time you import, you will get asked
> which gnucash account you want to use fot that ofx account.
> 
[THE FOLLOWING WORKED FOR ME]
> If you don't want to edit your datafile, you can import some other ofx
> file (like one of the sample files distributed with libofx).  Each
> time you are asked which gnucash account to use for account number
> whatever, select the account that you mistakenly selected before. 
> Once you see the list of transactions, hit cancel.  Then try to
> reimport your original ofx file, you should be able to select the
> right account.
> 
> Off course, backup your file before you proceed...
Comment 7 Pablo Nogueira Vale 2014-11-05 18:51:38 UTC
(In reply to comment #2)
> OFX account mappings are unique and should not change over time, your
> checking account at bank X will stay your checking account at bank X.
>  If your transit number changes, the ofx module won't find the
> matching account and will give you the chance to reassign.  Puting a
> global option in the account editor for editing online id's is
> premature.  (That may no longuer be the case once we use the generic
> import infrastructure for QIF).  At most, I would currently see a
> button "Remove all online_id associations", but I wonder where to plug
> it in the interface.

HI. My OFX and my bank statement for my credit card brings me transactions on different currencies. How should I deal with it so? As far as I know, I should use different accounts for different currencies. Doing this, how can I import my OFX on both accounts? 

I already compiled a GIT version on Ubuntu today and I'm willing to work on the code. I think this is related to https://bugzilla.gnome.org/show_bug.cgi?id=385366 as well.
Comment 8 Benoit Grégoire 2014-11-06 15:10:20 UTC
Unless credit card work very differently where you live than in Canada, the transactions on your credit card are all in your local currency (at whatever exchange rate your card applied at the time of the transaction.  For my cards the amoun in the foreign currency is in the transaction description, not in the actual data).

The ofx file only represents on side of the transaction (one split).  In your case, since it's a credit card, it's the side of the passive account representing your credit card.  The transaction matcher allows you to create the other side if the transaction doesn't already exist.

Having accounts in different currencies make sense only when having splits across them are indeed in different currencies.  I'd be very surprised if that's your case.  If credit card work like they do in Canada, all acconts involved should be in your local currency.  You pay back your credit card in your local currency.  For your expense account, you are normally interested in what it really cost you, so the amount AFTER conversion by your credit card.  So once again in your local currency.
Comment 9 Pablo Nogueira Vale 2014-11-06 17:03:06 UTC
How can I send my OFX to you ?  I don't want to change anything on it in the process ( to cover data ). I can send you 2 example OFX and PDF from credit card. Maybe you would get a better idea about it.

I have some reasons to register both values. But I can accept suggestions.
Comment 10 John Ralls 2018-06-29 20:21:08 UTC
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=98963. Please continue processing the bug there and please update any external references or bookmarks.