JMP Wish List

What inspired this wish list request?     What is the improvement you would like to see?              <<Visibility("private") <<Visibility("invisible"/"hidden") <<Visibility("visible")       Why is this idea important?      ... View more

☐ cool new feature ☑ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2022 ➜ Jmp18 :)     Get rows where is extremely slow if the column is referenced with a varible (here i=5 ) i = 5; dt << get rows where( As Column( dt, i ) == 999 ); instead of a direct reference like in dt << get rows where( As Column( dt, 5 ) == 999 ); My wishes: Is it possible to "fix this issue in the background"? e.g. by a setting in the preferences: "hereby I confirm that JMP is allows to pre-evaluate variables to speed up code execution - accepting that this could lead to unintended/unusual behavior" (I am not good enough in JSL programming to predict all the collateral effects - would such a mode make sense?) If fixing the issue in the background is not possible, could you please implement a warning function in JSL such that the user gets informed about the bad performance due to non-pre-evaluated variables. Then he can adjust the code, with substitute Should you Loop through a data table or use Recode, or use Get Rows Where to change values in a data table  or Eval: https://community.jmp.com/t5/Discussions/Should-you-Loop-through-a-data-table-or-use-Recode-or-use-Get/m-p/580751/highlight/true#M78769        more wishes submitted by   ... View more

What inspired this wish list request?  Multiple file import and open functions are able to save a list of files they open in a list. I'd like to see something similar with functions that can generate multiple columns from one, mainly text to columns    What is the improvement you would like to see?    saving text to column to a variable saves a list of column names generated to a list.   Example: A dt containing a column of numbers separated by commas new_cols_list = dt << Text to Columns( columns( :Numbers column ), Delimiters( "," ) );   Why is this idea important?  This would allow more compact identification of generated columns, and therefore more streamlined, and less error-prone way of working with these columns, if needed   ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it     If columns have to be visible all-time, independent of the actual position in the data table. one can lock them on the left. To do so, one has to select the columns and click on Scroll Lock/Unlock in the Col menu. https://community.jmp.com/t5/Discussions/Collection-of-quot-funny-quot-JSL-newbie-questions/m-p/575687/highlight/true#M78385   my wish: Could you please add this command also to the context menu which is opened by selecting columns and right-clicking. here the command can be found much easier.   ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it   There is a bug in Substitute if several items are substituted simultaneously or sequentially in a JSL code. JMP complains that the code is not correct. The code works after feeding it through  parse(char(my code)). And it works as well if the file is saved and re-opened: https://community.jmp.com/t5/Discussions/Col-Median-what-s-wrong/m-p/573778#M78278 really strange.         ... View more

☐ cool new feature ☑ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it     When scripts are copied to the Scripting Window via the save script command in the red-triangle menu, there is a Semicolon added at the end of the script to glue them together. When the scripts are saved to the data table or copied to the clipboard, no Semicolon is added.   Mi wish: please let JMP add the Semicolon independent of the case. Then the scripts can be concatenated manually without taking care if the glue operator is missing.         more wishes submitted by     ... View more

For additional context, please see  https://community.jmp.com/t5/Discussions/Monitoring-log-file-updates-from-console/m-p/700345#M88509.   What inspired this wish list request?  >>> Monitoring the JMP log remotely is very difficult.  Currently, it requires issuing frequent Save Log commands.  Even then, it appears that that command completely rewrites the log file (rather than just appending to it), which is very inefficient.  And it's not an up-to-date output since it requires a Save Log command for each update.   What is the improvement you would like to see?  >>> As a JSL option, enable automatic writing of any log console info, (e.g., Write, Show, error output), to a script-specified file name.  Flush this buffer after each newline (and maybe also after some period of time in case of output without any or many newlines).   Why is this idea important?  >>> Provides for quality monitoring of JSL script execution progress via the log output without having to be viewing the JMP UI (which is problematic in itself in that it can often put up windows that cover the log window).  This feature would also provide for programmatic monitoring of program execution.   ... View more

