Thanks John, I'll try and get Samantha's perl installation sorted out,
then we will see if she still has a problem with exchange rates.
Geoff
=====
On 26/08/2020 2:33 am, John Ralls wrote:
On Aug 25, 2020, at 1:42 AM, Geoff <cleanoutmys...@gmail.com> wrote:
<<< Please excuse me for jumping in late on this thread >>>
Samantha reported: ""when I click it I get an error window that says: "There was a system
error while retrieving the price quotes".""
Samantha's debug output shows the error message:
* 10:15:31 DEBUG <gnc.scm> handling-request: (currency USD GBP)
* 10:15:31 DEBUG <gnc.scm> results: #<eof>
* 10:15:31 DEBUG <gnc.scm> handling-request: (currency EUR GBP)
* 10:15:31 ERROR <gnc.scm> There was a system error while retrieving the price
quotes.
But *only* when two non-USD currencies are involved - EUR/GBP in this case.
John - when you said you can't reproduce the problem your log only shows
CAD/USD. Have you tried EUR/GBP? I have the same problem as Samantha when I
try this, even though both gnc-fq-dump and gnc-gfq-helper are working OK.
Samantha - would you mind checking in gnucash under "Edit / Preferences /
Accounts" and telling us what your Default Currency setting is please? See attached
screenshot for my settings - DO NOT change yours to mine.
and
On Aug 25, 2020, at 4:13 AM, Geoff <cleanoutmys...@gmail.com> wrote:
Hi Samantha
There were a couple of typos in the powershell command John asked you to run,
which is why there was no output.
Would you mind trying the following 4 powershell command lines please - with
your actual API Key of course - and note the single quote at the end of each
line:
$Env:ALPHAVANTAGE_API_KEY = 'your_actual_key'
echo '(currency "USD" "GBP")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper'
echo '(currency "USD" "EUR")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper'
echo '(currency "GBP" "EUR")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper'
That's interesting, yesterday when I used echo on Powershell it didn't work,
but did without it. This morning it works both ways.
The actual fail was my copy and paste lost the trailing quote mark. The >>
Samantha got was powershell asking for it.
Yes, it works fine with GBP/EUR:
* 09:29:36 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when
'neveround' specified.
* 09:29:38 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<xxx>
* 09:29:38 DEBUG <gnc.scm> handling-request: (currency GBP EUR)
* 09:29:46 DEBUG <gnc.scm> results: ((GBP (symbol . GBP) (gnc:time-no-zone .
20-08-25 09:29:39) (last . 27789/25000) (currency . EUR)))
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.
