ExifTool Forum

ExifTool => ExifTool GUI => Topic started by: stephanie on November 23, 2016, 11:54:06 AM

Title: How to create a csv-file with all filenames from metadata?
Post by: stephanie on November 23, 2016, 11:54:06 AM
Hello to all & special to Phil,

I am desperately trying to create one csv-file which contains all the filenames of my pictures (about 200 jpeg-files organized in folders and subfolders)?

I am using ExifToolGui (ExifTool direct) and already tried out the following option:

-r -filename -csv C:/Users/Stephanie.Drr@gmx.de/Desktop/Export /> filenames.csv

But it does not work.

ExifTool LOG notice is:

SourceFile,FileName
...
H:/Daten/Metadaten/FotografIn/Andreas_E/WalnussHal263.JPG,WalnussHal263.JPG
H:/Daten/Metadaten/FotografIn/Andreas_E/WalnussHal264.JPG,WalnussHal264.JPG
H:/Daten/Metadaten/FotografIn/Andreas_E/WalnussWald.jpg,WalnussWald.jpg
H:/Daten/Metadaten/FotografIn/Andreas_E/Ästung.jpg,Ästung.jpg
H:/Daten/Metadaten/FotografIn/Andreas_E/Bild_1.jpg,Bild_1.jpg
File not found: filenames.csv
    2 directories scanned
  132 image files read
    1 files could not be read
<-END-

Where is my mistake?
I am thankful for any help.

Many greetings from

Stephanie
Title: Re: How to create a csv-file with all filenames from metadata?
Post by: Phil Harvey on November 23, 2016, 11:59:46 AM
You have an extra "/" before the ">".  Also I think that you shouldn't be trying to specify the input folder name in the GUI.

And I don't know if redirection (">") will work in the GUI, so maybe you will need to do this instead:

-r -filename -csv -w+! C:/Users/Stephanie.Drr@gmx.de/Desktop/%0ffilenames.csv

- Phil
Title: Re: How to create a csv-file with all filenames from metadata?
Post by: j99mac on June 12, 2020, 07:51:16 AM
I tryed running the command with -w+! and got the error "Sorry, -w may not be combined with -csv
". I am running it on a Mac

This is my full command
exiftool -r -csv -w+! -filename -artist -make -model -CameraModel "$path" >> ${now}_tech.csv
Title: Re: How to create a csv-file with all filenames from metadata?
Post by: Phil Harvey on June 12, 2020, 08:41:05 AM
Ooops.  You're right.  My suggestion above won't work.

You'll have to use one of the alternatives to the -csv option.  See FAQ 12 (https://exiftool.org/faq.html#Q12) for some examples.

- Phil