Subscribe Bookmark RSS Feed
M_Anderson

Staff

Joined:

Nov 21, 2014

Adding Images to A Data Table From a Directory

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!

M_Anderson

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

M_Anderson
And what is the file type of the images?
juna1

it`s tif file, and i use windows

M_Anderson
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?

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

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

 

Article Tags
Contributors