Re: [GNC] Get online quote for Canada Fund

[David T. via gnucash-user]

Note that adding the price source column to the security list will allow you to 
see at a glance which source all your stocks are using. 

 
 
  On Wed, Aug 14, 2019 at 8:17, David Reiser via 
gnucash-user wrote:   First, make sure that _none_ of 
your stocks are requesting quotes through yahoo. (yahoo_json is OK, though). It 
took me about 3 tries going through my stocks list to track down the straggling 
reference. Any stock whose online quote source is yahoo will cause the entire 
retrieval effort to fail.
--
Dave Reiser
dbrei...@icloud.com





> On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
> 
> Hello,  I still need someone help me.
> 
> I made changes of Cdnfundlibrary.pm.  Now when I run:
> 
> perl .\gnc-fq-dump -v fundlibrary  8282
> 
> I could get:
> 
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> 8282
> Finance::Quote fields Gnucash uses:
>    symbol: 8282                <=== required
>      date: 08/12/2019          <=== recommended
>  currency: CAD                  <=== required
>      last: 14.91                <=\
>      nav:                      <=== one of these
>    price:                      <=/
>  timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock 8282
> 
> stock          field  value
> -          -  -
> 8282        currency: CAD
> 8282            date: 08/12/2019
> 8282          isodate: 2019-08-12
> 8282            last: 14.91
> 8282            link: https://www.fundlibrary.com/MutualFunds/Detail/8282
> 8282          method: fundlibrary
> 8282          source: http://www.fundlibrary.com
> 8282          success: 1
> 8282          symbol: 8282
> 
> 
> So the results looks correct to me.  BUT when I go to Tools->Price
> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
> 
> How should I debug this problem?
> 
> Thanks a lot.
> 
> 
> 
___
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] Get online quote for Canada Fund

[John Ralls]

No, the #e means that it's an exact number (1491/100) instead of a 
floating-point one. That's a Good Thing™.

Are you getting the "Unable to create price quotes for these items" dialog?

Regards,
John Ralls


