The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > OmniFocus > OmniFocus 1 for Mac
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
How to make OmniFocus work with File Maker Pro? Thread Tools Search this Thread Display Modes
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!
 
sqlite3 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: http://www.sqlite.org/

Google searches for
filemaker sqlite3 | sqlite
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
 
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'
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make OmniFocus work for complex projects? Indyprint OmniFocus 1 for Mac 11 2011-12-12 11:15 PM
Help! How do I make OmniGraffle stop loading previous file on open? RadicalBender OmniGraffle General 4 2011-02-17 10:57 AM
Make it all work between Entourage 2008 and Omnifocus? berntm Applying OmniFocus 1 2009-12-10 07:06 AM
Trying to make it all work dpfels OmniFocus 1 for Mac 3 2008-02-14 05:12 PM


All times are GMT -8. The time now is 08:56 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.