cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Adding Images to A Data Table From a Directory

*DEPRECATED*

This is now possible to be done natively in JMP 14 through the Multiple File Import capability (Documentation)

 

This is a little script to add a bunch of images from a directory to a data table.  It expects that the image names will be in a column in the data table.  It will then create a new expression column with a formula that pulls the images in.  As written, it expects that the images and the data table are in the same directory, but that could be easily changed.

 

To make the data table portable (i.e., no longer needing to be in the same directory as the images), simply remove the formula from the expression column after it has finished pulling in the images.  

Comments
juna1

hi Anderson

 

it works in JMP 13, or also other version. because i can`t get what you mentioned in JMP12.

All column shows  Empty().

can you give more details, i don`t know if my operation was wrong or not.

thanks!

The expression column should work with JMP 12.  My guess is that there is something up the formatting of your file paths.  Can you provide an example of the table you are trying to run the script on?  Also, are you working on mac or windows?

 

M

juna1

Hi

this the way of my floder including JMP file and picture.

C:\Users\Juna\Desktop\New folder

 

 tabletableCapture1.PNG

And what is the file type of the images?
juna1

it`s tif file, and i use windows

Okay - I missed this in the data table. You need the file path information in the “Response” column. So, the two entries should be

C:\Users\Juna\Desktop\New folder\aa
C:\Users\Juna\Desktop\New folder\Desert
juna1

sorry, it`s still not worked.  

is there other person who use it ok?

Yup - I’ve used it a few times with several people.

Oh, good grief… Sorry - I’m coming off of vacation.  Your screen shot has the answer.  Note that the formula in the “micrograph” column is referencing a column called “Image”… Your table doesn’t have an “Image” column.  You need to either change the “Image” in the formula to match the column name that has the image path or change the column name in the table to be “Image."

juna1

thanks for your help. but it seems it not work on my part.

but i have found another way to add pictures into a table, also for many rows in below topic.

 

https://community.jmp.com/t5/Discussions/Open-Local-Image-In-Expression-Column/td-p/16028