Reading a DBF file and extracting data with Python in City Engine 2019

CL11

I am trying to use Python in City Engine 2019 to read the DBF file of an SHP that is imported into City Engine

I tried to install the simpledbf python module, but Python in City Engine gives an error on execution, 

 

Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "testdbf.py", line 9, in <module>
    import simpledbf
ImportError: No module named simpledbf

 

 

Is there something I have to do to include external python modules in order to work with City Engine Python?

CL11

Thanks for the suggestion. I tried making a scripting.py with the import sys and sys.path.append and import of simpledbf  and placed that in the project root folder, then re-started city Engine. 

Unfortunately, it still gives the same error on execution for simpledbf.  I also tried just doing the myHelper.py example and it also did not work (perhaps this solution is for the Python console and not for scripts.)

I also tried moving simpledbf into my project's scripts directory. No luck.

The final solution:

In my python script itself,

I added the lines - 

import sys

sys.path.append (with the path being my project scripts directory)

from simpledbf import Dbf5

 

And then I put simpledbf.py in that scripts directory. 

This did work - I was able to read DBF's and query values.

As far as Fiona - I would like to use it, unfortunately, City Engine's python is using Jython 2.7 while Fiona requires CPython 3.