cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
How to save journal to a JMP data table using JSL (2022-US-EPO-1079)

Hui Di, Software Test Engineer, SAS Institute

 

We have a built-in command to save a JMP report to a JMP data table so that the customer can rerun the report. However, if a customer wants to save the report as a journal, customize it, and then save it to the data table, JMP currently does not have the build-in UI command to do so. As a tester on the JMP journal, I see customers' needs for this function. 

 

My poster will show how to write an add-in to save a journal to a data table so that customers can rerun it in future JMP sessions. 

 

 

Hi,  my  name  is  Hoi Dee. I'm  working  in  JMP.

I'm  working  in  JMP  system  testing  group.

One  of  my  responsibility is   testing  journal.

So  this  brings  the  introduction   of  my  poster.

JMP  has  a  function  to  save our JSL  or the report to data table,

which  is  very  convenient   for  users

to  access  previously generated  reports.

A s  a  journal  tester, I'm  thinking,

is  it  possible  to  save a  journal  to  a data  table?

And  not  only  me  think  about  that,

we  have  some  customers thinking  of  that,  too.

And  even  our  customer  requested

the  function  of  save journal   to  a  data  table.

So  because  we  have  customer   requesting  that,

I  began  to  look   into  the  ways in JSL,

how  do  we  do  it  to  save a  journal  to  a data  table?

So  this  poster  is  to  study   their  JSL commands

and  how  do  I  put  them  together to  save  journal  to  a  data  table.

Methods  and  objectives.

Objectives,  as  introduction  said, as I planned, or as customer requested,

is  to  save  journal  to  a  data  table

so that  in  a  data  table,  users  can launch  other  report  or  journal.

So that  they  don't  need   to  have  a  separated  journal

associated  with  the  data  table.

Then  the  second  method,

and  the  objectives  we  are  thinking is  how  to  deliver  this  small  application.

Because  JMP  has  an  add- in, I  used  this add- in  to  deliver

this  small piece of JSL command  for  easier  delivery.

The  last  one  I  want   to  mention  is that

since  we  want  to  save the journal  to the data table,

we  need  the  data  table   to  be  current.

That  means  we  need  existing  data  table in the JMP to   save the script, too.

Then  let's  talk  about  results.

After  user  creates  a  new  journal

or  attached  piece  of  the  report to an existing journal,

by  running  the  add- in   save  journal  to  data table,

user  can  save  journal   to  the  data  table.

When  a  user  send or  share  the  file   to  another  user,

then  another  person  can  launch  the  journal from  her  or  from  his  desktop.

Similarly,  a  user  may  use   this  method  to  save  file,

s ave  other  file  formats  inside the data table,

to  wrap  other  files   inside  a  data  table.

Then  I  will  show  you  a  case  study   how to use this add-in.

On  the  poster,  I  have  show  you multiple steps  how  to  do  that.

But  in  a  little  while, I  will  show  you  how  to  use  it,

how  do  we  save  the  journal to a data table  in  real  JMP  session.

Let  me  briefly  introduce  the  steps how  to  use  this  command.

First of  all,  either  we  want  to  bring in a template to journal,

like  in  this  case,

I  use  our  marketing  department's journal template  from  Hyde Miller

as  a  template  because  I  want to  insert  report  to  his  journal  template.

On  this  template, we can see they have the company's JMP logo,

and a title for their journal and some other  land  separators  there.

After  we  bring  up  our journal  template, we need a data table and a report,

especially  a  report, because we want  to insert report to the journal.

After  we  insert,  let's  move  on   to  the  step  number  three.

After  we  attach  a  part  of   or a  whole  part of the report to journal,

then  we  move  on  to  the  last  step, which  is  run  add- in.

Since  we  are  on  the  journal, then we move on to the last step -

to  run  the  add- in   save  journal  to  data  table.

The  result,  as  I  shown  before, is  that  we  have  viewed  in  JSL scripts

in  the  data  table  on  the  left  panel  of  the  table.

Then  if  we  launch  it,  we  get   the  journal  template  and  the  report.

So  the  conclusion   of  this  poster  is that

we  can  use  the  save  journal  to  do the  table  add- in  to  fill  the  gap  in  JMP,

where  we  have  no  command  you to  save  journal  to  your  data  table.

Besides,  we  can  save  journal  to  a  data  table.

Similarly,  we  can  use  this  method to  apply  to  other  file  formats.

So  we  can  wrap  other  file  formats   inside the JMP data table

