Ask Your Question
1

Couldn't install packages for DMView

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

LSilv gravatar image

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)')))

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted
0

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

LSilv gravatar image

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.

edit flag offensive delete link more
0

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

jconto gravatar image

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
edit flag offensive delete link more

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 gravatar imageLSilv ( 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 gravatar imageMohamed_M ( 2023-10-04 12:51:07 -0500 )edit
0

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

Alex P gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

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

Seen: 973 times

Last updated: Oct 11 '23