Hi - I am hoping someone can help.
Apologies in advance for the long message.
I am using FME Workbench 2022.2.8.
I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database.
I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script.
I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas.
I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1).
I created an environment called fme_env and set the Python version to 3.9.
I was able to successfully set up all this, but I encountered the no module called FMEObjects error.
I went into my FME installation path and there was a folder called fmeobjects and inside that there were several version but I used Python39 (C:\Program Files\FME\fmeobjects\python39) .
Inside that folder there were two files fmeobjects.pyd and pluginbuilder.pyd. I copied both those files into a new folder called fme within the site-packages folder of my environment . (C:\Users\usera\AppData\Local\anaconda3\envs\fme_env\Lib\site-packages\fme)
I got an error about missing DLL files.
I used the Discrepancy Walker and it highlighted four files. (fme.dll, fmepython39.dll, fmeutil.dll and python39.dll)
The first three I found (C:\Program Files\FME) and copied them to my fme. I was unable to find the python39.dll file but I was able to find one in the environment I created (C:\Users\usera\AppData\Local\anaconda3\envs\fme_env) so copied that into the folder as well.
Same issue happened again.
As a last resort I created this script but again still no luck.
import sys
import os
sys.path.append("C:\\Program Files\\FME\\fmeobjects\\python39")
sys.path.append("C:\\Program Files\\FME\\")
os.chdir("C:\\Program Files\\FME\\")
import fmeobjects
Any ideas on how to resolve this would be fantastic.
