Installation error - v. 3.8.0 and 3.8.1 on LibreOffice Calc v. 25.2.3.2 (X86_64)

[myllo]

While trying to install as usual in LibreOffice Calc on Win10 Home64, I get this:

(com.sun.star.uno.RuntimeException) { { Message = "<class 'Exception'>: Neither curl_cffi nor requests found., traceback follows\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 147, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 102, in getModuleFromUrl\X000a exec(codeobject, mod.dict)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu201201j81hu.tmp_\Financials-Extension.oxt\financials.py", line 57, in \X000a import financials_yahoo as yahoo\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu201201j81hu.tmp\Financials-Extension.oxt\financials_yahoo.py", line 22, in \X000a from baseclient import BaseClient, HttpException\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu201201j81hu.tmp\Financials-Extension.oxt\baseclient.py", line 36, in \X000a raise Exception("Neither curl_cffi nor requests found.")\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

Apparently not working.

Olli

[myllo]

Version 3.8.1 still gives the same error on install:

(com.sun.star.uno.RuntimeException) { { Message = "<class 'ImportError'>: No module named 'urllib3' (or 'baseclient.BaseClient' is unknown), traceback follows\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 147, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 102, in getModuleFromUrl\X000a exec(codeobject, mod.dict)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu778026375s.tmp_\Financials-Extension.oxt\financials.py", line 57, in \X000a import financials_yahoo as yahoo\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu778026375s.tmp\Financials-Extension.oxt\financials_yahoo.py", line 22, in \X000a from baseclient import BaseClient, HttpException\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 425, in _uno_import\X000a raise uno_import_exc\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu778026375s.tmp\Financials-Extension.oxt\baseclient.py", line 32, in \X000a import requests\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\ollip\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu778026375s.tmp\Financials-Extension.oxt\requests\init.py", line 43, in \X000a import urllib3\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return _builtin_import(name, *optargs, **kwargs)\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

Not working.

Olli

[jorgemonteiro]

Correct, same install error but on a different module... this time it is 'urllib3'. For me it was on macOS, not Windows.

[Rfk124]

Same error on Windows 11, I have deleted the previous extension version and when I install the new one I get this error :

(com.sun.star.uno.RuntimeException) { { Message = "<class 'ImportError'>: No module named 'urllib3' (or 'baseclient.BaseClient' is unknown), traceback follows\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 147, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 102, in getModuleFromUrl\X000a exec(codeobject, mod.dict)\X000a File "C:\Users\User\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu12468jn3mj.tmp_\Financials-Extension.oxt\financials.py", line 57, in \X000a import financials_yahoo as yahoo\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\User\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu12468jn3mj.tmp\Financials-Extension.oxt\financials_yahoo.py", line 22, in \X000a from baseclient import BaseClient, HttpException\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 425, in _uno_import\X000a raise uno_import_exc\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\User\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu12468jn3mj.tmp\Financials-Extension.oxt\baseclient.py", line 32, in \X000a import requests\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\User\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu12468jn3mj.tmp\Financials-Extension.oxt\requests\init.py", line 43, in \X000a import urllib3\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return _builtin_import(name, *optargs, **kwargs)\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

[antapos]

To resolve this you need to follow the instructions in the README at the root directory. It mentions how to download and install get-pip.py using Libreoffice's python.exe and then pip install needed dependency.

[jorgemonteiro]

@antapos Unfortunately that does not work, even after following all the steps, it still complains about the missing module :( But since @cmallwitz bundled 'requests' with the extension, now it complains about 'urllib3'... maybe @cmallwitz can add 'urllib3' to the extension? ;)

Please note, I am on macOS, not on Windows...

[sancheza]

I tried updating the extension to bundle urllib3. That resolved all installation errors. Unfortunately, the extension still doesn't work properly. Any cells referencing Yahoo show #N/A whereas FT works properly. This points to residual issues specific to Yahoo. (Note that this is on MacOS.)

[bluesubie18]

I followed the latest release instructions and the extension installs without issue but still be error in cells referencing yahoo.

I get the following error when I run the two command prompt lines in the read me. Does anyone know the solution to this?

sys.exec prefix = sys . path 'c: \Program Files\LibreOffice\program\python39.zip' , 'C:\Program , 'C: \Program , 'c:\Program Files\LibreOffice\program' , Fatal Python error: init_fs_encoding: failed to get the Python codec of the file system encoding Python runtime state: core initialized ModuleNotFoundError: No module named 'encodings ' Current thread exØOØ0652c (most recent call first) : <no Python frame>