GniPlannerFTTH This plugin is broken No module named openpyxl

9 posts Page 1 of 1
Ousmane
Posts: 5
Joined: Fri Aug 17, 2018 7:23 pm


Hello

I'm facing a problem after installation of GNI Planner.

I use Mac OS, can anyone support me to complet the installation.
everything is OK except the plugin GniPlannerFTTH.

Thanks in advance for the support
gni_support
Posts: 62
Joined: Wed Sep 20, 2017 1:05 pm


Hello,
We need more information about your problem.
Please tell us what version of qgis you are using and what is the problem with the PlannerFTTH plugin, do you get some errors? Could you describe/qoute them?
Best regards,
Ousmane
Posts: 5
Joined: Fri Aug 17, 2018 7:23 pm


Hello,

I'm using QGIS 2.18.15 on macOS high Sierra.

I get this message:

Impossible de charger l'extension GniPlannerFTTH provoque une erreur lors de l'appel de sa méthode classFactory()

ImportError: No module named openpyxl
Traceback (most recent call last):
File "/Applications/QGIS.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 333, in startPlugin
plugins[packageName] = package.classFactory(iface)
File "/Users/ousmanediagne/.qgis2/python/plugins/GniPlannerFTTH/__init__.py", line 31, in classFactory
from gniplanner import GniPlannerFTTHPlugin
File "/Applications/QGIS.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 607, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "/Users/ousmanediagne/.qgis2/python/plugins/GniPlannerFTTH/gniplanner.py", line 34, in
from gniplanner_provider import GniPlannerFTTHProvider
File "/Applications/QGIS.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 607, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "/Users/ousmanediagne/.qgis2/python/plugins/GniPlannerFTTH/gniplanner_provider.py", line 32, in
from planner_report import PlannerReport
File "/Applications/QGIS.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 607, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "/Users/ousmanediagne/.qgis2/python/plugins/GniPlannerFTTH/planner_report.py", line 26, in
from openpyxl import Workbook
File "/Applications/QGIS.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 607, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
ImportError: No module named openpyxl


Version de Python : 2.7.10 (default, Oct 6 2017, 22:29:07) [GCC 4.2.1 Compatible Apple LLVM 9.0.0 (clang-900.0.31)]
Version de QGIS : 2.18.15 Las Palmas, exported

Chemin Python :
/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins/processing
/Users/ousmanediagne/.qgis2/python/plugins/ScipyPointClustering
/Applications/QGIS.app/Contents/MacOS/../Resources/python
/Users/ousmanediagne/.qgis2/python
/Users/ousmanediagne/.qgis2/python/plugins
/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins
/Library/Frameworks/SQLite3.framework/Versions/C/Python/2.7
/Library/Frameworks/GEOS.framework/Versions/3/Python/2.7/site-packages
/Library/Python/2.7/site-packages/numpy-override
/Library/Python/2.7/site-packages/matplotlib-override
/Library/Frameworks/GDAL.framework/Versions/2.1/Python/2.7/site-packages
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload
/Library/Python/2.7/site-packages
/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python
/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC
/Users/ousmanediagne/.qgis2//python.

Any question feel free to let me know.

Kindly
gni_support
Posts: 62
Joined: Wed Sep 20, 2017 1:05 pm


Hello,
In one of the previous topics the same problem appeared: viewtopic.php?f=4&t=3#p4
Try to install a python module 'openpyxl', this should solve the problem.
Best regards,
Ousmane
Posts: 5
Joined: Fri Aug 17, 2018 7:23 pm


Hello,

I already follow this and install it:

openpyxl 2.5.5 is installed and it not working
gni_support
Posts: 62
Joined: Wed Sep 20, 2017 1:05 pm


Hello,
It is possible that the module python 'openpyxl' is not visible to QGIS. The solution is to add the path to the location of the module to the PYTHONPATH.
Best regards,
Ousmane
Posts: 5
Joined: Fri Aug 17, 2018 7:23 pm


Please can you guide on how to do that

Thanks in advance for the support

kindly,
gni_support
Posts: 62
Joined: Wed Sep 20, 2017 1:05 pm


Hello,

One way to add a path to PYTHONPATH:
1. Open up Terminal
2. Type open .bash_profile or .profile
3. In the text file that pops up, add this line at the end:
export PYTHONPATH=$PYTHONPATH: path/where/python/package/is/located/
4. Save the file and restart the Terminal.

This solution adds the path, it doesn't change the one already existing there.
Although we don't use this system (Mac OS) and we are not able to check if this option is enough to help run the GniPlannerFTTH plugin. It's possible that you will need to change the path in QGIS software as well.

Best regards,
Ousmane
Posts: 5
Joined: Fri Aug 17, 2018 7:23 pm


Hello,

I'm using MacOS
9 posts Page 1 of 1
ekskluzywne stoły stoły włoskie nowoczesne