topic Open data tables from file dialog in Discussions

Open data tables from file dialog

kca — Thu, 01 Dec 2011 20:08:12 GMT

Is there a file open dialog box where I can select several files and have it return a list of files for my JSL script to operate on? I would prefer to have the standard Windows one that one sees when they press File > Open in JMP.

Edit: 'Pick File' is the command I was looking for.

Open data tables from file dialog

ms — Thu, 01 Dec 2011 21:29:06 GMT

The dialog that comes up when running Open(), or Pick File(), looks exactly like a standard File > Open dialog (at least in JMP 9 on the Mac) but it seems to be limited. In contrast to the standard open-dialog only one file can be selected in the open-dialog called from JSL.

In Mac OS X I haven't found a way to open the standard dialog from script, but it may be possible on Windows where JMP can call dll-files. I am not of much help in that area but there som amazing examples in other threads of what can be done via dll.

If you would find a way to do that, the code below can be used to get a list of the names of the last opened data tables.

nr_of_already_open_tables = N Table;

Open( );// some clever dll funcion or similar

last_opened_tables = Local( {i, d = {}},

For( i = 1, i <= N Table() - nr_of_already_open_tables, i++,

d[i] = Data Table( i ) << GetName

);

Open data tables from file dialog

kca — Fri, 02 Dec 2011 16:27:38 GMT

Thanks, MS. You are right that even on Windows I can only select a single file. However, it turned out that is all the functionality I need. Your code snipet did come in quite handy after that!