I have a QGIS .model3 file that uses PostgreSQL tables as its inputs and writes to other PostgreSQL tables as its outputs. I am having trouble getting this model to run as part of an FME Workbench.
What I have done so far:
- Copied the tool parameters from the QGIS graphical interface (Advanced > Copy as qgis_process command)
- Edited the command so that “--” only appears in front of the first parameter
- Added “” around each PostgreSQL parameter as they contain spaces and special characters and were causing Invalid parameter errors in Windows command prompt
- Thanks to these changes, running the tool with qgis_process in Windows command prompt no longer throws invalid parameter errors
The tool fails silently through the SystemCaller transformer in FME.
In Windows command prompt, the parameters now seem to be read properly but I am now getting “File could not be found” for PostgreSQL addresses.
Still in command prompt, dialing psql first with my database credentials makes it say \PROGRA~1 is an invalid command.