Issues with EXIF Command (GPS to Image EXIF)

[Yalios]

Hi,
i'am trying to get my GPS Data (lat,lon,alt,pitch,roll,yaw) into the Exif data of my 194 Images. First Problem Picture Date is NOT the Same as The GPS Time but the number of Images is equal to the Number of GPS Data. So i have copy all data i need in one CSV that looks like that:

SourceFile;gpstimestamp;gpslatitude;gpslatituderef;gpslongitude;gpslongituderef;gpsaltitude;gpsaltituderef
DSC06781.JPG;122422,00;5216,9581209;N;1325,7358454;E;34,842;above sea level;;;
DSC06782.JPG;122426,00;5216,9581088;N;1325,7358363;E;34,807;above sea level;;;
DSC06783.JPG;122430,00;5216,9580943;N;1325,7358298;E;34,798;above sea level;;;

Now i Have tryed the Following Command:
exiftool -GPSLatitude -GPSLongitude -GPSAltitude -GPSLatitudeRef -GPSLongitudeRef -GPSAltitudeRef -GPSImg_Direction -GPSpitch -gpsroll -csv="C:/EXIF_Test_RTK_a6000/A6000_EXIF_LAT_LON_ALTITUDE.csv" -o output/ C:/EXIF_Test_RTK_a6000

and get Errors Like this:

No SourceFile 'C:/EXIF_Test_RTK_a6000/DSC0678.jpg' in imported CSV database (full path: 'C:/EXIF_Test_RTK_a6000/DSC0678.jpg')

What ist Wrong with my Code?

i hope someone can help me with this "Problem"

Greetings
Yalios

[StarGeek]

The first problem is that you have a Semicolon Separated File.  From the docs on the -csv option:
   ...and values must be separated by commas.

You would also have to change from using a comma to a dot to indicate the decimal.

The second problem is listed by the error result.  Exiftool tells you No SourceFile 'C:/EXIF_Test_RTK_a6000/DSC0678.jpg.  Your file contains only the file names, while exiftool is looking for the full path.  You can either add the file path to the file names in the CSV file or change your working dir to C:/EXIF_Test_RTK_a6000/ and use a dot to represent the current directory.  You would have to change your output directory to reflect the full path in that case.

Your example file lists shows a column for GPSTimeStamp, but there is no time data in that first column. It also doesn't include GPSDateStamp.  GPS time is supposed to be UTC.  Rather than try and make an entry for each file, it would be easier to copy from DateTimeOriginal and tack on the time zone to the copy.  Exiftool will adjust the time and date properly.  For example, for my Pacific Standard Time:
exiftool "-GPSTimeStamp<${DateTimeOriginal}-08:00" "-GPSDateStamp<${DateTimeOriginal}-08:00" DIR

Additionally, all the tags you list serve no function in this case.  All tags listed in the CSV file will be added to the files.

Finally, your example command is using fancy quotes ".  Make sure you're using regular quotes "

[Yalios]

Hi,

Sorry for the late response i was busy. Thank you very much you are my Hero now! After reorganising my Data it worked for me. The timestamp was like hhmmss so it dont look like Time Data i have now to sperated gpsDatestamp and gpstimestamp


I Added some new Lines like
GPSDatestamp,GPSimagedirection,GPSPitch,GPSRoll

And Transform my Koordinates into decimal degree.

My New .csv looked now like that:

Sourcefile,gpsdatestamp,gpstimestamp,gpslatitude,gpslatituderef,gpslongitude,gpslongituderef,gpsaltitude,gpsaltituderef,GPSImgDirection,GPSPitch,GPSRoll
DSC06813.JPG,14.11.2019,12:26:30,5216.958083,N,1325.735715,E,34.761,above sea level,358.09,0.06,2.3
DSC06814.JPG,14.11.2019,12:26:34,5216.958171,N,1325.735538,E,35.594,above sea level,357.5875,0.2375,1.25
DSC06815.JPG,14.11.2019,12:26:38,5216.958124,N,1325.735488,E,44.858,above sea level,357.6625,0.0125,1.6125

Now Everything works fine, exept Pitch and Roll i read in https://exiftool.org/geotag.html#Orient that i have make That EXIF Tags by myself.  But i can´t figure out where i have to write the Config file mentioned in this Link.

Thank you in advance, I didn't think I'd get such a competent answer so quickly! Thank you again.

Greetings
Yalios

[StarGeek]

exept Pitch and Roll i read in https://exiftool.org/geotag.html#Orient that i have make That EXIF Tags by myself.  But i can´t figure out where i have to write the Config file mentioned in this Link.

Download and save the example.config file to the same directory as ExifTool, renaming it as .ExifTool_config.  The dot at the front is important and you won't be able to rename it properly from the windows desktop.  It's best to save it directly to the new name from the browser.

That example config file already has the GPSPitch and GPSRoll defined so you don't need to edit it.