How can I get a Metadata report for a selected set of files

[aka_db]

Hi,

I need to run a report for a filtered selection of files from multiple directories and can only seem to be able to either run for all files in a directory or selected files but not all metadata.

Thanks, Db.

[admin]

Hi and welcome,

You are talking about the Info Panel / Report / Current Folder tab, right? And you want to have the "MetaData to CSV" report, but only for the selected files? Indeed, that's currently not possible. I will see if I can add it.

Don

[admin]

FYI, a Metadata report for a selected set of files is already possible now using scripting. However this is not yet fully documented in Help. The nom de guerre for it is Portable Metadata Layouts (PML).

For example, this line...

Code: Select all

text property("Name,Size,Write,FileVersion", "%winsysdir%\msvbvm60.dll", "m");

will return something like this:

Code: Select all

          Name: msvbvm60.dll            
          Size: 1384479                 
          Write: 14.04.2008 02:22:18    
          FileVersion: 6.0.98.2         

So, it's quite easy to loop this through all selected files. Ask if you are interested... The script can be wrapped into a toolbar button and the whole job will be just a click on a button.

[aka_db]

Hi, Does this mean that I can do this, or I need to request you do create this and provide an update version? If I could create this capability and add it to a tool bar, that would be great, how is this done?

It seems like a perfect solution, especially if I can decide which fields I actually want to return as I do not require all fields, just the following:

File Name, File Path, Owner, Date Created, Date Modified, date Last Accessed, File Size. My problem is that I have to run this over very large numbers of files in many directories.

Thanks, db.

P.S. I will be purchasing a license of this application tomorrow, I think it is excellent.

[aka_db]

Hi, I was also wondering if I can limit the Meta Data report to certain file types like *.tab, *.wor or if I could run the find files and then invoke the Meta Data report over that result set it would be perfect.

Thanks, Daryl.

[admin]

Hi, I was also wondering if I can limit the Meta Data report to certain file types like *.tab, *.wor or if I could run the find files and then invoke the Meta Data report over that result set it would be perfect.

The latter would be the easiest way.

Let's first work out the format of your Metadata report. BTW, I decided that the report command is better suited for this. So please select some files and then run this line through the address bar:

Code: Select all

text report("{Name}, {Fullpath}, {prop:Owner}, {modified yyyy-mm-dd hh:nn:ss}, {created yyyy-mm-dd hh:nn:ss}, {accessed yyyy-mm-dd hh:nn:ss}, {Size FLEX}<crlf>", 1);

Is this what you wanted to get?

PS: See also here for some info: http://www.xyplorer.com/release_12.70.htm#ExtRep

[aka_db]

Hi, this is exactly what I was looking for, thanks. Can the returned size be changed to kb or mb on the fly, not that it matters, I can convert it later.

Thanks very much, really appreciate the assistance.

Cheers, db.

[binocular222]

Size format can be customized:
see help file > Advanced Topic > Scripting Command Reference > Report
Optional format definitions for the {Size} field:
{Size KBR} KB (rounded up)
{Size KB} KB
{Size B} Bytes (no suffix)
{Size BB} Bytes (with suffix)
{Size FLEXR} Flexible (rounded up)
{Size FLEX} Flexible
{Size RAW} Raw bytes (no thousand separators)
{Size MB} MB
{Size GB} GB
{Size TB} TB
{Size PB} PB
{Size} [no format: use current Size Column Format]

[aka_db]

That is perfect, thanks.