> On Aug 13, 2019, at 8:38 PM, Kaman Wu  wrote:
> 
> I do not use yahoo (Just use yahoo_json)
> when I use gnc-fq-helper, I got:
> (("8282" (symbol . "8282") (gnc:time-no-zone . "2019-08-12 12:00:00") (last
> . #e14.91) (currency . "CAD")))
> 
> Is #e14.91 a problem?
> 
> 
> Thanks,
> 
> 
> 
> 
> On Tue, Aug 13, 2019 at 10:35 PM David Reiser  wrote:
> 
>> First, make sure that _none_ of your stocks are requesting quotes through
>> yahoo. (yahoo_json is OK, though). It took me about 3 tries going through
>> my stocks list to track down the straggling reference. Any stock whose
>> online quote source is yahoo will cause the entire retrieval effort to fail.
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
>>> 
>>> Hello,  I still need someone help me.
>>> 
>>> I made changes of Cdnfundlibrary.pm.  Now when I run:
>>> 
>>> perl .\gnc-fq-dump -v fundlibrary   8282
>>> 
>>> I could get:
>>> 
>>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
>>> 8282
>>> Finance::Quote fields Gnucash uses:
>>>   symbol: 8282 <=== required
>>> date: 08/12/2019   <=== recommended
>>> currency: CAD  <=== required
>>> last: 14.91<=\
>>>  nav:  <=== one of these
>>>price:  <=/
>>> timezone:  <=== optional
>>> 
>>> All fields returned by Finance::Quote for stock 8282
>>> 
>>> stock   field  value
>>> -   -  -
>>> 8282 currency: CAD
>>> 8282 date: 08/12/2019
>>> 8282  isodate: 2019-08-12
>>> 8282 last: 14.91
>>> 8282 link:
>> https://www.fundlibrary.com/MutualFunds/Detail/8282
>>> 8282   method: fundlibrary
>>> 8282   source: http://www.fundlibrary.com
>>> 8282  success: 1
>>> 8282   symbol: 8282
>>> 
>>> 
>>> So the results looks correct to me.  BUT when I go to Tools->Price
>>> Database, and clicked "Get Quotes" button, I still CANNOT get the
>> results.
>>> 
>>> How should I debug this problem?
>>> 
>>> Thanks a lot.
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér  wrote:
>>> 
 Sorry, I don't know, I'm using Linux, so directories will be very
 different.
 br Ove.
 
 On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:
 
> Hello Ove,
> 
> I try to change the code by myself.  I am using windows 10 right now.
> 
> I find the perl code
> at:
>> C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
> 
> BUT after I made the change, it looks like the GNC still call the old
> code.  Can I change that file directly?
> Does GNC keep a copy of this file? (I cannot find the it)
> 
> Thanks a lot.
> 
> 
> 
> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
> 
>> thanks a lot.  I will try it.
>> 
>> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér 
>> wrote:
>> 
>>> I was looking at the code in cpan, and it looks like the module is
>>> using this base url
>>> 
>>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=
>>> 
>>> and then adding the code after it, e.g.
>>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743
>>> 
>>> however when trying this url, I get Error 404, unknown web page,
>>> 
>>> It could be that the module is not current and fails on everything.
>>> 
>>> if you are comfortable with perl, you could try changing the url in
>> the module.
>>> 
>>> I tried also to retrieve the mutual fund from my ubuntu based
>> gnucash, and it also fails.
>>> 
>>> there are contact details for this module on this url:
>> https://metacpan.org/author/ECOCODE
>>> 
>>> the author of the code may be able to help more.
>>> 
>>> br Ove.
>>> 
>>> 
>>> 
>>> 
>>> On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:
>>> 
 Hello Ove,
 
 Thanks for reply my question.  I did try "1743".  Still get the same
 error message.   I really need solve the problem, otherwise, I have
>> to
 manually input the price for all funds I have.
 
 
 PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
 fundlibrary   1743
 Finance::Quote fields Gnucash uses:
   symbol: 1743 (deduced)   <=== required
 date: ** missing **<=== recommended
 currency: ** missing **<=== required
 last:  <=\
  nav:  <=== one of these
price:  <=/
 timezone: 

Re: [GNC] Get online quote for Canada Fund

[John Ralls via gnucash-user]

Bet it took you three times because you didn't realize that you can open 
Tools>Securities, go to the right end of the header, click the little arrow and 
select Source to add the quote source to the display columns, then click that 
column header to sort on it.

Namespace (e.g. NYSE) is still the primary sort key, but inside each namespace 
the securities will be sorted by the quote source making it much easier to find 
"bad" sources.

Regards,
John Ralls


> On Aug 13, 2019, at 7:35 PM, David Reiser via gnucash-user 
>  wrote:
> 
> First, make sure that _none_ of your stocks are requesting quotes through 
> yahoo. (yahoo_json is OK, though). It took me about 3 tries going through my 
> stocks list to track down the straggling reference. Any stock whose online 
> quote source is yahoo will cause the entire retrieval effort to fail.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
>> 
>> Hello,  I still need someone help me.
>> 
>> I made changes of Cdnfundlibrary.pm.  Now when I run:
>> 
>> perl .\gnc-fq-dump -v fundlibrary   8282
>> 
>> I could get:
>> 
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
>> 8282
>> Finance::Quote fields Gnucash uses:
>>   symbol: 8282 <=== required
>> date: 08/12/2019   <=== recommended
>> currency: CAD  <=== required
>> last: 14.91<=\
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> All fields returned by Finance::Quote for stock 8282
>> 
>> stock   field  value
>> -   -  -
>> 8282 currency: CAD
>> 8282 date: 08/12/2019
>> 8282  isodate: 2019-08-12
>> 8282 last: 14.91
>> 8282 link: https://www.fundlibrary.com/MutualFunds/Detail/8282
>> 8282   method: fundlibrary
>> 8282   source: http://www.fundlibrary.com
>> 8282  success: 1
>> 8282   symbol: 8282
>> 
>> 
>> So the results looks correct to me.  BUT when I go to Tools->Price
>> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
>> 
>> How should I debug this problem?
>> 
>> Thanks a lot.
>> 
>> 
>> 
>> 
>> 
>> 
>> On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér  wrote:
>> 
>>> Sorry, I don't know, I'm using Linux, so directories will be very
>>> different.
>>> br Ove.
>>> 
>>> On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:
>>> 
 Hello Ove,
 
 I try to change the code by myself.  I am using windows 10 right now.
 
 I find the perl code
 at: 
 C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
 
 BUT after I made the change, it looks like the GNC still call the old
 code.  Can I change that file directly?
 Does GNC keep a copy of this file? (I cannot find the it)
 
 Thanks a lot.
 
 
 
 On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
 
> thanks a lot.  I will try it.
> 
> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér  wrote:
> 
>> I was looking at the code in cpan, and it looks like the module is
>> using this base url
>> 
>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=
>> 
>> and then adding the code after it, e.g.
>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743
>> 
>> however when trying this url, I get Error 404, unknown web page,
>> 
>> It could be that the module is not current and fails on everything.
>> 
>> if you are comfortable with perl, you could try changing the url in the 
>> module.
>> 
>> I tried also to retrieve the mutual fund from my ubuntu based gnucash, 
>> and it also fails.
>> 
>> there are contact details for this module on this url: 
>> https://metacpan.org/author/ECOCODE
>> 
>> the author of the code may be able to help more.
>> 
>> br Ove.
>> 
>> 
>> 
>> 
>> On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:
>> 
>>> Hello Ove,
>>> 
>>> Thanks for reply my question.  I did try "1743".  Still get the same
>>> error message.   I really need solve the problem, otherwise, I have to
>>> manually input the price for all funds I have.
>>> 
>>> 
>>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
>>> fundlibrary   1743
>>> Finance::Quote fields Gnucash uses:
>>>   symbol: 1743 (deduced)   <=== required
>>> date: ** missing **<=== recommended
>>> currency: ** missing **<=== required
>>> last:  <=\
>>>  nav:  <=== one of these
>>>price:  <=/
>>> timezone:  <=== optional
>>> 
>>> ** This stock quote cannot be used by GnuCash!
>>> 
>>> 
>>> All fields returned by Finance::Quote 

Re: [GNC] Get online quote for Canada Fund

[Kaman Wu]

I do not use yahoo (Just use yahoo_json)
when I use gnc-fq-helper, I got:
(("8282" (symbol . "8282") (gnc:time-no-zone . "2019-08-12 12:00:00") (last
. #e14.91) (currency . "CAD")))

Is #e14.91 a problem?


Thanks,




On Tue, Aug 13, 2019 at 10:35 PM David Reiser  wrote:

> First, make sure that _none_ of your stocks are requesting quotes through
> yahoo. (yahoo_json is OK, though). It took me about 3 tries going through
> my stocks list to track down the straggling reference. Any stock whose
> online quote source is yahoo will cause the entire retrieval effort to fail.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
> >
> > Hello,  I still need someone help me.
> >
> > I made changes of Cdnfundlibrary.pm.  Now when I run:
> >
> > perl .\gnc-fq-dump -v fundlibrary   8282
> >
> > I could get:
> >
> > PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> > 8282
> > Finance::Quote fields Gnucash uses:
> >symbol: 8282 <=== required
> >  date: 08/12/2019   <=== recommended
> >  currency: CAD  <=== required
> >  last: 14.91<=\
> >   nav:  <=== one of these
> > price:  <=/
> >  timezone:  <=== optional
> >
> > All fields returned by Finance::Quote for stock 8282
> >
> > stock   field  value
> > -   -  -
> > 8282 currency: CAD
> > 8282 date: 08/12/2019
> > 8282  isodate: 2019-08-12
> > 8282 last: 14.91
> > 8282 link:
> https://www.fundlibrary.com/MutualFunds/Detail/8282
> > 8282   method: fundlibrary
> > 8282   source: http://www.fundlibrary.com
> > 8282  success: 1
> > 8282   symbol: 8282
> >
> >
> > So the results looks correct to me.  BUT when I go to Tools->Price
> > Database, and clicked "Get Quotes" button, I still CANNOT get the
> results.
> >
> > How should I debug this problem?
> >
> > Thanks a lot.
> >
> >
> >
> >
> >
> >
> > On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér  wrote:
> >
> >> Sorry, I don't know, I'm using Linux, so directories will be very
> >> different.
> >> br Ove.
> >>
> >> On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:
> >>
> >>> Hello Ove,
> >>>
> >>> I try to change the code by myself.  I am using windows 10 right now.
> >>>
> >>> I find the perl code
> >>> at:
> C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
> >>>
> >>> BUT after I made the change, it looks like the GNC still call the old
> >>> code.  Can I change that file directly?
> >>> Does GNC keep a copy of this file? (I cannot find the it)
> >>>
> >>> Thanks a lot.
> >>>
> >>>
> >>>
> >>> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
> >>>
>  thanks a lot.  I will try it.
> 
>  On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér 
> wrote:
> 
> > I was looking at the code in cpan, and it looks like the module is
> > using this base url
> >
> > http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=
> >
> > and then adding the code after it, e.g.
> > http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743
> >
> > however when trying this url, I get Error 404, unknown web page,
> >
> > It could be that the module is not current and fails on everything.
> >
> > if you are comfortable with perl, you could try changing the url in
> the module.
> >
> > I tried also to retrieve the mutual fund from my ubuntu based
> gnucash, and it also fails.
> >
> > there are contact details for this module on this url:
> https://metacpan.org/author/ECOCODE
> >
> > the author of the code may be able to help more.
> >
> > br Ove.
> >
> >
> >
> >
> > On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:
> >
> >> Hello Ove,
> >>
> >> Thanks for reply my question.  I did try "1743".  Still get the same
> >> error message.   I really need solve the problem, otherwise, I have
> to
> >> manually input the price for all funds I have.
> >>
> >>
> >> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
> >> fundlibrary   1743
> >> Finance::Quote fields Gnucash uses:
> >>symbol: 1743 (deduced)   <=== required
> >>  date: ** missing **<=== recommended
> >>  currency: ** missing **<=== required
> >>  last:  <=\
> >>   nav:  <=== one of these
> >> price:  <=/
> >>  timezone:  <=== optional
> >>
> >> ** This stock quote cannot be used by GnuCash!
> >>
> >>
> >> All fields returned by Finance::Quote for stock 1743
> >>
> >> stock   field  value
> >> -   -  -
> >> 1743 errormsg: Fund name 1743 not found
> >> 1743 last: 

Re: [GNC] Problem with save-as

[John Ralls]

> On Aug 13, 2019, at 2:52 PM, James Fuller  wrote:
> 
> 
> I tried to use the save as to change the name of a file last evening. Here is 
> what I did:
> 
> from the File drop down menu I chose Save-As,  When the next screen popped up 
> it asked for the name I wanted to use. I chose and entered databack.  I then 
> went to the Places select box and clicked on 640GB (F:).  Next I went to the 
> Name screen and entered in the save in folder (pre-existing) cruzback.  Then 
> moving to the bottom right of the screen clicked the radio button Save as. I 
> looked in F:\cruzback.   There is a save with the familiar Backuologo 
> followed with databack   8/13/2019  GnuCash Financial Data  8 KB. 
> There is also a databack.Gnucash.201908131529478/13/2019 3:29 which is 
> the usual data file accompanying the backup files.  My question is tis,  why 
> is there no dates etc. appended to the name databackup? I'm afraid that 
> without that info, the next save will just overwrite this file.
> 
> any idea how I'm messing this one up?

Relax, you're not messing anything up.

Assuming you're using the XML backend, when you first save a file it's the only 
one you have so there's no appended timestamp. After you do some work on it and 
save it, either by hand or via auto-save, GnuCash renames the file you opened 
by appending the current timestamp before writing out the new file with the 
undecorated name. This ensures that even if the computer should crash during 
the save at least your old data will be safe. The file with the undecorated 
name is always the "most current" and the one that GnuCash will load and list 
in the most-recent list in the File menu.

Now if you're using the SQLite3 backend things work a little differently: 
SQLite3 is in control of the file and writes new data to it without needing to 
rewrite the whole thing, and it does so immediately after each edit. There are 
no "old" files to serve as backups, and SQLite3 has its own mechanisms for 
ensuring that nothing is lost if the system should fail in the middle of a 
write.

Regards,
John Ralls

___
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] Get online quote for Canada Fund

[David Reiser via gnucash-user]

First, make sure that _none_ of your stocks are requesting quotes through 
yahoo. (yahoo_json is OK, though). It took me about 3 tries going through my 
stocks list to track down the straggling reference. Any stock whose online 
quote source is yahoo will cause the entire retrieval effort to fail.
--
Dave Reiser
dbrei...@icloud.com





> On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
> 
> Hello,  I still need someone help me.
> 
> I made changes of Cdnfundlibrary.pm.  Now when I run:
> 
> perl .\gnc-fq-dump -v fundlibrary   8282
> 
> I could get:
> 
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> 8282
> Finance::Quote fields Gnucash uses:
>symbol: 8282 <=== required
>  date: 08/12/2019   <=== recommended
>  currency: CAD  <=== required
>  last: 14.91<=\
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> All fields returned by Finance::Quote for stock 8282
> 
> stock   field  value
> -   -  -
> 8282 currency: CAD
> 8282 date: 08/12/2019
> 8282  isodate: 2019-08-12
> 8282 last: 14.91
> 8282 link: https://www.fundlibrary.com/MutualFunds/Detail/8282
> 8282   method: fundlibrary
> 8282   source: http://www.fundlibrary.com
> 8282  success: 1
> 8282   symbol: 8282
> 
> 
> So the results looks correct to me.  BUT when I go to Tools->Price
> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
> 
> How should I debug this problem?
> 
> Thanks a lot.
> 
> 
> 
> 
> 
> 
> On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér  wrote:
> 
>> Sorry, I don't know, I'm using Linux, so directories will be very
>> different.
>> br Ove.
>> 
>> On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:
>> 
>>> Hello Ove,
>>> 
>>> I try to change the code by myself.  I am using windows 10 right now.
>>> 
>>> I find the perl code
>>> at: 
>>> C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
>>> 
>>> BUT after I made the change, it looks like the GNC still call the old
>>> code.  Can I change that file directly?
>>> Does GNC keep a copy of this file? (I cannot find the it)
>>> 
>>> Thanks a lot.
>>> 
>>> 
>>> 
>>> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
>>> 
 thanks a lot.  I will try it.
 
 On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér  wrote:
 
> I was looking at the code in cpan, and it looks like the module is
> using this base url
> 
> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=
> 
> and then adding the code after it, e.g.
> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743
> 
> however when trying this url, I get Error 404, unknown web page,
> 
> It could be that the module is not current and fails on everything.
> 
> if you are comfortable with perl, you could try changing the url in the 
> module.
> 
> I tried also to retrieve the mutual fund from my ubuntu based gnucash, 
> and it also fails.
> 
> there are contact details for this module on this url: 
> https://metacpan.org/author/ECOCODE
> 
> the author of the code may be able to help more.
> 
> br Ove.
> 
> 
> 
> 
> On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:
> 
>> Hello Ove,
>> 
>> Thanks for reply my question.  I did try "1743".  Still get the same
>> error message.   I really need solve the problem, otherwise, I have to
>> manually input the price for all funds I have.
>> 
>> 
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
>> fundlibrary   1743
>> Finance::Quote fields Gnucash uses:
>>symbol: 1743 (deduced)   <=== required
>>  date: ** missing **<=== recommended
>>  currency: ** missing **<=== required
>>  last:  <=\
>>   nav:  <=== one of these
>> price:  <=/
>>  timezone:  <=== optional
>> 
>> ** This stock quote cannot be used by GnuCash!
>> 
>> 
>> All fields returned by Finance::Quote for stock 1743
>> 
>> stock   field  value
>> -   -  -
>> 1743 errormsg: Fund name 1743 not found
>> 1743 last: **missing**
>> 1743  nav: **missing**
>> 1743price: **missing**
>> 1743  success: 0
>> 
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
>> canadamutual  1743
>> Finance::Quote fields Gnucash uses:
>>symbol: 1743 (deduced)   <=== required
>>  date: ** missing **<=== recommended
>>  currency: ** missing **<=== required
>>  last:  <=\
>>   nav:   

Re: [GNC] Get online quote for Canada Fund

[Frank H. Ellenberger]

Hi,

Am Mi., 14. Aug. 2019 um 03:30 Uhr schrieb Kaman Wu :
>
> Hello,  I still need someone help me.
>
> I made changes of Cdnfundlibrary.pm.  Now when I run:
>
> perl .\gnc-fq-dump -v fundlibrary   8282
>
> I could get:
>
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> 8282
> Finance::Quote fields Gnucash uses:
> symbol: 8282 <=== required
>   date: 08/12/2019   <=== recommended
>   currency: CAD  <=== required
>   last: 14.91<=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> All fields returned by Finance::Quote for stock 8282
>
> stock   field  value
> -   -  -
> 8282 currency: CAD
> 8282 date: 08/12/2019
> 8282  isodate: 2019-08-12
> 8282 last: 14.91
> 8282 link: https://www.fundlibrary.com/MutualFunds/Detail/8282
> 8282   method: fundlibrary
> 8282   source: http://www.fundlibrary.com
> 8282  success: 1
> 8282   symbol: 8282
>
>
> So the results looks correct to me.  BUT when I go to Tools->Price
> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
>
> How should I debug this problem?

Try gnc-fq-helper, see
https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
HTH
Frank
___
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] Get online quote for Canada Fund

[Kaman Wu]

Hello,  I still need someone help me.

I made changes of Cdnfundlibrary.pm.  Now when I run:

perl .\gnc-fq-dump -v fundlibrary   8282

I could get:

PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
8282
Finance::Quote fields Gnucash uses:
symbol: 8282 <=== required
  date: 08/12/2019   <=== recommended
  currency: CAD  <=== required
  last: 14.91<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 8282

stock   field  value
-   -  -
8282 currency: CAD
8282 date: 08/12/2019
8282  isodate: 2019-08-12
8282 last: 14.91
8282 link: https://www.fundlibrary.com/MutualFunds/Detail/8282
8282   method: fundlibrary
8282   source: http://www.fundlibrary.com
8282  success: 1
8282   symbol: 8282


So the results looks correct to me.  BUT when I go to Tools->Price
Database, and clicked "Get Quotes" button, I still CANNOT get the results.

How should I debug this problem?

Thanks a lot.






On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér  wrote:

> Sorry, I don't know, I'm using Linux, so directories will be very
> different.
> br Ove.
>
> On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:
>
>> Hello Ove,
>>
>> I try to change the code by myself.  I am using windows 10 right now.
>>
>> I find the perl code
>> at: 
>> C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
>>
>> BUT after I made the change, it looks like the GNC still call the old
>> code.  Can I change that file directly?
>> Does GNC keep a copy of this file? (I cannot find the it)
>>
>> Thanks a lot.
>>
>>
>>
>> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
>>
>>> thanks a lot.  I will try it.
>>>
>>> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér  wrote:
>>>
 I was looking at the code in cpan, and it looks like the module is
 using this base url

 http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=

 and then adding the code after it, e.g.
 http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743

 however when trying this url, I get Error 404, unknown web page,

 It could be that the module is not current and fails on everything.

 if you are comfortable with perl, you could try changing the url in the 
 module.

 I tried also to retrieve the mutual fund from my ubuntu based gnucash, and 
 it also fails.

 there are contact details for this module on this url: 
 https://metacpan.org/author/ECOCODE

 the author of the code may be able to help more.

 br Ove.




 On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:

> Hello Ove,
>
> Thanks for reply my question.  I did try "1743".  Still get the same
> error message.   I really need solve the problem, otherwise, I have to
> manually input the price for all funds I have.
>
>
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
> fundlibrary   1743
> Finance::Quote fields Gnucash uses:
> symbol: 1743 (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> All fields returned by Finance::Quote for stock 1743
>
> stock   field  value
> -   -  -
> 1743 errormsg: Fund name 1743 not found
> 1743 last: **missing**
> 1743  nav: **missing**
> 1743price: **missing**
> 1743  success: 0
>
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
> canadamutual  1743
> Finance::Quote fields Gnucash uses:
> symbol: 1743 (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> All fields returned by Finance::Quote for stock 1743
>
> stock   field  value
> -   -  -
> 1743 errormsg: Error determining fund code for 1743.
> 1743 last: **missing**
> 1743  nav: **missing**
> 1743price: **missing**
> 1743  success: 0
>
>
>
>
>
>

Re: [GNC] Problem with save-as

[Adrien Monteleone]

The dates are appended to backups that GnuCash makes. If you just save a file 
on your own, how would it presume to know to append the date to the file name? 
Why would it alter your chosen file name?

Why would you not want the next save to overwrite the current file?

Regards,
Adrien

> On Aug 13, 2019, at 4:52 PM, James Fuller  wrote:
> 
> 
> I tried to use the save as to change the name of a file last evening. Here is 
> what I did:
> 
> from the File drop down menu I chose Save-As,  When the next screen popped up 
> it asked for the name I wanted to use. I chose and entered databack.  I then 
> went to the Places select box and clicked on 640GB (F:).  Next I went to the 
> Name screen and entered in the save in folder (pre-existing) cruzback.  Then 
> moving to the bottom right of the screen clicked the radio button Save as. I 
> looked in F:\cruzback.   There is a save with the familiar Backuologo 
> followed with databack   8/13/2019  GnuCash Financial Data  8 KB. 
> There is also a databack.Gnucash.201908131529478/13/2019 3:29 which is 
> the usual data file accompanying the backup files.  My question is tis,  why 
> is there no dates etc. appended to the name databackup? I'm afraid that 
> without that info, the next save will just overwrite this file.
> 
> any idea how I'm messing this one up?
> 
> Thanks,
> 
> James Fuller

___
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] Problem with save-as

[James Fuller]

I tried to use the save as to change the name of a file last evening. 
Here is what I did:


from the File drop down menu I chose Save-As,  When the next screen 
popped up it asked for the name I wanted to use. I chose and entered 
databack.  I then went to the Places select box and clicked on 640GB 
(F:).  Next I went to the Name screen and entered in the save in folder 
(pre-existing) cruzback.  Then moving to the bottom right of the screen 
clicked the radio button Save as. I looked in F:\cruzback.   There is a 
save with the familiar Backuologo followed with databack   
8/13/2019  GnuCash Financial Data  8 KB. There is also a 
databack.Gnucash.20190813152947    8/13/2019 3:29 which is the usual 
data file accompanying the backup files.  My question is tis,  why is 
there no dates etc. appended to the name databackup? I'm afraid that 
without that info, the next save will just overwrite this file.


any idea how I'm messing this one up?

Thanks,

James Fuller





___
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] journal entries

[Mike or Penny Novack]

On 8/13/2019 10:57 AM, Dale Alspach wrote:



The Gnucash documentation could make some general statements about
differences between Gnucash and other accounting software, but it would be
too much to expect specifics about the other software.
Dale
 Gnucash IS ordinary, run of the mill, double entry accounting software 
<< all the double entry apps I have used are also "virtual journal" >> 
There is little to learn for anybody familiar with double entry 
bookkeeping (and that IS standard for accounting, has been for a VERY 
long time)


If you mean "differences from other applications that are NOT standard 
accounting" why should that be necessary. Shouldn't simply saying that 
gnucash is "double entry bookkeeping" enough? The documentation DOES 
make that clear. Not up to gnucash to point out that non-double entry 
isn't standard accounting.


Michael D Novack
___
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] Problems moving vertical lines between columns on registers

[Greg Feneis]

You can also double click the column headers of all but the description
column. Last, double click the header for the description column.

This automatically sets the columns' widths to just the minimum needed to
display the contents of the fields, except the description column.
Description column automatically adjusts to normalize the page width.

Kind regards, Greg Feneis
(Pixel 3)


On Mon, Aug 12, 2019, 18:30 James Fuller  wrote:

>
> David,
> thanks very much.  after some cut and try I got what I Need.
> I appreciate the help.
> Regards,
> James
>
>
> On 8/12/2019 6:09 PM, David Carlson wrote:
> > James,
> >
> > Keep in mind that in the register view the description column is a
> > special case that essentially defaults to use all the space that is
> > not explicitly given to other columns.
> >
> > This means setting the other widths first, then dragging the right
> > edge of the description column title box leftward and letting it snap
> > back until there is no horizontal scrollbar at the bottom.
> >
> > Of course, this can get awkward for users that run the program on
> > computers with different display and font settings.  Since those
> > settings are defined as user settings, different computers normally
> > each keep their own settings, but if one accesses the program remotely
> > via ssh, for example, it can still get very interesting.
> >
> > David Carlson
> >
> > On Mon, Aug 12, 2019 at 6:15 PM James Fuller  > > wrote:
> >
> >
> > Hi Guys,
> >
> > I'm having a problem figuring out how to move the vertical lines
> > defining columns on registers.   I seem to remember that you place a
> > mouse cursor on the vertical line, hold down the right mouse
> > button, and
> > move left or right to change the width of of the columns. When I do
> > that, the vertical line moves with my mouse. When I let go of the
> > right
> > button the line zips back.
> >
> > I'm using 3.2 Gnucash on a Windows 7 HP desktop.  What am I doing
> > wrong?  BTW, I have read the Help Manual until I'm blue in the
> > face and
> > can't find it.
> >
> > Thank you
> >
> > James Fuller
> >
> > ___
> > 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.
>
___
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] gnucash-user Digest, Vol 197, Issue 31

[Rick Mobley]

David,

Perfect! The right click is what I was missing. Now I can work with the tab
bar in either position.

Thank you very much.
Rick

Message: 3
Date: Tue, 13 Aug 2019 10:44:57 -0500
From: David Carlson 
To: Adrien Monteleone 
Cc: Gnucash Users 
Subject: Re: [GNC] Default tab on open
Message-ID:

Content-Type: text/plain; charset="UTF-8"

I leave lots of tabs open across the top of the window.  When I want to go
to a tab that I  cannot see, I right click on the tab bar and choose the tab
from the dropdown list.

David Carlson

On Tue, Aug 13, 2019, 10:30 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Rick,
>
> It might not be as bad as you fear.
>
> I never used the scroll feature and just kept closing tabs as they got 
> too numerous.
>
> I don?t keep my GnuCash window full width to allow for some other 
> windows on the same screen. (bills & Invoices due reminders and the 
> upcoming SX along with a calculator. This also gives me screen space 
> to view PDF copies of bills to enter into GnuCash)
>
> Since moving my tabs to the left, I now keep about 8-10 open at all 
> times (mostly reports) and I use them much more and find it easier to 
> ?see? the one I want more easily than when they were on top. It took 
> me all of maybe a day or two of adapting.
>
> The only drawback is lots of tabs, especially with complicated 
> reports, can slow down the re-opening of GnuCash, particularly on Windows.
> Fortunately (though I?m on Mac) I never shut the app down except to
upgrade.
>
> Regards,
> Adrien
>
> > On Aug 13, 2019, at 10:17 AM, Rick Mobley 
> wrote:
> >
> > Yes, by the end of the month, I will likely have 10 tabs open while 
> > I am
> creating invoices. With the tabs at the top, they disappear off to the 
> right and I can't just "click" on one I can't see without scrolling to 
> the right. Scrolling now is one tab at a time instead of mouse wheel 
> to the right and click on the tab I want to display.
> >
> > For now, I have moved the tabs to the left and I can see them all to
> click on the tab I need. I was used to scrolling with the mouse wheel 
> but if that feature has broken, I will teach this old dog to look for 
> the tabs on the left side.
> >
> > Thanks,
> > Rick
>
>
> ___
> 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] First Day of the Week

[John Morris]

Curiouser and curiouser. I just booted my 2014 MacBook Pro in Mojave. I was 
hoping to see good results, but I was disappointed. My experience on Mojave was 
identical to my experience on El Capitan. I first tried changing just the day 
of the week and creating a new set of books. Then, I tried changing the whole 
region to United Kingdom and creating a new set of books. In both cases, both 
the date picker and the reports used Sunday as the first day of the week.

  This is a brand new, clean install of Mojave and GnuCash, so I don't think 
there can be any corruption in the user profile. GnuCash must be looking 
somewhere else to get the first day of the week.

  I forgot to check "locale" in Terminal, but I assume I would have gotten the 
same results already reported for Mojave (en_US when I set just the first day 
of the week and en_GB when I set the entire region).

Best,
John

> On Aug 13, 2019, at 10:07 AM, Michael Hendry  wrote:
> 
>> On 13 Aug 2019, at 14:52, Adrien Monteleone  
>> wrote:
>> 
>> Thanks Michael,
>> 
>> That is interesting.
>> 
>> I just changed my Mac to UK, even restarted the computer, still the date 
>> picker shows Sunday as the first day.
>> 
>> Maybe this is a change in Mojave?
>> 
>> Maybe some sort of user profile corruption myself and the OP share?
>> 
>> Anyone out there on Mojave with Monday working as the first day?
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 13, 2019, at 3:49 AM, Michael Hendry  
>>> wrote:
>> 
>>> When I bring up the date-picker on GC 3.6 on my Mac OS X High Sierra, I get 
>>> a calendar widget with Monday as the first day of the week.
>>> 
>>> This is my preference, but I’m not sure if I ever set it up as such, other 
>>> than selecting UK in my locale options on the Mac.
>>> 
>>> Looking at the Mac Calendar App’s preferences, I see that that is set up as 
>>> Monday-first.
>>> 
>>> In System Preferences —> Language & Region, I also have “First day of week: 
>>> Monday”.
>>> 
>>> Gnucash —> Preferences doesn’t appear to have a first-day setting, but it 
>>> picks up the correct date format from Locale.
>>> 
>>> HTH
>>> 
>>> Michael
> 
> What does “locale” tell you on your Mac?
> 
> Mine says:
> 
> | => locale
> LANG="en_GB.UTF-8"
> LC_COLLATE="en_GB.UTF-8"
> LC_CTYPE="en_GB.UTF-8"
> LC_MESSAGES="en_GB.UTF-8"
> LC_MONETARY="en_GB.UTF-8"
> LC_NUMERIC="en_GB.UTF-8"
> LC_TIME="en_GB.UTF-8"
> LC_ALL="en_GB.UTF-8”
> 
> Michael
> 
> ___
> 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] Get online quote for Canada Fund

