Total newb can exiftool extract or authenticate original Time/Date

Started by BALLARD, April 26, 2015, 04:49:54 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

BALLARD

April 26, 2015, 04:49:54 PM Last Edit: April 26, 2015, 07:48:22 PM by BALLARD
If so can someone break it down for me I don't know much about Terminal/Mac.

Can you see if and when the file was modified. The time stamps don't add up could be UTC. This is rather important.

ExifTool Version Number         : 9.91
File Name                       : VIDEO0122.3gp
Directory                       : /Users/
File Size                       : 36 MB
File Modification Date/Time     : 2014:03:27 04:02:50-07:00   (what do these -7:00 mean?)
File Access Date/Time           : 2015:04:26 13:22:49-07:00
File Inode Change Date/Time     : 2015:04:25 20:07:26-07:00
File Permissions                : rwxrwxrwx
File Type                       : 3GP
MIME Type                       : video/3gpp
Major Brand                     : 3GPP Media (.3GP) Release 4
Minor Version                   : 0.3.0
Compatible Brands               : 3gp4, mp41, 3gp6
Movie Data Size                 : 38003846
Movie Data Offset               : 36
Movie Header Version            : 0
Create Date                     : 2014:03:27 09:01:14        (UTC?)
Modify Date                     : 2014:03:27 09:01:14        (UTC?)
Time Scale                      : 1000
Duration                        : 0:01:36
Preferred Rate                  : 1
Preferred Volume                : 100.00%
Preview Time                    : 0 s
Preview Duration                : 0 s
Poster Time                     : 0 s
Selection Time                  : 0 s
Selection Duration              : 0 s
Current Time                    : 0 s
Next Track ID                   : 3
Copyright                       :
Author                          :
Title                           :
Description                     :
Performer                       :
Genre                           :
Rating                          : Entity= Criteria=
Classification                  : Entity= Index=0
Keywords                        :
Location Information            : (none) Role=shooting Lat=0.00000 Lon=0.00000 Alt=0.00 Body= Notes=
Album                           :
Year                            : 0
Track Header Version            : 0
Track Create Date               : 2014:03:27 09:01:14
Track Modify Date               : 2014:03:27 09:01:14
Track ID                        : 1
Track Duration                  : 0:01:36
Track Layer                     : 0
Track Volume                    : 0.00%
Image Width                     : 800
Image Height                    : 480
Graphics Mode                   : srcCopy
Op Color                        : 0 0 0
Compressor ID                   : mp4v
Source Image Width              : 800
Source Image Height             : 480
X Resolution                    : 72
Y Resolution                    : 72
Bit Depth                       : 24
Video Frame Rate                : 23.3
Matrix Structure                : 1 0 0 0 1 0 0 0 1
Media Header Version            : 0
Media Create Date               : 2014:03:27 09:01:14
Media Modify Date               : 2014:03:27 09:01:14
Media Time Scale                : 8000
Media Duration                  : 0:01:36
Handler Type                    : Audio Track
Handler Description             : SoundHandler
Balance                         : 0
Audio Format                    : samr
Audio Channels                  : 1
Audio Bits Per Sample           : 16
Audio Sample Rate               : 8000
Encoder Vendor                  : pvmm
Encoder Version                 : 0
Avg Bitrate                     : 3.16 Mbps
GPS Altitude                    : 0 m
GPS Altitude Ref                : Above Sea Level
GPS Latitude                    : 0 deg 0' 0.00" N
GPS Longitude                   : 0 deg 0' 0.00" E
Image Size                      : 800x480
Megapixels                      : 0.384
Rotation                        : 0
GPS Position                    : 0 deg 0' 0.00" N, 0 deg 0' 0.00" E
    1 image files read
    1 files could not be read



