If I may attach myself to this thread ;)
I did not want to start new one since my probblem is pretty much the same, but I cannot find a solution.
In a folder I have:
824 pictures with missing createDate
efixtool.exe
values.csv, which contains filenames and CreateDate
(https://abload.de/thumb/zwischenablage01ilcsx.jpg) (https://abload.de/image.php?img=zwischenablage01ilcsx.jpg)
and my CSV source file looks:
(https://abload.de/thumb/zwischenablage02lsf6n.jpg) (https://abload.de/image.php?img=zwischenablage02lsf6n.jpg)
I tried this command, but then nothing happens.
C:\Users\myname.m\Downloads\iCloud Fotos\iCloud Fotos Teil 2 von 2\iCloud Fotos Teil 2 von 2\ohne Datum>exiftool -csv="values.csv" .
1 directories scanned
0 image files updated
824 image files unchanged
What am I doing wrong?
The problem is your date/time formatting in your CSV file. ExifTool expects the date/time in YYYYmmddHHMMSS format (with any separators you want), but you are giving ddmmYYYY.
- Phil
Okay then my command was correct, just the CSV is not.
I now changed it to
(https://abload.de/thumb/zwischenablage01zldm2.jpg) (https://abload.de/image.php?img=zwischenablage01zldm2.jpg)
But now I get
C:\Users\user\Downloads\iCloud Fotos\iCloud Fotos Teil 2 von 2\iCloud Fotos Teil 2 von 2\ohne Datum>exiftool -csv="valuesformat2.csv" .
Invalid tag name 'SourceFile;CreateDate' in CSV file
No SourceFile './044418-090918.jpg' in imported CSV database
(full path: 'c:/users/user/downloads/icloud fotos/icloud fotos teil 2 von 2/icloud fotos teil 2 von 2/ohne datum/044418-090918.jpg')
No SourceFile './20130318_153919-bearbeitet.jpg' in imported CSV database
(full path: 'c:/users/user/downloads/icloud fotos/icloud fotos teil 2 von 2/icloud fotos teil 2 von 2/ohne datum/20130318_153919-bearbeitet.jpg')
No SourceFile './20150524_200309.jpg' in imported CSV database
(full path: 'c:/users/user/downloads/icloud fotos/icloud fotos teil 2 von 2/icloud fotos teil 2 von 2/ohne datum/20150524_200309.jpg')
No SourceFile './20150524_200414-bearbeitet.jpg' in imported CSV database
(full path: 'c:/users/user/downloads/icloud fotos/icloud fotos teil 2 von 2/icloud fotos teil 2 von 2/ohne datum/20150524_200414-bearbeitet.jpg')
No SourceFile './20160306_212153.jpg' in imported CSV database
(full path: 'c:/users/user/downloads/icloud fotos/icloud fotos teil 2 von 2/icloud fotos teil 2 von 2/ohne datum/20160306_212153.jpg')
Seems to be a problem with finding files in directory based on my csv? But the files are in the folder!
Maybe important: in my csv i have about 9.000 entries, while in the folder there are about 900 files. But I think exiftool should ignore the files missing and just process the rest?
Your CSV file is now using semicolons instead of commas. Change these back to commas and it should work.
- Phil
Worked perfect now, very very very much thank you!