Extract and show video recording date

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

Extract and show video recording date

Post by afatac » 08 Jan 20 4:14

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: 250
Joined: 18 Feb 18 22:21

Re: Extract and show video recording date

Post by Username » 18 Jan 20 21:01

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 5 & Postgres 12 on macOS 10.14
- I'm the user

Hert
Posts: 5987
Joined: 13 Sep 03 7:24

Re: Extract and show video recording date

Post by Hert » 18 Jan 20 21:48

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 which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

HaraldE
Posts: 248
Joined: 29 Apr 07 22:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE » 20 Jan 20 1:01

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: 5987
Joined: 13 Sep 03 7:24

Re: Extract and show video recording date

Post by Hert » 20 Jan 20 9:07

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 which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

HaraldE
Posts: 248
Joined: 29 Apr 07 22:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE » 21 Jan 20 18:35

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: 250
Joined: 18 Feb 18 22:21

Re: Extract and show video recording date

Post by Username » 21 Jan 20 19:15

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 5 & Postgres 12 on macOS 10.14
- I'm the user

HaraldE
Posts: 248
Joined: 29 Apr 07 22:30
Location: Bålsta, Sweden

Re: Extract and show video recording date

Post by HaraldE » 22 Jan 20 13:11

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: 250
Joined: 18 Feb 18 22:21

Re: Extract and show video recording date

Post by Username » 24 Jan 20 7:43

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 5 & Postgres 12 on macOS 10.14
- I'm the user

Hert
Posts: 5987
Joined: 13 Sep 03 7:24

Re: Extract and show video recording date

Post by Hert » 24 Jan 20 9:40

* 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 368 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 367 times
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply