Write tag value to image with csv file

Started by dkc, November 10, 2019, 01:30:17 AM

Previous topic - Next topic

dkc

Dear All

I am trying to write values to image with csv file.

There are several field in the csv file.
When I try to write value to image file, some values are written, some values aren't written.

I think because there are right tag name like Yaw, Pitch, Roll
What should I do solve this problem.
I am attaching sample files.

Thank you in advance.

Phil Harvey

The question is: Where do you want to write Yaw, Pitch and Roll?  There are no standardized EXIF or XMP tags available for these.  The sample config file shows how to define GPSPitch and GPSRoll tags in EXIF and XMP.  Along with these, you can use GPSImgDirection (and GPSImgDirectionRef) for the yaw angle.  Note that only ExifTool will be able to read the custom EXIF tags, but other apps may be able to read the custom XMP tags.

- Phil

Edit: Actually, the EXIF 2.31 specification added a CameraElevationAngle to both EXIF and XMP that may be used instead of GPSPitch.  Then it would be only GPSRoll for which you need a custom tag.
...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 ($).

dkc

Thank you for your help.

I get the config file from manufacturer of sense which is Micasense.
There are XMP custom tag for Yaw, Pitch, Roll.

So I used this configuration file with below command line
cmd = 'exiftool -config ../MicaSense.config -csv="csv file path" -overwrite_original

And I changed field name in csv file like (ex) XMP-DLS:Yaw).

So I could add my Yaw, Pitch, Roll

Thank you again.

Phil Harvey

It sounds like it may be working for you.  This works for me with the config file you posted:

> exiftool -config MicaSense.config -csv=log.csv .
    1 directories scanned
    3 image files updated
> exiftool -yaw -pitch -roll -G1 -a .
======== ./IMG_0800.jpg
[XMP-Camera]    Yaw                             : 2.022980662976513
[XMP-DLS]       Yaw                             : 2.022980662976513
[XMP-Camera]    Pitch                           : 0.4930616372767948
[XMP-DLS]       Pitch                           : 0.4930616372767948
[XMP-Camera]    Roll                            : 0.043007434369521744
[XMP-DLS]       Roll                            : 0.043007434369521744
======== ./IMG_0801.jpg
[XMP-Camera]    Yaw                             : 2.0375201297056793
[XMP-DLS]       Yaw                             : 2.0375201297056793
[XMP-Camera]    Pitch                           : 0.5018901831718523
[XMP-DLS]       Pitch                           : 0.5018901831718523
[XMP-Camera]    Roll                            : 0.06277172085829345
[XMP-DLS]       Roll                            : 0.06277172085829345
======== ./IMG_0802.jpg
[XMP-Camera]    Yaw                             : 2.0166868321432827
[XMP-DLS]       Yaw                             : 2.0166868321432827
[XMP-Camera]    Pitch                           : 0.5514595474522185
[XMP-DLS]       Pitch                           : 0.5514595474522185
[XMP-Camera]    Roll                            : 0.08056636217973329
[XMP-DLS]       Roll                            : 0.08056636217973329
    1 directories scanned
    3 image files read


- 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 ($).