Shotwell does not properly display videos in chronological order when sorted by exposure date for videos taken in another timezone
Mandatory: Shotwell version the issue was seen with
Shotwell 0.31.0
The expected behavior
Photos and videos taken at the same time should be in correct chronological order when sorting by exposure date.
What was actually happening
Videos are not in correct chronological order, rather they are adjacent to photos that were taken N hours earlier or later where N is the timezone offset between where the video was taken and the local time of the Shotwell. Let me say that I'm filing this as a bug because as an end user I expect my photo library manager to be able to properly chronologically sort my photos AND videos. That said, I'm also well aware that this issue plagues every other photo library manager software I've ever used. I'm just hoping that this time a solution can be found.
Steps to reproduce the issue
- Travel to a different timezone
- Take photos and videos with the same device (phone or camera)
- Return home and import photos into Shotwell
- Observe that videos do not sort chronologically when sorting by exposure date.
Example:
Timezone differences in February
Paris UTC+01:00 where pictures and videos were taken
Minneapolis UTC-6:00 where my Shotwell photo library currently resides
Difference = 7hr
Also, see attachments of video and photo sorting when sort by exposure date is selected.
**IMG_1366.JPG**
$ exiftool -s IMG_1366.JPG
ExifToolVersion : 10.80
FileName : IMG_1366.JPG
Directory : .
FileSize : 1977 kB
FileModifyDate : 2020:05:13 20:48:35-05:00
FileAccessDate : 2020:05:15 10:11:37-05:00
FileInodeChangeDate : 2020:05:13 20:48:35-05:00
FilePermissions : rw-r--r--
FileType : JPEG
FileTypeExtension : jpg
MIMEType : image/jpeg
ExifByteOrder : Big-endian (Motorola, MM)
Make : Apple
Model : iPhone 5
Orientation : Rotate 90 CW
XResolution : 72
YResolution : 72
ResolutionUnit : inches
Software : Shotwell 0.31.0
ModifyDate : 2014:02:09 16:07:42
YCbCrPositioning : Centered
ExposureTime : 1/120
FNumber : 2.4
ExposureProgram : Program AE
ISO : 64
ExifVersion : 0221
DateTimeOriginal : 2014:02:09 16:07:42
CreateDate : 2014:02:09 16:07:42
ComponentsConfiguration : Y, Cb, Cr, -
ShutterSpeedValue : 1/120
ApertureValue : 2.4
BrightnessValue : 5.170849421
MeteringMode : Multi-segment
Flash : No Flash
FocalLength : 4.1 mm
RunTimeScale : 1000000000
RunTimeEpoch : 0
RunTimeValue : 185788911603875
RunTimeFlags : Valid
HDRImageType : HDR Image
SubSecTimeOriginal : 840
SubSecTimeDigitized : 840
FlashpixVersion : 0100
ColorSpace : sRGB
ExifImageWidth : 3264
ExifImageHeight : 2448
SensingMethod : One-chip color area
SceneType : Directly photographed
CustomRendered : HDR
ExposureMode : Auto
WhiteBalance : Auto
DigitalZoomRatio : 1.743589744
FocalLengthIn35mmFormat : 58 mm
SceneCaptureType : Standard
LensInfo : 4.12mm f/2.4
LensMake : Apple
LensModel : iPhone 5 back camera 4.12mm f/2.4
GPSLatitudeRef : North
GPSLongitudeRef : East
GPSAltitudeRef : Above Sea Level
GPSTimeStamp : 15:07:42.37
GPSImgDirectionRef : True North
GPSImgDirection : 275.7603687
Compression : JPEG (old-style)
ThumbnailOffset : 1288
ThumbnailLength : 12271
XMPToolkit : XMP Core 4.4.0-Exiv2
Label : 2014 Paris Feb Album
Subject : 2014 Paris Feb Album
CurrentIPTCDigest : ed65507c369f47a253231e1aeadee743
Keywords : 2014 Paris Feb Album
OriginatingProgram : Shotwell
ProgramVersion : 0.31.0
ImageWidth : 3264
ImageHeight : 2448
EncodingProcess : Baseline DCT, Huffman coding
BitsPerSample : 8
ColorComponents : 3
YCbCrSubSampling : YCbCr4:2:0 (2 2)
Aperture : 2.4
GPSAltitude : 39.5 m Above Sea Level
GPSLatitude : 48 deg 51' 13.66" N
GPSLongitude : 2 deg 20' 12.79" E
GPSPosition : 48 deg 51' 13.66" N, 2 deg 20' 12.79" E
ImageSize : 3264x2448
Megapixels : 8.0
RunTimeSincePowerUp : 2 days 3:36:28
ScaleFactor35efl : 14.1
ShutterSpeed : 1/120
SubSecCreateDate : 2014:02:09 16:07:42.840
SubSecDateTimeOriginal : 2014:02:09 16:07:42.840
ThumbnailImage : (Binary data 12271 bytes, use -b option to extract)
CircleOfConfusion : 0.002 mm
FOV : 34.5 deg
FocalLength35efl : 4.1 mm (35 mm equivalent: 58.0 mm)
HyperfocalDistance : 3.31 m
LightValue : 10.1
**IMG_1369.MOV**
$ exiftool -s IMG_1369.MOV
ExifToolVersion : 10.80
FileName : IMG_1369.MOV
Directory : .
FileSize : 41 MB
FileModifyDate : 2020:05:15 11:55:28-05:00
FileAccessDate : 2020:05:15 11:55:31-05:00
FileInodeChangeDate : 2020:05:15 11:55:28-05:00
FilePermissions : rw-r--r--
FileType : MOV
FileTypeExtension : mov
MIMEType : video/quicktime
MajorBrand : Apple QuickTime (.MOV/QT)
MinorVersion : 0.0.0
CompatibleBrands : qt
MovieDataSize : 42784169
MovieDataOffset : 36
MovieHeaderVersion : 0
CreateDate : 2014:02:09 15:09:46
ModifyDate : 2014:02:09 15:09:58
TimeScale : 600
Duration : 20.33 s
PreferredRate : 1
PreferredVolume : 100.00%
PreviewTime : 0 s
PreviewDuration : 0 s
PosterTime : 0 s
SelectionTime : 0 s
SelectionDuration : 0 s
CurrentTime : 0 s
NextTrackID : 3
TrackHeaderVersion : 0
TrackCreateDate : 2014:02:09 15:09:46
TrackModifyDate : 2014:02:09 15:09:58
TrackID : 1
TrackDuration : 20.33 s
TrackLayer : 0
TrackVolume : 0.00%
ImageWidth : 1920
ImageHeight : 1080
CleanApertureDimensions : 1920x1080
ProductionApertureDimensions : 1920x1080
EncodedPixelsDimensions : 1920x1080
GraphicsMode : ditherCopy
OpColor : 32768 32768 32768
CompressorID : avc1
SourceImageWidth : 1920
SourceImageHeight : 1080
XResolution : 72
YResolution : 72
CompressorName : H.264
BitDepth : 24
VideoFrameRate : 29.973
CameraIdentifier : Back
FrameReadoutTime : 29376 microseconds
MatrixStructure : 1 0 0 0 1 0 0 0 1
MediaHeaderVersion : 0
MediaCreateDate : 2014:02:09 15:09:46
MediaModifyDate : 2014:02:09 15:09:58
MediaTimeScale : 44100
MediaDuration : 20.36 s
MediaLanguageCode : und
Balance : 0
HandlerClass : Data Handler
HandlerVendorID : Apple
HandlerDescription : Core Media Data Handler
AudioFormat : mp4a
AudioBitsPerSample : 16
AudioSampleRate : 44100
LayoutFlags : Mono
AudioChannels : 1
PurchaseFileFormat : mp4a
Model : iPhone 5
SoftwareVersion : 7.0.4
ContentCreateDate : 2014:02:09 16:09:46+01:00
GPSCoordinates : 48 deg 51' 13.68" N, 2 deg 20' 12.84" E, 35.289 m Above Sea Level
Make : Apple
HandlerType : Metadata Tags
Make-und-US : Apple
CreationDate-und-US : 2014:02:09 16:09:46+01:00
GPSCoordinates-und-US : 48 deg 51' 13.68" N, 2 deg 20' 12.84" E, 35.289 m Above Sea Level
Software-und-US : 7.0.4
Model-und-US : iPhone 5
CreationDate : 2014:02:09 16:09:46+01:00
Software : 7.0.4
AvgBitrate : 16.8 Mbps
GPSAltitude : 35.289 m
GPSAltitudeRef : Above Sea Level
GPSLatitude : 48 deg 51' 13.68" N
GPSLongitude : 2 deg 20' 12.84" E
ImageSize : 1920x1080
Megapixels : 2.1
Rotation : 0
GPSPosition : 48 deg 51' 13.68" N, 2 deg 20' 12.84" E