Hello,<br><br>I thought I'd update on my Filemaker Pro 6 situation.<br><br>The PyFileMaker module (CGI based access) is meeting my requirements at present, although record searches with a large number of results are a little slow.
<br><br>If my project grows much larger in scope I will certainly look into the mxODBC extension.<br><br>Thanks for the suggestions.<br><br><br><div><span class="gmail_quote">On 8/26/07, <b class="gmail_sendername">M.-A. Lemburg
</b> <<a href="mailto:mal@egenix.com">mal@egenix.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On 2007-08-01 23:41, Ian Witham wrote:
<br>> Hello,<br>><br>> I'm hoping someone here can put me on the right track with some broad<br>> concepts here.<br>><br>> What I am hoping to achieve is a simple HTML page to be served over<br>> our company LAN, into which the users (Real Estate Agents) can enter a
<br>> property address or reference number.<br>><br>> My next thought was to have a Python CGI script query our filemaker<br>> database of property listings, construct a PDF from the relevant<br>> information, and finally return this PDF to the user.
<br>><br>> At no stage do I want the user to have unfettered access to the<br>> database or the ability to alter/delete records.<br>><br>> My question is: what is the most appropriate way for my script to<br>
> interact with Filemaker? Can this be done with Filemaker Pro 6?<br>><br>> According to the Filemaker Help, the "Local Data Access Companion"<br>> shares the FileMaker Pro database with ODBC-compliant applications on
<br>> the same computer. Is this the right option?<br>><br>> Can my CGI script be an ODBC client? How? Would it need to be<br>> Filemaker specific code or does ODBC have a standardised format?<br>><br>> I'm grateful for any advice and a nudge in the right direction.
<br><br>You could try our mxODBC extension for Python which will<br>likely just work out of the box:<br><br><a href="https://www.egenix.com/products/python/mxODBC/">https://www.egenix.com/products/python/mxODBC/</a><br><br>
with the Filemaker ODBC driver.<br><br>Or give this module a try (if you have more time at hand<br>and can do without a DB-API interface):<br><br><a href="http://www.lfd.uci.edu/~gohlke/code/filemaker.py.html">http://www.lfd.uci.edu/~gohlke/code/filemaker.py.html
</a><br><br>It uses Filemaker's XML interface.<br><br>--<br>Marc-Andre Lemburg<br>eGenix.com<br><br>Professional Python Services directly from the Source (#1, Aug 25 2007)<br>>>> Python/Zope Consulting and Support ...
<a href="http://www.egenix.com/">http://www.egenix.com/</a><br>>>> mxODBC.Zope.Database.Adapter ... <a href="http://zope.egenix.com/">http://zope.egenix.com/</a><br>>>> mxODBC, mxDateTime, mxTextTools ...
<a href="http://python.egenix.com/">http://python.egenix.com/</a><br>________________________________________________________________________<br><br>:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::
<br><br><br> eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48<br> D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg<br> Registered at Amtsgericht Duesseldorf: HRB 46611<br></blockquote>
</div><br>