XBMC Community Forum
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Development (/forumdisplay.php?fid=32)
+--- Forum: Python Add-on Development (/forumdisplay.php?fid=26)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=80845)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

- solexalex - 2011-02-06 15:12

fiveisalive Wrote:other camera-related stuff in EXIF like camera model (e.g. "Panasonic Lumix" or "Nikon N60"), whether flash was on or not, would be good.
I was afraid someone ask me this kind of thing someday !! Wink

With mhdebokx, we were on the point to think about what fields are usefull and if it was necessary to feed a database with any EXIF and IPTC as needed. This was how the database was feeding up to now. But maybe if I feed only the database with the meta I want to use, the whole scan process would be faster.

OK I'll do my best to add, if not all the metas, the most metas as possible to filter pictures in the albums.

- solexalex - 2011-02-07 01:47

Hello
I'm on good way to use smart albums !
Right now I coded everything to show pictures of an album which is made of several simple differents filters.
I need to code all the stuff to create/manage the filters, and then add those filters to a given album.

Unfortunately i didn't succeeded in re-use the smartplaylisteditor window which will be just perfect for my use. But I go on coding my way, if later I can use this dialog, I'll do it then.

- mhdebokx - 2011-02-07 04:10

solexalex Wrote:But maybe if I feed only the database with the meta I want to use, the whole scan process would be faster .

i think there 2 reasons for slow performance
1. The MPD does do an Insert in the different tables, and if the record already exists, an exception handler is raided. Tuis consumes extra CPU cycles and also the writing the debug messages

2. The IPTC scripting has slow performance on some jpeg files. My latest investigation is that high end camera's with more than 15mp does take sometimes about 20sec. To process

Scanning not working on Apple TV with windows network share - 2gnospam - 2011-02-19 23:10

Hi. I have a first generation Apple TV with media shared via a SMB network share. The media can be browsed for videos, photos, and audio without problem. However, I can not get My Picture Database to successfully scan the share (returns zero entries). Any ideas of how I might debug this?

- solexalex - 2011-03-23 23:31

Hello
Sorry for no news from all that time, and saddly, no update neither.
I feel tired those couple of weeks and give a (short/long) break to python script.


I don't think you gonna wait too much time for my come back as I really want to make this addon a good one.
Please be patient Smile

IMG_001.jpg - helio58 - 2011-05-30 21:38

Hi I have a lot of pictures as IMG_001.JPG
The addon dont show this pictures it crashes , is there a walk around?
Helio

- Robotica - 2011-10-11 22:44

mhdebokx Wrote:i think there 2 reasons for slow performance
1. The MPD does do an Insert in the different tables, and if the record already exists, an exception handler is raided. Tuis consumes extra CPU cycles and also the writing the debug messages

This could be an Addon Setting: Addon debugger on/off. (off is speed (don't raise the exception handler) and on is debug-logging)

Also I made the Dutch strings.xml more up to date with SVN R180.

A while ago we talked about picture rating & XMP metadata. There was a simple Python library which could handle XMP: http://www.zoia.org/blog/2006/08/13/extracting-xmp-metadata-using-python/ .
Now I found some other usefull tools (written in C++): http://xmpphptoolkit.sourceforge.net/ and Exiv2. Also this other python one: http://code.google.com/p/python-xmp-toolkit/

It would be great if online sources could be integrated. So you can easily up- and download pictures to Facebook, Flickr, Picasso, etc. There are plugins for this but the don't interact with the photo plugins database. A simple "sent to service" from the context menu in combination with settings for login credentials (like i.e. xbmc subtitles by amet works) would do the job. Is the best way to achieve this to ask to Addon authors if those plugins to add such feature?

Also auto mounting USB media/sd cards/camera's so you can easily connect your phone, camera and add your pictures to the database.

And what do you think about those tickets: Allow set up way picture thumbnails are generated and I would love to have a context-menu item to "Also view pictures in subfolder(s)" or start slideshow including subfolders. But the most missed feature is: Everytime your access a folder, XBMC cashes the pictures in there. No precaching and slow browsing are troublesome for users.

This ticket can be closed (i've no trac access). And since I checked most stuff related to pictures, this http://trac.xbmc.org/ticket/10262 ticket is also a reminder.

And some new features/improvements from Eden and on: enables playing of videos within a picture slideshow and Video thumbnails in Picture viewmode and Support automatic scrolling of panoramas in slideshows

Mostly thanks to Aardvark & Gwan & Solexalex picture managing and viewing is getting better and better in XBMC. There are also some discussed features (in this topic) which could improve picture viewing a lot:
1> smart albums. You create simple filters and use these filters to feed the albums with the pictures in your database. For this, bringing up the Smartplaylist with Python works but interacting doesn't yet.

- dgsgc - 2011-10-15 01:15

Is this compatible with pre-eden and where can i get it?

Cheers Big Grin

- tenzion - 2011-11-05 21:13

I've installed this addon on my OpenELEC installation (v1.0.2 - with Dharma v10.1).
The installation is ok, but I can't get it to work. I get a script error - scanpath.py

I have tried several ways to mount my photo folder on my NAS. Both via FTP and also via NFS mount from OpenELEC directly. In both cases I can add the photo folder to My Pictures Database, but whenever I want to scan what's inside, I get the script error.

Does it not run on OpenELEC? Does anyone know what's wrong?

Thanks.

- madcow - 2011-11-12 10:30

I have the same issue. Folder does get added, but scanpath.py fails.

I am also on Openelec 1.0.2 (x32) on the ION platform (Asrock 330 HT). and add folders using smb.