Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db

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

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-04-05 19:09

You can install by repo passion in xbmc or with the zip file too
http://passion-xbmc.org/addons/?Page=View&ID=plugin.image.mypicsdb

Is it possible to add property for recently or random pictures in the home, like recently movie or other media?

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mgmartin - 2012-04-06 05:41

Thanks for putting this addon together, it is filling a distinct hole in XBMC's capabilities.

I've noticed that the browse_folder function scanpath.py tends to bomb out at the stat functions if it encounters any files or folders without read permissions.
This is probably OS-specific and partially a user issue...
HOWEVER - In the name of bulletproofing, would it be possible to insert some exception trapping per-file or per-folder ?
I crudely hacked some try/except blocks around the code to enable it to scan my pics, but this might be handled more elegantly by the original authors.

Thanks again !

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-06 19:31

(2012-04-05 18:53)fiveisalive Wrote: Update: I took the liberty of adding the link to: http://www.xycl.de/de/xbmc/addons-und-programme.html to the first column, now the two Xycl repos should show up in the Repositories Installer Add-on.

Thanks.
It works.

(2012-04-05 19:09)fmronan Wrote: Is it possible to add property for recently or random pictures in the home, like recently movie or other media?

You want to go directly into "Uploads from last n days" or "The n latest pictures"?

PHP Code:

ActivateWindow(Pictures,"plugin://plugin.image.mypicsdb/?method='recentpicsdb'&viewmode='view'&action='showpics'",return)
or
ActivateWindow(Pictures,"plugin://plugin.image.mypicsdb/?method='lastpicsshooted'&viewmode='view'&action='showpics'",return) 

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - fmronan - 2012-04-06 19:52

good question Frown

the last added , i suppose

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-06 20:07

See my updated reply.

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-07 16:50

(2012-04-06 05:41)mgmartin Wrote: I've noticed that the browse_folder function scanpath.py tends to bomb out at the stat functions if it encounters any files or folders without read permissions.
This is probably OS-specific and partially a user issue...
HOWEVER - In the name of bulletproofing, would it be possible to insert some exception trapping per-file or per-folder ?
I crudely hacked some try/except blocks around the code to enable it to scan my pics, but this might be handled more elegantly by the original authors.

Thanks again !

Please test it with new version 0.6.6.
File permission errors are now handled when using Windows.

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-04-07 18:40

(2012-04-05 19:09)fmronan Wrote: You can install by repo passion in xbmc or with the zip file too
http://passion-xbmc.org/addons/?Page=View&ID=plugin.image.mypicsdb
Is it possible to add property for recently or random pictures in the home, like recently movie or other media?

Hello Xycl.

Fmronan, Glass skinner, is looking for a special feature of your script.

Your script is able to return "Recently added" and "Random" images but not as Home properties.

Is it possible to you to set Home properties so skinners could populate widgets, as for "Recently added" and " Random" movies, tvshows, albums ?

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Xycl - 2012-04-08 15:33

(2012-04-07 18:40)mikebzh44 Wrote:
(2012-04-05 19:09)fmronan Wrote: You can install by repo passion in xbmc or with the zip file too
http://passion-xbmc.org/addons/?Page=View&ID=plugin.image.mypicsdb
Is it possible to add property for recently or random pictures in the home, like recently movie or other media?
Hello Xycl.

Fmronan, Glass skinner, is looking for a special feature of your script.

Your script is able to return "Recently added" and "Random" images but not as Home properties.

Is it possible to you to set Home properties so skinners could populate widgets, as for "Recently added" and " Random" movies, tvshows, albums ?

Sorry, but what are home properties?
Can you give me an example? Best would be the xml file (and lines) from confluence skin where the recently added videos are shown because I don't know much about skins (only enough to add some home submenus for playlists or sources).
With help of an example it should'nt be to complicated for me to give fmronan the needed pictures.

Update: I can write for him a function like 'RecentlyAdded(n)' which gives back the picture path of the n'th recently added picture.

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mikebzh44 - 2012-04-08 21:45

How I set Home property with RandomAndLastItems script :

WINDOW = xbmcgui.Window( 10000 )
_setProperty( "PictureDB.%d.Path" % ( _count ), path )

So skinners can use PictureDB.1.Path to PictureDB.10.Path for example.

RE: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - mgmartin - 2012-04-09 08:49

Still seems to have issues under Linux.
I have to trap exceptcions in the picentry={...stat...} code to successfully scan the folders.

(2012-04-07 16:50)Xycl Wrote:
(2012-04-06 05:41)mgmartin Wrote: I've noticed that the browse_folder function scanpath.py tends to bomb out at the stat functions if it encounters any files or folders without read permissions.
This is probably OS-specific and partially a user issue...
HOWEVER - In the name of bulletproofing, would it be possible to insert some exception trapping per-file or per-folder ?
I crudely hacked some try/except blocks around the code to enable it to scan my pics, but this might be handled more elegantly by the original authors.

Thanks again !

Please test it with new version 0.6.6.
File permission errors are now handled when using Windows.