[Ove Grunnér]

Sorry, I don't know, I'm using Linux, so directories will be very different.
br Ove.

On Tue, 13 Aug 2019 at 03:05, Kaman Wu  wrote:

> Hello Ove,
>
> I try to change the code by myself.  I am using windows 10 right now.
>
> I find the perl code
> at: 
> C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
>
> BUT after I made the change, it looks like the GNC still call the old
> code.  Can I change that file directly?
> Does GNC keep a copy of this file? (I cannot find the it)
>
> Thanks a lot.
>
>
>
> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu  wrote:
>
>> thanks a lot.  I will try it.
>>
>> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér  wrote:
>>
>>> I was looking at the code in cpan, and it looks like the module is using
>>> this base url
>>>
>>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=
>>>
>>> and then adding the code after it, e.g.
>>> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743
>>>
>>> however when trying this url, I get Error 404, unknown web page,
>>>
>>> It could be that the module is not current and fails on everything.
>>>
>>> if you are comfortable with perl, you could try changing the url in the 
>>> module.
>>>
>>> I tried also to retrieve the mutual fund from my ubuntu based gnucash, and 
>>> it also fails.
>>>
>>> there are contact details for this module on this url: 
>>> https://metacpan.org/author/ECOCODE
>>>
>>> the author of the code may be able to help more.
>>>
>>> br Ove.
>>>
>>>
>>>
>>>
>>> On Sun, 11 Aug 2019 at 15:44, Kaman Wu  wrote:
>>>
 Hello Ove,

 Thanks for reply my question.  I did try "1743".  Still get the same
 error message.   I really need solve the problem, otherwise, I have to
 manually input the price for all funds I have.


 PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
 fundlibrary   1743
 Finance::Quote fields Gnucash uses:
 symbol: 1743 (deduced)   <=== required
   date: ** missing **<=== recommended
   currency: ** missing **<=== required
   last:  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional

 ** This stock quote cannot be used by GnuCash!


 All fields returned by Finance::Quote for stock 1743

 stock   field  value
 -   -  -
 1743 errormsg: Fund name 1743 not found
 1743 last: **missing**
 1743  nav: **missing**
 1743price: **missing**
 1743  success: 0

 PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
 canadamutual  1743
 Finance::Quote fields Gnucash uses:
 symbol: 1743 (deduced)   <=== required
   date: ** missing **<=== recommended
   currency: ** missing **<=== required
   last:  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional

 ** This stock quote cannot be used by GnuCash!


 All fields returned by Finance::Quote for stock 1743

 stock   field  value
 -   -  -
 1743 errormsg: Error determining fund code for 1743.
 1743 last: **missing**
 1743  nav: **missing**
 1743price: **missing**
 1743  success: 0






 On Sun, Aug 11, 2019 at 6:56 AM Ove Grunnér 
 wrote:

