Woo hoo!
I couldn't have resolved this without John's groundwork.
Enjoy your day.
Regards
Geoff
=
On 26/08/2020 8:49 pm, Samantha Payn wrote:
HURRAH!
Thank you so much Geoff and John for your patience while I struggled
with this. Geoff seems to have found the solution and I am enormousl
HURRAH!
Thank you so much Geoff and John for your patience while I struggled
with this. Geoff seems to have found the solution and I am enormously
grateful to him, and to John Ralls who supported me in the earlier
phases of this mystery.
I hope not to trouble you again for a ver
Thanks very much for your quick response. I am totally out of my depth
in the CMD window!
On 26 August 2020 11:24 Geoff < [1]cleanoutmys...@gmail.com> wrote:
Hi Samantha
I see nothing wrong there - the SET command does not return any output.
Please try the 3rd command - it sho
Hi Samantha
I see nothing wrong there - the SET command does not return any output.
Please try the 3rd command - it should show you your key:
echo %ALPHAVANTAGE_API_KEY%
Thanks
Geoff
=
On 26/08/2020 8:10 pm, Samantha Payn wrote:
Hi Geoff
Thank you for this.
For some reason I encounter a
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 wrote:
<<< Please excuse me for jumping in late on this thread >>>
>
> On Aug 25, 2020, at 1:42 AM, Geoff 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
Rounding
required
>> >>> when 'never round' specified.
>> >>> * 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding
required
>> >>> when 'never round' specified.
>> >>>
>> >>> It does
e'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
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\
amantha Payn <
saman...@boorertranslations.com
<mailto: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 Pay
esponse of mine from a week ago must have fallen
through the net?
>> Any assistance gratefully received
>> Samantha Payn
>>> ------ Original Message --
>>> From: Samantha Payn < [3]saman...@boorertranslations.com>
>>> To: Joh
Message --
From: Samantha Payn < [3]saman...@boorertranslations.com>
To: John Ralls < [4]jra...@ceridwen.us>
CC: Gnucash Users < [5]gnucash-user@gnucash.org>
Date: 17 August 2020 10:19
Subject: Re: [GNC] Difficulty with online price retrieval
John, tha
uot;)))
Regards,
John Ralls
On Aug 24, 2020, at 3:16 AM, Samantha Payn
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
John Ralls
> On Aug 24, 2020, at 3:16 AM, Samantha Payn
> 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 Mess
John, thank you for your continued patience!
This is what I got:
* 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard
* 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 10:13:32 DEBUG dir-files=(view-column trial-balance
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 o
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 P
Samantha,
OK. Please do it when running GnuCash from Powershell with the --log
gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log.
Regards,
John Ralls
> On Aug 12, 2020, at 6:54 AM, Samantha Payn
> wrote:
>
> John, I am so sorry, I have slightly misled you. It is the "
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 < [1]jra...@ceridwen.us> wrote:
Samantha,
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
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".
Th
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
> wrote:
>
> Hi John
> I did what you suggest and this is what I got:
>
> PS C:\U
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 rpt-subdir=gnucash/reports/standard
* 11:46:06 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.
> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger
> 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 -Pr
Odd that the list isn't properly sorted...
Original Message
From: "Frank H. Ellenberger"
Sent: Mon Aug 10 09:16:42 EDT 2020
To: Samantha Payn
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Difficulty with online price retrieval
Samanta,
Am 10.08.20 u
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 LastW
Hi John
Thank you for your continued support.
This is the path displayed for Strawberry Perl.
PS C:\Users\User> [Environment]::GetEnvironmentVariable('PATH',
'MACHINE')
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32\WindowsPowerShell\v1.0\;C:\Wi
Samantha,
So Finance::Quote is correctly installed. Maybe GnuCash isn't finding perl. Run
the following in Poweshell:
[Environment]::GetEnvironmentVariable('PATH', 'MACHINE')
Make sure that it lists the correct Strawberry Perl path. Those square brackets
around Environment are part of the comma
John, thank you for these corrections. In Powershell they brought
results as below:
PS C:\Users\User> cd "C:\Program Files (x86)\gnucash\bin\"
PS C:\Program Files (x86)\gnucash\bin> $Env:ALPHAVANTAGE_API_KEY = "
APIKEY"
PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program File
Samantha,
Pardon the inlining:
> On Aug 7, 2020, at 6:00 AM, Samantha Payn
> wrote:
>
> John, I appreciate why you wish to keep this on list and so thank you and
> everyone for your patience while I stumble through.
> Sorry but I am such a beginner with CMD and Powershell environment that
>
John, I appreciate why you wish to keep this on list and so thank you
and everyone for your patience while I stumble through.
Sorry but I am such a beginner with CMD and Powershell environment that
initially I took your references to CMD and Powershell as part of the
code I should be
Samantha,
I'd prefer to keep everything on the list. I'm not regularly a Windows user and
someone who is might be able to chime in with more help.
I think you have a CMD shell there rather than a Powershell. Powershell would
color $Env:ALPHAVANTAGE_API_KEY bright green no matter what else you t
Hi John
Sorry for my lengthy silence. I have attempted to follow your
instructions but so far without success.
This is as far as I have got:
C:\Program Files (x86)\gnucash\bin>$Env:ALPHAVANTAGE_API_KEY = "[my
alphavantage key"
The filename, directory name, or volume label sy
Samantha,
Regardless of the shell you must enclose paths with spaces in quotes, e.g.
cd "c:\Program Files (86)\gnucash\bin"
You can use ' instead of " if you like. You can also start typing and use tab
completion, for example type
cd c:\prog
and the shell will change it to
cd 'C:\Program F
Sorry John (and everyone). I can't get it to accept (x86) now:
C:\Users\User> cd C:\Program Files (x86)\gnucash\bin
x86 : The term 'x86' is not recognized as the name of a cmdlet,
function, script file, or operable program.
Check the spelling of the name, or if a path was included,
Samantha,
Sorry I wasn't more explicit: Yes, each command is a line on its own, followed
by . You need to use quotes around your API key, so
$Env:ALPHAVANTAGE_API_KEY = "[my API key]"
I see that I left off the second quote in the perl command line, it should be
perl 'c:\Program Files (x86)\
Hi John
I am sorry to have to come back to you for more support on this and
thanks again for your patience.
After some fumbling (am I right that I should type each line you have
typed followed by the "Enter" key? I really am that much of a newb at
this), I got an error message i
Samantha,
Powershell (Admin) just means Powershell with admin privilege. Starting it will
raise a User Authorization Escalation dialog box asking if you're sure that you
want Powershell to "make changes to your device". You don't need it for this
test, plain Powershell is fine. Yes, Powershell.
John, thank you for your continued support.
Before I try this can I just clarify two points:
I have a choice of Windows Powershell and Windows Powershell (Admin):
which should I choose?
And in the middle of your email I presume you mean "Powershell" (not
Poweshell as typed)?
Samantha,
Next, some command-line testing. You can use CMD if you like, but I find
Powershell to be a bit friendlier and easier to get to: Just right-click in the
Start menu and it's in the middle. Once you have a shell, cd to C:\Program
Files (x86)\gnucash\bin.
First you'll need to set your A
Thank you for your help John.
I have done as you instruct (including restarting Gnucash after the
install) but there is now a different problem.
The Gnucash about info now does show version 1.49 for Finance::Quote
The Get Quotes button does light up, but when I click it I get an e
> On Jul 24, 2020, at 4:33 AM, Samantha Payn
> wrote:
>
> Sorry to repeat myself but can anyone help me or shall I have to rely
> on manual input of foreign exchange rates for the foreseeable future? I
> think that Windows has put the online price retrieval somewhere where
> Gnucash c
Sorry to repeat myself but can anyone help me or shall I have to rely
on manual input of foreign exchange rates for the foreseeable future? I
think that Windows has put the online price retrieval somewhere where
Gnucash cannot "see" it and I am not sufficiently computer literate to
c
Thank you for your response, John, and I am sorry for the long delay
but I have had an avalanche of work to do.
My problem is that when I go to post an invoice the "fetch rate" button
is greyed out so I cannot use the online currency rate retrieval that I
used to be able to before I
Samantha,
Have you tried price retrieval from the command line as explained in
https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Does that work?
You haven't actually told us exactly what doesn't work. Please elaborate.
Note that trading accounts has nothing to do with it, nor do pre
(BST)
From: Samantha Payn < [6]saman...@boorertranslations.com>
To: " [7]gnucash-user@gnucash.org" < [8]gnucash-user@gnucash.org>
Subject: [GNC] Difficulty with online price retrieval
Message-ID: < [9]1218599278.968.1594830289...@privateemail.com>
Content-Type: text/pla
But not for currency rates, which F::Q has hard-coded to use alphavantage. Plus
Alphavantage currency rates seem to still be working:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency USD GBP
1 USD = 0.79411 GBP
Regards,
John Ralls
> On Jul 15, 2020, at 9:44 AM, Eric Coate
A few days ago it was reported that AlphaVantage was no longer serving
price information (something to do with them not having the appropriate
licences apparently). The general advice seems to be use Yahoo as JSON
which works fine for me perhaps it would for you.
Eric
=
I did post this question before but am still having the same problem.
I have successfully used Gnucash for a couple of years for
multicurrency invoice processing using the Strawberry perl plug in (by
clicking on Install online price retrieval in the Gnucash section of
the start menu
49 matches
Mail list logo
