There seems to be two reports already with somewhat similar issues but I could be mistaken.
https://bugs.gnucash.org/show_bug.cgi?id=797848 and a much older one https://bugs.gnucash.org/show_bug.cgi?id=137017 If they aren't related then I can go ahead and submit a new bug. What do you think? ________________________________ From: David Carlson <david.carlson....@gmail.com> Sent: Wednesday, January 12, 2022 8:58 PM To: xraive . <xra...@hotmail.com> Cc: Mattia Rizzolo <mat...@mapreri.org>; Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Derek is a developer. Follow his advice On Wed, Jan 12, 2022, 2:56 PM David Carlson <david.carlson....@gmail.com<mailto:david.carlson....@gmail.com>> wrote: You as a user have no way of knowing the history that the developers have already done on that problem. I would hope that one of them will look at it and get back to us with an answer whether the solution committed last year didn't work, never made it to release 4.9, or what happened. On Wed, Jan 12, 2022, 2:41 PM xraive . <xra...@hotmail.com<mailto:xra...@hotmail.com>> wrote: I've never filled out a bug report. Can anyone confirm if need to submit one or are the developers aware of this issue. ________________________________ From: David Carlson <david.carlson....@gmail.com<mailto:david.carlson....@gmail.com>> Sent: Wednesday, January 12, 2022 8:25 PM To: xraive . <xra...@hotmail.com<mailto:xra...@hotmail.com>> Cc: Mattia Rizzolo <mat...@mapreri.org<mailto:mat...@mapreri.org>>; Gnucash Users <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) The OFX standard is very complex but that should not be an excuse for some of the mistakes that sometimes happen. It could be worse. I have one credit card that reverses the sign on charges and payments or the names of charges and payments, so everything comes in backwards. I will probably try switching to QIF for that one, but I vaguely recall there is a problem with that format too. I think even CSV has issues there. On Wed, Jan 12, 2022, 12:03 PM xraive . <xra...@hotmail.com<mailto:xra...@hotmail.com>> wrote: I forgot to mention the file from RBC works fine. ________________________________ From: xraive . <xra...@hotmail.com<mailto:xra...@hotmail.com>> Sent: Wednesday, January 12, 2022 6:00 PM To: Mattia Rizzolo <mat...@mapreri.org<mailto:mat...@mapreri.org>>; gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Thanks for correcting me, I tried your suggestion and it came to the same result. I've looked at my other financial institution and download their transactions. They also have the same format the only difference being the transaction time. TD: 20210722020000[-5:EST] RBC: 20211025120000[-5:EST] ________________________________ From: gnucash-user <gnucash-user-bounces+xraive=hotmail....@gnucash.org<mailto:hotmail....@gnucash.org>> on behalf of Mattia Rizzolo <mat...@mapreri.org<mailto:mat...@mapreri.org>> Sent: Wednesday, January 12, 2022 4:53 PM To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) On Wed, Jan 12, 2022 at 5:46 PM xraive . <xra...@hotmail.com<mailto:xra...@hotmail.com>> wrote: > I changed [-5:EST] to [+2:EST] and the dates are working. But I don't know > why that would work. FWIW, +2:EST doesn't make sense. If you want UTC+2, that would be +2:EET (for example). (though TBH I'm not sure what are the actual parsing rules (according to the standard) of that datetime string, so it might or might not change the result) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. more about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@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@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.