so  that  when  we  share  the  data  table, it  comes  with  the  JSL  scripts

and other file formats  could be launched from  JMP.

Let's go, for  example, HTML5, PDF, etc.

Last  part  is that  I  want  to  say  some  thanks

for the people who  contribute   to  this  presentation.

Of  course,  the  first one  who come   to  my  mind is Hyde Miller,

whose  journal  template   is  used  in  my  case  study.

Now,  let's  move  on   to  the  journal  to  see...

Let's  move  on  to  the   real-time  JMP to  see  how  do  I  use  this  function

or  this  save  journal   to  data table add-in.

First of  all,   let's  bring  up  JMP  application.

Now,  we  open  the  data  table, for  example,  Big  Class.

First,  let  me   demonstrate   the  first scenario.

The first case  study  where  a  report was inserted  into  a journal  template.

Let  me  bring  up  a  journal.

Here  is  an  existing  journal   template  from Hyde.

Then  user  bring  up   a  JMP  data  table.

Then  he  or  she  may  run   testing  scripts or  his  own  customized JSL l aunched  report.

In  my  case,  in  this  example,  let me run this  one,

bar  chart,  and  the  land  chart.

From  here,  we  may  copy  or  paste part  of  the   display  boxes.

This  report  made  up  of  display  boxes.

We  may  copy  parts  or  copy  a whole   display  boxes  or  reports  to  this  journal.

To  make  it  easy,   let  me  use  [inaudible 00:10:08]

to  journal  this  report to  existing  journal  template.

Now,  this  is  the  journal.

Then  here,  we  can  go  to  the  add- in, then  we  click  save  journal  to  data  table.

Now...

Let  me  close  all  this so  that  we  may  see  clearly.

Here  on  the  data  table,  we  have  viewed in  JSL  script  AsJ ournal.

When  we  run  it,

we  have a general template  at beginning of the journal,

and  we  have  the  journal   of  the  report  inserted  into  it.

This  is  the  one  scenario  which  we insert  a  report  or  part  of  report

to  an existing  journal and save the  journal  to  the  data  table.

Now,  let  me  demo  another  one,   which  is  the  case  where  the  user

do not want to  use  the  template, but want to save the  journal  to  the  data  table.

Let  me  bring  up  Big  Class  again.

We  may  want  to  run  a  report,

then we may want  to  Control- J   to  make  a  journal.

Here,  this  is  the  journal.

Then  go  to  the  add- in   to  save  journal  to  the  data  table.

So  to  see  clearly,   we  close  all  the  other  windows.

So  now  we  have  this  viewed   in  JSL  script  AsJ ournal.

Then  when  we  ran  it,   this  is  the  journal   we  captured  from  our  report.

I  put  this  journal  as  a  label  to  see,   to  identify  that  this  is  a  journal  window.

Journal  is  different  from  a report. It's  a  static  image.

So it's  not  affected  by  the  changing   of  their  development.

It's  like  a  camera. It  takes  the  picture  there.

For  example,  here  on  journal,

we  don't  have  the  two  tapes   showing  up  here.

So  this  is  a  journal.

The  good  thing  about  journal is  that  it  won't  change.

It's   static.

It's   a  screenshot  of  the  report   at  that  moment.

Okay,   let's  go  back   to  the  PowerPoint.

The  whole  poster, I  want  to  summarize  the  poster  again.

Here,  we  have  a  new  add- in   save  journal to data table

enabled  for  user  to  use  if  they  want   to  save  a  journal  to a  data  table.

The  journal  is  a  static  image of  different  display  boxes  in  nature.

And  it  can  include  image   or  different  display  boxes.

So from  this  add- in, user  can  add  a  script,

viewed in script  to  a  data  table to  keep  their  report  or  their  journal.

S imilarly,  to  save a  JSL   of  a  report  to  a  data  table,

we  can  do  save  a  journal   to  a  data  table

to  capture  the  journal  users   want  to  keep.

So  the  good  thing  is  that,   once  again, as a conclusion,

people  can  share  this  data  table   so  that  people  can  run  their  journal

to  bring  up  their  static  image   of  their  report  at  that  time.

So  this  is  the  poster   of  save  journal  to  a data  table.

Let  me  know  if  you  have  any  questions.

Again,   there  are  many  user  cases   possible  still  to  explore.

I've  just  researched   and  studied  some simple cases

for  saving  journal  to  a data  table.

I'm  looking  for  your  feedback.

Thank  you.

Bye. Bye.