ExifTool Forum

General => Metadata => Topic started by: Chris75 on April 11, 2013, 01:35:42 AM

Title: write tags to csv/txt file listed by filename.jpg
Post by: Chris75 on April 11, 2013, 01:35:42 AM
Hello,
Is it possible to write tags of an image folder (e.g. the orientation) listed by the filenames to a csv/txt file?

Thanks & best regards,
Chris
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Phil Harvey on April 11, 2013, 07:15:43 AM
Hi Chris,

Yes:

exiftool -csv -orientation FOLDER_NAME > out.csv

- Phil
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Chris75 on April 14, 2013, 08:30:39 AM
Ah, great.  :)
Thank you, Phil.

Best,
Chris
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Chris75 on June 19, 2013, 03:21:08 PM
Hi Phil,

Is it possible to write tags like e.g. image direction to JPGs by filenames listed in such a csv or txt?

Thanks,
Chris



Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Phil Harvey on June 19, 2013, 07:17:36 PM
You can do this with any number of writable tags in the same command.  See the Tag Name documentation (https://exiftool.org/TagNames/) if you want to see what tags are writable (spoiler: just about any tag you can imagine).

- Phil
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Chris75 on June 22, 2013, 11:03:04 AM
Hi Phil,

Thanks for your input on the tags which was very helpful. I couldn't find a solution anyway.
If I like to write the attributes from a csv or txt file to the JPGs exifdata and overwrite the existing values - how can I process it? I can write the same date or ascending/descending it by increment but how to transfer tags from a table?
e.g. table with attributes/tags
IMG1.jpg, GPSLatitude1, GPSLongitude1, datetimeoriginal1
IMG2.jpg, GPSLatitude2, GPSLongitude2, datetimeoriginal2
...
Can I write the datetimeoriginal tags or other attributes available to the exif data of the JPGs, not one by one but in batch proces?

This would be the other way around to the cmd "exiftool -csv -orientation FOLDER_NAME > out.csv" for the orientation tag and creating the csv from the JPGs.

Thanks & best regards,
Chris
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Phil Harvey on June 22, 2013, 03:01:09 PM
Hi Chris,

The inverse of this command

exiftool -csv -orientation FOLDER_NAME > out.csv

is this

exiftool -csv=out.csv -orientation FOLDER_NAME

- Phil
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Chris75 on June 23, 2013, 04:45:59 AM
Thanks again, Phil.
Would be of great help for me if it transfers the attributes from the csv table to the exif of the JPGs.

Best regards,
Chris
Title: Re: write tags to csv/txt file listed by filename.jpg
Post by: Phil Harvey on June 23, 2013, 06:05:38 AM
That it does.

- Phil