Id like to use python to get information in and out of FMP 12.
is this possible?
There is ODBC to access FM data from python.
You are probably looking for PyFileMaker
GitHub - aeguana/PyFileMaker: PyFileMaker - Integrating FileMaker and Python
I believe, they are available on pip
To combine the two answers, you have two choices:
- ODBC/JDBC - straightforward but you can only get data, not run scripts
- pyFileMaker - leverages the XML API so that you can get both data and run scripts on the server
Clarifying a difference, ODBC don't need FM Server.
"only get" may be typo, "only get/set".
Do you know if I can use pyFileMaker with filemaker pro, or do you need the server version of filemmaker pro?
It mentions "web companion" and FMP v6 but I cant seem to figure out if there is this "web companion" feature in FMP 12.
You will need a FileMaker Server to use pyFileMaker. I am sure it still works with FileMaker Server 14, but the best way to find out is to get in touch with the developer.
With FileMaker Pro client, ODBC is the way to go, as user19752 mentioned before. Another option is to use a plugin. There is a FileMaker plugin allowing to use python coding inside FileMaker: PyFM
I was just playing around with Python (sooooo easy to use!!!!) and saw your posting.
For the OP....if you want to extract data from FMP (not necessarily FMS) outside FMP, then I would either use JDBC/Java or ODBC. FMI supplies both ODBC and JDBC (xDBC) drivers for free with FMP's installation files.
Personally I would almost always use the XML API since it can be set up without any drivers; AND has the ability to execute scripts on FMS before or after the query.
AND the direct xml queries can be used with so many web apps!
This not the same as the FM API for PHP classes/libraries (which also uses the XML api).
FMS only though, right?
Yep, I'd be hard pressed to do any kind of integration against a desktop machine with a user-space application. Usually when integration is needed, FMS is in the picture.
OK, but the OP asked a different question (FMP) which I tried to answer.
FMP 12, ODBC/JDBC Sharing can be turned on per file per user(s).
The Sharing options (on my old FMPA 12) are:
Instant Web Publishing...
The FMP 12 xDBC guide is here:
(all older manuals: http://www.filemaker.com/support/product/documentation_archive.html )
Since I've been using JDBC with FMP for years, I'm assuming that's for the OP, right?
Yes. FMP 12 can have ODBC/JDBC sharing turned on for a file/database. So if OP has the ability/means to read the file with any app that can process either ODBC or JDBC, then yes to that as well.
The way replies are posted on the forum, it's often difficult to know who a particular reply is meant for.
PyFileMaker works with FMS15, but note it's only compatible with Python 2.x. There is a branch that is supposed to work with Python 3.x, but that's not the case. I contacted the last developer who worked on PyFileMaker, he just quit porting to Python 3.x because that was to much work. I tried by myself, even after all compilation issues were solved, I couldn't use it.
PyFileMaker use the XML interface, that'S why FMS is needed.
Retrieving data ...