Troubleshooting

[John Ralls]

> On Jun 24, 2015, at 12:48 AM, Rene Hasekamp <hasekamp at gmail.com> wrote:
> 
> 
> Op woensdag 24 jun. 2015 om 1:08 AM schreef John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>>:
>> 
>> 
>> > On Jun 22, 2015, at 11:52 PM, Graeme Harris <gfhwalkabout at yahoo.com> wrote:
>> > 
>> > On 6/22/15 7:16 PM, John Ralls wrote:
>> >>> On Jun 22, 2015, at 8:38 PM, Bruno Lima <brunocadelima at me.com> wrote:
>> >>> 
>> >>> Dear Gnucash team - my deepest appreciation on the outstanding software built.
>> >>> 
>> >>> I am using a MacBook Pro, Intel, running OS X Yosemite (10.10.1).
>> >>> 
>> >>> Gnucash is working, but I am unable to have the Real-time quote updated.
>> >>> 
>> >>> Troubleshooting:
>> >>> 
>> >>> (gnc-fq-update) -> updated (1.37).
>> >>> 
>> >>> sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
>> >>> Password:
>> >>> Reading '/Users/BrunoCAdeLima/.cpan/Metadata'
>> >>> Database was generated on Tue, 23 Jun 2015 02:17:02 GMT
>> >>> Finance::Quote is up to date (1.37).
>> >>> 
>> >>> (gnc-fq-dump) -> working, with any symbol.
>> >>> 
>> >>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump nyse V
>> >>> Finance::Quote fields Gnucash uses:
>> >>> symbol: V <=== required
>> >>> date: 06/22/2015 <=== required
>> >>> currency: USD <=== required
>> >>> last: 69.09 <=\
>> >>> nav: <=== one of these
>> >>> price: 69.09 <=/
>> >>> timezone: <=== optional
>> >>> 
>> >>> However, when I click on the Price Editor, and try to get the online quotes, the following message shows up: “There was a system error while retrieving the prices”. (screenshot).
>> >>> 
>> >>> 
>> >>> How this can be fixed? done some search and even re-installed the sudo cpan install HTML::TableExtract
>> >>> 
>> >>> But, no success so far.
>> >> What source do you have configured for Visa in Security Editor? NYSE isn’t one of the choices in the drop-down, you must have picked something else. NB: The source drop-down is below the checkbox which enables online price retrieval. The Type field has nothing to do with price retrieval. FWIW, using Yahoo is the most reliable for stocks listed on the major US exchanges.
>> >> 
>> >> Regards,
>> >> John Ralls
>> >> 
>> >> 
>> > 
>> > I am using a MacBook Pro, Intel, running OS X Yosemite (10.10.3).
>> > 
>> > I am also having the same problem and followed the the same "fix" posted earlier with the same result as Bruno.
>> > 
>> > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump yahoo AAPL
>> > Finance::Quote fields Gnucash uses:
>> > symbol: AAPL <=== required
>> > date: 06/22/2015 <=== required
>> > currency: USD <=== required
>> > last: 127.61 <=\
>> > nav: <=== one of these
>> > price: 127.61 <=/
>> > timezone: <=== optional
>> > 
>> > My Price Editor is displaying the same error message when trying to retrieve prices.
>> > 
>> > Price Editor was working on a similar MacBook Pro, Intel, running OS X Maverick (10.9.5).
>> 
>> If gnc-fq-dump works then the Finance::Quote installation is OK, no fixing required. This seems to be https://bugzilla.gnome.org/show_bug.cgi?id=748459.
>> 
>> Regards,
>> John Ralls
> ​
> Thanks. I read the bug page. What does all this mean to the non-technical Mac user? ​

Probably not much, other than that it stumps the technical users too. If you can run the command in the description from Applications:Utilities:Terminal you can compare the output with what btjones had to confirm that its the same failure. If it isn’t, by all means paste it into the bug report with a “me too, but different trace” comment.

Regards,
John Ralls