> Hi Kaman,
>
> according to https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary
> "This module uses an id that represents the mutual fund on an id used
> by www.fundlibrary.com. There is no easy way of fetching the id
> except to jump onto the fundlibrary website, look up the fund and view the
> url for clues to its id number."
> the url for TDB900 is:
>
> https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743
> so try 1743
>
> br Ove.
>
> On Sun, 11 Aug 2019 at 04:07, Kaman Wu  wrote:
>
>> I did some search, and found some old posts which are not very
>> helpful.
>>
>> I think I can use:
>> https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary
>> Basing on this module, it use the data from
>> http://www.fundlibrary.com/
>>
>> I do can search TDB900 on this website and find the correct fund.
>>
>> BUT when I setup it up in gnucash, I get quote failed.
>>
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v
>> fundlibrary
>> TDB900
>> Finance::Quote fields Gnucash uses:
>> symbol: TDB900 (deduced) <=== required
>>   date: ** missing **<=== recommended
>>   currency: ** missing **<=== required
>>   

Re: [GNC] Scroll through tabs

[Catscrash]

Am 13.08.19 um 07:44 schrieb Liz:
> I tried it today on Debian. I've never used this feature, but
> experimented.
> Debian Buster/Sid
> Gnucash
> Version: 3.4
> Build ID: 3.4+ (2018-12-30)
> Finance::Quote: 1.47
> __

so, what was the result of your experiment? ;-)

___
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] First Day of the Week

[Michael Hendry]

> On 13 Aug 2019, at 17:00, Adrien Monteleone  
> wrote:
> 
> I think Christopher confirmed earlier that the Transaction Report code is not 
> considering locale at all.
> 
> There’s already a bug on it from 2015: 
> https://bugs.gnucash.org/show_bug.cgi?id=752395
> 
> Though it seems at that point in time, the report was stuck on Monday instead 
> of Sunday!
> 
> Regards,
> Adrien

I had entirely forgotten that I reported the problem (as a persistent Monday to 
Sunday weekly report, despite a change of locale), after I read John Morris’s 
2015 message ( 
https://lists.gnucash.org/pipermail/gnucash-user/2015-June/060793.html ).

I didn’t follow up, partly because the default setting suited me, but also 
because I had looked into the weekly report option and found I didn’t actually 
need to use it anyway.

Regards,

Michael

___
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] First Day of the Week

[John Morris]

Hi Michael,
  Thank you for chiming in. This is very good news. Perhaps I just need to move 
further up the OS ladder. I'm currently working with a 2008 MacBook Pro that 
cannot run anything beyond El Capitan. However, I do also plan to move my 2014 
MacBook Pro to Mojave. If it works correctly for you in High Sierra, it should 
work correctly for me in Mojave (assuming that GnuCash runs in general on 
Mojave). I will report my results when I get around to running that test.

Best,
John

> When I bring up the date-picker on GC 3.6 on my Mac OS X High Sierra, I get a 
> calendar widget with Monday as the first day of the week.
> 
> This is my preference, but I’m not sure if I ever set it up as such, other 
> than selecting UK in my locale options on the Mac.
> 
> Looking at the Mac Calendar App’s preferences, I see that that is set up as 
> Monday-first.
> 
> In System Preferences —> Language & Region, I also have “First day of week: 
> Monday”.
> 
> Gnucash —> Preferences doesn’t appear to have a first-day setting, but it 
> picks up the correct date format from Locale.
> 
> HTH
> 
> Michael
___
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] First Day of the Week

[John Morris]

Hi Adrien,
  Thanks for the clarification. I certainly agree that this could be a problem 
in GTK. I don't have enough information about GnuCash's inner workings to make 
that judgment.

Best,
John

> On Aug 13, 2019, at 4:04 AM, Adrien Monteleone 
>  wrote:
> 
> But I don’t think GnuCash is doing that. (telling the widget to draw a 
> calendar with first_weekday set to ‘Monday’) It is calling GtkCalendar() and 
> that widget doesn’t have a setting for defining the first day. Now, since it 
> seems to work on Ubuntu as another user reported, maybe the widget is looking 
> at the system locale, but something on MacOS is preventing that. (or it isn’t 
> even aware of the locale since it might have its own default)
> 
> This is where I was headed when I tried to copy this custom locale file to my 
> user profile’s gtk-3.0 folder.
> 
> However, I see now that GnuCash.app has a locale folder but the files there 
> seem to be encoded somehow and not plain text. I’ll have to check the sources 
> out to see what is really there. It could be those locale files are not set 
> to have first_weekday be ‘2’ and they are taking precedence.
> 
> And yes, testing a different GTK app on a Mac would shed some light on if it 
> is possible. Unfortunately, I don’t think my other GTK apps have date pickers 
> or calendar widgets in use. Maybe someone else has such an app to try.
> 
> Regards,
> Adrien
___
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] First Day of the Week

