Re: [GNC] reports: filter by number

[Bregt - ICTgroup.be via gnucash-user]

Hi Adrien,

Your first suggestion works like a charm. The created report is exactly
what I need. I'll have to work on the layout, as the options are more
limited, but that's a minor detail.

Your second suggestion, through the Transaction Report, indeed does not
operate on the NUM field: what is available is a filter on the Account
Name, or apply a regex on fields Description, Notes or Memo.

Thank you!

Kind regards,
Bregt

On 1/11/22 11:51 PM, Adrien Monteleone wrote:
> Do the bill#'s show up in the NUM field (or elsewhere) in your expense
> account registers?
>
> If so, my first suggestion would be to do a Find (from the CoA tab)
> filtering for the string you want.
>
> Then run an Account Report (or File > Export > Active Tab to CSV) on the
> Find results tab.
>
> Let us know if that works.
>
> Also, while the P&L/Income Report filtering is somewhat limited, the
> Transaction Report gives much more flexibility and *should* operate on
> the NUM field if I am not mistaken. If not directly in the Filter
> option, then try the Regex option.
>
> Regards,
> Adrien
>
> On 1/11/22 6:29 AM, Bregt - ICTgroup.be via gnucash-user wrote:
>> Hi all!
>>
>> I live in Belgium and am using GnuCash and its business features for my
>> (small) company accounting.
>>
>> I'm running GnuCash 4.4 on Ubuntu Mate 20.04 LTS.
>>
>> I've composed a custom CoA in compliance to local accounting laws. My
>> accountant told me to register all transactions through one of 4
>> *theoretical* journals: "incomes" (linked to invoices and an A/R),
>> "expenses" (linked to bills and an A/P), "bank", and "others".
>>
>> So, for instance, the new coffeemachine we bought for the office is
>> booked through the "expenses" journal: an expenseaccount + a taxaccount
>> are debited, and a (general) vendoraccount (A/P) is credited. These type
>> of transactions (through bills) are numbered by GnuCash, I set the
>> numbers to be BILL-21001, BILL-21002, etc through the Counters feature.
>>
>> Some other expenses, however, are booked through the "others" journal as
>> they have nothing to do with an A/P and there's no tax involved in the
>> expense (so my accountant says, it has to do with quarterly VAT
>> declarations). So, these transactions are also expenses, but are not
>> registered as bills and thus not numbered by GnuCash, so I number them
>> manually: OTH-21001, OTH-21002, etc.
>>
>> As the year ended and we're to close the books for 2021, my accountant
>> is now asking for a listing of these 4 journals. If I create a report
>> with a listing of all the expenses-accounts, this report contains
>> transactions from both the "expenses" and the "others" journal. My
>> question: is there a way in GnuCash (besides selecting each and every
>> expense account individually, or exporting the report to a spreadsheet)
>> to create 2 separate reports filtered by the "Number" field? Idealy, I'd
>> filter on the string in the transaction number field, similar to the
>> currently available filter on account name, but this functionality is
>> currently not implemented.
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

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

[xraive .]

I changed [-5:EST] to [+2:EST] and the dates are working.  But I don't know why 
that would work.


From: gnucash-user  on 
behalf of xraive . 
Sent: Wednesday, January 12, 2022 6:55 AM
To: john 
Cc: Mark Sutton ; gnucash-user@gnucash.org 

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

Thanks for your response but I just tried from both locations and I still have 
the same issue.


From: john 
Sent: Wednesday, January 12, 2022 5:25 AM
To: xraive . 
Cc: Mark Sutton ; gnucash-user@gnucash.org 

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 in libofx where the offset is applied 
in the wrong direction, i.e. a GMT offset of -5 hours is added to GMT making 
2021-07-21T02:00:00 into 2021-07-20T21:00:00 when it should be subtracted 
making 2021-07-22T07:00:00. That bug is supposed to be patched in the GnuCash 
4.9 AIO packages.

Regards,
John Ralls


On Jan 11, 2022, at 4:48 PM, xraive . 
mailto:xra...@hotmail.com>> wrote:

I'm in the Eastern Standard Time - Time zone in (GMT-5).


From: gnucash-user 
mailto:gnucash-user-bounces+xraive=hotmail@gnucash.org>>
 on behalf of Mark Sutton mailto:m...@lazo.ca>>
Sent: Tuesday, January 11, 2022 10:55 PM
To: 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 January 11, 2022 2:33:08 PM PST, "xraive ." 
mailto:xra...@hotmail.com>> wrote:
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 in MSMoney and the dates matched the banks if that helps.

Thanks for your assistance so far.

From: gnucash-user 
mailto:gnucash-user-bounces+xraive=hotmail@gnucash.org>>
 on behalf of David Carlson 
