topic Import Image from URL into Expression Column in Discussions

Import Image from URL into Expression Column

robot — Mon, 14 Dec 2015 02:02:56 GMT

I am trying to use the new Expression Role column in JMP12 to organize some images. I can drag an image into a cell from a webpage, but I would like to use a formula to add an image with a known URL pattern.

If I drag an image into the cell, I get a cell of the form,

New Image(Char To Blob( " /* bunch of stuff */ ", "base64compressed" ), "jpeg")

, but this requires me to manually drag each image into the data table. Can I add an image into a data table cell using a formula directly from the URL location? Something like:

New Image(" http://www.sas.com/content/dam/jmp/images/design/social-share/jmp-com-share.jpg ") // ?

Re: Import Image from URL into Expression Column

ms — Mon, 14 Dec 2015 07:20:26 GMT

New Image(Open(URL)); seems to work.

Example:

New Table("test", Add Rows(1), New Column("Image", Expression));

:Image[1] = New Image(

Open(

"http://www.sas.com/content/dam/jmp/images/design/social-share/jmp-com-share.jpg "

)

);

Re: Import Image from URL into Expression Column

robot — Mon, 14 Dec 2015 15:24:01 GMT

Thanks MS.

Re: Import Image from URL into Expression Column

morenopelaez_p — Mon, 04 Jan 2016 13:31:15 GMT

This is fantastic! Just what I was looking for!

I am not very knowledgeable in JSL, maybe someone can help me modify the proposed script to my need...

I modified the above to import an image from my computer resulting in:

New Table("test", Add Rows(1), New Column("Image", Expression));

:Image[1] = New Image("C:\Photos\Capture.png"

);

What I would love to have is a JSL script that I can save into an existing table and that, when run, would do the following:

- Look at table variable "Location" and read the folder path of the images I will want to import. Lets say this is "C:\Photos"

- Look at column 1 and read the content of cell 1 which is the name of the first image to import. lets say this is "holiday1"

- Join the path and the image name to plug it into the above script to import the image in cell 1 of "column 2"

- Loop through all the rows to import all the images.

It sounds feasible to me, just I do not know how to script many parts of the code. I am going to start researching on how to write this but if someone gets to a solution...:)

Thanks!

Re: Import Image from URL into Expression Column

msharp — Mon, 04 Jan 2016 17:54:19 GMT

You don't need a loop and this is faster anyways:

dt = New Table("test", Add Rows(1),

New Column("ImageTitle", Character, Nominal, Set Values({"Capture"})),

New Column("Image", Expression, Formula(New Image(dt:Location || :ImageTitle || ".png")))

);

dt << Set Table Variable("Location", "C:\Photos\");

Image with path C:\Photos\Capture.png will be displayed in column 2 (:Image)

Re: Import Image from URL into Expression Column

morenopelaez_p — Tue, 05 Jan 2016 16:05:33 GMT

Fantastic! That is exactly what I was looking for.

Thanks a lot for the help @msharp !