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 problem trying to enter my API key at the
CMD prompt. Way (way!) back John gave me two routes to start
investigating the problem and the CMD prompt route didn't work so we
stuck with the Powershell route. At that time I thought it was my
inability to type commands correctly, but I have since been copy/pasting
everything into Powershell, and today into the CMD prompt window.
Please see attachment which shows a different result to the one your
example does.
Samantha
On 26 August 2020 05:39 Geoff < cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>> wrote:
Good morning Samantha
Today's task is to repair your perl installation (specifically the
missing "Date::Manip" module) so that gnucash can use the perl
Finance::Quote module to retrieve currency exchange rates for you.
I have tested this on my Windows 10 PC today by manually deleting the
Date::Manip module then reinstalling it using the steps below. Note
that instead of using Powershell as you have been doing to date, you
will use the DOS Command Shell to enter the necessary commands. Please
refer to the attached screenshots as you proceed.
Screenshot: gnucsh_date_manip_1_command_prompt.jpg
The objective here is to open a DOS Command Shell running with
Administrator privileges. There several ways to do this, the one I have
shown involves typing "cmd" into the search box on the left of the
Windows task bar at the bottom of your screen. A new window will open
titled "Administrator: Command Prompt". Type these 4 commands into that
window - obviously using your own API Key:
cd "C:\Program Files (x86)\gnucash\bin"
set ALPHAVANTAGE_API_KEY=your_actual_key
echo %ALPHAVANTAGE_API_KEY%
install-fq-mods.cmd
Screenshot: gnucsh_date_manip_2_installation.jpg
The gnucash perl installation script is now running and you will see a
heap of gobbledygook on your screen like this.
Screenshot: gnucsh_date_manip_3_long_delay.jpg
After a few minutes the installation will appear to "freeze" at this
point. Just be patient and wait, I have seen it take over 30 minutes in
some cases.
Screenshot: gnucsh_date_manip_4_completion.jpg
This is what it should look like after a successful installation. If
you don't see this, please send details including a screenshot and we
will decide the next steps.
Screenshot: gnucsh_date_manip_5_testing.jpg
Assuming you do have a successful installation, let's test it out by
typing (or pasting) these 3 commands into the window:
echo (currency "GBP" "EUR") | perl gnc-fq-helper
echo (currency "USD" "GBP") | perl gnc-fq-helper
echo (currency "USD" "EUR") | perl gnc-fq-helper
Good luck!
Geoff
=====
On 25/08/2020 10:18 pm, Samantha Payn wrote:
Thanks Geoff! Sleep well!
On 25 August 2020 13:17 Geoff < cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>
<mailto: cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>>> wrote:
>>
>> Ah hah! This could be the cause of all your problems.
>>
>> That error message says that your perl installation is missing a key
>> component - the "Date::Manip" module.
>>
>> Explaining how to fix this will take a bit of effort, and as it is now
>> bedtime in my part of the world, I will try to knock up some
>> instructions for you tomorrow.
>>
>> Stay tuned.
>>
>> Geoff
>> =====
>>
>> On 25/08/2020 9:24 pm, Samantha Payn wrote:
>>> Hi Geoff
>>> Thanks for your suggestoins. This is what I get:
>>> PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = 'mykey'
>>> PS C:\Users\User> echo '(currency "USD" "GBP")' | perl 'c:\Program
Files
>>> (x86)\gnucash\bin\gnc-fq-helper'
>>> Can't locate Date/Manip.pm in @INC (you may need to install the
>>> Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib
>>> C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program
>>> Files (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> BEGIN failed--compilation aborted at c:\Program Files
>>> (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> PS C:\Users\User> echo '(currency "USD" "EUR")' | perl 'c:\Program
Files
>>> (x86)\gnucash\bin\gnc-fq-helper'
>>> Can't locate Date/Manip.pm in @INC (you may need to install the
>>> Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib
>>> C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program
>>> Files (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> BEGIN failed--compilation aborted at c:\Program Files
>>> (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> PS C:\Users\User> echo '(currency "GBP" "EUR")' | perl 'c:\Program
Files
>>> (x86)\gnucash\bin\gnc-fq-helper'
>>> Can't locate Date/Manip.pm in @INC (you may need to install the
>>> Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib
>>> C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program
>>> Files (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> BEGIN failed--compilation aborted at c:\Program Files
>>> (x86)\gnucash\bin\gnc-fq-helper line 29.
>>> PS C:\Users\User>
>>> Thanks for taking up the cudgels on this one.
>>> Samantha
>>>> On 25 August 2020 12:13 Geoff < cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>
>>>> <mailto: cleanoutmys...@gmail.com <mailto:cleanoutmys...@gmail.com>>
>>>> <mailto: cleanoutmys...@gmail.com <mailto:cleanoutmys...@gmail.com>
>>>> <mailto: cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>>>> wrote:
_______________________________________________
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.