Currently, the Mail function in JSL allows you to send email to a list of valid email addresses, however, it does so by incrementing through the list and sending an individual email to each recipient.  On a machine where the email client requires user intervention to allow an email to be sent by JMP (e.g. Outlook on Windows in a corporate environment), this means that the user must sit and await a warning message for each recipient, sometimes with a built-in delay!  This is highly inefficient, and means that sending out a report to interested stakeholders requires just as much if not more time when automated using the Mail function as it would to just manually copy and paste the report into an email. JMP Version 16.2.0 Example code (assumes reports saved in temp folder as pngs, uses dummy email addresses): sites = {"Site-1", "Site-2"}; report_path = Convert File Path( "$TEMP" ); default_dn = "example.com"; maillist = Associative Array( sites, {{// Site-1 "support@example.com", "stakeholder1@example.com", "stakeholder2@example.com", "stakeholder3@example.com"}, {// Site-2 "support@example.com", "stakeholder3@example.com", "vpsales@example.com"}} ); For( i = 1, i <= N Items( sites ), i++, site = sites[i]; rep_title = Eval Insert( "^site^_Report" ); temp_file_path = Convert File Path( report_path || "/" || rep_title || ".png" ); winmail = New Window( Eval Insert( "Send ^site^ Email" ), V List Box( Lineup Box( N Col( 2 ), Text Box( "To:" ), H List Box( lb_to = List Box( maillist[site], <<NLines( 4 ) ), V List Box( Button Box( "Add", nw = New Window( "Add Recipient", <<Modal, <<Return Result, Text Box( "Enter a valid email address:" ), H List Box( teb_add = Text Edit Box( "", <<Set Width( 300 ) ), Text Box( "@" || default_dn ) ), H List Box( <<Horizontal Alignment( "Right" ), Button Box( "OK" ), Button Box( "Cancel" ) ) ); If( Char( nw[N Items( nw )] ) == "Button(1)", lb_to << Append( nw["teb_add"] || "@" || default_dn ) ); ), Button Box( "Remove", seli = lb_to << Get Selected Indices; If( N Items( seli ) > 0, newl = lb_to << Get Items; For( i = N Items( newl ), i > 0, i--, If( Contains( seli, i ), Remove From( newl, i ) ) ); lb_to << Set Items( newl ); ); ) ) ), Text Box( "Subject:" ), teb_subj = Text Edit Box( rep_title ), Text Box( "Body:" ), teb_body = Text Edit Box( Eval Insert( "Hello All,\!N\!tPlease find ^rep_title^ attached.\!N\!N" ), <<SetNLines( 8 ) ), Text Box( "Attached:" ), Text Box( tempfilepath, <<Set Wrap( 500 ) ), ), H List Box( <<Horizontal Alignment( "Right" ), Button Box( "Send", Write( "Sending..." ); // Send Mail to_list = lb_to << Get Items; subjstr = teb_subj << Get Text; bodystr = teb_body << Get Text; Eval( Eval Expr( Mail( Expr( to_list ), subjstr, bodystr, tempfilepath ) ) ); winmail << Close Window; ), Button Box( "Cancel", Write( "Cancelled.\!N" ); winmail << Close Window; ) ) ) ); ); ... View more

Apparently, we do not have a method to perform the following action.   dt:column << Type(Best Guess)   This is done when loading a CSV, but seems not accessible via JSL.   For more context: https://community.jmp.com/t5/Discussions/How-to-force-a-new-best-guess-a-column-modeling-type-and-data/m-p/397945#M64866   ... View more

I would like the quoted string in the :Name() function to be an element that JMP evaluates, rather than just being a quoted string.  I would like the below script to work names default to here(1); dt=current data table(); thename="NPN1"; bivariate(x(:Name(thename)),y(:Pnp1)) ... View more

Hi,   Could it be possible to implement a new function for encrypt and decrypt multiple files ? A way to encrypt or decrypt multiple files which have the same password. Could be very interesting.   Thanks Regards Guillaume ... View more

Please consider adding the Robust Mean and Robust Standard Deviation functions already available in the Distribution platform to the Formula Editor and as JSL functions.  Thank you! ... View more

I would like to not be forced to resize my columns every time something happens in the data table. I would like to be able to set a column either by JSL or manually and then lock it so that it doesn't change until I decide to change it. I want to be able to lock the width smaller that the column name width too so that it does not change back to the length of the column name.  ... View more

What inspired this wish list request?  Currently not every interactive action is capture by the Action Recorder and written to the log View.  When a JMP script is written for repeated execution of a process, it is helpful to have every action required for the JMP process to have a JSL code.  When a JMP action is not scriptable since the actions were not recorded in the Action Recorder, instructions must be written within the JSL script process for the operator to perform a specific action manually.     What is the improvement you would like to see?  Capture manual JMP actions in the Action Recorder and write to the Log View.   Why is this idea important?  Save time for the operator since the operator does not need to perform manual actions.   ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Xpath provides a very powerful way to address individual elements in a display tree. Unfortunately, it feels like black magic and I assume that it's just used by a few Jmp power users.   Column Formulas are also very powerful. One can generate very complicated code. The difference: There is this amazing Formula Editor which allows even beginners to generate meaningful Column formulas.   such an editor is missin for Xpath queries.   What is the improvement you would like to see?  Please implement in Jmp a Xpath Query GUI. It should provide all possibilites to generate a fancy Xpath query. Examples from JMP-Discovery-2015-Mining-JMP-Reports-v10 :     There should be a live view of the query results. The entry point should be selectable from the Display Tree. Additional entry points should be available as well: - current report() - all scriptable objects within the current report     Why is this idea important?  Users experience a huge efficiency boost when they start to learn to talk to the Report elements. Xpath is a great help to do so - but it's quite complicated.   A Xpath Query GUI will provide all the necessary flexibility and guidance when working with Report entries and Xpath queries - even for Jmp Newbies :)         more wishes submitted by   ... View more

I love the column name recode utility. It would be super nice if the one-klick-script generation of the column recode would also be possible for the column name recoding and also caught by the new action recorder of JMP 16. I know that there are workarounds directly in JSL and possibly even the new action recorder, but a one-klick-capture as with the other platforms would truly speed up script automation. ... View more

☐ cool new feature ☐ could help many users! ☑ feels like a bug ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  In Jmp, there are 2 approaches to generate Transform Columns. 1) by talking to a data table: - the transform column is generated with Table Scope - so, the Transform Column "lives" outside the context of the platform it is generated for. - there is a Replace option: either a pre-existing Transform Column is replaced (setting: 1) or the name of the new Transform Column is adjusted (setting: 0) - The Transform Column is easily accessible, e.g. by using the return value of the command = handle for the generated transform column 2) by talking to a report 2b)  via platform << Transform Column() - this Transform column is generated in the scope of the platform - and will we deleted once the platform is closed -> very useful :) This is why this is the default approach how Transform Columns are used in Graph Builder, Summary and all the other platforms. - unfortunately, there is no replace option. If there is a Transform Column with the same name, the command is ignored (!) and the exiting Transform Column is used instead. -  unfortunately, Transform Columns which are generated by a platform are very hard to access: how to reference a Transform Column?  e.g. how to remove a Transform Column? What is the improvement you would like to see?  Although it works like designed, it definitely feels like a bug. It's hard for a user to understand that there are several tasks doable via the GUI which are not accessible via JSL.   Please improve the functionality of Transform Columns which are generated in the context of a Platform: return a handle for the column - - analogous to the one of the first kind of Transform columns add a replace option - analogous to the one of the first kind of Transform columns   Why is this idea important?  GraphBuilder has cool features to aggregate data via Summary Statistics - but important functions are missing, like CDF . Transform Columns provide a possibility to close such gaps - but the limited functionality of Transform Columns in the context of a platform make it difficult.   Example: If a user changes the selection in a Local Data Filter - how to update a Transform Column to account for the changes?         more wishes submitted by   ... View more

