Ask Your Question
0

I just updated to 5.2.7. I've been using the extension GETYAHOO.

asked 2017-05-31 22:21:57 +0200

Harwyn gravatar image

I'm now getting the error in the cell where I'm attempting to use GETYAHOO.....unknown url type: https. I've killed the original extension thinking it may have gotten corrupted and reloaded it. Same result. What happened?

edit retag flag offensive close merge delete

Comments

I had the same problem. Searched my system for "yahoo.py" and updated the URL in it to "http://download.finance.yahoo.com/d/q...". Seems to work now.

Thomas T gravatar imageThomas T ( 2017-05-31 23:55:01 +0200 )edit

Tom, please detail the steps involved. I am on the latest Win10 and cannot find yahoo.py on my system. LIbre office version 5.2.7 and SMF version 7.0 same error as OP unknown url type: https. I used this SMF to retrieve about 50 symbols daily and suddenly it went kaput. I have installed and reinstalled LO and Apache OO to no avail.

husky1055 gravatar imagehusky1055 ( 2017-06-01 21:45:52 +0200 )edit

HI tom, please detail the steps involved. I am Win10 last version and LO v 5.2.7 and SMF v 7.0. Cannot find yahoo.py on my system.

husky1055 gravatar imagehusky1055 ( 2017-06-01 21:50:42 +0200 )edit

After many hours I finally fixed the problem. Thank you Thomas for pointing out the direction. Really appreciated it. Who changed the previously working SMF is a mystery for me.

husky1055 gravatar imagehusky1055 ( 2017-06-01 23:35:56 +0200 )edit

I have the same problem. IMHO Yahoo changed something andhe original URL no longer works. One must find the file yahoo.py which going to be somewhere in the hierarchy of where the extension is installed. On a mac, it is down in ~/Library/Application Support. I don't know where it is on a PC. Once you find the file, you need to use a (dumb) text editor to change http://finance.... to http://download.finance. Note that getQuote in OO is also broken. I don't know how to fix getQuote - yet.

dottore gravatar imagedottore ( 2017-06-02 18:11:19 +0200 )edit

husky1055, I'm having this problem also. I located and modified yahoo.py but still see the same behaviour. Can you outline the steps you took to correct this?

Many thanks,

PF gravatar imagePF ( 2017-06-02 18:15:58 +0200 )edit

since =INDIRECT(CONCATENATE("'http://finance.yahoo.com/d/quotes.csv?s=",A4,"&f=l1'#Sheet1.a1")) works perfectly fine with a ticker in the A4 cell, this is not the problem. Something about the python script is out of wack. Its been doing it to me before i updated to 5.x. There is no yahoo.py anywhere in my win10 system other than in the zip containing the source.

The Mac gravatar imageThe Mac ( 2017-06-02 20:02:52 +0200 )edit

On windows 10 I found yahoo.py buried deep in my user directory:

C:\Users\username\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu860428wnkp.tmp_\smf.oxt\yahoo.py

