Update Timestamp of file based on time in filename

[dcwul62]

I am looking for a way (script, or tool) that will update the timestamps of files based on the time in the filenames.
The time is always at the end of the filename, before the extensions.

Like: FilenameXYZ Bla-bla ddmmyyyy hhmmss.txt
or     FilenameXYZ Bla-bla yyyymmdd hhmmss.txt

I am already using a small script that updates the modified DATE, but not the modified TIME.

Have searched Internet for any tools, but regretfully can't find it.

Example:
ProgFileW10PShellModules.snippets-06-20141230 123456.txt  present date time : 15122003 141414
After updating date: the modified date reads 30-12-2014
but the time remains 14:14:14

I am looking for some tool, or so, that updates the time to 12:34:56

The default renamers can't do this.
I have no knowledge about programming.

If it is just 1 or just a few, then any ordinary attribute changer can handle that, but that is one by one, not in a batch.

Thanks!

[Ath]

What tool/script do you already have for updating the dates?

[dcwul62]

It is a vbs script to be used within Opus

[skwire]

Can you post the VBS snippet, please?

[dcwul62]

see pm

[skwire]

see pm

-dcwul62 (April 02, 2018, 07:59 AM)

Hmmm...never got a PM; you sure you sent it to me?

[dcwul62]

Sorry ...

I just now noticed: I accidentally clicked on the envelope-button, which is 'sending an email'.
Did you receive an email?

[skwire]

Sorry ...
I just now noticed: I accidentally clicked on the envelope-button, which is 'sending an email'.
Did you receive an email?

-dcwul62 (April 02, 2018, 11:47 PM)

I did not.

[4wd]

√ FilenameXYZ Bla-bla 12022011 130254.txt
√ FilenameXYZ Bla-bla 20141115_020218.txt
√ PatchToFiles-Video_2018-04-04_091419.wmv
√ Another F'n crappy name-2011_02_01-184901.sfa
√ Some-Other-Stupid-Filename .... 1999..12%&()23 ..!_- 231402.fck
√ Yet Another Example of Poor Standardised Naming-2001+08+03---15;34;34.dcm
√ Example of Poor Naming 32 - 03+03+2013---23;42;00.dcm


TfN.ps1

Code: PowerShell [Select]

1. Param (
2.   [string]$file,
3.   [int32]$type = 2
4. )
5. # Types: 0 = Creation Time
6. #        1 = Last Access Time
7. #        2 = Modified Time
8. #        3 = All of them
9.  
10. $fileObject = Get-ChildItem -Path $file
11. $wanted = (($fileObject.BaseName | %{ -join $_[$_.Length..0] }) -Replace '(\D)', '').Substring(0,14)  | %{ -join $_[$_.Length..0] }
12. $pattern = 'yyyyMMddHHmmss'
13. If ($wanted.Substring(4, 2) -gt "12") { $pattern = 'ddMMyyyyHHmmss' }
14. $date = [DateTime]::ParseExact($wanted, $pattern, $null)
15. Switch ($type) {
16.   "0" {$fileObject.CreationTime = $date; break}
17.   "1" {$fileObject.LastAccessTime = $date; break}
18.   "2" {$fileObject.LastWriteTime = $date; break}
19.   default {
20.     $fileObject.CreationTime = $date
21.     $fileObject.LastAccessTime = $date
22.     $fileObject.LastWriteTime = $date
23.   }
24. }

TfN.ps1 <file> <type>

type = Read script

Example:
.\TfN.ps1 "ProgFileW10PShellModules.snippets-06-20141230 123720.txt" 0

Update Timestamp of file based on time in filename

Update Timestamp of file based on time in filename

TfN.cmd <dir> <type>

Code: Text [Select]

1. pushd %1
2. for /f "usebackq tokens=* delims=" %%a in (`dir "%~1" /b /a-d-h-r`) do (
3.       powershell.exe -ExecutionPolicy Bypass -File C:\PoSh\TfN.ps1 "%%~a" %2
4.       )
5. popd

