Bug 225550 - Import does not set detail field correctly
Summary: Import does not set detail field correctly
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Debian testing Linux
: NOR wishlist
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-04 22:25 UTC by Antony
Modified: 2022-12-19 23:52 UTC (History)
2 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 Antony 2010-02-04 22:25:45 UTC
Version:           3.95.0-svn20090511 (using KDE 4.3.4)
OS:                Linux
Installed from:    Debian testing/unstable Packages

When importing the QIF file below, the Details field of the 3 transactions are identical and equal to "P field".

The file encoding is set to utf-8 as recommended. The same file format used to work some months ago. Unfortunately, I am not able to pinpoint exactly when this stopped to be.

Let me know if I can help you further in any way,

Cheers,
Antony.

----------------------------------------
!Type:Bank
D13-08-2008
T123.45
N
PP field 1
^
D17-08-2009
T-14.32
N
PP field 2
M
^
D19-08-2010
T789.19
N
PP field 3
M
^
----------------------------------------
Comment 1 Thomas Baumgart 2010-02-06 09:23:51 UTC
Looks to me, that you get tricked by a feature here. Please check the following :

Do you have a payee "P field" that has a matching option setup to cause the above behaviour?

This is the only thing I could think of as things are working here fine and there haven't been any changes in this area of the code lately.

Please confirm or provide more information.
Comment 2 Antony 2010-02-08 13:07:07 UTC
Thomas,

thank you for looking into this. 
Yes, you're right, I got caught by the "matching option". The file I sent works fine when the matching is disabled.

However, my original problem remains and it is the following. I have a .qif file which, when imported in the KMyMoney data files containing all my accounts, does not import properly the Details field. However, for the purpose of testing/experimenting, I created a new, empty .kmy file. When importing the same .qif file, all the Details are imported properly.

The next step for me is to produce a simpler (almost empty) .kmy file for which the import does not behave as expected so that can provide it to you for testing (I wouldn't like to distribute the original file as it obviously contains lot of sensitive, personal data).

Of course, if there is anything you would like me to do to help you, let me know!

Antony.
Comment 3 Thomas Baumgart 2010-02-08 13:20:59 UTC
An example to reproduce the problem sure would be fine.

Regarding the sensitive information: do you know about the anon-xml file format? Check http://kmymoney2.sourceforge.net/online-manual/details.formats.html for details.
Comment 4 Antony 2010-02-10 16:05:14 UTC
My apologies for not following this up earlier.

After numerous experiment at importing different QIF files into different KMY files, I have finally got this problem sorted. 

Also I cannot confirm it, I believe I know what the problem was. At some point a blank payee got added to KMY file and the default option is to match transaction automatically. The QIF file I tried to import had P fields containing 2 consecutive white spaces in the middle of the description. When importing, the matching process identified these payees as identical to the blank payee already in the KMY database and automatically replaced those payee by a blank payee.

While the new matching feature confusing me for some time, I am not quite sure if this is the expected behaviour. I leave you the decision on whether this bug must be close without further investigation or not.

Thank you for your help with this. KMyMoney is a great application, thank you to all of the contributors!

Antony J.

PS: While trying to follow you suggestion about using the anon-xml, I noticed that unfortunately the Save-as command crashed KMyMoney every time I used it. Unfortunately, my system could not collect enough debug infos to report it in a useful way. I'll check if this has already been reported.
Comment 5 Thomas Baumgart 2010-02-11 12:13:43 UTC
Made it a wishlist item, so that we can come back later to it for decision.
Comment 6 harry bennett 2012-03-13 17:50:40 UTC
can i get some more information on what is, and where to find this matching feature?

I am having some issues with importing qif files but would like to explore as many options as possible before submitting a bug report
Comment 7 Markus 2012-05-17 06:06:11 UTC
I have some problems with the automatic matching feature too: several of the transactions imported via HBCI are matched wrong (my bank is the ING-DiBa). Complicating is, that KMM doesn't display the original transaction texts from the bank, so I have no chance to correct the wrong matching.

So I have to wishes and would like to propose:
1) please implement a global feature where you can switch on/off the automatic matching
2) please implement a global setting for new payees where I can preset if you would like to auto match it or not by default
3) please improve the handling of the HBCI imported transactions text: all text should be available after conceiling it

In general I would place an idea for improving the process to match imported transactions with existing transactions:
It would be more clear and easier, if you get a two divided window with two lists:  on the upper side you see all new imported transactions via HBCI (or QIF or whatever). Below that list you can find your transactions from the ledger,
Then you can select a transaction from the import list and add it to your ledger, or you can select an existing transaction in the ledger to "connect" / match them. 

You can see this behaviour for example im Quicken or in Mac Giro.
Comment 8 Jack 2013-09-17 23:15:19 UTC
It seems the original poster is ok closing this as WORKSFORME, although he asks whether it is correct or not for a P field which contains two spaces embedded between other text to match to a payee with a blank name.  Unless someone confirms this is wrong behavior, this should probably be closed.

I originally responded to Harry Bennett on th emai list, and I think Markus' request should be opened as a new wishlist item if they are still desired, although we probably already have some existing requests in this area.
Comment 9 Jack 2022-03-14 21:08:46 UTC
Is it time to close this, or does the wishlist item still need to be filed?
Comment 10 Jack 2022-12-19 23:52:49 UTC
I'm finally going to close this, but I do note that there is a new feature recently added to the master branch that imported transactions now show "Original payee: " so you don't lose that text if the payee was matched.  Unfortunately, there is not yet a timeline for a release with this feature.