nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JMP 15 AppleScript Run Program()

john_madden

I've never used Run Program() before, and I need some help. Since JMP can't open password-protected Excel files, I'm working up a little Applescript to open them and export them as unprotected .csv. I'd like to run this Applescript from within a JSL script. Maybe if it works well, I'll create a little JMP user function to wrap it, so I can simulate in JMP the ability to open password-protected Excel.

BUT…I'm having trouble wrangling Run Program(). A few questions.

1. Should my Applescript be saved as an application (.app extension) or as a script (.scpt extension).

2. My JSL syntax looks like this:

Run Program( Executable( "Users/me/Desktop/myscript.scpt" ) )

but it doesn't work, giving the following error:

launch path not accessible in access or evaluation of 'Glue' , Names Default To Here( 1 ); /*###*/Run Program(
	Executable( "/Users/me/Desktop/re.scpt" )
) /*###*/;

In the following script, error marked by /*###*/
Names Default To Here( 1 ); /*###*/Run Program(
	Executable( "/Users/me/Desktop/re.scpt" )
) /*###*/;

Again, I've tried using .app and .scpt and no extension at all -- no joy.

Obviously, I'm going to have to add in some additional code to get a handle on the resulting .csv export file, but for now, I just need to get off the ground with running a barebones Applescript at all.

Thanks for any help.

Accepted answers

jules

Hi @john_madden,

I would save your script as .app, and then use something like the following to open that application, which uses the 'open' executable to open the .app:

Run Program(
	Executable( "/usr/bin/open"),
	options( {"/users/me/Desktop/myscript.app"} )
);

I hope this helps get you started!

@jules

All comments

jules

Hi @john_madden,

I would save your script as .app, and then use something like the following to open that application, which uses the 'open' executable to open the .app:

Run Program(
	Executable( "/usr/bin/open"),
	options( {"/users/me/Desktop/myscript.app"} )
);

I hope this helps get you started!

@jules

john_madden

Perfect!! Thanks!!!

john_madden

Just a little followup on this, maybe some Mac users might find useful.

The Applescript idea didn't work out -- not because of JSL, but because of limitations in MSExcel applescripting under OSX 10.15. (Save commands in Excel no longer work right, apparently due to sandboxing; I'm told Microsoft needs to update its Applescript support. )

Instead, I decided to script what I needed using Keyboard Maestro (KM), which is a very fine OSX scripting/macro app. (I recommend it highly -- I have no conflicts of interest.)

I wrote the script I needed in KM. Then I wrote a little JSL function that invokes a KM script:

Add Custom Functions(
	New Custom Function(
		"ex",
		"Run KMScript",
		Function( {scriptID, paramlist = {}},
			{paramstring},
			paramstring = Concat Items( paramlist );
			Run Program(
				Executable( "/usr/bin/osascript" ),
				Options(
					"-e tell application \!"Keyboard Maestro Engine\!" to do script \!"" || scriptID || "\!" with parameter \!"" || paramstring ||
					"\!""
				)
			);
		)
	) << Prototype( "ex:Run KMScript( scriptID as string, < {param1 as string, param2 as string, etc.} > )" ) << Parameter( "String", "scriptID" ) <<
	Parameter( "List", "parameter(s)" ) << Formula Category( "Utility" ) << Description(
		"Runs a Keyboard Maestro script. The KM scriptID is a UUID; you can reveal and copy it by opening the 'Or trigger by shell script' text box at the top of your KM macro window. The (optional) parameters to the KM script can be retrieved inside the KM macro using the KM '%TriggerValue' token. KM receives them as a single concatenated string of space-separated values."
	)
);

Right now, I'm using this within my JSL to invoke a KM macro that opens the protected Excel file in Numbers, unprotects it, saves it as csv, opens it in JMP, then closes Numbers. It works fine.

Hope somebody else might find this useful.

jules

This is fantastic, John! So glad you shared this, I’m positive it will be helpful to someone.

@jules