83347_en-US

liliconcom

Inserting reports

Hi,

 

I was wondering if it is possible to insert a Word or Powerpoint document into a JMP file?  Appreciate any advice.

 

Best regards,

 

Jess

Re: Inserting reports

I agree with Jim, more information is needed.

 

Typically, requests for this type of Event Handler() have this type of scenario:

• A summary report is created and stored in a table of identifiers and indicators. 
• The sources for the indicators and summary statistics, that is, the actual plots, analyses, or original table files  are all stored in a shared file repository. The files for these plots and analyses have some type of key that can be constructed from the identifiers. If you look at the JMP Sample data table SAS Offices.jmp the column Cities defines the Event Handler script using the latitude and longitude columns. 
• Example: If the reports were created in order, maybe the report names are as simple as Capability_1.pptx. So the column of Cpk values would have a function with hardcoded file repository ( like the JMP paths), concatenated with "Capability_", char(thisRow) and ".pptx" 

The point being that there should be some linkage from that table row and possibly columns to the reports/files you want to open. 

Re: Inserting reportsI need more information about where the file names are. If they are all located in a folder, you can use
x = Files in Directory()
to retrieve all of the files found in a directory, and place them into a JSL ListRe: Inserting reports

Hi,

 

This is very nice.  I didn't know about Event Handler.  Thank you for your reply.  

I am still struggling on how to enter the files into the columns.  Any suggestions?  

Re: Inserting reportsThanks - that is exactly what I was thinking, appreciate you putting something together to demonstrate! This is actually very useful and I have been planning to start pushing people to use when it makes sense.Re: Inserting reports

If you have JMP 14, here is an example JMP Table, that uses the new column property 

Event Handler({thisTable, thisColumn, thisRow), script ) 

 

The attached data table has two columns, both have a an event handler column property. This is an application of what Jim was suggesting.

 

Re: Inserting reports

To pile on to @andersonmj2's reply, in JMP 14, JMP Projects has been completely redesigned from prior versions of JMP...so if you are someone NOT running JMP 14...this new JMP Projects deployment should be very exciting. I (truth be told as a JMP systems engineer) demonstrate this capability to many existing as well as prospective JMP users...and they break into big smiles with the JMP 14 version of Projects.

 

Here's a link to a Mastering JMP On Demand webinar hosted by my colleague Chris Kirchberg:

 

https://www.jmp.com/en_us/events/ondemand/mastering-jmp/organizing-work-using-projects.html

 

 

Re: Inserting reports

I will push back a little against @andersonmj2's response.  I believe that you can construct a script within the Column Property, Event Handler that can open up Word or PPT files.  Now, since JMP is column based, as apposed to Excel, which is cell based, there has to be an identifier in the value of the cell that can allow the Event Handler script to decern which Word or PPT to open.

Additionally, there is the ability to add as many scripts as desired into the data table in general, which can open virtually any type of file, or run programs.  These are data table based, not column or cell based, so you have the ability to have either table wide, or column/cell based links.

Re: Inserting reportsYou can insert all sorts of files and file types into a JMP Project - I use that all the time, and it keeps things organized and launches files in their respective apps.

However, there isn't a utility to insert an arbitrary file into a cell and have JMP pass to the OS to launch the host program, although the 'event handler' function might get at least somewhat close (i.e. you could insert the file address into the cell).Re: Inserting reports

It would be helpful to link (or imbed) reports to data table.  The reports may be in the format of powerpoint, word or pdf. 

Re: Inserting reports

Some questions.....

"into a JMP file"......a JMP Data Table?  The display output from a JMP Platform(i.e. Fit by Y, Distribution, etc.).  Into a JMP Journal?  Into a JMP Project?

 

What do you mean by "Insert".  You want the PowerPoint slides or Word Document to be showing in the JMP file?  Or do you want to have a field that you can link to those documents?