Integrating Omnifocus 2 with Devonthink Pro (Rob Trew scripts)

bkruisdijk · September 1, 2017, 7:56am

This is very promising and it would be great if I can make this working on my machine, however I get the following error message:

error “OmniFocus kreeg een fout: Error: near “Support”: syntax error” number 1

It is on this command line probably:

set strNoteXML to do shell script "sqlite3 " & pstrDBPath & space & quoted form of strQuery

I use this DBPath:

property pstrDBPath : "~/Library/Containers/com.omnigroup.OmniFocus2.MacAppStore/Data/Library/Application Support/Omnifocus/OmniFocus.ofocus"

Could you give me a hint where to look for a solution!

unlocked2412 · September 1, 2017, 8:54am

I’ll try to give you a hint. Did you bought OmniFocus in the Mac App Store?
If so, try with this line:
property pstrDBPath : "~/Library/Containers/com.omnigroup.OmniFocus2.MacAppStore/Data/Library/Caches/com.omnigroup.OmniFocus2.MacAppStore/OmniFocusDatabase2"

If not:

property pstrDBPath : "$HOME/Library/Containers/com.omnigroup.OmniFocus2/Data/Library/Caches/com.omnigroup.OmniFocus2/OmniFocusDatabase2"

I hope that helps. Let me know if it works.

bkruisdijk · September 2, 2017, 4:22am

Thank you very much for your quick reply and answer. It is great to have such supportive people, willing to help!

Your suggestions helped and everything is working now!

unlocked2412 · September 2, 2017, 8:42pm

That’s fantastic! You’re welcome. I’m glad I could help.

Splinky · December 29, 2017, 2:53pm

I’m working through adding this to my system, but I’m having trouble trying to get KM to recognise the area of the OF note to activate a switch to either DevonThink or OmniOutliner.

It seems that KM just can’t ‘see’ the text image to be able to activate the click action.

I’ve tried taking my own screenshot and replacing the built-in as well as mucking around with fuzziness, but it’s not working.

Any ideas?

Splinky · December 30, 2017, 10:31am

To respond to my own thread to help others; I discovered that I had to recreate the screenshots of the text in KM - I think my font must have been different.

I also went into System Preferences and toggled the reduce transparency setting to prevent colour bleed - although not sure this has any impact, to be honest.

Now, though, with my own screenshot, the text is recognised consistently and the script works.

I used the Rob Trew versions back in OF1 days, and it’s nice to have them back again!

unlocked2412 · December 30, 2017, 4:07pm

If you like, I am leaving here two scripts I wrote in JXA to open DT link and OO link

Usage:

Select a project
Run script (or use a KM Execute Javascript Action)

P.S.: In one of the above posts, there is an AppleScript version.

(() => {
	// Data List JS ----------------------------------------------------------

	// bindMay (>>=) :: Maybe a -> (a -> Maybe b) -> Maybe b
	const bindMay = (mb, mf) =>
		mb.nothing ? mb : mf(mb.just);

	// just :: a -> Just a
	const just = x => ({
		nothing: false,
		just: x
	});

	// nothing :: () -> Nothing
	const nothing = (optionalMsg) => ({
		nothing: true,
		msg: optionalMsg
	});

	// OF Functions -----------------------------------
	
	// projectMay :: Window -> Maybe Project
	const projectMay = win => {
		const seln = win.content.selectedTrees.value();
		return seln.length > 0 ?
			(Object.keys(seln[0].properties()).includes('reviewInterval')) ?
			just(seln[0]) : nothing('No projects selected') :
			nothing('No selection')
	}
	
	// linkMay :: OF Project -> URL String
	const linkMay = x => {
		try {
			return {
				nothing: false,
				just: x.note.paragraphs[0].style.attributes['link'].value()
			};
		} catch (e) {
			return {
				nothing: true,
				msg: 'No link in note'
			};
		}
	};

	// groupMay :: URL String -> maybe DT record
	const groupMay = x => {
		const strUUID = x.split('//')[1]
		return dt.getRecordWithUuid(strUUID) == null ?
			nothing('') :
			just(x)
	};

	// MAIN
	const
		ca = Application.currentApplication(),
		sa = (ca.includeStandardAdditions = true, ca),
		dt = Application('DEVONthink Pro'),
		of = Application('OmniFocus'),
		oDoc = of.defaultDocument,
		oWin = oDoc.documentWindows[0];
		
	const mb = bindMay(bindMay(projectMay(oWin), linkMay), groupMay)
	return (mb.nothing) ? mb.msg : ca.openLocation(mb.just)
})();

Open OO Link Code

(() => {
    // Data List JS ----------------------------------------------------------

    // bindMay (>>=) :: Maybe a -> (a -> Maybe b) -> Maybe b
    const bindMay = (mb, mf) =>
        mb.nothing ? mb : mf(mb.just);

    // Data List JS ----------------------------------------------------------

    // just :: a -> Just a
    const just = x => ({
        nothing: false,
        just: x
    });

    // nothing :: () -> Nothing
    const nothing = (optionalMsg) => ({
        nothing: true,
        msg: optionalMsg
    });
    // OF Functions -----------------------------------
    
    // projectMay :: Window -> Maybe Project
    const projectMay = win => {
        const seln = win.content.selectedTrees.value();
        return seln.length > 0 ?
            (Object.keys(seln[0].properties()).includes('reviewInterval')) ?
            just(seln[0]) : nothing('No projects selected') :
            nothing('No selection')
    }
    
    // linkMay :: OF Project -> URL String
    const linkMay = x => {
        try {
            return {
                nothing: false,
                just: x.note.paragraphs[2].style.attributes['link'].value()
            };
        } catch (e) {
            return {
                nothing: true,
                msg: 'No link in note'
            };
        }
    };

    // groupMay :: URL String -> maybe DT record
    const groupMay = x => {
        const strUUID = x.split('//')[1]
        return dt.getRecordWithUuid(strUUID) == null ?
            nothing('') :
            just(x)
    };

    // MAIN
    const
        ca = Application.currentApplication(),
        sa = (ca.includeStandardAdditions = true, ca),
        dt = Application('DEVONthink Pro'),
        of = Application('OmniFocus'),
        oDoc = of.defaultDocument,
        oWin = oDoc.documentWindows[0];
        
    const mb = bindMay(bindMay(projectMay(oWin), linkMay), groupMay)
    return (mb.nothing) ? mb.msg : ca.openLocation(mb.just)
})();