[John Morris]

Hi Catscrash,
  Thank you for confirming that at least someone can get GnuCash to use Monday 
as the first day of the week. Unfortunately, the pictures did not come through, 
but I believe you that it is working on your system.

  I'm not sure how to describe the report I'm referring to. On my system (macOS 
10.10, Yosemite), I simply open the Reports menu and choose Transaction Report. 
I then click the options button to bring up the report's options. In that 
dialog, I select the accounts to include on the Accounts tab, set the report's 
date range on the General tab and set the primary key to Date on the Sorting 
tab. On that last tab, I also have to change the Primary Subtotal for Date Key 
to Weekly because it defaults to Monthly. After clicking Apply, I get a report 
of all the transactions in the selected accounts sorted by date with subtotals 
following the transactions from each Saturday. For example, if I set the date 
range for 20190805 to 20190901 (four weeks, Monday to Sunday), the first 
subtotal is reported as 2019-08-04 to 2019-08-10. The second subtotal is 
2019-08-11 to 2019-08-17 (Sunday to Saturday). Does this help you replicate the 
report?

Best,
John

> On Aug 13, 2019, at 1:11 AM, Catscrash  wrote:
> 
> Hi,
> 
> at least for Ubuntu this is definitely not a problem. I don't know if
> the mailinglist allows pictures, but the date-chooser definitely shows
> the monday as first day of the week:
> 
> 
> I have the date settings in gnucash set to system default and my ubuntu
> is set to german
> 
> I'm not sure how to get to that report you are talking about, I'm
> certainly happy to check there...
> 
> best regards
___
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] Default tab on open

[David Carlson]

I leave lots of tabs open across the top of the window.  When I want to go
to a tab that I  cannot see, I right click on the tab bar and choose the
tab from the dropdown list.

David Carlson

On Tue, Aug 13, 2019, 10:30 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Rick,
>
> It might not be as bad as you fear.
>
> I never used the scroll feature and just kept closing tabs as they got too
> numerous.
>
> I don’t keep my GnuCash window full width to allow for some other windows
> on the same screen. (bills & Invoices due reminders and the upcoming SX
> along with a calculator. This also gives me screen space to view PDF copies
> of bills to enter into GnuCash)
>
> Since moving my tabs to the left, I now keep about 8-10 open at all times
> (mostly reports) and I use them much more and find it easier to ’see’ the
> one I want more easily than when they were on top. It took me all of maybe
> a day or two of adapting.
>
> The only drawback is lots of tabs, especially with complicated reports,
> can slow down the re-opening of GnuCash, particularly on Windows.
> Fortunately (though I’m on Mac) I never shut the app down except to upgrade.
>
> Regards,
> Adrien
>
> > On Aug 13, 2019, at 10:17 AM, Rick Mobley 
> wrote:
> >
> > Yes, by the end of the month, I will likely have 10 tabs open while I am
> creating invoices. With the tabs at the top, they disappear off to the
> right and I can't just "click" on one I can't see without scrolling to the
> right. Scrolling now is one tab at a time instead of mouse wheel to the
> right and click on the tab I want to display.
> >
> > For now, I have moved the tabs to the left and I can see them all to
> click on the tab I need. I was used to scrolling with the mouse wheel but
> if that feature has broken, I will teach this old dog to look for the tabs
> on the left side.
> >
> > Thanks,
> > Rick
>
>
> ___
> 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] Default tab on open

[Adrien Monteleone]

Rick,

It might not be as bad as you fear.

I never used the scroll feature and just kept closing tabs as they got too 
numerous.

I don’t keep my GnuCash window full width to allow for some other windows on 
the same screen. (bills & Invoices due reminders and the upcoming SX along with 
a calculator. This also gives me screen space to view PDF copies of bills to 
enter into GnuCash)

Since moving my tabs to the left, I now keep about 8-10 open at all times 
(mostly reports) and I use them much more and find it easier to ’see’ the one I 
want more easily than when they were on top. It took me all of maybe a day or 
two of adapting.

The only drawback is lots of tabs, especially with complicated reports, can 
slow down the re-opening of GnuCash, particularly on Windows. Fortunately 
(though I’m on Mac) I never shut the app down except to upgrade.

Regards,
Adrien

> On Aug 13, 2019, at 10:17 AM, Rick Mobley  wrote:
> 
> Yes, by the end of the month, I will likely have 10 tabs open while I am 
> creating invoices. With the tabs at the top, they disappear off to the right 
> and I can't just "click" on one I can't see without scrolling to the right. 
> Scrolling now is one tab at a time instead of mouse wheel to the right and 
> click on the tab I want to display.
> 
> For now, I have moved the tabs to the left and I can see them all to click on 
> the tab I need. I was used to scrolling with the mouse wheel but if that 
> feature has broken, I will teach this old dog to look for the tabs on the 
> left side.
> 
> Thanks,
> Rick


___
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] Default tab on open

[Rick Mobley]

Yes, by the end of the month, I will likely have 10 tabs open while I am 
creating invoices. With the tabs at the top, they disappear off to the right 
and I can't just "click" on one I can't see without scrolling to the right. 
Scrolling now is one tab at a time instead of mouse wheel to the right and 
click on the tab I want to display.

For now, I have moved the tabs to the left and I can see them all to click on 
the tab I need. I was used to scrolling with the mouse wheel but if that 
feature has broken, I will teach this old dog to look for the tabs on the left 
side.

Thanks,
Rick

-Original Message-
From: Colin Law [mailto:clan...@gmail.com] 
Sent: Tuesday, August 13, 2019 5:05 AM
To: Rick Mobley 
Cc: gnucash-user 
Subject: Re: [GNC] Default tab on open

Can I just check that you realise you can have multiple tabs open at once, each 
showing an account.  So to switch accounts you just need to click on the tab.

Colin

On Tue, 13 Aug 2019 at 01:04, Rick Mobley  wrote:
>
> Is there a place to set a "default" tab to open up to? I'd like for it 
> to open up to my cash account each time, but it seems to open to the 
> last place when I closed off the program.
>
>
>
> Rick
>
>
>
>
>
>
>
> ___
> 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] journal entries

[Dale Alspach]

The problem is actually that in these consumer oriented packages the
paradigm is different. In Gnucash the chart of accounts is fundamental. In
Quickbooks the  initial screen shows a set of tasks: add a customer, pay
bills, enter charges, etc. Clicking on these brings up a set of account
names, customers, vendors, etc. Underneath the user is creating a
transaction but parts of it are hidden. (This happens to a limited extent
in the Basic Ledger view in Gnucash.)
Let me describe writing a check in Quickbooks, I either click on Write
Checks on the Quickbooks desktop or go to the Bank menu and click on it
there. I choose the correct  checking account and am presented with an
image of a blank check. I fill in the Pay To and the bottom part of the
screen will show a split and will suggest an account. After filling in the
remaining parts of the check and scanning in and attaching any related
documents, I go to the split, select the appropriate account, enter a memo,
customer, job, or item. Additional splits can be added and the check can be
printed.
The point is that the user is not seeing the transaction as a whole, is not
seeing credit/debit or even more friendly versions of labels, and that the
interface is task oriented. With a task oriented system situations arise
which are not covered by the tasks in the user interface; those situations
can be handled by a journal entry. Making a journal entry in Quickbooks is
like Gnucash, i.e., double entry accounting. Here is an example list of
journal transactions from Intuit's site:

   - Opening balances in a new file
   - Adjusting entries
   - Asset purchases
   - Depreciation
   - Interest on loan accounts
   - End of financial year adjustments
   - Sales amount from a different industry software that is required in
   the accounting software
   - Company transfers, different entities in two different files
   - Stock adjustments
   - Capital contributions
   - Owner drawings

The Gnucash documentation could make some general statements about
differences between Gnucash and other accounting software, but it would be
too much to expect specifics about the other software.
Dale

On Tue, Aug 13, 2019 at 4:44 AM Fred Bone  wrote:

> On 12 August 2019 at 12:57, Mike or Penny Novack said:
>
> > On 8/12/2019 12:45 PM, Clint Chaplin wrote:
> > > This is also similar to NetSuite, which is an on-line double entry
> > > bookkeeping service, and where "journal entries" are a special case
> > > transaction, even though by definition everything is really a journal
> > > entry.
> > >
> > It is definitely a terminology confusion.
> >
> > In the old days, especially with "cash book" accounting*, a "journal
> > entry" referred to a transaction that was not affecting any of the cash
> > accounts. So mainly corrections and adjustments (example: recording
> > depreciation).
> >
> > It has no real meaning in a "virtual journal" system like gnucash.
>
> Indeed. But what is the meaning in the systems being referred to in this
> thread? The matter will undoubtedly arise again.
>
> ___
> 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] First Day of the Week

[Adrien Monteleone]

Presently, they are all set to en_US.UTF-8, but when I switch to UK, they are 
all en_GB.UTF-8 like yours.

Note that changing only the first day of the week (and leaving the locale 
alone) in System Preferences doesn’t change any locales for me. (but presumably 
writes the ‘first_weekday 2’ line into the LC_TIME section, I guess I’ll have 
to go digging for that file now.)

Regards,
Adrien

> On Aug 13, 2019, at 9:07 AM, Michael Hendry  wrote:
> 
> 
> What does “locale” tell you on your Mac?
> 
> Mine says:
> 
> | => locale
> LANG="en_GB.UTF-8"
> LC_COLLATE="en_GB.UTF-8"
> LC_CTYPE="en_GB.UTF-8"
> LC_MESSAGES="en_GB.UTF-8"
> LC_MONETARY="en_GB.UTF-8"
> LC_NUMERIC="en_GB.UTF-8"
> LC_TIME="en_GB.UTF-8"
> LC_ALL="en_GB.UTF-8”
> 
> Michael
> 
> 


___
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] First Day of the Week

[Michael Hendry]

