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 -- http://mail.python.org/mailman/listinfo/python-list
