No SourceFile... in imported CSV database

[ejm554]

I'm getting an error message when trying to update some image files using a CSV file. However, I can see the SourceFile record that ExifTool says does not exist.


$ exiftool -csv=out3.csv  .
No SourceFile './201808.IMG_4171.0.jpg' in imported CSV database
(full path: '/Users/ejm/~Temp/Updating_From_CSV_Test_2018-09-29/201808.IMG_4171.0.jpg')
[...]
    1 directories scanned
    0 image files read


See attached screenshot that (I think) demonstrates that the record exists.



This is my first time using a CSV to update metadata, so I suspect that I'm just missing something simple.

Regards,
EJ

[Phil Harvey]

I can't see anything obvious.

Try adding the -v2 option to your command to make sure that ExifTool is importing this line from the CSV file.

- Phil

[ejm554]

That tip helped! By using -v2, I was able to see that the SourceFiles in question were indeed missing from the CSV file, at least as far as ExifTool was concerned. Not sure why, but I (re-)added the missing SourceFiles, and all is well.

Update:
In looking more closely at my screenshot, I noticed an indicator that my CSV had unsaved changes. Doh!



EJ

[Phil Harvey]

There must have been some sort of format error in the CSV file.  Honestly, it would be hard to get ExifTool to ignore a line, but it could happen if there was an unpaired quotation mark in a previous line.

- Phil

[ejm554]

Nope. Just unsaved changes. See my update.

EJ

[Phil Harvey]

Cool.  Learn something new every day.  I've been on Mac forever, but didn't know about that black dot.

- Phil