News:

2023-03-15 Major improvements to the new Geolocation feature

Main Menu

How to create a csv-file with all filenames from metadata?

Started by stephanie, November 23, 2016, 11:54:06 AM

Previous topic - Next topic

stephanie

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

Phil Harvey

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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

j99mac

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

Phil Harvey

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 for some examples.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).