#65743 - 2002-05-26 05:50 PM
metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
Anyone know how to access the properties / summary data of a file (from explorer in win2k/xp)
For example, if I wanted to edit the ownername property from a word document, or read the album name from a MP3.
|
|
Top
|
|
|
|
#65744 - 2002-05-26 10:10 PM
Re: metadata editing help needed
|
Howard Bullock
KiX Supporter
   
Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
|
All I can do at this time is list them:
code:
$obj = createobject("word.application") $objdoc = $obj.Documents.Open("c:\data\scripts\titlea.doc") for each $property in $objdoc.BuiltinDocumentProperties ? $property.name + "=" + $property.value next $objdoc.close $obj.quit
|
|
Top
|
|
|
|
#65745 - 2002-05-26 11:08 PM
Re: metadata editing help needed
|
Howard Bullock
KiX Supporter
   
Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
|
Radimus, I have now been successful in changing the "Title" and the "Author" of the document. I have confirmed this in both my Hex editor and Word. It surprised me that I did not have to explicitly SAVE the document.
code:
$obj = createobject("word.application") $objdoc = $obj.Documents.Open("c:\data\scripts\titlea.doc") for each $property in $objdoc.BuiltinDocumentProperties ? $property.name + "=" + $property.value next $objdoc.BuiltinDocumentProperties.item("Title").value="Title www" $objdoc.BuiltinDocumentProperties.item("Author").value="Kenobi, Obi-Wan (Ben)"
$objdoc.close $obj.quit
[ 26 May 2002, 23:22: Message edited by: Howard Bullock ]
|
|
Top
|
|
|
|
#65746 - 2002-05-26 11:44 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
Cool.. Do you know of a way to get it via explorer or scripting.filesystemobject. [ 27 May 2002, 00:29: Message edited by: Radimus ]
|
|
Top
|
|
|
|
#65747 - 2002-05-27 12:46 AM
Re: metadata editing help needed
|
Howard Bullock
KiX Supporter
   
Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
|
I'm still learning the COM object model. I can see the same data using IE propertites as I changed via Word COM. At this time I can't seem to find out how to do anything once I have the InternetExplorer application object.
$obj = createobject("internetexplorer.application") [ 27 May 2002, 00:47: Message edited by: Howard Bullock ]
|
|
Top
|
|
|
|
#65748 - 2002-05-27 06:40 AM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
This gets the file via COM, but I don't know what to do with it now... The for/next thig returns nothing.
code:
$filedir="\\server\drives$$\Listening\Singles" $obj = createobject("Scripting.FileSystemObject") $objdoc = $obj.getfolder("$filedir") ? $objdoc
$file= $obj.GetFile("$filedir\01--Wils.mp3") ? $file ? $file.name for each $property in $file ? $property.name + "=" + property.value next
$obj.quit
|
|
Top
|
|
|
|
#65749 - 2002-05-27 07:04 AM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
|
|
Top
|
|
|
|
#65750 - 2002-05-27 04:07 PM
Re: metadata editing help needed
|
Howard Bullock
KiX Supporter
   
Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
|
We'll I found this and it does not look like that data is not available using the FileSystemObject. FileSystemObject Properties
|
|
Top
|
|
|
|
#65751 - 2002-05-27 04:56 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
the previous post has come of the info needed, but doesn't specify the COM object used to get it.
this will enum a dir using COM: $obj = createobject("Scripting.FileSystemObject") $objdoc = $obj.getfolder("$filedir")
$d= $objdoc.Files for each $file in $d ? $file.name+" "+ $file.type next
$obj.quit
|
|
Top
|
|
|
|
#65752 - 2002-05-27 05:47 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
|
|
Top
|
|
|
|
#65754 - 2002-05-28 05:05 AM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
I came across references to ACShellExt.ContextMenu , but I don't know... This is a bit out of my league (for a systems Admin)
I've tried this:
code:
$filedir="\\server\drives$$\Listening\Singles" $fso= createobject("Scripting.FileSystemObject") $cd = $fso.getfolder("$filedir")
$shell = createobject("shell.application") $foldir = $shell.namespace("$filedir")
$folder= $cd.Files for each $file in $folder ? $file.name+" "+ $file.type $fparse = $foldir.parsename($file.name) $fparse.value next $shell.quit $fso.quit
I've replaced $fparse.value with every property I could think of, but nothing volunteers... [ 28 May 2002, 05:05: Message edited by: Radimus ]
|
|
Top
|
|
|
|
#65756 - 2002-05-28 02:00 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
It's getting there... Thanks for the help. but for some reason, it isn't pulling the title. Writing these values will be necessary
code:
break on $filedir="\\server\drives$$\Listening\Singles" $fso = createobject("Scripting.FileSystemObject") $cd = $fso.getfolder("$filedir") $folder= $cd.Files
$shell = createobject("shell.application") $foldir = $shell.namespace("$filedir").items
for each $file in $folder ; ? $file.name+" "+ $file.type
$fparse = $foldir.item($file.name) ? $fparse.extendedproperty("Name")+" " $fparse.extendedproperty("Title")+" " $fparse.extendedproperty("Artist")+" " $fparse.extendedproperty("Album")+" " next $shell.quit $fso.quit
[ 28 May 2002, 15:52: Message edited by: Radimus ]
|
|
Top
|
|
|
|
#65758 - 2002-05-28 11:28 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
|
|
Top
|
|
|
|
#65759 - 2002-05-28 11:33 PM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
|
|
Top
|
|
|
|
#65761 - 2002-05-29 01:46 AM
Re: metadata editing help needed
|
Radimus
Moderator
   
Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
|
it doesn't retuen any data, just the attribute name
Name-Size-Type- Name-Size-Type- Name-Size-Type-
|
|
Top
|
|
|
|
Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 931 anonymous users online.
|
|
|