lantrix · May 1, 2025 00:19 · Mar 18, 2017 · Aug 11, 2015 · Jan 25, 2015 · Jan 25, 2015
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,4 +1,4 @@
-*Last updated: 2015-08-11*
+*Last updated: 2017-03-18*
 
 ## Searching for Files
 
@@ -30,6 +30,19 @@
 
 ## Modifying Files
 
+### Create Captions From a Filename ###
+
+The command alone will put the *full* filename in the comments. If you want to add the filename without the extension, add the example exiftool config file found [here][config]
+
+	# This is the command if you have the config installed
+	exiftool '-Comment<BaseName' '-UserComment<BaseName' .
+
+	# Getting the filename without the config file, but with a for-loop
+	for i in *; do 
+		FileName="${i%%.*}"
+		exiftool "-Comment=$FileName" "-UserComment=$FileName" "$i";
+	done
+
 ###Change JPG to jpg and MOV to mov in filenames###
 
     for i in *.JPG; do mv "$i" "${i%%.JPG}.jpg"; done; !#:gs/JPG/MOV/:gs/jpg/mov/
@@ -113,10 +126,12 @@ Found at http://u88.n24.queensu.ca/exiftool/forum/index.php?topic=2736.0
 
 ## Update Notes ##
 
+- 2017-03-18 - added command to create comments from a filename
 - 2015-08-11 - added line to rename files based on milliseconds
 - 2015-01-18 - added line on how to set a date for a particular photo(s)
 - 2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
 - 2014-12-25 - Added line for copying photos into organized photos.
 
 
-[exec_sh]: http://unix.stackexchange.com/questions/60404/manipulate-file-name-piped-from-find-command
+[exec_sh]: http://unix.stackexchange.com/questions/60404/manipulate-file-name-piped-from-find-command
+[config]: http://www.sno.phy.queensu.ca/~phil/exiftool/config.html
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,8 +1,8 @@
-[exec_sh]		m*Last updated: 2015-01-18*
+*Last updated: 2015-08-11*
 
 ## Searching for Files
 
-###Find images in a directory that don't have a DateTimeOriginal###
+### Find images in a directory that don't have a DateTimeOriginal ###
 
     exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
@@ -24,7 +24,7 @@
         exiftool -q -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00"))' -csv -common "$n" | sed 1d >> "$DROPBOX_PERSONAL/nodates.csv"
     done < <( mdfind -onlyin "$DROPBOX_PERSONAL" 'kMDItemKind =="JPEG image"' -0 )
 
-###See files File Modify Date recursively in a directory who don't have datetimeoriginal set###
+### See files File Modify Date recursively in a directory who don't have datetimeoriginal set ###
 
     exiftool -filemodifydate -r -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
@@ -58,13 +58,21 @@ Info at http://www.sno.phy.queensu.ca/~phil/exiftool/Shift.html
 
 	exiftool "-AllDates+=1:0:0 0" .
 
-###Rename files to datestamp###
+### Rename files to datestamp ###
 
 *Filename looks like 2014-01-01 12:00:00.jpg and will append -NUM if DateTimeOriginal is the same for multiple files*
 
     exiftool '-FileName<DateTimeOriginal' -d "%Y-%m-%d %H.%M.%S%%-c.%%e" .  
 
-### Update any photo that doesn't have DateTimeOriginal to have it based on file modify date###
+### Rename Files to With Milliseconds ###
+
+*Good for burst photos where the seconds are all the same. If milliseconds are only out to 2 digits, use `${SubSecCreateDate}` instead*
+
+Found at http://u88.n24.queensu.ca/exiftool/forum/index.php?topic=2736.0
+
+	exiftool -v '-Filename<${datetimeoriginal}${subsectimeoriginal;$_.=0 x(3-length)}.%e' -d %Y%m%d_%H%M%S .
+
+### Update any photo that doesn't have DateTimeOriginal to have it based on file modify date ###
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
@@ -98,13 +106,14 @@ Info at http://www.sno.phy.queensu.ca/~phil/exiftool/Shift.html
 	exiftool -n -r -q -p $DESKTOP/kml-placemark.fmt . >> out.kml
 	cat $DESKTOP/kml-end.fmt >> out.kml
 
-###Create CSV of Geo Information###
+### Create CSV of Geo Information ###
 
 	exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv
 
 
 ## Update Notes ##
 
+- 2015-08-11 - added line to rename files based on milliseconds
 - 2015-01-18 - added line on how to set a date for a particular photo(s)
 - 2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
 - 2014-12-25 - Added line for copying photos into organized photos.

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -56,7 +56,7 @@ Option 2:
 
 Info at http://www.sno.phy.queensu.ca/~phil/exiftool/Shift.html
 