> On 13 Aug 2019, at 14:52, Adrien Monteleone  
> wrote:
> 
> Thanks Michael,
> 
> That is interesting.
> 
> I just changed my Mac to UK, even restarted the computer, still the date 
> picker shows Sunday as the first day.
> 
> Maybe this is a change in Mojave?
> 
> Maybe some sort of user profile corruption myself and the OP share?
> 
> Anyone out there on Mojave with Monday working as the first day?
> 
> Regards,
> Adrien
> 
>> On Aug 13, 2019, at 3:49 AM, Michael Hendry  wrote:
> 
>> When I bring up the date-picker on GC 3.6 on my Mac OS X High Sierra, I get 
>> a calendar widget with Monday as the first day of the week.
>> 
>> This is my preference, but I’m not sure if I ever set it up as such, other 
>> than selecting UK in my locale options on the Mac.
>> 
>> Looking at the Mac Calendar App’s preferences, I see that that is set up as 
>> Monday-first.
>> 
>> In System Preferences —> Language & Region, I also have “First day of week: 
>> Monday”.
>> 
>> Gnucash —> Preferences doesn’t appear to have a first-day setting, but it 
>> picks up the correct date format from Locale.
>> 
>> HTH
>> 
>> Michael

What does “locale” tell you on your Mac?

Mine says:

| => locale
LANG="en_GB.UTF-8"
LC_COLLATE="en_GB.UTF-8"
LC_CTYPE="en_GB.UTF-8"
LC_MESSAGES="en_GB.UTF-8"
LC_MONETARY="en_GB.UTF-8"
LC_NUMERIC="en_GB.UTF-8"
LC_TIME="en_GB.UTF-8"
LC_ALL="en_GB.UTF-8”

Michael

___
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] First Day of the Week

[Adrien Monteleone]

Thanks Fred, so we know it isn’t a 3.6 change. (though I do see the SX Editor 
starts on Sunday now instead of Monday, which isn’t consistent with the locale)

Regards,
Adrien

> On Aug 13, 2019, at 5:17 AM, Fred Bone via gnucash-user 
>  wrote:
> 
> On 13 August 2019 at 2:57, Adrien Monteleone said:
> 
>> Hmm..
>> 
>> Is there anyone using Windows with a Monday first setup that works
>> correctly?
> 
> Windows 10, system week-start setting is Monday.
> 
> 2.6.21:
> 
> The calendar in the SX Editor starts the week on Monday. I have no idea 
> where it derives the setting, or indeed how to get it to use Sunday if 
> that was what I wanted. I have no use for the calendar.
> 
> The date-picker in the SX Editor also has Monday as first day. I don't 
> much care either way.
> 
> The date-picker in account registers is the same (presumably it's the 
> same widget).
> 
> "Income vs day of week" report starts on Sunday.
> 
> =
> 
> 3.6 Portable (fresh install, no attempt to  set any options):
> 
> SX Editor calendar starts on Sunday.
> 
> SX Editor date-picker starts on Monday.
> 
> Register date-picker starts on Monday.
> 
> "Income vs day of week" report starts on Sunday.
> 
> =
> 
> Happy to supply more detail if wanted.

___
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] First Day of the Week

[Adrien Monteleone]

Thanks Michael,

That is interesting.

I just changed my Mac to UK, even restarted the computer, still the date picker 
shows Sunday as the first day.

Maybe this is a change in Mojave?

Maybe some sort of user profile corruption myself and the OP share?

Anyone out there on Mojave with Monday working as the first day?

Regards,
Adrien

> On Aug 13, 2019, at 3:49 AM, Michael Hendry  wrote:

> When I bring up the date-picker on GC 3.6 on my Mac OS X High Sierra, I get a 
> calendar widget with Monday as the first day of the week.
> 
> This is my preference, but I’m not sure if I ever set it up as such, other 
> than selecting UK in my locale options on the Mac.
> 
> Looking at the Mac Calendar App’s preferences, I see that that is set up as 
> Monday-first.
> 
> In System Preferences —> Language & Region, I also have “First day of week: 
> Monday”.
> 
> Gnucash —> Preferences doesn’t appear to have a first-day setting, but it 
> picks up the correct date format from Locale.
> 
> HTH
> 
> Michael


___
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] First Day of the Week

[Derek Atkins]

Christopher Lam  writes:

> On Tue., 13 Aug. 2019, 11:12 John Morris,  wrote:
>
>>  I set this up with a simple transaction report by setting the date range
>> to run from the "start of previous month" to "today". I then set the
>> primary sort key to "Date" and the primary subtotal for date key to
>> "Weekly". If there is a way to get this level of granularity to start on a
>> different day, I would like to hear about it.
>>
>
> I confirm the transaction report weekly grouping doesn't consider locale
> setting at all.

Then please file a bug on this topic.

>>   I'm sorry, but (as I said) I have a lot on my plate. Spending the time
>> to write up clear bug reports that probably won't be looked at for years
>> and certainly won't be addressed any time soon does not seem like a good
>> investment at this time.
>>
>
> Conversely, user issues which are not logged in Bugzilla are usually
> ignored. Feel free to file a bug about above.

Indeed, if it's not in Bugzilla then most likely it will never get
fixed.  So please, if you want the developers to take their time to fix
your issue, the least you can do is take a little bit of your own time
to properly report it.

Thanks!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   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] First Day of the Week

[Lawrence Joy via gnucash-user]

I lived in Singapore for four years and their first day of the week is Monday. 
There are other other countries that follow this also, I believe Spain is one 
of them.--Regards, Larry
___
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] First Day of the Week

[Fred Bone via gnucash-user]

On 13 August 2019 at 2:57, Adrien Monteleone said:

> Hmm..
> 
> Is there anyone using Windows with a Monday first setup that works
> correctly?

Windows 10, system week-start setting is Monday.

2.6.21:

The calendar in the SX Editor starts the week on Monday. I have no idea 
where it derives the setting, or indeed how to get it to use Sunday if 
that was what I wanted. I have no use for the calendar.

The date-picker in the SX Editor also has Monday as first day. I don't 
much care either way.

The date-picker in account registers is the same (presumably it's the 
same widget).

"Income vs day of week" report starts on Sunday.

=

3.6 Portable (fresh install, no attempt to  set any options):

SX Editor calendar starts on Sunday.

SX Editor date-picker starts on Monday.

Register date-picker starts on Monday.

"Income vs day of week" report starts on Sunday.

=

Happy to supply more detail if wanted.


___
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] Default tab on open

[Colin Law]

Can I just check that you realise you can have multiple tabs open at
once, each showing an account.  So to switch accounts you just need to
click on the tab.

Colin

On Tue, 13 Aug 2019 at 01:04, Rick Mobley  wrote:
>
> Is there a place to set a "default" tab to open up to? I'd like for it to
> open up to my cash account each time, but it seems to open to the last place
> when I closed off the program.
>
>
>
> Rick
>
>
>
>
>
>
>
> ___
> 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] journal entries

[Fred Bone]

On 12 August 2019 at 12:57, Mike or Penny Novack said:

> On 8/12/2019 12:45 PM, Clint Chaplin wrote:
> > This is also similar to NetSuite, which is an on-line double entry
> > bookkeeping service, and where "journal entries" are a special case
> > transaction, even though by definition everything is really a journal
> > entry.
> >
> It is definitely a terminology confusion.
> 
> In the old days, especially with "cash book" accounting*, a "journal
> entry" referred to a transaction that was not affecting any of the cash
> accounts. So mainly corrections and adjustments (example: recording
> depreciation).
> 
> It has no real meaning in a "virtual journal" system like gnucash.

Indeed. But what is the meaning in the systems being referred to in this 
thread? The matter will undoubtedly arise again.

___
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] Selective Export of Transactions omitting sub-accounts

[Michael Hendry]

> On 13 Aug 2019, at 09:36, Michael Hendry  wrote:
> 
>> On 13 Aug 2019, at 08:48, Adrien Monteleone  
>> wrote:
>> 
>> I have a somewhat detailed asset tree, but I did a test on a subset of it.
>> 
>> I have the following:
>> 
>> Assets:Current Assets:Currency
>> 
>> And under that I have:
>> 
>> Cash in Wallet
>> Coin Jar
>> Envelopes
>> 
>> The latter was for an experiment trying to shoehorn the envelope method into 
>> GnuCash. (nutshell - it doesn’t really work without lots of effort)
>> 
>> ‘Coin Jar’ has some sub-accounts and one of them has more subs.
>> 
>> I planned to do two exports as a test:
>> 
>> 1 - Cash in Wallet & Coin Jar including all sub accounts
>> 2 - Envelopes
>> 
>> This should fulfill the criteria since these are at least 4 levels down in 
>> the Asset tree. If one or both fails, but an export of the entire Asset tree 
>> works, then I’d say I’ve reproduced your bug.
>> 
>> I stopped on the first test because I got a CSV with all transactions from 
>> every account in that part of the tree.
>> 
>> Note, each transaction appears only once. So where there are moves between 
>> ‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they 
>> are not duplicated later in the file when the Coin Jar subs are listed. This 
>> makes sense because otherwise a re-import would result in duplicate 
>> transactions.
>> 
>> It just so happens that I had some unique transactions in each and every 
>> sub-account that didn’t involve any of the others so every account was 
>> represented.
>> 
>> It is possible that in your case, duplicates would have resulted, so that is 
>> why you only saw the one account.
>> 
>> Or else in your case, you found a bug that I can’t reproduce.
>> 
>> Regards,
>> Adrien
> 
> Thanks, Adrien,
> 
> With your help, I’ve now completed the transfer of these accounts, so my 
> earlier setup has been superseded.
> 
> I suspect you may be right, in that not all (and perhaps none) of these 
> sub-accounts would have had transactions in them, but I’m fairly sure that 
> there were transactions in the CSV for the sub-accounts when everything in 
> the Liabilities tree was exported, rather than the selective export of a 
> branch.
> 
> I’ll have to go to a backup from yesterday and experiment with it to see if 
> that’s what’s been going on. Maybe later...
> 
> Regards,
> 
> Michael

Have done the above, and confirmed that you were right. I had set up the sub 
accounts for later use, but hadn’t put any dummy transactions into them, so 
there were no transactions for export!

I had previously used the "Export to CSV —> Edit CSV —> Import" cycle to 
duplicate sub-accounts, which works OK because transactions aren’t required in 
that context.

Humiliating spurious bug-report avoided!

Regards,

Michael
___
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] First Day of the Week

[Michael Hendry]

