[Tutor] Filemaker interactions

[Ian Witham]

Hello,

I thought I'd update on my Filemaker Pro 6 situation.

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.

If my project grows much larger in scope I will certainly look into the
mxODBC extension.

Thanks for the suggestions.


On 8/26/07, M.-A. Lemburg <mal at egenix.com> wrote:
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20070829/dc98f14f/attachment.htm