Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Database Question: Filemaker?

by Kozz (Friar)
on Feb 03, 2001 at 00:34 UTC ( #56090=perlquestion: print w/ replies, xml ) Need Help??
Kozz has asked for the wisdom of the Perl Monks concerning the following question:

My esteemed monks:
I've been researching a way to interact with a Filemaker Pro relational database system (Mac platform) from the web, using any means possible. I don't know much of anything about Filemaker, aside from the fact that it's a database system. Does anyone know of any modules or snippets that would allow me to interact with a Filemaker database?

Even worse (and maybe off-topic) any PHP tools?

Thanks much.

Comment on Database Question: Filemaker?
Re: Database Question: Filemaker?
by PsychoSpunk (Hermit) on Feb 03, 2001 at 00:50 UTC
    Simple answer: Does this FileMaker Pro have ODBC? DBD::ODBC and an ODBC bridge like the Easysoft Bridge would be useful (if they have one for the Mac).

    Update: This was of course just a guess. I have no Macs immediately at my disposal. Looks like Coyote gets the prize for this one.

    ALL HAIL BRAK!!!

(Coyote) Re: Database Question: Filemaker?
by Coyote (Deacon) on Feb 03, 2001 at 01:34 UTC
    Filemaker Pro on the Mac side doesn't have either an odbc or DBD driver, but you can use Chris Nandor's Mac::Glue to script Filemaker via Apple Events. You can find it on CPAN or at http://sourceforge.net/projects/mac-glue/. I've seen examples that use Filemaker on some of the MacPerl mailing lists. You might want to check the archives for example code.

    Update: I cranked up my Powerbook and looked at the Mac::Glue distribution and an example for extracting FileMaker data is included.

    ----
    Coyote

Re: Database Question: Filemaker?
by sierrathedog04 (Hermit) on Feb 03, 2001 at 17:25 UTC
    It looks to me as if Filemaker Pro on the MAC does have an ODBC interface. You can find out more about it here.

    At that point your Filemaker Pro has become an ODBC datasource. Perl won't care very much that it is Filemaker Pro and should treat it like any other ODBC source.

    I am not sure what the best way is to access ODBC from Perl. However, CPAN has some modules. DBD::ODBC available here looks like a promising candidate, but there may be better ways.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://56090]
Approved by root
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2014-09-20 13:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (159 votes), past polls