When there is twice the same operation in a QFX file (same date, same total
but different label), only one is imported in kmymoney.
File example :
---------------------------------
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20080902
<TRNAMT>-7.90
<FITID>0364 020908 -790
<NAME> CB A.R.E.A. 31/08/08
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20080902
<TRNAMT>-7.90
<FITID>0364 020908 -790
<NAME> CB A.R.E.A. 30/08/08
</STMTTRN>
<STMTTRN>
---------------------------------
Operation appears as duplicated in the popup as the end of import.
________________________________________________
The OFX specification clearly states the following:
"Each <STMTTRN> contains an <FITID> that the client uses to detect whether
the server has previously
downloaded the transaction."
and a bit further down, where FITID is explained:
"Transaction ID issued by financial institution. Used to detect duplicate
downloads, FITID"
and since the FITID in your statement is identical, the OFX importer
treats those as duplicates as specified. If you really expect two different
transactions at this point, it is a problem of the institution issuing the
OFX data.
________________________________________________
Actually, it seems that my financial institution doesn't respect this specification
However, I don't think it's possible to have the same transaction twice in the same file.
The <FITID> is here to compare client data and bank data if there is duplicate entry when the same file is imported twice (or when the file contains previously imported entries)
I don't think that checking duplicates entries in an incoming file is needed...
All the other softwares I have tried doesn't care of that and include the two statement in the registry
Thanks for you app...
I'm waiting for version 1.0 !
Which version are you using?
The importers have changed a lot in CVS. Specially since 0.8.x versions.
I'm using version 0.9.2-CVS from here :
deb http://ppa.launchpad.net/claydoh/ubuntu intrepid main restricted universe multiverse
Same problem with this entry :
-----
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20090202
<TRNAMT>-7.90
<FITID>0364 020209 -790
<NAME> CB A.R.E.A. 31/08/08
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20090202
<TRNAMT>-7.90
<FITID>0364 020209 -790
<NAME> CB A.R.E.A. 30/08/08
</STMTTRN>
-----
The logic to create internally unique IDs even if the bank's id is identical for different transactions in the same statement did not work correctly. It has now been fixed in CVS HEAD.
No more problem with version "kmymoney2 20090228cvs-0ubuntu1~ppa2"
You can close the bug.
Thanks for the fix !