Update Timestamp of file based on time in filename

Update Timestamp of file based on time in filename

[dcwul62]

Sorry ...
I just now noticed: I accidentally clicked on the envelope-button, which is 'sending an email'.
Did you receive an email?

-dcwul62 (April 02, 2018, 11:47 PM)

I did not.

-skwire (April 02, 2018, 11:51 PM)

"Your message has been sent successfully."

please could you check again?

thanks a lot!

[dcwul62]

Thanks 4WD.
I'll check it out. Right now I seem to have issues with executing .ps1 file (executionpolicy, whatever)

[wraith808]

Thanks 4WD.
I'll check it out. Right now I seem to have issues with executing .ps1 file (executionpolicy, whatever)

-dcwul62 (April 03, 2018, 03:19 AM)

You need to change the execution policy to run many powershell scripts

https://www.addictiv...ll-execution-policy/

[highend01]

Alternatively, try this...

Written in PureBasic.
Accepts one parameter, the filename (put it in quotes if it contains spaces)!

It is a command line app, the return values are the following:
0 = Everything went fine, modified time should be set correctly
1 = You forgot to call it with a filename
2 = The filename does not exist!
3 = There isn't a space where it should be (between date and time in the filename)
4 = Either the date or the time doesn't have the expected length (8 chars for the date, 6 for the time)
5 = Setting the new modified date failed (could e.g. happen if you try to change a date for a file in a UAC protected directory, and the app was not called with admin permissions)

[dcwul62]

Thanks.

The idea is to do this in a batch, i.e. for multiple files simultaneously.

For years I have this script that is doing exactly what I want.
It is working fine, with just 1 exception...
updating time, when the date format in the file is yyyymmdd
In case the date format is ddmmyyyy then it is okay.

So far I manually update the time of such files using the change date time attributes
within Opus. It is not a big issue, but I would like to have it in a script.

Have sent skwire the script by PM.

So, let's wait for his feedback.

Anyway, many thanks so far!
Truly appreciate your support.

PatchToFiles-Video_2018-04-04_091419.wmv (400.27 kB - downloaded 529 times.)

[skwire]

Have sent skwire the script by PM.

-dcwul62 (April 04, 2018, 02:23 AM)

If possible, please post the script here so everybody can help.   

[highend01]

This one does it for all files in a folder (not recursively)...

Accepts one parameter, the foldername (put it in quotes if it contains spaces, full path required)!

It is a command line app, the return values are the following:
0 = Everything went fine, modified times should be set correctly
1 = You forgot to call it with a foldername (full path)
2 = The folder does not exist!
3 = Setting the new modified date failed (could e.g. happen if you try to change a date for a file in a UAC protected directory, and the app was not called with admin permissions)

Ofc this version just skips all files that do not fulfill the requirements...

[4wd]

...
updating time, when the date format in the file is yyyymmdd
In case the date format is ddmmyyyy then it is okay.

-dcwul62 (April 04, 2018, 02:23 AM)

I have an idea, how about you standardise your filenames instead of having other people try and conform to your seemingly chaotic system?

It started off with:
yyyymmdd_hhmmss
ddmmyyyy_hhmmss

Now it appears that yyyy-mm-dd_hhmmss is also to be included, no doubt there's also dd-mm-yyyy_hhmmss plus who knows what other combinations.

Choose a format and do a rename of all the non-conforming files before running the script that sets the timestamps and then the whole process becomes simpler for everyone.

Updated

[dcwul62]

I have a regex for almost every format. Opus vbs script containing all kinds of possibilities. (If this then that, etc.).
With   [-\s_]*  I cover 99% of the cases.
The only  exception is mentioned in my earlier post, specifically updating the time stamp only (date is updated)

Anyway, I suggest to drop the issue. It is not worth spending more time on.

Would like to thank you all for thinking along! Really appreciated.