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

[David Carlson]

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> 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>
> *Sent:* Wednesday, January 12, 2022 8:25 PM
> *To:* xraive . <xraive at hotmail.com>
> *Cc:* 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 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> wrote:
>
> I forgot to mention the file from RBC works fine.
>
> ________________________________
> From: xraive . <xraive at hotmail.com>
> Sent: Wednesday, January 12, 2022 6:00 PM
> To: Mattia Rizzolo <mattia at mapreri.org>; gnucash-user at gnucash.org <
> 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>
> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> Sent: Wednesday, January 12, 2022 4:53 PM
> To: gnucash-user at gnucash.org <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> 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
> 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
> 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.
>
>