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<TAB> and the shell will change it to cd 'C:\Program Files\' You can then backspace out the \', type a space and <TAB> again and it will fill in the (x86)\' for you.
Regards, John Ralls > On Jul 27, 2020, at 12:01 PM, Samantha Payn <saman...@boorertranslations.com> > wrote: > > 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, verify that the > path is correct and try again. > At line:1 char:22 > + cd C:\Program Files (x86)\gnucash\bin > + ~~~ > + CategoryInfo : ObjectNotFound: (x86:String) [], CommandNotFoundException > + FullyQualifiedErrorId : CommandNotFoundException > > So sorry. Instead of bothering you guys should I try to get local help? > Best wishes and thanks again > Samantha >> On 27 July 2020 19:30 John Ralls < jra...@ceridwen.us> wrote: >> >> >> Samantha, >> >> Sorry I wasn't more explicit: Yes, each command is a line on its own, >> followed by <Return>. 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)\gnucash\bin\gnc-fq-dump currency' USD GBP >> >> The Powershell terminal color-codes errors in red on black, variables and >> special values (e.g. $true, $false) in green, and command names in yellow. >> >> Regards, >> John Ralls >> >>> On Jul 27, 2020, at 2:30 AM, Samantha Payn < >>> saman...@boorertranslations.com> wrote: >>> >>> 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 in red type as follows: >>> [my API key] : The term '[my API key]' 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, verify >>> that the path is correct and try again. >>> At line:1 char:29 >>> + $Env:ALPHAVANTAGE_API_KEY = [my API key] >>> + ~~~~~~~~~~~~~~~ >>> + CategoryInfo : ObjectNotFound: ([my API key]:String) [], >>> CommandNotFoundException >>> + FullyQualifiedErrorId : CommandNotFoundException >>> >>> (In the text above I have switched out my 16 digit API key for the words >>> "[my API key]"). >>> >>> Please also explain what the significance of green and yellow text is in >>> this environment. >>> Many thanks >>> Samantha >>> >>> >>>> On 25 July 2020 20:04 John Ralls < jra...@ceridwen.us> wrote: >>>> >>>> >>>> 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. I don't >>>> think that there is a Poweshell, please excuse my hasty typing. >>>> >>>> Since you use only those 3 currencies try all three combinations, i.e. >>>> USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>> >>>>> On Jul 25, 2020, at 10:27 AM, Samantha Payn < >>>>> saman...@boorertranslations.com> wrote: >>>>> >>>>> 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)? >>>>> Finally, in response to your question I have no securities in my Gnucash >>>>> accounts. I am a freelance translator with a home currency of GBP and >>>>> clients who pay me (and a very occasional purchase) in EUR and USD and >>>>> use Gnucash for my business accounts. These are the currency rates I am >>>>> trying to access. >>>>> Best wishes >>>>> Samantha >>>>>> On 25 July 2020 17:12 John Ralls < jra...@ceridwen.us> wrote: >>>>>> >>>>>> >>>>>> 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 ALPHAVANTAGE_API_KEY in the environment: >>>>>> CMD >>>>>> set ALPHAVANTAGE_API_KEY xxx... >>>>>> Poweshell >>>>>> $Env:ALPHAVANTAGE_API_KEY = xxx... >>>>>> >>>>>> Now test that you can retrieve an arbitrary currency pair: >>>>>> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP >>>>>> >>>>>> If that works then Finance::Quote is working correctly and something >>>>>> else is going on. So far you've mentioned only currency rates, but the >>>>>> usual reason for a system error message from online price retrieval is >>>>>> trying to get a stock price from one of the dicontinued Yahoo! price >>>>>> sources. Do you have any securities in your book? If you're unsure use >>>>>> Tools>Security Editor to show a list of them. >>>>>> >>>>>> Regards, >>>>>> John Ralls >>>>>> >>>>>> >>>>>>> On Jul 25, 2020, at 5:22 AM, Samantha Payn < >>>>>>> saman...@boorertranslations.com> wrote: >>>>>>> >>>>>>> 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 error >>>>>>> window that says: "There was a system error while retrieving the price >>>>>>> quotes". >>>>>>> I have tried restarting my computer to see if that helps but it made no >>>>>>> difference. >>>>>>> The last two lines of the installing text in the CPAN window, before >>>>>>> the cpan prompt reappeared were *slightly* different to what you showed >>>>>>> in your email. As far as I can recall they said: >>>>>>> Appending installation info to C:\strawberry\perl\lib/perllocal.pod >>>>>>> ECOCODE/Finance-Quote-1.49.tar.gz >>>>>>> C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK >>>>>>> Can you please give me guidance on what to do now? >>>>>>> Very many thanks! >>>>>>> Samantha >>>>>>> >>>>>>>> On 24 July 2020 21:12 John Ralls < jra...@ceridwen.us> wrote: >>>>>>>> >>>>>>>> >>>>>>>>> On Jul 24, 2020, at 4:33 AM, Samantha Payn < >>>>>>>>> saman...@boorertranslations.com> 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 cannot "see" it and I am not sufficiently computer literate to >>>>>>>>> correct this. >>>>>>>>> My problem is that when I go to post an invoice in a "foreign" >>>>>>>>> currency >>>>>>>>> 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 upgraded my >>>>>>>>> hardware. >>>>>>>>> After installing the current version of gnucash on my new PC, I >>>>>>>>> clicked >>>>>>>>> on "Install Online Price Retrieval" from the Gnucash list in my start >>>>>>>>> menu and I have entered the Alfa Vantage API key in my gnucash >>>>>>>>> preferences. >>>>>>>>> I have checked for the presence of the perl software using the >>>>>>>>> Troubleshooting method John Ralls directed me to and received the >>>>>>>>> response that I should install the Finance::Quote. The only way I have >>>>>>>>> done this in the past is by clicking on "Install Online Price >>>>>>>>> Retrieval" from the Gnucash list in my start menu and this is what I >>>>>>>>> have done. So I have done this again and after a run of code in the >>>>>>>>> cmd >>>>>>>>> window the final lines are: >>>>>>>>> "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - >>>>>>>>> examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump >>>>>>>>> SBECK/Date-Manip-6.82.tar.gz >>>>>>>>> C:\STRAWB~1\c\bin\gmake.exe - -OK >>>>>>>>> Does this mean that online price retrieval has been installed? >>>>>>>>> When I look in the Windows list of apps installed it says I have >>>>>>>>> installed Strawberry Perl on 3rd July (when I first tried installing >>>>>>>>> it >>>>>>>>> on my new PC). >>>>>>>>> I am running the latest version of Gnucash and I find that in the help >>>>>>>>> window it says >>>>>>>>> "Version: 4.0 >>>>>>>>> Build ID: 4.0+(2020-06-27) >>>>>>>>> Finance::Quote: -" >>>>>>>>> Please let me know what other information you need in order to be able >>>>>>>>> to help me. I am stepping way out of my comfort zone when I enter the >>>>>>>>> cmd window but willing to give it a go. >>>>>>>> It looks like Finance::Quote is not getting installed. Try this: >>>>>>>> >>>>>>>> Find the Strawberry Perl group in the Start menu (windows logo at the >>>>>>>> bottom left of the screen). Open it and start CPAN Client. You'll get >>>>>>>> something that looks sort of like a CMD window. At the prompt there >>>>>>>> type >>>>>>>> install Finance::Quote >>>>>>>> It will probably take a while and should eventually finish with >>>>>>>> Appending installation info to C:\strawberry\perl\lib/perllocal.pod >>>>>>>> ECOCODE/Finance-Quote-1.49.tar.gz >>>>>>>> C:\strawberry\c\bin\dmake.exe install UNINST=1 -- OK >>>>>>>> >>>>>>>> If GnuCash is running restart it, after which it should report version >>>>>>>> 1.49 for Finance::Quote and light up the Get Quotes button. >>>>>>>> >>>>>>>> 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.
