[GNC] Difficulty with online price retrieval

[Geoff]

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 <cleanoutmyshed at 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 <cleanoutmyshed at 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
> 
>