Menu

#328 Error importing OFX file v2.0

closed-fixed
nobody
importer (23)
5
2009-03-01
2008-09-04
No

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 !

Discussion

  • LiteulDiablo

    LiteulDiablo - 2008-09-04
    • labels: --> importer
     
  • LiteulDiablo

    LiteulDiablo - 2008-09-04
    • summary: Error importing QFX file --> Error importing QFX file v2.0
     
  • Alvaro Soliverez

    Which version are you using?
    The importers have changed a lot in CVS. Specially since 0.8.x versions.

     
  • Alvaro Soliverez

    • summary: Error importing QFX file v2.0 --> Error importing OFX file v2.0
     
  • LiteulDiablo

    LiteulDiablo - 2009-02-17

    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>
    -----

     
  • Thomas Baumgart

    Thomas Baumgart - 2009-02-17
    • status: open --> pending-fixed
     
  • Thomas Baumgart

    Thomas Baumgart - 2009-02-17

    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.

     
  • LiteulDiablo

    LiteulDiablo - 2009-03-01

    No more problem with version "kmymoney2 20090228cvs-0ubuntu1~ppa2"
    You can close the bug.

    Thanks for the fix !

     
  • LiteulDiablo

    LiteulDiablo - 2009-03-01
    • status: pending-fixed --> open-fixed
     
  • Thomas Baumgart

    Thomas Baumgart - 2009-03-01
    • status: open-fixed --> closed-fixed
     
MongoDB Logo MongoDB