JMP Wish List

I'd like to request an ability to convert an excel file to a text file through JSL without having to open the excel file first.  This would greatly speed up daily reports that have to reference excel files (fyi: an excel file currently takes 30 seconds to open but the same file as a text CSV file opens in a second).  Something along the lines of Copy(source, tabs, starting row, starting col, ending row, ending col).   This was brought up in this discussion post as well: https://community.jmp.com/t5/Discussions/Save-xlsx-to-csv-file/m-p/36763   Thanks for considering it! Steve ... View more

In the script editor, I would like to have the ability split the window so that I can see 3 or more sections of my code at once.  That is, when right-clicking on the line numbers on the left of the script editor and selecting "Split", I would like the option to specify how many splits I would like to have.   Often I find myself needing to compare 3 or more sections of code to each other.  Adding this feature would make this task much simpler.  I would hope implementing this would be relatively easy. ... View more

Add function to round to even / preference to change default rounding used by JMP (to my understanding both Python and R follow IEEE 754 and round to even by default). Also add Teaching Script to demonstrate the effect of rounding to even vs rounding to nearest. To my understanding round-to-even is the default behaviour for example in IEEE 754 - Rounding Rules (wikipedia.org)  Rounding to nearest should reduce bias when calculating aggregated statistics such as sum and mean from rounded values.   Below is example script (might not be the best demonstration...): Names Default To Here(1); // https://en.wikipedia.org/wiki/IEEE_754#Rounding_rules // https://blogs.sas.com/content/iml/2019/11/11/round-to-even.html // https://stackoverflow.com/questions/311696/why-does-net-use-bankers-rounding-as-default row_count = 400; dt = New Table("Bankers_demo", Add Rows(row_count), New Column("TrueValue", Numeric, Continuous, Formula(0.25 * (Row() - 100)))); dt << New Column("RoundToNearest", Numeric, Continuous, Formula(Round(:TrueValue, 0))); dt << New Column("RoundToEven", Numeric, Continuous, Formula( l = Words(Char(:TrueValue), "."); If(N Items(l) == 1, :TrueValue, If(l[2] == "5", If(Modulo(Num(l[1]), 2), Ceiling(:TrueValue), Floor(:TrueValue) ), Round(:TrueValue, 0) ) ); ) ); dt << New Column("TrueSum", Numeric, Continuous, Formula(Col Cumulative Sum(:TrueValue))); dt << New Column("NearestSum", Numeric, Continuous, Formula(Col Cumulative Sum(:RoundToNearest))); dt << New Column("EvenSum", Numeric, Continuous, Formula(Col Cumulative Sum(:RoundToEven))); dt << New Column("ErrorNearest", Numeric, Continuous, Formula(Abs(:TrueSum - :NearestSum))); dt << New Column("ErrorEven", Numeric, Continuous, Formula(Abs(:TrueSum - :EvenSum))); dt << New Column("TrueAvg", Numeric, Continuous, Formula(:TrueSum / Row())); dt << New Column("NearestAvg", Numeric, Continuous, Formula(:NearestSum / Row())); dt << New Column("EvenAvg", Numeric, Continuous, Formula(:EvenSum / Row())); nw = New Window("Rounding", H List Box( Panel Box("Actions", Button Box("Add Row", dt << Add Rows(1, At End)), Button Box("Add 10 Rows", dt << Add Rows(10, At End)), Button Box("Add 100 Rows", dt << Add Rows(100, At End)), Button Box("Add 1000 Rows", dt << Add Rows(1000, At End)) ), gb = dt << Graph Builder( Size(528, 456), Show Control Panel(0), Variables(X(:TrueValue), Y(:ErrorNearest, Position(1)), Y(:ErrorEven, Position(1))), Elements(Points(X, Y(1), Y(2), Y(3), Legend(3)), Line(X, Y(1), Y(2), Y(3), Legend(5))), Local Data Filter(Add Filter(columns(:TrueValue))), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 3, Base(0, 0, 0, Item ID("TrueSum", 1)), Base(1, 0, 0, Item ID("NearestSum", 1)), Base(2, 0, 0, Item ID("EvenSum", 1)) )} ) ) ), Tabulate( Show Control Panel(0), Add Table(Column Table(Statistics(Sum, Mean)), Row Table(Analysis Columns(:TrueValue, :RoundToNearest, :RoundToEven))) ) ), << On Close(Try(Close(dt, No Save))) );     ... View more

