473,561 Members | 3,128 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Filemaker interactions

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.

Ian.

Aug 1 '07 #1
3 4032
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.

Ian.
I don't know if this helps, but there is a PyFileMaker module for Python for interacting with FileMaker:
http://www.sourcefiles.org/Programmi...aker-1.2a4.zip

That seems to be the only still working link to the module I can find, so I'm guessing it's not in active development.

-Jay
Aug 1 '07 #2
On Aug 2, 10:13 am, Jay Loden <pyt...@jaylode n.comwrote:
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.
Ian.

I don't know if this helps, but there is a PyFileMaker module for Python for interacting with FileMaker:http://www.sourcefiles.org/Programmi...les/Python/PyF...

That seems to be the only still working link to the module I can find, so I'm guessing it's not in active development.

-Jay
Thanks for that. I've come across it before but never found a working
link!
I'll let you know how I get on.

Ian.

Aug 1 '07 #3
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.D atabase.Adapter ... http://zope.egenix.com/
mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
_______________ _______________ _______________ _______________ ____________

:::: Try mxODBC.Zope.DA for Windows,Linux,S olaris,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
Aug 25 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1954
by: Lloyd Dupont | last post by:
============== MEDIA RELEASE ================ Wednesday 5th August 2003 5D Services, makers of the ihook IT Management solution announce the immediate release of FM.NET. ihook's FileMaker ADO.NET Connector is a data provider for .NET connecting to FileMaker. It allows applications to connect to a FileMaker database in a
0
1504
by: David Simpson | last post by:
..com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with a new FileMaker to PostgreSQL migration feature. Images within FileMaker container fields are automatically migrated to PostgreSQL 'lo' (large object type) columns. Improvements have also been made to the existing FileMaker 7 table consolidation feature. The latest...
1
3494
by: Jason Berg | last post by:
I am new to filemaker, and i was wondering if there is any solution out there to export date from filemaker to SQL Server in an automated process?
9
6490
by: Noesis Strategy | last post by:
My firm is creating a database that profiles (about 100) companies in various sectors. Each profile is about 10 pages long with perhaps 150 parameters. Some of the parameters will contain a half a page of information such as "recent press releases". Is there particular function of Access that would make it better than Filemaker? I have...
2
5709
by: polpe | last post by:
Hello, i have a filemaker server 5.5 with some shared files. I don't understand how use ODBC with these files to import a database in Access. Can anyone help me? Polpe from Italy
0
1564
by: =?Utf-8?B?TWU=?= | last post by:
I am not sure if this is the right group, if not, please point me to the right one - thank you. I am novice to Filemaker pro familiarizing with filemaker pro 5.5 server and filemaker pro 6 client. First of all I would like to know little bit how Filemaker works? Does it work like client-server architecture or something else? I have a...
12
2427
by: AllYourSpam | last post by:
I work for a small company just over a year old. I have them sold on the idea of a database for tracking their sales and order entry (plus many other duties). We are going to develop our own database and are trying to decide which software to use. We are windows based, have Access, and a trial version of FMP 8.5. I have used Access for the...
2
5219
by: briggsbpc | last post by:
I am a FileMaker developer and have been since Version 5.0... that long. FileMaker 9.0 has promised to hook up to SQL server and MySQL databases. When I hook up I can not upload pictures just text and numbers. There is a web page http://www.frontendsolutions.ca that shows it uploading pictures. Can Access upload pictures to a SQL server...
2
1483
by: liukaiyuan | last post by:
FileMaker Business Management Software Free trial of FileMaker Pro 8 and Business Productivity Kit software. Try FileMaker???s database and business software tools for managing customers, contacts, projects, assets, and more. http://www.ogogosina.cn/Filemaker.htm
0
7858
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8085
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7928
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5469
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5185
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3615
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2066
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1180
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
892
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.