topic Re: Automate copying table scripts when rerunning "source" in Discussions

Automate copying table scripts when rerunning "source"

sowiakg — Fri, 23 Aug 2024 19:28:23 GMT

Hi,

I am creating a database in Excel that will be continually updated. New rows and columns will be added periodically, and existing rows will occasionally have new data added. As such I have started making use of the "Source" script to update the corresponding downstream JMP table.

The question I have is, is there a way to bring over any existing table scripts to the updated table when running the Source script? I have a number of graph builder scripts saved to the JMP table and would like to automatically copy them over to the new table each time the Source script is run. I use JMP version 17.

Thank you!

Re: Automate copying table scripts when rerunning "source"

txnelson — Fri, 23 Aug 2024 21:03:16 GMT

Welcome to the community.

Here is an example of the code required to copy all of the table scripts from one data table to another, minus the Source table script.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
names=dt<<get table Script names;
remove from(names,1,1);
dt << Select Properties( names );
proplist = dt << Get Selected Properties();
dt2 = New Table( "Little Class" );
dt2 << Add scripts to table( proplist );

You would have to add this methodology to your Source script, or run it as a separate script to do what you are trying to do.

You can find details and examples of the different elements in this script in the Scripting Index under the Help pull down menu

Re: Automate copying table scripts when rerunning "source"

jthi — Sat, 24 Aug 2024 05:15:42 GMT

Here is other option

Names Default To Here(1);

// Depending on your source script, there are different options of handling
// getting the reference to dt1 and dt2
dt1 = Open("$SAMPLE_DATA/Big Class.jmp");
dt2 = Open("$SAMPLE_DATA/Big Class Families.jmp");

dt2 << Delete Scripts(dt2 << Get Table Script Names); // for demo purposes
wait(1); // for demo purposes

t_scripts = dt1 << Get Table Script Names;
Remove From(t_scripts, Contains(t_scripts, "Source"), 1);

For Each({t_script}, t_scripts,
	Eval(EvalExpr(
		dt2 << New Script(t_script,
			Expr(dt1 << Get Script(t_script));
		);
	));
);
wait(0);

Re: Automate copying table scripts when rerunning "source"

hogi — Tue, 15 Oct 2024 20:27:37 GMT

Another approach:
Upgrade to JMP 18, it's free for all licensed users.

In JMP 18, besides the Source Script, there is an Update Script:

which will update the table itself - insted of creating a new one. Manually added scripts stay.

Pros of "Update Table" compared to "Source Scripts:
Source Scripts are "fragile" - JMP overwrites them without warning:

Cons:
Update Table removes any manually added column

https://community.jmp.com/t5/JMP-Wish-List/Wizard-to-update-Excel-files-in-place-no-code-solution/idc-p/761983/highlight/true#M5540

Re: Automate copying table scripts when rerunning "source"

Thomas_Kilmer — Tue, 15 Oct 2024 14:20:11 GMT

I know I just left another comment saying how I see your JMP help everywhere and it's really appreciated. But seriously. I see your help everywhere and it's so useful. Thanks for all you do to help people out.