Open up JMP table format

[vince_faller]

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. 

[vince_faller]

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

[txnelson]

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.

[vince_faller]

I'm explicitly trying NOT to open JMP.  

[bryan_boone]

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

[vince_faller]

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

[txnelson]

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.

[guillaumebugnon]

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.

[vince_faller]

@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.  

[vince_faller]

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

[txnelson]

I can not make a script of an existing table.