cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Sqlite3 to JMP Data table through Python Integration

The attached JSL uses JMP's Python integration to create a sqlite3 database file by recursively descending a directory of files.  The directory is chosen using JSL's Pick Directory().  The path is passed through to the Python environment.

Screen Shot 2021-03-09 at 4.13.35 PM.png

 

A MD5 checksum is computed for each file and that along with the path is inserted into the sqlite3 database, then the sqlite3 table is imported into JMP as a Data Table.

 

Screen Shot 2021-03-09 at 4.14.29 PM.pngRe-running the script just appends another directory's worth of information into the database.  Also demonstrated is an example of fully specifying dll and sys.path in the Python Init().