Help importing data from a CSV

[MartinDanK]

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



and my CSV source file looks:



I tried this command, but then nothing happens.

Code Select Expand

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?

[Phil Harvey]

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

[MartinDanK]

Okay then my command was correct, just the CSV is not.

I now changed it to



But now I get

Code Select Expand

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?

[Phil Harvey]

Your CSV file is now using semicolons instead of commas.  Change these back to commas and it should work.

- Phil

[MartinDanK]

Worked perfect now, very very very much thank you!