<<< 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.
Thanks
Geoff
=====
<<< Feeel free to tell me to butt out if this isn't helpful >>>
On 25/08/2020 8:04 am, John Ralls wrote:
Samantha,
Sorry, yes, I got busy on other work.
#<eof> means that no quote information made it in to the code that handles the
quotes.
I can't reproduce the problem. Since you revealed your key I even used that,
worked fine:
* 14:34:32 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 14:34:32 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 14:34:57 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Yours>
* 14:34:57 DEBUG <gnc.scm> handling-request: (currency CAD USD)
* 14:35:04 DEBUG <gnc.scm> results: ((CAD (symbol . CAD) (gnc:time-no-zone .
2020-08-24 14:34:58) (last . 15127/20000) (currency . USD)))
* 14:35:04 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 14:35:04 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
It does occur to me the US markets are closed at 10:15 BST, but I suppose that
you also checked with gnc-fq-dump around the same time and that worked OK.
There's one other thing to try in Powershell but it would be odd if gnc-fq-dump
works and this doesn't:
$Env:ALPHAVANTAGE_API_KEY = 'xxx'
'(currency "USD" "GBP")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper
Should produce something like
(("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") (last . #e0.7658)
(currency . "GBP")))
Regards,
John Ralls
On Aug 24, 2020, at 3:16 AM, Samantha Payn <saman...@boorertranslations.com>
wrote:
Dear John and list
I think this response of mine from a week ago must have fallen through the net?
Any assistance gratefully received
Samantha Payn
---------- Original Message ----------
From: Samantha Payn <saman...@boorertranslations.com>
To: John Ralls <jra...@ceridwen.us>
CC: Gnucash Users <gnucash-user@gnucash.org>
Date: 17 August 2020 10:19
Subject: Re: [GNC] Difficulty with online price retrieval
John, thank you for your continued patience!
This is what I got:
* 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/standard
* 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 10:13:32 DEBUG <gnc.scm> dir-files=(view-column trial-balance transaction
taxinvoice register reconcile-report receivables receipt price-scatter portfolio
payables owner-report new-owner-report new-aging net-charts lot-viewer job-report
invoice income-statement income-gst-statement general-ledger general-journal
equity-statement dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast
advanced-portfolio account-summary account-piecharts)
* 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/example
* 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
* 10:13:32 DEBUG <gnc.scm> dir-files=(welcome-to-gnucash sample-graphs
hello-world daily-reports average-balance)
* 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/locale-specific/us
* 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
* 10:13:32 DEBUG <gnc.scm> dir-files=(taxtxf)
* 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/report/stylesheets
* 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
* 10:13:32 DEBUG <gnc.scm> dir-files=(plain head-or-tail footer css)
* 10:13:33 DEBUG <gnc.scm> gnc:fq-check-sources results: (1.49 adig aex aiahk
alphavantage amfiindia asegr asx aufunds australia bamosz bet bmonesbittburns bourso
bse bsero canada canadamutual citywire cominvest cse deka dutch dwsfunds europe
fetch_live_currencies fidelity fidelity_direct fidelityfixed financecanada
finanzpartner finland fool france ftfunds ftportfolios ftportfolios_direct
fundlibrary goldmoney greece hex hu hufund hungary hustock iexcloud indiamutual
known_currencies lerevenu maninv morningstar morningstarau morningstarch
morningstarjp mstaruk nasdaq nyse nz nzx platinum romania seb_funds sixfunds
sixshares stockhousecanada_fund tdefunds tdwaterhouse tiaacref tnetuk troweprice
troweprice_direct trustnet tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds
vanguard vwd yahoo_json yahoo_yql za za_unittrusts)
* 10:13:33 MESSG <gnc.scm> Found Finance::Quote version 1.49
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:31 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Key>
* 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.
* 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
* 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when 'never
round' specified.
On 15 August 2020 19:20 John Ralls < jra...@ceridwen.us> wrote:
Samantha,
Run GnuCash from Powershell as you did before:
& 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug
(The last time the command was & 'C:\Program Files
(x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that last command,
--nofile, tells GnuCash to not open the previous data file. Last time I didn't need
to see anything from a data file and starting GnuCash without one is faster. This
time I do want you to have access to your data file.)
This time edit an exchange rate on an existing multi-currency transaction and
use the Fetch Rate button to attempt to get an online quote. Dismiss the error
dialog, cancel the edit, and quit GnuCash.
Then list the log files
Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.*
| Sort-Object -Property Date
figure out which is the latest one (the guidance about that is still at the
bottom of the quoted text in this message if you've forgotten)
Display the contents
Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
(That's the file name from last time, you'll replace VEQEP0 with whatever is in
the latest file's name.)
And copy and paste them into a reply.
Regards,
John Ralls
On Aug 15, 2020, at 6:42 AM, Samantha Payn < saman...@boorertranslations.com>
wrote:
I am sorry John, do what?
I am afraid I just do not understand "Please run from the PowerShell command line
with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and
paste in the contents of the resulting log file."
I am such a beginner with the Powershell window stuff, all I can do is copy/paste what
you provide. This problem has been so drawn out that we both lost sight of the fact that
I had originally raised the issue over "Fetch Rates" for foreign currency
transactions in my business.
Yours apologetically
Samantha
On 13 August 2020 01:30 John Ralls < jra...@ceridwen.us> wrote:
Samantha,
OK. Please do it when running GnuCash from Powershell with the --log
gnc.scm=debug option and paste in the resulting gnucash.trace.XXXXXX.log.
Regards,
John Ralls
On Aug 12, 2020, at 6:54 AM, Samantha Payn < saman...@boorertranslations.com>
wrote:
John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which
returns the error message. I only use Gnucash for my business accounts and have no need of the
"Get Quotes" button.
On 11 August 2020 18:54 John Ralls < jra...@ceridwen.us> wrote:
Samantha,
Sorry, I lost that in the ensuing conversation about how to work Powershell and
got hung up on the previous no Get Rate button issue.
The Fetch Rate and Get Quotes buttons work a bit differently from each other: The first looks only
at the currencies involved in the transaction you're entering and the latter tries to retrieve
rates for all of the currencies in your book. Can you try the Fetch Rate button? You can do that
most easily by editing the rate on a foreign currency split. (Open a foreign currency transaction,
put it in split view, select a split in the "other" currency, right-click and pick Edit
Exchange Rate from the context menu. Note that which currency is the "other" one depends
on which account you started the transaction from so it might be GBP if you created the transaction
starting from an account denominated in, say, EUR.)
Please run from the PowerShell command line with the --log gnc.scm=debug option
as before, try both a Fetch Rate and a Get Quotes and paste in the contents of
the resulting log file.
Regards,
John Ralls
On Aug 11, 2020, at 5:00 AM, Samantha Payn < saman...@boorertranslations.com>
wrote:
I'm afraid the problem has not been solved.
The Get Quotes button does light up (as I mentioned in an email to the list just after I
first reported the problem), but when I click it I get an error window that says:
"There was a system error while retrieving the price quotes".
Thank you for your persisitance and continued support.
Samantha
On 11 August 2020 00:51 John Ralls < jra...@ceridwen.us> wrote:
Good. It succeeded in finding Finance::Quote from the command line. That should
be sufficient to enable the Fetch Rate button. Was it enabled?
Regards,
John Ralls
On Aug 10, 2020, at 12:06 PM, Samantha Payn < saman...@boorertranslations.com>
wrote:
Hi John
I did what you suggest and this is what I got:
PS C:\Users\User> Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
* 11:46:06 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/standard
* 11:46:06 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 11:46:06 DEBUG <gnc.scm> dir-files=(view-column trial-balance transaction
taxinvoice register reconcile-report receivables receipt price-scatter portfolio
payables owner-report new-owner-report new-aging net-charts lot-viewer job-report
invoice income-statement income-gst-statement general-ledger general-journal
equity-statement dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast
advanced-portfolio account-summary account-piecharts)
* 11:46:07 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/example
* 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
* 11:46:07 DEBUG <gnc.scm> dir-files=(welcome-to-gnucash sample-graphs
hello-world daily-reports average-balance)
* 11:46:07 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/locale-specific/us
* 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
* 11:46:07 DEBUG <gnc.scm> dir-files=(taxtxf)
* 11:46:07 DEBUG <gnc.scm> rpt-subdir=gnucash/report/stylesheets
* 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
* 11:46:07 DEBUG <gnc.scm> dir-files=(plain head-or-tail footer css)
* 11:46:10 DEBUG <gnc.scm> gnc:fq-check-sources results: (1.49 adig aex aiahk
alphavantage amfiindia asegr asx aufunds australia bamosz bet bmonesbittburns bourso
bse bsero canada canadamutual citywire cominvest cse deka dutch dwsfunds europe
fetch_live_currencies fidelity fidelity_direct fidelityfixed financecanada
finanzpartner finland fool france ftfunds ftportfolios ftportfolios_direct
fundlibrary goldmoney greece hex hu hufund hungary hustock iexcloud indiamutual
known_currencies lerevenu maninv morningstar morningstarau morningstarch
morningstarjp mstaruk nasdaq nyse nz nzx platinum romania seb_funds sixfunds
sixshares stockhousecanada_fund tdefunds tdwaterhouse tiaacref tnetuk troweprice
troweprice_direct trustnet tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds
vanguard vwd yahoo_json yahoo_yql za za_unittrusts)
* 11:46:10 MESSG <gnc.scm> Found Finance::Quote version 1.49
PS C:\Users\User>
Cheers
Samantha
On 10 August 2020 16:37 John Ralls < jra...@ceridwen.us> wrote:
On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:
Samanta,
Am 10.08.20 um 12:53 schrieb Samantha Payn:
But you lost me at the next bit.
PS C:\Users\User> Get-ChildItem -Path
$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
Sort-Object -Property Date
Directory: C:\Users\User\AppData\Local\Temp
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a---- 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
-a---- 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
-a---- 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
-a---- 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
-a---- 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
-a---- 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
-a---- 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
-a---- 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
-a---- 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
-a---- 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
-a---- 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
-a---- 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
PS C:\Users\User>
Where do I substitute the most recent file name from my listing? Which
listing?
Awaiting further guidance and thanks again.
Samantha
In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46
Samantha,
Specifically, run
Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
and paste the results into a reply.
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.
_______________________________________________
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.
