Page 1 of 1

GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Fri Aug 17, 2018 7:29 pm
by Ousmane
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

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Thu Aug 23, 2018 7:17 am
by gni_support
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,

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Thu Aug 23, 2018 9:02 pm
by Ousmane
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

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Fri Aug 24, 2018 8:08 am
by gni_support
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,

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Fri Aug 24, 2018 9:02 am
by Ousmane
Hello,

I already follow this and install it:

openpyxl 2.5.5 is installed and it not working

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Tue Aug 28, 2018 7:14 am
by gni_support
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,

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Wed Aug 29, 2018 2:04 am
by Ousmane
Please can you guide on how to do that

Thanks in advance for the support

kindly,

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Tue Sep 04, 2018 8:45 am
by gni_support
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,

Re: GniPlannerFTTH This plugin is broken No module named openpyxl

Posted: Mon Dec 31, 2018 4:22 pm
by Ousmane
Hello,

I'm using MacOS