Re: [GNC] Two versions, same computer
On 3/22/2023 4:56 PM, R Losey wrote: It may not just be a matter of separate directories... an install program may put things (like DLLs for MS Windows) in some common directories. This is not the place for this sort of techie stuff except to point out that this sort of expertise/experience is exactly what I was talking about. How to check where the installer put them << ans - in the same directory where it put the run exec >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GNC 4.904 Online price source pick list greyed
I am testing GNC 4.904 and FC 1.54 on Windows 10.0.19 When i edit and check security editor and check the sources, all of them are greyed out. i checked the price install which looks fine and all the folders and files are available under C:\Strawberry\perl\site\lib\Finance not sure it is only for me. Saludos Cordiales Murugan ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote problem MacOS High Sierra.
Bruce,
Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land in
the autoload call.
Regards,
John Ralls
> On Mar 21, 2023, at 6:30 PM, Bruce Schuck wrote:
>
> Please trying installing Module::Load::Conditional from CPAN. It will also
> install Module::Load. If that still does not work, also install modules
> SelfLoader and AutoLoader.
>
> I will need to these to the package dependencies.
>
> - Bruce S.
>
> On 3/21/23 4:05 PM, John Ralls wrote:
>> It works for me on macOS 11 and later and fails on 10.14 and earlier;
>> Murugan reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that
>> they're using 10.15, so I guess that's the cutoff. I don't have a 10.15
>> machine or VM to test on.
>> It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier
>> so it's something in Finance::Quote. I've been salting that with print
>> statements to try to figure out what's going on and it seems to be failing
>> to load the AlphaVantage currency module at Quote.pm line 421: A print
>> before that line prints and one immediately after doesn't. At line 805
>> `$this->{currency_rate_method}` is empty so no attempt to get quotes is made.
>> It seems strange that this would have come up now. Could it be that nobody
>> has tried this on an older Mac in a long time?
>> Regards,
>> John Ralls
>>> On Mar 21, 2023, at 3:27 PM, David H wrote:
>>>
>>> Murugan,
>>>
>>> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
>>>
>>> Cheers David H.
>>>
>>>
>>> On Wed, 22 Mar 2023 at 05:49, David H wrote:
>>> Murugan,
>>>
>>> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my
>>> Intel MacBook Pro was OK - will double check later and confirm whether that
>>> is the case. Also the same command works on Win 11 when formatted
>>> correctly :-) None of the tests I ran required a valid AlphaVantage api
>>> key, a single x was all that was required.
>>>
>>> ALPHAVANTAGE_API_KEY=
>>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>>> EUR->USD = 1.0766
>>>
>>>
>>> ALPHAVANTAGE_API_KEY=x
>>> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
>>> currency EUR USD
>>> 1 EUR = 1.07678 USD
>>>
>>> Cheers David H.
>>>
>>>
>>> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam
>>> wrote:
>>> I fired up my old macbook pro and installed the Finance quote 1.54
>>>
>>>
>>> 1. i go the same issue of 1 EUR = USD gnc-fq-dump currency EUR
>>> USD
>>> 2. Since i run on windows i tried the same command in Windows and it
>>> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows,
>>> i have been using it for years and it works for me)
>>> 3. I checked using gnc-fq-dump yahoo_json USDEUR=X and got the exact
>>> result
>>> 4. gnc-fq-dump yahoo_json EURUSD=X
>>> Finance::Quote fields Gnucash uses:
>>> symbol: EURUSD=X <=== required
>>> date: 03/21/2023 <=== recommended
>>> currency: USD <=== required
>>> last: 1.0779347<=\
>>>
>>> i checked if alphavantage was able to get me stock quote in Macbook and
>>> voila it worked perfectly
>>>
>>> gnc-fq-dump alphavantage IBM
>>> Finance::Quote fields Gnucash uses:
>>> symbol: IBM <=== required
>>> date: 03/20/2023 <=== recommended
>>> currency: USD <=== required
>>> last: 125.9400 <=\
>>>nav: <=== one of these
>>>
>>>
>>> so looks like the issue is particular to currency rates in mac. I will
>>> raise a bug report
>>>
>>>
>>> Saludos Cordiales
>>>
>>>
>>> Murugan
>>>
>>>
>>> From: gnucash-user
>>> on behalf of
>>> John Ralls
>>> Sent: Tuesday, March 21, 2023 12:52 AM
>>> To: G R Hewitt
>>> Cc: GNU Cash User
>>> Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
>>>
>>> Please remember to copy the list on all replies.
>>>
>>> No, what's expected is what I just got,
>>> 1 EUR = 1.072271 USD
>>> so something is still not right with your F::Q installation.
>>>
>>> You should have a .cpan folder (the . hides it from Finder but you can say
>>> `ls ~/.cpan` on the command line to see if it's there), and so you should
>>> be able to run
>>>
>>> ALPHAVANTAGE_API_KEY=
>>> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
>>>
>>> which should print EUR->USD = 1.072386
>>>
>>> but may say "Urgh! Nothing back\n" instead. Unfortunately I don't think it
>>> will do much for diagnostics beyond that.
>>>
>>> Regards,
>>> John Ralls
>>>
On Mar 20, 2023, at 10:15 AM, G R Hewitt wrote:
Hi John,
Ha ha, you got me there, no I didn't, and should have.
I now get:
1 EUR = USD
Is that what is expected?
Oddly enough, I was being lazy and tried to paste the code over the
highlighted '' and terminal wasn't having it and put
Re: [GNC] Finance Quote problem MacOS High Sierra.
Just to confirm. The modules
Load::Module
Load::Module::Conditional
SelfLoader
AutoLoader
are all installed?
I also found that if one has taken of advantage of using the PERL5LIB
environment to modify the @INC path when installing modules, things can
get wonky if it's unset. Or if it was when installing some modules, but
unset when installing others.
I'm guessing the issue on whatever 10.13 system you have tested is still
a missing module (I was able to reproduce the issue on my Catalina
system, no complaints about missing module but still just died after the
autoload call - autoload is function in Module::Load).
On 3/23/23 1:42 PM, John Ralls wrote:
Bruce,
Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land in
the autoload call.
Regards,
John Ralls
On Mar 21, 2023, at 6:30 PM, Bruce Schuck wrote:
Please trying installing Module::Load::Conditional from CPAN. It will also
install Module::Load. If that still does not work, also install modules
SelfLoader and AutoLoader.
I will need to these to the package dependencies.
- Bruce S.
On 3/21/23 4:05 PM, John Ralls wrote:
It works for me on macOS 11 and later and fails on 10.14 and earlier; Murugan
reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that they're using
10.15, so I guess that's the cutoff. I don't have a 10.15 machine or VM to test
on.
It demonstrates with the Examples/currency_rates.pl I pointed GR at earlier so
it's something in Finance::Quote. I've been salting that with print statements to
try to figure out what's going on and it seems to be failing to load the
AlphaVantage currency module at Quote.pm line 421: A print before that line prints
and one immediately after doesn't. At line 805 `$this->{currency_rate_method}`
is empty so no attempt to get quotes is made.
It seems strange that this would have come up now. Could it be that nobody has
tried this on an older Mac in a long time?
Regards,
John Ralls
On Mar 21, 2023, at 3:27 PM, David H wrote:
Murugan,
Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
Cheers David H.
On Wed, 22 Mar 2023 at 05:49, David H wrote:
Murugan,
I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my Intel
MacBook Pro was OK - will double check later and confirm whether that is the
case. Also the same command works on Win 11 when formatted correctly :-) None
of the tests I ran required a valid AlphaVantage api key, a single x was all
that was required.
ALPHAVANTAGE_API_KEY=
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
EUR->USD = 1.0766
ALPHAVANTAGE_API_KEY=x
/Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
currency EUR USD
1 EUR = 1.07678 USD
Cheers David H.
On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam
wrote:
I fired up my old macbook pro and installed the Finance quote 1.54
1. i go the same issue of 1 EUR = USD gnc-fq-dump currency EUR USD
2. Since i run on windows i tried the same command in Windows and it
brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on windows, i
have been using it for years and it works for me)
3. I checked using gnc-fq-dump yahoo_json USDEUR=X and got the exact
result
4. gnc-fq-dump yahoo_json EURUSD=X
Finance::Quote fields Gnucash uses:
symbol: EURUSD=X <=== required
date: 03/21/2023 <=== recommended
currency: USD <=== required
last: 1.0779347<=\
i checked if alphavantage was able to get me stock quote in Macbook and voila
it worked perfectly
gnc-fq-dump alphavantage IBM
Finance::Quote fields Gnucash uses:
symbol: IBM <=== required
date: 03/20/2023 <=== recommended
currency: USD <=== required
last: 125.9400 <=\
nav: <=== one of these
so looks like the issue is particular to currency rates in mac. I will raise a
bug report
Saludos Cordiales
Murugan
From: gnucash-user on
behalf of John Ralls
Sent: Tuesday, March 21, 2023 12:52 AM
To: G R Hewitt
Cc: GNU Cash User
Subject: Re: [GNC] Finance Quote problem MacOS High Sierra.
Please remember to copy the list on all replies.
No, what's expected is what I just got,
1 EUR = 1.072271 USD
so something is still not right with your F::Q installation.
You should have a .cpan folder (the . hides it from Finder but you can say `ls
~/.cpan` on the command line to see if it's there), and so you should be able
to run
ALPHAVANTAGE_API_KEY=
.cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
which should print EUR->USD = 1.072386
but may say "Urgh! Nothing back\n" instead. Unfortunately I don't think it
will do much for diagnostics beyond that.
Regards,
John Ralls
On Mar 20, 2023, at 10:15 AM, G R Hewitt wrote:
Hi John,
Ha ha, you got me there, no I didn't, and should have.
I now
Re: [GNC] Two versions, same computer
-- On 3/22/2023 4:56 PM, R Losey wrote: >* It may not just be a matter of separate directories... an install *>* program may put things (like DLLs for MS Windows) in some common *>* directories.* That is exactly what PortableApps manages to put apps in self-contained folders. Download links for old GnuCash PortableApp for Windows versions: https://sourceforge.net/projects/portableapps/files/GnuCash%20Portable/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote problem MacOS High Sierra.
Bruce,
Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in
/Library/Perl/Updates/5.18.2. @INC includes both directories and neither
PERLLIB nor PERL5LIB is set.
No doubt something else is missing in 10.13. What's a good way to get perl to
tell me?
Regards,
John Ralls
> On Mar 23, 2023, at 2:18 PM, Bruce Schuck wrote:
>
> Just to confirm. The modules
>
> Load::Module
> Load::Module::Conditional
> SelfLoader
> AutoLoader
>
> are all installed?
>
> I also found that if one has taken of advantage of using the PERL5LIB
> environment to modify the @INC path when installing modules, things can get
> wonky if it's unset. Or if it was when installing some modules, but unset
> when installing others.
>
> I'm guessing the issue on whatever 10.13 system you have tested is still a
> missing module (I was able to reproduce the issue on my Catalina system, no
> complaints about missing module but still just died after the autoload call -
> autoload is function in Module::Load).
>
> On 3/23/23 1:42 PM, John Ralls wrote:
>> Bruce,
>> Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land
>> in the autoload call.
>> Regards,
>> John Ralls
>>> On Mar 21, 2023, at 6:30 PM, Bruce Schuck
>>> wrote:
>>>
>>> Please trying installing Module::Load::Conditional from CPAN. It will also
>>> install Module::Load. If that still does not work, also install modules
>>> SelfLoader and AutoLoader.
>>>
>>> I will need to these to the package dependencies.
>>>
>>> - Bruce S.
>>>
>>> On 3/21/23 4:05 PM, John Ralls wrote:
It works for me on macOS 11 and later and fails on 10.14 and earlier;
Murugan reported on https://bugs.gnucash.org/show_bug.cgi?id=798794 that
they're using 10.15, so I guess that's the cutoff. I don't have a 10.15
machine or VM to test on.
It demonstrates with the Examples/currency_rates.pl I pointed GR at
earlier so it's something in Finance::Quote. I've been salting that with
print statements to try to figure out what's going on and it seems to be
failing to load the AlphaVantage currency module at Quote.pm line 421: A
print before that line prints and one immediately after doesn't. At line
805 `$this->{currency_rate_method}` is empty so no attempt to get quotes
is made.
It seems strange that this would have come up now. Could it be that nobody
has tried this on an older Mac in a long time?
Regards,
John Ralls
> On Mar 21, 2023, at 3:27 PM, David H wrote:
>
> Murugan,
>
> Same popsitive results on macOS Ventura 13.2.1 with F/Q 1.54-0
>
> Cheers David H.
>
>
> On Wed, 22 Mar 2023 at 05:49, David H wrote:
> Murugan,
>
> I'm not seeing any issues on macOS Big Sur version 11.7.4 and I think my
> Intel MacBook Pro was OK - will double check later and confirm whether
> that is the case. Also the same command works on Win 11 when formatted
> correctly :-) None of the tests I ran required a valid AlphaVantage api
> key, a single x was all that was required.
>
> ALPHAVANTAGE_API_KEY=
> .cpan/build/Finance-Quote-1.54-0/Examples/currency-lookup.pl EUR USD
> EUR->USD = 1.0766
>
>
> ALPHAVANTAGE_API_KEY=x
> /Applications/Gnucash/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> currency EUR USD
> 1 EUR = 1.07678 USD
>
> Cheers David H.
>
>
> On Wed, 22 Mar 2023 at 01:18, Murugan Muruganandam
> wrote:
> I fired up my old macbook pro and installed the Finance quote 1.54
>
>
> 1. i go the same issue of 1 EUR = USD gnc-fq-dump currency
> EUR USD
> 2. Since i run on windows i tried the same command in Windows and it
> brought back 1 EUR = 1.0779347 USD. (by the way i saw a comment on
> windows, i have been using it for years and it works for me)
> 3. I checked using gnc-fq-dump yahoo_json USDEUR=X and got the exact
> result
> 4. gnc-fq-dump yahoo_json EURUSD=X
> Finance::Quote fields Gnucash uses:
> symbol: EURUSD=X <=== required
> date: 03/21/2023 <=== recommended
> currency: USD <=== required
> last: 1.0779347<=\
>
> i checked if alphavantage was able to get me stock quote in Macbook and
> voila it worked perfectly
>
> gnc-fq-dump alphavantage IBM
> Finance::Quote fields Gnucash uses:
> symbol: IBM <=== required
> date: 03/20/2023 <=== recommended
> currency: USD <=== required
> last: 125.9400 <=\
>nav: <=== one of these
>
>
> so looks like the issue is particular to currency rates in mac. I will
> raise a bug report
>
>
> Saludos Cordiales
>
>
> Murugan
>
> _
[GNC] Modify Balance Sheet report in 4.13?
I'm setting up a local nonprofit with GnuCash books. It's a bare-bones organization, with no liabilities. When I run a Balance Sheet report in 4.13, there's a final line, "Total for Liability and Equity". Of course that's appropriate in most cases, but in this case it's redundant with the "Total for Equity" line. I've tried the Display options that seem appropriate, but haven't found any that suppress that line. Is there any way I can modify the report to suppress the "Total for Liability and Equity" line? -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Error in "Close Book" help text
In 4.13, the Close Book help text, which is the Close Book section of the installed manual, includes the following text under "How It Works", as the second paragraph under "Necessity": "In fact, closing the books reduces the usefulness of the standard reports because the reports don’t currently understand closing transactions. So from their point of view it simply looks like the net income or expense in each account for a given period was simply zero. " That paragraph doesn't seem to be accurate any more. I closed the books in 4.13 and the ran an income statement for the full year. The account totals were given just as they were before I closed the book. Can whoever is maintaining the book look at deleting that paragraph, please? (And please note: This is the installed manual, not the one on the website. I have GnuCash running in a virtual machine with no Internet.) -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote problem MacOS High Sierra.
On 3/23/23 3:28 PM, John Ralls wrote: Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in /Library/Perl/Updates/5.18.2. @INC includes both directories and neither PERLLIB nor PERL5LIB is set. No doubt something else is missing in 10.13. What's a good way to get perl to tell me? If it were Linux I'd say use "strace" and look at all the different Perl Modules being opened. OSX has dtrace/dstruss but SIP has to be disabled. While I know how to disable it, my MacBook belongs to work and I'd rather not. On the other hand, it *should* be the same modules being utilized regardless of OS. It is baffling that Perl just exits quietly instead of complaining about a missing module. - Bruce S. OpenPGP_0xFBCD3E088F8FA737.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote problem MacOS High Sierra.
On 3/23/23 3:28 PM, John Ralls wrote: Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in /Library/Perl/Updates/5.18.2. @INC includes both directories and neither PERLLIB nor PERL5LIB is set. No doubt something else is missing in 10.13. What's a good way to get perl to tell me? John, What versions of those modules are on the 10.13 OS you have access to? Can you update Module::Load and test again? Thanks. - Bruce S. OpenPGP_0xFBCD3E088F8FA737.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote problem MacOS High Sierra.
On 03/23/23 9:21 PM, Bruce Schuck wrote: What versions of those modules are on the 10.13 OS you have access to? Can you update Module::Load and test again? Perl does have two modules, Devel::Trace and Devel::DumpTrace. I think the output of Devel::Trace may be more useful. "perl -d:Trace /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency EUR USD 2>/tmp/foobar" It creates a fairly large file, over 300k lines on my Catalina system where it is working. Starting on line 246638 I see the call to autoload and subsequent perl lines executed. Just starting it as "perl -d /Applications/..." runs the script in a sort of gdb like environment. But I've always debugged using prints to stdout or Smart::Comments. So if you or whoever is having issues on a High Sierra OS can install install Devel::Trace and provide me the output (I checked mine, my ALPHAVANTAGE API key is not exposed, but double check your output), I can maybe compare. Thanks again. - Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Modify Balance Sheet report in 4.13?
On 3/23/2023 7:01 PM, Stan Brown wrote: I'm setting up a local nonprofit with GnuCash books. It's a bare-bones organization, with no liabilities. When I run a Balance Sheet report in 4.13, there's a final line, "Total for Liability and Equity". Of course that's appropriate in most cases, but in this case it's redundant with the "Total for Equity" line. I've tried the Display options that seem appropriate, but haven't found any that suppress that line. Is there any way I can modify the report to suppress the "Total for Liability and Equity" line? Let me ask you a question. How do you know your little bare-bones non-profit organization will never have a liability? Even with no intent to borrow money, no organizational credit card, etc. Think about these possibilities. a) There is going to be an event. Organization member X is assigned to pick up certain supplies, goes to the stores and does so, paying with their own funds. When they show up at the event with the goods and the receipts, you, the treasurer give then a reimbursement check. How are you entering these transactions? b) There is a major project in the works which will require far more than the organization normally has on hand. A member offers to give a donation specifically for this project << formally restricted; if the project is cancelled, that donation must be returned >> How are you entering this donation? As the Balance Sheet report stands, if you have no liabilities that is clearly shown. Meanwhile, if you really don't want that line to show, export the report form gnucash and edit it before printing. Michael D Novack -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
