ExifTool Forum

ExifTool => Newbies => Topic started by: metfun01 on January 22, 2014, 12:08:32 PM

Title: Trying to export csv
Post by: metfun01 on January 22, 2014, 12:08:32 PM
I am trying to export a single csv file for several photos using the drag-n-drop method of using the executable file (I don't have permission to install program in the windows folder to use the command line prompt).

I've been using the following name for the file "exiftool(-k -a -u -g1 csv).exe"  but it gives me a csv for each photo; is there any way to get the metadata combined into one file?

Thanks
Title: Re: Trying to export csv
Post by: Phil Harvey on January 22, 2014, 12:34:49 PM
I think you forgot a "-" before "csv" in your application name.  But I don't understand how you are getting one csv per file with this command.

The way to do this would be to make a drag-n-drop .bat file with a command something like this:

exiftool -a -u -g1 -csv %* > c:\out.csv

- Phil
Title: Re: Trying to export csv
Post by: metfun01 on January 22, 2014, 12:39:16 PM
How do I make a bat file? Would I type exiftool -a -u -g1 -csv %* > c:\out.csv   into notepad, save it as a .txt and then change the extension to .bat?
Title: Re: Trying to export csv
Post by: Phil Harvey on January 22, 2014, 12:54:34 PM
Yes.
Title: Re: Trying to export csv
Post by: k_grons on June 05, 2014, 12:24:44 PM
With the recommendation of the .bat file, are you saying this is not possible by adding options to the target property in the Windows executable file? Is there anyway to do something akin to adding -w txt to the target but for csv files?

Thanks!
Title: Re: Trying to export csv
Post by: Phil Harvey on June 05, 2014, 12:45:11 PM
With the recommendation of the .bat file, are you saying this is not possible by adding options to the target property in the Windows executable file?

Yes.  The target property does not support redirection.

Quote
Is there anyway to do something akin to adding -w txt to the target but for csv files?

No.  The -w option gives one output file for each input file, and is incompatible with the -csv option.

- Phil
Title: Re: Trying to export csv
Post by: k_grons on June 05, 2014, 12:50:02 PM
Hi Phil,

Thanks for the clarification - much appreciated!