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 <[EMAIL PROTECTED]> 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 >
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