I proposed that JMP deal with display elements the same manner as every other GUI framework -- don't redraw any element unless the contents have changed or a specific redraw (or inval) method is invoked.   Specifically, can there please be a way to keep frameboxes from redrawing the content (this includes redrawing all data points and re-running any attached script) whenever a window is scrolled?  Like seriously, draw once and keep the bitmap (or pixmap) persistent unless the box has been changed (size change / dt RowState change / inval method)   This is an insanely extreme productivity kill when scrolling through graphs that have many thousands of points or complex attached scripts.  The current method of "redraw at every possible opportunity no matter what" is extremely baffling.   Here is an example -- the attached scrip merely prints to the log, but scrolling through the graphs shows how it is constantly running every time the scroll box updates (don't propagate the <<inval method to child boxes, ffs)   New Window( "Test", vlb = V List Box() ); ::global function = Function( {}, Print( 1 ); ); For( i = 1, i <= 20, i++, vlb << Append( Graph Box( Frame Size( 200, 200 ), X Scale( -100, 100 ), Y Scale( -100, 100 ), ::global function ) ) ) ... View more

Expose as many as possible GUI features through JSL. Specifically, in this case, 'new formula column'. ... View more

Expose the GUI search and replace to JSL. ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it     The "Help Scripting Index" entry in the right click context menu is very helpful to open the scripting index info for a JSL object or function. Is there also such a fast way to run "show properties" for a JSL object - perhaps with a possibility to select one property and use it directly in my code ( e.g. auto-send to clipboard to paste it at the correct position in the code)? ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it add more features to the slider object: set the step size at initialization to enable new features like: use the keyboard up/down arrow keys to change the value alternative: increase and decrease the value via buttons on the screen (that can be enabled via context menu) Slider with automatically included Number edit Box not new: Combined and Connected Number Edit Box and Slider Box  other wishes submitted by   ... View more

