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 syntax is incorrect. All text in white. If you are willing to help me further, John, perhaps we should take this off the mailing list as at the moment the problems are with my inexperience in the Powershell environment, rather than with gnucash itself? Many thanks for your assistance so far and hoping for your continued patience. Samantha On 27 July 2020 20:16 John Ralls < [1]jra...@ceridwen.us> wrote: 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 < [2]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 < [3]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 < [4]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 < [5]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 < [6]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 < [7]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 < [8]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 < [9]jra...@ceridwen.us> wrote: On Jul 24, 2020, at 4:33 AM, Samantha Payn < [10]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 References 1. mailto:jra...@ceridwen.us 2. mailto:saman...@boorertranslations.com 3. mailto:jra...@ceridwen.us 4. mailto:saman...@boorertranslations.com 5. mailto:jra...@ceridwen.us 6. mailto:saman...@boorertranslations.com 7. mailto:jra...@ceridwen.us 8. mailto:saman...@boorertranslations.com 9. mailto:jra...@ceridwen.us 10. mailto:saman...@boorertranslations.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.