-	exiftool "-datecreated+=1:0:0 0" .
+	exiftool "-AllDates+=1:0:0 0" .
 
 ###Rename files to datestamp###
 

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,4 +1,4 @@
-*Last updated: 2015-01-18*
+[exec_sh]		m*Last updated: 2015-01-18*
 
 ## Searching for Files
 
@@ -52,6 +52,12 @@ Option 2:
 
     exiftool "-AllDates=1986:11:05 12:00:00" -if '$filetype eq "JPEG"' .
 
+### Timeshift Photos by One Year ###
+
+Info at http://www.sno.phy.queensu.ca/~phil/exiftool/Shift.html
+
+	exiftool "-datecreated+=1:0:0 0" .
+
 ###Rename files to datestamp###
 
 *Filename looks like 2014-01-01 12:00:00.jpg and will append -NUM if DateTimeOriginal is the same for multiple files*

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -6,7 +6,7 @@
 
     exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
-###Output photos that don't have datetimeoriginal to a CSV###  
+###Output photos that don't have datetimeoriginal to a CSV###
 *Note this can take a long time if you have a lot of jpgs*
 
     # You'll need to set your Dropbox folder path. I have mine set as a global variable

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -6,7 +6,7 @@
 
     exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
-###Output photos that don't have datetimeoriginal to a CSV ###  
+###Output photos that don't have datetimeoriginal to a CSV###  
 *Note this can take a long time if you have a lot of jpgs*
 
     # You'll need to set your Dropbox folder path. I have mine set as a global variable

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,4 +1,4 @@
-*Last updated: 2014-12-26*
+*Last updated: 2015-01-18*
 
 ## Searching for Files
 
@@ -99,6 +99,7 @@ Option 2:
 
 ## Update Notes ##
 
+- 2015-01-18 - added line on how to set a date for a particular photo(s)
 - 2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
 - 2014-12-25 - Added line for copying photos into organized photos.
 

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -6,7 +6,7 @@
 
     exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
-###Output photos that don't have datetimeoriginal to a CSV###  
+###Output photos that don't have datetimeoriginal to a CSV ###  
 *Note this can take a long time if you have a lot of jpgs*
 
     # You'll need to set your Dropbox folder path. I have mine set as a global variable
@@ -58,10 +58,14 @@ Option 2:
 
     exiftool '-FileName<DateTimeOriginal' -d "%Y-%m-%d %H.%M.%S%%-c.%%e" .  
 
-###Update any photo that doesn't have DateTimeOriginal to have it based on file modify date###
+### Update any photo that doesn't have DateTimeOriginal to have it based on file modify date###
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
+### Set DateTimeOriginal to Any Arbitrary Timestamp ###
+
+	exiftool '-datetimeoriginal=2015:01:18 12:00:00' .
+
 ## Moving/Copying Files ##
 
 ###Copy directory recursively into organized folder###

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -95,8 +95,8 @@ Option 2:
 
 ## Update Notes ##
 
-2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
-2014-12-25 - Added line for copying photos into organized photos.
+- 2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
+- 2014-12-25 - Added line for copying photos into organized photos.
 
 
 [exec_sh]: http://unix.stackexchange.com/questions/60404/manipulate-file-name-piped-from-find-command
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -95,7 +95,7 @@ Option 2:
 
 ## Update Notes ##
 
-2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]
+2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]  
 2014-12-25 - Added line for copying photos into organized photos.
 
 

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -95,5 +95,8 @@ Option 2:
 
 ## Update Notes ##
 
-2014-12-26 - Adding new recursive command to rename JPG to jpg
-2014-12-25 - Added line for copying photos into organized photos
+2014-12-26 - Adding new recursive command to rename JPG to jpg. Info on using `sh` with `-exec` [here][exec_sh]
+2014-12-25 - Added line for copying photos into organized photos.
+
+
+[exec_sh]: http://unix.stackexchange.com/questions/60404/manipulate-file-name-piped-from-find-command
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,12 +1,12 @@
-*Last updated: 2014-12-25*
+*Last updated: 2014-12-26*
 
 ## Searching for Files
 
-**Find images in a directory that don't have a DateTimeOriginal**
+###Find images in a directory that don't have a DateTimeOriginal###
 
     exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
-**Output photos that don't have datetimeoriginal to a CSV**  
+###Output photos that don't have datetimeoriginal to a CSV###  
 *Note this can take a long time if you have a lot of jpgs*
 
     # You'll need to set your Dropbox folder path. I have mine set as a global variable
