topic Re: Saving Summary Table as HTML and Picture in Discussions

Saving Summary Table as HTML and Picture

Josee — Mon, 08 Apr 2019 19:58:34 GMT

I am trying to save the summary table as an HTML and a picture but both scripts do not work. How can I get it to work?

jrnl<<save HTML and jrnl<<save picture do not save as I need it to. Any help will be much appreciated.

Example:

dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt1=dt<< Summary(
Group(:sex),
Mean( :height )
);
dt1<< sort( by( :Name("Mean(height)")),Order(Descending), Replace Table );

jrnl=dt1<<journal;

jrnl<<Save HTML ("path/Summary.html");

Re: Saving Summary Table as HTML and Picture

txnelson — Mon, 08 Apr 2019 21:09:25 GMT

I suspect that

"path/Summary.html"

does not point to an actual location. That is, do you have a folder named "path" as a folder at the top of your OS system.

I suspect that is if you change "path" to an actual writable folder on your hard drive you will not have an issue.

I made that change and the Save HTML worked just find.

Re: Saving Summary Table as HTML and Picture

Josee — Mon, 08 Apr 2019 21:20:06 GMT

yes I do direct it to a writable path. for example this is what I am trying to do and it is stilll not wanting to save on my desktop.

dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt1=dt<< Summary(
Group(:sex),
Mean( :height )
);
dt1<< sort( by( :Name("Mean(height)")),Order(Descending), Replace Table );

jrnl=dt1<<journal;

jrnl<<Save HTML ("C:\Users\joseebon\Desktop\Summary.html");

Re: Saving Summary Table as HTML and Picture

txnelson — Mon, 08 Apr 2019 21:26:27 GMT

What is the error message in your Log?

Re: Saving Summary Table as HTML and Picture

Josee — Mon, 08 Apr 2019 21:29:30 GMT

There are no errors on the log. This is what is showing up.

/*:
//:*/
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt1=dt<< Summary(
Group(:sex),
Mean( :height )
);
dt1<< sort( by( :Name("Mean(height)")),Order(Descending), Replace Table );

jrnl=dt1<<journal;

jrnl<<Save HTML ("C:\Users\joseebon\Desktop\Summary.html");
/*:

Scriptable[]

Re: Saving Summary Table as HTML and Picture

txnelson — Mon, 08 Apr 2019 21:30:33 GMT

Are you running JMP 14?

Re: Saving Summary Table as HTML and Picture

Josee — Mon, 08 Apr 2019 21:32:28 GMT

No I am running on JMP Pro 12.

Re: Saving Summary Table as HTML and Picture

txnelson — Mon, 08 Apr 2019 21:50:36 GMT

With JMP 12, the simple assigning of a variable to the journal does not work, you will have to use a

xxx = Current Journal;

to get the correct pointer to the journal.

See below

//:*/
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt1=dt<< Summary(
Group(:sex),
Mean( :height )
);
dt1<< sort( by( :Name("Mean(height)")),Order(Descending), Replace Table );
jrnl=dt1<<journal;
zippy=current journal();
zippy<<Save HTML ("C:\Users\joseebon\desktop\Summary.html");

Re: Saving Summary Table as HTML and Picture

Josee — Mon, 08 Apr 2019 22:09:18 GMT

It works perfect. Thank you.