topic Re: row editor in Discussions

row editor

Françoise — Sat, 10 Jun 2023 23:17:12 GMT

Hi,

when we use row editor we have the information on all columns for a line.

Is it possible to configure the row editor only on certain columns and have the photo displayed if we have a column with photos ?

best regards

Re: row editor

txnelson — Mon, 03 Aug 2020 10:22:21 GMT

The Row Editor will display photos

but it always displays all columns. You could write a simple script that would handle your request.I also suggest that you add your request to the JMP Wish List, so it can be reviewed for possible addition to a future release.

Re: row editor

Françoise — Mon, 03 Aug 2020 10:36:44 GMT

hi,

thanks for your answer Jim.

but, the image is too small as in your copy screen.

and how to access to the script of the editor?

I would like to change the size of the image and make a selection for the columns.

best regards

Re: row editor

txnelson — Mon, 03 Aug 2020 11:16:40 GMT

It is my assumption that the Row Editor is a C++ piece of code that does not have a script behind it. You will have to write the script from scratch.

Re: row editor

Françoise — Mon, 03 Aug 2020 13:44:27 GMT

ok Jim, thanks for your answer.

all the best

Re: row editor

nascif_jmp — Tue, 04 Aug 2020 15:34:56 GMT

Hi @Françoise,

This is not exactly what you are asking about but is close: the LabelViewer Addin will show only the labeled columns for a given row, and has support for controlling the size of the images it displays:

I designed it to be launched from a graph hover label, but since it is all based in JSL, it could probably be adapted to be launched directly from the table. It contains a Local Data Filter which you can use to control the scope of the rows displayed. Give it a try and let me know how it goes.

Re: row editor

Françoise — Wed, 05 Aug 2020 06:07:57 GMT

Hi,

thanks for your answer.

I understandt hat I must adapt and use the script "labelviewer.jsl".

is this good?

I start in Scripting and this script seems complicated to me.

It will be difficult to do it !

best regards

Re: row editor

nascif_jmp — Wed, 05 Aug 2020 18:14:44 GMT

@Françoise Fair enough. Please check the Addin page again. I just attached an adapter file named "LabelViewer_dt.jsl". Once you have the Addin installed, you just have to open e execute that script and it will open the LabelViewer window for the current window. It assumes that the data table has at least one labeled column. If you want to see images, their columns have to be labeled also. Here is what it displays for SAS Office:

You can control what is displayed using the filter, number of rows displayed per page, size of the images, and layout (horizontal vs vertical).

Re: row editor

Françoise — Wed, 05 Aug 2020 18:29:40 GMT

Hi,

thanks for your reply, I tested and I have the following message "alert. Nothing to display".

I have several colums labelled.

I have an another question: when I have a file with photos, I import the photos in a column with the expression format in a JMP database. This requires to compress the photos (to avoid a database too big when you have many and many photos), importing them and attaching them to the right line with a common identifier in Jmp. You need time to do it.

Question: Is the hover label editor (than I discover with your message) able to look for a photo in a folder of photos (*.jpeg), to put it inside the hover label for the correct line. It will be more simple and it will avoid a database too big.

we all need to resize the photo inside the hover label.

best regard

Re: row editor

nascif_jmp — Wed, 05 Aug 2020 19:20:26 GMT

Q: "thanks for your reply, I tested and I have the following message "alert. Nothing to display".

I have several colums labelled."

A: This is because it picks up the first labelled column it finds to build a data filter. I just found out that this approach does not work for picture columns. A simple solution is to open the table and reorder the columns so that the first label column from left to right has a categorical or numerical type. I will code something more robust later. Once the LabelViewer window is up you can change the filter.

Q: "Question: Is the hover label editor (than I discover with your message) able to look for a photo in a folder of photos (*.jpeg), to put it inside the hover label for the correct line. It will be more simple and it will avoid a database too big."

A:Yes. It can even fetch pictures from a web site. But that needs a bit of JSL. There is an example showing how to get images from Wikipedia here:

https://community.jmp.com/t5/JMP-Scripts/WikiReader-Augmenting-Hover-Labels-with-web-data-and-images/ta-p/237488

Documentation is here:

https://www.jmp.com/support/help/en/15.2/index.shtml#page/jmp/add-graphs-or-images-to-hover-labels-using-graphlets.shtml#ww599909

A simple example of displaying an image from disk would use the Picture attribute of the Set Graphlet command to build the image file name from the execution context (which includes the values of the labeled variables), open it and pass the result to a PictureBox, like so:

Set Graphlet(
  Picture(PictureBox(Open( cwd || local:_Species || ".jpg", "jpg"))),
  Click(Web( "file://" || cwd || local:_Species || ".jpg" ))
)

Please see the attached IrisLocalImages.zip for a complete example.

Re: row editor

Françoise — Thu, 06 Aug 2020 06:45:33 GMT

Hi,

thanks for your answer.

For the first question, it is OK.

At the scale at 0.5, the image is too large.

is it possible to have less scale?

for the second question, I shall try it through your example.

all the best!

Re: row editor

nascif_jmp — Thu, 06 Aug 2020 13:44:31 GMT

"Is it possible to have less scale?"
It is, but it requires a change to the Addin. I will post a new version later, and integrate the adapter to it.

"I shall try it through your example."
Great. Let us know how it goes. Post a screenshot if you can! :)