Parse JSON() is hard to use because it does not handle errors nicely. In a callback, perhaps from RunProgram or a button, it will create an unwanted model dialog announcing the failure. It will also announce the failure in the log. It takes extra JSL to fix it up: New Window( "parsejson", Button Box( "parse", local( {birestore, errText}, birestore = Batch Interactive( 1 ); // makes an alert dialog from a button without this errText = Log Capture( p = Parse JSON( "\!n" /* invalid json error */ ) ); // writes to the log without this Batch Interactive( birestore ); // pop the previous behavior If( Length( errText ), Throw( "Caught an error:" || char(errText) ) ); // handle unexpected error, somehow /* use p here */ ) ) ); Suggestion: add an optional parameter to change the behavior, something like parseJson(x, throwIfError() ) Failsafe JSON parsing    ... View more

Add multivariate t distribution ... View more

As in Origin software, it would be very usefull to have integration of curves (calculating area below curves). Many thanks, best regards JMP version 16.0.0 Tanja ... View more

Request to restrict the search function on the JMP help page (https://www.jmp.com/support/help/en/16.2/) by section.  For example, the user will be able to search only "Scripting Guide" or only "JSL Syntax Reference".   Currently, the search function will search all sections, which makes it difficult to find relevant information. ... View more

From time to time it would be nice to build user-interfaces which allow user to change datatables which will be used (currently my solution to this, is to "never" add option to change data tables). To my knowledge, you currently will have to re-create filter col selector and col list box to change datatables they use.   This is what I think you have to do: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Probe.jmp", invisible); dt1 = Open("$SAMPLE_DATA/Big Class.jmp", invisible); dt2 = Open("$SAMPLE_DATA/Semiconductor Capability.jmp", invisible); close_dts = Expr( Try(Close(dt, no save)); Try(Close(dt1, no save)); Try(Close(dt2, no save)); ); change_table = Expr( cur_table = (lb << get selected)[1]; // this wont work on filter col box due to ifbox created by it clb << Delete Box(); vlb_clb << Append(clb = Col List Box(Datatable(cur_table), all, numeric, max selected(1), nlines(5), <<Modeling Type({"Continuous"}))); vlb_fcs << Delete Box(); // for some reason we also seem to need Datatable(Datatable()) vlb_vlb_fcs << Append(vlb_fcs = V List Box(fcs = Filter Col Selector(Datatable(Datatable(cur_table))))); ); nw = New Window("Col List Box Example", H List Box( lb = List Box(Get Data Table List(), change_table ), vlb_vlb_fcs = V List Box(vlb_fcs = V List Box(fcs = Filter Col Selector(Datatable(dt)))), vlb_clb = V List Box(clb = Col List Box(Datatable(dt), all, numeric, max selected(1), nlines(5), <<Modeling Type({"Continuous"}))), Button Box("Close", close_dts; nw << Close Window; ) ) ); Write(); This is how I would like it to be done: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Probe.jmp", invisible); dt1 = Open("$SAMPLE_DATA/Big Class.jmp", invisible); dt2 = Open("$SAMPLE_DATA/Semiconductor Capability.jmp", invisible); close_dts = Expr( Try(Close(dt, no save)); Try(Close(dt1, no save)); Try(Close(dt2, no save)); ); change_table = Expr( cur_table = (lb << get selected)[1]; fcs << Set Data Table(cur_table); clb << Set Data Table(cur_table); ); nw = New Window("Col List Box Example", H List Box( lb = List Box(Get Data Table List(), change_table ), fcs = Filter Col Selector(Datatable(dt)), clb = Col List Box(Datatable(dt), all, numeric, max selected(1), nlines(5), <<Modeling Type({"Continuous"})), Button Box("Close", close_dts; nw << Close Window; ) ) ); Write(); This would eliminate the need for unnecessary display boxes and make the reference changing much simpler. ... View more

There are some functions in the Scripting Index that are worth to get "pinned" somehow. --> Would be great to have a "bookmarking" functionality. ... View more

Type hints in Python were a beautiful addition when they got added.  With JSL also not being a typed language, I'm wondering if we could get something similar.   This function is sort of served by new custom function, and Naturaldocs usage if there are diligent programmers. But nothing quite as nice as an inline hint.     I'm sure this is no small task, but figured I'd bring  it up since I haven't seen it anywhere else.       ... View more

JMP already has Get Punctuation Characters() and Get Whitespace Characters(), but it is missing couple of functions to get characters, for example letters and digits.    Python's string library does provide these constants, which would be useful to have also in JMP: string.ascii_letters string.ascii_lowercase string.ascii_uppercase string.digits string.printable In addition to that, it might be helpful to make the functions work in such a manner, that user could pass optional argument, which would let the function to return list instead of string. Of course user can do this fairly easily (if they know how) by using Words(). ... View more

Provide row number to formula editors Preview window. This could make it easier to debug formulas when you have a possible problem within subexpression. Would have to figure out how to show row numbers when using Random n, I would be fine with "real" row numbers from datatable. ... View more

I would like to have an option to prevent print/return on last executed row. Currently I'm ending most of my scripts with Write() to work around this. In some cases this has caused my JMP to crash because I have forgotten about this and run a script which ends up in a large matrix.  ... View more

Once I started using block folding, I found myself doing full collapsing all the time. It will be more efficient if a hotkey can be created for it (ctrl + '-' is suggested).   ... View more