Splinky · December 31, 2017, 6:48am

I’ve tried using this Interactive Inbox script, but I get an error upon compile

Can't get script "omnifocus"

This is triggered by line 3 of the script.

Can you suggest what I need to do to fix it?

TheWart · December 31, 2017, 12:55pm

In looking for an answer, I dug some more and found that the Interactive Inbox script is the work of Brandon Pittman. I forgot that he had a “library” script that needed to be placed in an OF directory for the inbox script to work. You can find directions at the link above.

Splinky · December 31, 2017, 2:43pm

Thank you so much; that did the trick!

bkruisdijk · May 28, 2019, 12:54am

The script broke down, I do not know why. I get the following error:

/Users/bertkruisdijk/Library/Application Scripts/com.omnigroup.OmniFocus3.MacAppStore/DTPO.scptd: execution error: OmniFocus kreeg een fout: Error: near “Support”: syntax error (1)\

I have tried to find answers/ solutions but not succeeded. Can somebody give me a hint?

unlocked2412 · May 28, 2019, 1:33am

Your path contains a space (near “Support”), and what happens is explained here:

Mac Automation Scripting Guide

Quoting Strings
The shell uses space characters to separate parameters and gives special meaning to certain punctuation marks, such as $ , ( , ) , and * . To ensure that strings are treated as expected—for example, spaces aren’t seen as delimiters—it’s best to wrap strings in quotes. This process is known as quoting . If your string contains quotes, they must also be escaped (preceded by a / character) so they are interpreted as part of the string.

set thePath to "/Library/Application Support/"
do shell script "ls " & thePath
--> Result: error "ls: /Library/Application: No such file or directory\rls: Support: No such file or directory" number 1

It’s necessary to properly quote the string in order to run a shell script.

Change this line:

set strNoteXML to do shell script "sqlite3 " & pstrDBPath & space & quoted form of strQuery

to this line of code…

set strNoteXML to do shell script "sqlite3 " & quoted form of pstrDBPath & space & quoted form of strQuery

bkruisdijk · May 29, 2019, 7:29am

Thank you very much for this. It solved the problem I was facing. Again thanks for your effort!!

I am now encountering a new problem:

I am using this path:
property pstrDBPath : “~/Library/Containers/com.omnigroup.OmniFocus3.MacAppStore/Data/Library/Application Support/OmniFocus/OmniFocus Caches⁨/OmniFocusDatabase”

Is this not working anymore because the database is encrypted?

unlocked2412 · May 29, 2019, 12:26pm

You are welcome.

The problem is your path contains a tilde ~ and it does not expand automatically. Use full path, instead.

Tell me if you have any remaining issues.

bkruisdijk · May 29, 2019, 6:48pm

I have tried the following path:

property pstrDBPath : "$HOME/Library/Containers/com.omnigroup.OmniFocus3.MacAppStore/Data/Library/Caches/com.omnigroup.OmniFocus3.MacAppStore/OmniFocusDatabase"

This is not working.

I have also tried the following:
property pstrDBPath : "Macintosh HD/Users⁩/bertkruisdijk⁩/Library⁩/Containers⁩/com.omnigroup.OmniFocus3.MacAppStore⁩/Data⁩/Library⁩/Application Support⁩/OmniFocus⁩/⁨OmniFocus Caches⁩/OmniFocusDatabase

This was also not successful. I have looked for other possibilities but I am stuck. Can you give me a hint?

Nick · May 29, 2019, 8:41pm

This looks similar to disk access permissions issues I’ve seen with other apps. In Preferences, Security and Privacy, Privacy tab, give AppleScript all disk access. That might help

bkruisdijk · May 29, 2019, 9:12pm

Thanks Nick, I have tried this but is not the solution for me.

unlocked2412 · May 29, 2019, 9:32pm

I can help, of course.

Try with this line:

property pstrDBPath : "/Users⁩/bertkruisdijk⁩/Library⁩/Containers⁩/com.omnigroup.OmniFocus3.MacAppStore⁩/Data⁩/Library⁩/Application Support⁩/OmniFocus⁩/⁨OmniFocus Caches⁩/OmniFocusDatabase"

Your path didn’t have an end quote.

draft8 · May 30, 2019, 11:43am

As a footnote, see under Posix file paths in the AppleScript documentation here:

Note that:

the $HOME and ~ prefixes are understood (and automatically expanded, given the right quote marks) in Terminal.app (the Bash shell), but are not part of AppleScript.
The Macintosh HD prefix is recognised by the legacy colon-separated file path references (also described in the link above), but is not part of the default (forward slash delimited) Posix file path references.

bkruisdijk · May 31, 2019, 6:14am

Thanks for your help. I did paste the line but the problem persist. Do you have any other idea’s or suggestions. Your splendid help is welcome here.