Extract and show video recording date

Post Reply
afatac
Posts: 2
Joined: 07 Jan 20 7:08

Extract and show video recording date

Post by afatac »

Using single user version 5.3.

Is there a way to extract and show the mp4 video recorded date? The videos are recorded using Samsung Galaxy mobile phones.
Username
Posts: 310
Joined: 18 Feb 18 21:21

Re: Extract and show video recording date

Post by Username »

In the top right corner:
Click View
View Settings
Select Custom Thumbnail Info
And then you can try different output to be displayed below your movies.

If you want everything to be extracted.
Right click a movie
Run script from repository
Meta data
Full Exif dump (or Exiftool metadata output)


I believe you need to install Exiftool first though.
https://exiftool.org
PSu Server 2024 & Postgres 15 on macOS 14
PSO 6 on Windows Server 2022

- I'm the user
Hert
Posts: 7940
Joined: 13 Sep 03 6:24

Re: Extract and show video recording date

Post by Hert »

This was fixed in a recent version (build 2643);

https://www.idimager.com/what-s-new-in-photo-supreme-v5

Press Ctrl-Alt-S (Cmd-Alt-S) on a Samsung Galaxy mp4 file to reload the metadata to the catalog. The date will appear.
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
HaraldE
Posts: 267
Joined: 29 Apr 07 21:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE »

Morning,

I see things have improved but I am still having a bit of a problem. Using Windows 10,64 bit and PSU 2654 single version.

Files from my Samsung Galaxy 7 (both JPG and MP4) have filenames that include the date and time when photo/film was captured. This timestamp in the name has for JPGs allways been same as the Photodate in PSU. In the past both date and time has allways been wrong for my MP4 files.

Now PSU has changed and improved but MP4 files are still about an hour off. As far as I can se the date is now correct.
I have two MP4 files from yesterday with the following times:
File 1: Filename says 094012 and PSU says 084025
File 2: Filename says 174319 and PSU says 164512

Since I took these films I can confirm that the filename time is correct.

Are there some other Samsung Galaxy users with film that can comment on this?
Do you get the correct timestamp in PSU photodate?

Regards, Harald
Hert
Posts: 7940
Joined: 13 Sep 03 6:24

Re: Extract and show video recording date

Post by Hert »

PSU presents whatever is available in the video file. A one hour difference sounds like a timezone offset.
Compare the date that PSU shows with the date as reported by your OS or another metadata supporting tool (e.g. ExifTool).
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
HaraldE
Posts: 267
Joined: 29 Apr 07 21:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE »

Using Windows Explorer gives me (I assume) Window's time for the two files. They are as follows:

File 1: Filename says 094012 and PSU says 084025 and Windows Explorer says 09:40
File 2: Filename says 174319 and PSU says 164512 and Windows Explorer says 17:45

I will do some more testing and also try to look into the files to see where these times are coming from.

Again, it would be valuable to hear from any other Samsung Galaxy user if this is an issue with only me.
Username
Posts: 310
Joined: 18 Feb 18 21:21

Re: Extract and show video recording date

Post by Username »

There’s many different datetime in EXIF.

DateTime
DateTimeDigitized
DateTimeOriginal
And
TimeZoneOffset

Does the hour correlate with GMT and time zone offset?
Does the minute/seconds differences correlate to movie run length in seconds?
PSu Server 2024 & Postgres 15 on macOS 14
PSO 6 on Windows Server 2022

- I'm the user
HaraldE
Posts: 267
Joined: 29 Apr 07 21:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE »

Sweden is ahead of England (of course) so we are GMT+1

I have added datestamp from file properties and length of film below
File 1: Filename says 094012 PSU says 084025 Windows Explorer says 09:40 file properties says 08:40:25 length of film is 0 min and 12 secs
File 2: Filename says 174319 PSU says 164512 Windows Explorer says 17:45 file properties says 16:45:12 length of film is 1 min and 51 secs

Date is all correct for both files.
This confirms what Hert said earlier.
However the hour in filename is correct, I know, I took the film.

When I have some time I will look into the file and try to locate the various timestamps
Username
Posts: 310
Joined: 18 Feb 18 21:21

Re: Extract and show video recording date

Post by Username »

That looks like they parse and present different file time data.

Use exiftool to output all data from the file and then you can see who parses which time value.
PSu Server 2024 & Postgres 15 on macOS 14
PSO 6 on Windows Server 2022

- I'm the user
Hert
Posts: 7940
Joined: 13 Sep 03 6:24

Re: Extract and show video recording date

Post by Hert »

* Filename says 094012
File name doesn't say anything.

* PSU says 084025
That is the MP4 metadata date

* Windows Explorer says 09:40
That is the file date (probably last modified date)

* Windows Explorer file properties says 08:40:25 length of film is 0 min and 12 secs
Properties in Windows Explorer is showing the metadata of a file. 8:40:25 is the MP4 metadata date

Don't confuse video files with photo files. While the Photo industry came up with standards, that is far to be found for video. Every video file format used its own proprietary metadata (if any). MP4 has different data than AVI or MOV or any other video file.
By default the MP4 format only stores technical video info and the recording date and length. Some vendors add extra information to the file in their own proprietary way. Apple, for instance, does that for files from iOS devices.

Exif is a photo metadata standard, not used by the video industry. Don't expect something tags like "date original, date digitized, aperture value, focallength, rotation, etc" for video files.

Below is a screenshot of all the metadata in a Samsung Galaxy S10 file:
Ignore the file details, as that is info from the OS about the file, and not related to the contents of the file itself.
As you can see, the metadata is very poor.
galaxy.png
galaxy.png (148 KiB) Viewed 8823 times


And here is how that info returns in PSU for a Samsung Galaxy file:
galaxy_psu.png
galaxy_psu.png (64.24 KiB) Viewed 8822 times
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
Post Reply