The problem with file time stamps<\/h2>\n
A few months ago, I wrote a function that uses Windows PowerShell to modify file access time stamps<\/a>. In the Hey, Scripting Guy! Blog where I discussed this technique, I envisioned creating a single DateTime<\/b> object and using that to set all three of the file access time stamps. I even discussed my use case scenario, which was to use the technique as a sort of cheap versioning system while I was working on the Windows 7 Resource Kit.<\/p>\n This week, however, as I began working with the Word documents stored on my computer for all of the Hey Scripting Guy! Blogs I have written, I came up with another use for the function−to correct time stamps that are modified through various means (such as backup and restore from a network SAN and modifications created to Microsoft Word built-in properties). Luckily, all of my Hey, Scripting Guy! Blogs have a file name based on the date in which the blog appears. For example, the file for today’s Weekend Scripter is: WES-8-4-12.docx. I am assured the file names are consistent because I have a Windows PowerShell script that creates all of the 365 files I need each year (the script also creates folders for each week of the year, and folders for each year.<\/p>\n With a file name of WES-8-4-12 or HSG-8-2-12, it is really easy to find the date portion of the file name. All I need to do is to retrieve the item (by using Get-Item<\/b> or Get-ChildItem<\/b>). WhenI have the FileInfo<\/b> <\/i>object, I use the BaseName<\/b> <\/i>property to obtain only the file name without the path or the file extension. Therefore, in my example, HSG-7-23-12 returns the following.<\/p>\n PS C:\\> $a = Get-Item C:\\fso\\HSG-7-23-12.docx<\/p>\n PS C:\\> $a.basename<\/p>\n HSG-7-23-12<\/p>\n When I have a value such as HSG-7-23-12, I can easily convert that value to provide me with a DateTime<\/b> <\/i>object. To do this, I first remove the HSG-<\/i> portion of the filename. This technique is shown here.<\/p>\n PS C:\\> $a = Get-Item C:\\fso\\HSG-7-23-12.docx<\/p>\n PS C:\\> $a.basename<\/p>\n HSG-7-23-12<\/p>\n PS C:\\> $a.BaseName.Substring(4)<\/p>\n 7-23-12<\/p>\n Now, all I need to do is to cast that value to a datetime <\/i>object and I am finished. This appears here.<\/p>\n PS C:\\> $a = Get-Item C:\\fso\\HSG-7-23-12.docx<\/p>\n PS C:\\> $a.basename<\/p>\n HSG-7-23-12<\/p>\n PS C:\\> $a.BaseName.Substring(4)<\/p>\n 7-23-12<\/p>\n PS C:\\> [datetime]$a.BaseName.Substring(4)<\/p>\n Monday, July 23, 2012 12:00:00 AM<\/p>\n The commands and the output associated with the commands are shown in the figure that follows.<\/p>\n Interestingly enough, it is possible to do this all on a single line. This technique is shown here.<\/p>\n PS C:\\> [datetime](Get-Item C:\\fso\\HSG-7-23-12.docx).basename.substring(4)<\/p>\n Monday, July 23, 2012 12:00:00 AM<\/p>\n Now that I know I can create a DateTime<\/b> <\/i>object from the base file name, it is a simple matter of replacing Get-ChildItem<\/b> for Get-Item<\/b>, and looping through the returned files. I talked about filtering files on Monday<\/a> of this week and on Tuesday of the week<\/a>.<\/p>\n Because Microsoft Word changed the file extension during the four years that I have been writing the Hey, Scripting Guy! Blog, I decided to use a wild card character in the extension<\/b> property. To see how many of each type of files I have, I used the following command where I group by the extension. The command and the output associated with the command are shown here (gci<\/b> is an alias for the Get-ChildItem<\/b> cmdlet).<\/p>\n PS C:\\> Get-ChildItem -Recurse -Path C:\\data\\ScriptingGuys -Include HSG*.doc*,WES*.doc* | group<\/p>\n extension<\/p>\n <\/p>\n Count Name Group<\/p>\n —– —- —–<\/p>\n 731 .docx {C:\\data\\ScriptingGuys\\2008\\hsg_11_17_08\\HSG_QHF_…<\/p>\n 359 .Doc {C:\\data\\ScriptingGuys\\2009\\HSG_10_12_09\\HSG-10-1…<\/p>\n To pick up the date from the file names as they cross the pipeline, I use the Foreach-Object<\/b> cmdlet and a version of the command I derived earlier in this blog. The command is shown here.<\/p>\n Get-ChildItem -Recurse -Path C:\\data\\ScriptingGuys -Include HSG*.doc*,WES*.doc* |<\/p>\n foreach-object {[datetime]$_.basename.substring(4)}<\/p>\n I decided to make a few changes to the Set-FileTimeStamps<\/b> function from the previous blog posting. There are two reasons. The first is that I want to pass a System.Io.FileInfo<\/b> object to the function instead of a path. Secondly, the Path<\/b> <\/i>parameter in the original function uses a string, and passing a FileInfo<\/b> object to the function automatically casts the object to a string. When this happens, the $doc<\/b> variable no longer contains a FileInfo<\/b> object, but rather it contains a string. This generates an error stating that the object does not contain a property named CreationTime<\/b> or any of the other properties. The modified Set-FIleTimeStamps<\/b> function is shown here.<\/p>\n Function Set-FileTimeStamps<\/strong><\/p>\n {<\/p>\n Param (<\/p>\n [Parameter(mandatory=$true)]<\/p>\n [system.io.fileinfo]$doc,<\/p>\n [datetime]$date = (Get-Date))<\/p>\n ForEach-Object {<\/p>\n $doc.CreationTime = $date<\/p>\n $doc.LastAccessTime = $date<\/p>\n $doc.LastWriteTime = $date }<\/p>\n } #end function Set-FileTimeStamps<\/p>\n <\/p>\n The script parameters must reside at the top of the script. The parameters section has not changed from any of the other scripts used this week. It is shown here.<\/p>\n Param(<\/p>\n $path = “C:\\fso”,<\/p>\n [array]$include = @(“HSG*.docx”,”WES*.docx”))<\/p>\n The entry point to the script, accepts the command line parameters, and uses Get-ChildItem<\/b> to find all of the files. It then walks through the collection of FileInfo<\/b> objects, creates the time stamp from the file name, and calls the Set-FileTimeStamps<\/b> function. This is shown here.<\/p>\n ## entry point to script<\/p>\n $docs = Get-childitem -path $Path -Recurse -Include $include<\/p>\n Foreach($doc in $docs)<\/p>\n {<\/p>\n Try<\/p>\n {<\/p>\n $date = [datetime]$doc.BaseName.Substring(4)<\/p>\n Set-FileTimeStamps -Doc $doc -date $date<\/p>\n }<\/p>\n Catch [System.Exception] {“Error occurred setting date for $doc”}<\/p>\n }<\/p>\n When the script runs, it finds all of the appropriate files and makes the requisite changes to the file time stamps. One such file is shown in the image that follows.<\/p>\n I uploaded the complete script<\/a> to the Scripting Guys Script Repository.<\/p>\n Well, that is all for today. Join me tomorrow when I have a new PowerTip and I introduce the “love-o-matic.” It is cool, and is the latest Scripting Guys “o-matic” tool.<\/p>\n I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n Ed Wilson, Microsoft Scripting Guy<\/b> <\/p>\n","protected":false},"excerpt":{"rendered":" Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to set the time stamps on Microsoft Word document files. Microsoft Scripting Guy, Ed Wilson, is here. It is Saturday here in Charlotte, and the sunshine continues to make its presence known. It seems that the sun gets up rather early during the summer, […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[38,3,12,61,45],"class_list":["post-8471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-scripting-guy","tag-storage","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to set the time stamps on Microsoft Word document files. Microsoft Scripting Guy, Ed Wilson, is here. It is Saturday here in Charlotte, and the sunshine continues to make its presence known. It seems that the sun gets up rather early during the summer, […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/8471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=8471"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/8471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=8471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=8471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=8471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/4747.wes-8-4-12-01.png\" "\\"Image")
<\/a><\/p>\nExpanding the technique a bit<\/h2>\n
Adding in the function and changing all the time stamps<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/4405.wes-8-4-12-02.png\" "\\"Image")
<\/a><\/p>\n