davidhamann / python-fmrest

Python wrapper around the FileMaker Data API
MIT License
100 stars 27 forks source link

Question: can I use python-fmrest to acceess data in a local .fmp12? #73

Open andrejjh opened 7 months ago

andrejjh commented 7 months ago

Hi David, Your examples shows FileMaker Server Data API.

Can I also use python-fmrest to directly access a local Filemaker database(.fmp12) without Server Connection? I want to extract some fields from a existing database to save in a CSV format. Thanks

davidhamann commented 7 months ago

Hi André,

No, this is not possible, unfortunately. The Data API is only available with FileMaker Server, not the client.

For your use-case you might be able to use the ODBC driver and then connect to the local Pro client (if you have an installation). I wrote some article about it in 2016; maybe it helps: https://davidhamann.de/2016/12/24/working-with-filemaker-data-in-python/

Unfortunately, getting the data out of a .fmp12 file without any FileMaker client or server software is a bit tricky since it's not a publicly documented file format. I thought about digging deeper into the fmp12 file structure in the past, but haven't gotten around to it so far.

Cheers!