[GNC] Difficulty with online price retrieval

[Geoff]

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 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 very long time!
> THANK YOU!
> Samantha
>> On 26 August 2020 11:24 Geoff < cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at 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 < cleanoutmyshed at gmail.com 
>>>> <mailto:cleanoutmyshed at gmail.com>
>>>> <mailto: cleanoutmyshed at gmail.com 
>>>> <mailto:cleanoutmyshed at 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 < cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>
>> >>>> <mailto: cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>>
>> >>>> <mailto: cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>
>> >>>> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at 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 < cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>
>> >> <mailto: cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>>
>> >> >>>> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>>>
>> >> >>>> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>>
>> >> >>>> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>
>> >> <mailto: cleanoutmyshed at gmail.com 
>> <mailto:cleanoutmyshed at gmail.com>>>>> wrote: