Python FMS?

Questions
1

Is anyone using Python to connect to FMS using any method like the Python FMS connector?

Thanks,

2

Hi did you mean python and data api?

3

Thanks for your reply. Really, I'm just wondering if anyone uses Python-anything with FMS.

4

I collaborated with a developer to deliver a shop-front ordering system. All of the data sources were managed by FileMaker. He used Python as the code for the website and the comms with FileMaker. I never saw the code, and I don't know what effort was required, but the website worked really well.

1 Like
5

I did a project that used python extensively on the client computer using BaseElements BE_ExecuteSystemCommand. One of the hurdles I encountered was that the scripts had to be called with the full path to the python executable and the scripts themselves had to use full paths to the various imported modules. Just a couple gotchas, but it ended up working great.

Looking back, I wish that the client had just hired me to write the scripts in filemaker in the first place instead of a python developer, especially because he wanted to call them from filemaker in the end anyway. But it gave me a chance to brush up on some python, so it's all good.

1 Like
6

We're using Python in the mix somewhere that drives our React Scheduler. Also in there are GraphQL, Go and Django.
But I'm the UI guy so I don't have the technical details.
I do know that right now we can't update the server past 19.2.1 because that's the last version that supports the older ODBC driver. It does not work with Apple Silicon.

1 Like
7

thanks

8

bBox plug-in for FileMaker

  • macOS (FM Pro, FM Server) and Linux (FM Server) only
  • 50+ functions, many useable as script steps
  • Free, as in beer

Python functions:

  • bBox_Python3Run ( mode; script; text {; param1; ...} )
  • bBox_PythonCompile ( mode; script )
  • bBox_PythonEval ( reference; expression )
  • bBox_PythonExecute ( mode )
  • bBox_PythonFinalize
  • bBox_PythonGetVar ( name }
  • bBox_PythonSetVar ( name; value {; asType} )

As mentioned, other plugins (MBS, BE) can be used to execute python. Also, various methods using Data API, serverless or microservices models, etc.

6 Likes
9

I avoid plug-ins at all cost since they restrict me to a "FileMaker-Only" implementation (often with expensive server costs and restrictions).
A simple REST ("micro") service is, IMHO, far superior as it can be used with any HTTP-capable application (like, for example, FileMaker) and you control the code so no worries about needing the "developer" to fix any issues. Free and quick to set up in just about any modern programming language, also.

10

Nice to see you here, @JayG . Welcome to the Soup.

1 Like
11

Nice product. Is that your work?

12

Simon Brown is the chief architect. Others contribute code, testing, docs.

1 Like
13

Thanks! Been lurking for 3 years.

2 Likes