nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Set MAp Role via script

bobmorrane

Hello,

I am making a script to help beginners set some parameters in a data table, such as table variables and map roles.

The issue is when I set the map role, the file path is not recorded in the column properties

path = pick file ();

dt0:my_column << set property ("Map Role", Map Role ("Shape Name Use" (path), "My_column") ) ) ;

Any ideas what causes this ?

Accepted answers

All comments

bobmorrane

Ok, after fiddling with this for a while, I see where the problem lies :

file paths in Windows look like this C:\user\file.txt

When you extract a path in jmp using pick file (), it converts it to "C:/user/file.txt". I guess this is because JMP considers '\' to be a special character. The weird thing is, in other JSL instructions, you can just use the JMP syntax for file paths but for some reason, Map Role uses the normal Windows syntax.

Now my question is : is there a simple way to convert a JMP file path into a Windows file path ? Something that would avoid the need to write it like this :

"C:\!\user\!\file.txt"

Alternatively, a script that could access the column properties directly and open the prompt t ochoose a file in the map role pane would be useful too.

Thanks

bobmorrane

Ok it looks like I found a solution to this :

dt= open (pick file (), invisible ) ;

path = dt<< get path;

 

dt<<close ;

show (path);

This seems to solve it

Mark_Bailey

Also, I think that the argument with the path is a named argument, not a string, so it looks like this:

dt0:my_column << Set Property ( "Map Role", Map Role( Shape Name Use( path ), "My_column" ) ) ) ;

BTW, JMP uses the POSIX path format by default, not the Windows format. But usually it will automatically convert or you can explicitly call the built-in function to convert between the two formats.

Mark_Bailey

That route is a bit round-about and unnecessary. See this function.

bobmorrane

thanks @Mark_Bailey ,

I learnt something here. I didn't know what Posix was

Searching for POSIX in the Scripting index, I found the conversion function :

path = pick file () ; 

converted_path= Convert File Path (path, windows) ;

Compared to using the <<get path message, this saves the opening of the table.

bobmorrane

So I do I manage to set this property from a text string ?

You said this is " a named argument, not a string ". What does this mean ? I guess this is a downside of JSL, the system being so simple and flexible, users don't know the exact nature of what they are manipulating

I tried the following syntaxes to no avail :

dt0:my_column << Set Property ( "Map Role", Map Role( Shape Name Use(Eval( path) ), "My_column" ) );

dt0:my_column << Set Property ( "Map Role", Map Role( Shape Name Use(Expr( path) ), "My_column" ) );

Eval Expr (dt0:my_column << Set Property ( "Map Role", Map Role( Shape Name Use(Expr( path) ), "My_column" ) ) );

bobmorrane

Ok, finally my script works

For some reason, when I wrote :

dt0:my_column << set property ("Map Role", Map Role (Shape Name Use (path, "my_column" ) ) ;

It wouldn't transfer the string contained in the variable path into the column property. It still wouldn't work when I tried to use Eval(path) and other workarounds. I'm guessing JSL doesn't support evaluating variables Inside this message.

So here is the workaround I found :

My_expression = Eval Expr ( dt0:my_column << set property ("Map Role", Map Role (Shape Name Use (Expr(path), "my_column" ) ) );

Eval (My_expression);

And this finally does the trick!

The step to convert the path from posix to Windows was not necesary in the end, as the column property accepts both formats.