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

2022-01-13 Thread Jean L
I'm a bit confused by this discussion. Is there a consensus as to whether the bug is located in libofx, or whether libofx is passing on the right info, and GC is misinterpreting it? Jean On 1/13/2022 8:41 PM, David Carlson wrote: I have kept copies of OFX exports from several FI's for my

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

2022-01-13 Thread David Carlson
I have kept copies of OFX exports from several FI's for my personal data for several years. I could make a few of them available for testing if needed. They are from several different US banks, credit union, or credit card companies. I quoted the October 16 2020 edition of the OFX standard in

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

2022-01-13 Thread Mark Sutton
Ok, so I see there was no change to gnucash to fix this only a fix to libofx. So I shouldn't even bother looking at the combination of 4.9 and 0.10.2. I will upgrade and try a few different time stamp/ offset combinations. Thanks On Thu, Jan 13, 2022 at 10:32:17AM -0800, John Ralls wrote: >

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

2022-01-13 Thread 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

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

2022-01-13 Thread Mark Sutton
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

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

2022-01-13 Thread john
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. Regards,

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

2022-01-12 Thread xraive .
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

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

2022-01-12 Thread David Carlson
om:* David Carlson > *Sent:* Wednesday, January 12, 2022 8:58 PM > *To:* xraive . > *Cc:* Mattia Rizzolo ; Gnucash Users < > gnucash-user@gnucash.org> > *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD > Bank) > > Derek is a developer. Follo

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

2022-01-12 Thread xraive .
? From: David Carlson Sent: Wednesday, January 12, 2022 8:58 PM To: xraive . Cc: Mattia Rizzolo ; Gnucash Users 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

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

2022-01-12 Thread David Carlson
are the developers aware of this issue. >> >> -- >> *From:* David Carlson >> *Sent:* Wednesday, January 12, 2022 8:25 PM >> *To:* xraive . >> *Cc:* Mattia Rizzolo ; Gnucash Users < >> gnucash-user@gnucash.org> >> *Subject:* Re: [GN

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

2022-01-12 Thread David Carlson
*To:* xraive . > *Cc:* Mattia Rizzolo ; Gnucash Users < > 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 somet

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

2022-01-12 Thread Derek Atkins
cash Users 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

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

2022-01-12 Thread xraive .
nucash.org<mailto: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 . mailto:xra...@hotmail.com>> wrote: > I changed [-5:EST] to [+2:EST] and the dat

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

2022-01-12 Thread David Carlson
ve . > Sent: Wednesday, January 12, 2022 6:00 PM > To: Mattia Rizzolo ; gnucash-user@gnucash.org < > 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 t

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

2022-01-12 Thread xraive .
I forgot to mention the file from RBC works fine. From: xraive . Sent: Wednesday, January 12, 2022 6:00 PM To: Mattia Rizzolo ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Thanks for correcting me, I

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

2022-01-12 Thread xraive .
:EST] From: gnucash-user on behalf of Mattia Rizzolo Sent: Wednesday, January 12, 2022 4:53 PM To: 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 . wrote: > I chan

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

2022-01-12 Thread Fred Bone
On 12 January 2022 at 17:53, Mattia Rizzolo said: > On Wed, Jan 12, 2022 at 5:46 PM xraive . 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

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

2022-01-12 Thread Derek Atkins
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 On Wed, January 12, 2022 12:26 pm, David Carlson wrote: > doing a little research I found this history, but no current bug. > >

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

2022-01-12 Thread David Carlson
doing a little research I found this history, but no current bug. https://bugs.gnucash.org/show_bug.cgi?id=636340 On Wed, Jan 12, 2022 at 11:17 AM Derek Atkins wrote: > Hi, > > On Wed, January 12, 2022 12:03 pm, David Carlson wrote: > > Xraive, > > Your test proves that GnuCash in the release

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

2022-01-12 Thread Derek Atkins
Hi, On Wed, January 12, 2022 12:03 pm, David Carlson wrote: > Xraive, > Your test proves that GnuCash in the release that you are using does not > perform that import function correctly. You have found a work-around > which > will work for you temporarily. Now that the developers are aware of

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

2022-01-12 Thread David Carlson
Xraive, Your test proves that GnuCash in the release that you are using does not perform that import function correctly. You have found a work-around which will work for you temporarily. Now that the developers are aware of this, hopefully there should be a fix applied in the next update.

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

2022-01-12 Thread Mattia Rizzolo
On Wed, Jan 12, 2022 at 5:46 PM xraive . 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

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

2022-01-12 Thread xraive .
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Are you using our AIO bundle downloaded from https://sourceforge.net/projects/gnucash or https://github.com/gnucash/GnuCash, perhaps after linking through https://www.gnucash.org? This appears to be the behavior of a bug

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