@@ -24,17 +24,21 @@
         exiftool -q -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00"))' -csv -common "$n" | sed 1d >> "$DROPBOX_PERSONAL/nodates.csv"
     done < <( mdfind -onlyin "$DROPBOX_PERSONAL" 'kMDItemKind =="JPEG image"' -0 )
 
-**See files File Modify Date recursively in a directory who don't have datetimeoriginal set**
+###See files File Modify Date recursively in a directory who don't have datetimeoriginal set###
 
     exiftool -filemodifydate -r -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
 ## Modifying Files
 
-**Change JPG to jpg and MOV to mov in filenames**
+###Change JPG to jpg and MOV to mov in filenames###
 
     for i in *.JPG; do mv "$i" "${i%%.JPG}.jpg"; done; !#:gs/JPG/MOV/:gs/jpg/mov/
 
-**Change last created and modified for files in a directory**
+Recursively
+
+	find /path/to/directory -name *JPG -exec sh -c 'mv "$0" "${0%%.JPG}.jpg"; echo "Moved $0 to ${0%%.JPG}.jpg"' {} \;
+
+###Change last created and modified for files in a directory###
 
 *The date syntax has to be YYYY:MM:DD HH:MM:SS*
 
@@ -48,19 +52,19 @@ Option 2:
 
     exiftool "-AllDates=1986:11:05 12:00:00" -if '$filetype eq "JPEG"' .
 
-**Rename files to datestamp**
+###Rename files to datestamp###
 
 *Filename looks like 2014-01-01 12:00:00.jpg and will append -NUM if DateTimeOriginal is the same for multiple files*
 
     exiftool '-FileName<DateTimeOriginal' -d "%Y-%m-%d %H.%M.%S%%-c.%%e" .  
 
-**Update any photo that doesn't have DateTimeOriginal to have it based on file modify date**
+###Update any photo that doesn't have DateTimeOriginal to have it based on file modify date###
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
 ## Moving/Copying Files ##
 
-**Copy directory recursively into organized folder**
+###Copy directory recursively into organized folder###
 
 	exiftool -o ~/dummy/ -if '$filesize# > 300000' '-Directory<CreateDate' -d ~/Desktop/old_photos2/%Y/%m\ %B -r ~/Desktop/iPhoto\ Library/
 
@@ -77,18 +81,19 @@ Option 2:
 
 ## Extras
 
-**Create KML from geotagged photos**
+###Create KML from geotagged photos###
 
 	DESKTOP=$HOME/Desktop
 	cat $DESKTOP/kml-start.fmt > out.kml
 	exiftool -n -r -q -p $DESKTOP/kml-placemark.fmt . >> out.kml
 	cat $DESKTOP/kml-end.fmt >> out.kml
 
-**Create CSV of Geo Information**
+###Create CSV of Geo Information###
 
 	exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv
 
 
 ## Update Notes ##
 
+2014-12-26 - Adding new recursive command to rename JPG to jpg
 2014-12-25 - Added line for copying photos into organized photos
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,4 +1,4 @@
-*Last updated: 2014-11-04*
+*Last updated: 2014-12-25*
 
 ## Searching for Files
 
@@ -86,4 +86,9 @@ Option 2:
 
 **Create CSV of Geo Information**
 
-	exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv
+	exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv
+
+
+## Update Notes ##
+
+2014-12-25 - Added line for copying photos into organized photos
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -58,6 +58,23 @@ Option 2:
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
+## Moving/Copying Files ##
+
+**Copy directory recursively into organized folder**
+
+	exiftool -o ~/dummy/ -if '$filesize# > 300000' '-Directory<CreateDate' -d ~/Desktop/old_photos2/%Y/%m\ %B -r ~/Desktop/iPhoto\ Library/
+
+`-o ~/dummy` This flag is to copy, not move. The directory is a fallback if the flag isn't available on the given photo. Good if using something like DateTimeOriginal
+
+`-if '$filesize# > 300000'` gets files that are over 300kB. I was parsing an iPhoto library where there were thumbnails. The `#` turns the value to a number. you can use the flag `-n` to turn all values to numbers
+
+`'-Directory<CreateDate'` Create directories based on the CreateDate of the photos
+
+`-d ~/Desktop/old_photos/%Y/%m\ %B` Create folders with the given date format.
+
+`-r` Run recursively
+
+
 ## Extras
 
 **Create KML from geotagged photos**

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,6 +1,6 @@
-*Last updated: 2014-09-28*
+*Last updated: 2014-11-04*
 
-# Searching for Files
+## Searching for Files
 
 **Find images in a directory that don't have a DateTimeOriginal**
 
@@ -28,7 +28,7 @@
 
     exiftool -filemodifydate -r -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
