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. 3 4034
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
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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 demo version of FmPro Migrator is
now fully functional for a limited number of database fields,...
|
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?
|
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 done similar
projects on Filemaker. However, my experience with Access is does not deal
well with...
|
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
| |
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 need to copy database (if you will) from one server to another. How
|
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
past few years and would call my skills above intermediate but
definitely not expert. I used FMP...
|
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 database running on the Web?
Thank you.
|
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
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |