This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Created:
Aug 19, 2014 03:29 PM
| Last Modified: Nov 14, 2016 04:42 AM
Preview file
3398 KB
Supporting Files.zip
Authors
Brady Brady, JMP Enablement Engineer, SAS
Donald W. McCormack, JMP Enablement Engineer, SAS
At one time or another, you have likely “lost” a JMP table, journal or script. The file wasn’t really lost – just moved, altered or renamed. Traditionally, people have relied on creating a system of directories to keep track of files. There are a number of disadvantages to this method, the greatest of which is that the directory structure contains no information about what is in the files. We show a powerful and flexible file management application, built with JSL, which allows users to find data tables, journals and scripts using a variety of criteria. Topics include:
Methods for crawling through journals, scripts and data tables to extract file metadata and to categorize and locate scripts located within these files.
Combining local data filters with a hidden tabulate platform to avoid construction of complicated row selection WHERE clauses.
Using hidden output to derive and present search results.
Methods to locate and surface elements buried within large journals.
Using set operations and associative arrays to aggregate/summarize rows of multiple response columns by levels of a grouping variable.
Allowing users to view and edit file metadata without editing files directly.
WHERE clause considerations when using multiple response columns and data filters.
I am working on a project to organize and understand the information on a server. I can get the requisite info from Mircosoft Office files (docx, xlsx, and pptx). I would like to do the same for .jmp files since there are a great number of those. I really only need to know the column names at this point. I watched the presentation, are the finished scripts available? If not is there an alternative method? I can see on my Mac when I preview a JMP file in finder I can see the column names. Is there a tool available that would let me crawl a server to extract that data?