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

[John Ralls]

Mark,

AIO expands to "all-in-one" and refers to the Windows and macOS bundles that we publish containing GnuCash and all of its dependencies. Flatpak is something of a hybrid in that the GNOME dependencies are provided by the flatpak runtime and our build script adds AQBanking, Boost, and libofx.

The relevant commit is https://github.com/libofx/libofx/commit/70ae1b44fd4ea00175ae9fa5a6abd12243534fc2 and it was to fix https://bugs.gnucash.org/show_bug.cgi?id=798267.

Interestingly that bug was for Australian Eastern Standard Time, +10:00 instead of US Eastern Standard Time -5:00.

Regards,
John Ralls

> On Jan 13, 2022, at 10:07 AM, Mark Sutton <mes at lazo.ca> wrote:
> 
> On Thu, Jan 13, 2022 at 09:28:06AM -0800, john wrote:
>> Derek,
>> 
>> The libofx change was in libofx-0.10.3 but I also (as I generally do) set the same patch to libofx 0.10.2 in the build repositories so GnuCash 4.8 and 4.9 include the fix.
>> Since the 4.9 AIO still doesn't work there must be another path where the TZ is bering applied backwards.
>> 
> I'm not sure what AIO is, but I have 4.9 installed on funtoo. Right now libofx-0.10.2
> is installed, but I can emerge libofx-0.10.3.
> I have also run into this problem but I am in UTC-8 or -7 depending on the time
> of year so the problem only manifested when DST set in. I think I just massaged the
> file to make the transaction post at noon then it didn't matter.
> 
> I have five years of TD files to import so I don't mind doing some tests.
> So what combination should work? gnc-4.9 with libofx-0.10.2? 
> if so does that break with 0.10.3 
> I can not find the commit that might have fixed this so I can't see what it does.
> Does it check version and apply the correction or not.
> 
> -mark
>> 
>> 
>>> On Jan 12, 2022, at 9:31 AM, Derek Atkins <derek at ihtfp.com> wrote:
>>> 
>>> According to that bug it was fixed in LibOFX in June 2021...  And the fix
>>> appears to be in 0.10.3
>>> What version of LibOFX is in use?
>>> 
>>> -derek
> _______________________________________________
> 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.