Yahoo is redirecting the old url to "https://finance.yahoo.com/d/quotes.csv", which is where the python script fails (it doesn't seem to be able to handle https). If that redirect had worked they would have been redirected again to "http://download.finance.yahoo.com/d/q...", which python can handle.

Thomas T gravatar imageThomas T ( 2017-06-03 00:10:57 +0200 )edit

Thomas outlined the exact steps needed to fix this issue. Just to be clear, yahoo.py is a folder not a file. the file you needed is smf.oxt. You will then use notepad to edit the url as mentioned above. I have several computers and laptops and want to verified if they all needed to be fixed before posting all the steps. You canot just edit the smf.oxt in your various locations. It has to be in yahoo.py folder as outlined above. Hope it helps somebody.

husky1055 gravatar imagehusky1055 ( 2017-06-03 01:49:47 +0200 )edit

couple of things: 1. yahoo.py is the file to change, not the directory. 2. you may have more than one tmp directory under uno_packages if you've removed and reinstalled the extension multiple times. in the cache directory, view the pmap file to find the correct one (install notepad++ if you get garbage with notepad) 3. do not have LO open. 4. Just add download. to the beginning of the url. the rest stays the same. 5. If you get garbage when opening the file, install notepad++

The Mac gravatar imageThe Mac ( 2017-06-03 02:38:48 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2017-06-01 21:59:08 +0200

husky1055 gravatar image

Mike, the SMF extension was last worked on by Dave Capro who released version 7.0 about 5 or 6 years ago. Dave was not the creator or the originator. There were several people involved. I had the same problem as the OP and was hoping for some help from other users more knowledgeable and skillful than myself.

edit flag offensive delete link more
0

answered 2017-06-01 05:54:37 +0200

The problems with extensions should be reported to those extensions authors. It may be a problem in extension itself (and just happened to work because it relied on something incorrectly); or it might happen that the problem is really in LibreOffice; but only a person familiar with extension code can sort it out and fix it in the extension's code, or work with LO community to get it fixed. Please use extension's home page (or documentation that comes with it) to find ways to contact them.

edit flag offensive delete link more

Comments

Mike, the SMF extension has not been changed and/or updated for years. David Capro was the last person working on it. I have been using this extension for a few years and suddenly have this problem explained exactly by the OP. I have not been able to identify the cause of this problem and am hoping for some help from others users who might have some helpful solution or idea.

husky1055 gravatar imagehusky1055 ( 2017-06-01 21:39:49 +0200 )edit

OK. So I see that you two have found some solution, (btw @husky1055 didn't even shared exact steps for others to benefit) and SMF-Extension's bug tracker wasn't used to file a bug. Thus, whoever might want to jump in and take over/fork, wouldn't even know about such a problem. That's what I'm talking about, and that isn't community-friendly.

Mike Kaganski gravatar imageMike Kaganski ( 2017-06-02 10:14:35 +0200 )edit

Husky1055 could you please detail your solution. Thanks

bob49b gravatar imagebob49b ( 2017-06-02 16:03:42 +0200 )edit

sorry, I'm totally new to LO and to this community. as I posted above, this cause of this problem appears to be a change made by Yahoo (or possibly some DNS issue). All that needs to happen is that SMF.oxt needs to be updated by changing the URL in yahoo.py. (from http://finance... to http://download.finance...)If one of you gurus would be kind enough to file the bug, I would really appreciate it. Yes, I should do it, but this change has already eaten up two days of my time. many thanks!!!!

dottore gravatar imagedottore ( 2017-06-02 18:39:07 +0200 )edit

See my post above!!!

husky1055 gravatar imagehusky1055 ( 2017-06-03 01:50:31 +0200 )edit
0

answered 2017-06-13 21:14:30 +0200

updated 2017-06-21 12:51:24 +0200

erAck gravatar image

Sometime ago, I forked SMF-Extension and added new functions to retrieve historical stock data from Yahoo (see SMF-Extension-Fork). Unfortunately, Yahoo terminated the historical stock data service somewhere around 5/15/2017 and I had to fall back to a lesser Google service that only reliably provides historical closing prices.

Today, I changed the Yahoo URL from finance.yahoo.com to download.finance.yahoo.com. This should fix the problems discussed in this thread. If you are interested in giving the updated extension a try, you can find it here.

edit flag offensive delete link more

Comments

I am unable to install SMF 8.6 on LO 5.2.7. New at this and I could use some help.

john

johninreno gravatar imagejohninreno ( 2017-06-19 23:36:41 +0200 )edit

The link of the fork mentioned above was wrong, I corrected it to dhocker/SMF-Extension.

erAck gravatar imageerAck ( 2017-06-21 12:53:20 +0200 )edit
Login/Signup to Answer

Question Tools

3 followers

Stats

Asked: 2017-05-31 22:21:57 +0200

Seen: 853 times

Last updated: Jun 21 '17