2022-01-11 Thread xraive .
11, 2022 10:55 PM To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) what time zone are you in? 2:00AM (whether GMT, or EST) is still yesterday if you are GMT-8 ? On J

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

2022-01-11 Thread john
; Sent: Tuesday, January 11, 2022 10:55 PM > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) > > what time zone are you in? 2:00AM (whether GMT, or EST) is still yesterday if > you are GMT-8 ? > > On January 11, 2022 2:33:0

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

2022-01-11 Thread xraive .
I'm in the Eastern Standard Time - Time zone in (GMT-5). From: gnucash-user on behalf of Mark Sutton Sent: Tuesday, January 11, 2022 10:55 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) what time

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

2022-01-11 Thread Mark Sutton
he bank. This is all normal. > > > > > > Thank You, > > Gyle McCollam > > > > Gyle McCollam > > > > 609.680.2326 Mobile > > > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > >

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

2022-01-11 Thread Mark Sutton
> >> > >> > ---- Original Message ---- >> > From: Gyle McCollam >> > Sent: Tue Jan 11 13:33:51 EST 2022 >> > To: "D." >> > Cc: "gnucash-user@gnucash.org" >> > Subject: Re: Re: [GNC] Transaction Date is

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

2022-01-11 Thread xraive .
This is what I have in my file. 20220101161409[-5:EST] From: David Reiser Sent: Tuesday, January 11, 2022 11:36 PM To: xraive . Cc: David Carlson ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) What do

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

2022-01-11 Thread David Reiser via gnucash-user
time zone as the time zone in the file. > > > From: David Carlson > Sent: Tuesday, January 11, 2022 10:57 PM > To: xraive . > Cc: Jean Laroche ; gnucash-user@gnucash.org > > Subject: Re: [GNC] Transaction Date issues during import OFX fi

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

2022-01-11 Thread xraive .
Yes I live in the same time zone as the time zone in the file. From: David Carlson Sent: Tuesday, January 11, 2022 10:57 PM To: xraive . Cc: Jean Laroche ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank

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

2022-01-11 Thread David Carlson
gt; > Thanks in advance. > > -- > *From:* xraive . > *Sent:* Tuesday, January 11, 2022 10:33 PM > *To:* David Carlson ; Jean Laroche < > rip...@gmail.com> > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Transaction Date issues during impor

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

2022-01-11 Thread xraive .
Carlson ; Jean Laroche Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Sorry for the late response. I tried removing [-5:EST] and the issue still persists. All the dates are still reported as one day earlier. I imported the same file

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

2022-01-11 Thread xraive .
of David Carlson Sent: Tuesday, January 11, 2022 9:33 PM To: Jean Laroche Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) That -5 EST relates local time to universal time and may come into play if the local computer clock is not set

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

2022-01-11 Thread David Carlson
hese days) > shouldn't get shifted around much at all. I'd be miffed if every EFT entry > were a day off. > > > > > > Original Message > > From: Gyle McCollam > > Sent: Tue Jan 11 13:33:51 EST 2022 > > To: "D." > >

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

2022-01-11 Thread Jean Laroche
uldn't get shifted around much at all. I'd be miffed if every EFT entry were a day off. Original Message From: Gyle McCollam Sent: Tue Jan 11 13:33:51 EST 2022 To: "D." Cc: "gnucash-user@gnucash.org" Subject: Re: Re: [GNC] Transaction Date issues during import

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

2022-01-11 Thread D. via gnucash-user
ser@gnucash.org" Subject: Re: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) I find my dates usualy do not agree with the bank dates. I record credit card bills when I pay them (electronically) and they are recorded by the payee on the same date. However, they usually hit my b

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

2022-01-11 Thread Gyle McCollam
D. via gnucash-user Sent: Tuesday, January 11, 2022 1:20 PM To: David Carlson Cc: GnuCash Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) I'd be annoyed at the shift. I wonder what happens if the "[-5:EST]" gets removed. The dates seem to have 02

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

2022-01-11 Thread D. via gnucash-user
t: Tue Jan 11 12:53:59 EST 2022 To: "xraive ." Cc: Gnucash Users Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Your bank creates the Ofx file. Gnucash just accepts what they give you. Sometimes it may appear to be incorrect when it is a misunderst

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

2022-01-11 Thread David Carlson
Your bank creates the Ofx file. Gnucash just accepts what they give you. Sometimes it may appear to be incorrect when it is a misunderstanding about whether transactions are posted on the same day they occur. Does it really make a difference? On Tue, Jan 11, 2022, 10:12 AM xraive . wrote:

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

2022-01-11 Thread xraive .
I downloaded transactions from my bank (TD) in Canada and when I tried importing the file into GNUCASH all the dates were set to one day earlier then the actual transactions. I'm including sample transactions below. OFX file imported to GNUCASH DEBIT 2021072202[-5:EST] -14.64