-# Modifying Files
+## Modifying Files
 
 **Change JPG to jpg and MOV to mov in filenames**
 
@@ -58,13 +58,15 @@ Option 2:
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
 
-# Extras
+## Extras
 
 **Create KML from geotagged photos**
 
 	DESKTOP=$HOME/Desktop
 	cat $DESKTOP/kml-start.fmt > out.kml
 	exiftool -n -r -q -p $DESKTOP/kml-placemark.fmt . >> out.kml
 	cat $DESKTOP/kml-end.fmt >> out.kml
-
-
+
+**Create CSV of Geo Information**
+
+	exiftool -csv -filename -imagesize -gps:GPSLatitude -gps:GPSLongitude ./ > long.csv
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -57,5 +57,14 @@ Option 2:
 **Update any photo that doesn't have DateTimeOriginal to have it based on file modify date**
 
     exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
+
+# Extras
+
+**Create KML from geotagged photos**
+
+	DESKTOP=$HOME/Desktop
+	cat $DESKTOP/kml-start.fmt > out.kml
+	exiftool -n -r -q -p $DESKTOP/kml-placemark.fmt . >> out.kml
+	cat $DESKTOP/kml-end.fmt >> out.kml
 
 
diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -1,3 +1,5 @@
+*Last updated: 2014-09-28*
+
 # Searching for Files
 
 **Find images in a directory that don't have a DateTimeOriginal**

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -34,6 +34,8 @@
 
 **Change last created and modified for files in a directory**
 
+*The date syntax has to be YYYY:MM:DD HH:MM:SS*
+
 Option 1:
 
     find . -name "*.jpg" | while read filename;  

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -2,7 +2,7 @@
 
 **Find images in a directory that don't have a DateTimeOriginal**
 
-    exiftool -filename -filemodifydate -r -if '(not $datetimeoriginal) and $filemodifydate le "2014:01:01" and $filetype eq "JPEG"' .
+    exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .
 
 **Output photos that don't have datetimeoriginal to a CSV**  
 *Note this can take a long time if you have a lot of jpgs*

diff --git a/My Exiftool Cheatsheet.md b/My Exiftool Cheatsheet.md
@@ -0,0 +1,57 @@
+# Searching for Files
+
+**Find images in a directory that don't have a DateTimeOriginal**
+
+    exiftool -filename -filemodifydate -r -if '(not $datetimeoriginal) and $filemodifydate le "2014:01:01" and $filetype eq "JPEG"' .
+
+**Output photos that don't have datetimeoriginal to a CSV**  
+*Note this can take a long time if you have a lot of jpgs*
+
+    # You'll need to set your Dropbox folder path. I have mine set as a global variable
+    OLDFILE="$DROPBOX_PERSONAL/nodates.csv"
+
+    FILECOUNT=$(mdfind -count -onlyin "$DROPBOX_PERSONAL" 'kMDItemKind =="JPEG image"')
+    while IFS= read -r -d '' n; do
+        FILECOUNT=$(( $FILECOUNT - 1 ))
+        if grep -q "$n" "$OLDFILE"; then
+            echo "Skipping $n"
+            continue
+        fi
+
+        echo -ne "Remaining: $FILECOUNT\r"
+        exiftool -q -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00"))' -csv -common "$n" | sed 1d >> "$DROPBOX_PERSONAL/nodates.csv"
+    done < <( mdfind -onlyin "$DROPBOX_PERSONAL" 'kMDItemKind =="JPEG image"' -0 )
+
+**See files File Modify Date recursively in a directory who don't have datetimeoriginal set**
+
+    exiftool -filemodifydate -r -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
+
+# Modifying Files
+
+**Change JPG to jpg and MOV to mov in filenames**
+
+    for i in *.JPG; do mv "$i" "${i%%.JPG}.jpg"; done; !#:gs/JPG/MOV/:gs/jpg/mov/
+
+**Change last created and modified for files in a directory**
+
+Option 1:
+
+    find . -name "*.jpg" | while read filename;  
+        exiftool "-AllDates=1986:11:05 12:00:00" "$filename";
+    done
+
+Option 2:
+
+    exiftool "-AllDates=1986:11:05 12:00:00" -if '$filetype eq "JPEG"' .
+
+**Rename files to datestamp**
+
+*Filename looks like 2014-01-01 12:00:00.jpg and will append -NUM if DateTimeOriginal is the same for multiple files*
+
+    exiftool '-FileName<DateTimeOriginal' -d "%Y-%m-%d %H.%M.%S%%-c.%%e" .  
+
+**Update any photo that doesn't have DateTimeOriginal to have it based on file modify date**
+
+    exiftool '-datetimeoriginal<filemodifydate' -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' .
+
+