> On 13 Aug 2019, at 09:13, Adrien Monteleone  
> wrote:
> 
> I spoke too soon.
> 
> It turns out that GIMP has a date picker when editing meta data.
> 
> It also does not honor the first day of week setting in MacOS preferences.
> 
> So this is a problem with GTK, not just GnuCash.
> 
> The question is then, can a proper locale file be stored by the user to 
> override the default that will be seen and honored by GTK?
> 
> After that, the question would be “Why are there so many locale files in 
> GnuCash.app but only a few are selectable from within GnuCash and then 
> apparently the obvious ones don’t have first_weekday set to ‘2’?"
> 
> Regards,
> Adrien
> 
>> On Aug 13, 2019, at 3:04 AM, Adrien Monteleone 
>>  wrote:
>> 
>> But I don’t think GnuCash is doing that. (telling the widget to draw a 
>> calendar with first_weekday set to ‘Monday’) It is calling GtkCalendar() and 
>> that widget doesn’t have a setting for defining the first day. Now, since it 
>> seems to work on Ubuntu as another user reported, maybe the widget is 
>> looking at the system locale, but something on MacOS is preventing that. (or 
>> it isn’t even aware of the locale since it might have its own default)
>> 
>> This is where I was headed when I tried to copy this custom locale file to 
>> my user profile’s gtk-3.0 folder.
>> 
>> However, I see now that GnuCash.app has a locale folder but the files there 
>> seem to be encoded somehow and not plain text. I’ll have to check the 
>> sources out to see what is really there. It could be those locale files are 
>> not set to have first_weekday be ‘2’ and they are taking precedence.
>> 
>> And yes, testing a different GTK app on a Mac would shed some light on if it 
>> is possible. Unfortunately, I don’t think my other GTK apps have date 
>> pickers or calendar widgets in use. Maybe someone else has such an app to 
>> try.
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 12, 2019, at 10:01 PM, John Morris  wrote:
>>> 
>>> Hi Frank,
>>> Thank you for thinking about my little problem.
>>> 
>>> I don't understand why we would assume this is a bug in GTK. If GnuCash 
>>> tells GTK to create a calendar with Sundays as the first day of the week, 
>>> it should obey. The problem is that some code is not looking at the locale 
>>> setting on my computer. Since this is a completely new test build, I think 
>>> I can rule out a corrupted operating system. Also, other date-aware 
>>> applications are correctly picking the first day of the week.
>>> 
>>> I guess a real test would be to find some other application that uses GTK 
>>> to display calendars and see if it picks the correct first day of the week 
>>> on my system. I'm not aware of any I could try.
>>> 
>>> Best,
>>> John
> 

When I bring up the date-picker on GC 3.6 on my Mac OS X High Sierra, I get a 
calendar widget with Monday as the first day of the week.

This is my preference, but I’m not sure if I ever set it up as such, other than 
selecting UK in my locale options on the Mac.

Looking at the Mac Calendar App’s preferences, I see that that is set up as 
Monday-first.

In System Preferences —> Language & Region, I also have “First day of week: 
Monday”.

Gnucash —> Preferences doesn’t appear to have a first-day setting, but it picks 
up the correct date format from Locale.

HTH

Michael
___
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] Plot Size on Piechart reports

[David T. via gnucash-user]

I'm pretty sure that this code isn't making sizing decisions based on 
readability-- at least not in my experience.  It is perfectly happy to cram 
huge amounts of data into tiny on screen areas... Percentages default to 100%, 
but remember previously stored values. 

 
 
  On Tue, Aug 13, 2019 at 13:24, Adrien 
Monteleone wrote:   I could see how more actual 
slices (regardless of how many accounts were chosen) would maybe trigger a 
larger size than a really small one specified for readability. But still, that 
should be only a default behavior and should not override a specified size.

I think yes, the percentage is based on the width of the ‘printable’ area of 
the report. (and it looks like the default is 100% or else it just remembers 
what I used last)

Regards,
Adrien

> On Aug 13, 2019, at 2:45 AM, David T.  wrote:
> 
> I will try using percentages, although why a percentage (based off what? 
> Window dimensions?) would be more reliable is beyond my ability to 
> comprehend. 
> 
> 
> As for number of slices, they all are set to the same value; it's just that 
> the number of matching accounts is limited.  Again, why that would affect 
> overall pie size goes beyond my comprehension. 
> 
> 
> David
> 


___
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] Selective Export of Transactions omitting sub-accounts

[Michael Hendry]

> On 13 Aug 2019, at 08:48, Adrien Monteleone  
> wrote:
> 
> I have a somewhat detailed asset tree, but I did a test on a subset of it.
> 
> I have the following:
> 
> Assets:Current Assets:Currency
> 
> And under that I have:
> 
> Cash in Wallet
> Coin Jar
> Envelopes
> 
> The latter was for an experiment trying to shoehorn the envelope method into 
> GnuCash. (nutshell - it doesn’t really work without lots of effort)
> 
> ‘Coin Jar’ has some sub-accounts and one of them has more subs.
> 
> I planned to do two exports as a test:
> 
> 1 - Cash in Wallet & Coin Jar including all sub accounts
> 2 - Envelopes
> 
> This should fulfill the criteria since these are at least 4 levels down in 
> the Asset tree. If one or both fails, but an export of the entire Asset tree 
> works, then I’d say I’ve reproduced your bug.
> 
> I stopped on the first test because I got a CSV with all transactions from 
> every account in that part of the tree.
> 
> Note, each transaction appears only once. So where there are moves between 
> ‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they 
> are not duplicated later in the file when the Coin Jar subs are listed. This 
> makes sense because otherwise a re-import would result in duplicate 
> transactions.
> 
> It just so happens that I had some unique transactions in each and every 
> sub-account that didn’t involve any of the others so every account was 
> represented.
> 
> It is possible that in your case, duplicates would have resulted, so that is 
> why you only saw the one account.
> 
> Or else in your case, you found a bug that I can’t reproduce.
> 
> Regards,
> Adrien

Thanks, Adrien,

With your help, I’ve now completed the transfer of these accounts, so my 
earlier setup has been superseded.

I suspect you may be right, in that not all (and perhaps none) of these 
sub-accounts would have had transactions in them, but I’m fairly sure that 
there were transactions in the CSV for the sub-accounts when everything in the 
Liabilities tree was exported, rather than the selective export of a branch.

I’ll have to go to a backup from yesterday and experiment with it to see if 
that’s what’s been going on. Maybe later...

Regards,

Michael

___
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] Problems moving vertical lines between columns on

[David T. via gnucash-user]

As covered in the note at 
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-running-gnucash.html#basics-register2
 
 
  On Tue, Aug 13, 2019 at 5:40, David Carlson 
wrote:   James,

Keep in mind that in the register view the description column is a special
case that essentially defaults to use all the space that is not explicitly
given to other columns.

This means setting the other widths first, then dragging the right edge of
the description column title box leftward and letting it snap back until
there is no horizontal scrollbar at the bottom.

Of course, this can get awkward for users that run the program on computers
with different display and font settings.  Since those settings are defined
as user settings, different computers normally each keep their own
settings, but if one accesses the program remotely via ssh, for example, it
can still get very interesting.

David Carlson

On Mon, Aug 12, 2019 at 6:15 PM James Fuller  wrote:

>
> Hi Guys,
>
> I'm having a problem figuring out how to move the vertical lines
> defining columns on registers.  I seem to remember that you place a
> mouse cursor on the vertical line, hold down the right mouse button, and
> move left or right to change the width of of the columns.  When I do
> that, the vertical line moves with my mouse. When I let go of the right
> button the line zips back.
>
> I'm using 3.2 Gnucash on a Windows 7 HP desktop.  What am I doing
> wrong?  BTW, I have read the Help Manual until I'm blue in the face and
> can't find it.
>
> Thank you
>
> James Fuller
>
> ___
> 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.
  
___
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] First Day of the Week

[Adrien Monteleone]

I spoke too soon.

It turns out that GIMP has a date picker when editing meta data.

It also does not honor the first day of week setting in MacOS preferences.

So this is a problem with GTK, not just GnuCash.

The question is then, can a proper locale file be stored by the user to 
override the default that will be seen and honored by GTK?

After that, the question would be “Why are there so many locale files in 
GnuCash.app but only a few are selectable from within GnuCash and then 
apparently the obvious ones don’t have first_weekday set to ‘2’?"

Regards,
Adrien

> On Aug 13, 2019, at 3:04 AM, Adrien Monteleone 
>  wrote:
> 
> But I don’t think GnuCash is doing that. (telling the widget to draw a 
> calendar with first_weekday set to ‘Monday’) It is calling GtkCalendar() and 
> that widget doesn’t have a setting for defining the first day. Now, since it 
> seems to work on Ubuntu as another user reported, maybe the widget is looking 
> at the system locale, but something on MacOS is preventing that. (or it isn’t 
> even aware of the locale since it might have its own default)
> 
> This is where I was headed when I tried to copy this custom locale file to my 
> user profile’s gtk-3.0 folder.
> 
> However, I see now that GnuCash.app has a locale folder but the files there 
> seem to be encoded somehow and not plain text. I’ll have to check the sources 
> out to see what is really there. It could be those locale files are not set 
> to have first_weekday be ‘2’ and they are taking precedence.
> 
> And yes, testing a different GTK app on a Mac would shed some light on if it 
> is possible. Unfortunately, I don’t think my other GTK apps have date pickers 
> or calendar widgets in use. Maybe someone else has such an app to try.
> 
> Regards,
> Adrien
> 
>> On Aug 12, 2019, at 10:01 PM, John Morris  wrote:
>> 
>> Hi Frank,
>> Thank you for thinking about my little problem.
>> 
>> I don't understand why we would assume this is a bug in GTK. If GnuCash 
>> tells GTK to create a calendar with Sundays as the first day of the week, it 
>> should obey. The problem is that some code is not looking at the locale 
>> setting on my computer. Since this is a completely new test build, I think I 
>> can rule out a corrupted operating system. Also, other date-aware 
>> applications are correctly picking the first day of the week.
>> 
>> I guess a real test would be to find some other application that uses GTK to 
>> display calendars and see if it picks the correct first day of the week on 
>> my system. I'm not aware of any I could try.
>> 
>> Best,
>> John


___
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] First Day of the Week

[Adrien Monteleone]

But I don’t think GnuCash is doing that. (telling the widget to draw a calendar 
with first_weekday set to ‘Monday’) It is calling GtkCalendar() and that widget 
doesn’t have a setting for defining the first day. Now, since it seems to work 
on Ubuntu as another user reported, maybe the widget is looking at the system 
locale, but something on MacOS is preventing that. (or it isn’t even aware of 
the locale since it might have its own default)

This is where I was headed when I tried to copy this custom locale file to my 
user profile’s gtk-3.0 folder.

However, I see now that GnuCash.app has a locale folder but the files there 
seem to be encoded somehow and not plain text. I’ll have to check the sources 
out to see what is really there. It could be those locale files are not set to 
have first_weekday be ‘2’ and they are taking precedence.

And yes, testing a different GTK app on a Mac would shed some light on if it is 
possible. Unfortunately, I don’t think my other GTK apps have date pickers or 
calendar widgets in use. Maybe someone else has such an app to try.

