Table Scripts

You can prompt to open a table script named On Open or OnOpen when the data table opens. The choice is remembered each time you open the data table in the current JMP session.

To create an On Open script, perform one of the following actions:

•

Create the script using the Save Script > To Data Table option, and then double-click the property name and change the name to On Open.

•

Store the script using a New Script message.

In this example, you create an OnOpen script in Big Class.jmp.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Script(

"OnOpen", // create the script

sortedDt = Data Table( "Big Class" ) << Sort( By( :name ), Output Table Name( "Sorted Big Class" ) ) // sort the data and put it in a new data table

);

The JMP preference called Evaluate OnOpen Scripts determines when the script runs. By default, the user is prompted to run the script. You can set the preference to always run the On Open script or to prevent it from running:

Preference( Evaluate OnOpen Scripts( "always" ) );

Preference( Evaluate OnOpen Scripts( "never" ) );

Preference( Evaluate OnOpen Scripts( "prompt" ) ); // default setting

On Open scripts that execute other programs are never run. As a safety precaution, you might consider suppressing automatic execution when opening data tables that you receive from others.

注意：

•

If the OnOpen script is in a downloaded data table, you must specify Quarantine Action( "Allow Scripts" ) in the Open() expression to run the OnOpen script automatically. See Options for Downloaded Data Tables that Contain Scripts.

•

When you create a new data table in a script and include the On Open() function, On Open() is called after the data table is created.

•

Some operations in an OnOpen script are considered unsafe, such as saving the current data table. Run an external script to open that table instead of opening a table to run the OnOpen script.

Work with Groups of Table Scripts

Suppose that you want to put related table scripts in a group to save room in the list of data table scripts. Use Group Scripts, specify the group name, and then specify the script names to put in the group.

dt = Open( "$SAMPLE_DATA/San Francisco Crime.jmp" );

dt << Group Scripts(

"Maps",

{"Bubble Plot Street Map", "Graph Builder Street Map: Traffic Incidents",

"Graph Builder Street Map Zoomed"}

);

dt << Group Scripts(

"Tabulate",

{"Tabulate: Category and Description", "Tabulate: Category, Summary, Percentage",

"Tabulate: Category and Resolution", "Tabulate: Resolution and Description"}

);

Move a Script Group

Move Script Group rearranges the table script groups using the to first, to last, after(script), and after(group) arguments:

dt << Move Script Group( "Tabulate", after( "Maps" ) );

dt << Move Script Group( "Tabulate", to last);

Get Groups and Group Names

To get the list of table scripts in the group, use Get Script Group. Then you can perform an operation such as running a script in the group.

tb = dt << Get Script Group( "Tabulate" );

dt << Run Script( tb[2] ); // runs the second script in the Tabulate group

Get Script Groups Names returns the group names in a list:

gn = dt << Get Script Groups Names; // returns {"Maps", "Tabulate"}

dt << Move Script Group(gn[1], to last);

// moves the Maps group to the end of the table scripts

Select a Script Group

Select Script Group selects the named table script group, a list of scripts in a group, or all scripts.

dt << Select Script Group; // selects all scripts groups

dt << Select Script Group( "Tabulate" ); // selects Tabulate group

dt << Select Script Group( {"Tabulate", "Maps"} // selects both groups

Ungroup Scripts

Ungroup Scripts removes specified table scripts or group from the group. You can send the message to the name of the script group or a list of scripts.

dt << Ungroup Scripts( "Tabulate" );

dt << Ungroup Scripts(

{"Tabulate: Category and Description", "Tabulate: Category, Summary, Percentage",

"Tabulate: Category and Resolution", "Tabulate: Resolution and Description"}

);

Rename a Script Group

You can rename a table script group using Rename Script Group, specifying the existing group name, and specifying the new group name.

dt << Rename Script Group( "Maps", "Street Maps" );

Delete a Script Groups

To delete a table script group, you get it first and then delete it.

a = dt << Get Script Group( "Street Maps" );

dt << Delete Scripts( a );