mailto:david.carlson@gmail.com>>
Sent: Tuesday, January 11, 2022 9:33 PM
To: Jean Laroche mailto:rip...@gmail.com>>
Cc: gnucash-user@gnucash.org 
mailto: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 to the local time zone.  Usually it
clarifies the source time reference of the data.

On Tue, Jan 11, 2022, 2:07 PM Jean Laroche 
mailto:rip...@gmail.com>> wrote:

I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
have 0200 as their time; subtracting 5 hours from that would return -3
o'clock (and presumably shift the date back one).

You could do a test where you modify your OFX file to remove [-5:EST]
from all transactions (you can do that easily in an editor), then try to
import it and see whether this fixes the dates.

After that the question is whether that [-5:EST] is valid or not.
Jean


On 1/11/22 11:59 AM, D. via gnucash-user wrote:
But EFT transactions (which are the bulk of my txns these 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 mailto:gmccol...@live.com>>
Sent: Tue Jan 11 13:33:51 EST 2022
To: "D." mailto:sunfis...@yahoo.com>>
Cc: "gnucash-user@gnucash.org" 
mailto:gnucash-user@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 bank the next
banking day.  This isn't and shouldn't be a problem or concern.  Actual
physical checks take even longer to show up at the bank.  This is all
normal.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com  
 email


From: gnucash-user 
mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org>>
on behalf of D. via gnucash-user 
mailto:gnucash-user@gnucash.org>>
Sent: Tuesday, January 11, 2022 1:20 PM
To: David Carlson 
mailto:david.carlson@gmail.com>>
Cc: GnuCash mailto:gnucash-user@gnucash.org>>
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 0200 as their time; subtracting 5 hours from that would return -3
o'clock (and presumably shift the date back

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

[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 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@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.

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

[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. Unfortunately
in real life a fix for one problem sometimes creates a regression in some
other area.  Perhaps that is what happened here.

On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo  wrote:

> 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 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@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] reports: filter by number

[Adrien Monteleone]

Good to know, thanks for the follow-up!

Regards,
Adrien

On 1/12/22 3:31 AM, Bregt - ICTgroup.be via gnucash-user wrote:

Hi Adrien,

Your first suggestion works like a charm. The created report is exactly
what I need. I'll have to work on the layout, as the options are more
limited, but that's a minor detail.

Your second suggestion, through the Transaction Report, indeed does not
operate on the NUM field: what is available is a filter on the Account
Name, or apply a regex on fields Description, Notes or Memo.


___
gnucash-user mailing list
gnucash-user@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.

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

[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 this,
> hopefully there should be a fix applied in the next update. Unfortunately
> in real life a fix for one problem sometimes creates a regression in some
> other area.  Perhaps that is what happened here.

Is there a Bugzilla Bug# for this issue?

-derek

>
> On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo 
> wrote:
>
>> 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 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@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.
>>
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

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

[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 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. Unfortunately
> > in real life a fix for one problem sometimes creates a regression in some
> > other area.  Perhaps that is what happened here.
>
> Is there a Bugzilla Bug# for this issue?
>
> -derek
>
> >
> > On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo 
> > wrote:
> >
> >> 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 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@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.
> >>
> >
> >
> > --
> > David Carlson
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

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

[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.
>
> 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 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.
>> Unfortunately
>> > in real life a fix for one problem sometimes creates a regression in
>> some
>> > other area.  Perhaps that is what happened here.
>>
>> Is there a Bugzilla Bug# for this issue?
>>
>> -derek
>>
>> >
>> > On Wed, Jan 12, 2022 at 10:54 AM Mattia Rizzolo 
>> > wrote:
>> >
>> >> 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 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@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.
>> >>
>> >
>> >
>> > --
>> > David Carlson
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@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.
>> >
>>
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>>
>
> --
> David Carlson
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

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

[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 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)

Why "not sure"? The standard says "The offset defines the time zone." The 
time zone name is optional and, clearly, not used in determining the time 
zone.

___
gnucash-user mailing list
gnucash-user@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.

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

[xraive .]

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:  2021072202[-5:EST]
RBC:  2021102512[-5: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 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@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@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.

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

[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 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:  2021072202[-5:EST]
RBC:  2021102512[-5: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 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@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@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.

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

[David Carlson]

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 .  wrote:

> 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 <
> 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 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:  2021072202[-5:EST]
> RBC:  2021102512[-5: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 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@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@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@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.

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

[xraive .]

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 
Sent: Wednesday, January 12, 2022 8:25 PM
To: xraive . 
Cc: Mattia Rizzolo ; Gnucash 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 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 . 
mailto:xra...@hotmail.com>> wrote:
I forgot to mention the file from RBC works fine.


From: xraive . mailto:xra...@hotmail.com>>
Sent: Wednesday, January 12, 2022 6:00 PM
To: Mattia Rizzolo mailto:mat...@mapreri.org>>; 
gnucash-user@gnucash.org 
mailto: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 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:  2021072202[-5:EST]
RBC:  2021102512[-5:EST]


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Mattia Rizzolo mailto:mat...@mapreri.org>>
Sent: Wednesday, January 12, 2022 4:53 PM
To: 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 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@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@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@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.

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

[Derek Atkins]

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 ."  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 
Sent: Wednesday, January 12, 2022 8:25 PM
To: xraive . 
Cc: Mattia Rizzolo ; Gnucash 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 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 . 
mailto:xra...@hotmail.com>> wrote:

I forgot to mention the file from RBC works fine.


From: xraive . mailto:xra...@hotmail.com>>
Sent: Wednesday, January 12, 2022 6:00 PM
To: Mattia Rizzolo mailto:mat...@mapreri.org>>; 
gnucash-user@gnucash.org 
mailto: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 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:  2021072202[-5:EST]
RBC:  2021102512[-5:EST]


From: gnucash-user 
mailto:hotmail@gnucash.org>> 
on behalf of Mattia Rizzolo mailto:mat...@mapreri.org>>

Sent: Wednesday, January 12, 2022 4:53 PM
To: 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 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@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@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@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@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.

Re: [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 .  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 
> *Sent:* Wednesday, January 12, 2022 8:25 PM
> *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 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 .  wrote:
>
> 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 <
> 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 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:  2021072202[-5:EST]
> RBC:  2021102512[-5: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 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@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@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@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.

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

[David Carlson]

Derek is a developer.   Follow his advice

On Wed, Jan 12, 2022, 2:56 PM David Carlson 
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 .  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 
>> *Sent:* Wednesday, January 12, 2022 8:25 PM
>> *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 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 .  wrote:
>>
>> 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 <
>> 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 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:  2021072202[-5:EST]
>> RBC:  2021102512[-5: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 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@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@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@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.

[GNC] eBay Managed Payment

[Dale Holden]

Helo Guys

I am new on here and just trying to move from Xero Accounts.
I was wondering if any members on here use GC for eBay Managed Payments?
Id so i would like to have a quick chat if possible

[image: Mailtrack]

Sender
notified by
Mailtrack

12/01/22,
21:02:40
___
gnucash-user mailing list
gnucash-user@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.

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

[xraive .]

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


From: xraive . mailto:xra...@hotmail.com>>
Sent: Wednesday, January 12, 2022 6:00 PM
To: Mattia Rizzolo mailto:mat...@mapreri.org>>; 
gnucash-user@gnucash.org 
mailto: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 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:  2021072202[-5:EST]
RBC:  2021102512[-5:EST]


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Mattia Rizzolo mailto:mat...@mapreri.org>>
Sent: Wednesday, January 12, 2022 4:53 PM
To: 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 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@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@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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using

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

[David Carlson]

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 .  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 
> *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.   Follow his advice
>
> On Wed, Jan 12, 2022, 2:56 PM David Carlson 
> 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 .  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 
> *Sent:* Wednesday, January 12, 2022 8:25 PM
> *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 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 .  wrote:
>
> 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 <
> 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 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:  2021072202[-5:EST]
> RBC:  2021102512[-5: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 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@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@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 Repl

Re: [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 
Sent: Thursday, January 13, 2022 12:45 AM
To: xraive . 
Cc: Derek Atkins ; Mattia Rizzolo ; 
Gnucash Users 
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 . 
mailto:xra...@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 
mailto:david.carlson@gmail.com>>
Sent: Wednesday, January 12, 2022 8:58 PM
To: xraive . mailto:xra...@hotmail.com>>
Cc: Mattia Rizzolo mailto:mat...@mapreri.org>>; Gnucash 
Users mailto:gnucash-user@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 
mailto:david.carlson@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 . 
mailto:xra...@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 
mailto:david.carlson@gmail.com>>
Sent: Wednesday, January 12, 2022 8:25 PM
To: xraive . mailto:xra...@hotmail.com>>
Cc: Mattia Rizzolo mailto:mat...@mapreri.org>>; Gnucash 
Users mailto: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 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 . 
mailto:xra...@hotmail.com>> wrote:
I forgot to mention the file from RBC works fine.


From: xraive . mailto:xra...@hotmail.com>>
Sent: Wednesday, January 12, 2022 6:00 PM
To: Mattia Rizzolo mailto:mat...@mapreri.org>>; 
gnucash-user@gnucash.org 
mailto: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 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:  2021072202[-5:EST]
RBC:  2021102512[-5:EST]


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Mattia Rizzolo mailto:mat...@mapreri.org>>
Sent: Wednesday, January 12, 2022 4:53 PM
To: 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 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@gnucash.org
To update your