Subscribe Bookmark RSS Feed

Does JMP have a hidden cache for opened file names? Can I clean it? Is this a bug?

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

I have a beginning part of a long script as:

);

Data Table( "AgencyStayISL.jmp" ) << Concatenate(

    Data Table( "AgencyStayLBL.jmp" ),

    Output Table( "AgencyStay" ),

    Keep Formulas,

    Create source column

);


When I first time open and run JMP everything is fine. When I close all windows and rerun the script the output table name turns to "AgencyStay 2" instead of "AgencyStay" which kills the rest of the process hence the whole depends on the output table name. When I quit JMP reopen and rerun then everything is again fine which means I have to quit and reopen JMP 80 times a day. Is there a hidden cache for opened file names? If so how can I always keep it unrecorded? Or is this a bug?


Would appreciate any help

4 REPLIES
Craige_Hales

Staff

Joined:

Mar 21, 2013

This works for me, in JMP 11.  If you force the AgencyStay table to already exist, the Try( close( ... ) ... ) at the beginning will clean it up and tell you what happened.

In my example, I assign the new table to c so I can have a reference to the table that was created, and even ask it what name it actually received if JMP had to resolve a name collision with an existing table.


// this is only needed if the previous script failed to close the table


Try(


  Close( Data Table( "AgencyStay" ), "nosave" );


  Print( "found one!" );


,


  Print( "good start" )


);


// this loop tests, 10 times, that the name does not change


For( i = 1, i < 10, i++,


  a = Open( "$desktop/a.jmp" );


  b = Open( "$desktop/b.jmp" );


  c = Data Table( "a.jmp" ) << Concatenate(


  Data Table( "b.jmp" ),


  Output Table( "AgencyStay" ),


  Keep Formulas,


  Create source column


  );


  Print( c << getname() );


  Close( a, "nosave" );


  Close( b, "nosave" );


  Close( c, "nosave" );


);


"good start"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

Craige
saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Forgot to say; Using JMP12, the script ends with close all no save...

During work I use "Close Multiple" and untick "review documents with unsaved..."

Thanks for your input!

Craige_Hales

Staff

Joined:

Mar 21, 2013


close all(data tables, nosave);


also works for me (in 12); I can't find the close multiple you refer to.

Craige
saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

8577_Screen Shot 2015-04-19 at 14.39.11.png