465303_en-US

liliconcom

Automatically collect file name and date of a document

Hello,

a lead working in Quality Assurance have to manage thousands of documents (excel, word, pdf, power point). He wants to automatically collect a) file name , b) date of creation, c) date of last update as a JMP file to quickly identify which documents are up-to-date or have been recently updated or likely need revision (ISO9001 requires regular updates/checking for appropriateness). In addition he wants to evaluate the content by comparing documents to identify redundancy (i.e. 2 documents with different names but with the exact same content) or mismatch ((i.e. 2 documents with the same name but with different content). I don't see any workaround with JMP but was wondering if anyone have an idea. Thanks for the help. Emmanuel

Re: Automatically collect file name and date of a document

Although JSL provides some 'file' capabilities (for example, 'Files In Directory()' and 'File Exists()'), I'm inclined to think you would have more luck with using 'RunProgram()' to execute OS commands or utilities from JMP. But, as you imply I think, if you are doing that you may not need to bother with JMP at all.

Re: Automatically collect file name and date of a document

Names Default to Here( 1 );

dt = New Table(
 New Column( "File Name", Character, Nominal ),
 New Column( "Created", Numeric, Continuous, Format( "ddMonyyyy:h:m:s", 22, 0 ) ),
 New Column( "Modified", Numeric, Continuous, Format( "ddMonyyyy:h:m:s", 22, 0 ) )
);

file = Files In Directory( "$SAMPLE_DATA" );
n files = N Items( file );

For( f = 1, f <= n files, f++,
 path = "$SAMPLE_DATA/" || file[f];
 Eval(
  Substitute(
   Expr( dt << Add Rows( { :File Name = nnn, :Created = ccc, :Modified =  mmm } ) ),
   Expr( nnn ), file[f],
   Expr( ccc ), Creation Date( path ),
   Expr( mmm ), Last Modification Date( path )
  )
 )
);

Re: Automatically collect file name and date of a document

FWIW, my reply above was in relation to the stated 'In addition' requirements . In this regard you might be able to make some progress with blobs. But I'm not sure how much work this would be, nor how reliable the results for the different file types might be. 

Re: Automatically collect file name and date of a document

You can see what information is currently (JMP Pro 17 under development) available through JSL functions by selecting Help > Scripting Index and then click the popup button and select Functions. Now select the File group on the left. This result is what you should see:

 

 

I do not see the name of the creator or modifier in this list. That information might not be stored with the file directory.

Re: Automatically collect file name and date of a document

is there any documentation on the blob ? I'm able to use Char to blob to collect information from a word document, but I'm not sure how to compare 2 documents to identify if identical or different ? and wondering if we can isolate the differences if any.