Bug 274435 - importing gnucash makes payee from comment instead of corresponding account
Summary: importing gnucash makes payee from comment instead of corresponding account
Status: RESOLVED WAITINGFORINFO
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 3.98.x
Platform: Debian stable Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-29 17:30 UTC by M G Berberich
Modified: 2012-05-20 15:37 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description M G Berberich 2011-05-29 17:30:44 UTC
Version:           3.98.x (using KDE 4.4.5) 
OS:                Linux

When importing gnucash-data the importer generates the payee-field from the comment instead of the corresponding account, resulting in a mass of wierd, useless payees (like "HP ZR24w and HDMI-DVI-cable" or "haircut inc. 50¢ tip")

The result of this conversion is useless.

Reproducible: Always
Comment 1 Thomas Baumgart 2011-05-29 18:01:41 UTC
Did you try with a newer version of KMyMoney (4.3.5 is the current stable)? 3.98 is outdated.
Comment 2 Tony B 2011-05-31 11:08:59 UTC
I think this happens with data imported into Gnucash from bank statements. Try the 'Transaction Notes' import option as per manual extract below. Perhaps we should try to think of a better name for this option.

Transaction Notes option

Under some usage conditions, non-split GnuCash transactions may contain residual, often incorrect, memo data which is not normally visible to the user. When imported into KMyMoney however, due to display differences, this data can become visible. Often, these transactions will have a Notes field describing the real purpose of the transaction. If this option is selected, these notes, if present, will be used to override the extraneous memo data.
Comment 3 M G Berberich 2011-05-31 21:49:18 UTC
This happens with transactions that have been manually entered in gnucash.
Comment 4 Cristian Oneț 2011-05-31 22:19:34 UTC
(In reply to comment #3)
> This happens with transactions that have been manually entered in gnucash.

I think that what Tony actually means is that you try to import that file with the fourth option from the bottom of this dialog http://kmymoney2.sourceforge.net/kde4/online-manual/gnucash-import_options.png activated.
Comment 5 Tony B 2011-06-02 11:13:41 UTC
The following is an extract from the manual re GnuCash import:

Payees
KMyMoney prefers that all transactions have a Payee (a generic term that encompasses both payees and payers), and unlike GnuCash, a list of these payees is maintained. Payee names are generated by the importer from the GnuCash transaction's Description field. 

This has proved satisfactory for some time now, with the option to over-ride in some circumstances, as detailed in my previous post.
Comment 6 Thomas Baumgart 2011-09-28 19:22:24 UTC
Any news?
Comment 7 Thomas Baumgart 2012-01-03 09:12:34 UTC
Changing state due to missing feedback
Comment 8 Karel 2012-05-20 12:14:49 UTC
Is it possible to edit multiple transaction data with these custom settings:
1. Copy data from payee field to Memo field
2. rewrite payee data with new custom name, so we can delete these useless payees.

This would solve the problem and transaction data will not be lost
Comment 9 Jack 2012-05-20 15:37:34 UTC
You might get some similar effect by re-importing the data from scratch, with appropriate payees already set up, using the matching section for payees.  Now, it seems your best approach is to delete those "wrong" payees - when you delete a payee, KMM asks to what other payee it should move the transactions.  There is also a checkbox on that dialog to automatically add the old payee name as a matching string for the payee to which you move the transactions.