exiftool -d %Y%m%d "-filename<datetimeoriginal" "-filemodifydate<datetimeoriginal#" -ext FILENAME=VIDEO122No file specified
usernam-MacBook-Pro:Desktop username$ exiftool -v2 /Users/jamesquilici/Desktop/VIDEO0122.3gp
  ExifToolVersion = 9.91
  FileName = VIDEO0122.3gp
  Directory = /Users/username/Desktop
  FileSize = 38031393
  FileModifyDate = 1395918170
  FileAccessDate = 1430081022
  FileInodeChangeDate = 1430017646
  FilePermissions = 33279
  FileType = 3GP
  MIMEType = video/3gpp
  FileType (SubDirectory) -->
  - Tag 'ftyp' (20 bytes)
  + [BinaryData directory, 20 bytes]
  | MajorBrand = 3gp4
  | - Tag 0x0000 (4 bytes, undef[4])
  | MinorVersion = .
  | - Tag 0x0001 (4 bytes, undef[4])
  | CompatibleBrands = 3gp4mp413gp6
  | - Tag 0x0002 (12 bytes, undef[12])
  MovieDataSize = 38003846
  MovieDataOffset = 36
  MovieData
  - Tag 'mdat' at offset 0x0024 (38003846 bytes)
  Movie (SubDirectory) -->
  - Tag 'moov' (27503 bytes)
  + [Movie directory]
  | MovieHeader (SubDirectory) -->
  | - Tag 'mvhd' (100 bytes)
  | + [BinaryData directory, 100 bytes]
  | | MovieHeaderVersion = 0
  | | - Tag 0x0000 (1 bytes, int8u[1])
  | | CreateDate = 3478755674
  | | - Tag 0x0001 (4 bytes, int32u[1])
  | | ModifyDate = 3478755674
  | | - Tag 0x0002 (4 bytes, int32u[1])
  | | TimeScale = 1000
  | | - Tag 0x0003 (4 bytes, int32u[1])
  | | Duration = 96223
  | | - Tag 0x0004 (4 bytes, int32u[1])
  | | PreferredRate = 65536
  | | - Tag 0x0005 (4 bytes, int32u[1])
  | | PreferredVolume = 256
  | | - Tag 0x0006 (2 bytes, int16u[1])
  | | MatrixStructure = 1 0 0 0 1 0 0 0 16384
  | | - Tag 0x0009 (36 bytes, fixed32s[9])
  | | PreviewTime = 0
  | | - Tag 0x0012 (4 bytes, int32u[1])
  | | PreviewDuration = 0
  | | - Tag 0x0013 (4 bytes, int32u[1])
  | | PosterTime = 0
  | | - Tag 0x0014 (4 bytes, int32u[1])
  | | SelectionTime = 0
  | | - Tag 0x0015 (4 bytes, int32u[1])
  | | SelectionDuration = 0
  | | - Tag 0x0016 (4 bytes, int32u[1])
  | | CurrentTime = 0
  | | - Tag 0x0017 (4 bytes, int32u[1])
  | | NextTrackID = 3
  | | - Tag 0x0018 (4 bytes, int32u[1])
  | UserData (SubDirectory) -->
  | - Tag 'udta' (245 bytes)
  | + [UserData directory]
  | | Copyright = ..
  | | - Tag 'cprt' (10 bytes)
  | | Author = ..
  | | - Tag 'auth' (10 bytes)
  | | Title = ..
  | | - Tag 'titl' (10 bytes)
  | | Description = ..
  | | - Tag 'dscp' (10 bytes)
  | | Performer = ..
  | | - Tag 'perf' (10 bytes)
  | | Genre = ..
  | | - Tag 'gnre' (10 bytes)
  | | Rating = ..
  | | - Tag 'rtng' (18 bytes)
  | | Classification = ..
  | | - Tag 'clsf' (16 bytes)
  | | Keywords = U.
  | | - Tag 'kywd' (7 bytes)
  | | LocationInformation = ......
  | | - Tag 'loci' (31 bytes)
  | | Album = ...
  | | - Tag 'albm' (11 bytes)
  | | Year =
  | | - Tag 'yrrc' (6 bytes)
  | Track (SubDirectory) -->
  | - Tag 'trak' (26324 bytes)
  | + [Track directory]
  | | TrackHeader (SubDirectory) -->
  | | - Tag 'tkhd' (84 bytes)
  | | + [BinaryData directory, 84 bytes]
  | | | TrackHeaderVersion = 0
  | | | - Tag 0x0000 (1 bytes, int8u[1])
  | | | TrackCreateDate = 3478755674
  | | | - Tag 0x0001 (4 bytes, int32u[1])
  | | | TrackModifyDate = 3478755674
  | | | - Tag 0x0002 (4 bytes, int32u[1])
  | | | TrackID = 1
  | | | - Tag 0x0003 (4 bytes, int32u[1])
  | | | TrackDuration = 96223
  | | | - Tag 0x0005 (4 bytes, int32u[1])
  | | | TrackLayer = 0
  | | | - Tag 0x0008 (2 bytes, int16u[1])
  | | | TrackVolume = 0
  | | | - Tag 0x0009 (2 bytes, int16u[1])
  | | | MatrixStructure = 1 0 0 0 1 0 0 0 16384
  | | | - Tag 0x000a (36 bytes, fixed32s[9])
  | | | ImageWidth = 52428800
  | | | - Tag 0x0013 (4 bytes, int32u[1])
  | | | ImageHeight = 31457280
  | | | - Tag 0x0014 (4 bytes, int32u[1])
  | | Media (SubDirectory) -->
  | | - Tag 'mdia' (26224 bytes)
  | | + [Media directory]
  | | | MediaHeader (SubDirectory) -->
  | | | - Tag 'mdhd' (24 bytes)
  | | | + [BinaryData directory, 24 bytes]
  | | | | MediaHeaderVersion = 0
  | | | | - Tag 0x0000 (4 bytes, int32u[1])
  | | | | MediaCreateDate = 3478755674
  | | | | - Tag 0x0001 (4 bytes, int32u[1])
  | | | | MediaModifyDate = 3478755674
  | | | | - Tag 0x0002 (4 bytes, int32u[1])
  | | | | MediaTimeScale = 1000
  | | | | - Tag 0x0003 (4 bytes, int32u[1])
  | | | | MediaDuration = 96223
  | | | | - Tag 0x0004 (4 bytes, int32u[1])
  | | | | MediaLanguageCode = 0
  | | | | - Tag 0x0005 (2 bytes, int16u[1])
  | | | Handler (SubDirectory) -->
  | | | - Tag 'hdlr' (37 bytes)
  | | | + [BinaryData directory, 37 bytes]
  | | | | HandlerClass =
  | | | | - Tag 0x0004 (4 bytes, undef[4])
  | | | | HandlerType = vide
  | | | | - Tag 0x0008 (4 bytes, undef[4])
  | | | | HandlerVendorID =
  | | | | - Tag 0x000c (4 bytes, undef[4])
  | | | | HandlerDescription = VideoHandler
  | | | | - Tag 0x0018 (13 bytes, string[13])
  | | | MediaInfo (SubDirectory) -->
  | | | - Tag 'minf' (26139 bytes)
  | | | + [MediaInfo directory]
  | | | | VideoHeader (SubDirectory) -->
  | | | | - Tag 'vmhd' (12 bytes)
  | | | | + [BinaryData directory, 12 bytes]
  | | | | | GraphicsMode = 0
  | | | | | - Tag 0x0002 (2 bytes, int16u[1])
  | | | | | OpColor = 0 0 0
  | | | | | - Tag 0x0003 (6 bytes, int16u[3])
  | | | | DataInfo (SubDirectory) -->
  | | | | - Tag 'dinf' (28 bytes)
  | | | | + [DataInfo directory]
  | | | | | DataRef (SubDirectory) -->
  | | | | | - Tag 'dref' (20 bytes)
  | | | | | + [DataRef directory]
  | | | | | | URL = .
  | | | | | | - Tag 'url ' (4 bytes, undef)
  | | | | SampleTable (SubDirectory) -->
  | | | | - Tag 'stbl' (26075 bytes)
  | | | | + [SampleTable directory]
  | | | | | VideoSampleDesc (SubDirectory) -->
  | | | | | - Tag 'stsd' (159 bytes)
  | | | | | + [BinaryData directory, 94 bytes]
  | | | | | | CompressorID = mp4v
  | | | | | | - Tag 0x0002 (4 bytes, string[4])
  | | | | | | VendorID =
  | | | | | | - Tag 0x000a (4 bytes, string[4])
  | | | | | | SourceImageWidth = 800
  | | | | | | - Tag 0x0010 (2 bytes, int16u[1])
  | | | | | | SourceImageHeight = 480
  | | | | | | - Tag 0x0011 (2 bytes, int16u[1])
  | | | | | | XResolution = 72
  | | | | | | - Tag 0x0012 (4 bytes, fixed32u[1])
  | | | | | | YResolution = 72
  | | | | | | - Tag 0x0014 (4 bytes, fixed32u[1])
  | | | | | | CompressorName =
  | | | | | | - Tag 0x0019 (32 bytes, string[32])
  | | | | | | BitDepth = 24
  | | | | | | - Tag 0x0029 (2 bytes, int16u[1])
  | | | | | + [VideoSampleDesc directory]
  | | | | | | Unknown_esds = .3.+ ...*-..-............ .@.(.!......
  | | | | | | - Tag 'esds' (57 bytes)
  | | | | | VideoFrameRate = .....c.e.d.m.\.c.e.c.e.q.W.e.c.e.c.d.e.d.j.].e.c.e.c.e.d.c[snip]
  | | | | | - Tag 'stts' (14360 bytes, undef)
  | | | | | SampleToChunk = {..........................................................[snip]
  | | | | | - Tag 'stsc' (1484 bytes)
  | | | | | SampleSizes = ........4}4"E.>1;.6r._...R.':.<B;.:.;TA.f._vS.q..u.|.S..."...[snip]
  | | | | | - Tag 'stsz' (8980 bytes)
  | | | | | ChunkOffset = ..d....W...T.uy..|.a...c....e...:#g.'2g+.]...2.A6Dn:.l=..A..E[snip]
  | | | | | - Tag 'stco' (648 bytes)
  | | | | | SyncSampleTable = a....(@^|.......0.N.l........... .>.\.z...............,.J[snip]
  | | | | | - Tag 'stss' (396 bytes)
  | Track (SubDirectory) -->
  | - Tag 'trak' (802 bytes)
  | + [Track directory]
  | | TrackHeader (SubDirectory) -->
  | | - Tag 'tkhd' (84 bytes)
  | | + [BinaryData directory, 84 bytes]
  | | | TrackHeaderVersion = 0
  | | | - Tag 0x0000 (1 bytes, int8u[1])
  | | | TrackCreateDate = 3478755674
  | | | - Tag 0x0001 (4 bytes, int32u[1])
  | | | TrackModifyDate = 3478755674
  | | | - Tag 0x0002 (4 bytes, int32u[1])
  | | | TrackID = 2
  | | | - Tag 0x0003 (4 bytes, int32u[1])
  | | | TrackDuration = 96120
  | | | - Tag 0x0005 (4 bytes, int32u[1])
  | | | TrackLayer = 0
  | | | - Tag 0x0008 (2 bytes, int16u[1])
  | | | TrackVolume = 256
  | | | - Tag 0x0009 (2 bytes, int16u[1])
  | | | MatrixStructure = 1 0 0 0 1 0 0 0 16384
  | | | - Tag 0x000a (36 bytes, fixed32s[9])
  | | | ImageWidth = 0
  | | | - Tag 0x0013 (4 bytes, int32u[1])
  | | | ImageHeight = 0
  | | | - Tag 0x0014 (4 bytes, int32u[1])
  | | Media (SubDirectory) -->
  | | - Tag 'mdia' (702 bytes)
  | | + [Media directory]
  | | | MediaHeader (SubDirectory) -->
  | | | - Tag 'mdhd' (24 bytes)
  | | | + [BinaryData directory, 24 bytes]
  | | | | MediaHeaderVersion = 0
  | | | | - Tag 0x0000 (4 bytes, int32u[1])
  | | | | MediaCreateDate = 3478755674
  | | | | - Tag 0x0001 (4 bytes, int32u[1])
  | | | | MediaModifyDate = 3478755674
  | | | | - Tag 0x0002 (4 bytes, int32u[1])
  | | | | MediaTimeScale = 8000
  | | | | - Tag 0x0003 (4 bytes, int32u[1])
  | | | | MediaDuration = 768960
  | | | | - Tag 0x0004 (4 bytes, int32u[1])
  | | | | MediaLanguageCode = 0
  | | | | - Tag 0x0005 (2 bytes, int16u[1])
  | | | Handler (SubDirectory) -->
  | | | - Tag 'hdlr' (37 bytes)
  | | | + [BinaryData directory, 37 bytes]
  | | | | HandlerClass =
  | | | | - Tag 0x0004 (4 bytes, undef[4])
  | | | | HandlerType = soun
  | | | | - Tag 0x0008 (4 bytes, undef[4])
  | | | | HandlerVendorID =
  | | | | - Tag 0x000c (4 bytes, undef[4])
  | | | | HandlerDescription = SoundHandler
  | | | | - Tag 0x0018 (13 bytes, string[13])
  | | | MediaInfo (SubDirectory) -->
  | | | - Tag 'minf' (617 bytes)
  | | | + [MediaInfo directory]
  | | | | AudioHeader (SubDirectory) -->
  | | | | - Tag 'smhd' (8 bytes)
  | | | | + [BinaryData directory, 8 bytes]
  | | | | | Balance = 0
  | | | | | - Tag 0x0002 (2 bytes, fixed16s[1])
  | | | | DataInfo (SubDirectory) -->
  | | | | - Tag 'dinf' (28 bytes)
  | | | | + [DataInfo directory]
  | | | | | DataRef (SubDirectory) -->
  | | | | | - Tag 'dref' (20 bytes)
  | | | | | + [DataRef directory]
  | | | | | | URL = .
  | | | | | | - Tag 'url ' (4 bytes, undef)
  | | | | SampleTable (SubDirectory) -->
  | | | | - Tag 'stbl' (557 bytes)
  | | | | + [SampleTable directory]
  | | | | | AudioSampleDesc (SubDirectory) -->
  | | | | | - Tag 'stsd' (61 bytes)
  | | | | | + [BinaryData directory, 44 bytes]
  | | | | | | AudioFormat = samr
  | | | | | | - Tag 0x0004 (4 bytes, undef[4])
  | | | | | | AudioVendorID =
  | | | | | | - Tag 0x0014 (4 bytes, undef[4])
  | | | | | | AudioChannels = 1
  | | | | | | - Tag 0x0018 (2 bytes, int16u[1])
  | | | | | | AudioBitsPerSample = 16
  | | | | | | - Tag 0x001a (2 bytes, int16u[1])
  | | | | | | AudioSampleRate = 8000
  | | | | | | - Tag 0x0020 (4 bytes, fixed32u[1])
  | | | | | + [AudioSampleDesc directory]
  | | | | | | DecodeConfig (SubDirectory) -->
  | | | | | | - Tag 'damr' (9 bytes)
  | | | | | | + [BinaryData directory, 9 bytes]
  | | | | | | | EncoderVendor = pvmm
  | | | | | | | - Tag 0x0000 (4 bytes, undef[4])
  | | | | | | | EncoderVersion = 0
  | | | | | | | - Tag 0x0004 (1 bytes, int8u[1])
  | | | | | TimeToSampleTable = ....
  | | | | | - Tag 'stts' (16 bytes)
  | | | | | SampleToChunk = ..2.a..
  | | | | | - Tag 'stsc' (32 bytes)
  | | | | | SampleSizes =  ..
  | | | | | - Tag 'stsz' (12 bytes)
  | | | | | ChunkOffset = a$..u....o9._m','+..2..:.,=..A.lI..Mv.U%.Y.`6.d..k..r.!v..~.f[snip]
  | | | | | - Tag 'stco' (396 bytes)

Hayo Baan

#1
April 26, 2015, 05:57:05 PM
The -07:00 is simply the timezone of your computer (or at least, what exiftool thinks it is).

All other date/times are coming directly from the recording device (e.g, camera), they simply depict the time that your camera clock was at.

Does this answer your question?
Hayo Baan – Photography
Web: www.hayobaan.nl

BALLARD

#2
April 26, 2015, 08:20:33 PM
It was recorded from a cellphone so the time is never really wrong. What do you make of the 3-27 09:01 time? My phone wasn't even on me unless that's 9:01 Pm then maybe.

Phil Harvey

#3
April 26, 2015, 08:31:39 PM
The time zones in QuickTime-format files are inconsistent.  If they are stored as UTC, then you should add "-api QuickTimeUTC" to your command to convert them to local time.

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

BALLARD

#4
April 27, 2015, 12:50:03 AM
Thanks that seemed to work. But the File Modification Date/Time didn't change, do you know whats up with that? Anyway to see if someone modified it.

Create Date                     : 2014:03:27 02:01:14-07:00
Modify Date                     : 2014:03:27 02:01:14-07:00
Track Create Date            : 2014:03:27 02:01:14-07:00
Track Modify Date            : 2014:03:27 02:01:14-07:00

File Modification Date/Time         : 2014:03:27 04:02:50-07:00
File Access Date/Time                : 2015:04:26 17:45:54-07:00
File Inode Change Date/Time      : 2015:04:25 20:07:26-07:00

B.

Phil Harvey

#5
April 27, 2015, 06:57:36 AM
The QuickTimeUTC option only affects interpretation of QuickTime date/time tags.  Use the -G1 option to see where the information is coming from, and see the QuickTime tags documentation for more details about QuickTime tags.

- 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 ($).
Print
Go Up Pages1
User actions