Regards,
Adrien

> On Aug 12, 2019, at 10:01 PM, John Morris  wrote:
> 
> Hi Frank,
>  Thank you for thinking about my little problem.
> 
>  I don't understand why we would assume this is a bug in GTK. If GnuCash 
> tells GTK to create a calendar with Sundays as the first day of the week, it 
> should obey. The problem is that some code is not looking at the locale 
> setting on my computer. Since this is a completely new test build, I think I 
> can rule out a corrupted operating system. Also, other date-aware 
> applications are correctly picking the first day of the week.
> 
>  I guess a real test would be to find some other application that uses GTK to 
> display calendars and see if it picks the correct first day of the week on my 
> system. I'm not aware of any I could try.
> 
> Best,
> John

___
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] Plot Size on Piechart reports

[Adrien Monteleone]

I could see how more actual slices (regardless of how many accounts were 
chosen) would maybe trigger a larger size than a really small one specified for 
readability. But still, that should be only a default behavior and should not 
override a specified size.

I think yes, the percentage is based on the width of the ‘printable’ area of 
the report. (and it looks like the default is 100% or else it just remembers 
what I used last)

Regards,
Adrien

> On Aug 13, 2019, at 2:45 AM, David T.  wrote:
> 
> I will try using percentages, although why a percentage (based off what? 
> Window dimensions?) would be more reliable is beyond my ability to 
> comprehend. 
> 
> 
> As for number of slices, they all are set to the same value; it's just that 
> the number of matching accounts is limited.  Again, why that would affect 
> overall pie size goes beyond my comprehension. 
> 
> 
> David
> 


___
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] Selective Export of Transactions omitting sub-accounts

[Adrien Monteleone]

I have a somewhat detailed asset tree, but I did a test on a subset of it.

I have the following:

Assets:Current Assets:Currency

And under that I have:

Cash in Wallet
Coin Jar
Envelopes

The latter was for an experiment trying to shoehorn the envelope method into 
GnuCash. (nutshell - it doesn’t really work without lots of effort)

‘Coin Jar’ has some sub-accounts and one of them has more subs.

I planned to do two exports as a test:

1 - Cash in Wallet & Coin Jar including all sub accounts
2 - Envelopes

This should fulfill the criteria since these are at least 4 levels down in the 
Asset tree. If one or both fails, but an export of the entire Asset tree works, 
then I’d say I’ve reproduced your bug.

I stopped on the first test because I got a CSV with all transactions from 
every account in that part of the tree.

Note, each transaction appears only once. So where there are moves between 
‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they 
are not duplicated later in the file when the Coin Jar subs are listed. This 
makes sense because otherwise a re-import would result in duplicate 
transactions.

It just so happens that I had some unique transactions in each and every 
sub-account that didn’t involve any of the others so every account was 
represented.

It is possible that in your case, duplicates would have resulted, so that is 
why you only saw the one account.

Or else in your case, you found a bug that I can’t reproduce.

Regards,
Adrien

> On Aug 13, 2019, at 2:30 AM, Michael Hendry  wrote:
> 
>> On 13 Aug 2019, at 08:07, Adrien Monteleone  
>> wrote:
>> 
>> Sorry, I forgot to include that in order to see the Income option for type, 
>> you need to first choose an Income account as a parent. (or make it another 
>> top level account)
>> 
>> Regards,
>> Adrien
> 
> Thanks, Adrien.
> 
> That solved the problem of switching my accounts around in seconds!
> 
> Can you confirm the issue with selective Exporting of Transactions?
> 
> I’d rather not burden Bugzilla with a non-bug because I misunderstood what 
> was supposed to happen!
> 
> Regards,
> 
> Michael
> 
> 


___
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] Selective Export of Transactions omitting sub-accounts

[Michael Hendry via gnucash-user]

> On 13 Aug 2019, at 08:07, Adrien Monteleone  
> wrote:
> 
> Sorry, I forgot to include that in order to see the Income option for type, 
> you need to first choose an Income account as a parent. (or make it another 
> top level account)
> 
> Regards,
> Adrien

Thanks, Adrien.

That solved the problem of switching my accounts around in seconds!

Can you confirm the issue with selective Exporting of Transactions?

I’d rather not burden Bugzilla with a non-bug because I misunderstood what was 
supposed to happen!

Regards,

Michael

___
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 Report Sign Reverses

[Adrien Monteleone via gnucash-user]

> On Aug 13, 2019, at 12:12 AM, Christopher Lam  
> wrote:
> 
> Maybe I'm being thick here, but it's still not easy. We need to start with 
> the knowledge that *internally* income amounts are negative -- after all they 
> usually balance with positive asset amounts. Also, liability amounts are also 
> internally negative, but no one seems to have a problem with that.

Maybe I’m not understanding something, but...

I don’t see how this is an issue. (Equity is also negative in this case)

Note that they are only stored as negatives to facilitate addition for all 
operations for simplicity. Always keep the accounting equation in mind and 
don’t do something non-sensical with the terms. If you reverse signs before 
calculation, that means you can’t use only addition operations. You’d have to 
change the relevant operations of the calculation to make the equation still 
balance. I haven’t tried to grok this report’s code yet, but I can’t see how 
such an approach would be any fun to work out.

> 
> Second, the Transaction Report historically needs to handle multiple types of 
> grouping and sorting -- not only account-name, but also other-account-name. 
> Running a TR with sort=other-account-name may not be that common, but is 
> still supported.

Good to know. I don’t see any reason to change this.

> 
> Third, we can select both income and expense accounts for reporting. If 
> during a period I earn $100 and spend $80, I expect the grand total to be $20 
> (or -$20) rather than $180. Conversely if we select both asset and liability 
> accounts, we'd expect the grand-total to be a net-worth-type amount.

Again, as long as the sign reversal is done merely for display purposes, this 
shouldn’t be an issue. You’d get a retained earnings/net income result if you 
choose income and expense accounts and you’d get a net-worth result if you 
choose asset and liability. (discounting retained earnings and other equity 
that is) I think that is called the "liquidity ratio" in such a case.


> 
> The TR internally will:
> 1) get all splits from all specified accounts
> 2) sort them accordingly - typically stable-sort by account-name (or 
> other-account-name) and date.
> 3) keep a tally of subtotals, adding split-amounts which are currently 
> negative for income amounts.
> 4) add split details onto table. When the sort-criteria (e.g. account-name) 
> changes between rows, render the subtotals.

5) Reverse the signs of the subtotals and splits when printing them on the 
report according to the preference.

> 
> How to design a subtotal strategy that handles all possibilities as above? Do 
> we want the *split* amounts to be negative for expenses and liability?

You want to follow the preference but not as part of the calculation or that 
can get messy as noted above.

> I don't know. A better strategy can be used as along as it can handle all gnc 
> peculiarities as above. I would hope that the TR can produce a useful output, 
> with subtotals & grand-totals which are consistent irrespective of the global 
> sign-reversing strategy.
> 
> Anyone wishing to try the old strategy, can patch trep-engine.scm as follows:
> (map (lambda (cell)
>(let ((cell-monetary (vector-ref cell 0))
> +(reverse? (and (vector-ref cell 1) reversible-account?))
>  (subtotal? (vector-ref cell 2)))
> -(and subtotal? cell-monetary)))
> +(and subtotal? 
> + (if reverse?
> + (gnc:monetary-neg cell-monetary)
> + cell-monetary
>  cells)))

I guess it is time for me to dive into scheme. But it looks like sign reversal 
is happening before each split is added to the subtotal. That is the problem. 
Am I not reading that correctly?

Regards,
Adrien
___
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] Selective Export of Transactions omitting sub-accounts

[Adrien Monteleone]

Sorry, I forgot to include that in order to see the Income option for type, you 
need to first choose an Income account as a parent. (or make it another top 
level account)

Regards,
Adrien

> On Aug 13, 2019, at 2:06 AM, Adrien Monteleone 
>  wrote:
> 
> Changing the account type to Income first should allow the deletion and 
> re-assignment.
> 
> Since they are both credit type accounts, you are fortunate not to have the 
> debits and credits reversed.
> 
> Regards,
> Adrien
> 
>> On Aug 13, 2019, at 1:42 AM, Michael Hendry  wrote:
>> 
>> I have set up some accounts as Liabilities and want to change them to 
>> Income. This can’t be done by deleting the accounts and transferring the 
>> transactions to another account because only Liability Accounts are offered 
>> as alternative destinations.
>> 
>> I would like to export the transactions to CSV, edit the Liability Account 
>> references to make them refer to Income, and import the resulting CSV.
>> 
>> Let’s say I have the following accounts:
>> 
>> L:A:B
>> L:C:D
>> 
>> I use File—>Export—>Export Transactions to CSV, and select the accounts in 
>> L:A:B (ignoring L:C:D). GC highlights the appropriate accounts in blue and 
>> leaves the unwanted ones.
>> 
>> The resulting CSV file ignores B, including only transactions in L:A, and 
>> not L:A’s sub-accounts.
>> 
>> If I select the whole L tree, the resulting CSV file is complete.
>> 
>> Obviously, I can edit out the unwanted transactions, and then adjust the 
>> destination accounts before I import the result, but I don’t think I should 
>> need to do it this way.
>> 
>> Am I misunderstanding something, or have I uncovered an "undesirable 
>> feature" of the "Export Transactions to CSV" process?
>> 
>> Regards,
>> 
>> Michael


___
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] Selective Export of Transactions omitting sub-accounts

[Michael Hendry]

I have set up some accounts as Liabilities and want to change them to Income. 
This can’t be done by deleting the accounts and transferring the transactions 
to another account because only Liability Accounts are offered as alternative 
destinations.

I would like to export the transactions to CSV, edit the Liability Account 
references to make them refer to Income, and import the resulting CSV.

Let’s say I have the following accounts:

L:A:B
L:C:D

I use File—>Export—>Export Transactions to CSV, and select the accounts in 
L:A:B (ignoring L:C:D). GC highlights the appropriate accounts in blue and 
leaves the unwanted ones.

The resulting CSV file ignores B, including only transactions in L:A, and not 
L:A’s sub-accounts.

If I select the whole L tree, the resulting CSV file is complete.

Obviously, I can edit out the unwanted transactions, and then adjust the 
destination accounts before I import the result, but I don’t think I should 
need to do it this way.

Am I misunderstanding something, or have I uncovered an "undesirable feature" 
of the "Export Transactions to CSV" process?

Regards,

Michael
___
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.