How anyone know how to enable my Filemaker database interface with OmniFocus?
Thanks!
Thanks!
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!
|
|
FAQ | Members List | Calendar | Today's Posts | Search |
How to make OmniFocus work with File Maker Pro? | Thread Tools | Search this Thread | Display Modes |
Member
2012-07-20, 02:51 PM
How anyone know how to enable my Filemaker database interface with OmniFocus?
Thanks!
Post 1
|
Guest
2012-07-21, 06:08 AM
You can read the OF cache through SQLite SQL, but don't try writing to it.
Post 2
|
Member
2012-07-21, 11:15 AM
Thanks...though I'm not sure I follow. Is that an app a plugin or some other way of interfacing FMP w/ OmniFocus? Thanks!
Post 3
|
Guest
2012-07-21, 02:58 PM
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 | sqlitewill 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
Post 4
|
Guest
2012-07-21, 03:16 PM
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'
Post 5
|
|
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 |