cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Row selection includes negative quantity and rows that cannot be selected. BUG?

mann
Level III

I am importing ~140000 rows of data from 20 preexisting jmp files using this script in windows 11, JMP 18.1.0

 

Multiple File Import(
	<<Set Folder( "C:\here\there\"),
	<<Set Name Filter( "*.jmp;" ),	<<Set Name Enable( 1 ),
	<<Set Size Filter( {1, 1} ),	<<Set Size Enable( 0 ),
	<<Set Date Filter( {Today() - indays(10), Today()} ),	<<Set Date Enable( 1 ),
	<<Set Add File Name Column( 1 ),	<<Set Add File Size Column( 0 ),	<<Set Add File Date Column( 0 ),
	<<Set Import Mode( "CSVData" ),	<<Set Charset( "Best Guess" ),	<<Set Stack Mode( "Stack Similar" ),
	<<Set CSV Has Headers( 1 ),	<<Set CSV Allow Numeric( 1 ),	<<Set CSV First Header Line( 1 ),
	<<Set CSV Number Of Header Lines( 1 ),	<<Set CSV First Data Line( 2 ),	<<Set CSV EOF Comma( 1 ),
	<<Set CSV EOF Tab( 0 ),	<<Set CSV EOF Space( 0 ),	<<Set CSV EOF Spaces( 0 ),
	<<Set CSV EOF Other( "" ),	<<Set CSV EOL CRLF( 1 ),	<<Set CSV EOL CR( 1 ),	<<Set CSV EOL LF( 1 ),
	<<Set CSV EOL Semicolon( 0 ),	<<Set CSV EOL Other( "" ),	<<Set CSV Quote( "\!"" ),	<<Set CSV Escape( "" )
) << Import Data;

I do see now it may be strange to specify JMP files and then list CSV import settings.  I think this script was created by JMP 14 automatically.  The import works just fine, and the data table looks very normal (initially).  (All my other data tables work fine.)
This table has a bug in it - every time I use the above script to generate it:  If I select the first row and invert the row selection, I should have 139,999 rows selected - but i only have 70,921.  Over 60k remain unselected.  If I select one of those unselected rows, and invert the row selection again, then again, 70,900 rows are selected, but I can not unselect any of them by clicking. I can invert the selection state of multiple rows if if I click-drag over multiple rows. If I select any row, and delete it, I instantly have -37k rows selected.  If I delete all the rows, I still have -37k rows selected.  This is not convenient.  Is there a solution?

 

4 REPLIES 4
jthi
Super User


Re: Row selection includes negative quantity and rows that cannot be selected. BUG?

Have you tried re-creating the script in JMP18? Also, might be worth contacting JMP technical support JMP Support 

-Jarmo
txnelson
Super User


Re: Row selection includes negative quantity and rows that cannot be selected. BUG?

I created 4 tables with approximately 60k in each table.  I then used your script to input the files.  I selected row 1 and then did a Invert Selection, and all remaining rows were selected without issue.

 

Since you have "Set Add File Name Column( 1 )" in your script, I suggest that after you select row 1 and then do your Invert Selection, that you scroll down to the last selected row, and see if the value of the new column "File Name" is different between the last selected row, and the first unselected row.  If so, that may point to an issue within one of your input tables.

Also,  you can remove the CSV settings from your script, assuming that only JMP files are being input.

 
Multiple File Import(
	<<Set Folder( "C:\here\there\"),
	<<Set Name Filter( "*.jmp;" ),	<<Set Name Enable( 1 ),
	<<Set Size Filter( {1, 1} ),	<<Set Size Enable( 0 ),
	<<Set Date Filter( {Today() - indays(10), Today()} ),	<<Set Date Enable( 1 ),
	<<Set Add File Name Column( 1 ),	<<Set Add File Size Column( 0 ),	<<Set Add File Date Column( 0 ),
	<<Set Import Mode( "CSVData" ),	<<Set Charset( "Best Guess" ),	<<Set Stack Mode( "Stack Similar" )
) << Import Data;
Jim
mann
Level III


Re: Row selection includes negative quantity and rows that cannot be selected. BUG?

Update:  I have determined the cause, and I think this should be considered a bug. 

I used TXNelson's code and got the same results.

I used JMP18 to rebuild the script and got the same results.

JMP 14 did not have this problem.

The original jmp files were created with JMP 18 a few days ago and saved with some rows already selected (37000 rows of the 146000 total).  Those 37000 rows are imported in an unselected state AND a selected state simultaneously (but the selected rows are very(very) hidden (?).  The "invert row selection" function inverts the originally unselected rows but does not do anything to the originally selected rows... they appear unselected regardless of the inversion.  Deleting any rows also deletes the very hidden duplicate of the doubly imported rows which instantly drops the tally of selected rows to -37000 (instead of 0).  All the while, the table does not permit normal click-to-select functionality: selected rows are not unselected when a different row is selected: rows selected states are toggled when they are clicked or click-dragged.

txnelson
Super User


Re: Row selection includes negative quantity and rows that cannot be selected. BUG?

Good catch........

Jim