364899_en-US

liliconcom

Open up JMP table format

I would love if the JMP table format were open.  As in I could build a jmp table from pwsh/python (or whatever) from scratch. 

I have two use cases

 

1. make my pipeline more efficient so that I don't have to wait for a JMP machine to open up to do some backend pre-processing while still having all of the wonderful features of JMP when I'm ready for it.  
   1.   I am currently doing this by having JMP run some stuff on a machine that just preprocesses, but JSL isn't built to handle this. 
2. interactive html isn't up to what I need it to do for everything so being able to read a jmp table to make some custom web frontend stuff would be useful

 

Obviously I could just use a csv for data, or switch everything over to another language.  But being able to read/write the jmp data format directly would make a world of difference. 

Data AccessScriptingRe: Open up JMP table format - Status changed to: Not Planned For Now

@vince_faller, we have decided to not pursue this feature request.  We appreciate your input and contributions to the user community.  

Re: Open up JMP table format - Status changed to: Acknowledged

Hi @vince_faller, thank you for your suggestion! We have captured your request and will take it under consideration.

Re: Open up JMP table format

I can not make a script of an existing table.

Re: Open up JMP table format

@txnelson can you make a jsl script of a table without opening JMP?

Re: Open up JMP table format

@guillaumebugnon yep pretty much the same request.  I have a couple of workarounds that I can get data into JMP. But nothing is quite the same from what I've found.  

Re: Open up JMP table format

Hi @vince_faller ,

 

Yes, more or less same idea as this one API to convert csv to jmp format 

For huge amount of data, maybe you can test hdf5 format, JMP can open it. Not yet tested from my side but planned

pandas python lib can do it with pandas.Dataframe.to_hdf function.

Re: Open up JMP table format

I am going to offer up jsl of a script once again.  If you need to manipulate or create jmp data without opening up jmp, it can be done if the data table has been saved or created as a script.  It contains all of the column properties, all of the row selections, etc. in the script and it would be fairly simple to parse the script to get any of the information you need.  And if the data table is saved as jsl, then when one is in jmp, all that has to be done, is to open the script and it will populate the data table defined in the script.

Re: Open up JMP table format

not really .  Imagine I'm trying to recreate Big Class.jmp exactly.  I want to be able to do that without opening JMP. 

Re: Open up JMP table format

JMP can open sqlite files natively, without an ODBC driver. So Python, etc, can create "vanilla" sqlite tables without JMP, that then, can re opened with JMP. However, if you want to save the table back to sqlite, you'll need ODBC.

HTH

Re: Open up JMP table format

I'm explicitly trying NOT to open JMP.  

Re: Open up JMP table format

I have solved this issue many times by just creating the data table and all of the required JMP goodies in a JMP script.  It works great to move data from one environment into JMP.

Re: Open up JMP table format

@msharp @gzmorgan0 @pmroz @ms @txnelson Shamelessly plugging this request for kudos as I imagine you've run into this wish as well.