---------- Forwarded message ---------- From: Steven Anter <ante...@gmail.com> Date: Fri, Mar 23, 2018 at 10:44 PM Subject: Re: Unable to download stock quotes To: Chris Good <goodchri...@gmail.com>
C:\Program Files (x86)\gnucash\bin>echo %PATH% C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\ WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\ WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Skype\Phone\;C:\ Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\ Strawberry\perl\bin;C:\Users\Steven\AppData\Local\Microsoft\WindowsApps; C:\Program Files (x86)\gnucash\bin> C:\Program Files (x86)\gnucash\bin>perl -v This is perl 5, version 26, subversion 1 (v5.26.1) built for MSWin32-x86-multi-thread-64int Copyright 1987-2017, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. On Fri, Mar 23, 2018 at 10:29 PM, Steven Anter <ante...@gmail.com> wrote: > I'm using strawberry perl > > On Fri, Mar 23, 2018 at 10:28 PM, Steven Anter <ante...@gmail.com> wrote: > >> I'm an Administrator >> This is my computer >> I used netplwiz to verify and ran *echo (yahoo_json "CBA.AX >> <http://cba.ax/>") | perl gnc-fq-helper* >> >> On Fri, Mar 23, 2018 at 10:24 PM, Steven Anter <ante...@gmail.com> wrote: >> >>> >>> >>> *when I run: echo (yahoo_json "CBA.AX <http://cba.ax/>") | perl >>> gnc-fq-helper* >>> >>> I now get this >>> >>> >>> (("CBA.AX" (symbol . "CBA.AX") (gnc:time-no-zone . "2018-03-22 >>> 12:00:00") (last . 72.81) (currency . "AUD"))) >>> >>> On Fri, Mar 23, 2018 at 10:15 PM, Steven Anter <ante...@gmail.com> >>> wrote: >>> >>>> I used the cpan command >>>> >>>> >>>> On Fri, Mar 23, 2018, 9:41 PM Chris Good <goodchri...@gmail.com> wrote: >>>> >>>>> Hi Steven, >>>>> >>>>> >>>>> >>>>> Do you mean you used the cpan command to find the version of >>>>> Finance::Quote >>>>> >>>>> or you logged in as a user that does have administrative privileges? >>>>> >>>>> >>>>> >>>>> Please answer all the questions I ask, and tell me exactly what you >>>>> have done, to speed up a resolution. >>>>> >>>>> >>>>> >>>>> Reinstalling may help but if you don’t have administrative privileges, >>>>> it may cause more issues. >>>>> >>>>> >>>>> >>>>> We should try a few other things before reinstalling GnuCash. >>>>> >>>>> >>>>> >>>>> Re the “access denied” error from *perl gnc-fq-check:* >>>>> >>>>> What happens when you try running >>>>> >>>>> *cd \Program Files (x86)\gnucash\bin* >>>>> >>>>> *echo (yahoo_json "CBA.AX <http://CBA.AX>") | perl gnc-fq-helper* >>>>> >>>>> from an administrative command prompt? >>>>> >>>>> >>>>> >>>>> What is your login name? >>>>> >>>>> Are you an administrator? >>>>> >>>>> >>>>> >>>>> In File Explorer, right click on C:\Program Files >>>>> (x86)\gnucash\bin\gnc-fq-check, >>>>> >>>>> Properties, Security Tab. >>>>> >>>>> Click on each of the entries in ‘Group or user names’. >>>>> >>>>> Under Permissions for Users, for each, it should show at least “Read & >>>>> Execute” & “Read” is allowed, as follows: >>>>> >>>>> >>>>> >>>>> Note my pc name is goodi7. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Are you using strawberry perl or ActiveState perl? >>>>> >>>>> If you are using strawberry perl, which you should be, you should see >>>>> only that in >>>>> >>>>> Start, Settings, Apps, not ActiveState. >>>>> >>>>> >>>>> >>>>> Please paste in the response from running the following in a command >>>>> prompt (NOT administrative): >>>>> >>>>> *echo %PATH%* >>>>> >>>>> *perl -v* >>>>> >>>>> >>>>> >>>>> If you are a programmer , you can debug the problem using: >>>>> >>>>> *cd \Program Files (x86)\gnucash\bin* >>>>> >>>>> *echo (yahoo_json "CBA.AX <http://CBA.AX>") | perl -d gnc-fq-helper* >>>>> >>>>> If you open in WordPad: >>>>> >>>>> *C:\strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm* >>>>> >>>>> And change the Page Setup to landscape, do you see the following lines >>>>> which are only in my fixed YahooJSON.pm: >>>>> >>>>> >>>>> >>>>> # MS Windows strftime() does not support %T so use %H:%M:%S >>>>> >>>>> # instead. >>>>> >>>>> $my_date = >>>>> >>>>> localtime($json_timestamp)->strftime('%d.%m.%Y >>>>> %H:%M:%S'); >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Regards, Chris Good >>>>> >>>>> >>>>> >>>>> *From:* Steven Anter <ante...@gmail.com> >>>>> *Sent:* Saturday, 24 March 2018 1:45 PM >>>>> *To:* Chris Good <goodchri...@gmail.com> >>>>> *Subject:* Re: Unable to download stock quotes >>>>> >>>>> >>>>> >>>>> Chris, >>>>> >>>>> >>>>> >>>>> I followed your instructions. I have 1.47. Perhaps I should >>>>> uninstall and then reinstall gnucash? >>>>> >>>>> >>>>> >>>>> >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> >>>>> >>>>> Virus-free. www.avast.com >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> >>>>> >>>>> >>>>> >>>>> On Wed, Mar 21, 2018 at 10:18 PM, Chris Good <goodchri...@gmail.com> >>>>> wrote: >>>>> >>>>> Hi Steven, >>>>> >>>>> >>>>> >>>>> Well that’s strange. >>>>> >>>>> Was Gnucash perhaps installed when signed on as another user? >>>>> >>>>> Try running the echo command from an administrative command prompt. >>>>> >>>>> >>>>> >>>>> If you don’t have administrative privileges, login to Windows as a >>>>> user that does. >>>>> >>>>> >>>>> >>>>> Another way to check the version of Finance::Quote: >>>>> >>>>> From a command prompt (NOT run as administrator): >>>>> >>>>> cpan >>>>> >>>>> m Finance::Quote >>>>> >>>>> quit >>>>> >>>>> >>>>> >>>>> If your Finance::Quote is not 1.47: >>>>> >>>>> cpan >>>>> >>>>> upgrade Finance::Quote >>>>> >>>>> quit >>>>> >>>>> After you upgrade Finance::Quote you will need to reinstall my fixed >>>>> YahooJSON.pm. >>>>> >>>>> >>>>> >>>>> Good luck, Chris Good >>>>> >>>>> >>>>> >>>>> *From:* Steven Anter <ante...@gmail.com> >>>>> *Sent:* Wednesday, 21 March 2018 4:49 PM >>>>> >>>>> >>>>> *To:* Chris Good <goodchri...@gmail.com> >>>>> *Subject:* Re: Unable to download stock quotes >>>>> >>>>> >>>>> >>>>> Chris, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> When I try to execute this: >>>>> >>>>> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check* >>>>> >>>>> >>>>> >>>>> I get >>>>> >>>>> Access Denied >>>>> >>>>> >>>>> >>>>> >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> >>>>> >>>>> Virus-free. www.avast.com >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> >>>>> >>>>> >>>>> >>>>> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good <goodchri...@gmail.com> >>>>> wrote: >>>>> >>>>> Hi Steve, >>>>> >>>>> >>>>> >>>>> Hmm.. works for me. >>>>> >>>>> What version of Finance::Quote do you have: >>>>> >>>>> >>>>> >>>>> Do >>>>> >>>>> >>>>> >>>>> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check* >>>>> >>>>> >>>>> >>>>> Response should be: >>>>> >>>>> ("*1.47*" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" >>>>> "asia" "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" >>>>> "brasil" >>>>> "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" >>>>> "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" >>>>> "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" >>>>> "finland" >>>>> "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" >>>>> "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" >>>>> "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" >>>>> "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" >>>>> "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" >>>>> "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" >>>>> "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" >>>>> "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" >>>>> "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" >>>>> "za_unittrusts") >>>>> >>>>> >>>>> >>>>> You should have version 1.47 at the start of the response. This is the >>>>> latest. >>>>> >>>>> >>>>> >>>>> Regards, >>>>> >>>>> >>>>> >>>>> Chris Good >>>>> >>>>> >>>>> >>>>> *From:* Steven Anter <ante...@gmail.com> >>>>> *Sent:* Wednesday, 21 March 2018 4:29 PM >>>>> *To:* Chris Good <goodchri...@gmail.com> >>>>> *Subject:* Re: Unable to download stock quotes >>>>> >>>>> >>>>> >>>>> Chris, >>>>> >>>>> I ran this in the command prompt >>>>> >>>>> >>>>> >>>>> *C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CBA.AX >>>>> <http://CBA.AX>") | perl gnc-fq-helper* >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> This is all that returned: >>>>> >>>>> *(#f)* >>>>> >>>>> >>>>> >>>>> >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> >>>>> >>>>> Virus-free. www.avast.com >>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> >>>>> >>>>> >>>>> >>>>> On Tue, Mar 20, 2018 at 10:08 PM, Chris Good <goodchri...@gmail.com> >>>>> wrote: >>>>> >>>>> Hi Steven, >>>>> >>>>> >>>>> >>>>> Instructions are in the nabble link. GnuCash does not have to be >>>>> running. >>>>> >>>>> >>>>> >>>>> Regards, >>>>> >>>>> >>>>> >>>>> Chris Good >>>>> >>>>> Mobile 0484 001 392 >>>>> >>>>> >>>>> >>>>> *From:* Steven Anter <ante...@gmail.com> >>>>> *Sent:* Wednesday, 21 March 2018 4:06 PM >>>>> *To:* Chris Good <goodchri...@gmail.com> >>>>> *Subject:* RE: Unable to download stock quotes >>>>> >>>>> >>>>> >>>>> Chris, >>>>> >>>>> I know how to run a command from the prompt. >>>>> >>>>> But what's the command? >>>>> >>>>> Can I run it from any directory? >>>>> >>>>> Does gnucash have to be running? >>>>> >>>>> >>>>> >>>>> On Mar 20, 2018 10:02 PM, "Chris Good" <goodchri...@gmail.com> wrote: >>>>> >>>>> Hi Steven, >>>>> >>>>> >>>>> >>>>> Type into Google: how to run a command prompt >>>>> >>>>> >>>>> >>>>> Sorry to seem unhelpful but the GnuCash Users email list is not the >>>>> place to teach basic computer usage. >>>>> >>>>> Google is your friend.. or perhaps you have a friend who is computer >>>>> savvy? >>>>> >>>>> >>>>> >>>>> Regards, Chris Good >>>>> >>>>> >>>>> >>>>> *From:* Steven Anter <ante...@gmail.com> >>>>> *Sent:* Wednesday, 21 March 2018 3:43 PM >>>>> *To:* Chris Good <goodchri...@gmail.com> >>>>> *Cc:* gnucash-user@gnucash.org >>>>> *Subject:* RE: Unable to download stock quotes >>>>> >>>>> >>>>> >>>>> How do I run the test from command prompt >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>> >> > _______________________________________________ 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.