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

Derek Atkins derek at ihtfp.com
Wed Jan 12 15:50:05 EST 2022


If you feel there is still a bug, you should file a report in Bugzilla.  
Issues here are easily lost or forgotten, so it is not safe to assume 
developers are aware and will remember to explore and fix it.

-derek
Sent using my mobile device. Please excuse any typos.
On January 12, 2022 3:43:08 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<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.
> _______________________________________________
> 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.



More information about the gnucash-user mailing list