On 4/6/2022 3:53 PM, Ed Reeder wrote:
Example:
I have previously entered a check into gnucash:
Num=205, Description=Smith Plumbing, Withdrawal=100.00

My bank's OFX  transaction has:
<STMTTRN>
    <TRNTYPE>CHECK
    <TRNAMT>-100.00
    <CHECKNUM>205
    <NAME>CHECK # 205
</STMTTRN>

When I import the OFX file and and match its transaction with the previously entered check 
transaction the "Smith Plumbing" gets overwritten with "CHECK # 205".

Is there a way to preserve the "Smith Plumbing" and not have it overwritten?  
(It is a pain to go back and reenter the payee's name on each check).


This might be an opportunity to see how an analyst might approach the problem. I do n not import OFX transactions, know nothing about them. That being the case I would ..

a) FIRST make a copy of you books before the import. You might give that a name of test. You are going to work with THAT file so as not to mess up your "production" data. Each time before the trials I am going to suggest you make a reserve cop of that test file. I suspect it is going to take multiple trials.

b) Same with the OFX file you are trying to import. You are going to be editing it perhaps multiple times so you want a clean original each time.

c) You can see that is happening. The "<name>CHECK # XXX" is overwriting what you had in the name field. For your first trial, see what happensĀ  if you make than <NAME>" (in other words, NOTHING (null) there. My guess is that this is;t going to do what you want , but it might. For you next trial, eliminate that entire line form the transaction. In other words, nothing between <CHECKNUM>xxx and </STMTTRN>

Of course ACTUALLY I'd not do it it trail and error but would look up the definition of the bank's OFX transaction to find out if <name> is optional or not.

Michael D Novack


_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to