topic How do I let user select their files to open via JSL? in Discussions

How do I let user select their files to open via JSL?

Sukanyap — Sun, 11 Jun 2023 12:02:11 GMT

Hi All,

As I'm new user to JMP, I want to know how do I open any csv file without specifying any folder in the JSL script.

I have saved this script from data table but instead of opening the folder and hence csv file from here I want the users to select folder and open any csv like in below image.

Thanks !

Re: How do I let user select their files to open via JSL?

Sukanyap — Sun, 11 Jun 2023 12:14:00 GMT

One more I want to add is I tried "Pick File" to select any folder and open the csv file but it is throwing error as below

Re: How do I let user select their files to open via JSL?

txnelson — Sun, 11 Jun 2023 12:23:16 GMT

The simplest form of what you specified you need is:

Names Default To Here( 1 );
file = Pick File(
	"Select csv File",
	"$HOME",
	{"csv Files|csv", "All Files|*"},
	1,
	0
);
If( file != "",
	dt = Open( file )
);

Look in the Scripting Index for the definitions and examples of the Pick File and Open functions.

Re: How do I let user select their files to open via JSL?

Sukanyap — Sun, 11 Jun 2023 15:42:47 GMT

Thanks it worked

Re: How do I let user select their files to open via JSL?

Sukanyap — Fri, 23 Jun 2023 10:24:51 GMT

Hi txnelson,

Your commands helped me, but now since we're directly opening any data table it seems JMP is not reading the change in data types of the user density here arrow marked. Originally the data type of "user density" is "numeric and continuous" but in my JSL i changed it to character and nominal, but it seems JMP is not reading this, since we're opening the data table directly

Can you please help me here, how do I make JMP possible to ready my changes, it is needed in my plotting and data processing

Re: How do I let user select their files to open via JSL?

txnelson — Fri, 23 Jun 2023 11:56:30 GMT

It is not really to debug your issue without having your data files. I suggest you use the Excel Wizard on the files that are not being handled correctly. The wizard should give you some insight on how JMP is interpreting your files.