Unable to import module named xlrd

[bmeyers]

Good morning,

I am trying to add a 3rd party module to Ignition called xlrd. However, when I go to run my script the module is not found.

This link here suggests changing the module location:

ImportError: No module named abc

Greetings I created a library function and hope to reuse it But then i got this error. I search through and read through the forum posts and tried but still could not resolve it. Finally i just copy an existing file decimal.py and rename it as abc.py and try to import it but it still gives the same error as “ImportError: No module named abc” However, there wasnt any error for the line comprising of the import decimal. Both files are located in the same folder in pylib So could someone pleas…

I can then import the module from the script Console but not the script I am running.

Any help with what I am doing wrong is appreciated.

[bschroeder]

What version of xlrd did you download?
Also what version of Ignition are you using?

[JordanCClark]

Copying a Excel file to a tables Dataset

xlrd works with Jython 2.7. Unzip this into the user-lib/pylib/site-packages folder. xlrd.zip (283.0 KB) Documentation

You may also have to restart your designer to get a local copy. I don't quite remember.

[JordanCClark]

Bear in mind that I was only able to get it to work properly in v8. I never had any success in 7.9.

[JordanCClark]

Whoops!Just sunk in what your issue is. Where are you trying to run the script from? And where did you install xlrd?

[bmeyers]

Hello,

I installed the folder you attached here:
C:\Program Files\Inductive Automation\Ignition\user-lib\pylib

I then went to my script console and typed in “import xlrd”
Error message in script console: ImportError: No module named xlrd

If I can get that to work I’ll try the script again.

[JordanCClark]

you need a site-packages folder.
C:\Program Files\Inductive Automation\Ignition\user-lib\pylib\site-packages

[bmeyers]

That seemed to work for the console and the script I was running. I got my original info from here…

https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/98/2/importing-and-using-3rd-party-python-libraries-in-ignition

Do I need to put the folder in both locations or just the site-packages one you mentioned?

[JordanCClark]

The site-packages should be all you need.

[JordanCClark]

@bmeyers

That seemed to work for the console and the script I was running. I got my original info from here…

https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/98/2/importing-and-using-3rd-party-python-libraries-in-ignition

Do I need to put the folder in both locations or just the site-packages one you mentioned?

Things got changed up a bit for v8. The site-packages folder more of a python standard.

Procedure for installing python libraries from source

There’s actually a procedure you can use to use pip from within Jython to install packages, then link Ignition’s Jython lib to an-off-the-shelf Jython lib and use that…however, the article specifically calls out the twilio module as not working, because one of its dependencies, cffi, has C dependencies (IE, won’t work in Jython). For posterity, here’s the procedure, copied verbatim from an internal document: 0) On the server, install Java 8 if you haven’t already. Download the full Jython 2.…