My situation is the following:
- At some point I got a large database of music files, in mp3 format.
- I added album covers using MP3tag automatically.
- That software changed the timestamps of all my music files to some new values.
- I still had the pre-changed files, the files with the original timestamps.
- Now, a dilemma – based on 1,000 files with old/new timestamps, how can I transfer the old timestamps to new timestamps?
The solution proved a bit difficult. I detail it, below.
The process is detailed in the attached document »
I also partially detail it here:
- Download File Time Changer » (direct link»)
- Download File Touch »
- Create two folders: 1. A folder with the original files, with the original timestamps. 2. A folder with the new files, different timestamps.
- Run a command prompt
- Change directory to the old folder
- Run this command: dir /O:GNE /b >a.txt
- Excel – Create First Batch File based on TXT file – step 1 – copying to Excel
- Excel – Adding two columns
- Notepad – Copy & paste to notepad
- Notepad – Remove tabs and empty spaces
- Windows Explorer – Save as bat and run in the OLD folder
- Excel: Copying to Excel, adding two columns – The left column is an index. The second one is just self-repeating.
- Excel: Sorting by index
- Excel: Keeping only the relevant rows
- Excel: Sorting by index
- Excel: Messing a bit with the date format
- Excel: Adding another index column
- Excel: Sorting so date we can change the date
- Excel: Change date format
- Excel: Sorting again, this time reversed, so time is first in list
- Word: Copy & paste to word
- Word: First search & replace – SEARCH & REPLACE :00^p with :00 ” (pay attention to quotes, they should be in autoformat as you type straight quotes)
- Word: Second search & replace – SEARCH & REPLACE [space] ^p with quotes ^p (pay attention to quotes, they should be in autoformat as you type straight quotes)
- Excel: Copy & paste from Word, adding the command to run the software
- Notepad: Copy & paste to notepad
- Notepad: Search & Replace ” ” (tab, as pressed on keyboard) with space
- Notepad: Search & Replace ” ” (double space) with ” ” (space). Repeat.
- Explorer: Save the file with BAT extension and run in THE NEW folder