Couldn't install packages for DMView

DMView
openpyxl
retag add tags

I'm trying to use the DMView for the first time for an ERCOT project and I'm not able to install openpyxl. I get the following error messages when I try. I've experimented with using pip, pip3, and pip3.7. The issue is the same using pip as opposed to pip3. The last one is not recognized.

I set the python path in the 'run3x.bat' file explicitly. Does 'openpyxl-3.1.2-py2.py3-none-any.whl' have to be somewhere specific? After I downloaded it, I put a copy in my DMView folder and another copy in "C:\Python37\Lib\ensurepip_bundled" Does it need to be somewhere else?

Mon 10/02/2023 18:28:41.93 PATHs set: python 37

C:\Users...\DMView 3.0>pip3 install openpyxl Collecting openpyxl Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATEVERIFYFAILED] certificate verify failed: self signed certificate in certificate chain (ssl.c:1056)'))': /packages/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a/openpyxl-3.1.2-py2.py3-none-any.whl ... Could not install packages due to an EnvironmentError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Max retries exceeded with url: /packages/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a/openpyxl-3.1.2-py2.py3-none-any.whl (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATEVERIFYFAILED] certificate verify failed: self signed certificate in certificate chain (ssl.c:1056)')))

LSilv

asked 2023-10-02 18:36:39 -0500

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

3 Answers

Sort by

oldest

newest

most voted

This is most reliable way that I've found to install python modules:

open a command prompt with admin privileges

change to the scripts folder (where pip.exe is) inside the main folder of the python version you want to install the module for, e.g.
C:\Python27\Scripts

install the module using pip:
pip install pandas

Done. In my experience this is best way to ensure that the module will be found when trying to import. It also avoids conflicts between 32 bit and 64 bit versions when they are installed in the user profile folder.

Your error is strange, but this might still be helpful.

Alex P

answered 2023-10-03 21:37:53 -0500

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Confim the following: could it be your pc requires Admin rights to install python modules? Has other python modules installed ok?

is the python37 installed at the c:\ root directory, a 32-bit version?

I did install openpyxl for python 39, 32-bit, with pip, using the following command in a DOS window (open at 'any' directory):

c:\..>pip install openpyxl

2.9k

jconto

answered 2023-10-03 19:44:52 -0500

edit flag offensive 0 remove flag delete link

Comments

I asked IT to give my full access for python 3.7 folders on my machine. The error is now slightly different. (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1091)')))

LSilv (2023-10-04 12:11:09 -0500) edit

you can try this for your certificate issue $ pip install --trusted-host pypi.org --trusted-host pypi.python.org --trusted-host files.pythonhosted.org <package_name> see: https://stackoverflow.com/questions/25981703/pip-install-fails-with-connection-error-ssl-certificate-verify-failed-certi

Mohamed_M (2023-10-04 12:51:07 -0500) edit

add a comment see more comments

After reaching out to ERCOT, I needed to install python 39 and used that instead of python 37. (No idea how PSS/e 35 could be installed on my machine without python 39.) Then there were several iterations of getting the necessary permissions from IT to run 'pip' and also had to add 'trusted host' to the command when downloading openpyxl and matplotlib. But finally, was able to run the program.

LSilv

answered 2023-10-11 09:31:34 -0500

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Couldn't install packages for DMView edit

Comments

3 Answers

Comments

Comments

Comments