Hi.  I propose there should be an optional argument that forces all columns to be Character Data Type for both the Open() and Multiple File Import() commands.  This request is similar to, but not exactly the same, as these 2 requests:   https://community.jmp.com/t5/JMP-Wish-List/Excel-Import-specific-column-types-or-formats/idi-p/248136  https://community.jmp.com/t5/Discussions/Force-column-from-CSV-import-as-Character-not-Numeric-Date/m-p/260752#M51078    The first link requests the ability to manually specify column data type for Excel files in the Open() GUI, whereas my request is addressing usage of the Open() command in a script, not the GUI, and applies to both csv and xlsx files.  The second link appears to apply only to MFI() and csv files, whereas, I would like this ability for both MFI() and Open(), and for both csv and xlsx files.   I realize there exist various scripting methods that could do this for certain scenarios, although not all. Some of these methods might require you to know the column names/locations in advance, or require that the column names always be on the first row.  This is not something we necessarily have control over.     I feel having a single option to set would simplify this greatly for many users.  Also, this would save time since JMP would not need to spend time scanning the file to detect column data type.  Lastly, my feeling is that this could be low-hanging fruit to implement, in that you'd just be turning off the portion of the internal code that scans each column.   Hope this is possible.  Thanks. ... View more

Instead of the dreaded ###, please show which file and line number a script failed in.   Kind regards Thomas ... View more