ExifTool Forum

ExifTool => The "exiftool" Application => Topic started by: zuiko3000 on February 19, 2018, 10:52:28 PM

Title: Create Date/Time among hundreds of files
Post by: zuiko3000 on February 19, 2018, 10:52:28 PM
Hi all,

I have thousands of pictures taken with several iPhones. About 60% of them have metadata so "Apple Photos"app is able to pull date/time and even location from these files. The rest of the pictures have not metadata so date and time are not available. When Apple Photos organizes them, the ones that have date/time are sorted but the ones that don't have any info, are put at the end.

Is there any way to create date/time among pictures in batch mode?

For instance:

photo 1 2/14/14 04:56
photo 2 <--                      new date and time 2/14/14 05:07
photo 3 2/14/14 05:15
photo 4 <--                      new date and time 2/14/14 05:45
photo 5 2/14/14 06:20

Create date and time in the middle so they are sorted.

These files are only sorted now by file name because iPhone saves them like IMG0001, IMG0002, etc...

Any ideas???

Thank you so much in advance.

David
Title: Re: Create Date/Time among hundreds of files
Post by: StarGeek on February 20, 2018, 03:25:03 AM
Exiftool operates on one file at a time, so reading a tag from the file before and after and calculating the average would probably need a script.

But if you have any spreadsheet experience, I would suggest exporting the data to a CSV file, loading that into a spreadsheet like excel or LibreOffice.  You could then figure out a formula to figure out the average, export the data back to a CSV and then reload it with exiftool.