[GNC] Transaction Date issues during import OFX file (TD Bank)

[xraive .]

Thanks for the assistance.  I submitted a bug report and included a link below.

https://bugs.gnucash.org/show_bug.cgi?id=798419

________________________________
From: David Carlson <david.carlson.417 at gmail.com>
Sent: Thursday, January 13, 2022 12:45 AM
To: xraive . <xraive at hotmail.com>
Cc: Derek Atkins <derek at ihtfp.com>; Mattia Rizzolo <mattia at mapreri.org>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

The most important thing is to report your own results with files from your banks and the rest of your details about the versions of Gnucash etc.  If you start a new bug report you could even reference those other bug reports.

Over the years there have been issues with daylight time adjustment s affecting the transactions date s in certain time zones  and sometimes bank data is questionable.

If the developer s need more information they will ask.

On Wed, Jan 12, 2022, 3:37 PM xraive . <xraive at hotmail.com<mailto:xraive at hotmail.com>> wrote:

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.417 at gmail.com<mailto:david.carlson.417 at gmail.com>>
Sent: Wednesday, January 12, 2022 8:58 PM
To: xraive . <xraive at hotmail.com<mailto:xraive at hotmail.com>>
Cc: Mattia Rizzolo <mattia at mapreri.org<mailto:mattia at mapreri.org>>; Gnucash Users <gnucash-user at gnucash.org<mailto:gnucash-user at 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.417 at gmail.com<mailto:david.carlson.417 at 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 . <xraive at hotmail.com<mailto:xraive at 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.417 at gmail.com<mailto:david.carlson.417 at gmail.com>>
Sent: Wednesday, January 12, 2022 8:25 PM
To: xraive . <xraive at hotmail.com<mailto:xraive at hotmail.com>>
Cc: Mattia Rizzolo <mattia at mapreri.org<mailto:mattia at mapreri.org>>; Gnucash Users <gnucash-user at gnucash.org<mailto:gnucash-user at 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 . <xraive at hotmail.com<mailto:xraive at hotmail.com>> wrote:
I forgot to mention the file from RBC works fine.

________________________________
From: xraive . <xraive at hotmail.com<mailto:xraive at hotmail.com>>
Sent: Wednesday, January 12, 2022 6:00 PM
To: Mattia Rizzolo <mattia at mapreri.org<mailto:mattia at mapreri.org>>; gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <gnucash-user at gnucash.org<mailto:gnucash-user at 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.com at gnucash.org<mailto:hotmail.com at gnucash.org>> on behalf of Mattia Rizzolo <mattia at mapreri.org<mailto:mattia at mapreri.org>>
Sent: Wednesday, January 12, 2022 4:53 PM
To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

On Wed, Jan 12, 2022 at 5:46 PM xraive . <xraive at hotmail.com<mailto:xraive at 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 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.