Can't make any morningstar functions work with SMF extension

Discuss the spreadsheet application

Can't make any morningstar functions work with SMF extension

Postby gav_sharma » Thu Mar 12, 2015 11:19 pm

I am having problems with making the SMF extension work in Libre Office

http://extensions.libreoffice.org/extension-center/smf-extension/050alpha/0.6.4


I have Windows 7 64 bit + LibreOffice 4.4.1 and LibreOffice 4.3.6 installed. I tried both v6.4 and v6.3 of the sfm extension with both the Libreoffice version. In none of the case I was able to make the example Morningstar files. Yahoo works for all versions and I am able to update the data but all I see is NMS or NYQ in the data column
Libre Office 4.4.1 and Win 7 64 bit
gav_sharma
 
Posts: 1
Joined: Thu Mar 12, 2015 11:16 pm

Re: Can't make any morningstar functions work with SMF exten

Postby Villeroy » Fri Mar 13, 2015 7:26 pm

I'm sure that my 0.6.2 version used to work well 3 weeks ago. But now the same version returns NMS or NYQ just as you describe. Something has must have changed on the site which delivers the data.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can't make any morningstar functions work with SMF exten

Postby madsailor » Sat Mar 14, 2015 7:10 am

gav_sharma,
The new version 0.7.0 is up which should fix the issue. Thanks for reporting your issue on Github, as I saw that before finding your post here, and for your extensive multi-version testing.
LibreOffice 4.2.7.2 on Ubuntu 14.04
madsailor
 
Posts: 17
Joined: Sat Feb 21, 2015 8:16 pm

Re: Can't make any morningstar functions work with SMF exten

Postby Villeroy » Sun Mar 15, 2015 6:39 pm

I can't install SMF on OpenOffice nor LibreOffice 3 because some method can't be found. Does your version 0.7 depend on Python 3?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can't make any morningstar functions work with SMF exten

Postby madsailor » Mon Mar 16, 2015 6:10 am

Yes, migrated to Python 3 with the 0.6.2 release. I'm surprised you haven't had an issue until now.
LibreOffice 4.2.7.2 on Ubuntu 14.04
madsailor
 
Posts: 17
Joined: Sat Feb 21, 2015 8:16 pm

Re: Can't make any morningstar functions work with SMF exten

Postby Villeroy » Wed Mar 18, 2015 2:43 pm

The top comment on https://docs.python.org/2/library/urlli ... ule-urllib describes the compatibility problem. When installing the extension, I get "Couldn't load file:///<user profile>/uno_packages/.../SMF.oxt/smf.py for reason type urllib.Request.request is unknown. This may be the only problem or only the first.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can't make any morningstar functions work with SMF exten

Postby madsailor » Wed Mar 18, 2015 9:59 pm

Villeroy,
There are going to be multiple problems trying to run SMF with Python 2.x. As of Libreoffice 4.0 the bundled version of Python was bumped from 2.6 to 3.3 as noted at http://wiki.documentfoundation.org/ReleaseNotes/4.0#API_Changes, so there is not much reason to support python 2.x. That being said, I have modified a version that you can find herehttps://drive.google.com/file/d/0B8TbA-B3cHhxbGszR1RvZnMzaDQ/view?usp=sharing that fixes the specific error you referenced when running under Python 2.x. If you would like to try this version and report the next set of errors here, we can troubleshoot together, as even the python uno bindings for 2.x have been deprecated on Ubuntu 14.04 (my development environment).
Backward-compatibility bug squashing aside, I would recommend that everyone upgrade to LO 4.x + since this will update Python to 3.3+ and avoid the issue altogether.
LibreOffice 4.2.7.2 on Ubuntu 14.04
madsailor
 
Posts: 17
Joined: Sat Feb 21, 2015 8:16 pm

Re: Can't make any morningstar functions work with SMF exten

Postby Villeroy » Wed Mar 18, 2015 11:49 pm

All in all, I don't like LibreOffice. The compatibility version works for me. This is a candidate for the the OpenOffice extention site.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can't make any morningstar functions work with SMF exten

Postby marcsfox » Sat Apr 04, 2015 7:26 pm

Hi, would love to use the SMF function on Mac. Unfortunately, I am unable to install the SMF.oxt in LibreOffice. when I click add extension from my download folder I get the following error message, any step-by-step help for those of use less savvy would be very much appreciated!

(com.sun.star.uno.RuntimeException) { { Message = "<class 'FileNotFoundError'>: [Errno 2] No such file or directory: '/Users/moshe/Library/Application Support/LibreOffice/4/user/uno_packages/cache/uno_packages/lu39znuh.tmp_/SMF%20(2).oxt/smf.py', traceback follows\X000a /Applications/LibreOffice.app/Contents/MacOS/pythonloader.py:94 in function getModuleFromUrl() [fileHandle = open( filename, encoding='utf_8' )]\X000a /Applications/LibreOffice.app/Contents/MacOS/pythonloader.py:149 in function writeRegistryInfo() [mod = self.getModuleFromUrl( locationUrl )]\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }
LibreOffice 4.3.0.4 on Mac OS X 10.9
marcsfox
 
Posts: 1
Joined: Sat Apr 04, 2015 7:22 pm

Re: Can't make any morningstar functions work with SMF exten

Postby Villeroy » Sat Apr 04, 2015 8:02 pm

Can you access any Python macros under Tools>Macros>Organize>Python...? Are there any libraries in the LibreOffice container? Open a Writer document and run the HelloWorld macro. It should write "Hello World (in Python)" into the current Writer document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 15 guests