Filemaker interactions

[M.-A. Lemburg]

On 2007-08-01 23:41, Ian Witham wrote:
> Hello,
> 
> I'm hoping someone here can put me on the right track with some broad
> concepts here.
> 
> What I am hoping to achieve is a simple HTML page to be served over
> our company LAN, into which the users (Real Estate Agents) can enter a
> property address or reference number.
> 
> My next thought was to have a Python CGI script query our filemaker
> database of property listings, construct a PDF from the relevant
> information, and finally return this PDF to the user.
> 
> At no stage do I want the user to have unfettered access to the
> database or the ability to alter/delete records.
> 
> My question is: what is the most appropriate way for my script to
> interact with Filemaker? Can this be done with Filemaker Pro 6?
> 
> According to the Filemaker Help, the "Local Data Access Companion"
> shares the FileMaker Pro database with ODBC-compliant applications on
> the same computer. Is this the right option?
> 
> Can my CGI script be an ODBC client? How? Would it need to be
> Filemaker specific code or does ODBC have a standardised format?
> 
> I'm grateful for any advice and a nudge in the right direction.

You could try our mxODBC extension for Python which will
likely just work out of the box:

https://www.egenix.com/products/python/mxODBC/

with the Filemaker ODBC driver.

Or give this module a try (if you have more time at hand
and can do without a DB-API interface):

http://www.lfd.uci.edu/~gohlke/code/filemaker.py.html

It uses Filemaker's XML interface.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Aug 25 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611