Windows – How to bulk rename files in a directory using the Date column

bulkdaterenamewindows-explorer

I've got a list of a few hundred files that I need renamed by appending a modified version of the Date column to the front of the file name.

The tricky part is the use of the Date column. I've tried software like ReNamer and the Bulk Renaming Utility as outlined in this question's answers and while those allow you to append based on some date columns like Created Date and Modified Date, neither of those allow the use of the plain 'ol Date column.

Why? I need to upload these files to a DVD making software and have them processed chronologically, but the DVD making software doesn't look at the Date column so the only other option is to sort them by filename. So if I can get the Date string pre-pended to the filenames before I upload them, then in the DVD making software I can sort by file name and it will be a de-facto Date sort.

I'm open to solutions using command prompt, 3rd party software, whatever…

So in the image below, the first 3 files should be renamed to this (ignore the directory):

  • 20100402_MVI_0018.AVI
  • 20101102_MVI_0036.AVI
  • 20101202_MVI_0037.AVI

enter image description here

Edit 1

This answer states the Date field to be the older of either the Date Modified or Date Created unless the Date Taken column is populated, in which case it uses that. But I'm finding different cases!

In this image the Date column = Date Acquired even though Date Modified/Date Taken are both older.
enter image description here

And HERE'S something weird! Sometimes the Date column is the Date Taken field but exactly 12 hours ahead!?
enter image description here

Best Answer

I would

  1. Ignore the date column and decide which date I want to use: file creation date, file modified date or the "date taken" date from the AVI metadata. The first two are the easiest to make use of.

  2. If necessary, find a tool that extracts the metadata from an AVI file in a way that facilitates its use in a scripting language. This might depend on the specific variant details of the AVI files you are working with.

  3. Write a script in my favourite scripting language to perform the renaming. I would use Perl or Go because those are my favourite languages at the moment but most people might try Windows-batch, Powershell or something like Python. I've done this in the past a few times for renaming JPEG files.

Your Mileage May Vary.

Related Question