Interfacing w/ FileMaker Pro?

jprint714 · February 23, 2009, 8:53pm

Does anyone know if there’s any way to interface DevonThink w/ FileMaker Pro? That is, apart from exporting a FMP into an Excel or a PDF, and then opening it in DevonThink…

Thanks!

cturner · February 23, 2009, 10:22pm

Um, Applescript?

jprint714 · February 23, 2009, 10:56pm

Ok… In what way can AppleScript enable a FileMaker Pro database to become accessible to DT?

jprint714 · February 24, 2009, 7:38am

Any suggestions…?

cturner · February 24, 2009, 1:42pm

I don’t think there are any mind readers here on the forum, so until you propose something you want to do with these two pieces of software, I doubt you’ll get anyone to describe the effectively infinite number of possibilities there are.

Alternatively, you could take a look at FMP and DTPO’s dictionaries in the Applescript editor and see for yourself.

Charles

jprint714 · February 25, 2009, 8:04am

I’m trying to find a way that FileMaker Pro & DEVONthink can communicate w/ each other (i.e., interface) so that I can access the data / info contained in my FileMaker Pro database – just like the way DEVONthink is able to access / import / index data from other formats (e.g., from email clients).

Is this possible? If so, how?

Thanks!

jprint714 · February 25, 2009, 8:20am

I’ve been asking around in a FileMaker Pro forum, and was told that in order for FMP to access / interface w/ a DEVONthink database FMP would need specific ODBC drivers to access from the DEVONthink database… Possible?

Thanks!

cgrunenberg · February 25, 2009, 9:05am

DEVONthink doesn’t use or support ODBC. Therefore the only solutions are either AppleScript or ex- & importing CSV/TSV files.

jprint714 · February 25, 2009, 9:21am

I’ve never used AppleScript before. How would you suggest I use it? Is there a kind of script you’d suggest I produce that would enable this kind of interfacing? Thanks for your help!

cgrunenberg · February 25, 2009, 11:20am

I don’t use FileMaker, therefore I don’t know.

cturner · February 25, 2009, 12:39pm

You can look in your Filemaker Documentation for the discussion of “Perform Applescript,” p. 139:

http://www.filemaker.com/downloads/pdf/fmp10_scripts_reference.pdf

You’ll be interested in everything else that document has to say.

Hanaan Rosenthals’s book on Applescript also has a section of Filemaker:

http://www.apress.com/book/preview/9781590596531

See page 635 of the Apress preview.

jprint714 · March 5, 2009, 12:47am

Thanks very much. But I was wondering if there were suggested AppleScripts already out there that I might be to try out – anything already created that helps DT to interface w/ FMP. Thanks!