How to make OmniFocus work with File Maker Pro?
 

How anyone know how to enable my Filemaker database interface with OmniFocus?


Thanks!

You can read the OF cache through SQLite SQL, but don't try writing to it.

Thanks...though I'm not sure I follow. Is that an app a plugin or some other way of interfacing FMP w/ OmniFocus? Thanks!

[I]sqlite3[/I] is a standard command in OS X installations.

Probably only an option if you're familiar with (or happy to learn) some SQL.

For the relevant dialect of SQL: [url]http://www.sqlite.org/[/url]

Google searches for
[INDENT][I]filemaker sqlite3 | sqlite[/I][/INDENT]
will lead you to examples of the options for reading from the FileMaker end.

(as I mentioned, writing to the cache is not an option)

You can track down the location of the OmniFocus sqlite cache by running code like:

[CODE]GetCachePath()


on GetCachePath()
set strDefaultFolder to "~/Library/Caches/com.omnigroup.OmniFocus"
set strAppStoreFolder to "~/Library/Caches/com.omnigroup.OmniFocus.MacAppStore"
set strDBName to "OmniFocusDatabase2"

set strCacheFolder to strDefaultFolder
if (do shell script ("test -d " & strCacheFolder & "; echo $?")) ≠ "0" then
set strCacheFolder to strAppStoreFolder
if (do shell script ("test -d " & strCacheFolder & "; echo $?")) ≠ "0" then return ""
end if

return strCacheFolder & "/" & strDBName
end GetCachePath[/CODE]

General pattern, from the command line:

[CODE]OFOC=$(osascript -e 'tell application "Finder" to get id of application file id "OFOC"')
sqlite3 ~/Library/Caches/$OFOC/OmniFocusDatabase2 'select count(*) from task where projectInfo is null and childrenCount=0'[/CODE]