topic How to refer to data tables within a project? in Discussions

How to refer to data tables within a project?

markschahl — Tue, 03 Sep 2024 08:55:31 GMT

Hi! I have a jmpprj file with multiple tables in it. To make it easier for users, I've created a journal within the project with script buttons to launch specific analyses.

What is the best way to point to the dt in the script below? Open()? Other? If Open(), what is the correct file path (I am planning on sending this jmpprj file to many people and need the script to run "anywhere")
How to ensure the output stays within the project?
Any other tips on scripting within a project?

Thanks in advance, o-talented-JSL-scripters!

Names Default to Here (1);
dt = // how to refer to a given table in this project?
dt << Graph Builder(
	Size( 2165, 1020 ),
	Show Control Panel( 0 ),
	Fit to Window,
	Variables( X( :Platform ), Y( :Equipment.Simplified ) ),
	Elements( Points( X, Y, Legend( 5 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Equipment.Simplified",
			ScaleBox,
			{Label Row( Show Major Grid( 1 ) )}
		),
		Dispatch( {}, "graph title", TextEditBox, {Set Text( "Blah Blah Blah" )} )
	)
);

Re: How to refer to data tables within a project?

jthi — Tue, 03 Sep 2024 09:12:04 GMT

Have you read scripting guide part of projects, https://www.jmp.com/support/help/en/18.0/#page/jmp/creating-projects.shtml# ? Are you storing the data tables to the project (embedded) or are they just "links" (referenced)?

Re: How to refer to data tables within a project?

markschahl — Wed, 04 Sep 2024 00:41:55 GMT

Jarmo:

Thanks for link. I thought that I had exhaustively searched the help...

The data tables are embedded in the project itself. There doesn't seem to be a path variable for "Current Project":
https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/path-variables.shtml#ww361809

Re: How to refer to data tables within a project?

jthi — Wed, 04 Sep 2024 06:05:58 GMT

There is but it is only available inside a project, $PROJECT

Projects have their own a bit weird file "path: "jmpprj://contents/"

I think you can also use Get Default Directory() IF you have saved the script which is running that function inside the project.

Usually I try to script projects just like I would JMP normally (but in reality I try to JMP projects due to few issues they have), but depending where you are writing the JSL, inside or outside of project, it is a bit different.

Re: How to refer to data tables within a project?

markschahl — Wed, 04 Sep 2024 06:35:45 GMT

Jarmo: thanks, it was just what i needed!

Re: How to refer to data tables within a project?

markschahl — Mon, 09 Sep 2024 06:38:45 GMT

Well, accidentally discovered this while hovering over the project contents file list: right click on the file to copy the path...