Video metadata and GPS information.

Mon Mar 5 18:33:08 GMT 2018

Gilles,

I could not reproduce an error message with a small test collection. Did the 
error message appear as a dialog or in the console as a debug message? What 
was the error message about?

Maik

Am Montag, 5. März 2018, 12:51:41 CET schrieb Gilles Caulier:
> 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