[GNC] CSV matching produces duplicates?

[David Cousens]

That is a pretty reasonable summary of the position with CSV imports. The
records in CSV do not contain the additional information that identifies a
particular transaction uniquely that is present in the OFX file so its
detection of duplicates is not as reliable as with OFX.  The Bayesian
process is used primarily in matching the transfer account to the data based
on previous assignments and not for the duplicate detection AFAIK. That is
primarily  based on a score of matches of the data in selected fields
between transactions in the date range around the date of the data being
imported.

When you get the no match message I think you can force the match editor to
come up (this is another popup dialog in addition to the Import Matcher
window). It has been a long time since I have had to use it  but if I
remember correctly it is something like a click or double click in any area
of the record other than the transfer account field. I don't have time to
check it out this morning unfortunately as I have an appointment but I will
try it out later today or tomorrow and report back. This will show you
transactions most closely matching the record being imported and you can
force selection of a particular match. I don't think this feature is very
well described in the documentation.  I wrote a lot of the current
documentation largely from experimentation with the program while matching
it to the code, but there were a few areas  where I hadn't managed to work
out exactly how they worked. When I have a bit of spare time I'll take
another look at that area.

My bank is pretty good with the date transaction range selection, so I can
set the 1st of the month to the last of the month and it wont download any
transactions either side of that. The only problems now are when i have
manually entered transactions with a date slightly different from the bank's
date. transaction clearing in banks locally is generally minutes these days
so it is rare for the dates to deliver. A few years back it was far more
likely.

Once the transactions have had the transfer account assigned, they usually
appear in the account register even though they have not yet been finally
imported. I use multiple screens so having the account register and the
import matcher window displayed side by side makes it easier.  I mainly rely
on reconciliation with the downloaded statements to find any really
difficult to locate duplicates.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html