topic Open Local Image In Expression Column in Discussions

Open Local Image In Expression Column

robot — Mon, 21 Dec 2015 19:48:05 GMT

Hi,

I am trying to import some images into a data table using an Expression Column in JMP12. I am able to import an image from URL, but when I try the same technique on a local image, JMP12 will open the image rather than import it into the data table. Does anyone have any idea what is causing this difference how to resolve it? Thanks!

Names Default To Here( 1 );

dt = New Table( "Image Test",

Add Rows( 1 ),

New Column( "Image from URL",

Expression,

Formula( New Image( Open( "http://eits.uga.edu/_resources/files/images/JMP_logo.png" ) ) )

New Column( "Local Image",

Expression,

Formula( New Image( Open( "C:\Program Files\SAS\JMP\12\Samples\Images\tile.jpg" ) ) )

);

Re: Open Local Image In Expression Column

Craige_Hales — Mon, 21 Dec 2015 20:44:21 GMT

add the type argument to the open function.

Formula( New Image( Open( "$desktop/circle.png", "png" ) ) )

it will probably work OK even if you mix'n'match png, jpg, gif because the 2nd argument is mostly telling open not to pass the file to the OS default program but to turn it into an image if possible.

Re: Open Local Image In Expression Column

robot — Mon, 21 Dec 2015 21:31:43 GMT

Thanks Craige@JMP. That works.

One complication is that if I replace the <type> argument with a column reference, it seems to no longer work. Do you know why?

Names Default To Here( 1 );

dt = New Table( "Image Test",

Add Rows( 1 ),

New Column( "Image Type", Character, Nominal, Set Values( {"png"} ) ),

New Column( "Image from URL",

Expression,

Formula(

New Image( Open( "http://eits.uga.edu/_resources/files/images/JMP_logo.png", :Image Type ) )

)

New Column( "Local Image",

Expression,

Formula( New Image( Open( "$desktop/circle.png", :Image Type ) ) )

)

);

Re: Open Local Image In Expression Column

Craige_Hales — Tue, 22 Dec 2015 13:19:38 GMT

I'm not where I can look at the JMP source, but it's possible it is being treated like a keyword and not a variable. I'm pretty certain you can just use "png" even for a .jpg.

Re: Open Local Image In Expression Column

txnelson — Tue, 22 Dec 2015 15:20:18 GMT

try changing the formula to:

New Image( Open("http://cits.uga.edu/_resources/files/images/JMP-logo.png",Eval(Parse(char(:Image Type[Row()]) )) ) )

This should force the proper evaluation

Re: Open Local Image In Expression Column

robot — Tue, 22 Dec 2015 15:41:44 GMT

Thanks txnelson and Craige@JMP. Both methods worked.