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 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 < [2]cleanoutmys...@gmail.com <mailto: [3]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 < [4]cleanoutmys...@gmail.com >>>> <mailto: [5]cleanoutmys...@gmail.com> >>>> <mailto: [6]cleanoutmys...@gmail.com >>>> <mailto: [7]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 < [8]cleanoutmys...@gmail.com >> <mailto: [9]cleanoutmys...@gmail.com> >> >>>> <mailto: [10]cleanoutmys...@gmail.com <mailto: [11]cleanoutmys...@gmail.com>> >> >>>> <mailto: [12]cleanoutmys...@gmail.com <mailto: [13]cleanoutmys...@gmail.com> >> >>>> <mailto: [14]cleanoutmys...@gmail.com >> <mailto: [15]cleanoutmys...@gmail.com>>>> wrote: References 1. mailto:cleanoutmys...@gmail.com 2. mailto:cleanoutmys...@gmail.com 3. mailto:cleanoutmys...@gmail.com 4. mailto:cleanoutmys...@gmail.com 5. mailto:cleanoutmys...@gmail.com 6. mailto:cleanoutmys...@gmail.com 7. mailto:cleanoutmys...@gmail.com 8. mailto:cleanoutmys...@gmail.com 9. mailto:cleanoutmys...@gmail.com 10. mailto:cleanoutmys...@gmail.com 11. mailto:cleanoutmys...@gmail.com 12. mailto:cleanoutmys...@gmail.com 13. mailto:cleanoutmys...@gmail.com 14. mailto:cleanoutmys...@gmail.com 15. mailto:cleanoutmys...@gmail.com _______________________________________________ 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.
