[GNC] Incorrect QFX Import

[Jean L]

OK, that would have been too easy :D... Any chance you could send me the 
OFX? Remove anything that's private in it if you want. I'll debug on my 
end. If you get a chance, open a bug, and put the file there, otherwise 
send it to me directly...
Thanks!

Jean


On 12/29/2021 7:58 PM, Steve Cohen wrote:
> There do not appear to be any duplicate FITIDs here.
>
> I ran the command
>
> grep FITID downloaded.QFX | sort > fitid.txt
>
> and could easily see that there were no duplicates in the 136 entries 
> in the file. The bank (Chase) appears to assign FITIDs of the form 
> YYYYmmDD# where # is a consecutive number from 0-9.  What it would do 
> if there were more than 10 entries isn't clear to me but that 
> eventuality did not occur in this file which has only 136 entries over 
> a year.
>
>
>
> On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche <ripngo at gmail.com 
> <mailto:ripngo at gmail.com>> wrote:
>
>     GC will not import an ofx transaction it thinks it already has
>     imported.
>     To determine whether a transaction has been imported GC looks at the
>     FITID. So if two transactions in your OFX file have the same
>     FITID, the
>     second one won't be imported.
>
>     Can you check that the transactions that are missing don't have
>     the same
>     FITID as some of the transactions that were imported?
>     Some banks are not good at assigning unique FITID to transactions,
>     and
>     that can cause a problem for GC.
>     Jean
>
>     On 12/29/21 2:13 PM, Steve Cohen wrote:
>     > Additionally, I tried exiting GnuCash and trying the import
>     again.  This
>     > made no difference.
>     >
>     > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen <stevecoh2 at gmail.com
>     <mailto:stevecoh2 at gmail.com>> wrote:
>     >
>     >> I downloaded all of 2021's transactions from my bank in QFX
>     format and
>     >> tried to import the file.
>     >>
>     >> As I was doing so, I noticed an anomaly.  I receive monthly direct
>     >> deposits from a pension, all arrive on or shortly after the
>     first of each
>     >> month, the same amount every month. But on the QFX import
>     screen, only 5 of
>     >> the months showed the deposit,
>     >> for January, May, August, September and December. The other
>     seven months
>     >> were not on the import screen. I tried sorting by date, by
>     amount, by
>     >> description - they aren't there.
>     >>
>     >> In an attempt to learn what was going on, I first checked my bank
>     >> statements.  Was the pension not being deposited? No, that
>     wasn't it, the
>     >> deposits came in every month as they were supposed to. I then
>     opened the
>     >> QFX file in a text editor to see if the deposits were listed in
>     the QFX.
>     >> They all were.  So I am trying to understand if there's a bug
>     in the import
>     >> function that would throw these transactions away.
>     >>
>     >> Here are the QFX entries from December and November. Perhaps
>     someone
>     >> looking at them can tell me why the first one was accepted and
>     the second
>     >> not? I see no important difference.
>     >>
>     >> <STMTTRN>
>     >> <TRNTYPE>CREDIT
>     >> <DTPOSTED>20211201120000[0:GMT]
>     >> <TRNAMT>1772.79
>     >> <FITID>202112010
>     >> <NAME>COOK COUNTY PENS PENSIONS
>     >> <MEMO>PPD ID: 3660023021
>     >> </STMTTRN>
>     >>
>     >> <STMTTRN>
>     >> <TRNTYPE>CREDIT
>     >> <DTPOSTED>20211101120000[0:GMT]
>     >> <TRNAMT>1772.79
>     >> <FITID>202111010
>     >> <NAME>COOK COUNTY PENS PENSIONS
>     >> <MEMO>PPD ID: 3660023021
>     >> </STMTTRN>
>     >>
>     > _______________________________________________
>     > gnucash-user mailing list
>     > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     > To update your subscription preferences or to unsubscribe:
>     > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     > If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>     > -----
>     > Please remember to CC this list on all your replies.
>     > You can do this by using Reply-To-List or Reply-All.
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>