Video metadata and GPS information.

Mon Mar 5 11:51:41 GMT 2018

Andrey,

Confirmed, my patch fix https://bugs.kde.org/show_bug.cgi?id=375570 too...

But removing and creating new DB from scratch report unwanted errors
(without any side-effects). I think it's relevant only on 6.0.0 and
probably to new similarity DB rules.
Maik, did you try to run digiKam from scratch whithout any DB (but a valid
RC). Typically, i do exactly what's Andrey done in this video :

https://youtu.be/67pcOJj_3RM

I moved all DB files hosted in my main root collection path to a temp
directory, and restart digiKam. It ask my to setup collection as usual, but
it ask me to use current DB file in this path, where all DB file was bee
removed previously. I confirm to create new DB, but finally it said an
error while creating DB files at end of scanning. By change all have been
processed fine: files have been parsed and DB populated...

Can you reproduce on your computer ?

Gilles

2018-03-05 8:20 GMT+01:00 Gilles Caulier <caulier.gilles at gmail.com>:

> Confirmed. The patch follow fix definitively the GPS info problem, and
> certainly more about video info stored in DB. This small patch can also be
> applied to git master.
>
> Gilles
>
> 2018-03-05 7:14 GMT+01:00 Gilles Caulier <caulier.gilles at gmail.com>:
>
>> Hi all,
>>
>> I think i found the problem, and in fact, the video file are not scanned
>> by the same way than image.
>>
>> Look well in ImageScanner::scanFile()
>>
>> https://cgit.kde.org/digikam.git/tree/libs/database/item/ima
>> gescanner.cpp?h=development/6.0.0#n467
>>
>> The condition (item == video) do not backport anything about camera shot
>> information. This include GPS info but not only, as image size.
>>
>> The scanVideoInformation need to be improved, i think :
>>
>> https://cgit.kde.org/digikam.git/tree/libs/database/item/ima
>> gescanner.cpp?h=development/6.0.0#n1480
>>
>> Gilles Caulier
>>
>> 2018-03-04 23:02 GMT+01:00 Gilles Caulier <caulier.gilles at gmail.com>:
>>
>>> I don't yet tested XMP sidecar file, but if GPS info inside video file,
>>> backported properly by ffmpeg parser, is not able to populate the database
>>> with this information, well the problem is more in-deed, somewhere in file
>>> parser or DB interface.
>>>
>>> If i'm right, fixing this problem will fix XMP sidecar too...
>>>
>>> Gilles
>>>
>>> 2018-03-04 21:48 GMT+01:00 Andrey Goreev <aegoreev at gmail.com>:
>>>
>>>> How about this one? Can you reproduce it on files without Geolocation
>>>> embedded (e.g. videos taken on a camera) but with geolocation added to a
>>>> sidecar file ?
>>>>
>>>> https://bugs.kde.org/show_bug.cgi?id=375570
>>>>
>>>> Sent from my Samsung Galaxy smartphone.
>>>>
>>>> -------- Original message --------
>>>> From: Gilles Caulier <caulier.gilles at gmail.com>
>>>> Date: 2018-03-04 11:10 AM (GMT-07:00)
>>>> To: "digiKam developers room - digiKam: Manage your photographs as a
>>>> professional with the power of open source" <digikam-devel at kde.org>
>>>> Subject: Re: Video metadata and GPS information.
>>>>
>>>> Another file probably relevant of this dysfunction :
>>>>
>>>> https://bugs.kde.org/show_bug.cgi?id=373682
>>>>
>>>> Gilles Caulier
>>>>
>>>> 2018-03-04 19:07 GMT+01:00 Gilles Caulier <caulier.gilles at gmail.com>:
>>>>
>>>>> Hi all,
>>>>>
>>>>> I can reproduce this file here with 6.0.0:
>>>>>
>>>>> https://bugs.kde.org/show_bug.cgi?id=377177
>>>>>
>>>>> From my video collection, few items are taken with Iphone and GPS info
>>>>> are present in metadata.
>>>>>
>>>>> Even if the FFMPEG metadata extractor get GPS info and populate Exif
>>>>> with right values, the GPS icon view overlay is off and now GPS position
>>>>> are linked with the video on DB.
>>>>>
>>>>> To reproduce, try to import this file in your collection for ex :
>>>>>
>>>>> https://drive.google.com/open?id=1qn5k2zwIg-jihb6i4LwG1CVdUQ-AChMW
>>>>>
>>>>> This is the result on icon-view :
>>>>>
>>>>> https://www.flickr.com/photos/digikam/26745652098/in/pool-di
>>>>> gikam-labs/
>>>>>
>>>>> The question is why... As you can see, GPS info are properly populated
>>>>> in Exif :
>>>>>
>>>>> [gilles at localhost METADATA]$ ./loadfromfile_exif Apple-Iphone5s.mov
>>>>> digikam.metaengine: Cannot load metadata from file   (Error # 11 :
>>>>>  Apple-Iphone5s.mov : Le fichier contient des données de type inconnu
>>>>> digikam.metaengine: Parse metadada with FFMpeg: "Apple-Iphone5s.mov"
>>>>> digikam.metaengine: -- FFMpeg video stream metadata entries :
>>>>> digikam.metaengine: QMap(("creation_time",
>>>>> "2014-07-05T11:02:04.000000Z")("encoder", "H.264")("handler_name",
>>>>> "Core Media Data Handler")("language", "und")("rotate", "90"))
>>>>> digikam.metaengine: -----------------------------------------
>>>>> digikam.metaengine: Exif.Image.Orientation tag set to:  6
>>>>> digikam.metaengine: -- FFMpeg audio stream metadata entries :
>>>>> digikam.metaengine: QMap(("creation_time",
>>>>> "2014-07-05T11:02:04.000000Z")("handler_name", "Core Media Data
>>>>> Handler")("language", "und"))
>>>>> digikam.metaengine: -----------------------------------------
>>>>> digikam.metaengine: -- FFMpeg root container metadata entries :
>>>>> digikam.metaengine: QMap(("com.apple.quicktime.creationdate",
>>>>> "2014-07-05T13:02:04+0200")("com.apple.quicktime.location.ISO6709",
>>>>> "+43.6521+003.3638+148.202/")("com.apple.quicktime.make",
>>>>> "Apple")("com.apple.qui
>>>>> cktime.model", "iPhone 5s")("com.apple.quicktime.software",
>>>>> "7.1.2")("compatible_brands", "qt  ")("creation_time",
>>>>> "2014-07-05T11:02:04.000000Z")("date", "2014-07-05T13:02:04+0200")("date-fra",
>>>>> "2014-07-05T13:02
>>>>> :04+0200")("encoder", "7.1.2")("encoder-fra", "7.1.2")("location",
>>>>> "+43.6521+003.3638+148.202/")("location-fra",
>>>>> "+43.6521+003.3638+148.202/")("major_brand", "qt  ")("make",
>>>>> "Apple")("make-fra", "Apple")("minor_
>>>>> version", "0")("model", "iPhone 5s")("model-fra", "iPhone 5s"))
>>>>> digikam.metaengine: ------------------------------------------
>>>>> "Exif.GPSInfo.GPSAltitude" :: "148.2 m"
>>>>> "Exif.GPSInfo.GPSAltitudeRef" :: "Au dessus du niveau de la mer"
>>>>> "Exif.GPSInfo.GPSLatitude" :: "43deg 39.12600' "
>>>>> "Exif.GPSInfo.GPSLatitudeRef" :: "Nord"
>>>>> "Exif.GPSInfo.GPSLongitude" :: "3deg 21.82800' "
>>>>> "Exif.GPSInfo.GPSLongitudeRef" :: "Est"
>>>>> "Exif.GPSInfo.GPSMapDatum" :: "WGS-84"
>>>>> "Exif.GPSInfo.GPSVersionID" :: "2.0.0.0"
>>>>> "Exif.Image.DateTime" :: "2014:07:05 11:02:04"
>>>>> "Exif.Image.ImageLength" :: "1080"
>>>>> "Exif.Image.ImageWidth" :: "1920"
>>>>> "Exif.Image.Orientation" :: "droit, haut"
>>>>> "Exif.Photo.DateTimeDigitized" :: "2014:07:05 11:02:04"
>>>>> "Exif.Photo.DateTimeOriginal" :: "2014:07:05 11:02:04"
>>>>> "Exif.Photo.PixelXDimension" :: "1920"
>>>>> "Exif.Photo.PixelYDimension" :: "1080"
>>>>>
>>>>> ... and file scanner must be able to import this info in DB...
>>>>>
>>>>> Gilles
>>>>>
>>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20180305/e8158b64/attachment.html>