topic Re: Oops - I lost my data ... in Discussions

Oops - I lost my data ...

hogi — Tue, 07 Oct 2025 23:07:22 GMT

Remember, you must not ....

~~create a virtual link with a wrong table reference~~ (fixed <= v18.2.2)
~~create a summary table with a compact column~~ (fixed <= v18.2.2)

It makes your data table non-accessible!

[More Topic Containers like this]

Re: Oops - I lost my data ...

hogi — Thu, 18 Sep 2025 19:57:49 GMT

option 1):
add a Link with a non-resolved reference:

Names Default to Here(1);

dt =  Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << new column("Conan the Destroyer",Set Property("Link Reference", {Reference Table(link_path), Options("Use Linked Column Name", "Auto Open")}));

dt << save("$TEMP/test.jmp");
close(dt, noSave);

open("$TEMP/test.jmp");

fixed in JMP18.2.2?

Re: How to make a data table non-accessible?

jthi — Mon, 02 Dec 2024 16:34:02 GMT

In what sense non-accessible?

Re: How to make a data table non-accessible?

hogi — Mon, 02 Dec 2024 17:01:57 GMT

In the sense of "dead".

Re: How to make a data table non-accessible?

hogi — Mon, 02 Dec 2024 17:12:50 GMT

The good thing:
JMP stores the Table reference in plain text ...

By deleting the ", Auto Open" one can revive the file:

JMP will show a warning message:

and skip the details of the erroneous column.

Re: How to make a data table non-accessible?

txnelson — Mon, 02 Dec 2024 18:18:58 GMT

What is the purpose of this thread?

Re: How to make a data table non-accessible?

jthi — Mon, 02 Dec 2024 19:44:46 GMT

Why would you want to make your data non-accessible in such a way that it is basically corrupted?

Re: How to make a data table non-accessible?

hogi — Tue, 03 Dec 2024 14:50:00 GMT

@txnelson wrote:
What is the purpose of this thread?

mainly: Help people save their work.

Besides that:
a) Documentation: Things you should NOT (!!) do with your data table.

b) Motivation:
@ colleagues - please invest 30 minutes to understand the beauty of Eval/Eval Expr/Expr
(the basics: # 62, some examples: #66) --- it will save you from lost data like this one.

c) preventive action:

-> I will add a check + warning functionality to the button ...
if a variable is defined in the script - and the variable shows up in a message (<< ...) ... show a WARNING !

Re: How to make a data table non-accessible?

hogi — Sat, 07 Dec 2024 19:24:25 GMT

@hogi wrote:
a check + warning functionality ...

(view in My Videos)

Re: Oops - I lost my data ...

Dahlia_Watkins — Wed, 04 Dec 2024 21:59:13 GMT

I believe understand the problem after speaking with another colleague.

The issue here is the JMP user interface will not allow one to save a table, with Auto Open selected, while an invalid Link Reference path exists. The JMP UI will save the table but will set the Auto Open option. So the table can be opened or recovered.

In JSL however, it is permitted. The table is saved with Auto Open and an invalid Link Reference. This prevents JMP from opening the table. The JMP UI has some sort of safety check in place that is not built into JSL.

I've reported this issue so it can be addressed in a future release.

Best!

Re: Oops - I lost my data ...

hogi — Thu, 18 Sep 2025 19:48:11 GMT

#1:
Hi @Dahlia_Watkins , thank you for digging deeper and triggering a bugfix for a future release : )

[TS - 00177463]

Re: How to make a data table non-accessible?

HaltsMaulwurf — Mon, 09 Dec 2024 08:33:48 GMT

Thanks hogi,
I could rescue a few of my datasets with your solution! Highly appreciated

Re: Oops - I lost my data ...

hogi — Thu, 18 Sep 2025 20:00:15 GMT

option 2) create a summary table

- with a link to the main table (default)

- with a compact column

dt = New Table( "input",
	Add Rows( 3 ),
	New Column( "ID",
		Character,
		"Nominal",
		Set Values( {"A_1", "A_2", "A_3"} ),
		Compact() // <- disable to remove the bug
	)
);

dt sum = dt << Summary(	Group( :ID ),
//Link to original data table( 0 ) // <- uncomment to disable the bug
);

fn = "$temp\bug" || Char(random integer(10000))||".jmp";
dtsum  << Save( fn );
Close( dt sum, NoSave );
Try(open(fn), Caption("sorry, the file is damaged"));

When you try to open the file manually, JMP will display an error message:

same issue with linked subset tables?

fixed in JMP18.2.2?