Skip to content

jthi-jmp-tools/JMP-Tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

JMP-Tools

| Description | Current Tools | Tool Descriptions | Todo | Disclaimer

Description

Purpose

Purpose of these tools is to provide additional functionalities to JMP and further enchance JMP. Some of the tools also include scripting techniques which might be interesting to some users and standalone functions which you can use in your own scripts.

Repositories

The repositories in jthi-jmp-tools include addin for installing the tool and required files to rebuild build the Add-in. The addins currently built with Add-In Manager by Justin Chilton because it provides superior user-experience when compared to native JMPs Add-in builder (even thou Add-In Manager is missing toolbars for example).

Most of the tools include README.md, README.html, settings.json, script files and the installation addin.

Installation

It is easiest to install addins from this repository's releases page. Addin's can also be installed from each tools own repository or this repository's addins folder. To install them from non-release page, open the addin file then click download on the right side.

Most of the tools will be added under JMP's Add-Ins menu in JMP-Tools but there are also exceptions, such as Order Selected Columns which will be added to Cols menu.

Add-Ins Menu

Cols Menu

Because there is no installer to install all of the tools at the same time, multiple folders will be created to addins folder and View/Add-Ins menu.

Some of the tools also offer settings.json to change default behaviours.

Current Tools

List of current tools provided. By clicking the tool name you will be redirect to that tools description in this README and by clicking Github link you will be redirected to Github repo foir that tool which includes the addin for installation and better description of the tool.

  1. Analyse Columns (GitHub link)
  2. Character Columns to Numeric (GitHub link)
  3. Create Order Column (GitHub link)
  4. Delete Missing Value Columns (GitHub link)
  5. Fill Missing Cells (GitHub link)
  6. Get Unique Values(GitHub link)
  7. Group Listagg Columns (GitHub link)
  8. Join Nearest Columns (GitHub link)
  9. Order Selected Columns (GitHub link)
  10. Replace X with Y (GitHub link)
  11. Split and Set Spec Limits (GitHub link)
  12. Script Launcher (GitHub link)
  13. File Indexer (GitHub link)

Tool descriptions

Get quick overview of columns you select. Also provides some manipulations you can perform on selected columns on right click menu and buttons.

Analyse Columns

Change character columns to numeric if possible.

Character Columns to Numeric

*Create ordering column to datatable

Delete columns which have more than desired amount of missing values.

Delete Missing Value Columns

Fill missing cells based on existing values. Doesn't require the data to be sorted, supports grouping and multiple options of fill directions.

Fill Missing Cells

Get unique values from columns and copy them to clipboard in different formats.

Get Unique Values

Group data in single (multiple expression) column. Most useful when combined with Summary or Split -table platforms.

Group Listagg Columns

Join two tables based on continuous columns, for example timestamp. Doesn't require data to be sorted, allows grouping columns and offers multiple join directions.

Join Nearest Rows

Provides extensions to JMP's existing column ordering options which work for selected colums.

Cols Menu

Quickly replace value x with value y in multiple columns.

Replace x with Y

Format tall datatatable with measurement data and specification limits into wide table with specification limit column properties

Split and Set Spec

Provides user interface to launch JMP Scripts. Also allows opening README.html and changing settings.json if such exist in desired location.

Script Launcher

Provides folder structure of specified directories and allows opening directories/files.

This tool is still totally unfinished

File Indexer

Generic JMP-Tools todo

  • Add help buttons to scripts
    • In best case this would open README.md files and parse them
    • Could also maybe load markdown page from github / create help wiki there and use that?
  • Create "custom" settings files / gui
    • Add possibility to creator to add limits to values
    • Could have generic settings.jsl for example -> on first run it could create settings file if not existing
  • Modify load_settings() functions in such a way, that it won't just replace default values, but rather inserts them. And if settings.json has missing keys, defaults will be saved there
  • Add general ideas of these tools to this README.md
    • functions and gui separated
    • .md file / .html file
    • naturaldocs compatible function/class descriptions/prototypes
  • Try to find a way to disable KaTex from .html files because it isn't used
  • Add functionalities to basic template:
    • Open directory, open help, open script, change datatable, ...
  • Create README.md template
  • Create basic folder structure
  • Modify how settings are handled
    • Remove default settings from .jsl files
    • Create default_settings.json (or similar)
    • If user modifies this -> save user_settings.json to NON-addin folder to "protect" from deletion or ovewriting
    • During startup, if user_settings.json exists -> overwrite values in default_settings.json with those values

Disclaimer from author

As these have been all been developed and tested by one person, on one setup (Windows10 and JMP16) there are most likely bugs and tools will most likely be changed